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

[
  "glamlite"
]

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 = 'glamlite' LIMIT 1;

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

[
  "brand"
  8305
  "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 = 8305 AND locale = 'ru';

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

[
  "brand"
  8305
  "ru"
]

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

SELECT COUNT(*) FROM translations
             WHERE entity_type = 'brand' AND entity_id = 8305 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 = ?

[
  8305
]

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

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

[
  8305
]

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

[
  8305
  77635
  86110
  51454
  22898
  144295
  42250
  144296
]

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 = 8305 AND p0_.id IN (77635, 86110, 51454, 22898, 144295, 42250, 144296) ORDER BY p0_.product_name ASC;