| 1 |
1.14 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 = 219;
|
| 2 |
3.25 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.commande_id_presta AS commande_id_presta_43, t0.client_id AS client_id_44, t0.client_final_id AS client_final_id_45 FROM commande t0 WHERE t0.client_id = ? ORDER BY t0.date_collecte DESC
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.commande_id_presta AS commande_id_presta_43,
t0.client_id AS client_id_44,
t0.client_final_id AS client_final_id_45
FROM
commande t0
WHERE
t0.client_id = ?
ORDER BY
t0.date_collecte DESC
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.commande_id_presta AS commande_id_presta_43, t0.client_id AS client_id_44, t0.client_final_id AS client_final_id_45 FROM commande t0 WHERE t0.client_id = 402 ORDER BY t0.date_collecte DESC;
|
| 3 |
2.22 ms |
SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.commande_id_presta AS commande_id_presta_42, c0_.client_id AS client_id_43, c0_.client_final_id AS client_final_id_44 FROM commande c0_ WHERE c0_.state = ? AND c0_.emballage_livraison = ? AND c0_.client_id = ? AND c0_.is_temporaire = ? ORDER BY c0_.date_collecte ASC
Parameters: [
"emballage_caviste"
0
402
0
]
SELECT
c0_.id AS id_0,
c0_.nombre_colis_total AS nombre_colis_total_1,
c0_.numero_dae AS numero_dae_2,
c0_.assurance_livraison AS assurance_livraison_3,
c0_.emballage_livraison AS emballage_livraison_4,
c0_.fichier_facture AS fichier_facture_5,
c0_.numero_facture AS numero_facture_6,
c0_.montant_total_facture AS montant_total_facture_7,
c0_.date_debut_fenetre AS date_debut_fenetre_8,
c0_.date_fin_fenetre AS date_fin_fenetre_9,
c0_.date_commande_soumission AS date_commande_soumission_10,
c0_.code_postal_livraison AS code_postal_livraison_11,
c0_.ville_livraison AS ville_livraison_12,
c0_.adresse_livraison AS adresse_livraison_13,
c0_.complement_adresse_livraison AS complement_adresse_livraison_14,
c0_.etat_us AS etat_us_15,
c0_.state AS state_16,
c0_.observation AS observation_17,
c0_.province AS province_18,
c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19,
c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20,
c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21,
c0_.token AS token_22,
c0_.fedex_pdf_generated AS fedex_pdf_generated_23,
c0_.is_temporaire AS is_temporaire_24,
c0_.is_validee_par_client AS is_validee_par_client_25,
c0_.commande_massive AS commande_massive_26,
c0_.date_collecte AS date_collecte_27,
c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28,
c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29,
c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30,
c0_.tracking_number AS tracking_number_31,
c0_.fedex_pdf_available AS fedex_pdf_available_32,
c0_.ship_date AS ship_date_33,
c0_.prior_url AS prior_url_34,
c0_.type_emballage AS type_emballage_35,
c0_.individual_tracking_numbers AS individual_tracking_numbers_36,
c0_.fast_pickup AS fast_pickup_37,
c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38,
c0_.pro_forma AS pro_forma_39,
c0_.dap AS dap_40,
c0_.service_priority AS service_priority_41,
c0_.commande_id_presta AS commande_id_presta_42,
c0_.client_id AS client_id_43,
c0_.client_final_id AS client_final_id_44
FROM
commande c0_
WHERE
c0_.state = ?
AND c0_.emballage_livraison = ?
AND c0_.client_id = ?
AND c0_.is_temporaire = ?
ORDER BY
c0_.date_collecte ASC
SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.commande_id_presta AS commande_id_presta_42, c0_.client_id AS client_id_43, c0_.client_final_id AS client_final_id_44 FROM commande c0_ WHERE c0_.state = 'emballage_caviste' AND c0_.emballage_livraison = 0 AND c0_.client_id = 402 AND c0_.is_temporaire = 0 ORDER BY c0_.date_collecte ASC;
|
| 4 |
1.67 ms |
SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.commande_id_presta AS commande_id_presta_42, c0_.client_id AS client_id_43, c0_.client_final_id AS client_final_id_44 FROM commande c0_ WHERE c0_.state = ? AND c0_.emballage_livraison = ? AND c0_.client_id = ? AND c0_.is_temporaire = ? ORDER BY c0_.date_collecte ASC
Parameters: [
"preparation"
0
402
0
]
SELECT
c0_.id AS id_0,
c0_.nombre_colis_total AS nombre_colis_total_1,
c0_.numero_dae AS numero_dae_2,
c0_.assurance_livraison AS assurance_livraison_3,
c0_.emballage_livraison AS emballage_livraison_4,
c0_.fichier_facture AS fichier_facture_5,
c0_.numero_facture AS numero_facture_6,
c0_.montant_total_facture AS montant_total_facture_7,
c0_.date_debut_fenetre AS date_debut_fenetre_8,
c0_.date_fin_fenetre AS date_fin_fenetre_9,
c0_.date_commande_soumission AS date_commande_soumission_10,
c0_.code_postal_livraison AS code_postal_livraison_11,
c0_.ville_livraison AS ville_livraison_12,
c0_.adresse_livraison AS adresse_livraison_13,
c0_.complement_adresse_livraison AS complement_adresse_livraison_14,
c0_.etat_us AS etat_us_15,
c0_.state AS state_16,
c0_.observation AS observation_17,
c0_.province AS province_18,
c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19,
c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20,
c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21,
c0_.token AS token_22,
c0_.fedex_pdf_generated AS fedex_pdf_generated_23,
c0_.is_temporaire AS is_temporaire_24,
c0_.is_validee_par_client AS is_validee_par_client_25,
c0_.commande_massive AS commande_massive_26,
c0_.date_collecte AS date_collecte_27,
c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28,
c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29,
c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30,
c0_.tracking_number AS tracking_number_31,
c0_.fedex_pdf_available AS fedex_pdf_available_32,
c0_.ship_date AS ship_date_33,
c0_.prior_url AS prior_url_34,
c0_.type_emballage AS type_emballage_35,
c0_.individual_tracking_numbers AS individual_tracking_numbers_36,
c0_.fast_pickup AS fast_pickup_37,
c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38,
c0_.pro_forma AS pro_forma_39,
c0_.dap AS dap_40,
c0_.service_priority AS service_priority_41,
c0_.commande_id_presta AS commande_id_presta_42,
c0_.client_id AS client_id_43,
c0_.client_final_id AS client_final_id_44
FROM
commande c0_
WHERE
c0_.state = ?
AND c0_.emballage_livraison = ?
AND c0_.client_id = ?
AND c0_.is_temporaire = ?
ORDER BY
c0_.date_collecte ASC
SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.commande_id_presta AS commande_id_presta_42, c0_.client_id AS client_id_43, c0_.client_final_id AS client_final_id_44 FROM commande c0_ WHERE c0_.state = 'preparation' AND c0_.emballage_livraison = 0 AND c0_.client_id = 402 AND c0_.is_temporaire = 0 ORDER BY c0_.date_collecte ASC;
|
| 5 |
1.59 ms |
SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.commande_id_presta AS commande_id_presta_42, c0_.client_id AS client_id_43, c0_.client_final_id AS client_final_id_44 FROM commande c0_ WHERE c0_.client_id = ? AND c0_.state = ? AND c0_.is_temporaire = ? ORDER BY c0_.date_collecte ASC
Parameters: [
402
"emballage_caviste"
0
]
SELECT
c0_.id AS id_0,
c0_.nombre_colis_total AS nombre_colis_total_1,
c0_.numero_dae AS numero_dae_2,
c0_.assurance_livraison AS assurance_livraison_3,
c0_.emballage_livraison AS emballage_livraison_4,
c0_.fichier_facture AS fichier_facture_5,
c0_.numero_facture AS numero_facture_6,
c0_.montant_total_facture AS montant_total_facture_7,
c0_.date_debut_fenetre AS date_debut_fenetre_8,
c0_.date_fin_fenetre AS date_fin_fenetre_9,
c0_.date_commande_soumission AS date_commande_soumission_10,
c0_.code_postal_livraison AS code_postal_livraison_11,
c0_.ville_livraison AS ville_livraison_12,
c0_.adresse_livraison AS adresse_livraison_13,
c0_.complement_adresse_livraison AS complement_adresse_livraison_14,
c0_.etat_us AS etat_us_15,
c0_.state AS state_16,
c0_.observation AS observation_17,
c0_.province AS province_18,
c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19,
c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20,
c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21,
c0_.token AS token_22,
c0_.fedex_pdf_generated AS fedex_pdf_generated_23,
c0_.is_temporaire AS is_temporaire_24,
c0_.is_validee_par_client AS is_validee_par_client_25,
c0_.commande_massive AS commande_massive_26,
c0_.date_collecte AS date_collecte_27,
c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28,
c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29,
c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30,
c0_.tracking_number AS tracking_number_31,
c0_.fedex_pdf_available AS fedex_pdf_available_32,
c0_.ship_date AS ship_date_33,
c0_.prior_url AS prior_url_34,
c0_.type_emballage AS type_emballage_35,
c0_.individual_tracking_numbers AS individual_tracking_numbers_36,
c0_.fast_pickup AS fast_pickup_37,
c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38,
c0_.pro_forma AS pro_forma_39,
c0_.dap AS dap_40,
c0_.service_priority AS service_priority_41,
c0_.commande_id_presta AS commande_id_presta_42,
c0_.client_id AS client_id_43,
c0_.client_final_id AS client_final_id_44
FROM
commande c0_
WHERE
c0_.client_id = ?
AND c0_.state = ?
AND c0_.is_temporaire = ?
ORDER BY
c0_.date_collecte ASC
SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.commande_id_presta AS commande_id_presta_42, c0_.client_id AS client_id_43, c0_.client_final_id AS client_final_id_44 FROM commande c0_ WHERE c0_.client_id = 402 AND c0_.state = 'emballage_caviste' AND c0_.is_temporaire = 0 ORDER BY c0_.date_collecte ASC;
|
| 6 |
1.53 ms |
SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.commande_id_presta AS commande_id_presta_42, c0_.client_id AS client_id_43, c0_.client_final_id AS client_final_id_44 FROM commande c0_ WHERE c0_.client_id = ? AND c0_.state = ? AND c0_.is_temporaire = ? ORDER BY c0_.date_collecte ASC
Parameters: [
402
"preparation"
0
]
SELECT
c0_.id AS id_0,
c0_.nombre_colis_total AS nombre_colis_total_1,
c0_.numero_dae AS numero_dae_2,
c0_.assurance_livraison AS assurance_livraison_3,
c0_.emballage_livraison AS emballage_livraison_4,
c0_.fichier_facture AS fichier_facture_5,
c0_.numero_facture AS numero_facture_6,
c0_.montant_total_facture AS montant_total_facture_7,
c0_.date_debut_fenetre AS date_debut_fenetre_8,
c0_.date_fin_fenetre AS date_fin_fenetre_9,
c0_.date_commande_soumission AS date_commande_soumission_10,
c0_.code_postal_livraison AS code_postal_livraison_11,
c0_.ville_livraison AS ville_livraison_12,
c0_.adresse_livraison AS adresse_livraison_13,
c0_.complement_adresse_livraison AS complement_adresse_livraison_14,
c0_.etat_us AS etat_us_15,
c0_.state AS state_16,
c0_.observation AS observation_17,
c0_.province AS province_18,
c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19,
c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20,
c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21,
c0_.token AS token_22,
c0_.fedex_pdf_generated AS fedex_pdf_generated_23,
c0_.is_temporaire AS is_temporaire_24,
c0_.is_validee_par_client AS is_validee_par_client_25,
c0_.commande_massive AS commande_massive_26,
c0_.date_collecte AS date_collecte_27,
c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28,
c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29,
c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30,
c0_.tracking_number AS tracking_number_31,
c0_.fedex_pdf_available AS fedex_pdf_available_32,
c0_.ship_date AS ship_date_33,
c0_.prior_url AS prior_url_34,
c0_.type_emballage AS type_emballage_35,
c0_.individual_tracking_numbers AS individual_tracking_numbers_36,
c0_.fast_pickup AS fast_pickup_37,
c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38,
c0_.pro_forma AS pro_forma_39,
c0_.dap AS dap_40,
c0_.service_priority AS service_priority_41,
c0_.commande_id_presta AS commande_id_presta_42,
c0_.client_id AS client_id_43,
c0_.client_final_id AS client_final_id_44
FROM
commande c0_
WHERE
c0_.client_id = ?
AND c0_.state = ?
AND c0_.is_temporaire = ?
ORDER BY
c0_.date_collecte ASC
SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.commande_id_presta AS commande_id_presta_42, c0_.client_id AS client_id_43, c0_.client_final_id AS client_final_id_44 FROM commande c0_ WHERE c0_.client_id = 402 AND c0_.state = 'preparation' AND c0_.is_temporaire = 0 ORDER BY c0_.date_collecte ASC;
|
| 7 |
5.03 ms |
SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.commande_id_presta AS commande_id_presta_42, c0_.client_id AS client_id_43, c0_.client_final_id AS client_final_id_44 FROM commande c0_ WHERE c0_.emballage_livraison = ? AND c0_.client_id = ? AND c0_.is_temporaire = ? ORDER BY c0_.date_collecte ASC
SELECT
c0_.id AS id_0,
c0_.nombre_colis_total AS nombre_colis_total_1,
c0_.numero_dae AS numero_dae_2,
c0_.assurance_livraison AS assurance_livraison_3,
c0_.emballage_livraison AS emballage_livraison_4,
c0_.fichier_facture AS fichier_facture_5,
c0_.numero_facture AS numero_facture_6,
c0_.montant_total_facture AS montant_total_facture_7,
c0_.date_debut_fenetre AS date_debut_fenetre_8,
c0_.date_fin_fenetre AS date_fin_fenetre_9,
c0_.date_commande_soumission AS date_commande_soumission_10,
c0_.code_postal_livraison AS code_postal_livraison_11,
c0_.ville_livraison AS ville_livraison_12,
c0_.adresse_livraison AS adresse_livraison_13,
c0_.complement_adresse_livraison AS complement_adresse_livraison_14,
c0_.etat_us AS etat_us_15,
c0_.state AS state_16,
c0_.observation AS observation_17,
c0_.province AS province_18,
c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19,
c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20,
c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21,
c0_.token AS token_22,
c0_.fedex_pdf_generated AS fedex_pdf_generated_23,
c0_.is_temporaire AS is_temporaire_24,
c0_.is_validee_par_client AS is_validee_par_client_25,
c0_.commande_massive AS commande_massive_26,
c0_.date_collecte AS date_collecte_27,
c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28,
c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29,
c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30,
c0_.tracking_number AS tracking_number_31,
c0_.fedex_pdf_available AS fedex_pdf_available_32,
c0_.ship_date AS ship_date_33,
c0_.prior_url AS prior_url_34,
c0_.type_emballage AS type_emballage_35,
c0_.individual_tracking_numbers AS individual_tracking_numbers_36,
c0_.fast_pickup AS fast_pickup_37,
c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38,
c0_.pro_forma AS pro_forma_39,
c0_.dap AS dap_40,
c0_.service_priority AS service_priority_41,
c0_.commande_id_presta AS commande_id_presta_42,
c0_.client_id AS client_id_43,
c0_.client_final_id AS client_final_id_44
FROM
commande c0_
WHERE
c0_.emballage_livraison = ?
AND c0_.client_id = ?
AND c0_.is_temporaire = ?
ORDER BY
c0_.date_collecte ASC
SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.commande_id_presta AS commande_id_presta_42, c0_.client_id AS client_id_43, c0_.client_final_id AS client_final_id_44 FROM commande c0_ WHERE c0_.emballage_livraison = 1 AND c0_.client_id = 402 AND c0_.is_temporaire = 0 ORDER BY c0_.date_collecte ASC;
|
| 8 |
2.45 ms |
SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.commande_id_presta AS commande_id_presta_42, c0_.client_id AS client_id_43, c0_.client_final_id AS client_final_id_44 FROM commande c0_ WHERE c0_.emballage_livraison = ? AND c0_.client_id = ? AND c0_.is_temporaire = ? ORDER BY c0_.date_collecte ASC
SELECT
c0_.id AS id_0,
c0_.nombre_colis_total AS nombre_colis_total_1,
c0_.numero_dae AS numero_dae_2,
c0_.assurance_livraison AS assurance_livraison_3,
c0_.emballage_livraison AS emballage_livraison_4,
c0_.fichier_facture AS fichier_facture_5,
c0_.numero_facture AS numero_facture_6,
c0_.montant_total_facture AS montant_total_facture_7,
c0_.date_debut_fenetre AS date_debut_fenetre_8,
c0_.date_fin_fenetre AS date_fin_fenetre_9,
c0_.date_commande_soumission AS date_commande_soumission_10,
c0_.code_postal_livraison AS code_postal_livraison_11,
c0_.ville_livraison AS ville_livraison_12,
c0_.adresse_livraison AS adresse_livraison_13,
c0_.complement_adresse_livraison AS complement_adresse_livraison_14,
c0_.etat_us AS etat_us_15,
c0_.state AS state_16,
c0_.observation AS observation_17,
c0_.province AS province_18,
c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19,
c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20,
c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21,
c0_.token AS token_22,
c0_.fedex_pdf_generated AS fedex_pdf_generated_23,
c0_.is_temporaire AS is_temporaire_24,
c0_.is_validee_par_client AS is_validee_par_client_25,
c0_.commande_massive AS commande_massive_26,
c0_.date_collecte AS date_collecte_27,
c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28,
c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29,
c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30,
c0_.tracking_number AS tracking_number_31,
c0_.fedex_pdf_available AS fedex_pdf_available_32,
c0_.ship_date AS ship_date_33,
c0_.prior_url AS prior_url_34,
c0_.type_emballage AS type_emballage_35,
c0_.individual_tracking_numbers AS individual_tracking_numbers_36,
c0_.fast_pickup AS fast_pickup_37,
c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38,
c0_.pro_forma AS pro_forma_39,
c0_.dap AS dap_40,
c0_.service_priority AS service_priority_41,
c0_.commande_id_presta AS commande_id_presta_42,
c0_.client_id AS client_id_43,
c0_.client_final_id AS client_final_id_44
FROM
commande c0_
WHERE
c0_.emballage_livraison = ?
AND c0_.client_id = ?
AND c0_.is_temporaire = ?
ORDER BY
c0_.date_collecte ASC
SELECT c0_.id AS id_0, c0_.nombre_colis_total AS nombre_colis_total_1, c0_.numero_dae AS numero_dae_2, c0_.assurance_livraison AS assurance_livraison_3, c0_.emballage_livraison AS emballage_livraison_4, c0_.fichier_facture AS fichier_facture_5, c0_.numero_facture AS numero_facture_6, c0_.montant_total_facture AS montant_total_facture_7, c0_.date_debut_fenetre AS date_debut_fenetre_8, c0_.date_fin_fenetre AS date_fin_fenetre_9, c0_.date_commande_soumission AS date_commande_soumission_10, c0_.code_postal_livraison AS code_postal_livraison_11, c0_.ville_livraison AS ville_livraison_12, c0_.adresse_livraison AS adresse_livraison_13, c0_.complement_adresse_livraison AS complement_adresse_livraison_14, c0_.etat_us AS etat_us_15, c0_.state AS state_16, c0_.observation AS observation_17, c0_.province AS province_18, c0_.nombre_bouteille_rouge AS nombre_bouteille_rouge_19, c0_.nombre_bouteille_blanc AS nombre_bouteille_blanc_20, c0_.nombre_bouteille_petillant AS nombre_bouteille_petillant_21, c0_.token AS token_22, c0_.fedex_pdf_generated AS fedex_pdf_generated_23, c0_.is_temporaire AS is_temporaire_24, c0_.is_validee_par_client AS is_validee_par_client_25, c0_.commande_massive AS commande_massive_26, c0_.date_collecte AS date_collecte_27, c0_.nombre_magnum_rouge AS nombre_magnum_rouge_28, c0_.nombre_magnum_blanc AS nombre_magnum_blanc_29, c0_.nombre_magnum_petillant AS nombre_magnum_petillant_30, c0_.tracking_number AS tracking_number_31, c0_.fedex_pdf_available AS fedex_pdf_available_32, c0_.ship_date AS ship_date_33, c0_.prior_url AS prior_url_34, c0_.type_emballage AS type_emballage_35, c0_.individual_tracking_numbers AS individual_tracking_numbers_36, c0_.fast_pickup AS fast_pickup_37, c0_.fichier_facture_pro_forma AS fichier_facture_pro_forma_38, c0_.pro_forma AS pro_forma_39, c0_.dap AS dap_40, c0_.service_priority AS service_priority_41, c0_.commande_id_presta AS commande_id_presta_42, c0_.client_id AS client_id_43, c0_.client_final_id AS client_final_id_44 FROM commande c0_ WHERE c0_.emballage_livraison = 0 AND c0_.client_id = 402 AND c0_.is_temporaire = 0 ORDER BY c0_.date_collecte ASC;
|
| 9 |
1.01 ms |
SELECT b0_.id AS id_0, b0_.titre AS titre_1, b0_.description AS description_2, b0_.token AS token_3, b0_.actif AS actif_4 FROM bandeau b0_ WHERE b0_.actif = 1 ORDER BY b0_.id DESC LIMIT 1
SELECT b0_.id AS id_0, b0_.titre AS titre_1, b0_.description AS description_2, b0_.token AS token_3, b0_.actif AS actif_4 FROM bandeau b0_ WHERE b0_.actif = 1 ORDER BY b0_.id DESC LIMIT 1;
|
| 10 |
1.38 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 = 402;
|
| 11 |
1.64 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 10793;
|
| 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 10659;
|
| 13 |
1.22 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 10447;
|
| 14 |
1.29 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 10450;
|
| 15 |
1.26 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 10234;
|
| 16 |
1.13 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 10236;
|
| 17 |
1.29 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 9985;
|
| 18 |
1.16 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 9987;
|
| 19 |
1.34 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 9724;
|
| 20 |
1.23 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 9726;
|
| 21 |
1.20 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 9449;
|
| 22 |
1.68 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 9477;
|
| 23 |
1.83 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 9479;
|
| 24 |
1.22 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 9519;
|
| 25 |
1.35 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 9140;
|
| 26 |
1.44 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 9174;
|
| 27 |
1.24 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 9382;
|
| 28 |
1.35 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 9390;
|
| 29 |
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 9147;
|
| 30 |
1.35 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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 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.commande_id_presta AS commande_id_presta_50,
t7.client_id AS client_id_51,
t7.client_final_id AS client_final_id_52
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.commande_id_presta AS commande_id_presta_50, t7.client_id AS client_id_51, t7.client_final_id AS client_final_id_52 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = 8928;
|