1.61 ms (21.59%)
5
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 = 291 ;
Copy
1.01 ms (13.48%)
1
SELECT s0_ . id AS id_0 , s0_ . type_localisation AS type_localisation_1 , s0_ . localisation AS localisation_2 , s0_ . commentaire AS commentaire_3 , s0_ . date_creation AS date_creation_4 , s0_ . evenement_id AS evenement_id_5 , s0_ . created_by_id AS created_by_id_6 FROM suivi_photo s0_ WHERE s0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
1032
1033
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
860
861
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
1162
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
]
SELECT
s0_ . id AS id_0 ,
s0_ . type_localisation AS type_localisation_1 ,
s0_ . localisation AS localisation_2 ,
s0_ . commentaire AS commentaire_3 ,
s0_ . date_creation AS date_creation_4 ,
s0_ . evenement_id AS evenement_id_5 ,
s0_ . created_by_id AS created_by_id_6
FROM
suivi_photo s0_
WHERE
s0_ . id IN (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ?
)
Copy
SELECT s0_ . id AS id_0 , s0_ . type_localisation AS type_localisation_1 , s0_ . localisation AS localisation_2 , s0_ . commentaire AS commentaire_3 , s0_ . date_creation AS date_creation_4 , s0_ . evenement_id AS evenement_id_5 , s0_ . created_by_id AS created_by_id_6 FROM suivi_photo s0_ WHERE s0_ . id IN (1032 , 1033 , 818 , 819 , 820 , 821 , 822 , 823 , 824 , 825 , 826 , 827 , 828 , 829 , 830 , 831 , 832 , 833 , 834 , 835 , 836 , 837 , 838 , 839 , 840 , 841 , 842 , 843 , 844 , 845 , 846 , 847 , 848 , 849 , 860 , 861 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15 , 16 , 17 , 18 , 19 , 20 , 21 , 22 , 23 , 24 , 25 , 1162 , 26 , 27 , 28 , 29 , 30 , 31 , 32 , 33 , 34 , 35 , 36 , 37 , 38 , 39 , 40 , 41 , 42 , 43 , 44 , 45 , 46 , 47 , 48 , 49 , 50 , 51 , 52 , 53 , 54 , 55 , 56 , 57 , 58 , 59 , 60 , 61 , 62 , 63 , 64 , 65 , 66 );
Copy