Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nombre_colis_total AS nombre_colis_total_2,
  t0.numero_dae AS numero_dae_3,
  t0.assurance_livraison AS assurance_livraison_4,
  t0.emballage_livraison AS emballage_livraison_5,
  t0.fichier_facture AS fichier_facture_6,
  t0.numero_facture AS numero_facture_7,
  t0.montant_total_facture AS montant_total_facture_8,
  t0.date_debut_fenetre AS date_debut_fenetre_9,
  t0.date_fin_fenetre AS date_fin_fenetre_10,
  t0.date_commande_soumission AS date_commande_soumission_11,
  t0.code_postal_livraison AS code_postal_livraison_12,
  t0.ville_livraison AS ville_livraison_13,
  t0.adresse_livraison AS adresse_livraison_14,
  t0.complement_adresse_livraison AS complement_adresse_livraison_15,
  t0.etat_us AS etat_us_16,
  t0.state AS state_17,
  t0.observation AS observation_18,
  t0.province AS province_19,
  t0.nombre_bouteille_rouge AS nombre_bouteille_rouge_20,
  t0.nombre_bouteille_blanc AS nombre_bouteille_blanc_21,
  t0.nombre_bouteille_petillant AS nombre_bouteille_petillant_22,
  t0.token AS token_23,
  t0.fedex_pdf_generated AS fedex_pdf_generated_24,
  t0.is_temporaire AS is_temporaire_25,
  t0.is_validee_par_client AS is_validee_par_client_26,
  t0.commande_massive AS commande_massive_27,
  t0.date_collecte AS date_collecte_28,
  t0.nombre_magnum_rouge AS nombre_magnum_rouge_29,
  t0.nombre_magnum_blanc AS nombre_magnum_blanc_30,
  t0.nombre_magnum_petillant AS nombre_magnum_petillant_31,
  t0.tracking_number AS tracking_number_32,
  t0.fedex_pdf_available AS fedex_pdf_available_33,
  t0.ship_date AS ship_date_34,
  t0.prior_url AS prior_url_35,
  t0.type_emballage AS type_emballage_36,
  t0.individual_tracking_numbers AS individual_tracking_numbers_37,
  t0.fast_pickup AS fast_pickup_38,
  t0.fichier_facture_pro_forma AS fichier_facture_pro_forma_39,
  t0.pro_forma AS pro_forma_40,
  t0.dap AS dap_41,
  t0.service_priority AS service_priority_42,
  t0.client_id AS client_id_43,
  t0.client_final_id AS client_final_id_44
FROM
  commande t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre_colis_total AS nombre_colis_total_2, t0.numero_dae AS numero_dae_3, t0.assurance_livraison AS assurance_livraison_4, t0.emballage_livraison AS emballage_livraison_5, t0.fichier_facture AS fichier_facture_6, t0.numero_facture AS numero_facture_7, t0.montant_total_facture AS montant_total_facture_8, t0.date_debut_fenetre AS date_debut_fenetre_9, t0.date_fin_fenetre AS date_fin_fenetre_10, t0.date_commande_soumission AS date_commande_soumission_11, t0.code_postal_livraison AS code_postal_livraison_12, t0.ville_livraison AS ville_livraison_13, t0.adresse_livraison AS adresse_livraison_14, t0.complement_adresse_livraison AS complement_adresse_livraison_15, t0.etat_us AS etat_us_16, t0.state AS state_17, t0.observation AS observation_18, t0.province AS province_19, t0.nombre_bouteille_rouge AS nombre_bouteille_rouge_20, t0.nombre_bouteille_blanc AS nombre_bouteille_blanc_21, t0.nombre_bouteille_petillant AS nombre_bouteille_petillant_22, t0.token AS token_23, t0.fedex_pdf_generated AS fedex_pdf_generated_24, t0.is_temporaire AS is_temporaire_25, t0.is_validee_par_client AS is_validee_par_client_26, t0.commande_massive AS commande_massive_27, t0.date_collecte AS date_collecte_28, t0.nombre_magnum_rouge AS nombre_magnum_rouge_29, t0.nombre_magnum_blanc AS nombre_magnum_blanc_30, t0.nombre_magnum_petillant AS nombre_magnum_petillant_31, t0.tracking_number AS tracking_number_32, t0.fedex_pdf_available AS fedex_pdf_available_33, t0.ship_date AS ship_date_34, t0.prior_url AS prior_url_35, t0.type_emballage AS type_emballage_36, t0.individual_tracking_numbers AS individual_tracking_numbers_37, t0.fast_pickup AS fast_pickup_38, t0.fichier_facture_pro_forma AS fichier_facture_pro_forma_39, t0.pro_forma AS pro_forma_40, t0.dap AS dap_41, t0.service_priority AS service_priority_42, t0.client_id AS client_id_43, t0.client_final_id AS client_final_id_44 FROM commande t0 WHERE t0.id = 7738;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.telephone AS telephone_3,
  t0.prenom AS prenom_4,
  t0.nom AS nom_5,
  t0.full_name AS full_name_6,
  t7.id AS id_8,
  t7.nombre_colis_total AS nombre_colis_total_9,
  t7.numero_dae AS numero_dae_10,
  t7.assurance_livraison AS assurance_livraison_11,
  t7.emballage_livraison AS emballage_livraison_12,
  t7.fichier_facture AS fichier_facture_13,
  t7.numero_facture AS numero_facture_14,
  t7.montant_total_facture AS montant_total_facture_15,
  t7.date_debut_fenetre AS date_debut_fenetre_16,
  t7.date_fin_fenetre AS date_fin_fenetre_17,
  t7.date_commande_soumission AS date_commande_soumission_18,
  t7.code_postal_livraison AS code_postal_livraison_19,
  t7.ville_livraison AS ville_livraison_20,
  t7.adresse_livraison AS adresse_livraison_21,
  t7.complement_adresse_livraison AS complement_adresse_livraison_22,
  t7.etat_us AS etat_us_23,
  t7.state AS state_24,
  t7.observation AS observation_25,
  t7.province AS province_26,
  t7.nombre_bouteille_rouge AS nombre_bouteille_rouge_27,
  t7.nombre_bouteille_blanc AS nombre_bouteille_blanc_28,
  t7.nombre_bouteille_petillant AS nombre_bouteille_petillant_29,
  t7.token AS token_30,
  t7.fedex_pdf_generated AS fedex_pdf_generated_31,
  t7.is_temporaire AS is_temporaire_32,
  t7.is_validee_par_client AS is_validee_par_client_33,
  t7.commande_massive AS commande_massive_34,
  t7.date_collecte AS date_collecte_35,
  t7.nombre_magnum_rouge AS nombre_magnum_rouge_36,
  t7.nombre_magnum_blanc AS nombre_magnum_blanc_37,
  t7.nombre_magnum_petillant AS nombre_magnum_petillant_38,
  t7.tracking_number AS tracking_number_39,
  t7.fedex_pdf_available AS fedex_pdf_available_40,
  t7.ship_date AS ship_date_41,
  t7.prior_url AS prior_url_42,
  t7.type_emballage AS type_emballage_43,
  t7.individual_tracking_numbers AS individual_tracking_numbers_44,
  t7.fast_pickup AS fast_pickup_45,
  t7.fichier_facture_pro_forma AS fichier_facture_pro_forma_46,
  t7.pro_forma AS pro_forma_47,
  t7.dap AS dap_48,
  t7.service_priority AS service_priority_49,
  t7.client_id AS client_id_50,
  t7.client_final_id AS client_final_id_51
