Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 10
• Events
• Routing
• Cache
• Security
• Twig
• Doctrine 1
• Debug
• Emails
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.label AS label_4, t0.product_id AS product_id_5 FROM product_quantity t0 WHERE (t0.quantity >= ? AND t0.product_id = ?) ORDER BY t0.quantity ASC LIMIT 1

[
  1
  1243
]

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.label AS label_4,
  t0.product_id AS product_id_5
FROM
  product_quantity t0
WHERE
  (
    t0.quantity >= ?
    AND t0.product_id = ?
  )
ORDER BY
  t0.quantity ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.label AS label_4, t0.product_id AS product_id_5 FROM product_quantity t0 WHERE (t0.quantity >= 1 AND t0.product_id = 1243) ORDER BY t0.quantity ASC LIMIT 1;

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = ? ORDER BY t0.priority ASC

[
  1
]

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.priority AS priority_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5,
  t6.id AS id_7,
  t6.label AS label_8,
  t6.priority AS priority_9,
  t6.image AS image_10,
  t6.parent_id AS parent_id_11
FROM
  product_category t0
  LEFT JOIN product_category t6 ON t0.parent_id = t6.id
WHERE
  t0.parent_id = ?
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = 1 ORDER BY t0.priority ASC;

SELECT material_id FROM product WHERE product_category_id = ?

[
  -1 => 42
]

SELECT
  material_id
FROM
  product
WHERE
  product_category_id = ?

SELECT material_id FROM product WHERE product_category_id = ?;

SELECT t0.id AS id_1, t0.class AS class_2, t0.name AS name_3, t0.item_number AS item_number_4, t0.size AS size_5, t0.shape AS shape_6, t0.quantity AS quantity_7, t0.weight AS weight_8, t0.is_viewable AS is_viewable_9, t0.notes AS notes_10, t0.image AS image_11, t0.product_category_id AS product_category_id_12, t0.material_id AS material_id_13 FROM product t0 WHERE t0.product_category_id = ?

[
  42
]

SELECT
  t0.id AS id_1,
  t0.class AS class_2,
  t0.name AS name_3,
  t0.item_number AS item_number_4,
  t0.size AS size_5,
  t0.shape AS shape_6,
  t0.quantity AS quantity_7,
  t0.weight AS weight_8,
  t0.is_viewable AS is_viewable_9,
  t0.notes AS notes_10,
  t0.image AS image_11,
  t0.product_category_id AS product_category_id_12,
  t0.material_id AS material_id_13
FROM
  product t0
WHERE
  t0.product_category_id = ?

SELECT t0.id AS id_1, t0.class AS class_2, t0.name AS name_3, t0.item_number AS item_number_4, t0.size AS size_5, t0.shape AS shape_6, t0.quantity AS quantity_7, t0.weight AS weight_8, t0.is_viewable AS is_viewable_9, t0.notes AS notes_10, t0.image AS image_11, t0.product_category_id AS product_category_id_12, t0.material_id AS material_id_13 FROM product t0 WHERE t0.product_category_id = 42;

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id IS NULL ORDER BY t0.priority ASC

[]

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.priority AS priority_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5,
  t6.id AS id_7,
  t6.label AS label_8,
  t6.priority AS priority_9,
  t6.image AS image_10,
  t6.parent_id AS parent_id_11
FROM
  product_category t0
  LEFT JOIN product_category t6 ON t0.parent_id = t6.id
WHERE
  t0.parent_id IS NULL
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id IS NULL ORDER BY t0.priority ASC;

SELECT t0.id AS id_1, t0.material AS material_2 FROM material t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  13
  13
  13
  14
  13
  14
  13
  14
  13
  13
  14
  13
  14
  13
  14
  13
  13
  13
  13
  14
  14
  13
  13
  14
  14
  13
  13
  14
  13
  13
]

SELECT
  t0.id AS id_1,
  t0.material AS material_2
FROM
  material t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.material AS material_2 FROM material t0 WHERE t0.id IN (13, 13, 13, 14, 13, 14, 13, 14, 13, 13, 14, 13, 14, 13, 14, 13, 13, 13, 13, 14, 14, 13, 13, 14, 14, 13, 13, 14, 13, 13);

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.id = ?

[
  "42"
]

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.priority AS priority_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5,
  t6.id AS id_7,
  t6.label AS label_8,
  t6.priority AS priority_9,
  t6.image AS image_10,
  t6.parent_id AS parent_id_11
FROM
  product_category t0
  LEFT JOIN product_category t6 ON t0.parent_id = t6.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.id = '42';