Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.created_at AS created_at_8,
  t0.is_active AS is_active_9,
  t0.sell_limit AS sell_limit_10,
  t0.position AS position_11,
  t0.logo AS logo_12,
  t0.phone AS phone_13,
  t0.is_price_changed AS is_price_changed_14,
  t0.last_price_read_at AS last_price_read_at_15,
  t0.hotel_id AS hotel_id_16,
  t0.hotel_department_id AS hotel_department_id_17
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.is_active AS is_active_9, t0.sell_limit AS sell_limit_10, t0.position AS position_11, t0.logo AS logo_12, t0.phone AS phone_13, t0.is_price_changed AS is_price_changed_14, t0.last_price_read_at AS last_price_read_at_15, t0.hotel_id AS hotel_id_16, t0.hotel_department_id AS hotel_department_id_17 FROM `user` t0 WHERE t0.id = 179;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phone AS phone_3,
  t0.city AS city_4,
  t0.address AS address_5,
  t0.month_limit AS month_limit_6,
  t0.is_active AS is_active_7,
  t0.created_at AS created_at_8,
  t0.postcode AS postcode_9,
  t0.email AS email_10,
  t0.shortcut AS shortcut_11,
  t0.logo AS logo_12,
  t0.www AS www_13,
  t0.nip AS nip_14
FROM
  hotel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.city AS city_4, t0.address AS address_5, t0.month_limit AS month_limit_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.postcode AS postcode_9, t0.email AS email_10, t0.shortcut AS shortcut_11, t0.logo AS logo_12, t0.www AS www_13, t0.nip AS nip_14 FROM hotel t0 WHERE t0.id = 29;

SELECT
  t0.id AS id_1,
  t0.hotel_id AS hotel_id_2,
  t0.supplier_id AS supplier_id_3
FROM
  hotel_has_supplier t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.hotel_id AS hotel_id_2, t0.supplier_id AS supplier_id_3 FROM hotel_has_supplier t0 WHERE t0.hotel_id = 29;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sell_limit AS sell_limit_3,
  t0.hotel_id AS hotel_id_4
FROM
  hotel_department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sell_limit AS sell_limit_3, t0.hotel_id AS hotel_id_4 FROM hotel_department t0 WHERE t0.id = 141;

SELECT
  t0.id AS id_1,
  t0.hotel_has_supplier_id AS hotel_has_supplier_id_2,
  t0.department_id AS department_id_3
FROM
  hotel_supplier_exclude_department t0
WHERE
  t0.department_id = ?

SELECT t0.id AS id_1, t0.hotel_has_supplier_id AS hotel_has_supplier_id_2, t0.department_id AS department_id_3 FROM hotel_supplier_exclude_department t0 WHERE t0.department_id = 141;

SELECT
  t0.id AS id_1,
  t0.hotel_department_id AS hotel_department_id_2,
  t0.product_category_id AS product_category_id_3
FROM
  hotel_department_has_exclude_category t0
WHERE
  t0.hotel_department_id = ?

SELECT t0.id AS id_1, t0.hotel_department_id AS hotel_department_id_2, t0.product_category_id AS product_category_id_3 FROM hotel_department_has_exclude_category t0 WHERE t0.hotel_department_id = 141;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  supplier_has_product s0_
  LEFT JOIN product p1_ ON s0_.product_id = p1_.id
  LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id
  LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id
  LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id
