Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Twig
• HTTP Client
• Doctrine
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.slug AS slug_3, t0.brand_desctiption AS brand_desctiption_4 FROM brands t0 WHERE t0.slug = ? LIMIT 1

[
  "serge-d-estel"
]

SELECT
  t0.id AS id_1,
  t0.brand_name AS brand_name_2,
  t0.slug AS slug_3,
  t0.brand_desctiption AS brand_desctiption_4
FROM
  brands t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.slug AS slug_3, t0.brand_desctiption AS brand_desctiption_4 FROM brands t0 WHERE t0.slug = 'serge-d-estel' LIMIT 1;

SELECT field_name, content FROM translations
             WHERE entity_type = ? AND entity_id = ? AND locale = ?

[
  "brand"
  16769
  "ru"
]

SELECT
  field_name,
  content
FROM
  translations
WHERE
  entity_type = ?
  AND entity_id = ?
  AND locale = ?

SELECT field_name, content FROM translations
             WHERE entity_type = 'brand' AND entity_id = 16769 AND locale = 'ru';

SELECT COUNT(*) FROM translations
             WHERE entity_type = ? AND entity_id = ? AND locale = ?

[
  "brand"
  16769
  "ru"
]

SELECT
  COUNT(*)
FROM
  translations
WHERE
  entity_type = ?
  AND entity_id = ?
  AND locale = ?

SELECT COUNT(*) FROM translations
             WHERE entity_type = 'brand' AND entity_id = 16769 AND locale = 'ru';

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM products p0_ INNER JOIN brands b1_ ON p0_.brand_id = b1_.id WHERE b1_.id = ?

[
  16769
]

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  products p0_
  INNER JOIN brands b1_ ON p0_.brand_id = b1_.id
WHERE
  b1_.id = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM products p0_ INNER JOIN brands b1_ ON p0_.brand_id = b1_.id WHERE b1_.id = 16769;

SELECT DISTINCT p0_.id AS id_0, p0_.product_name AS product_name_1 FROM products p0_ INNER JOIN brands b1_ ON p0_.brand_id = b1_.id WHERE b1_.id = ? ORDER BY p0_.product_name ASC LIMIT 48

[
  16769
]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.product_name AS product_name_1
FROM
  products p0_
  INNER JOIN brands b1_ ON p0_.brand_id = b1_.id
WHERE
  b1_.id = ?
ORDER BY
  p0_.product_name ASC
LIMIT
  48

SELECT DISTINCT p0_.id AS id_0, p0_.product_name AS product_name_1 FROM products p0_ INNER JOIN brands b1_ ON p0_.brand_id = b1_.id WHERE b1_.id = 16769 ORDER BY p0_.product_name ASC LIMIT 48;

SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.slug AS slug_2, p0_.product_description AS product_description_3, p0_.product_image AS product_image_4, b1_.id AS id_5, b1_.brand_name AS brand_name_6, b1_.slug AS slug_7, b1_.brand_desctiption AS brand_desctiption_8, p0_.brand_id AS brand_id_9 FROM products p0_ INNER JOIN brands b1_ ON p0_.brand_id = b1_.id WHERE b1_.id = ? AND p0_.id IN (?, ?) ORDER BY p0_.product_name ASC

[
  16769
  81334
  81335
]

SELECT
  p0_.id AS id_0,
  p0_.product_name AS product_name_1,
  p0_.slug AS slug_2,
  p0_.product_description AS product_description_3,
  p0_.product_image AS product_image_4,
  b1_.id AS id_5,
  b1_.brand_name AS brand_name_6,
  b1_.slug AS slug_7,
  b1_.brand_desctiption AS brand_desctiption_8,
  p0_.brand_id AS brand_id_9
FROM
  products p0_
  INNER JOIN brands b1_ ON p0_.brand_id = b1_.id
WHERE
  b1_.id = ?
  AND p0_.id IN (?, ?)
ORDER BY
  p0_.product_name ASC

SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.slug AS slug_2, p0_.product_description AS product_description_3, p0_.product_image AS product_image_4, b1_.id AS id_5, b1_.brand_name AS brand_name_6, b1_.slug AS slug_7, b1_.brand_desctiption AS brand_desctiption_8, p0_.brand_id AS brand_id_9 FROM products p0_ INNER JOIN brands b1_ ON p0_.brand_id = b1_.id WHERE b1_.id = 16769 AND p0_.id IN (81334, 81335) ORDER BY p0_.product_name ASC;