Symfony Profiler

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

Query Metrics

SELECT COUNT(c0_.id) AS sclr_0 FROM cabinet c0_ WHERE c0_.is_published_on_broker_directory = ?

[
  1
]

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  cabinet c0_
WHERE
  c0_.is_published_on_broker_directory = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM cabinet c0_ WHERE c0_.is_published_on_broker_directory = 1;

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 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
]

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
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 = ?

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 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;

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;

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_.description AS description_2, p0_.footer_seo_description AS footer_seo_description_3, p0_.slug AS slug_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6 FROM product p0_ ORDER BY p0_.name ASC

[]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.footer_seo_description AS footer_seo_description_3,
  p0_.slug AS slug_4,
  p0_.created_at AS created_at_5,
  p0_.updated_at AS updated_at_6
FROM
  product p0_
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.footer_seo_description AS footer_seo_description_3, p0_.slug AS slug_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6 FROM product p0_ ORDER BY p0_.name ASC;

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.code AS code_2, d0_.slug AS slug_3, d0_.seo_description AS seo_description_4 FROM department d0_ ORDER BY d0_.code ASC

[]

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.code AS code_2,
  d0_.slug AS slug_3,
  d0_.seo_description AS seo_description_4
FROM
  department d0_
ORDER BY
  d0_.code ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.code AS code_2, d0_.slug AS slug_3, d0_.seo_description AS seo_description_4 FROM department d0_ ORDER BY d0_.code ASC;