0.99 ms (16.06%)
5
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . datedebut AS datedebut_3 , t0 . datefin AS datefin_4 , t0 . montage_debut AS montage_debut_5 , t0 . montage_fin AS montage_fin_6 , t0 . exploitation_debut AS exploitation_debut_7 , t0 . exploitation_fin AS exploitation_fin_8 , t0 . demontage_debut AS demontage_debut_9 , t0 . demontage_fin AS demontage_fin_10 , t0 . lien AS lien_11 , t0 . reemploi AS reemploi_12 , t0 . suivi_biodechet AS suivi_biodechet_13 , t0 . inventaire_ctalogue AS inventaire_ctalogue_14 , t0 . leclient_id AS leclient_id_15 , t0 . logo_id AS logo_id_16 FROM evenement t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . datedebut AS datedebut_3 , t0 . datefin AS datefin_4 , t0 . montage_debut AS montage_debut_5 , t0 . montage_fin AS montage_fin_6 , t0 . exploitation_debut AS exploitation_debut_7 , t0 . exploitation_fin AS exploitation_fin_8 , t0 . demontage_debut AS demontage_debut_9 , t0 . demontage_fin AS demontage_fin_10 , t0 . lien AS lien_11 , t0 . reemploi AS reemploi_12 , t0 . suivi_biodechet AS suivi_biodechet_13 , t0 . inventaire_ctalogue AS inventaire_ctalogue_14 , t0 . leclient_id AS leclient_id_15 , t0 . logo_id AS logo_id_16 FROM evenement t0 WHERE t0 . id = 24 ;
Copy
0.53 ms (8.59%)
1
SELECT t0 . id AS id_1 , t0 . login AS login_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . prenom AS prenom_5 , t0 . nom AS nom_6 , t0 . datedenaissance AS datedenaissance_7 , t0 . lieudenaissance AS lieudenaissance_8 , t0 . adresse AS adresse_9 , t0 . contact AS contact_10 , t0 . rib AS rib_11 , t0 . siret AS siret_12 , t0 . securitesociale AS securitesociale_13 , t0 . email AS email_14 , t0 . contacturgence AS contacturgence_15 , t0 . contacturgencetel AS contacturgencetel_16 , t0 . photo AS photo_17 , t0 . permis AS permis_18 , t0 . autres AS autres_19 , t20 . id AS id_21 , t20 . nom_structure AS nom_structure_22 , t20 . type_structure AS type_structure_23 , t20 . types_projet AS types_projet_24 , t20 . volume_vehicule AS volume_vehicule_25 , t20 . manutention AS manutention_26 , t20 . adresse AS adresse_27 , t20 . nom_contact AS nom_contact_28 , t20 . email_contact AS email_contact_29 , t20 . telephone_contact AS telephone_contact_30 , t20 . site_web AS site_web_31 , t20 . linkedin AS linkedin_32 , t20 . ressources AS ressources_33 , t20 . details AS details_34 , t20 . validation AS validation_35 , t20 . user_id AS user_id_36 , t37 . id AS id_38 , t37 . quantites AS quantites_39 , t37 . proprietaire_id AS proprietaire_id_40 FROM `user` t0 LEFT JOIN filiere t20 ON t20 . user_id = t0 . id LEFT JOIN panier t37 ON t37 . proprietaire_id = t0 . id WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . login AS login_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . prenom AS prenom_5 , t0 . nom AS nom_6 , t0 . datedenaissance AS datedenaissance_7 , t0 . lieudenaissance AS lieudenaissance_8 , t0 . adresse AS adresse_9 , t0 . contact AS contact_10 , t0 . rib AS rib_11 , t0 . siret AS siret_12 , t0 . securitesociale AS securitesociale_13 , t0 . email AS email_14 , t0 . contacturgence AS contacturgence_15 , t0 . contacturgencetel AS contacturgencetel_16 , t0 . photo AS photo_17 , t0 . permis AS permis_18 , t0 . autres AS autres_19 , t20 . id AS id_21 , t20 . nom_structure AS nom_structure_22 , t20 . type_structure AS type_structure_23 , t20 . types_projet AS types_projet_24 , t20 . volume_vehicule AS volume_vehicule_25 , t20 . manutention AS manutention_26 , t20 . adresse AS adresse_27 , t20 . nom_contact AS nom_contact_28 , t20 . email_contact AS email_contact_29 , t20 . telephone_contact AS telephone_contact_30 , t20 . site_web AS site_web_31 , t20 . linkedin AS linkedin_32 , t20 . ressources AS ressources_33 , t20 . details AS details_34 , t20 . validation AS validation_35 , t20 . user_id AS user_id_36 , t37 . id AS id_38 , t37 . quantites AS quantites_39 , t37 . proprietaire_id AS proprietaire_id_40 FROM `user` t0 LEFT JOIN filiere t20 ON t20 . user_id = t0 . id LEFT JOIN panier t37 ON t37 . proprietaire_id = t0 . id WHERE t0 . id = 12 ;
Copy
0.39 ms (6.34%)
1
SELECT i0_ . id AS id_0 , i0_ . longueur AS longueur_1 , i0_ . largeur AS largeur_2 , i0_ . hauteur AS hauteur_3 , i0_ . diametre AS diametre_4 , i0_ . unite_diametre AS unite_diametre_5 , i0_ . materiaux AS materiaux_6 , i0_ . color1 AS color1_7 , i0_ . marque AS marque_8 , i0_ . etat AS etat_9 , i0_ . description AS description_10 , i0_ . conditionnement AS conditionnement_11 , i0_ . risques_precautions AS risques_precautions_12 , i0_ . etape AS etape_13 , i0_ . quantite AS quantite_14 , i0_ . unite_quantite AS unite_quantite_15 , i0_ . actions AS actions_16 , i0_ . localisation AS localisation_17 , i0_ . visuel AS visuel_18 , i0_ . lesvisuels AS lesvisuels_19 , i0_ . poids AS poids_20 , i0_ . quantite_reservee AS quantite_reservee_21 , i0_ . date_debut_reservation AS date_debut_reservation_22 , i0_ . date_fin_reservation AS date_fin_reservation_23 , i0_ . designation AS designation_24 , i0_ . categorie AS categorie_25 , i0_ . site_id AS site_id_26 , i0_ . provenance_id AS provenance_id_27 FROM inventaire i0_ WHERE i0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
101
153
262
307
310
317
352
353
453
73
74
75
76
77
78
79
80
81
82
83
]
SELECT
i0_ . id AS id_0 ,
i0_ . longueur AS longueur_1 ,
i0_ . largeur AS largeur_2 ,
i0_ . hauteur AS hauteur_3 ,
i0_ . diametre AS diametre_4 ,
i0_ . unite_diametre AS unite_diametre_5 ,
i0_ . materiaux AS materiaux_6 ,
i0_ . color1 AS color1_7 ,
i0_ . marque AS marque_8 ,
i0_ . etat AS etat_9 ,
i0_ . description AS description_10 ,
i0_ . conditionnement AS conditionnement_11 ,
i0_ . risques_precautions AS risques_precautions_12 ,
i0_ . etape AS etape_13 ,
i0_ . quantite AS quantite_14 ,
i0_ . unite_quantite AS unite_quantite_15 ,
i0_ . actions AS actions_16 ,
i0_ . localisation AS localisation_17 ,
i0_ . visuel AS visuel_18 ,
i0_ . lesvisuels AS lesvisuels_19 ,
i0_ . poids AS poids_20 ,
i0_ . quantite_reservee AS quantite_reservee_21 ,
i0_ . date_debut_reservation AS date_debut_reservation_22 ,
i0_ . date_fin_reservation AS date_fin_reservation_23 ,
i0_ . designation AS designation_24 ,
i0_ . categorie AS categorie_25 ,
i0_ . site_id AS site_id_26 ,
i0_ . provenance_id AS provenance_id_27
FROM
inventaire i0_
WHERE
i0_ . id IN (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ?
)
Copy
SELECT i0_ . id AS id_0 , i0_ . longueur AS longueur_1 , i0_ . largeur AS largeur_2 , i0_ . hauteur AS hauteur_3 , i0_ . diametre AS diametre_4 , i0_ . unite_diametre AS unite_diametre_5 , i0_ . materiaux AS materiaux_6 , i0_ . color1 AS color1_7 , i0_ . marque AS marque_8 , i0_ . etat AS etat_9 , i0_ . description AS description_10 , i0_ . conditionnement AS conditionnement_11 , i0_ . risques_precautions AS risques_precautions_12 , i0_ . etape AS etape_13 , i0_ . quantite AS quantite_14 , i0_ . unite_quantite AS unite_quantite_15 , i0_ . actions AS actions_16 , i0_ . localisation AS localisation_17 , i0_ . visuel AS visuel_18 , i0_ . lesvisuels AS lesvisuels_19 , i0_ . poids AS poids_20 , i0_ . quantite_reservee AS quantite_reservee_21 , i0_ . date_debut_reservation AS date_debut_reservation_22 , i0_ . date_fin_reservation AS date_fin_reservation_23 , i0_ . designation AS designation_24 , i0_ . categorie AS categorie_25 , i0_ . site_id AS site_id_26 , i0_ . provenance_id AS provenance_id_27 FROM inventaire i0_ WHERE i0_ . id IN (101 , 153 , 262 , 307 , 310 , 317 , 352 , 353 , 453 , 73 , 74 , 75 , 76 , 77 , 78 , 79 , 80 , 81 , 82 , 83 );
Copy