FROM
  client_final t0
  LEFT JOIN commande t7 ON t7.client_final_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.telephone AS telephone_3, t0.prenom AS prenom_4, t0.nom AS nom_5, t0.full_name AS full_name_6, t7.id AS id_8, t7.nombre_colis_total AS nombre_colis_total_9, t7.numero_dae AS numero_dae_10, t7.assurance_livraison AS assurance_livraison_11, t7.emballage_livraison AS emballage_livraison_12, t7.fichier_facture AS fichier_facture_13, t7.numero_facture AS numero_facture_14, t7.montant_total_facture AS montant_total_facture_15, t7.date_debut_fenetre AS date_debut_fenetre_16, t7.date_fin_fenetre AS date_fin_fenetre_17, t7.date_commande_soumission AS date_commande_soumission_18, t7.code_postal_livraison AS code_postal_livraison_19, t7.ville_livraison AS ville_livraison_20, t7.adresse_livraison AS adresse_livraison_21, t7.complement_adresse_livraison AS complement_adresse_livraison_22, t7.etat_us AS etat_us_23, t7.state AS state_24, t7.observation AS observation_25, t7.province AS province_26, t7.nombre_bouteille_rouge AS nombre_bouteille_rouge_27, t7.nombre_bouteille_blanc AS nombre_bouteille_blanc_28, t7.nombre_bouteille_petillant AS nombre_bouteille_petillant_29, t7.token AS token_30, t7.fedex_pdf_generated AS fedex_pdf_generated_31, t7.is_temporaire AS is_temporaire_32, t7.is_validee_par_client AS is_validee_par_client_33, t7.commande_massive AS commande_massive_34, t7.date_collecte AS date_collecte_35, t7.nombre_magnum_rouge AS nombre_magnum_rouge_36, t7.nombre_magnum_blanc AS nombre_magnum_blanc_37, t7.nombre_magnum_petillant AS nombre_magnum_petillant_38, t7.tracking_number AS tracking_number_39, t7.fedex_pdf_available AS fedex_pdf_available_40, t7.ship_date AS ship_date_41, t7.prior_url AS prior_url_42, t7.type_emballage AS type_emballage_43, t7.individual_tracking_numbers AS individual_tracking_numbers_44, t7.fast_pickup AS fast_pickup_45, t7.fichier_facture_pro_forma AS fichier_facture_pro_forma_46, t7.pro_forma AS pro_forma_47, t7.dap AS dap_48, t7.service_priority AS service_priority_49, t7.client_id AS client_id_50, t7.client_final_id AS client_final_id_51 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 10217;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  commande
SET
  adresse_livraison = ?,
  complement_adresse_livraison = ?
WHERE
  id = ?

UPDATE commande SET adresse_livraison = '1402 American Eagle Drive', complement_adresse_livraison = NULL WHERE id = 7738;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  commande
SET
  adresse_livraison = ?,
  complement_adresse_livraison = ?,
  state = ?,
  is_validee_par_client = ?
WHERE
  id = ?

UPDATE commande SET adresse_livraison = '1402 American Eagle Drive ', complement_adresse_livraison = '', state = 'attente_pec_transporteur', is_validee_par_client = 1 WHERE id = 7738;

"COMMIT"

"COMMIT";