Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 355
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Migrations
• Debug
• Emails
• Notifications
• Themes 1
• GraphQL 1
• Configuration

Query Metrics

SELECT a0_.id AS id_0, p1_.product_id AS product_id_1, p1_.product AS product_2, p1_.pn AS pn_3, p1_.description AS description_4, p1_.detail_description AS detail_description_5, p1_.deleted AS deleted_6, p1_.pic AS pic_7, p1_.warranty AS warranty_8, p1_.cost_min AS cost_min_9, p1_.create_time AS create_time_10, a2_.id AS id_11, a2_.type AS type_12, a2_.name AS name_13, a2_.active AS active_14, a0_.product_id AS product_id_15, a0_.a_product_id AS a_product_id_16, a0_.block AS block_17, p1_.category_id AS category_id_18, a2_.parent_id AS parent_id_19 FROM accessory_result a0_ INNER JOIN Products p1_ ON a0_.a_product_id = p1_.product_id INNER JOIN accessory a2_ ON a0_.block = a2_.id INNER JOIN sf_product_index s3_ ON p1_.product_id = s3_.product_id WHERE a0_.product_id = ? AND a2_.type = ? AND a2_.active = ? AND p1_.deleted = 0 AND s3_.is_show_in_catalog = ? AND s3_.presence >= ? ORDER BY p1_.product ASC LIMIT 10

[
  1007
  "s"
  1
  1
  1
]

SELECT
  a0_.id AS id_0,
  p1_.product_id AS product_id_1,
  p1_.product AS product_2,
  p1_.pn AS pn_3,
  p1_.description AS description_4,
  p1_.detail_description AS detail_description_5,
  p1_.deleted AS deleted_6,
  p1_.pic AS pic_7,
  p1_.warranty AS warranty_8,
  p1_.cost_min AS cost_min_9,
  p1_.create_time AS create_time_10,
  a2_.id AS id_11,
  a2_.type AS type_12,
  a2_.name AS name_13,
  a2_.active AS active_14,
  a0_.product_id AS product_id_15,
  a0_.a_product_id AS a_product_id_16,
  a0_.block AS block_17,
  p1_.category_id AS category_id_18,
  a2_.parent_id AS parent_id_19
FROM
  accessory_result a0_
  INNER JOIN Products p1_ ON a0_.a_product_id = p1_.product_id
  INNER JOIN accessory a2_ ON a0_.block = a2_.id
  INNER JOIN sf_product_index s3_ ON p1_.product_id = s3_.product_id
WHERE
  a0_.product_id = ?
  AND a2_.type = ?
  AND a2_.active = ?
  AND p1_.deleted = 0
  AND s3_.is_show_in_catalog = ?
  AND s3_.presence >= ?
ORDER BY
  p1_.product ASC
LIMIT
  10

SELECT a0_.id AS id_0, p1_.product_id AS product_id_1, p1_.product AS product_2, p1_.pn AS pn_3, p1_.description AS description_4, p1_.detail_description AS detail_description_5, p1_.deleted AS deleted_6, p1_.pic AS pic_7, p1_.warranty AS warranty_8, p1_.cost_min AS cost_min_9, p1_.create_time AS create_time_10, a2_.id AS id_11, a2_.type AS type_12, a2_.name AS name_13, a2_.active AS active_14, a0_.product_id AS product_id_15, a0_.a_product_id AS a_product_id_16, a0_.block AS block_17, p1_.category_id AS category_id_18, a2_.parent_id AS parent_id_19 FROM accessory_result a0_ INNER JOIN Products p1_ ON a0_.a_product_id = p1_.product_id INNER JOIN accessory a2_ ON a0_.block = a2_.id INNER JOIN sf_product_index s3_ ON p1_.product_id = s3_.product_id WHERE a0_.product_id = 1007 AND a2_.type = 's' AND a2_.active = 1 AND p1_.deleted = 0 AND s3_.is_show_in_catalog = 1 AND s3_.presence >= 1 ORDER BY p1_.product ASC LIMIT 10;

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM accessory_result a0_ INNER JOIN Products p1_ ON a0_.a_product_id = p1_.product_id INNER JOIN accessory a2_ ON a0_.block = a2_.id INNER JOIN sf_product_index s3_ ON p1_.product_id = s3_.product_id WHERE a0_.product_id = ? AND a2_.type = ? AND a2_.active = ? AND p1_.deleted = 0 AND s3_.is_show_in_catalog = ? AND s3_.presence >= ? ORDER BY a0_.id ASC

[
  1007
  "s"
  1
  1
  1
]

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  accessory_result a0_
  INNER JOIN Products p1_ ON a0_.a_product_id = p1_.product_id
  INNER JOIN accessory a2_ ON a0_.block = a2_.id
  INNER JOIN sf_product_index s3_ ON p1_.product_id = s3_.product_id
WHERE
  a0_.product_id = ?
  AND a2_.type = ?
  AND a2_.active = ?
  AND p1_.deleted = 0
  AND s3_.is_show_in_catalog = ?
  AND s3_.presence >= ?
ORDER BY
  a0_.id ASC

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM accessory_result a0_ INNER JOIN Products p1_ ON a0_.a_product_id = p1_.product_id INNER JOIN accessory a2_ ON a0_.block = a2_.id INNER JOIN sf_product_index s3_ ON p1_.product_id = s3_.product_id WHERE a0_.product_id = 1007 AND a2_.type = 's' AND a2_.active = 1 AND p1_.deleted = 0 AND s3_.is_show_in_catalog = 1 AND s3_.presence >= 1 ORDER BY a0_.id ASC;