Symfony Profiler

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

Query Metrics

SELECT s0_.id AS id_0, s0_.section AS section_1, s0_.location AS location_2, s0_.shop_name AS shop_name_3, s0_.phone AS phone_4, s0_.credit_limit AS credit_limit_5, s0_.credit_days AS credit_days_6, s0_.name_manager_shop AS name_manager_shop_7, s0_.longitude AS longitude_8, s0_.latitude AS latitude_9, s1_.id AS id_10, s1_.name AS name_11, s1_.contact AS contact_12, s1_.address AS address_13, s1_.can_sell_cash AS can_sell_cash_14, s1_.is_cashvan AS is_cashvan_15, c2_.id AS id_16, c2_.city_name AS city_name_17 FROM shop s0_ LEFT JOIN sales_men s1_ ON s0_.sales_men_id = s1_.id LEFT JOIN city c2_ ON s0_.city_id = c2_.id WHERE s0_.sales_men_id = ?

[
  27
]

SELECT
  s0_.id AS id_0,
  s0_.section AS section_1,
  s0_.location AS location_2,
  s0_.shop_name AS shop_name_3,
  s0_.phone AS phone_4,
  s0_.credit_limit AS credit_limit_5,
  s0_.credit_days AS credit_days_6,
  s0_.name_manager_shop AS name_manager_shop_7,
  s0_.longitude AS longitude_8,
  s0_.latitude AS latitude_9,
  s1_.id AS id_10,
  s1_.name AS name_11,
  s1_.contact AS contact_12,
  s1_.address AS address_13,
  s1_.can_sell_cash AS can_sell_cash_14,
  s1_.is_cashvan AS is_cashvan_15,
  c2_.id AS id_16,
  c2_.city_name AS city_name_17
FROM
  shop s0_
  LEFT JOIN sales_men s1_ ON s0_.sales_men_id = s1_.id
  LEFT JOIN city c2_ ON s0_.city_id = c2_.id
WHERE
  s0_.sales_men_id = ?

SELECT s0_.id AS id_0, s0_.section AS section_1, s0_.location AS location_2, s0_.shop_name AS shop_name_3, s0_.phone AS phone_4, s0_.credit_limit AS credit_limit_5, s0_.credit_days AS credit_days_6, s0_.name_manager_shop AS name_manager_shop_7, s0_.longitude AS longitude_8, s0_.latitude AS latitude_9, s1_.id AS id_10, s1_.name AS name_11, s1_.contact AS contact_12, s1_.address AS address_13, s1_.can_sell_cash AS can_sell_cash_14, s1_.is_cashvan AS is_cashvan_15, c2_.id AS id_16, c2_.city_name AS city_name_17 FROM shop s0_ LEFT JOIN sales_men s1_ ON s0_.sales_men_id = s1_.id LEFT JOIN city c2_ ON s0_.city_id = c2_.id WHERE s0_.sales_men_id = 27;

SELECT s0_.id AS id_0, s1_.id AS id_1, s1_.section AS section_2, s1_.location AS location_3, s1_.shop_name AS shop_name_4, s1_.phone AS phone_5, s1_.credit_limit AS credit_limit_6, s1_.credit_days AS credit_days_7, s1_.name_manager_shop AS name_manager_shop_8, s1_.longitude AS longitude_9, s1_.latitude AS latitude_10, s2_.id AS id_11, s2_.name AS name_12, s2_.contact AS contact_13, s2_.address AS address_14, s2_.can_sell_cash AS can_sell_cash_15, s2_.is_cashvan AS is_cashvan_16, c3_.id AS id_17, c3_.city_name AS city_name_18 FROM shop_salesman s0_ LEFT JOIN shop s1_ ON s0_.shop_id = s1_.id LEFT JOIN sales_men s2_ ON s0_.salesmen_id = s2_.id LEFT JOIN city c3_ ON s1_.city_id = c3_.id WHERE s2_.id = ?

[
  27
]

SELECT
  s0_.id AS id_0,
  s1_.id AS id_1,
  s1_.section AS section_2,
  s1_.location AS location_3,
  s1_.shop_name AS shop_name_4,
  s1_.phone AS phone_5,
  s1_.credit_limit AS credit_limit_6,
  s1_.credit_days AS credit_days_7,
  s1_.name_manager_shop AS name_manager_shop_8,
  s1_.longitude AS longitude_9,
  s1_.latitude AS latitude_10,
  s2_.id AS id_11,
  s2_.name AS name_12,
  s2_.contact AS contact_13,
  s2_.address AS address_14,
  s2_.can_sell_cash AS can_sell_cash_15,
  s2_.is_cashvan AS is_cashvan_16,
  c3_.id AS id_17,
  c3_.city_name AS city_name_18
FROM
  shop_salesman s0_
  LEFT JOIN shop s1_ ON s0_.shop_id = s1_.id
  LEFT JOIN sales_men s2_ ON s0_.salesmen_id = s2_.id
  LEFT JOIN city c3_ ON s1_.city_id = c3_.id
WHERE
  s2_.id = ?

SELECT s0_.id AS id_0, s1_.id AS id_1, s1_.section AS section_2, s1_.location AS location_3, s1_.shop_name AS shop_name_4, s1_.phone AS phone_5, s1_.credit_limit AS credit_limit_6, s1_.credit_days AS credit_days_7, s1_.name_manager_shop AS name_manager_shop_8, s1_.longitude AS longitude_9, s1_.latitude AS latitude_10, s2_.id AS id_11, s2_.name AS name_12, s2_.contact AS contact_13, s2_.address AS address_14, s2_.can_sell_cash AS can_sell_cash_15, s2_.is_cashvan AS is_cashvan_16, c3_.id AS id_17, c3_.city_name AS city_name_18 FROM shop_salesman s0_ LEFT JOIN shop s1_ ON s0_.shop_id = s1_.id LEFT JOIN sales_men s2_ ON s0_.salesmen_id = s2_.id LEFT JOIN city c3_ ON s1_.city_id = c3_.id WHERE s2_.id = 27;