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_.section AS section_34, s3_.location AS location_35, s3_.shop_name AS shop_name_36, s3_.phone AS phone_37, s3_.credit_limit AS credit_limit_38, s3_.credit_days AS credit_days_39, s3_.name_manager_shop AS name_manager_shop_40, s3_.longitude AS longitude_41, s3_.latitude AS latitude_42 FROM purchase p0_ LEFT JOIN goods g1_ ON p0_.id_brand_id = g1_.id LEFT JOIN invoice i2_ ON p0_.invoice_id = i2_.id LEFT JOIN shop s3_ ON i2_.shop_id = s3_.id WHERE p0_.id = ?

[
  39076
]

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_.section AS section_34,
  s3_.location AS location_35,
  s3_.shop_name AS shop_name_36,
  s3_.phone AS phone_37,
  s3_.credit_limit AS credit_limit_38,
  s3_.credit_days AS credit_days_39,
  s3_.name_manager_shop AS name_manager_shop_40,
  s3_.longitude AS longitude_41,
  s3_.latitude AS latitude_42
FROM
  purchase p0_
  LEFT JOIN goods g1_ ON p0_.id_brand_id = g1_.id
  LEFT JOIN invoice i2_ ON p0_.invoice_id = i2_.id
  LEFT JOIN shop s3_ ON i2_.shop_id = s3_.id
WHERE
  p0_.id = ?

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_.section AS section_34, s3_.location AS location_35, s3_.shop_name AS shop_name_36, s3_.phone AS phone_37, s3_.credit_limit AS credit_limit_38, s3_.credit_days AS credit_days_39, s3_.name_manager_shop AS name_manager_shop_40, s3_.longitude AS longitude_41, s3_.latitude AS latitude_42 FROM purchase p0_ LEFT JOIN goods g1_ ON p0_.id_brand_id = g1_.id LEFT JOIN invoice i2_ ON p0_.invoice_id = i2_.id LEFT JOIN shop s3_ ON i2_.shop_id = s3_.id WHERE p0_.id = 39076;

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;