Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_first_connexion AS is_first_connexion_5,
  t0.compte_id AS compte_id_6,
  t0.client_id AS client_id_7
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.is_first_connexion AS is_first_connexion_5, t0.compte_id AS compte_id_6, t0.client_id AS client_id_7 FROM user t0 WHERE t0.id = 190;

SELECT
  c0_.id AS id_0,
  c0_.nombre_colis_total AS nombre_colis_total_1,
  c0_.numero_dae AS numero_dae_2,
  c0_.assurance_livraison AS assurance_livraison_3,
  c0_.emballage_livraison AS emballage_livraison_4,
  c0_.fichier_facture AS fichier_facture_5,
  c0_.numero_facture AS numero_facture_6,
  c0_.montant_total_facture AS montant_total_facture_7,
  c0_.date_debut_fenetre AS date_debut_fenetre_8,
  c0_.date_fin_fenetre AS date_fin_fenetre_9,
  c0_.date_commande_soumission AS date_commande_soumission_10,
  c0_.code_postal_livraison AS code_postal_livraison_11,
  c0_.ville_livraison AS ville_livraison_12,
  c0_.adresse_livraison AS adresse_livraison_13,
  c0_.complement_adresse_livraison AS complement_adresse_livraison_14,
  c0_.etat_us AS etat_us_15,
  c0_.state AS state_16,
  c0_.observation AS observation_17,
  c0_.province AS province_18,
  c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19,
  c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20,
  c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21,
  c0_.token AS token_22,
  c0_.fedex_pdf_generated AS fedex_pdf_generated_23,
  c0_.is_temporaire AS is_temporaire_24,
  c0_.is_validee_par_client AS is_validee_par_client_25,
  c0_.commande_massive AS commande_massive_26,
  c0_.date_collecte AS date_collecte_27,
  c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28,
  c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29,
  c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30,
  c0_.tracking_number AS tracking_number_31,
  c0_.fedex_pdf_available AS fedex_pdf_available_32,
  c0_.ship_date AS ship_date_33,
  c0_.prior_url AS prior_url_34,
  c0_.type_emballage AS type_emballage_35,
  c0_.individual_tracking_numbers AS individual_tracking_numbers_36,
  c0_.fast_pickup AS fast_pickup_37,
  c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38,
  c0_.pro_forma AS pro_forma_39,
  c0_.dap AS dap_40,
  c0_.service_priority AS service_priority_41,
  c0_.client_id AS client_id_42,
  c0_.client_final_id AS client_final_id_43
FROM
  commande c0_
WHERE
  c0_.client_id = ?
  AND c0_.is_temporaire = ?

SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.client_id AS client_id_42, c0_.client_final_id AS client_final_id_43 FROM commande c0_ WHERE c0_.client_id = 373 AND c0_.is_temporaire = 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO client_final (
  email, telephone, prenom, nom, full_name
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO client_final (email, telephone, prenom, nom, full_name) VALUES ('cynthia.pope91@yahoo.com', '9402065229', NULL, NULL, 'POPE CYNTHIA');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO commande (
  nombre_colis_total, numero_dae, assurance_livraison,
  emballage_livraison, fichier_facture,
  numero_facture, montant_total_facture,
  date_debut_fenetre, date_fin_fenetre,
  date_commande_soumission, code_postal_livraison,
  ville_livraison, adresse_livraison,
  complement_adresse_livraison, etat_us,
  state, observation, province, nombre_bouteille_rouge,
  nombre_bouteille_blanc, nombre_bouteille_petillant,
  token, fedex_pdf_generated, is_temporaire,
  is_validee_par_client, commande_massive,
  date_collecte, nombre_magnum_rouge,
  nombre_magnum_blanc, nombre_magnum_petillant,
  tracking_number, fedex_pdf_available,
  ship_date, prior_url, type_emballage,
  individual_tracking_numbers, fast_pickup,
  fichier_facture_pro_forma, pro_forma,
  dap, service_priority, client_id,
  client_final_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO commande (nombre_colis_total, numero_dae, assurance_livraison, emballage_livraison, fichier_facture, numero_facture, montant_total_facture, date_debut_fenetre, date_fin_fenetre, date_commande_soumission, code_postal_livraison, ville_livraison, adresse_livraison, complement_adresse_livraison, etat_us, state, observation, province, nombre_bouteille_rouge, nombre_bouteille_blanc, nombre_bouteille_petillant, token, fedex_pdf_generated, is_temporaire, is_validee_par_client, commande_massive, date_collecte, nombre_magnum_rouge, nombre_magnum_blanc, nombre_magnum_petillant, tracking_number, fedex_pdf_available, ship_date, prior_url, type_emballage, individual_tracking_numbers, fast_pickup, fichier_facture_pro_forma, pro_forma, dap, service_priority, client_id, client_final_id) VALUES (1, '', 0, 1, 'facture_190_68555ceb41f4b.pdf', 'FA2294', 82, NULL, NULL, '2025-06-20', '76259', 'PONDER', '144 January Lane', '', 'TX', 'emballage_caviste', '', 'Texas', 4, 2, 0, 'gsrefgrdsgfres', 0, 1, 0, 0, '2025-06-27', 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 373, 10281);

INSERT INTO client_final (
  email, telephone, prenom, nom, full_name
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO client_final (email, telephone, prenom, nom, full_name) VALUES ('cynthia.pope91@yahoo.com', '9402065229', NULL, NULL, 'POPE CYNTHIA');

INSERT INTO colis (nombre_bouteille, commande_id)
VALUES
  (?, ?)

INSERT INTO colis (nombre_bouteille, commande_id) VALUES (6, 7771);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";