Symfony Profiler

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

Query Metrics

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, p1_.id AS id_3, p1_.name AS name_4, p1_.created_at AS created_at_5, p1_.barcode AS barcode_6, p1_.description AS description_7, p1_.usual_vendor AS usual_vendor_8, p1_.image AS image_9, c2_.id AS id_10, c2_.name AS name_11, c2_.description AS description_12, p3_.id AS id_13, p3_.name AS name_14, p3_.created_at AS created_at_15, p3_.barcode AS barcode_16, p3_.description AS description_17, p3_.usual_vendor AS usual_vendor_18, p3_.image AS image_19, c0_.parent_id AS parent_id_20, p1_.units_id AS units_id_21, p1_.brand_id AS brand_id_22, c2_.parent_id AS parent_id_23, p3_.units_id AS units_id_24, p3_.brand_id AS brand_id_25 FROM category c0_ LEFT JOIN product_category p4_ ON c0_.id = p4_.category_id LEFT JOIN product p1_ ON p1_.id = p4_.product_id LEFT JOIN category c2_ ON c0_.id = c2_.parent_id LEFT JOIN product_category p5_ ON c2_.id = p5_.category_id LEFT JOIN product p3_ ON p3_.id = p5_.product_id WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  p1_.id AS id_3,
  p1_.name AS name_4,
  p1_.created_at AS created_at_5,
  p1_.barcode AS barcode_6,
  p1_.description AS description_7,
  p1_.usual_vendor AS usual_vendor_8,
  p1_.image AS image_9,
  c2_.id AS id_10,
  c2_.name AS name_11,
  c2_.description AS description_12,
  p3_.id AS id_13,
  p3_.name AS name_14,
  p3_.created_at AS created_at_15,
  p3_.barcode AS barcode_16,
  p3_.description AS description_17,
  p3_.usual_vendor AS usual_vendor_18,
  p3_.image AS image_19,
  c0_.parent_id AS parent_id_20,
  p1_.units_id AS units_id_21,
  p1_.brand_id AS brand_id_22,
  c2_.parent_id AS parent_id_23,
  p3_.units_id AS units_id_24,
  p3_.brand_id AS brand_id_25
FROM
  category c0_
  LEFT JOIN product_category p4_ ON c0_.id = p4_.category_id
  LEFT JOIN product p1_ ON p1_.id = p4_.product_id
  LEFT JOIN category c2_ ON c0_.id = c2_.parent_id
  LEFT JOIN product_category p5_ ON c2_.id = p5_.category_id
  LEFT JOIN product p3_ ON p3_.id = p5_.product_id
WHERE
  c0_.parent_id IS NULL
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, p1_.id AS id_3, p1_.name AS name_4, p1_.created_at AS created_at_5, p1_.barcode AS barcode_6, p1_.description AS description_7, p1_.usual_vendor AS usual_vendor_8, p1_.image AS image_9, c2_.id AS id_10, c2_.name AS name_11, c2_.description AS description_12, p3_.id AS id_13, p3_.name AS name_14, p3_.created_at AS created_at_15, p3_.barcode AS barcode_16, p3_.description AS description_17, p3_.usual_vendor AS usual_vendor_18, p3_.image AS image_19, c0_.parent_id AS parent_id_20, p1_.units_id AS units_id_21, p1_.brand_id AS brand_id_22, c2_.parent_id AS parent_id_23, p3_.units_id AS units_id_24, p3_.brand_id AS brand_id_25 FROM category c0_ LEFT JOIN product_category p4_ ON c0_.id = p4_.category_id LEFT JOIN product p1_ ON p1_.id = p4_.product_id LEFT JOIN category c2_ ON c0_.id = c2_.parent_id LEFT JOIN product_category p5_ ON c2_.id = p5_.category_id LEFT JOIN product p3_ ON p3_.id = p5_.product_id WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC;