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 p0_.id AS id_0, p0_.item_number AS item_number_1, p0_.carton_number AS carton_number_2, p0_.totalitemvalue AS totalitemvalue_3, p0_.totalctnsvalue AS totalctnsvalue_4, p0_.totalvalue AS totalvalue_5, p0_.box_number AS box_number_6, p0_.bottle_number AS bottle_number_7, p0_.totalboxvalue AS totalboxvalue_8, p0_.sac_number AS sac_number_9, p0_.totalsacvalue AS totalsacvalue_10, p0_.totalbottlevalue AS totalbottlevalue_11, p0_.pricectn AS pricectn_12, p0_.pricesac AS pricesac_13, p0_.pricebtl AS pricebtl_14, p0_.pricebox AS pricebox_15, p0_.priceitem AS priceitem_16, g1_.id AS id_17, g1_.brand AS brand_18, g1_.pricectns AS pricectns_19, g1_.pricebox AS pricebox_20, g1_.pricebottle AS pricebottle_21, g1_.priceitem AS priceitem_22, g1_.pricesac AS pricesac_23, i2_.id AS id_24, i2_.date AS date_25, i2_.label AS label_26, i2_.amount AS amount_27, i2_.latitude AS latitude_28, i2_.longitude AS longitude_29, i2_.cash_amount AS cash_amount_30, i2_.credit_amount AS credit_amount_31, i2_.etat AS etat_32, s3_.id AS id_33, s3_.name AS name_34, s3_.contact AS contact_35, s3_.address AS address_36, s3_.can_sell_cash AS can_sell_cash_37, s3_.is_cashvan AS is_cashvan_38, s4_.id AS id_39, s4_.section AS section_40, s4_.location AS location_41, s4_.shop_name AS shop_name_42, s4_.phone AS phone_43, s4_.credit_limit AS credit_limit_44, s4_.credit_days AS credit_days_45, s4_.name_manager_shop AS name_manager_shop_46, s4_.longitude AS longitude_47, s4_.latitude AS latitude_48 FROM purchase p0_ LEFT JOIN goods g1_ ON p0_.id_brand_id = g1_.id LEFT JOIN invoice i2_ ON p0_.invoice_id = i2_.id INNER JOIN sales_men s3_ ON i2_.sales_id = s3_.id LEFT JOIN shop s4_ ON i2_.shop_id = s4_.id WHERE s3_.id = ? ORDER BY i2_.date DESC LIMIT 500

[
  11
]

SELECT
  p0_.id AS id_0,
  p0_.item_number AS item_number_1,
  p0_.carton_number AS carton_number_2,
  p0_.totalitemvalue AS totalitemvalue_3,
  p0_.totalctnsvalue AS totalctnsvalue_4,
  p0_.totalvalue AS totalvalue_5,
  p0_.box_number AS box_number_6,
  p0_.bottle_number AS bottle_number_7,
  p0_.totalboxvalue AS totalboxvalue_8,
  p0_.sac_number AS sac_number_9,
  p0_.totalsacvalue AS totalsacvalue_10,
  p0_.totalbottlevalue AS totalbottlevalue_11,
  p0_.pricectn AS pricectn_12,
  p0_.pricesac AS pricesac_13,
  p0_.pricebtl AS pricebtl_14,
  p0_.pricebox AS pricebox_15,
  p0_.priceitem AS priceitem_16,
  g1_.id AS id_17,
  g1_.brand AS brand_18,
  g1_.pricectns AS pricectns_19,
  g1_.pricebox AS pricebox_20,
  g1_.pricebottle AS pricebottle_21,
  g1_.priceitem AS priceitem_22,
  g1_.pricesac AS pricesac_23,
  i2_.id AS id_24,
  i2_.date AS date_25,
  i2_.label AS label_26,
  i2_.amount AS amount_27,
  i2_.latitude AS latitude_28,
  i2_.longitude AS longitude_29,
  i2_.cash_amount AS cash_amount_30,
  i2_.credit_amount AS credit_amount_31,
  i2_.etat AS etat_32,
  s3_.id AS id_33,
  s3_.name AS name_34,
  s3_.contact AS contact_35,
  s3_.address AS address_36,
  s3_.can_sell_cash AS can_sell_cash_37,
  s3_.is_cashvan AS is_cashvan_38,
  s4_.id AS id_39,
  s4_.section AS section_40,
  s4_.location AS location_41,
  s4_.shop_name AS shop_name_42,
  s4_.phone AS phone_43,
  s4_.credit_limit AS credit_limit_44,
  s4_.credit_days AS credit_days_45,
  s4_.name_manager_shop AS name_manager_shop_46,
  s4_.longitude AS longitude_47,
  s4_.latitude AS latitude_48
