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

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

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

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

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

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

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 ?
    )
  )
  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 = 6 OR h4_.hotel_id IS NULL)) AND s2_.id IN (4, 19, 20, 21, 37, 15, 16, 38, 32, 31, 30, 25, 24, 23, 22, 17, 18, 39, 43, 35, 41, 47, 27, 36, 49, 48, 50, 44, 26, 61, 74, 83, 82) AND s2_.id NOT IN (24, 23, 82, 17) AND ((p1_.name LIKE '%naldoni%' OR p1_.id = 'naldoni' OR p3_.name = 'naldoni' OR s0_.supplier_code = 'naldoni' OR p1_.manufacturer LIKE 'naldoni')) AND s2_.id = '74';

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