12.94 ms (81.41%)
20
SELECT t0 . id AS id_1 , t0 . quantite AS quantite_2 , t0 . total_ligne AS total_ligne_3 , t0 . prix_unitaire AS prix_unitaire_4 , t0 . fully_delivered AS fully_delivered_5 , t0 . quantite_restante_alivrer AS quantite_restante_alivrer_6 , t0 . partially_delivered AS partially_delivered_7 , t0 . delai AS delai_8 , t0 . commentaire AS commentaire_9 , t0 . designation AS designation_10 , t0 . code_article AS code_article_11 , t0 . prf AS prf_12 , t0 . devis_id AS devis_id_13 , t0 . article_id AS article_id_14 , t15 . id AS id_16 , t15 . name AS name_17 , t15 . designation AS designation_18 , t15 . fabricant AS fabricant_19 , t15 . reference_fabricant AS reference_fabricant_20 , t15 . type AS type_21 , t15 . prf AS prf_22 , t15 . unite_de_prix AS unite_de_prix_23 , t15 . date_validite_tarif AS date_validite_tarif_24 , t15 . code_tarif AS code_tarif_25 , t15 . code_douanier AS code_douanier_26 , t15 . dimentions AS dimentions_27 , t15 . poids AS poids_28 , t15 . pays_origine AS pays_origine_29 , t15 . numero_magasin AS numero_magasin_30 , t15 . emplacement_magasin AS emplacement_magasin_31 , t15 . created_at AS created_at_32 , t15 . image AS image_33 , t15 . id_monday AS id_monday_34 , t15 . updated_at AS updated_at_35 , t15 . updated_by AS updated_by_36 , t15 . coeff_prix_id AS coeff_prix_id_37 , t0 . coeff_prix_id AS coeff_prix_id_38 FROM devis_ligne t0 INNER JOIN article t15 ON t0 . article_id = t15 . id WHERE t0 . devis_id = ?
SELECT t0 . id AS id_1 , t0 . quantite AS quantite_2 , t0 . total_ligne AS total_ligne_3 , t0 . prix_unitaire AS prix_unitaire_4 , t0 . fully_delivered AS fully_delivered_5 , t0 . quantite_restante_alivrer AS quantite_restante_alivrer_6 , t0 . partially_delivered AS partially_delivered_7 , t0 . delai AS delai_8 , t0 . commentaire AS commentaire_9 , t0 . designation AS designation_10 , t0 . code_article AS code_article_11 , t0 . prf AS prf_12 , t0 . devis_id AS devis_id_13 , t0 . article_id AS article_id_14 , t15 . id AS id_16 , t15 . name AS name_17 , t15 . designation AS designation_18 , t15 . fabricant AS fabricant_19 , t15 . reference_fabricant AS reference_fabricant_20 , t15 . type AS type_21 , t15 . prf AS prf_22 , t15 . unite_de_prix AS unite_de_prix_23 , t15 . date_validite_tarif AS date_validite_tarif_24 , t15 . code_tarif AS code_tarif_25 , t15 . code_douanier AS code_douanier_26 , t15 . dimentions AS dimentions_27 , t15 . poids AS poids_28 , t15 . pays_origine AS pays_origine_29 , t15 . numero_magasin AS numero_magasin_30 , t15 . emplacement_magasin AS emplacement_magasin_31 , t15 . created_at AS created_at_32 , t15 . image AS image_33 , t15 . id_monday AS id_monday_34 , t15 . updated_at AS updated_at_35 , t15 . updated_by AS updated_by_36 , t15 . coeff_prix_id AS coeff_prix_id_37 , t0 . coeff_prix_id AS coeff_prix_id_38 FROM devis_ligne t0 INNER JOIN article t15 ON t0 . article_id = t15 . id WHERE t0 . devis_id = 139 ;
Copy
0.65 ms (4.11%)
1
SELECT d0_ . id AS id_0 , d0_ . created_at AS created_at_1 , d0_ . reference AS reference_2 , d0_ . total_ht AS total_ht_3 , d0_ . updated_at AS updated_at_4 , d0_ . remise_commerciale AS remise_commerciale_5 , d0_ . remise_en_p100 AS remise_en_p100_6 , d0_ . version AS version_7 , d0_ . description AS description_8 , d0_ . numero_dossier AS numero_dossier_9 , d0_ . id_monday AS id_monday_10 , d0_ . contact_name AS contact_name_11 , d0_ . contact_email AS contact_email_12 , d0_ . contact_phone_number AS contact_phone_number_13 , d0_ . contact_mobile_number AS contact_mobile_number_14 , d0_ . item_id_monday AS item_id_monday_15 , d0_ . adresse_livraison AS adresse_livraison_16 , d0_ . compte_commercial_id AS compte_commercial_id_17 FROM devis d0_ WHERE d0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY d0_ . updated_at DESC
Parameters :
[
139
138
137
136
135
57
134
133
132
131
130
129
128
127
125
126
124
123
122
121
]
SELECT d0_ . id AS id_0 , d0_ . created_at AS created_at_1 , d0_ . reference AS reference_2 , d0_ . total_ht AS total_ht_3 , d0_ . updated_at AS updated_at_4 , d0_ . remise_commerciale AS remise_commerciale_5 , d0_ . remise_en_p100 AS remise_en_p100_6 , d0_ . version AS version_7 , d0_ . description AS description_8 , d0_ . numero_dossier AS numero_dossier_9 , d0_ . id_monday AS id_monday_10 , d0_ . contact_name AS contact_name_11 , d0_ . contact_email AS contact_email_12 , d0_ . contact_phone_number AS contact_phone_number_13 , d0_ . contact_mobile_number AS contact_mobile_number_14 , d0_ . item_id_monday AS item_id_monday_15 , d0_ . adresse_livraison AS adresse_livraison_16 , d0_ . compte_commercial_id AS compte_commercial_id_17 FROM devis d0_ WHERE d0_ . id IN (139 , 138 , 137 , 136 , 135 , 57 , 134 , 133 , 132 , 131 , 130 , 129 , 128 , 127 , 125 , 126 , 124 , 123 , 122 , 121 ) ORDER BY d0_ . updated_at DESC ;
Copy
0.57 ms (3.57%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . commerciaux AS commerciaux_3 , t0 . affecte_a AS affecte_a_4 , t0 . type AS type_5 , t0 . status AS status_6 , t0 . interet AS interet_7 , t0 . tag_prioriry AS tag_prioriry_8 , t0 . email AS email_9 , t0 . telephone AS telephone_10 , t0 . mobile AS mobile_11 , t0 . adresse AS adresse_12 , t0 . adresse_old AS adresse_old_13 , t0 . adresse_complement AS adresse_complement_14 , t0 . adresse_rue AS adresse_rue_15 , t0 . adresse_cp AS adresse_cp_16 , t0 . adresse_ville AS adresse_ville_17 , t0 . remarques AS remarques_18 , t0 . tag_sector AS tag_sector_19 , t0 . my_group AS my_group_20 , t0 . site_web AS site_web_21 , t0 . pays AS pays_22 , t0 . region AS region_23 , t0 . origine AS origine_24 , t0 . effectifs AS effectifs_25 , t0 . fichier AS fichier_26 , t0 . tag_main_product AS tag_main_product_27 , t0 . tag_deals_part AS tag_deals_part_28 , t0 . agent AS agent_29 , t0 . commentaires AS commentaires_30 , t0 . commercial_local AS commercial_local_31 , t0 . commercial_sav AS commercial_sav_32 , t0 . commercial_service AS commercial_service_33 , t0 . opportunites_en_cours AS opportunites_en_cours_34 , t0 . id_monday AS id_monday_35 FROM compte_commerciaux t0 WHERE t0 . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
1002
996
985
793
802
152
784
978
694
806
987
1005
785
]
SELECT
t0 . id AS id_1 ,
t0 . name AS name_2 ,
t0 . commerciaux AS commerciaux_3 ,
t0 . affecte_a AS affecte_a_4 ,
t0 . type AS type_5 ,
t0 . status AS status_6 ,
t0 . interet AS interet_7 ,
t0 . tag_prioriry AS tag_prioriry_8 ,
t0 . email AS email_9 ,
t0 . telephone AS telephone_10 ,
t0 . mobile AS mobile_11 ,
t0 . adresse AS adresse_12 ,
t0 . adresse_old AS adresse_old_13 ,
t0 . adresse_complement AS adresse_complement_14 ,
t0 . adresse_rue AS adresse_rue_15 ,
t0 . adresse_cp AS adresse_cp_16 ,
t0 . adresse_ville AS adresse_ville_17 ,
t0 . remarques AS remarques_18 ,
t0 . tag_sector AS tag_sector_19 ,
t0 . my_group AS my_group_20 ,
t0 . site_web AS site_web_21 ,
t0 . pays AS pays_22 ,
t0 . region AS region_23 ,
t0 . origine AS origine_24 ,
t0 . effectifs AS effectifs_25 ,
t0 . fichier AS fichier_26 ,
t0 . tag_main_product AS tag_main_product_27 ,
t0 . tag_deals_part AS tag_deals_part_28 ,
t0 . agent AS agent_29 ,
t0 . commentaires AS commentaires_30 ,
t0 . commercial_local AS commercial_local_31 ,
t0 . commercial_sav AS commercial_sav_32 ,
t0 . commercial_service AS commercial_service_33 ,
t0 . opportunites_en_cours AS opportunites_en_cours_34 ,
t0 . id_monday AS id_monday_35
FROM
compte_commerciaux t0
WHERE
t0 . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Copy
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . commerciaux AS commerciaux_3 , t0 . affecte_a AS affecte_a_4 , t0 . type AS type_5 , t0 . status AS status_6 , t0 . interet AS interet_7 , t0 . tag_prioriry AS tag_prioriry_8 , t0 . email AS email_9 , t0 . telephone AS telephone_10 , t0 . mobile AS mobile_11 , t0 . adresse AS adresse_12 , t0 . adresse_old AS adresse_old_13 , t0 . adresse_complement AS adresse_complement_14 , t0 . adresse_rue AS adresse_rue_15 , t0 . adresse_cp AS adresse_cp_16 , t0 . adresse_ville AS adresse_ville_17 , t0 . remarques AS remarques_18 , t0 . tag_sector AS tag_sector_19 , t0 . my_group AS my_group_20 , t0 . site_web AS site_web_21 , t0 . pays AS pays_22 , t0 . region AS region_23 , t0 . origine AS origine_24 , t0 . effectifs AS effectifs_25 , t0 . fichier AS fichier_26 , t0 . tag_main_product AS tag_main_product_27 , t0 . tag_deals_part AS tag_deals_part_28 , t0 . agent AS agent_29 , t0 . commentaires AS commentaires_30 , t0 . commercial_local AS commercial_local_31 , t0 . commercial_sav AS commercial_sav_32 , t0 . commercial_service AS commercial_service_33 , t0 . opportunites_en_cours AS opportunites_en_cours_34 , t0 . id_monday AS id_monday_35 FROM compte_commerciaux t0 WHERE t0 . id IN (1002 , 996 , 985 , 793 , 802 , 152 , 784 , 978 , 694 , 806 , 987 , 1005 , 785 );
Copy
0.51 ms (3.24%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . address AS address_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . is_valid AS is_valid_6 FROM customer t0
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . address AS address_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . is_valid AS is_valid_6 FROM customer t0 ;
Copy
0.44 ms (2.77%)
1
SELECT DISTINCT d0_ . id AS id_0 , d0_ . updated_at AS updated_at_1 FROM devis d0_ ORDER BY d0_ . updated_at DESC LIMIT 20
SELECT DISTINCT d0_ . id AS id_0 , d0_ . updated_at AS updated_at_1 FROM devis d0_ ORDER BY d0_ . updated_at DESC LIMIT 20 ;
Copy
0.41 ms (2.60%)
1
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . name AS name_5 , t0 . service AS service_6 , t0 . phone AS phone_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 . name AS name_5 , t0 . service AS service_6 , t0 . phone AS phone_7 FROM user t0 WHERE t0 . id = 9 ;
Copy
0.37 ms (2.30%)
1
SELECT count (* ) AS sclr_0 FROM devis d0_
SELECT count (* ) AS sclr_0 FROM devis d0_ ;
Copy