WHERE
  (
    p1_.is_active IN (?, ?)
    AND s2_.is_active = ?
    AND s0_.is_active = ?
    AND s0_.price > 0
  )
  AND (
    (
      h4_.hotel_id = ?
      OR h4_.hotel_id IS NULL
    )
  )
  AND s2_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND s2_.id NOT IN (?, ?)
  AND (
    (
      p1_.name LIKE ?
      OR p1_.id = ?
      OR p3_.name = ?
      OR s0_.supplier_code = ?
      OR p1_.manufacturer LIKE ?
    )
  )

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM supplier_has_product s0_ LEFT JOIN product p1_ ON s0_.product_id = p1_.id LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id WHERE (p1_.is_active IN (1, 2) AND s2_.is_active = 1 AND s0_.is_active = 1 AND s0_.price > 0) AND ((h4_.hotel_id = 29 OR h4_.hotel_id IS NULL)) AND s2_.id IN (15, 37, 32, 31, 30, 29, 27, 25, 24, 23, 22, 17, 18, 16, 39, 43, 35, 41, 47, 36, 49, 48, 50, 26, 34, 19, 80, 82) AND s2_.id NOT IN (17, 82) AND ((p1_.name LIKE '%beefe%' OR p1_.id = 'beefe' OR p3_.name = 'beefe' OR s0_.supplier_code = 'beefe' OR p1_.manufacturer LIKE 'beefe'));

SELECT
  DISTINCT s0_.id AS id_0,
  p1_.name AS name_1
FROM
  supplier_has_product s0_
  LEFT JOIN product p1_ ON s0_.product_id = p1_.id
  LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id
  LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id
  LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id
WHERE
  (
    p1_.is_active IN (?, ?)
    AND s2_.is_active = ?
    AND s0_.is_active = ?
    AND s0_.price > 0
  )
  AND (
    (
      h4_.hotel_id = ?
      OR h4_.hotel_id IS NULL
    )
  )
  AND s2_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND s2_.id NOT IN (?, ?)
  AND (
    (
      p1_.name LIKE ?
      OR p1_.id = ?
      OR p3_.name = ?
      OR s0_.supplier_code = ?
      OR p1_.manufacturer LIKE ?
    )
  )
ORDER BY
  p1_.name ASC
LIMIT
  50

SELECT DISTINCT s0_.id AS id_0, p1_.name AS name_1 FROM supplier_has_product s0_ LEFT JOIN product p1_ ON s0_.product_id = p1_.id LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id WHERE (p1_.is_active IN (1, 2) AND s2_.is_active = 1 AND s0_.is_active = 1 AND s0_.price > 0) AND ((h4_.hotel_id = 29 OR h4_.hotel_id IS NULL)) AND s2_.id IN (15, 37, 32, 31, 30, 29, 27, 25, 24, 23, 22, 17, 18, 16, 39, 43, 35, 41, 47, 36, 49, 48, 50, 26, 34, 19, 80, 82) AND s2_.id NOT IN (17, 82) AND ((p1_.name LIKE '%beefe%' OR p1_.id = 'beefe' OR p3_.name = 'beefe' OR s0_.supplier_code = 'beefe' OR p1_.manufacturer LIKE 'beefe')) ORDER BY p1_.name ASC LIMIT 50;

SELECT
  s0_.id AS id_0,
  s0_.price AS price_1,
  s0_.supplier_code AS supplier_code_2,
  s0_.image AS image_3,
  s0_.last_price AS last_price_4,
  s0_.price_changed_at AS price_changed_at_5,
  s0_.price_last_at AS price_last_at_6,
  s0_.is_active AS is_active_7,
  s0_.extra_data AS extra_data_8,
  s0_.last_is_active AS last_is_active_9,
  s0_.supplier_id AS supplier_id_10,
  s0_.product_id AS product_id_11
FROM
  supplier_has_product s0_
  LEFT JOIN product p1_ ON s0_.product_id = p1_.id
  LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id
  LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id
  LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id
WHERE
  (
    p1_.is_active IN (?, ?)
    AND s2_.is_active = ?
    AND s0_.is_active = ?
    AND s0_.price > 0
  )
  AND (
    (
      h4_.hotel_id = ?
      OR h4_.hotel_id IS NULL
    )
  )
  AND s2_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND s2_.id NOT IN (?, ?)
  AND (
    (
      p1_.name LIKE ?
      OR p1_.id = ?
      OR p3_.name = ?
      OR s0_.supplier_code = ?
      OR p1_.manufacturer LIKE ?
    )
  )
  AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p1_.name ASC

SELECT s0_.id AS id_0, s0_.price AS price_1, s0_.supplier_code AS supplier_code_2, s0_.image AS image_3, s0_.last_price AS last_price_4, s0_.price_changed_at AS price_changed_at_5, s0_.price_last_at AS price_last_at_6, s0_.is_active AS is_active_7, s0_.extra_data AS extra_data_8, s0_.last_is_active AS last_is_active_9, s0_.supplier_id AS supplier_id_10, s0_.product_id AS product_id_11 FROM supplier_has_product s0_ LEFT JOIN product p1_ ON s0_.product_id = p1_.id LEFT JOIN supplier s2_ ON s0_.supplier_id = s2_.id LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id LEFT JOIN hotel_exclude_product h4_ ON p1_.id = h4_.product_id WHERE (p1_.is_active IN (1, 2) AND s2_.is_active = 1 AND s0_.is_active = 1 AND s0_.price > 0) AND ((h4_.hotel_id = 29 OR h4_.hotel_id IS NULL)) AND s2_.id IN (15, 37, 32, 31, 30, 29, 27, 25, 24, 23, 22, 17, 18, 16, 39, 43, 35, 41, 47, 36, 49, 48, 50, 26, 34, 19, 80, 82) AND s2_.id NOT IN (17, 82) AND ((p1_.name LIKE '%beefe%' OR p1_.id = 'beefe' OR p3_.name = 'beefe' OR s0_.supplier_code = 'beefe' OR p1_.manufacturer LIKE 'beefe')) AND s0_.id IN (1219, 21049, 1220, 21132, 17955, 19574, 77344, 20999, 17956, 19573, 119507, 19575, 125534, 37408) ORDER BY p1_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.photo AS photo_3,
  t0.is_active AS is_active_4,
  t0.max_limit AS max_limit_5,
  t0.unit AS unit_6,
  t0.ean AS ean_7,
  t0.pieces AS pieces_8,
  t0.dimension AS dimension_9,
  t0.manufacturer AS manufacturer_10,
  t0.category_id AS category_id_11
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.is_active AS is_active_4, t0.max_limit AS max_limit_5, t0.unit AS unit_6, t0.ean AS ean_7, t0.pieces AS pieces_8, t0.dimension AS dimension_9, t0.manufacturer AS manufacturer_10, t0.category_id AS category_id_11 FROM product t0 WHERE t0.id = 4372;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.created_at AS created_at_8,
  t0.is_active AS is_active_9,
  t0.sell_limit AS sell_limit_10,
  t0.position AS position_11,
  t0.logo AS logo_12,
  t0.phone AS phone_13,
  t0.is_price_changed AS is_price_changed_14,
  t0.last_price_read_at AS last_price_read_at_15,
  t0.hotel_id AS hotel_id_16,
  t0.hotel_department_id AS hotel_department_id_17
FROM
  `user` t0
  INNER JOIN user_product ON t0.id = user_product.user_id
WHERE
  user_product.product_id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.is_active AS is_active_9, t0.sell_limit AS sell_limit_10, t0.position AS position_11, t0.logo AS logo_12, t0.phone AS phone_13, t0.is_price_changed AS is_price_changed_14, t0.last_price_read_at AS last_price_read_at_15, t0.hotel_id AS hotel_id_16, t0.hotel_department_id AS hotel_department_id_17 FROM `user` t0 INNER JOIN user_product ON t0.id = user_product.user_id WHERE user_product.product_id = 4372;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.city AS city_3,
  t0.address AS address_4,
  t0.phone AS phone_5,
  t0.email AS email_6,
  t0.is_active AS is_active_7,
  t0.crated_at AS crated_at_8,
  t0.postcode AS postcode_9,
  t0.email_txt AS email_txt_10,
  t0.order_confirm_type AS order_confirm_type_11,
  t0.col_name AS col_name_12,
  t0.col_number AS col_number_13,
  t0.col_price AS col_price_14,
  t0.min_price AS min_price_15,
  t0.col_ean AS col_ean_16,
  t0.col_image AS col_image_17,
  t0.col_pieces AS col_pieces_18,
  t0.col_weight AS col_weight_19,
  t0.nip AS nip_20,
  t0.contact_name AS contact_name_21,
  t0.contact_surname AS contact_surname_22,
  t0.shortcut AS shortcut_23,
  t0.payment_term AS payment_term_24,
  t0.col_manufacture AS col_manufacture_25,
  t0.email_type AS email_type_26
