Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.parent_id IS NULL AND t0.active = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.parent_id AS parent_id_4
FROM
  category t0
WHERE
  t0.parent_id IS NULL
  AND t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.parent_id IS NULL AND t0.active = 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.parent_id = ? AND t0.active = ?

[
  1
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.parent_id AS parent_id_4
FROM
  category t0
WHERE
  t0.parent_id = ?
  AND t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.parent_id = 1 AND t0.active = 1;

SELECT s0_.id AS id_0, s1_.id AS id_1, s1_.name AS name_2, s1_.active AS active_3, s0_.specification_id AS specification_id_4, s0_.category_id AS category_id_5 FROM specification_category s0_ INNER JOIN specification s1_ ON s0_.specification_id = s1_.id WHERE s0_.category_id = ? ORDER BY s1_.name ASC

[
  1
]

SELECT
  s0_.id AS id_0,
  s1_.id AS id_1,
  s1_.name AS name_2,
  s1_.active AS active_3,
  s0_.specification_id AS specification_id_4,
  s0_.category_id AS category_id_5
FROM
  specification_category s0_
  INNER JOIN specification s1_ ON s0_.specification_id = s1_.id
WHERE
  s0_.category_id = ?
ORDER BY
  s1_.name ASC

SELECT s0_.id AS id_0, s1_.id AS id_1, s1_.name AS name_2, s1_.active AS active_3, s0_.specification_id AS specification_id_4, s0_.category_id AS category_id_5 FROM specification_category s0_ INNER JOIN specification s1_ ON s0_.specification_id = s1_.id WHERE s0_.category_id = 1 ORDER BY s1_.name ASC;

SELECT MIN(p0_.length) AS sclr_0, MAX(p0_.length) AS sclr_1 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (?) AND p0_.active = 1 AND p0_.length IS NOT NULL

[
  1
]

SELECT
  MIN(p0_.length) AS sclr_0,
  MAX(p0_.length) AS sclr_1
FROM
  products p0_
  INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id)
WHERE
  c1_.category_id IN (?)
  AND p0_.active = 1
  AND p0_.length IS NOT NULL

SELECT MIN(p0_.length) AS sclr_0, MAX(p0_.length) AS sclr_1 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (1) AND p0_.active = 1 AND p0_.length IS NOT NULL;

SELECT MIN(p0_.width) AS sclr_0, MAX(p0_.width) AS sclr_1 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (?) AND p0_.active = 1 AND p0_.width IS NOT NULL

[
  1
]

SELECT
  MIN(p0_.width) AS sclr_0,
  MAX(p0_.width) AS sclr_1
FROM
  products p0_
  INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id)
WHERE
  c1_.category_id IN (?)
  AND p0_.active = 1
  AND p0_.width IS NOT NULL

SELECT MIN(p0_.width) AS sclr_0, MAX(p0_.width) AS sclr_1 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (1) AND p0_.active = 1 AND p0_.width IS NOT NULL;

SELECT MIN(p0_.depth) AS sclr_0, MAX(p0_.depth) AS sclr_1 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (?) AND p0_.active = 1 AND p0_.depth IS NOT NULL

[
  1
]

SELECT
  MIN(p0_.depth) AS sclr_0,
  MAX(p0_.depth) AS sclr_1
FROM
  products p0_
  INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id)
WHERE
  c1_.category_id IN (?)
  AND p0_.active = 1
  AND p0_.depth IS NOT NULL

SELECT MIN(p0_.depth) AS sclr_0, MAX(p0_.depth) AS sclr_1 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (1) AND p0_.active = 1 AND p0_.depth IS NOT NULL;

SELECT MIN(p0_.weight) AS sclr_0, MAX(p0_.weight) AS sclr_1 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (?) AND p0_.active = 1 AND p0_.weight IS NOT NULL

[
  1
]

SELECT
  MIN(p0_.weight) AS sclr_0,
  MAX(p0_.weight) AS sclr_1
FROM
  products p0_
  INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id)
WHERE
  c1_.category_id IN (?)
  AND p0_.active = 1
  AND p0_.weight IS NOT NULL

SELECT MIN(p0_.weight) AS sclr_0, MAX(p0_.weight) AS sclr_1 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (1) AND p0_.active = 1 AND p0_.weight IS NOT NULL;

SELECT MIN(p0_.gross_price) AS sclr_0, MAX(p0_.gross_price) AS sclr_1 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (?) AND p0_.active = 1 AND p0_.gross_price IS NOT NULL

[
  1
]

SELECT
  MIN(p0_.gross_price) AS sclr_0,
  MAX(p0_.gross_price) AS sclr_1
FROM
  products p0_
  INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id)
