Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 28
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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 = ?

[
  119
]

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

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 = ?

[
  95
]

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

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 = ?

[
  95
]

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

SELECT p0_.id AS id_0, p0_.name AS name_1 FROM product_category p0_ LEFT JOIN product p1_ ON p0_.id = p1_.category_id LEFT JOIN supplier_has_product s2_ ON p1_.id = s2_.product_id WHERE (s2_.supplier_id = ? AND s2_.is_active = ? AND p1_.is_active = ?) AND ((p1_.name LIKE ? OR p1_.id = ? OR s2_.supplier_code = ? OR p1_.manufacturer LIKE ?)) GROUP BY p0_.id ORDER BY p0_.name ASC

[
  "74"
  1
  1
  "%SZPONDER%"
  "SZPONDER"
  "SZPONDER"
  "SZPONDER"
]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1
FROM
  product_category p0_
  LEFT JOIN product p1_ ON p0_.id = p1_.category_id
  LEFT JOIN supplier_has_product s2_ ON p1_.id = s2_.product_id
WHERE
  (
    s2_.supplier_id = ?
    AND s2_.is_active = ?
    AND p1_.is_active = ?
  )
  AND (
    (
      p1_.name LIKE ?
      OR p1_.id = ?
      OR s2_.supplier_code = ?
      OR p1_.manufacturer LIKE ?
    )
  )
GROUP BY
  p0_.id
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1 FROM product_category p0_ LEFT JOIN product p1_ ON p0_.id = p1_.category_id LEFT JOIN supplier_has_product s2_ ON p1_.id = s2_.product_id WHERE (s2_.supplier_id = '74' AND s2_.is_active = 1 AND p1_.is_active = 1) AND ((p1_.name LIKE '%SZPONDER%' OR p1_.id = 'SZPONDER' OR s2_.supplier_code = 'SZPONDER' OR p1_.manufacturer LIKE 'SZPONDER')) GROUP BY p0_.id ORDER BY p0_.name ASC;