Symfony Profiler

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 (
    (
      p1_.name LIKE ?
      OR p1_.id = ?
      OR p3_.name = ?
      OR s0_.supplier_code = ?
      OR p1_.manufacturer LIKE ?
    )
  )
  AND (
    (
      p1_.name LIKE ?
      OR p1_.id = ?
      OR p3_.name = ?
      OR s0_.supplier_code = ?
      OR p1_.manufacturer LIKE ?
    )
  )
  AND s2_.id = ?
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 = 22 OR h4_.hotel_id IS NULL)) AND s2_.id IN (2, 14, 19, 20, 21, 15, 17, 18, 24, 25, 23, 22, 16, 27, 32, 31, 30, 37, 38, 39, 35, 43, 41, 47, 34, 36, 49, 48, 51, 54, 50, 26, 63, 83, 82) AND ((p1_.name LIKE '%wino%' OR p1_.id = 'wino' OR p3_.name = 'bia' OR s0_.supplier_code = 'bia' OR p1_.manufacturer LIKE 'bia')) AND ((p1_.name LIKE '%bia%' OR p1_.id = 'bia' OR p3_.name = 'bia' OR s0_.supplier_code = 'bia' OR p1_.manufacturer LIKE 'bia')) AND s2_.id = '14' ORDER BY p1_.name ASC LIMIT 50;

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 (
    (
      p1_.name LIKE ?
      OR p1_.id = ?
      OR p3_.name = ?
      OR s0_.supplier_code = ?
      OR p1_.manufacturer LIKE ?
    )
  )
  AND (
    (
      p1_.name LIKE ?
      OR p1_.id = ?
      OR p3_.name = ?
      OR s0_.supplier_code = ?
      OR p1_.manufacturer LIKE ?
    )
  )
  AND s2_.id = ?

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 = 22 OR h4_.hotel_id IS NULL)) AND s2_.id IN (2, 14, 19, 20, 21, 15, 17, 18, 24, 25, 23, 22, 16, 27, 32, 31, 30, 37, 38, 39, 35, 43, 41, 47, 34, 36, 49, 48, 51, 54, 50, 26, 63, 83, 82) AND ((p1_.name LIKE '%wino%' OR p1_.id = 'wino' OR p3_.name = 'bia' OR s0_.supplier_code = 'bia' OR p1_.manufacturer LIKE 'bia')) AND ((p1_.name LIKE '%bia%' OR p1_.id = 'bia' OR p3_.name = 'bia' OR s0_.supplier_code = 'bia' OR p1_.manufacturer LIKE 'bia')) AND s2_.id = '14';

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 = 44379;

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 = 44379;

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 (
    (
      p1_.name LIKE ?
      OR p1_.id = ?
      OR p3_.name = ?
      OR s0_.supplier_code = ?
      OR p1_.manufacturer LIKE ?
    )
  )
  AND (
    (
      p1_.name LIKE ?
      OR p1_.id = ?
      OR p3_.name = ?
      OR s0_.supplier_code = ?
      OR p1_.manufacturer LIKE ?
    )
  )
  AND s2_.id = ?
  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 = 22 OR h4_.hotel_id IS NULL)) AND s2_.id IN (2, 14, 19, 20, 21, 15, 17, 18, 24, 25, 23, 22, 16, 27, 32, 31, 30, 37, 38, 39, 35, 43, 41, 47, 34, 36, 49, 48, 51, 54, 50, 26, 63, 83, 82) AND ((p1_.name LIKE '%wino%' OR p1_.id = 'wino' OR p3_.name = 'bia' OR s0_.supplier_code = 'bia' OR p1_.manufacturer LIKE 'bia')) AND ((p1_.name LIKE '%bia%' OR p1_.id = 'bia' OR p3_.name = 'bia' OR s0_.supplier_code = 'bia' OR p1_.manufacturer LIKE 'bia')) AND s2_.id = '14' AND s0_.id IN (42477, 39056, 45858, 42293, 46472, 453, 529, 45966, 39667, 44951, 44274, 39318, 45236, 45237, 39654, 40269, 40268, 45905, 28919, 46283, 45541, 41777, 46174, 39521, 39517, 39516, 39515, 44780, 42783, 39723, 44725, 44545, 44708, 43220, 44730, 44747, 42354, 45756, 47178, 40134, 44936, 46917, 42819, 42785, 42784, 47134, 47513, 40802, 38869, 44769) ORDER BY p1_.name ASC;

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 = 46;

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 = 21;

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 = 22;

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 = 22;

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 = 84;

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 = 14;

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 = 84;

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 = 84;