Symfony Profiler

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

Query Metrics

Grouped Statements

Show all queries

SELECT t0.id AS id_1, t0.name AS name_2, t0.category_order AS category_order_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM categories t0 ORDER BY t0.category_order ASC

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.category_order AS category_order_3,
  t0.slug AS slug_4,
  t0.parent_id AS parent_id_5
FROM
  categories t0
ORDER BY
  t0.category_order ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.category_order AS category_order_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM categories t0 ORDER BY t0.category_order ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.products_id AS products_id_3 FROM images t0 WHERE t0.products_id = ?

[
  5
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.products_id AS products_id_3
FROM
  images t0
WHERE
  t0.products_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.products_id AS products_id_3 FROM images t0 WHERE t0.products_id = 5;

SELECT t0.id AS id_1, t0.name AS name_2, t0.category_order AS category_order_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM categories t0 WHERE t0.slug = ? LIMIT 1

[
  "homme"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.category_order AS category_order_3,
  t0.slug AS slug_4,
  t0.parent_id AS parent_id_5
FROM
  categories t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.category_order AS category_order_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM categories t0 WHERE t0.slug = 'homme' LIMIT 1;

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.stock AS stock_4, p0_.created_at AS created_at_5, p0_.slug AS slug_6, c1_.id AS id_7, c1_.name AS name_8, c1_.category_order AS category_order_9, c1_.slug AS slug_10, p0_.categories_id AS categories_id_11, c1_.parent_id AS parent_id_12 FROM products p0_ INNER JOIN categories c1_ ON p0_.categories_id = c1_.id WHERE c1_.slug = 'homme' LIMIT 3

[]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.price AS price_3,
  p0_.stock AS stock_4,
  p0_.created_at AS created_at_5,
  p0_.slug AS slug_6,
  c1_.id AS id_7,
  c1_.name AS name_8,
  c1_.category_order AS category_order_9,
  c1_.slug AS slug_10,
  p0_.categories_id AS categories_id_11,
  c1_.parent_id AS parent_id_12
FROM
  products p0_
  INNER JOIN categories c1_ ON p0_.categories_id = c1_.id
WHERE
  c1_.slug = 'homme'
LIMIT
  3

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.stock AS stock_4, p0_.created_at AS created_at_5, p0_.slug AS slug_6, c1_.id AS id_7, c1_.name AS name_8, c1_.category_order AS category_order_9, c1_.slug AS slug_10, p0_.categories_id AS categories_id_11, c1_.parent_id AS parent_id_12 FROM products p0_ INNER JOIN categories c1_ ON p0_.categories_id = c1_.id WHERE c1_.slug = 'homme' LIMIT 3;

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.stock AS stock_4, p0_.created_at AS created_at_5, p0_.slug AS slug_6, c1_.id AS id_7, c1_.name AS name_8, c1_.category_order AS category_order_9, c1_.slug AS slug_10 FROM products p0_ INNER JOIN categories c1_ ON p0_.categories_id = c1_.id WHERE c1_.slug = 'homme') dctrn_result) dctrn_table

[]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.name AS name_1,
          p0_.description AS description_2,
          p0_.price AS price_3,
          p0_.stock AS stock_4,
          p0_.created_at AS created_at_5,
          p0_.slug AS slug_6,
          c1_.id AS id_7,
          c1_.name AS name_8,
          c1_.category_order AS category_order_9,
          c1_.slug AS slug_10
        FROM
          products p0_
          INNER JOIN categories c1_ ON p0_.categories_id = c1_.id
        WHERE
          c1_.slug = 'homme'
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.stock AS stock_4, p0_.created_at AS created_at_5, p0_.slug AS slug_6, c1_.id AS id_7, c1_.name AS name_8, c1_.category_order AS category_order_9, c1_.slug AS slug_10 FROM products p0_ INNER JOIN categories c1_ ON p0_.categories_id = c1_.id WHERE c1_.slug = 'homme') dctrn_result) dctrn_table;

Database Connections

Entity Managers

Second Level Cache

Entities Mapping