Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.password_changed AS password_changed_5,
  t0.last_password_change AS last_password_change_6,
  t0.temporary_password_count AS temporary_password_count_7,
  t0.plain_password AS plain_password_8,
  t0.password_reset_token AS password_reset_token_9
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.password_changed AS password_changed_5, t0.last_password_change AS last_password_change_6, t0.temporary_password_count AS temporary_password_count_7, t0.plain_password AS plain_password_8, t0.password_reset_token AS password_reset_token_9 FROM user t0 WHERE t0.id = 39;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.rue AS rue_3,
  t0.code_postal AS code_postal_4,
  t0.ville AS ville_5
FROM
  agences t0
  INNER JOIN agences_users ON t0.id = agences_users.agences_id
WHERE
  agences_users.user_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.rue AS rue_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5 FROM agences t0 INNER JOIN agences_users ON t0.id = agences_users.agences_id WHERE agences_users.user_id = 39;

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.designation AS designation_2,
  p0_.prix AS prix_3,
  p0_.poids AS poids_4,
  p0_.stock AS stock_5,
  p0_.image_name AS image_name_6,
  p0_.image_size AS image_size_7,
  p0_.updated_at AS updated_at_8,
  p0_.statut AS statut_9,
  p0_.quantite AS quantite_10,
  p0_.montant_lot AS montant_lot_11,
  p0_.cout_transport AS cout_transport_12,
  p0_.is_active AS is_active_13,
  p0_.category AS category_14,
  p0_.type_de_produit AS type_de_produit_15,
  p0_.stock_minimum AS stock_minimum_16,
  p0_.receive_start AS receive_start_17,
  p0_.max_quantity AS max_quantity_18,
  p0_.stock_alert_sent AS stock_alert_sent_19,
  p0_.commande_id AS commande_id_20
FROM
  produit p0_
WHERE
  p0_.is_active = ?
  AND p0_.stock > 0
ORDER BY
  p0_.reference ASC

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.designation AS designation_2, p0_.prix AS prix_3, p0_.poids AS poids_4, p0_.stock AS stock_5, p0_.image_name AS image_name_6, p0_.image_size AS image_size_7, p0_.updated_at AS updated_at_8, p0_.statut AS statut_9, p0_.quantite AS quantite_10, p0_.montant_lot AS montant_lot_11, p0_.cout_transport AS cout_transport_12, p0_.is_active AS is_active_13, p0_.category AS category_14, p0_.type_de_produit AS type_de_produit_15, p0_.stock_minimum AS stock_minimum_16, p0_.receive_start AS receive_start_17, p0_.max_quantity AS max_quantity_18, p0_.stock_alert_sent AS stock_alert_sent_19, p0_.commande_id AS commande_id_20 FROM produit p0_ WHERE p0_.is_active = 0 AND p0_.stock > 0 ORDER BY p0_.reference ASC;

SELECT
  a0_.id AS id_0,
  a0_.nom AS nom_1,
  a0_.rue AS rue_2,
  a0_.code_postal AS code_postal_3,
  a0_.ville AS ville_4
FROM
  agences a0_
WHERE
  a0_.id IN (?)
ORDER BY
  a0_.nom ASC

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.rue AS rue_2, a0_.code_postal AS code_postal_3, a0_.ville AS ville_4 FROM agences a0_ WHERE a0_.id IN ('7') ORDER BY a0_.nom ASC;

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.designation AS designation_2,
  p0_.prix AS prix_3,
  p0_.poids AS poids_4,
  p0_.stock AS stock_5,
  p0_.image_name AS image_name_6,
  p0_.image_size AS image_size_7,
  p0_.updated_at AS updated_at_8,
  p0_.statut AS statut_9,
  p0_.quantite AS quantite_10,
  p0_.montant_lot AS montant_lot_11,
  p0_.cout_transport AS cout_transport_12,
  p0_.is_active AS is_active_13,
  p0_.category AS category_14,
  p0_.type_de_produit AS type_de_produit_15,
  p0_.stock_minimum AS stock_minimum_16,
  p0_.receive_start AS receive_start_17,
  p0_.max_quantity AS max_quantity_18,
  p0_.stock_alert_sent AS stock_alert_sent_19,
  p0_.commande_id AS commande_id_20
FROM
  produit p0_
WHERE
  p0_.is_active = ?
  AND p0_.stock > 0
ORDER BY
  p0_.reference ASC

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.designation AS designation_2, p0_.prix AS prix_3, p0_.poids AS poids_4, p0_.stock AS stock_5, p0_.image_name AS image_name_6, p0_.image_size AS image_size_7, p0_.updated_at AS updated_at_8, p0_.statut AS statut_9, p0_.quantite AS quantite_10, p0_.montant_lot AS montant_lot_11, p0_.cout_transport AS cout_transport_12, p0_.is_active AS is_active_13, p0_.category AS category_14, p0_.type_de_produit AS type_de_produit_15, p0_.stock_minimum AS stock_minimum_16, p0_.receive_start AS receive_start_17, p0_.max_quantity AS max_quantity_18, p0_.stock_alert_sent AS stock_alert_sent_19, p0_.commande_id AS commande_id_20 FROM produit p0_ WHERE p0_.is_active = 0 AND p0_.stock > 0 ORDER BY p0_.reference ASC;

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.designation AS designation_2,
  p0_.prix AS prix_3,
  p0_.poids AS poids_4,
  p0_.stock AS stock_5,
  p0_.image_name AS image_name_6,
  p0_.image_size AS image_size_7,
  p0_.updated_at AS updated_at_8,
  p0_.statut AS statut_9,
  p0_.quantite AS quantite_10,
  p0_.montant_lot AS montant_lot_11,
  p0_.cout_transport AS cout_transport_12,
  p0_.is_active AS is_active_13,
  p0_.category AS category_14,
  p0_.type_de_produit AS type_de_produit_15,
  p0_.stock_minimum AS stock_minimum_16,
  p0_.receive_start AS receive_start_17,
  p0_.max_quantity AS max_quantity_18,
  p0_.stock_alert_sent AS stock_alert_sent_19,
  p0_.commande_id AS commande_id_20
FROM
  produit p0_
WHERE
  p0_.is_active = ?
  AND p0_.stock > 0
ORDER BY
  p0_.reference ASC

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.designation AS designation_2, p0_.prix AS prix_3, p0_.poids AS poids_4, p0_.stock AS stock_5, p0_.image_name AS image_name_6, p0_.image_size AS image_size_7, p0_.updated_at AS updated_at_8, p0_.statut AS statut_9, p0_.quantite AS quantite_10, p0_.montant_lot AS montant_lot_11, p0_.cout_transport AS cout_transport_12, p0_.is_active AS is_active_13, p0_.category AS category_14, p0_.type_de_produit AS type_de_produit_15, p0_.stock_minimum AS stock_minimum_16, p0_.receive_start AS receive_start_17, p0_.max_quantity AS max_quantity_18, p0_.stock_alert_sent AS stock_alert_sent_19, p0_.commande_id AS commande_id_20 FROM produit p0_ WHERE p0_.is_active = 0 AND p0_.stock > 0 ORDER BY p0_.reference ASC;

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.designation AS designation_2,
  p0_.prix AS prix_3,
  p0_.poids AS poids_4,
  p0_.stock AS stock_5,
  p0_.image_name AS image_name_6,
  p0_.image_size AS image_size_7,
  p0_.updated_at AS updated_at_8,
  p0_.statut AS statut_9,
  p0_.quantite AS quantite_10,
  p0_.montant_lot AS montant_lot_11,
  p0_.cout_transport AS cout_transport_12,
  p0_.is_active AS is_active_13,
  p0_.category AS category_14,
  p0_.type_de_produit AS type_de_produit_15,
  p0_.stock_minimum AS stock_minimum_16,
  p0_.receive_start AS receive_start_17,
  p0_.max_quantity AS max_quantity_18,
  p0_.stock_alert_sent AS stock_alert_sent_19,
  p0_.commande_id AS commande_id_20
FROM
  produit p0_
WHERE
  p0_.is_active = ?
  AND p0_.stock > 0
ORDER BY
  p0_.reference ASC

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.designation AS designation_2, p0_.prix AS prix_3, p0_.poids AS poids_4, p0_.stock AS stock_5, p0_.image_name AS image_name_6, p0_.image_size AS image_size_7, p0_.updated_at AS updated_at_8, p0_.statut AS statut_9, p0_.quantite AS quantite_10, p0_.montant_lot AS montant_lot_11, p0_.cout_transport AS cout_transport_12, p0_.is_active AS is_active_13, p0_.category AS category_14, p0_.type_de_produit AS type_de_produit_15, p0_.stock_minimum AS stock_minimum_16, p0_.receive_start AS receive_start_17, p0_.max_quantity AS max_quantity_18, p0_.stock_alert_sent AS stock_alert_sent_19, p0_.commande_id AS commande_id_20 FROM produit p0_ WHERE p0_.is_active = 0 AND p0_.stock > 0 ORDER BY p0_.reference ASC;

SELECT
  MAX(c0_.numeros) AS sclr_0
FROM
  commande c0_

SELECT MAX(c0_.numeros) AS sclr_0 FROM commande c0_;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO commande (
  numeros, objet, statut, autre_choix,
  suivi_envoi, quantities, created_at,
  status_date, instruction_detail,
  agency_id, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO commande (numeros, objet, statut, autre_choix, suivi_envoi, quantities, created_at, status_date, instruction_detail, agency_id, user_id) VALUES (174, 'POUR KAWASAKI avignon', 'warning', NULL, NULL, '[]', '2026-04-29 15:35:05', NULL, 'PLANETE JMS MOTOS : 1 BIS ROUTE DE MORIERES 84000 AVIGNON', 7, 39);

INSERT INTO order_line (quantity, command_id, product_id)
VALUES
  (?, ?, ?)

INSERT INTO order_line (quantity, command_id, product_id) VALUES (5, 279, 2);

INSERT INTO order_line (quantity, command_id, product_id)
VALUES
  (?, ?, ?)

INSERT INTO order_line (quantity, command_id, product_id) VALUES (2, 279, 17);

INSERT INTO order_line (quantity, command_id, product_id)
VALUES
  (?, ?, ?)

INSERT INTO order_line (quantity, command_id, product_id) VALUES (5, 279, 2);

UPDATE
  produit
SET
  stock = ?
WHERE
  id = ?

UPDATE produit SET stock = 200 WHERE id = 2;

UPDATE
  produit
SET
  stock = ?
WHERE
  id = ?

UPDATE produit SET stock = 1950 WHERE id = 17;

"COMMIT"

"COMMIT";