WHERE
  c1_.category_id IN (?)
  AND p0_.active = 1
  AND p0_.gross_price IS NOT NULL

SELECT MIN(p0_.gross_price) AS sclr_0, MAX(p0_.gross_price) AS sclr_1 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (1) AND p0_.active = 1 AND p0_.gross_price IS NOT NULL;

SELECT MIN(p0_.net_price) AS sclr_0, MAX(p0_.net_price) AS sclr_1 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (?) AND p0_.active = 1 AND p0_.net_price IS NOT NULL

[
  1
]

SELECT
  MIN(p0_.net_price) AS sclr_0,
  MAX(p0_.net_price) AS sclr_1
FROM
  products p0_
  INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id)
WHERE
  c1_.category_id IN (?)
  AND p0_.active = 1
  AND p0_.net_price IS NOT NULL

SELECT MIN(p0_.net_price) AS sclr_0, MAX(p0_.net_price) AS sclr_1 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (1) AND p0_.active = 1 AND p0_.net_price IS NOT NULL;

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (?) AND p0_.active = 1

[
  1
]

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  products p0_
  INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id)
WHERE
  c1_.category_id IN (?)
  AND p0_.active = 1

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM products p0_ INNER JOIN category_products c1_ ON (c1_.product_id = p0_.id) WHERE c1_.category_id IN (1) AND p0_.active = 1;

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.index_code AS index_code_2, p0_.length AS length_3, p0_.width AS width_4, p0_.depth AS depth_5, p0_.weight AS weight_6, p0_.gross_price AS gross_price_7, p0_.net_price AS net_price_8, p0_.stock_status AS stock_status_9, p0_.active AS active_10, p1_.id AS id_11, p1_.name AS name_12, p1_.active AS active_13, p2_.id AS id_14, p2_.photo AS photo_15, p2_.position AS position_16, p0_.producer_id AS producer_id_17, p2_.product_id AS product_id_18 FROM products p0_ INNER JOIN category_products c3_ ON (c3_.product_id = p0_.id) LEFT JOIN producers p1_ ON p0_.producer_id = p1_.id LEFT JOIN products_photos p2_ ON p0_.id = p2_.product_id WHERE c3_.category_id IN (?) AND p0_.active = 1 ORDER BY p0_.id DESC, p0_.name ASC LIMIT 12

[
  1
]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.index_code AS index_code_2,
  p0_.length AS length_3,
  p0_.width AS width_4,
  p0_.depth AS depth_5,
  p0_.weight AS weight_6,
  p0_.gross_price AS gross_price_7,
  p0_.net_price AS net_price_8,
  p0_.stock_status AS stock_status_9,
  p0_.active AS active_10,
  p1_.id AS id_11,
  p1_.name AS name_12,
  p1_.active AS active_13,
  p2_.id AS id_14,
  p2_.photo AS photo_15,
  p2_.position AS position_16,
  p0_.producer_id AS producer_id_17,
  p2_.product_id AS product_id_18
FROM
  products p0_
  INNER JOIN category_products c3_ ON (c3_.product_id = p0_.id)
  LEFT JOIN producers p1_ ON p0_.producer_id = p1_.id
  LEFT JOIN products_photos p2_ ON p0_.id = p2_.product_id
WHERE
  c3_.category_id IN (?)
  AND p0_.active = 1
ORDER BY
  p0_.id DESC,
  p0_.name ASC
LIMIT
  12

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.index_code AS index_code_2, p0_.length AS length_3, p0_.width AS width_4, p0_.depth AS depth_5, p0_.weight AS weight_6, p0_.gross_price AS gross_price_7, p0_.net_price AS net_price_8, p0_.stock_status AS stock_status_9, p0_.active AS active_10, p1_.id AS id_11, p1_.name AS name_12, p1_.active AS active_13, p2_.id AS id_14, p2_.photo AS photo_15, p2_.position AS position_16, p0_.producer_id AS producer_id_17, p2_.product_id AS product_id_18 FROM products p0_ INNER JOIN category_products c3_ ON (c3_.product_id = p0_.id) LEFT JOIN producers p1_ ON p0_.producer_id = p1_.id LEFT JOIN products_photos p2_ ON p0_.id = p2_.product_id WHERE c3_.category_id IN (1) AND p0_.active = 1 ORDER BY p0_.id DESC, p0_.name ASC LIMIT 12;

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.parent_id = ? AND t0.active = ? ORDER BY t0.name ASC

[
  1
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.parent_id AS parent_id_4
FROM
  category t0
WHERE
  t0.parent_id = ?
  AND t0.active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.parent_id = 1 AND t0.active = 1 ORDER BY t0.name ASC;