Symfony Profiler

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 = 31;

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 = 29;

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 = 4336;

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/SEP/%'
          AND sales_id = 29
    ;

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 = '0001 - Macaroni Champion (5 Kg) Spiral' 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

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 = 178 AND t0.invoice_id = NULL 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 = ?
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 = ' Benny Food Chicken (42 Pcs*8 Pqt)' 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

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 = 8 AND t0.invoice_id = NULL 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 = ?
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 = 'Macaroni Champion Fusilli ( 5 Kg )' 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

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 = 206 AND t0.invoice_id = NULL LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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-09-03 10:52:18', '2026/SEP/CASHVAN-4Hery/10', 343600, -18.9371739, 47.5252405, 343600, 0, 0, 29, 4336);

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

INSERT INTO payment (cash, date, shop_id) VALUES ('343600', '2026-09-03', 4336);

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, 284400, '0', '0', '0', '12', 284400, 0, 0, 23700, 0, 0, 0, 178, 28074, 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, 11800, '1', '0', '11800', '0', 0, 0, 93900, 0, 0, 11800, 0, 8, 28074, 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, 47400, '0', '0', '0', '2', 47400, 0, 0, 23700, 0, 0, 0, 206, 28074, NULL);

"COMMIT"

"COMMIT";