Symfony Profiler

• Request / Response
• Performance
• Exception
• Logs
• Events
• Routing
• Cache
• Twig
• HTTP Client
• Doctrine
• Configuration

Query Metrics

SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.company_id = ? AND o0_.is_deleted = ? AND o0_.user_created = ? LIMIT 1

[
  1
  0
  2
]

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  `order` o0_
WHERE
  o0_.company_id = ?
  AND o0_.is_deleted = ?
  AND o0_.user_created = ?
LIMIT
  1

SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.company_id = 1 AND o0_.is_deleted = 0 AND o0_.user_created = 2 LIMIT 1;

SELECT o0_.id AS id_0, o0_.company_id AS company_id_1, o0_.platform_id AS platform_id_2, o0_.source_id AS source_id_3, o0_.client_id AS client_id_4, o0_.client_work_point_id AS client_work_point_id_5, o0_.status_id AS status_id_6, o0_.payment_method_id AS payment_method_id_7, o0_.paid AS paid_8, o0_.production_day_id AS production_day_id_9, o0_.user_created AS user_created_10, o0_.date_created AS date_created_11, o0_.is_active AS is_active_12, c1_.name AS name_13, c1_.alias AS alias_14, c2_.name AS name_15, u3_.firstname AS firstname_16, u3_.lastname AS lastname_17, c4_.name AS name_18, c4_.color AS color_19, c5_.label AS label_20, p6_.date AS date_21, p6_.is_active AS is_active_22 FROM `order` o0_ LEFT JOIN user u3_ ON (o0_.user_created = u3_.id) LEFT JOIN client c1_ ON (o0_.client_id = c1_.id) LEFT JOIN client_work_point c2_ ON (o0_.client_work_point_id = c2_.id) LEFT JOIN config_order_status c4_ ON (o0_.status_id = c4_.id) LEFT JOIN config_payment_method c5_ ON (o0_.payment_method_id = c5_.id) LEFT JOIN production_day p6_ ON (o0_.production_day_id = p6_.id) WHERE o0_.company_id = ? AND o0_.user_created = ? AND o0_.is_deleted = ? ORDER BY o0_.id DESC LIMIT 12

[
  1
  2
  0
]

SELECT
  o0_.id AS id_0,
  o0_.company_id AS company_id_1,
  o0_.platform_id AS platform_id_2,
  o0_.source_id AS source_id_3,
  o0_.client_id AS client_id_4,
  o0_.client_work_point_id AS client_work_point_id_5,
  o0_.status_id AS status_id_6,
  o0_.payment_method_id AS payment_method_id_7,
  o0_.paid AS paid_8,
  o0_.production_day_id AS production_day_id_9,
  o0_.user_created AS user_created_10,
  o0_.date_created AS date_created_11,
  o0_.is_active AS is_active_12,
  c1_.name AS name_13,
  c1_.alias AS alias_14,
  c2_.name AS name_15,
  u3_.firstname AS firstname_16,
  u3_.lastname AS lastname_17,
  c4_.name AS name_18,
  c4_.color AS color_19,
  c5_.label AS label_20,
  p6_.date AS date_21,
  p6_.is_active AS is_active_22
FROM
  `order` o0_
  LEFT JOIN user u3_ ON (o0_.user_created = u3_.id)
  LEFT JOIN client c1_ ON (o0_.client_id = c1_.id)
  LEFT JOIN client_work_point c2_ ON (
    o0_.client_work_point_id = c2_.id
  )
  LEFT JOIN config_order_status c4_ ON (o0_.status_id = c4_.id)
  LEFT JOIN config_payment_method c5_ ON (o0_.payment_method_id = c5_.id)
  LEFT JOIN production_day p6_ ON (o0_.production_day_id = p6_.id)
WHERE
  o0_.company_id = ?
  AND o0_.user_created = ?
  AND o0_.is_deleted = ?
ORDER BY
  o0_.id DESC
LIMIT
  12

SELECT o0_.id AS id_0, o0_.company_id AS company_id_1, o0_.platform_id AS platform_id_2, o0_.source_id AS source_id_3, o0_.client_id AS client_id_4, o0_.client_work_point_id AS client_work_point_id_5, o0_.status_id AS status_id_6, o0_.payment_method_id AS payment_method_id_7, o0_.paid AS paid_8, o0_.production_day_id AS production_day_id_9, o0_.user_created AS user_created_10, o0_.date_created AS date_created_11, o0_.is_active AS is_active_12, c1_.name AS name_13, c1_.alias AS alias_14, c2_.name AS name_15, u3_.firstname AS firstname_16, u3_.lastname AS lastname_17, c4_.name AS name_18, c4_.color AS color_19, c5_.label AS label_20, p6_.date AS date_21, p6_.is_active AS is_active_22 FROM `order` o0_ LEFT JOIN user u3_ ON (o0_.user_created = u3_.id) LEFT JOIN client c1_ ON (o0_.client_id = c1_.id) LEFT JOIN client_work_point c2_ ON (o0_.client_work_point_id = c2_.id) LEFT JOIN config_order_status c4_ ON (o0_.status_id = c4_.id) LEFT JOIN config_payment_method c5_ ON (o0_.payment_method_id = c5_.id) LEFT JOIN production_day p6_ ON (o0_.production_day_id = p6_.id) WHERE o0_.company_id = 1 AND o0_.user_created = 2 AND o0_.is_deleted = 0 ORDER BY o0_.id DESC LIMIT 12;