141.12 ms (46.73%)
50
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . ean13 AS ean13_3 , t0 . ref AS ref_4 , t0 . old_id_web AS old_id_web_5 , t0 . is_etat_end AS is_etat_end_6 , t0 . is_etat_one AS is_etat_one_7 , t0 . is_accep AS is_accep_8 , t0 . quantite AS quantite_9 , t0 . num_commande AS num_commande_10 , t0 . num_facture AS num_facture_11 , t0 . date AS date_12 , t0 . is_en_livraison AS is_en_livraison_13 , t0 . date_delivery AS date_delivery_14 , t0 . is_relivraison AS is_relivraison_15 FROM mouvement_web t0 WHERE t0 . num_facture = ?
Parameters :
[
"CFAC1231ss11111 "
]
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . ean13 AS ean13_3 , t0 . ref AS ref_4 , t0 . old_id_web AS old_id_web_5 , t0 . is_etat_end AS is_etat_end_6 , t0 . is_etat_one AS is_etat_one_7 , t0 . is_accep AS is_accep_8 , t0 . quantite AS quantite_9 , t0 . num_commande AS num_commande_10 , t0 . num_facture AS num_facture_11 , t0 . date AS date_12 , t0 . is_en_livraison AS is_en_livraison_13 , t0 . date_delivery AS date_delivery_14 , t0 . is_relivraison AS is_relivraison_15 FROM mouvement_web t0 WHERE t0 . num_facture = 'CFAC1231ss11111' ;
Copy
55.85 ms (18.50%)
48
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . ean13 AS ean13_3 , t0 . old AS old_4 , t0 . bundle AS bundle_5 , t0 . is_active AS is_active_6 , t0 . reference AS reference_7 , t0 . qr_code_path AS qr_code_path_8 , t0 . is_surveillance AS is_surveillance_9 , t0 . is_france AS is_france_10 , t0 . is_active_produit AS is_active_produit_11 , t0 . is_coupure_produit AS is_coupure_produit_12 , t0 . is_in_active_produit AS is_in_active_produit_13 , t0 . date_debut AS date_debut_14 , t0 . date_fin AS date_fin_15 FROM produit t0 WHERE t0 . reference = ? LIMIT 1
Parameters :
[
"PQDFFS93395 "
]
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . ean13 AS ean13_3 , t0 . old AS old_4 , t0 . bundle AS bundle_5 , t0 . is_active AS is_active_6 , t0 . reference AS reference_7 , t0 . qr_code_path AS qr_code_path_8 , t0 . is_surveillance AS is_surveillance_9 , t0 . is_france AS is_france_10 , t0 . is_active_produit AS is_active_produit_11 , t0 . is_coupure_produit AS is_coupure_produit_12 , t0 . is_in_active_produit AS is_in_active_produit_13 , t0 . date_debut AS date_debut_14 , t0 . date_fin AS date_fin_15 FROM produit t0 WHERE t0 . reference = 'PQDFFS93395' LIMIT 1 ;
Copy
41.10 ms (13.61%)
56
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . ean13 AS ean13_3 , t0 . quantite AS quantite_4 , t0 . alerte AS alerte_5 , t0 . categorie AS categorie_6 , t0 . nomenclature AS nomenclature_7 , t0 . ht AS ht_8 , t0 . taxe AS taxe_9 , t0 . dlc AS dlc_10 , t0 . is_france AS is_france_11 , t0 . qt_tempo AS qt_tempo_12 , t0 . qt_site AS qt_site_13 , t0 . qt_appro AS qt_appro_14 , t0 . is_bouquet AS is_bouquet_15 , t0 . qr_code_path AS qr_code_path_16 , t0 . reffj AS reffj_17 , t0 . is_surveillance AS is_surveillance_18 , t0 . is_active_produit AS is_active_produit_19 , t0 . is_coupure_produit AS is_coupure_produit_20 , t0 . is_in_active_produit AS is_in_active_produit_21 , t0 . date_debut AS date_debut_22 , t0 . date_fin AS date_fin_23 , t0 . fournisseurs_id AS fournisseurs_id_24 , t0 . qt_id AS qt_id_25 , t0 . commande_id AS commande_id_26 , t0 . association_id AS association_id_27 FROM composant t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . ean13 AS ean13_3 , t0 . quantite AS quantite_4 , t0 . alerte AS alerte_5 , t0 . categorie AS categorie_6 , t0 . nomenclature AS nomenclature_7 , t0 . ht AS ht_8 , t0 . taxe AS taxe_9 , t0 . dlc AS dlc_10 , t0 . is_france AS is_france_11 , t0 . qt_tempo AS qt_tempo_12 , t0 . qt_site AS qt_site_13 , t0 . qt_appro AS qt_appro_14 , t0 . is_bouquet AS is_bouquet_15 , t0 . qr_code_path AS qr_code_path_16 , t0 . reffj AS reffj_17 , t0 . is_surveillance AS is_surveillance_18 , t0 . is_active_produit AS is_active_produit_19 , t0 . is_coupure_produit AS is_coupure_produit_20 , t0 . is_in_active_produit AS is_in_active_produit_21 , t0 . date_debut AS date_debut_22 , t0 . date_fin AS date_fin_23 , t0 . fournisseurs_id AS fournisseurs_id_24 , t0 . qt_id AS qt_id_25 , t0 . commande_id AS commande_id_26 , t0 . association_id AS association_id_27 FROM composant t0 WHERE t0 . id = 245 ;
Copy
26.87 ms (8.90%)
27
SELECT t0 . id AS id_1 , t0 . produit_reference AS produit_reference_2 , t0 . is_active_produit AS is_active_produit_3 , t0 . is_coupure_produit AS is_coupure_produit_4 , t0 . is_in_active_produit AS is_in_active_produit_5 , t0 . date_debut AS date_debut_6 , t0 . date_fin AS date_fin_7 , t0 . is_bouquet AS is_bouquet_8 , t0 . produit_id AS produit_id_9 FROM association t0 WHERE t0 . produit_id = ?
SELECT t0 . id AS id_1 , t0 . produit_reference AS produit_reference_2 , t0 . is_active_produit AS is_active_produit_3 , t0 . is_coupure_produit AS is_coupure_produit_4 , t0 . is_in_active_produit AS is_in_active_produit_5 , t0 . date_debut AS date_debut_6 , t0 . date_fin AS date_fin_7 , t0 . is_bouquet AS is_bouquet_8 , t0 . produit_id AS produit_id_9 FROM association t0 WHERE t0 . produit_id = 242 ;
Copy
25.74 ms (8.53%)
27
SELECT t0 . id AS id_1 , t0 . quantite AS quantite_2 , t0 . composants_id AS composants_id_3 , t0 . association_id AS association_id_4 FROM qt t0 WHERE t0 . association_id = ?
SELECT t0 . id AS id_1 , t0 . quantite AS quantite_2 , t0 . composants_id AS composants_id_3 , t0 . association_id AS association_id_4 FROM qt t0 WHERE t0 . association_id = 214 ;
Copy
9.83 ms (3.26%)
3
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . ean13 AS ean13_3 , t0 . ref AS ref_4 , t0 . old_id_web AS old_id_web_5 , t0 . is_etat_end AS is_etat_end_6 , t0 . is_etat_one AS is_etat_one_7 , t0 . is_accep AS is_accep_8 , t0 . quantite AS quantite_9 , t0 . num_commande AS num_commande_10 , t0 . num_facture AS num_facture_11 , t0 . date AS date_12 , t0 . is_en_livraison AS is_en_livraison_13 , t0 . date_delivery AS date_delivery_14 , t0 . is_relivraison AS is_relivraison_15 FROM mouvement_web t0
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . ean13 AS ean13_3 , t0 . ref AS ref_4 , t0 . old_id_web AS old_id_web_5 , t0 . is_etat_end AS is_etat_end_6 , t0 . is_etat_one AS is_etat_one_7 , t0 . is_accep AS is_accep_8 , t0 . quantite AS quantite_9 , t0 . num_commande AS num_commande_10 , t0 . num_facture AS num_facture_11 , t0 . date AS date_12 , t0 . is_en_livraison AS is_en_livraison_13 , t0 . date_delivery AS date_delivery_14 , t0 . is_relivraison AS is_relivraison_15 FROM mouvement_web t0 ;
Copy
1.45 ms (0.48%)
1
SELECT t0 . id AS id_1 , t0 . num_commande AS num_commande_2 , t0 . is_num_commande AS is_num_commande_3 , t0 . is_accept AS is_accept_4 , t0 . ref_produit AS ref_produit_5 , t0 . num_facture AS num_facture_6 , t0 . is_processed AS is_processed_7 , t0 . num_suivi AS num_suivi_8 , t0 . date_commande AS date_commande_9 , t0 . date_livraison AS date_livraison_10 , t0 . mouvement_webs_id AS mouvement_webs_id_11 FROM mouvement_transporteur t0 ORDER BY t0 . id DESC LIMIT 50
SELECT t0 . id AS id_1 , t0 . num_commande AS num_commande_2 , t0 . is_num_commande AS is_num_commande_3 , t0 . is_accept AS is_accept_4 , t0 . ref_produit AS ref_produit_5 , t0 . num_facture AS num_facture_6 , t0 . is_processed AS is_processed_7 , t0 . num_suivi AS num_suivi_8 , t0 . date_commande AS date_commande_9 , t0 . date_livraison AS date_livraison_10 , t0 . mouvement_webs_id AS mouvement_webs_id_11 FROM mouvement_transporteur t0 ORDER BY t0 . id DESC LIMIT 50 ;
Copy