FROM
  supplier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = 22;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  product_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM product_category t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.city AS city_3,
  t0.address AS address_4,
  t0.phone AS phone_5,
  t0.email AS email_6,
  t0.is_active AS is_active_7,
  t0.crated_at AS crated_at_8,
  t0.postcode AS postcode_9,
  t0.email_txt AS email_txt_10,
  t0.order_confirm_type AS order_confirm_type_11,
  t0.col_name AS col_name_12,
  t0.col_number AS col_number_13,
  t0.col_price AS col_price_14,
  t0.min_price AS min_price_15,
  t0.col_ean AS col_ean_16,
  t0.col_image AS col_image_17,
  t0.col_pieces AS col_pieces_18,
  t0.col_weight AS col_weight_19,
  t0.nip AS nip_20,
  t0.contact_name AS contact_name_21,
  t0.contact_surname AS contact_surname_22,
  t0.shortcut AS shortcut_23,
  t0.payment_term AS payment_term_24,
  t0.col_manufacture AS col_manufacture_25,
  t0.email_type AS email_type_26
FROM
  supplier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.crated_at AS crated_at_8, t0.postcode AS postcode_9, t0.email_txt AS email_txt_10, t0.order_confirm_type AS order_confirm_type_11, t0.col_name AS col_name_12, t0.col_number AS col_number_13, t0.col_price AS col_price_14, t0.min_price AS min_price_15, t0.col_ean AS col_ean_16, t0.col_image AS col_image_17, t0.col_pieces AS col_pieces_18, t0.col_weight AS col_weight_19, t0.nip AS nip_20, t0.contact_name AS contact_name_21, t0.contact_surname AS contact_surname_22, t0.shortcut AS shortcut_23, t0.payment_term AS payment_term_24, t0.col_manufacture AS col_manufacture_25, t0.email_type AS email_type_26 FROM supplier t0 WHERE t0.id = 26;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.photo AS photo_3,
  t0.is_active AS is_active_4,
  t0.max_limit AS max_limit_5,
  t0.unit AS unit_6,
  t0.ean AS ean_7,
  t0.pieces AS pieces_8,
  t0.dimension AS dimension_9,
  t0.manufacturer AS manufacturer_10,
  t0.category_id AS category_id_11
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.is_active AS is_active_4, t0.max_limit AS max_limit_5, t0.unit AS unit_6, t0.ean AS ean_7, t0.pieces AS pieces_8, t0.dimension AS dimension_9, t0.manufacturer AS manufacturer_10, t0.category_id AS category_id_11 FROM product t0 WHERE t0.id = 4373;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.created_at AS created_at_8,
  t0.is_active AS is_active_9,
  t0.sell_limit AS sell_limit_10,
  t0.position AS position_11,
  t0.logo AS logo_12,
  t0.phone AS phone_13,
  t0.is_price_changed AS is_price_changed_14,
  t0.last_price_read_at AS last_price_read_at_15,
  t0.hotel_id AS hotel_id_16,
  t0.hotel_department_id AS hotel_department_id_17
FROM
  `user` t0
  INNER JOIN user_product ON t0.id = user_product.user_id
WHERE
  user_product.product_id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.is_active AS is_active_9, t0.sell_limit AS sell_limit_10, t0.position AS position_11, t0.logo AS logo_12, t0.phone AS phone_13, t0.is_price_changed AS is_price_changed_14, t0.last_price_read_at AS last_price_read_at_15, t0.hotel_id AS hotel_id_16, t0.hotel_department_id AS hotel_department_id_17 FROM `user` t0 INNER JOIN user_product ON t0.id = user_product.user_id WHERE user_product.product_id = 4373;