https://wine.mbebordeaux.fr/commande/438/client?page=4

Query Metrics

19 Database Queries
5 Different statements
30.13 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.94 ms
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 = ?
Parameters:
[
  90
]
2 0.90 ms
SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.id_client_mbehub AS id_client_mbehub_3, t0.nom_contact AS nom_contact_4, t0.prenom_contact AS prenom_contact_5, t0.email_contact AS email_contact_6, t0.telephone_contact AS telephone_contact_7, t0.assurance_defaut AS assurance_defaut_8, t0.emballage_defaut AS emballage_defaut_9, t0.code_postal AS code_postal_10, t0.ville AS ville_11, t0.adresse AS adresse_12, t0.eori AS eori_13, t0.fast_pickup AS fast_pickup_14, t15.id AS id_16, t15.email AS email_17, t15.roles AS roles_18, t15.password AS password_19, t15.is_first_connexion AS is_first_connexion_20, t15.compte_id AS compte_id_21, t15.client_id AS client_id_22 FROM client t0 LEFT JOIN user t15 ON t15.client_id = t0.id WHERE t0.id = ?
Parameters:
[
  "438"
]
3 2.47 ms
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.client_id = ?
Parameters:
[
  438
]
4 1.09 ms
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.email AS email_4, t5.id AS id_6, t5.email AS email_7, t5.roles AS roles_8, t5.password AS password_9, t5.is_first_connexion AS is_first_connexion_10, t5.compte_id AS compte_id_11, t5.client_id AS client_id_12 FROM compte t0 LEFT JOIN user t5 ON t5.compte_id = t0.id WHERE t0.id = ?
Parameters:
[
  18
]
5 1.90 ms
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 = ?
Parameters:
[
  8049
]
6 1.53 ms
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 = ?
Parameters:
[
  8206
]
7 1.17 ms
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 = ?
Parameters:
[
  8224
]
8 1.40 ms
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 = ?
Parameters:
[
  8517
]
9 1.84 ms
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 = ?
Parameters:
[
  8557
]
10 1.32 ms
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 = ?
Parameters:
[
  8813
]
11 1.47 ms
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 = ?
Parameters:
[
  8900
]
12 1.28 ms
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 = ?
Parameters:
[
  8932
]
13 1.32 ms
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 = ?
Parameters:
[
  9067
]
14 1.54 ms
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 = ?
Parameters:
[
  9242
]
15 1.53 ms
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 = ?
Parameters:
[
  9924
]
16 1.45 ms
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 = ?
Parameters:
[
  9982
]
17 4.51 ms
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 = ?
Parameters:
[
  10146
]
18 1.21 ms
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 = ?
Parameters:
[
  10147
]
19 1.25 ms
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 = ?
Parameters:
[
  10221
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Compte No errors.
App\Entity\Client No errors.
App\Entity\StockBandeau No errors.
App\Entity\Commande No errors.
App\Entity\ClientFinal No errors.
App\Entity\Colis No errors.