FROM
  purchase p0_
  LEFT JOIN goods g1_ ON p0_.id_brand_id = g1_.id
  LEFT JOIN invoice i2_ ON p0_.invoice_id = i2_.id
  INNER JOIN sales_men s3_ ON i2_.sales_id = s3_.id
  LEFT JOIN shop s4_ ON i2_.shop_id = s4_.id
WHERE
  s3_.id = ?
ORDER BY
  i2_.date DESC
LIMIT
  500

SELECT p0_.id AS id_0, p0_.item_number AS item_number_1, p0_.carton_number AS carton_number_2, p0_.totalitemvalue AS totalitemvalue_3, p0_.totalctnsvalue AS totalctnsvalue_4, p0_.totalvalue AS totalvalue_5, p0_.box_number AS box_number_6, p0_.bottle_number AS bottle_number_7, p0_.totalboxvalue AS totalboxvalue_8, p0_.sac_number AS sac_number_9, p0_.totalsacvalue AS totalsacvalue_10, p0_.totalbottlevalue AS totalbottlevalue_11, p0_.pricectn AS pricectn_12, p0_.pricesac AS pricesac_13, p0_.pricebtl AS pricebtl_14, p0_.pricebox AS pricebox_15, p0_.priceitem AS priceitem_16, g1_.id AS id_17, g1_.brand AS brand_18, g1_.pricectns AS pricectns_19, g1_.pricebox AS pricebox_20, g1_.pricebottle AS pricebottle_21, g1_.priceitem AS priceitem_22, g1_.pricesac AS pricesac_23, i2_.id AS id_24, i2_.date AS date_25, i2_.label AS label_26, i2_.amount AS amount_27, i2_.latitude AS latitude_28, i2_.longitude AS longitude_29, i2_.cash_amount AS cash_amount_30, i2_.credit_amount AS credit_amount_31, i2_.etat AS etat_32, s3_.id AS id_33, s3_.name AS name_34, s3_.contact AS contact_35, s3_.address AS address_36, s3_.can_sell_cash AS can_sell_cash_37, s3_.is_cashvan AS is_cashvan_38, s4_.id AS id_39, s4_.section AS section_40, s4_.location AS location_41, s4_.shop_name AS shop_name_42, s4_.phone AS phone_43, s4_.credit_limit AS credit_limit_44, s4_.credit_days AS credit_days_45, s4_.name_manager_shop AS name_manager_shop_46, s4_.longitude AS longitude_47, s4_.latitude AS latitude_48 FROM purchase p0_ LEFT JOIN goods g1_ ON p0_.id_brand_id = g1_.id LEFT JOIN invoice i2_ ON p0_.invoice_id = i2_.id INNER JOIN sales_men s3_ ON i2_.sales_id = s3_.id LEFT JOIN shop s4_ ON i2_.shop_id = s4_.id WHERE s3_.id = 11 ORDER BY i2_.date DESC LIMIT 500;

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.contact AS contact_6 FROM user t0 WHERE t0.id = ?

[
  16
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.contact AS contact_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.contact AS contact_6 FROM user t0 WHERE t0.id = 16;