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 = ?
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 = 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 = ?
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 = '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 = ?
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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 10221;
|