Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1608
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• JMS Serializer 0 + 0
• Configuration

Query Metrics

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.code AS code_2, d0_.slug AS slug_3, COUNT(DISTINCT c1_.id) AS sclr_4 FROM cabinet c1_ INNER JOIN address a2_ ON c1_.address_id = a2_.id INNER JOIN department d0_ ON a2_.department_id = d0_.id WHERE c1_.is_published_on_broker_directory = ? GROUP BY d0_.id, d0_.name, d0_.code, d0_.slug HAVING COUNT(DISTINCT c1_.id) > 0 ORDER BY sclr_4 DESC, d0_.name ASC LIMIT 12

[
  1
]

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.code AS code_2,
  d0_.slug AS slug_3,
  COUNT(DISTINCT c1_.id) AS sclr_4
FROM
  cabinet c1_
  INNER JOIN address a2_ ON c1_.address_id = a2_.id
  INNER JOIN department d0_ ON a2_.department_id = d0_.id
WHERE
  c1_.is_published_on_broker_directory = ?
GROUP BY
  d0_.id,
  d0_.name,
  d0_.code,
  d0_.slug
HAVING
  COUNT(DISTINCT c1_.id) > 0
ORDER BY
  sclr_4 DESC,
  d0_.name ASC
LIMIT
  12

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.code AS code_2, d0_.slug AS slug_3, COUNT(DISTINCT c1_.id) AS sclr_4 FROM cabinet c1_ INNER JOIN address a2_ ON c1_.address_id = a2_.id INNER JOIN department d0_ ON a2_.department_id = d0_.id WHERE c1_.is_published_on_broker_directory = 1 GROUP BY d0_.id, d0_.name, d0_.code, d0_.slug HAVING COUNT(DISTINCT c1_.id) > 0 ORDER BY sclr_4 DESC, d0_.name ASC LIMIT 12;

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, COUNT(DISTINCT c1_.id) AS sclr_3 FROM cabinet c1_ INNER JOIN cabinet_product c2_ ON c1_.id = c2_.cabinet_id INNER JOIN product p0_ ON p0_.id = c2_.product_id WHERE c1_.is_published_on_broker_directory = ? GROUP BY p0_.id, p0_.name, p0_.slug HAVING COUNT(DISTINCT c1_.id) > 0 ORDER BY sclr_3 DESC, p0_.name ASC

[
  1
]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  COUNT(DISTINCT c1_.id) AS sclr_3
FROM
  cabinet c1_
  INNER JOIN cabinet_product c2_ ON c1_.id = c2_.cabinet_id
  INNER JOIN product p0_ ON p0_.id = c2_.product_id
WHERE
  c1_.is_published_on_broker_directory = ?
GROUP BY
  p0_.id,
  p0_.name,
  p0_.slug
HAVING
  COUNT(DISTINCT c1_.id) > 0
ORDER BY
  sclr_3 DESC,
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, COUNT(DISTINCT c1_.id) AS sclr_3 FROM cabinet c1_ INNER JOIN cabinet_product c2_ ON c1_.id = c2_.cabinet_id INNER JOIN product p0_ ON p0_.id = c2_.product_id WHERE c1_.is_published_on_broker_directory = 1 GROUP BY p0_.id, p0_.name, p0_.slug HAVING COUNT(DISTINCT c1_.id) > 0 ORDER BY sclr_3 DESC, p0_.name ASC;