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
  1278
]

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 = 1278) 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 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 = ?

[
  "44"
]

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 = '44';

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

[
  44
]

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

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 material_id FROM product WHERE product_category_id = ?

[
  -1 => 44
]

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.material AS material_2 FROM material t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  8
  8
  8
  8
  8
  8
  8
  8
  8
  8
  8
  8
  8
  8
]

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 (8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8);