Symfony Profiler

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

Query Metrics

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, t0.city AS city_7 FROM user t0 WHERE t0.id = ?

[
  22
]

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,
  t0.city AS city_7
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, t0.city AS city_7 FROM user t0 WHERE t0.id = 22;

SELECT t0.id AS id_1, t0.name AS name_2, t0.contact AS contact_3, t0.address AS address_4, t0.can_sell_cash AS can_sell_cash_5, t0.is_cashvan AS is_cashvan_6, t0.user_id AS user_id_7 FROM sales_men t0 WHERE t0.id = ?

[
  27
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.contact AS contact_3,
  t0.address AS address_4,
  t0.can_sell_cash AS can_sell_cash_5,
  t0.is_cashvan AS is_cashvan_6,
  t0.user_id AS user_id_7
FROM
  sales_men t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.contact AS contact_3, t0.address AS address_4, t0.can_sell_cash AS can_sell_cash_5, t0.is_cashvan AS is_cashvan_6, t0.user_id AS user_id_7 FROM sales_men t0 WHERE t0.id = 27;

SELECT t0.id AS id_1, t0.section AS section_2, t0.location AS location_3, t0.shop_name AS shop_name_4, t0.phone AS phone_5, t0.credit_limit AS credit_limit_6, t0.credit_days AS credit_days_7, t0.name_manager_shop AS name_manager_shop_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.sales_men_id AS sales_men_id_11, t0.city_id AS city_id_12 FROM shop t0 WHERE t0.id = ?

[
  3156
]

SELECT
  t0.id AS id_1,
  t0.section AS section_2,
  t0.location AS location_3,
  t0.shop_name AS shop_name_4,
  t0.phone AS phone_5,
  t0.credit_limit AS credit_limit_6,
  t0.credit_days AS credit_days_7,
  t0.name_manager_shop AS name_manager_shop_8,
  t0.longitude AS longitude_9,
  t0.latitude AS latitude_10,
  t0.sales_men_id AS sales_men_id_11,
  t0.city_id AS city_id_12
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.section AS section_2, t0.location AS location_3, t0.shop_name AS shop_name_4, t0.phone AS phone_5, t0.credit_limit AS credit_limit_6, t0.credit_days AS credit_days_7, t0.name_manager_shop AS name_manager_shop_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.sales_men_id AS sales_men_id_11, t0.city_id AS city_id_12 FROM shop t0 WHERE t0.id = 3156;

SELECT COUNT(id) AS invoiceCount
        FROM invoice
        WHERE label LIKE :yearMonth
          AND sales_id = :salesId

[
  "yearMonth" => "2026/MAY/%"
  "salesId" => 27
]

SELECT
  COUNT(id) AS invoiceCount
FROM
  invoice
WHERE
  label LIKE :yearMonth
  AND sales_id = :salesId

SELECT COUNT(id) AS invoiceCount
        FROM invoice
        WHERE label LIKE '2026/MAY/%'
          AND sales_id = 27
    ;

SELECT t0.id AS id_1, t0.brand AS brand_2, t0.pricectns AS pricectns_3, t0.pricebox AS pricebox_4, t0.pricebottle AS pricebottle_5, t0.priceitem AS priceitem_6, t0.pricesac AS pricesac_7 FROM goods t0 WHERE t0.brand = ? LIMIT 1

[
  " Lame Dorco ( STL-300) Titan Carte (Crt*50Pkt)"
]

SELECT
  t0.id AS id_1,
  t0.brand AS brand_2,
  t0.pricectns AS pricectns_3,
  t0.pricebox AS pricebox_4,
  t0.pricebottle AS pricebottle_5,
  t0.priceitem AS priceitem_6,
  t0.pricesac AS pricesac_7
FROM
  goods t0
WHERE
  t0.brand = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.brand AS brand_2, t0.pricectns AS pricectns_3, t0.pricebox AS pricebox_4, t0.pricebottle AS pricebottle_5, t0.priceitem AS priceitem_6, t0.pricesac AS pricesac_7 FROM goods t0 WHERE t0.brand = ' Lame Dorco ( STL-300) Titan Carte (Crt*50Pkt)' LIMIT 1;

SELECT t0.id AS id_1, t0.item_number AS item_number_2, t0.carton_number AS carton_number_3, t0.totalitemvalue AS totalitemvalue_4, t0.totalctnsvalue AS totalctnsvalue_5, t0.totalvalue AS totalvalue_6, t0.box_number AS box_number_7, t0.bottle_number AS bottle_number_8, t0.totalboxvalue AS totalboxvalue_9, t0.sac_number AS sac_number_10, t0.totalsacvalue AS totalsacvalue_11, t0.totalbottlevalue AS totalbottlevalue_12, t0.pricectn AS pricectn_13, t0.pricesac AS pricesac_14, t0.pricebtl AS pricebtl_15, t0.pricebox AS pricebox_16, t0.priceitem AS priceitem_17, t0.id_brand_id AS id_brand_id_18, t0.invoice_id AS invoice_id_19, t0.id_brand_cashvan_id AS id_brand_cashvan_id_20 FROM purchase t0 WHERE t0.id_brand_id = ? AND t0.invoice_id = ? LIMIT 1

[
  50
  null
]

SELECT
  t0.id AS id_1,
  t0.item_number AS item_number_2,
  t0.carton_number AS carton_number_3,
  t0.totalitemvalue AS totalitemvalue_4,
  t0.totalctnsvalue AS totalctnsvalue_5,
  t0.totalvalue AS totalvalue_6,
  t0.box_number AS box_number_7,
  t0.bottle_number AS bottle_number_8,
  t0.totalboxvalue AS totalboxvalue_9,
  t0.sac_number AS sac_number_10,
  t0.totalsacvalue AS totalsacvalue_11,
  t0.totalbottlevalue AS totalbottlevalue_12,
  t0.pricectn AS pricectn_13,
  t0.pricesac AS pricesac_14,
  t0.pricebtl AS pricebtl_15,
  t0.pricebox AS pricebox_16,
  t0.priceitem AS priceitem_17,
  t0.id_brand_id AS id_brand_id_18,
  t0.invoice_id AS invoice_id_19,
  t0.id_brand_cashvan_id AS id_brand_cashvan_id_20
FROM
  purchase t0
WHERE
  t0.id_brand_id = ?
  AND t0.invoice_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.item_number AS item_number_2, t0.carton_number AS carton_number_3, t0.totalitemvalue AS totalitemvalue_4, t0.totalctnsvalue AS totalctnsvalue_5, t0.totalvalue AS totalvalue_6, t0.box_number AS box_number_7, t0.bottle_number AS bottle_number_8, t0.totalboxvalue AS totalboxvalue_9, t0.sac_number AS sac_number_10, t0.totalsacvalue AS totalsacvalue_11, t0.totalbottlevalue AS totalbottlevalue_12, t0.pricectn AS pricectn_13, t0.pricesac AS pricesac_14, t0.pricebtl AS pricebtl_15, t0.pricebox AS pricebox_16, t0.priceitem AS priceitem_17, t0.id_brand_id AS id_brand_id_18, t0.invoice_id AS invoice_id_19, t0.id_brand_cashvan_id AS id_brand_cashvan_id_20 FROM purchase t0 WHERE t0.id_brand_id = 50 AND t0.invoice_id = NULL LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO invoice (date, label, amount, latitude, longitude, cash_amount, credit_amount, etat, sales_id, shop_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  "2026-05-14 13:21:23"
  "2026/MAY/CASHVAN-3Julia/174"
  53000.0
  -19.0749685
  47.5486187
  53000.0
  0.0
  0
  27
  3156
]

INSERT INTO invoice (
  date, label, amount, latitude, longitude,
  cash_amount, credit_amount, etat,
  sales_id, shop_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO invoice (date, label, amount, latitude, longitude, cash_amount, credit_amount, etat, sales_id, shop_id) VALUES ('2026-05-14 13:21:23', '2026/MAY/CASHVAN-3Julia/174', 53000, -19.0749685, 47.5486187, 53000, 0, 0, 27, 3156);

INSERT INTO payment (cash, date, shop_id) VALUES (?, ?, ?)

[
  "53000"
  "2026-05-14"
  3156
]

INSERT INTO payment (cash, date, shop_id)
VALUES
  (?, ?, ?)

INSERT INTO payment (cash, date, shop_id) VALUES ('53000', '2026-05-14', 3156);

INSERT INTO purchase (item_number, carton_number, totalitemvalue, totalctnsvalue, totalvalue, box_number, bottle_number, totalboxvalue, sac_number, totalsacvalue, totalbottlevalue, pricectn, pricesac, pricebtl, pricebox, priceitem, id_brand_id, invoice_id, id_brand_cashvan_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  "0"
  "0"
  0.0
  0.0
  53000.0
  "5"
  "0"
  "53000"
  "0"
  0.0
  0.0
  524500.0
  0.0
  0.0
  10600.0
  0.0
  50
  20989
  null
]

INSERT INTO purchase (
  item_number, carton_number, totalitemvalue,
  totalctnsvalue, totalvalue, box_number,
  bottle_number, totalboxvalue, sac_number,
  totalsacvalue, totalbottlevalue,
  pricectn, pricesac, pricebtl, pricebox,
  priceitem, id_brand_id, invoice_id,
  id_brand_cashvan_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

INSERT INTO purchase (item_number, carton_number, totalitemvalue, totalctnsvalue, totalvalue, box_number, bottle_number, totalboxvalue, sac_number, totalsacvalue, totalbottlevalue, pricectn, pricesac, pricebtl, pricebox, priceitem, id_brand_id, invoice_id, id_brand_cashvan_id) VALUES ('0', '0', 0, 0, 53000, '5', '0', '53000', '0', 0, 0, 524500, 0, 0, 10600, 0, 50, 20989, NULL);

"COMMIT"

[]

"COMMIT"

"COMMIT";