1
0.22 ms
SELECT a0_ . id AS id_0 , a0_ . filename AS filename_1 , a0_ . image_size AS image_size_2 , a0_ . title AS title_3 , a0_ . description AS description_4 , a0_ . created_at AS created_at_5 , a0_ . updated_at AS updated_at_6 , a0_ . type_art AS type_art_7 , a0_ . professionel_id AS professionel_id_8 , a0_ . admin_id AS admin_id_9 FROM article a0_ INNER JOIN admin a1_ ON a0_ . admin_id = a1_ . id LEFT JOIN user u2_ ON a1_ . id = u2_ . id WHERE a0_ . type_art IS NULL ORDER BY a0_ . id DESC LIMIT 3
SELECT a0_ . id AS id_0 , a0_ . filename AS filename_1 , a0_ . image_size AS image_size_2 , a0_ . title AS title_3 , a0_ . description AS description_4 , a0_ . created_at AS created_at_5 , a0_ . updated_at AS updated_at_6 , a0_ . type_art AS type_art_7 , a0_ . professionel_id AS professionel_id_8 , a0_ . admin_id AS admin_id_9 FROM article a0_ INNER JOIN admin a1_ ON a0_ . admin_id = a1_ . id LEFT JOIN user u2_ ON a1_ . id = u2_ . id WHERE a0_ . type_art IS NULL ORDER BY a0_ . id DESC LIMIT 3 ;
Copy
2
1.06 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"58 "
"en "
"App\Entity\Article "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '58' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Article' ;
Copy
3
3.97 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"57 "
"en "
"App\Entity\Article "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '57' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Article' ;
Copy
4
0.14 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"56 "
"en "
"App\Entity\Article "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '56' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Article' ;
Copy
5
8.73 ms
SELECT a0_ . id AS id_0 , a0_ . category AS category_1 , a0_ . marques AS marques_2 , a0_ . modeles AS modeles_3 , a0_ . etats AS etats_4 , a0_ . carosseries AS carosseries_5 , a0_ . year AS year_6 , a0_ . kilometrage AS kilometrage_7 , a0_ . carburants AS carburants_8 , a0_ . transmission AS transmission_9 , a0_ . moteur AS moteur_10 , a0_ . entrainement AS entrainement_11 , a0_ . couleur_ext AS couleur_ext_12 , a0_ . couleur_int AS couleur_int_13 , a0_ . numero_chassis AS numero_chassis_14 , a0_ . consommationville AS consommationville_15 , a0_ . consommation_route AS consommation_route_16 , a0_ . carosserie_equip AS carosserie_equip_17 , a0_ . transmission_equip AS transmission_equip_18 , a0_ . interieur_equip AS interieur_equip_19 , a0_ . exterieur_equip AS exterieur_equip_20 , a0_ . electronique_equip AS electronique_equip_21 , a0_ . dispo_securite AS dispo_securite_22 , a0_ . videos AS videos_23 , a0_ . price AS price_24 , a0_ . description AS description_25 , a0_ . descriptionadd AS descriptionadd_26 , a0_ . specificationtechniques AS specificationtechniques_27 , a0_ . infosgenerales AS infosgenerales_28 , a0_ . brochure_filename AS brochure_filename_29 , a0_ . brochure_size AS brochure_size_30 , a0_ . created_at AS created_at_31 , a0_ . updated_at AS updated_at_32 , a0_ . device AS device_33 , a0_ . regions AS regions_34 , a0_ . villes AS villes_35 , a0_ . communes AS communes_36 , a0_ . address AS address_37 , a0_ . type AS type_38 , a0_ . urgent AS urgent_39 , a0_ . nbrcylindre AS nbrcylindre_40 , a0_ . numero_enregistrement AS numero_enregistrement_41 , a0_ . is_favoris AS is_favoris_42 , a0_ . has_co2 AS has_co2_43 , a0_ . export_price AS export_price_44 , a0_ . bargan_price AS bargan_price_45 , a0_ . is_active AS is_active_46 , a0_ . int_moto AS int_moto_47 , a0_ . electro_moto AS electro_moto_48 , a0_ . disposec_moto AS disposec_moto_49 , a0_ . dispconf_moto AS dispconf_moto_50 , a0_ . lon AS lon_51 , a0_ . lat AS lat_52 , a0_ . duration AS duration_53 , a0_ . comments AS comments_54 , a0_ . note AS note_55 , a0_ . is_compared AS is_compared_56 , a0_ . user_id AS user_id_57 FROM annonce a0_ ORDER BY a0_ . id DESC LIMIT 6
SELECT
a0_ . id AS id_0 ,
a0_ . category AS category_1 ,
a0_ . marques AS marques_2 ,
a0_ . modeles AS modeles_3 ,
a0_ . etats AS etats_4 ,
a0_ . carosseries AS carosseries_5 ,
a0_ . year AS year_6 ,
a0_ . kilometrage AS kilometrage_7 ,
a0_ . carburants AS carburants_8 ,
a0_ . transmission AS transmission_9 ,
a0_ . moteur AS moteur_10 ,
a0_ . entrainement AS entrainement_11 ,
a0_ . couleur_ext AS couleur_ext_12 ,
a0_ . couleur_int AS couleur_int_13 ,
a0_ . numero_chassis AS numero_chassis_14 ,
a0_ . consommationville AS consommationville_15 ,
a0_ . consommation_route AS consommation_route_16 ,
a0_ . carosserie_equip AS carosserie_equip_17 ,
a0_ . transmission_equip AS transmission_equip_18 ,
a0_ . interieur_equip AS interieur_equip_19 ,
a0_ . exterieur_equip AS exterieur_equip_20 ,
a0_ . electronique_equip AS electronique_equip_21 ,
a0_ . dispo_securite AS dispo_securite_22 ,
a0_ . videos AS videos_23 ,
a0_ . price AS price_24 ,
a0_ . description AS description_25 ,
a0_ . descriptionadd AS descriptionadd_26 ,
a0_ . specificationtechniques AS specificationtechniques_27 ,
a0_ . infosgenerales AS infosgenerales_28 ,
a0_ . brochure_filename AS brochure_filename_29 ,
a0_ . brochure_size AS brochure_size_30 ,
a0_ . created_at AS created_at_31 ,
a0_ . updated_at AS updated_at_32 ,
a0_ . device AS device_33 ,
a0_ . regions AS regions_34 ,
a0_ . villes AS villes_35 ,
a0_ . communes AS communes_36 ,
a0_ . address AS address_37 ,
a0_ . type AS type_38 ,
a0_ . urgent AS urgent_39 ,
a0_ . nbrcylindre AS nbrcylindre_40 ,
a0_ . numero_enregistrement AS numero_enregistrement_41 ,
a0_ . is_favoris AS is_favoris_42 ,
a0_ . has_co2 AS has_co2_43 ,
a0_ . export_price AS export_price_44 ,
a0_ . bargan_price AS bargan_price_45 ,
a0_ . is_active AS is_active_46 ,
a0_ . int_moto AS int_moto_47 ,
a0_ . electro_moto AS electro_moto_48 ,
a0_ . disposec_moto AS disposec_moto_49 ,
a0_ . dispconf_moto AS dispconf_moto_50 ,
a0_ . lon AS lon_51 ,
a0_ . lat AS lat_52 ,
a0_ . duration AS duration_53 ,
a0_ . comments AS comments_54 ,
a0_ . note AS note_55 ,
a0_ . is_compared AS is_compared_56 ,
a0_ . user_id AS user_id_57
FROM
annonce a0_
ORDER BY
a0_ . id DESC
LIMIT
6
Copy
SELECT a0_ . id AS id_0 , a0_ . category AS category_1 , a0_ . marques AS marques_2 , a0_ . modeles AS modeles_3 , a0_ . etats AS etats_4 , a0_ . carosseries AS carosseries_5 , a0_ . year AS year_6 , a0_ . kilometrage AS kilometrage_7 , a0_ . carburants AS carburants_8 , a0_ . transmission AS transmission_9 , a0_ . moteur AS moteur_10 , a0_ . entrainement AS entrainement_11 , a0_ . couleur_ext AS couleur_ext_12 , a0_ . couleur_int AS couleur_int_13 , a0_ . numero_chassis AS numero_chassis_14 , a0_ . consommationville AS consommationville_15 , a0_ . consommation_route AS consommation_route_16 , a0_ . carosserie_equip AS carosserie_equip_17 , a0_ . transmission_equip AS transmission_equip_18 , a0_ . interieur_equip AS interieur_equip_19 , a0_ . exterieur_equip AS exterieur_equip_20 , a0_ . electronique_equip AS electronique_equip_21 , a0_ . dispo_securite AS dispo_securite_22 , a0_ . videos AS videos_23 , a0_ . price AS price_24 , a0_ . description AS description_25 , a0_ . descriptionadd AS descriptionadd_26 , a0_ . specificationtechniques AS specificationtechniques_27 , a0_ . infosgenerales AS infosgenerales_28 , a0_ . brochure_filename AS brochure_filename_29 , a0_ . brochure_size AS brochure_size_30 , a0_ . created_at AS created_at_31 , a0_ . updated_at AS updated_at_32 , a0_ . device AS device_33 , a0_ . regions AS regions_34 , a0_ . villes AS villes_35 , a0_ . communes AS communes_36 , a0_ . address AS address_37 , a0_ . type AS type_38 , a0_ . urgent AS urgent_39 , a0_ . nbrcylindre AS nbrcylindre_40 , a0_ . numero_enregistrement AS numero_enregistrement_41 , a0_ . is_favoris AS is_favoris_42 , a0_ . has_co2 AS has_co2_43 , a0_ . export_price AS export_price_44 , a0_ . bargan_price AS bargan_price_45 , a0_ . is_active AS is_active_46 , a0_ . int_moto AS int_moto_47 , a0_ . electro_moto AS electro_moto_48 , a0_ . disposec_moto AS disposec_moto_49 , a0_ . dispconf_moto AS dispconf_moto_50 , a0_ . lon AS lon_51 , a0_ . lat AS lat_52 , a0_ . duration AS duration_53 , a0_ . comments AS comments_54 , a0_ . note AS note_55 , a0_ . is_compared AS is_compared_56 , a0_ . user_id AS user_id_57 FROM annonce a0_ ORDER BY a0_ . id DESC LIMIT 6 ;
Copy
6
0.24 ms
SELECT t0 . id AS id_4 , t0 . email AS email_5 , t0 . roles AS roles_6 , t0 . password AS password_7 , t0 . type_compte AS type_compte_8 , t0 . is_verified AS is_verified_9 , t0 . tel AS tel_10 , t0 . approve AS approve_11 , t0 . facebook_id AS facebook_id_12 , t0 . is_super_admin AS is_super_admin_13 , t0 . facebook AS facebook_14 , t0 . twitter AS twitter_15 , t0 . instagram AS instagram_16 , t0 . linkedin AS linkedin_17 , t0 . youtube AS youtube_18 , t0 . whatsapp AS whatsapp_19 , t0 . pinterest AS pinterest_20 , t0 . facebook_access_token AS facebook_access_token_21 , t0 . twitter_id AS twitter_id_22 , t0 . twitter_access_token AS twitter_access_token_23 , t0 . google_id AS google_id_24 , t0 . google_access_token AS google_access_token_25 , t0 . compte , t1 . logo AS logo_26 , t1 . nom_professionel AS nom_professionel_27 , t1 . addresse AS addresse_28 , t1 . marques AS marques_29 , t1 . website AS website_30 , t1 . image_size AS image_size_31 , t1 . updated_at AS updated_at_32 , t1 . description AS description_33 , t2 . prenom AS prenom_34 , t2 . nom AS nom_35 , t2 . civility AS civility_36 , t2 . photo AS photo_37 , t2 . image_size AS image_size_38 , t2 . updated_at AS updated_at_39 , t3 . photo AS photo_40 , t3 . image_size AS image_size_41 , t3 . updated_at AS updated_at_42 FROM user t0 LEFT JOIN professionel t1 ON t0 . id = t1 . id LEFT JOIN particulier t2 ON t0 . id = t2 . id LEFT JOIN admin t3 ON t0 . id = t3 . id WHERE t0 . id = ?
SELECT t0 . id AS id_4 , t0 . email AS email_5 , t0 . roles AS roles_6 , t0 . password AS password_7 , t0 . type_compte AS type_compte_8 , t0 . is_verified AS is_verified_9 , t0 . tel AS tel_10 , t0 . approve AS approve_11 , t0 . facebook_id AS facebook_id_12 , t0 . is_super_admin AS is_super_admin_13 , t0 . facebook AS facebook_14 , t0 . twitter AS twitter_15 , t0 . instagram AS instagram_16 , t0 . linkedin AS linkedin_17 , t0 . youtube AS youtube_18 , t0 . whatsapp AS whatsapp_19 , t0 . pinterest AS pinterest_20 , t0 . facebook_access_token AS facebook_access_token_21 , t0 . twitter_id AS twitter_id_22 , t0 . twitter_access_token AS twitter_access_token_23 , t0 . google_id AS google_id_24 , t0 . google_access_token AS google_access_token_25 , t0 . compte , t1 . logo AS logo_26 , t1 . nom_professionel AS nom_professionel_27 , t1 . addresse AS addresse_28 , t1 . marques AS marques_29 , t1 . website AS website_30 , t1 . image_size AS image_size_31 , t1 . updated_at AS updated_at_32 , t1 . description AS description_33 , t2 . prenom AS prenom_34 , t2 . nom AS nom_35 , t2 . civility AS civility_36 , t2 . photo AS photo_37 , t2 . image_size AS image_size_38 , t2 . updated_at AS updated_at_39 , t3 . photo AS photo_40 , t3 . image_size AS image_size_41 , t3 . updated_at AS updated_at_42 FROM user t0 LEFT JOIN professionel t1 ON t0 . id = t1 . id LEFT JOIN particulier t2 ON t0 . id = t2 . id LEFT JOIN admin t3 ON t0 . id = t3 . id WHERE t0 . id = 1 ;
Copy
7
3.55 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"1 "
"en "
"App\Entity\User "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '1' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\User' ;
Copy
8
13.57 ms
SELECT t0 . id AS id_4 , t0 . email AS email_5 , t0 . roles AS roles_6 , t0 . password AS password_7 , t0 . type_compte AS type_compte_8 , t0 . is_verified AS is_verified_9 , t0 . tel AS tel_10 , t0 . approve AS approve_11 , t0 . facebook_id AS facebook_id_12 , t0 . is_super_admin AS is_super_admin_13 , t0 . facebook AS facebook_14 , t0 . twitter AS twitter_15 , t0 . instagram AS instagram_16 , t0 . linkedin AS linkedin_17 , t0 . youtube AS youtube_18 , t0 . whatsapp AS whatsapp_19 , t0 . pinterest AS pinterest_20 , t0 . facebook_access_token AS facebook_access_token_21 , t0 . twitter_id AS twitter_id_22 , t0 . twitter_access_token AS twitter_access_token_23 , t0 . google_id AS google_id_24 , t0 . google_access_token AS google_access_token_25 , t0 . compte , t1 . logo AS logo_26 , t1 . nom_professionel AS nom_professionel_27 , t1 . addresse AS addresse_28 , t1 . marques AS marques_29 , t1 . website AS website_30 , t1 . image_size AS image_size_31 , t1 . updated_at AS updated_at_32 , t1 . description AS description_33 , t2 . prenom AS prenom_34 , t2 . nom AS nom_35 , t2 . civility AS civility_36 , t2 . photo AS photo_37 , t2 . image_size AS image_size_38 , t2 . updated_at AS updated_at_39 , t3 . photo AS photo_40 , t3 . image_size AS image_size_41 , t3 . updated_at AS updated_at_42 FROM user t0 LEFT JOIN professionel t1 ON t0 . id = t1 . id LEFT JOIN particulier t2 ON t0 . id = t2 . id LEFT JOIN admin t3 ON t0 . id = t3 . id WHERE t0 . id = ?
SELECT t0 . id AS id_4 , t0 . email AS email_5 , t0 . roles AS roles_6 , t0 . password AS password_7 , t0 . type_compte AS type_compte_8 , t0 . is_verified AS is_verified_9 , t0 . tel AS tel_10 , t0 . approve AS approve_11 , t0 . facebook_id AS facebook_id_12 , t0 . is_super_admin AS is_super_admin_13 , t0 . facebook AS facebook_14 , t0 . twitter AS twitter_15 , t0 . instagram AS instagram_16 , t0 . linkedin AS linkedin_17 , t0 . youtube AS youtube_18 , t0 . whatsapp AS whatsapp_19 , t0 . pinterest AS pinterest_20 , t0 . facebook_access_token AS facebook_access_token_21 , t0 . twitter_id AS twitter_id_22 , t0 . twitter_access_token AS twitter_access_token_23 , t0 . google_id AS google_id_24 , t0 . google_access_token AS google_access_token_25 , t0 . compte , t1 . logo AS logo_26 , t1 . nom_professionel AS nom_professionel_27 , t1 . addresse AS addresse_28 , t1 . marques AS marques_29 , t1 . website AS website_30 , t1 . image_size AS image_size_31 , t1 . updated_at AS updated_at_32 , t1 . description AS description_33 , t2 . prenom AS prenom_34 , t2 . nom AS nom_35 , t2 . civility AS civility_36 , t2 . photo AS photo_37 , t2 . image_size AS image_size_38 , t2 . updated_at AS updated_at_39 , t3 . photo AS photo_40 , t3 . image_size AS image_size_41 , t3 . updated_at AS updated_at_42 FROM user t0 LEFT JOIN professionel t1 ON t0 . id = t1 . id LEFT JOIN particulier t2 ON t0 . id = t2 . id LEFT JOIN admin t3 ON t0 . id = t3 . id WHERE t0 . id = 55 ;
Copy
9
0.24 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"108 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '108' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
10
0.15 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"107 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '107' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
11
0.14 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"106 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '106' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
12
0.13 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"55 "
"en "
"App\Entity\User "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '55' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\User' ;
Copy
13
0.78 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"105 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '105' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
14
0.76 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"103 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '103' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
15
0.14 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"102 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '102' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
16
70.14 ms
SELECT p0_ . id AS id_0 , p0_ . nom AS nom_1 , p0_ . role AS role_2 , p0_ . year AS year_3 , p0_ . logo AS logo_4 , p0_ . image_size AS image_size_5 , p0_ . updated_at AS updated_at_6 , p0_ . description AS description_7 , p0_ . created_at AS created_at_8 , p0_ . theme_portrait AS theme_portrait_9 , p0_ . admin_id AS admin_id_10 FROM portrait p0_ ORDER BY p0_ . id DESC LIMIT 1
SELECT p0_ . id AS id_0 , p0_ . nom AS nom_1 , p0_ . role AS role_2 , p0_ . year AS year_3 , p0_ . logo AS logo_4 , p0_ . image_size AS image_size_5 , p0_ . updated_at AS updated_at_6 , p0_ . description AS description_7 , p0_ . created_at AS created_at_8 , p0_ . theme_portrait AS theme_portrait_9 , p0_ . admin_id AS admin_id_10 FROM portrait p0_ ORDER BY p0_ . id DESC LIMIT 1 ;
Copy
17
9.99 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"2 "
"en "
"App\Entity\Portrait "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '2' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Portrait' ;
Copy
18
21.85 ms
SELECT a0_ . id AS id_0 , t1_ . content AS category_1 , t2_ . content AS marques_2 , t3_ . content AS modeles_3 , t4_ . content AS etats_4 , t5_ . content AS carosseries_5 , a0_ . year AS year_6 , t6_ . content AS kilometrage_7 , t7_ . content AS carburants_8 , t8_ . content AS transmission_9 , t9_ . content AS moteur_10 , t10_ . content AS entrainement_11 , t11_ . content AS couleur_ext_12 , t12_ . content AS couleur_int_13 , a0_ . numero_chassis AS numero_chassis_14 , t13_ . content AS consommationville_15 , t14_ . content AS consommation_route_16 , t15_ . content AS carosserie_equip_17 , t16_ . content AS transmission_equip_18 , t17_ . content AS interieur_equip_19 , t18_ . content AS exterieur_equip_20 , t19_ . content AS electronique_equip_21 , a0_ . dispo_securite AS dispo_securite_22 , a0_ . videos AS videos_23 , t20_ . content AS price_24 , t21_ . content AS description_25 , t22_ . content AS descriptionadd_26 , t23_ . content AS specificationtechniques_27 , t24_ . content AS infosgenerales_28 , a0_ . brochure_filename AS brochure_filename_29 , a0_ . brochure_size AS brochure_size_30 , t25_ . content AS created_at_31 , t26_ . content AS updated_at_32 , a0_ . device AS device_33 , a0_ . regions AS regions_34 , a0_ . villes AS villes_35 , a0_ . communes AS communes_36 , a0_ . address AS address_37 , a0_ . type AS type_38 , a0_ . urgent AS urgent_39 , a0_ . nbrcylindre AS nbrcylindre_40 , a0_ . numero_enregistrement AS numero_enregistrement_41 , a0_ . is_favoris AS is_favoris_42 , a0_ . has_co2 AS has_co2_43 , a0_ . export_price AS export_price_44 , a0_ . bargan_price AS bargan_price_45 , a0_ . is_active AS is_active_46 , a0_ . int_moto AS int_moto_47 , a0_ . electro_moto AS electro_moto_48 , a0_ . disposec_moto AS disposec_moto_49 , a0_ . dispconf_moto AS dispconf_moto_50 , a0_ . lon AS lon_51 , a0_ . lat AS lat_52 , a0_ . duration AS duration_53 , a0_ . comments AS comments_54 , a0_ . note AS note_55 , a0_ . is_compared AS is_compared_56 , a0_ . user_id AS user_id_57 FROM annonce a0_ LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'category' AND t1_ . object_class = 'App\\Entity\\Annonce' AND t1_ . foreign_key = a0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'marques' AND t2_ . object_class = 'App\\Entity\\Annonce' AND t2_ . foreign_key = a0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'modeles' AND t3_ . object_class = 'App\\Entity\\Annonce' AND t3_ . foreign_key = a0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'etats' AND t4_ . object_class = 'App\\Entity\\Annonce' AND t4_ . foreign_key = a0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'carosseries' AND t5_ . object_class = 'App\\Entity\\Annonce' AND t5_ . foreign_key = a0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'kilometrage' AND t6_ . object_class = 'App\\Entity\\Annonce' AND t6_ . foreign_key = a0_ . id LEFT JOIN ext_translations t7_ ON t7_ . locale = 'en' AND t7_ . field = 'carburants' AND t7_ . object_class = 'App\\Entity\\Annonce' AND t7_ . foreign_key = a0_ . id LEFT JOIN ext_translations t8_ ON t8_ . locale = 'en' AND t8_ . field = 'transmission' AND t8_ . object_class = 'App\\Entity\\Annonce' AND t8_ . foreign_key = a0_ . id LEFT JOIN ext_translations t9_ ON t9_ . locale = 'en' AND t9_ . field = 'moteur' AND t9_ . object_class = 'App\\Entity\\Annonce' AND t9_ . foreign_key = a0_ . id LEFT JOIN ext_translations t10_ ON t10_ . locale = 'en' AND t10_ . field = 'entrainement' AND t10_ . object_class = 'App\\Entity\\Annonce' AND t10_ . foreign_key = a0_ . id LEFT JOIN ext_translations t11_ ON t11_ . locale = 'en' AND t11_ . field = 'couleurExt' AND t11_ . object_class = 'App\\Entity\\Annonce' AND t11_ . foreign_key = a0_ . id LEFT JOIN ext_translations t12_ ON t12_ . locale = 'en' AND t12_ . field = 'couleurInt' AND t12_ . object_class = 'App\\Entity\\Annonce' AND t12_ . foreign_key = a0_ . id LEFT JOIN ext_translations t13_ ON t13_ . locale = 'en' AND t13_ . field = 'consommationville' AND t13_ . object_class = 'App\\Entity\\Annonce' AND t13_ . foreign_key = a0_ . id LEFT JOIN ext_translations t14_ ON t14_ . locale = 'en' AND t14_ . field = 'consommationRoute' AND t14_ . object_class = 'App\\Entity\\Annonce' AND t14_ . foreign_key = a0_ . id LEFT JOIN ext_translations t15_ ON t15_ . locale = 'en' AND t15_ . field = 'carosserieEquip' AND t15_ . object_class = 'App\\Entity\\Annonce' AND t15_ . foreign_key = a0_ . id LEFT JOIN ext_translations t16_ ON t16_ . locale = 'en' AND t16_ . field = 'transmissionEquip' AND t16_ . object_class = 'App\\Entity\\Annonce' AND t16_ . foreign_key = a0_ . id LEFT JOIN ext_translations t17_ ON t17_ . locale = 'en' AND t17_ . field = 'InterieurEquip' AND t17_ . object_class = 'App\\Entity\\Annonce' AND t17_ . foreign_key = a0_ . id LEFT JOIN ext_translations t18_ ON t18_ . locale = 'en' AND t18_ . field = 'exterieurEquip' AND t18_ . object_class = 'App\\Entity\\Annonce' AND t18_ . foreign_key = a0_ . id LEFT JOIN ext_translations t19_ ON t19_ . locale = 'en' AND t19_ . field = 'electroniqueEquip' AND t19_ . object_class = 'App\\Entity\\Annonce' AND t19_ . foreign_key = a0_ . id LEFT JOIN ext_translations t20_ ON t20_ . locale = 'en' AND t20_ . field = 'price' AND t20_ . object_class = 'App\\Entity\\Annonce' AND t20_ . foreign_key = a0_ . id LEFT JOIN ext_translations t21_ ON t21_ . locale = 'en' AND t21_ . field = 'description' AND t21_ . object_class = 'App\\Entity\\Annonce' AND t21_ . foreign_key = a0_ . id LEFT JOIN ext_translations t22_ ON t22_ . locale = 'en' AND t22_ . field = 'descriptionadd' AND t22_ . object_class = 'App\\Entity\\Annonce' AND t22_ . foreign_key = a0_ . id LEFT JOIN ext_translations t23_ ON t23_ . locale = 'en' AND t23_ . field = 'specificationtechniques' AND t23_ . object_class = 'App\\Entity\\Annonce' AND t23_ . foreign_key = a0_ . id LEFT JOIN ext_translations t24_ ON t24_ . locale = 'en' AND t24_ . field = 'infosgenerales' AND t24_ . object_class = 'App\\Entity\\Annonce' AND t24_ . foreign_key = a0_ . id LEFT JOIN ext_translations t25_ ON t25_ . locale = 'en' AND t25_ . field = 'created_At' AND t25_ . object_class = 'App\\Entity\\Annonce' AND t25_ . foreign_key = a0_ . id LEFT JOIN ext_translations t26_ ON t26_ . locale = 'en' AND t26_ . field = 'updated_At' AND t26_ . object_class = 'App\\Entity\\Annonce' AND t26_ . foreign_key = a0_ . id WHERE t5_ . content = ? ORDER BY a0_ . id DESC
SELECT
a0_ . id AS id_0 ,
t1_ . content AS category_1 ,
t2_ . content AS marques_2 ,
t3_ . content AS modeles_3 ,
t4_ . content AS etats_4 ,
t5_ . content AS carosseries_5 ,
a0_ . year AS year_6 ,
t6_ . content AS kilometrage_7 ,
t7_ . content AS carburants_8 ,
t8_ . content AS transmission_9 ,
t9_ . content AS moteur_10 ,
t10_ . content AS entrainement_11 ,
t11_ . content AS couleur_ext_12 ,
t12_ . content AS couleur_int_13 ,
a0_ . numero_chassis AS numero_chassis_14 ,
t13_ . content AS consommationville_15 ,
t14_ . content AS consommation_route_16 ,
t15_ . content AS carosserie_equip_17 ,
t16_ . content AS transmission_equip_18 ,
t17_ . content AS interieur_equip_19 ,
t18_ . content AS exterieur_equip_20 ,
t19_ . content AS electronique_equip_21 ,
a0_ . dispo_securite AS dispo_securite_22 ,
a0_ . videos AS videos_23 ,
t20_ . content AS price_24 ,
t21_ . content AS description_25 ,
t22_ . content AS descriptionadd_26 ,
t23_ . content AS specificationtechniques_27 ,
t24_ . content AS infosgenerales_28 ,
a0_ . brochure_filename AS brochure_filename_29 ,
a0_ . brochure_size AS brochure_size_30 ,
t25_ . content AS created_at_31 ,
t26_ . content AS updated_at_32 ,
a0_ . device AS device_33 ,
a0_ . regions AS regions_34 ,
a0_ . villes AS villes_35 ,
a0_ . communes AS communes_36 ,
a0_ . address AS address_37 ,
a0_ . type AS type_38 ,
a0_ . urgent AS urgent_39 ,
a0_ . nbrcylindre AS nbrcylindre_40 ,
a0_ . numero_enregistrement AS numero_enregistrement_41 ,
a0_ . is_favoris AS is_favoris_42 ,
a0_ . has_co2 AS has_co2_43 ,
a0_ . export_price AS export_price_44 ,
a0_ . bargan_price AS bargan_price_45 ,
a0_ . is_active AS is_active_46 ,
a0_ . int_moto AS int_moto_47 ,
a0_ . electro_moto AS electro_moto_48 ,
a0_ . disposec_moto AS disposec_moto_49 ,
a0_ . dispconf_moto AS dispconf_moto_50 ,
a0_ . lon AS lon_51 ,
a0_ . lat AS lat_52 ,
a0_ . duration AS duration_53 ,
a0_ . comments AS comments_54 ,
a0_ . note AS note_55 ,
a0_ . is_compared AS is_compared_56 ,
a0_ . user_id AS user_id_57
FROM
annonce a0_
LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en'
AND t1_ . field = 'category'
AND t1_ . object_class = 'App\\Entity\\Annonce'
AND t1_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en'
AND t2_ . field = 'marques'
AND t2_ . object_class = 'App\\Entity\\Annonce'
AND t2_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en'
AND t3_ . field = 'modeles'
AND t3_ . object_class = 'App\\Entity\\Annonce'
AND t3_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en'
AND t4_ . field = 'etats'
AND t4_ . object_class = 'App\\Entity\\Annonce'
AND t4_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en'
AND t5_ . field = 'carosseries'
AND t5_ . object_class = 'App\\Entity\\Annonce'
AND t5_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en'
AND t6_ . field = 'kilometrage'
AND t6_ . object_class = 'App\\Entity\\Annonce'
AND t6_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t7_ ON t7_ . locale = 'en'
AND t7_ . field = 'carburants'
AND t7_ . object_class = 'App\\Entity\\Annonce'
AND t7_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t8_ ON t8_ . locale = 'en'
AND t8_ . field = 'transmission'
AND t8_ . object_class = 'App\\Entity\\Annonce'
AND t8_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t9_ ON t9_ . locale = 'en'
AND t9_ . field = 'moteur'
AND t9_ . object_class = 'App\\Entity\\Annonce'
AND t9_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t10_ ON t10_ . locale = 'en'
AND t10_ . field = 'entrainement'
AND t10_ . object_class = 'App\\Entity\\Annonce'
AND t10_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t11_ ON t11_ . locale = 'en'
AND t11_ . field = 'couleurExt'
AND t11_ . object_class = 'App\\Entity\\Annonce'
AND t11_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t12_ ON t12_ . locale = 'en'
AND t12_ . field = 'couleurInt'
AND t12_ . object_class = 'App\\Entity\\Annonce'
AND t12_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t13_ ON t13_ . locale = 'en'
AND t13_ . field = 'consommationville'
AND t13_ . object_class = 'App\\Entity\\Annonce'
AND t13_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t14_ ON t14_ . locale = 'en'
AND t14_ . field = 'consommationRoute'
AND t14_ . object_class = 'App\\Entity\\Annonce'
AND t14_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t15_ ON t15_ . locale = 'en'
AND t15_ . field = 'carosserieEquip'
AND t15_ . object_class = 'App\\Entity\\Annonce'
AND t15_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t16_ ON t16_ . locale = 'en'
AND t16_ . field = 'transmissionEquip'
AND t16_ . object_class = 'App\\Entity\\Annonce'
AND t16_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t17_ ON t17_ . locale = 'en'
AND t17_ . field = 'InterieurEquip'
AND t17_ . object_class = 'App\\Entity\\Annonce'
AND t17_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t18_ ON t18_ . locale = 'en'
AND t18_ . field = 'exterieurEquip'
AND t18_ . object_class = 'App\\Entity\\Annonce'
AND t18_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t19_ ON t19_ . locale = 'en'
AND t19_ . field = 'electroniqueEquip'
AND t19_ . object_class = 'App\\Entity\\Annonce'
AND t19_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t20_ ON t20_ . locale = 'en'
AND t20_ . field = 'price'
AND t20_ . object_class = 'App\\Entity\\Annonce'
AND t20_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t21_ ON t21_ . locale = 'en'
AND t21_ . field = 'description'
AND t21_ . object_class = 'App\\Entity\\Annonce'
AND t21_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t22_ ON t22_ . locale = 'en'
AND t22_ . field = 'descriptionadd'
AND t22_ . object_class = 'App\\Entity\\Annonce'
AND t22_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t23_ ON t23_ . locale = 'en'
AND t23_ . field = 'specificationtechniques'
AND t23_ . object_class = 'App\\Entity\\Annonce'
AND t23_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t24_ ON t24_ . locale = 'en'
AND t24_ . field = 'infosgenerales'
AND t24_ . object_class = 'App\\Entity\\Annonce'
AND t24_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t25_ ON t25_ . locale = 'en'
AND t25_ . field = 'created_At'
AND t25_ . object_class = 'App\\Entity\\Annonce'
AND t25_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t26_ ON t26_ . locale = 'en'
AND t26_ . field = 'updated_At'
AND t26_ . object_class = 'App\\Entity\\Annonce'
AND t26_ . foreign_key = a0_ . id
WHERE
t5_ . content = ?
ORDER BY
a0_ . id DESC
Copy
SELECT a0_ . id AS id_0 , t1_ . content AS category_1 , t2_ . content AS marques_2 , t3_ . content AS modeles_3 , t4_ . content AS etats_4 , t5_ . content AS carosseries_5 , a0_ . year AS year_6 , t6_ . content AS kilometrage_7 , t7_ . content AS carburants_8 , t8_ . content AS transmission_9 , t9_ . content AS moteur_10 , t10_ . content AS entrainement_11 , t11_ . content AS couleur_ext_12 , t12_ . content AS couleur_int_13 , a0_ . numero_chassis AS numero_chassis_14 , t13_ . content AS consommationville_15 , t14_ . content AS consommation_route_16 , t15_ . content AS carosserie_equip_17 , t16_ . content AS transmission_equip_18 , t17_ . content AS interieur_equip_19 , t18_ . content AS exterieur_equip_20 , t19_ . content AS electronique_equip_21 , a0_ . dispo_securite AS dispo_securite_22 , a0_ . videos AS videos_23 , t20_ . content AS price_24 , t21_ . content AS description_25 , t22_ . content AS descriptionadd_26 , t23_ . content AS specificationtechniques_27 , t24_ . content AS infosgenerales_28 , a0_ . brochure_filename AS brochure_filename_29 , a0_ . brochure_size AS brochure_size_30 , t25_ . content AS created_at_31 , t26_ . content AS updated_at_32 , a0_ . device AS device_33 , a0_ . regions AS regions_34 , a0_ . villes AS villes_35 , a0_ . communes AS communes_36 , a0_ . address AS address_37 , a0_ . type AS type_38 , a0_ . urgent AS urgent_39 , a0_ . nbrcylindre AS nbrcylindre_40 , a0_ . numero_enregistrement AS numero_enregistrement_41 , a0_ . is_favoris AS is_favoris_42 , a0_ . has_co2 AS has_co2_43 , a0_ . export_price AS export_price_44 , a0_ . bargan_price AS bargan_price_45 , a0_ . is_active AS is_active_46 , a0_ . int_moto AS int_moto_47 , a0_ . electro_moto AS electro_moto_48 , a0_ . disposec_moto AS disposec_moto_49 , a0_ . dispconf_moto AS dispconf_moto_50 , a0_ . lon AS lon_51 , a0_ . lat AS lat_52 , a0_ . duration AS duration_53 , a0_ . comments AS comments_54 , a0_ . note AS note_55 , a0_ . is_compared AS is_compared_56 , a0_ . user_id AS user_id_57 FROM annonce a0_ LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'category' AND t1_ . object_class = 'App\\Entity\\Annonce' AND t1_ . foreign_key = a0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'marques' AND t2_ . object_class = 'App\\Entity\\Annonce' AND t2_ . foreign_key = a0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'modeles' AND t3_ . object_class = 'App\\Entity\\Annonce' AND t3_ . foreign_key = a0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'etats' AND t4_ . object_class = 'App\\Entity\\Annonce' AND t4_ . foreign_key = a0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'carosseries' AND t5_ . object_class = 'App\\Entity\\Annonce' AND t5_ . foreign_key = a0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'kilometrage' AND t6_ . object_class = 'App\\Entity\\Annonce' AND t6_ . foreign_key = a0_ . id LEFT JOIN ext_translations t7_ ON t7_ . locale = 'en' AND t7_ . field = 'carburants' AND t7_ . object_class = 'App\\Entity\\Annonce' AND t7_ . foreign_key = a0_ . id LEFT JOIN ext_translations t8_ ON t8_ . locale = 'en' AND t8_ . field = 'transmission' AND t8_ . object_class = 'App\\Entity\\Annonce' AND t8_ . foreign_key = a0_ . id LEFT JOIN ext_translations t9_ ON t9_ . locale = 'en' AND t9_ . field = 'moteur' AND t9_ . object_class = 'App\\Entity\\Annonce' AND t9_ . foreign_key = a0_ . id LEFT JOIN ext_translations t10_ ON t10_ . locale = 'en' AND t10_ . field = 'entrainement' AND t10_ . object_class = 'App\\Entity\\Annonce' AND t10_ . foreign_key = a0_ . id LEFT JOIN ext_translations t11_ ON t11_ . locale = 'en' AND t11_ . field = 'couleurExt' AND t11_ . object_class = 'App\\Entity\\Annonce' AND t11_ . foreign_key = a0_ . id LEFT JOIN ext_translations t12_ ON t12_ . locale = 'en' AND t12_ . field = 'couleurInt' AND t12_ . object_class = 'App\\Entity\\Annonce' AND t12_ . foreign_key = a0_ . id LEFT JOIN ext_translations t13_ ON t13_ . locale = 'en' AND t13_ . field = 'consommationville' AND t13_ . object_class = 'App\\Entity\\Annonce' AND t13_ . foreign_key = a0_ . id LEFT JOIN ext_translations t14_ ON t14_ . locale = 'en' AND t14_ . field = 'consommationRoute' AND t14_ . object_class = 'App\\Entity\\Annonce' AND t14_ . foreign_key = a0_ . id LEFT JOIN ext_translations t15_ ON t15_ . locale = 'en' AND t15_ . field = 'carosserieEquip' AND t15_ . object_class = 'App\\Entity\\Annonce' AND t15_ . foreign_key = a0_ . id LEFT JOIN ext_translations t16_ ON t16_ . locale = 'en' AND t16_ . field = 'transmissionEquip' AND t16_ . object_class = 'App\\Entity\\Annonce' AND t16_ . foreign_key = a0_ . id LEFT JOIN ext_translations t17_ ON t17_ . locale = 'en' AND t17_ . field = 'InterieurEquip' AND t17_ . object_class = 'App\\Entity\\Annonce' AND t17_ . foreign_key = a0_ . id LEFT JOIN ext_translations t18_ ON t18_ . locale = 'en' AND t18_ . field = 'exterieurEquip' AND t18_ . object_class = 'App\\Entity\\Annonce' AND t18_ . foreign_key = a0_ . id LEFT JOIN ext_translations t19_ ON t19_ . locale = 'en' AND t19_ . field = 'electroniqueEquip' AND t19_ . object_class = 'App\\Entity\\Annonce' AND t19_ . foreign_key = a0_ . id LEFT JOIN ext_translations t20_ ON t20_ . locale = 'en' AND t20_ . field = 'price' AND t20_ . object_class = 'App\\Entity\\Annonce' AND t20_ . foreign_key = a0_ . id LEFT JOIN ext_translations t21_ ON t21_ . locale = 'en' AND t21_ . field = 'description' AND t21_ . object_class = 'App\\Entity\\Annonce' AND t21_ . foreign_key = a0_ . id LEFT JOIN ext_translations t22_ ON t22_ . locale = 'en' AND t22_ . field = 'descriptionadd' AND t22_ . object_class = 'App\\Entity\\Annonce' AND t22_ . foreign_key = a0_ . id LEFT JOIN ext_translations t23_ ON t23_ . locale = 'en' AND t23_ . field = 'specificationtechniques' AND t23_ . object_class = 'App\\Entity\\Annonce' AND t23_ . foreign_key = a0_ . id LEFT JOIN ext_translations t24_ ON t24_ . locale = 'en' AND t24_ . field = 'infosgenerales' AND t24_ . object_class = 'App\\Entity\\Annonce' AND t24_ . foreign_key = a0_ . id LEFT JOIN ext_translations t25_ ON t25_ . locale = 'en' AND t25_ . field = 'created_At' AND t25_ . object_class = 'App\\Entity\\Annonce' AND t25_ . foreign_key = a0_ . id LEFT JOIN ext_translations t26_ ON t26_ . locale = 'en' AND t26_ . field = 'updated_At' AND t26_ . object_class = 'App\\Entity\\Annonce' AND t26_ . foreign_key = a0_ . id WHERE t5_ . content = NULL ORDER BY a0_ . id DESC ;
Copy
19
16.23 ms
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . marques AS marques_3 , t0 . modeles AS modeles_4 , t0 . etats AS etats_5 , t0 . carosseries AS carosseries_6 , t0 . year AS year_7 , t0 . kilometrage AS kilometrage_8 , t0 . carburants AS carburants_9 , t0 . transmission AS transmission_10 , t0 . moteur AS moteur_11 , t0 . entrainement AS entrainement_12 , t0 . couleur_ext AS couleur_ext_13 , t0 . couleur_int AS couleur_int_14 , t0 . numero_chassis AS numero_chassis_15 , t0 . consommationville AS consommationville_16 , t0 . consommation_route AS consommation_route_17 , t0 . carosserie_equip AS carosserie_equip_18 , t0 . transmission_equip AS transmission_equip_19 , t0 . interieur_equip AS interieur_equip_20 , t0 . exterieur_equip AS exterieur_equip_21 , t0 . electronique_equip AS electronique_equip_22 , t0 . dispo_securite AS dispo_securite_23 , t0 . videos AS videos_24 , t0 . price AS price_25 , t0 . description AS description_26 , t0 . descriptionadd AS descriptionadd_27 , t0 . specificationtechniques AS specificationtechniques_28 , t0 . infosgenerales AS infosgenerales_29 , t0 . brochure_filename AS brochure_filename_30 , t0 . brochure_size AS brochure_size_31 , t0 . created_at AS created_at_32 , t0 . updated_at AS updated_at_33 , t0 . device AS device_34 , t0 . regions AS regions_35 , t0 . villes AS villes_36 , t0 . communes AS communes_37 , t0 . address AS address_38 , t0 . type AS type_39 , t0 . urgent AS urgent_40 , t0 . nbrcylindre AS nbrcylindre_41 , t0 . numero_enregistrement AS numero_enregistrement_42 , t0 . is_favoris AS is_favoris_43 , t0 . has_co2 AS has_co2_44 , t0 . export_price AS export_price_45 , t0 . bargan_price AS bargan_price_46 , t0 . is_active AS is_active_47 , t0 . int_moto AS int_moto_48 , t0 . electro_moto AS electro_moto_49 , t0 . disposec_moto AS disposec_moto_50 , t0 . dispconf_moto AS dispconf_moto_51 , t0 . lon AS lon_52 , t0 . lat AS lat_53 , t0 . duration AS duration_54 , t0 . comments AS comments_55 , t0 . note AS note_56 , t0 . is_compared AS is_compared_57 , t0 . user_id AS user_id_58 FROM annonce t0
SELECT
t0 . id AS id_1 ,
t0 . category AS category_2 ,
t0 . marques AS marques_3 ,
t0 . modeles AS modeles_4 ,
t0 . etats AS etats_5 ,
t0 . carosseries AS carosseries_6 ,
t0 . year AS year_7 ,
t0 . kilometrage AS kilometrage_8 ,
t0 . carburants AS carburants_9 ,
t0 . transmission AS transmission_10 ,
t0 . moteur AS moteur_11 ,
t0 . entrainement AS entrainement_12 ,
t0 . couleur_ext AS couleur_ext_13 ,
t0 . couleur_int AS couleur_int_14 ,
t0 . numero_chassis AS numero_chassis_15 ,
t0 . consommationville AS consommationville_16 ,
t0 . consommation_route AS consommation_route_17 ,
t0 . carosserie_equip AS carosserie_equip_18 ,
t0 . transmission_equip AS transmission_equip_19 ,
t0 . interieur_equip AS interieur_equip_20 ,
t0 . exterieur_equip AS exterieur_equip_21 ,
t0 . electronique_equip AS electronique_equip_22 ,
t0 . dispo_securite AS dispo_securite_23 ,
t0 . videos AS videos_24 ,
t0 . price AS price_25 ,
t0 . description AS description_26 ,
t0 . descriptionadd AS descriptionadd_27 ,
t0 . specificationtechniques AS specificationtechniques_28 ,
t0 . infosgenerales AS infosgenerales_29 ,
t0 . brochure_filename AS brochure_filename_30 ,
t0 . brochure_size AS brochure_size_31 ,
t0 . created_at AS created_at_32 ,
t0 . updated_at AS updated_at_33 ,
t0 . device AS device_34 ,
t0 . regions AS regions_35 ,
t0 . villes AS villes_36 ,
t0 . communes AS communes_37 ,
t0 . address AS address_38 ,
t0 . type AS type_39 ,
t0 . urgent AS urgent_40 ,
t0 . nbrcylindre AS nbrcylindre_41 ,
t0 . numero_enregistrement AS numero_enregistrement_42 ,
t0 . is_favoris AS is_favoris_43 ,
t0 . has_co2 AS has_co2_44 ,
t0 . export_price AS export_price_45 ,
t0 . bargan_price AS bargan_price_46 ,
t0 . is_active AS is_active_47 ,
t0 . int_moto AS int_moto_48 ,
t0 . electro_moto AS electro_moto_49 ,
t0 . disposec_moto AS disposec_moto_50 ,
t0 . dispconf_moto AS dispconf_moto_51 ,
t0 . lon AS lon_52 ,
t0 . lat AS lat_53 ,
t0 . duration AS duration_54 ,
t0 . comments AS comments_55 ,
t0 . note AS note_56 ,
t0 . is_compared AS is_compared_57 ,
t0 . user_id AS user_id_58
FROM
annonce t0
Copy
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . marques AS marques_3 , t0 . modeles AS modeles_4 , t0 . etats AS etats_5 , t0 . carosseries AS carosseries_6 , t0 . year AS year_7 , t0 . kilometrage AS kilometrage_8 , t0 . carburants AS carburants_9 , t0 . transmission AS transmission_10 , t0 . moteur AS moteur_11 , t0 . entrainement AS entrainement_12 , t0 . couleur_ext AS couleur_ext_13 , t0 . couleur_int AS couleur_int_14 , t0 . numero_chassis AS numero_chassis_15 , t0 . consommationville AS consommationville_16 , t0 . consommation_route AS consommation_route_17 , t0 . carosserie_equip AS carosserie_equip_18 , t0 . transmission_equip AS transmission_equip_19 , t0 . interieur_equip AS interieur_equip_20 , t0 . exterieur_equip AS exterieur_equip_21 , t0 . electronique_equip AS electronique_equip_22 , t0 . dispo_securite AS dispo_securite_23 , t0 . videos AS videos_24 , t0 . price AS price_25 , t0 . description AS description_26 , t0 . descriptionadd AS descriptionadd_27 , t0 . specificationtechniques AS specificationtechniques_28 , t0 . infosgenerales AS infosgenerales_29 , t0 . brochure_filename AS brochure_filename_30 , t0 . brochure_size AS brochure_size_31 , t0 . created_at AS created_at_32 , t0 . updated_at AS updated_at_33 , t0 . device AS device_34 , t0 . regions AS regions_35 , t0 . villes AS villes_36 , t0 . communes AS communes_37 , t0 . address AS address_38 , t0 . type AS type_39 , t0 . urgent AS urgent_40 , t0 . nbrcylindre AS nbrcylindre_41 , t0 . numero_enregistrement AS numero_enregistrement_42 , t0 . is_favoris AS is_favoris_43 , t0 . has_co2 AS has_co2_44 , t0 . export_price AS export_price_45 , t0 . bargan_price AS bargan_price_46 , t0 . is_active AS is_active_47 , t0 . int_moto AS int_moto_48 , t0 . electro_moto AS electro_moto_49 , t0 . disposec_moto AS disposec_moto_50 , t0 . dispconf_moto AS dispconf_moto_51 , t0 . lon AS lon_52 , t0 . lat AS lat_53 , t0 . duration AS duration_54 , t0 . comments AS comments_55 , t0 . note AS note_56 , t0 . is_compared AS is_compared_57 , t0 . user_id AS user_id_58 FROM annonce t0 ;
Copy
20
0.82 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"31 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '31' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
21
4.48 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"32 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '32' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
22
2.48 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"44 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '44' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
23
1.44 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"51 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '51' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
24
0.15 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"53 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '53' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
25
4.78 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"55 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '55' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
26
1.00 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"56 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '56' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
27
0.77 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"57 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '57' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
28
6.17 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"58 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '58' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
29
0.48 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"59 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '59' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
30
2.52 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"60 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '60' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
31
0.96 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"61 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '61' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
32
0.14 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"62 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '62' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
33
4.77 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"63 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '63' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
34
0.16 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"64 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '64' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
35
4.34 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"65 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '65' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
36
0.19 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"66 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '66' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
37
0.13 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"67 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '67' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
38
2.01 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"68 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '68' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
39
2.08 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"69 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '69' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
40
5.81 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"70 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '70' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
41
0.89 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"71 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '71' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
42
0.45 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"72 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '72' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
43
4.38 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"73 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '73' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
44
1.03 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"74 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '74' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
45
6.54 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"75 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '75' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
46
2.02 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"76 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '76' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
47
0.22 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"77 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '77' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
48
4.46 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"78 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '78' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
49
1.45 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"79 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '79' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
50
0.76 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"80 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '80' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
51
5.08 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"81 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '81' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
52
8.24 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"82 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '82' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
53
0.16 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"83 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '83' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
54
0.15 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"84 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '84' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
55
0.13 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"85 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '85' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
56
0.37 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"86 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '86' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
57
1.33 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"87 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '87' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
58
0.14 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"88 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '88' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
59
2.09 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"89 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '89' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
60
1.08 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"90 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '90' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
61
0.14 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"91 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '91' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
62
0.13 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"92 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '92' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
63
0.14 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"93 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '93' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
64
1.47 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"94 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '94' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
65
1.82 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"95 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '95' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
66
0.74 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"96 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '96' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
67
8.77 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"97 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '97' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
68
1.39 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"98 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '98' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
69
0.14 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"99 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '99' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
70
11.37 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"100 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '100' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
71
0.22 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"101 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '101' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
72
2.26 ms
SELECT a0_ . id AS id_0 , t1_ . content AS category_1 , t2_ . content AS marques_2 , t3_ . content AS modeles_3 , t4_ . content AS etats_4 , t5_ . content AS carosseries_5 , a0_ . year AS year_6 , t6_ . content AS kilometrage_7 , t7_ . content AS carburants_8 , t8_ . content AS transmission_9 , t9_ . content AS moteur_10 , t10_ . content AS entrainement_11 , t11_ . content AS couleur_ext_12 , t12_ . content AS couleur_int_13 , a0_ . numero_chassis AS numero_chassis_14 , t13_ . content AS consommationville_15 , t14_ . content AS consommation_route_16 , t15_ . content AS carosserie_equip_17 , t16_ . content AS transmission_equip_18 , t17_ . content AS interieur_equip_19 , t18_ . content AS exterieur_equip_20 , t19_ . content AS electronique_equip_21 , a0_ . dispo_securite AS dispo_securite_22 , a0_ . videos AS videos_23 , t20_ . content AS price_24 , t21_ . content AS description_25 , t22_ . content AS descriptionadd_26 , t23_ . content AS specificationtechniques_27 , t24_ . content AS infosgenerales_28 , a0_ . brochure_filename AS brochure_filename_29 , a0_ . brochure_size AS brochure_size_30 , t25_ . content AS created_at_31 , t26_ . content AS updated_at_32 , a0_ . device AS device_33 , a0_ . regions AS regions_34 , a0_ . villes AS villes_35 , a0_ . communes AS communes_36 , a0_ . address AS address_37 , a0_ . type AS type_38 , a0_ . urgent AS urgent_39 , a0_ . nbrcylindre AS nbrcylindre_40 , a0_ . numero_enregistrement AS numero_enregistrement_41 , a0_ . is_favoris AS is_favoris_42 , a0_ . has_co2 AS has_co2_43 , a0_ . export_price AS export_price_44 , a0_ . bargan_price AS bargan_price_45 , a0_ . is_active AS is_active_46 , a0_ . int_moto AS int_moto_47 , a0_ . electro_moto AS electro_moto_48 , a0_ . disposec_moto AS disposec_moto_49 , a0_ . dispconf_moto AS dispconf_moto_50 , a0_ . lon AS lon_51 , a0_ . lat AS lat_52 , a0_ . duration AS duration_53 , a0_ . comments AS comments_54 , a0_ . note AS note_55 , a0_ . is_compared AS is_compared_56 , a0_ . user_id AS user_id_57 FROM annonce a0_ LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'category' AND t1_ . object_class = 'App\\Entity\\Annonce' AND t1_ . foreign_key = a0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'marques' AND t2_ . object_class = 'App\\Entity\\Annonce' AND t2_ . foreign_key = a0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'modeles' AND t3_ . object_class = 'App\\Entity\\Annonce' AND t3_ . foreign_key = a0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'etats' AND t4_ . object_class = 'App\\Entity\\Annonce' AND t4_ . foreign_key = a0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'carosseries' AND t5_ . object_class = 'App\\Entity\\Annonce' AND t5_ . foreign_key = a0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'kilometrage' AND t6_ . object_class = 'App\\Entity\\Annonce' AND t6_ . foreign_key = a0_ . id LEFT JOIN ext_translations t7_ ON t7_ . locale = 'en' AND t7_ . field = 'carburants' AND t7_ . object_class = 'App\\Entity\\Annonce' AND t7_ . foreign_key = a0_ . id LEFT JOIN ext_translations t8_ ON t8_ . locale = 'en' AND t8_ . field = 'transmission' AND t8_ . object_class = 'App\\Entity\\Annonce' AND t8_ . foreign_key = a0_ . id LEFT JOIN ext_translations t9_ ON t9_ . locale = 'en' AND t9_ . field = 'moteur' AND t9_ . object_class = 'App\\Entity\\Annonce' AND t9_ . foreign_key = a0_ . id LEFT JOIN ext_translations t10_ ON t10_ . locale = 'en' AND t10_ . field = 'entrainement' AND t10_ . object_class = 'App\\Entity\\Annonce' AND t10_ . foreign_key = a0_ . id LEFT JOIN ext_translations t11_ ON t11_ . locale = 'en' AND t11_ . field = 'couleurExt' AND t11_ . object_class = 'App\\Entity\\Annonce' AND t11_ . foreign_key = a0_ . id LEFT JOIN ext_translations t12_ ON t12_ . locale = 'en' AND t12_ . field = 'couleurInt' AND t12_ . object_class = 'App\\Entity\\Annonce' AND t12_ . foreign_key = a0_ . id LEFT JOIN ext_translations t13_ ON t13_ . locale = 'en' AND t13_ . field = 'consommationville' AND t13_ . object_class = 'App\\Entity\\Annonce' AND t13_ . foreign_key = a0_ . id LEFT JOIN ext_translations t14_ ON t14_ . locale = 'en' AND t14_ . field = 'consommationRoute' AND t14_ . object_class = 'App\\Entity\\Annonce' AND t14_ . foreign_key = a0_ . id LEFT JOIN ext_translations t15_ ON t15_ . locale = 'en' AND t15_ . field = 'carosserieEquip' AND t15_ . object_class = 'App\\Entity\\Annonce' AND t15_ . foreign_key = a0_ . id LEFT JOIN ext_translations t16_ ON t16_ . locale = 'en' AND t16_ . field = 'transmissionEquip' AND t16_ . object_class = 'App\\Entity\\Annonce' AND t16_ . foreign_key = a0_ . id LEFT JOIN ext_translations t17_ ON t17_ . locale = 'en' AND t17_ . field = 'InterieurEquip' AND t17_ . object_class = 'App\\Entity\\Annonce' AND t17_ . foreign_key = a0_ . id LEFT JOIN ext_translations t18_ ON t18_ . locale = 'en' AND t18_ . field = 'exterieurEquip' AND t18_ . object_class = 'App\\Entity\\Annonce' AND t18_ . foreign_key = a0_ . id LEFT JOIN ext_translations t19_ ON t19_ . locale = 'en' AND t19_ . field = 'electroniqueEquip' AND t19_ . object_class = 'App\\Entity\\Annonce' AND t19_ . foreign_key = a0_ . id LEFT JOIN ext_translations t20_ ON t20_ . locale = 'en' AND t20_ . field = 'price' AND t20_ . object_class = 'App\\Entity\\Annonce' AND t20_ . foreign_key = a0_ . id LEFT JOIN ext_translations t21_ ON t21_ . locale = 'en' AND t21_ . field = 'description' AND t21_ . object_class = 'App\\Entity\\Annonce' AND t21_ . foreign_key = a0_ . id LEFT JOIN ext_translations t22_ ON t22_ . locale = 'en' AND t22_ . field = 'descriptionadd' AND t22_ . object_class = 'App\\Entity\\Annonce' AND t22_ . foreign_key = a0_ . id LEFT JOIN ext_translations t23_ ON t23_ . locale = 'en' AND t23_ . field = 'specificationtechniques' AND t23_ . object_class = 'App\\Entity\\Annonce' AND t23_ . foreign_key = a0_ . id LEFT JOIN ext_translations t24_ ON t24_ . locale = 'en' AND t24_ . field = 'infosgenerales' AND t24_ . object_class = 'App\\Entity\\Annonce' AND t24_ . foreign_key = a0_ . id LEFT JOIN ext_translations t25_ ON t25_ . locale = 'en' AND t25_ . field = 'created_At' AND t25_ . object_class = 'App\\Entity\\Annonce' AND t25_ . foreign_key = a0_ . id LEFT JOIN ext_translations t26_ ON t26_ . locale = 'en' AND t26_ . field = 'updated_At' AND t26_ . object_class = 'App\\Entity\\Annonce' AND t26_ . foreign_key = a0_ . id WHERE a0_ . type = ? ORDER BY a0_ . id DESC
Parameters :
[
"Prestige "
]
SELECT
a0_ . id AS id_0 ,
t1_ . content AS category_1 ,
t2_ . content AS marques_2 ,
t3_ . content AS modeles_3 ,
t4_ . content AS etats_4 ,
t5_ . content AS carosseries_5 ,
a0_ . year AS year_6 ,
t6_ . content AS kilometrage_7 ,
t7_ . content AS carburants_8 ,
t8_ . content AS transmission_9 ,
t9_ . content AS moteur_10 ,
t10_ . content AS entrainement_11 ,
t11_ . content AS couleur_ext_12 ,
t12_ . content AS couleur_int_13 ,
a0_ . numero_chassis AS numero_chassis_14 ,
t13_ . content AS consommationville_15 ,
t14_ . content AS consommation_route_16 ,
t15_ . content AS carosserie_equip_17 ,
t16_ . content AS transmission_equip_18 ,
t17_ . content AS interieur_equip_19 ,
t18_ . content AS exterieur_equip_20 ,
t19_ . content AS electronique_equip_21 ,
a0_ . dispo_securite AS dispo_securite_22 ,
a0_ . videos AS videos_23 ,
t20_ . content AS price_24 ,
t21_ . content AS description_25 ,
t22_ . content AS descriptionadd_26 ,
t23_ . content AS specificationtechniques_27 ,
t24_ . content AS infosgenerales_28 ,
a0_ . brochure_filename AS brochure_filename_29 ,
a0_ . brochure_size AS brochure_size_30 ,
t25_ . content AS created_at_31 ,
t26_ . content AS updated_at_32 ,
a0_ . device AS device_33 ,
a0_ . regions AS regions_34 ,
a0_ . villes AS villes_35 ,
a0_ . communes AS communes_36 ,
a0_ . address AS address_37 ,
a0_ . type AS type_38 ,
a0_ . urgent AS urgent_39 ,
a0_ . nbrcylindre AS nbrcylindre_40 ,
a0_ . numero_enregistrement AS numero_enregistrement_41 ,
a0_ . is_favoris AS is_favoris_42 ,
a0_ . has_co2 AS has_co2_43 ,
a0_ . export_price AS export_price_44 ,
a0_ . bargan_price AS bargan_price_45 ,
a0_ . is_active AS is_active_46 ,
a0_ . int_moto AS int_moto_47 ,
a0_ . electro_moto AS electro_moto_48 ,
a0_ . disposec_moto AS disposec_moto_49 ,
a0_ . dispconf_moto AS dispconf_moto_50 ,
a0_ . lon AS lon_51 ,
a0_ . lat AS lat_52 ,
a0_ . duration AS duration_53 ,
a0_ . comments AS comments_54 ,
a0_ . note AS note_55 ,
a0_ . is_compared AS is_compared_56 ,
a0_ . user_id AS user_id_57
FROM
annonce a0_
LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en'
AND t1_ . field = 'category'
AND t1_ . object_class = 'App\\Entity\\Annonce'
AND t1_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en'
AND t2_ . field = 'marques'
AND t2_ . object_class = 'App\\Entity\\Annonce'
AND t2_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en'
AND t3_ . field = 'modeles'
AND t3_ . object_class = 'App\\Entity\\Annonce'
AND t3_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en'
AND t4_ . field = 'etats'
AND t4_ . object_class = 'App\\Entity\\Annonce'
AND t4_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en'
AND t5_ . field = 'carosseries'
AND t5_ . object_class = 'App\\Entity\\Annonce'
AND t5_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en'
AND t6_ . field = 'kilometrage'
AND t6_ . object_class = 'App\\Entity\\Annonce'
AND t6_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t7_ ON t7_ . locale = 'en'
AND t7_ . field = 'carburants'
AND t7_ . object_class = 'App\\Entity\\Annonce'
AND t7_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t8_ ON t8_ . locale = 'en'
AND t8_ . field = 'transmission'
AND t8_ . object_class = 'App\\Entity\\Annonce'
AND t8_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t9_ ON t9_ . locale = 'en'
AND t9_ . field = 'moteur'
AND t9_ . object_class = 'App\\Entity\\Annonce'
AND t9_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t10_ ON t10_ . locale = 'en'
AND t10_ . field = 'entrainement'
AND t10_ . object_class = 'App\\Entity\\Annonce'
AND t10_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t11_ ON t11_ . locale = 'en'
AND t11_ . field = 'couleurExt'
AND t11_ . object_class = 'App\\Entity\\Annonce'
AND t11_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t12_ ON t12_ . locale = 'en'
AND t12_ . field = 'couleurInt'
AND t12_ . object_class = 'App\\Entity\\Annonce'
AND t12_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t13_ ON t13_ . locale = 'en'
AND t13_ . field = 'consommationville'
AND t13_ . object_class = 'App\\Entity\\Annonce'
AND t13_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t14_ ON t14_ . locale = 'en'
AND t14_ . field = 'consommationRoute'
AND t14_ . object_class = 'App\\Entity\\Annonce'
AND t14_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t15_ ON t15_ . locale = 'en'
AND t15_ . field = 'carosserieEquip'
AND t15_ . object_class = 'App\\Entity\\Annonce'
AND t15_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t16_ ON t16_ . locale = 'en'
AND t16_ . field = 'transmissionEquip'
AND t16_ . object_class = 'App\\Entity\\Annonce'
AND t16_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t17_ ON t17_ . locale = 'en'
AND t17_ . field = 'InterieurEquip'
AND t17_ . object_class = 'App\\Entity\\Annonce'
AND t17_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t18_ ON t18_ . locale = 'en'
AND t18_ . field = 'exterieurEquip'
AND t18_ . object_class = 'App\\Entity\\Annonce'
AND t18_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t19_ ON t19_ . locale = 'en'
AND t19_ . field = 'electroniqueEquip'
AND t19_ . object_class = 'App\\Entity\\Annonce'
AND t19_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t20_ ON t20_ . locale = 'en'
AND t20_ . field = 'price'
AND t20_ . object_class = 'App\\Entity\\Annonce'
AND t20_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t21_ ON t21_ . locale = 'en'
AND t21_ . field = 'description'
AND t21_ . object_class = 'App\\Entity\\Annonce'
AND t21_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t22_ ON t22_ . locale = 'en'
AND t22_ . field = 'descriptionadd'
AND t22_ . object_class = 'App\\Entity\\Annonce'
AND t22_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t23_ ON t23_ . locale = 'en'
AND t23_ . field = 'specificationtechniques'
AND t23_ . object_class = 'App\\Entity\\Annonce'
AND t23_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t24_ ON t24_ . locale = 'en'
AND t24_ . field = 'infosgenerales'
AND t24_ . object_class = 'App\\Entity\\Annonce'
AND t24_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t25_ ON t25_ . locale = 'en'
AND t25_ . field = 'created_At'
AND t25_ . object_class = 'App\\Entity\\Annonce'
AND t25_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t26_ ON t26_ . locale = 'en'
AND t26_ . field = 'updated_At'
AND t26_ . object_class = 'App\\Entity\\Annonce'
AND t26_ . foreign_key = a0_ . id
WHERE
a0_ . type = ?
ORDER BY
a0_ . id DESC
Copy
SELECT a0_ . id AS id_0 , t1_ . content AS category_1 , t2_ . content AS marques_2 , t3_ . content AS modeles_3 , t4_ . content AS etats_4 , t5_ . content AS carosseries_5 , a0_ . year AS year_6 , t6_ . content AS kilometrage_7 , t7_ . content AS carburants_8 , t8_ . content AS transmission_9 , t9_ . content AS moteur_10 , t10_ . content AS entrainement_11 , t11_ . content AS couleur_ext_12 , t12_ . content AS couleur_int_13 , a0_ . numero_chassis AS numero_chassis_14 , t13_ . content AS consommationville_15 , t14_ . content AS consommation_route_16 , t15_ . content AS carosserie_equip_17 , t16_ . content AS transmission_equip_18 , t17_ . content AS interieur_equip_19 , t18_ . content AS exterieur_equip_20 , t19_ . content AS electronique_equip_21 , a0_ . dispo_securite AS dispo_securite_22 , a0_ . videos AS videos_23 , t20_ . content AS price_24 , t21_ . content AS description_25 , t22_ . content AS descriptionadd_26 , t23_ . content AS specificationtechniques_27 , t24_ . content AS infosgenerales_28 , a0_ . brochure_filename AS brochure_filename_29 , a0_ . brochure_size AS brochure_size_30 , t25_ . content AS created_at_31 , t26_ . content AS updated_at_32 , a0_ . device AS device_33 , a0_ . regions AS regions_34 , a0_ . villes AS villes_35 , a0_ . communes AS communes_36 , a0_ . address AS address_37 , a0_ . type AS type_38 , a0_ . urgent AS urgent_39 , a0_ . nbrcylindre AS nbrcylindre_40 , a0_ . numero_enregistrement AS numero_enregistrement_41 , a0_ . is_favoris AS is_favoris_42 , a0_ . has_co2 AS has_co2_43 , a0_ . export_price AS export_price_44 , a0_ . bargan_price AS bargan_price_45 , a0_ . is_active AS is_active_46 , a0_ . int_moto AS int_moto_47 , a0_ . electro_moto AS electro_moto_48 , a0_ . disposec_moto AS disposec_moto_49 , a0_ . dispconf_moto AS dispconf_moto_50 , a0_ . lon AS lon_51 , a0_ . lat AS lat_52 , a0_ . duration AS duration_53 , a0_ . comments AS comments_54 , a0_ . note AS note_55 , a0_ . is_compared AS is_compared_56 , a0_ . user_id AS user_id_57 FROM annonce a0_ LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'category' AND t1_ . object_class = 'App\\Entity\\Annonce' AND t1_ . foreign_key = a0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'marques' AND t2_ . object_class = 'App\\Entity\\Annonce' AND t2_ . foreign_key = a0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'modeles' AND t3_ . object_class = 'App\\Entity\\Annonce' AND t3_ . foreign_key = a0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'etats' AND t4_ . object_class = 'App\\Entity\\Annonce' AND t4_ . foreign_key = a0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'carosseries' AND t5_ . object_class = 'App\\Entity\\Annonce' AND t5_ . foreign_key = a0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'kilometrage' AND t6_ . object_class = 'App\\Entity\\Annonce' AND t6_ . foreign_key = a0_ . id LEFT JOIN ext_translations t7_ ON t7_ . locale = 'en' AND t7_ . field = 'carburants' AND t7_ . object_class = 'App\\Entity\\Annonce' AND t7_ . foreign_key = a0_ . id LEFT JOIN ext_translations t8_ ON t8_ . locale = 'en' AND t8_ . field = 'transmission' AND t8_ . object_class = 'App\\Entity\\Annonce' AND t8_ . foreign_key = a0_ . id LEFT JOIN ext_translations t9_ ON t9_ . locale = 'en' AND t9_ . field = 'moteur' AND t9_ . object_class = 'App\\Entity\\Annonce' AND t9_ . foreign_key = a0_ . id LEFT JOIN ext_translations t10_ ON t10_ . locale = 'en' AND t10_ . field = 'entrainement' AND t10_ . object_class = 'App\\Entity\\Annonce' AND t10_ . foreign_key = a0_ . id LEFT JOIN ext_translations t11_ ON t11_ . locale = 'en' AND t11_ . field = 'couleurExt' AND t11_ . object_class = 'App\\Entity\\Annonce' AND t11_ . foreign_key = a0_ . id LEFT JOIN ext_translations t12_ ON t12_ . locale = 'en' AND t12_ . field = 'couleurInt' AND t12_ . object_class = 'App\\Entity\\Annonce' AND t12_ . foreign_key = a0_ . id LEFT JOIN ext_translations t13_ ON t13_ . locale = 'en' AND t13_ . field = 'consommationville' AND t13_ . object_class = 'App\\Entity\\Annonce' AND t13_ . foreign_key = a0_ . id LEFT JOIN ext_translations t14_ ON t14_ . locale = 'en' AND t14_ . field = 'consommationRoute' AND t14_ . object_class = 'App\\Entity\\Annonce' AND t14_ . foreign_key = a0_ . id LEFT JOIN ext_translations t15_ ON t15_ . locale = 'en' AND t15_ . field = 'carosserieEquip' AND t15_ . object_class = 'App\\Entity\\Annonce' AND t15_ . foreign_key = a0_ . id LEFT JOIN ext_translations t16_ ON t16_ . locale = 'en' AND t16_ . field = 'transmissionEquip' AND t16_ . object_class = 'App\\Entity\\Annonce' AND t16_ . foreign_key = a0_ . id LEFT JOIN ext_translations t17_ ON t17_ . locale = 'en' AND t17_ . field = 'InterieurEquip' AND t17_ . object_class = 'App\\Entity\\Annonce' AND t17_ . foreign_key = a0_ . id LEFT JOIN ext_translations t18_ ON t18_ . locale = 'en' AND t18_ . field = 'exterieurEquip' AND t18_ . object_class = 'App\\Entity\\Annonce' AND t18_ . foreign_key = a0_ . id LEFT JOIN ext_translations t19_ ON t19_ . locale = 'en' AND t19_ . field = 'electroniqueEquip' AND t19_ . object_class = 'App\\Entity\\Annonce' AND t19_ . foreign_key = a0_ . id LEFT JOIN ext_translations t20_ ON t20_ . locale = 'en' AND t20_ . field = 'price' AND t20_ . object_class = 'App\\Entity\\Annonce' AND t20_ . foreign_key = a0_ . id LEFT JOIN ext_translations t21_ ON t21_ . locale = 'en' AND t21_ . field = 'description' AND t21_ . object_class = 'App\\Entity\\Annonce' AND t21_ . foreign_key = a0_ . id LEFT JOIN ext_translations t22_ ON t22_ . locale = 'en' AND t22_ . field = 'descriptionadd' AND t22_ . object_class = 'App\\Entity\\Annonce' AND t22_ . foreign_key = a0_ . id LEFT JOIN ext_translations t23_ ON t23_ . locale = 'en' AND t23_ . field = 'specificationtechniques' AND t23_ . object_class = 'App\\Entity\\Annonce' AND t23_ . foreign_key = a0_ . id LEFT JOIN ext_translations t24_ ON t24_ . locale = 'en' AND t24_ . field = 'infosgenerales' AND t24_ . object_class = 'App\\Entity\\Annonce' AND t24_ . foreign_key = a0_ . id LEFT JOIN ext_translations t25_ ON t25_ . locale = 'en' AND t25_ . field = 'created_At' AND t25_ . object_class = 'App\\Entity\\Annonce' AND t25_ . foreign_key = a0_ . id LEFT JOIN ext_translations t26_ ON t26_ . locale = 'en' AND t26_ . field = 'updated_At' AND t26_ . object_class = 'App\\Entity\\Annonce' AND t26_ . foreign_key = a0_ . id WHERE a0_ . type = 'Prestige' ORDER BY a0_ . id DESC ;
Copy
73
2.16 ms
SELECT a0_ . id AS id_0 , t1_ . content AS category_1 , t2_ . content AS marques_2 , t3_ . content AS modeles_3 , t4_ . content AS etats_4 , t5_ . content AS carosseries_5 , a0_ . year AS year_6 , t6_ . content AS kilometrage_7 , t7_ . content AS carburants_8 , t8_ . content AS transmission_9 , t9_ . content AS moteur_10 , t10_ . content AS entrainement_11 , t11_ . content AS couleur_ext_12 , t12_ . content AS couleur_int_13 , a0_ . numero_chassis AS numero_chassis_14 , t13_ . content AS consommationville_15 , t14_ . content AS consommation_route_16 , t15_ . content AS carosserie_equip_17 , t16_ . content AS transmission_equip_18 , t17_ . content AS interieur_equip_19 , t18_ . content AS exterieur_equip_20 , t19_ . content AS electronique_equip_21 , a0_ . dispo_securite AS dispo_securite_22 , a0_ . videos AS videos_23 , t20_ . content AS price_24 , t21_ . content AS description_25 , t22_ . content AS descriptionadd_26 , t23_ . content AS specificationtechniques_27 , t24_ . content AS infosgenerales_28 , a0_ . brochure_filename AS brochure_filename_29 , a0_ . brochure_size AS brochure_size_30 , t25_ . content AS created_at_31 , t26_ . content AS updated_at_32 , a0_ . device AS device_33 , a0_ . regions AS regions_34 , a0_ . villes AS villes_35 , a0_ . communes AS communes_36 , a0_ . address AS address_37 , a0_ . type AS type_38 , a0_ . urgent AS urgent_39 , a0_ . nbrcylindre AS nbrcylindre_40 , a0_ . numero_enregistrement AS numero_enregistrement_41 , a0_ . is_favoris AS is_favoris_42 , a0_ . has_co2 AS has_co2_43 , a0_ . export_price AS export_price_44 , a0_ . bargan_price AS bargan_price_45 , a0_ . is_active AS is_active_46 , a0_ . int_moto AS int_moto_47 , a0_ . electro_moto AS electro_moto_48 , a0_ . disposec_moto AS disposec_moto_49 , a0_ . dispconf_moto AS dispconf_moto_50 , a0_ . lon AS lon_51 , a0_ . lat AS lat_52 , a0_ . duration AS duration_53 , a0_ . comments AS comments_54 , a0_ . note AS note_55 , a0_ . is_compared AS is_compared_56 , a0_ . user_id AS user_id_57 FROM annonce a0_ LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'category' AND t1_ . object_class = 'App\\Entity\\Annonce' AND t1_ . foreign_key = a0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'marques' AND t2_ . object_class = 'App\\Entity\\Annonce' AND t2_ . foreign_key = a0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'modeles' AND t3_ . object_class = 'App\\Entity\\Annonce' AND t3_ . foreign_key = a0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'etats' AND t4_ . object_class = 'App\\Entity\\Annonce' AND t4_ . foreign_key = a0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'carosseries' AND t5_ . object_class = 'App\\Entity\\Annonce' AND t5_ . foreign_key = a0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'kilometrage' AND t6_ . object_class = 'App\\Entity\\Annonce' AND t6_ . foreign_key = a0_ . id LEFT JOIN ext_translations t7_ ON t7_ . locale = 'en' AND t7_ . field = 'carburants' AND t7_ . object_class = 'App\\Entity\\Annonce' AND t7_ . foreign_key = a0_ . id LEFT JOIN ext_translations t8_ ON t8_ . locale = 'en' AND t8_ . field = 'transmission' AND t8_ . object_class = 'App\\Entity\\Annonce' AND t8_ . foreign_key = a0_ . id LEFT JOIN ext_translations t9_ ON t9_ . locale = 'en' AND t9_ . field = 'moteur' AND t9_ . object_class = 'App\\Entity\\Annonce' AND t9_ . foreign_key = a0_ . id LEFT JOIN ext_translations t10_ ON t10_ . locale = 'en' AND t10_ . field = 'entrainement' AND t10_ . object_class = 'App\\Entity\\Annonce' AND t10_ . foreign_key = a0_ . id LEFT JOIN ext_translations t11_ ON t11_ . locale = 'en' AND t11_ . field = 'couleurExt' AND t11_ . object_class = 'App\\Entity\\Annonce' AND t11_ . foreign_key = a0_ . id LEFT JOIN ext_translations t12_ ON t12_ . locale = 'en' AND t12_ . field = 'couleurInt' AND t12_ . object_class = 'App\\Entity\\Annonce' AND t12_ . foreign_key = a0_ . id LEFT JOIN ext_translations t13_ ON t13_ . locale = 'en' AND t13_ . field = 'consommationville' AND t13_ . object_class = 'App\\Entity\\Annonce' AND t13_ . foreign_key = a0_ . id LEFT JOIN ext_translations t14_ ON t14_ . locale = 'en' AND t14_ . field = 'consommationRoute' AND t14_ . object_class = 'App\\Entity\\Annonce' AND t14_ . foreign_key = a0_ . id LEFT JOIN ext_translations t15_ ON t15_ . locale = 'en' AND t15_ . field = 'carosserieEquip' AND t15_ . object_class = 'App\\Entity\\Annonce' AND t15_ . foreign_key = a0_ . id LEFT JOIN ext_translations t16_ ON t16_ . locale = 'en' AND t16_ . field = 'transmissionEquip' AND t16_ . object_class = 'App\\Entity\\Annonce' AND t16_ . foreign_key = a0_ . id LEFT JOIN ext_translations t17_ ON t17_ . locale = 'en' AND t17_ . field = 'InterieurEquip' AND t17_ . object_class = 'App\\Entity\\Annonce' AND t17_ . foreign_key = a0_ . id LEFT JOIN ext_translations t18_ ON t18_ . locale = 'en' AND t18_ . field = 'exterieurEquip' AND t18_ . object_class = 'App\\Entity\\Annonce' AND t18_ . foreign_key = a0_ . id LEFT JOIN ext_translations t19_ ON t19_ . locale = 'en' AND t19_ . field = 'electroniqueEquip' AND t19_ . object_class = 'App\\Entity\\Annonce' AND t19_ . foreign_key = a0_ . id LEFT JOIN ext_translations t20_ ON t20_ . locale = 'en' AND t20_ . field = 'price' AND t20_ . object_class = 'App\\Entity\\Annonce' AND t20_ . foreign_key = a0_ . id LEFT JOIN ext_translations t21_ ON t21_ . locale = 'en' AND t21_ . field = 'description' AND t21_ . object_class = 'App\\Entity\\Annonce' AND t21_ . foreign_key = a0_ . id LEFT JOIN ext_translations t22_ ON t22_ . locale = 'en' AND t22_ . field = 'descriptionadd' AND t22_ . object_class = 'App\\Entity\\Annonce' AND t22_ . foreign_key = a0_ . id LEFT JOIN ext_translations t23_ ON t23_ . locale = 'en' AND t23_ . field = 'specificationtechniques' AND t23_ . object_class = 'App\\Entity\\Annonce' AND t23_ . foreign_key = a0_ . id LEFT JOIN ext_translations t24_ ON t24_ . locale = 'en' AND t24_ . field = 'infosgenerales' AND t24_ . object_class = 'App\\Entity\\Annonce' AND t24_ . foreign_key = a0_ . id LEFT JOIN ext_translations t25_ ON t25_ . locale = 'en' AND t25_ . field = 'created_At' AND t25_ . object_class = 'App\\Entity\\Annonce' AND t25_ . foreign_key = a0_ . id LEFT JOIN ext_translations t26_ ON t26_ . locale = 'en' AND t26_ . field = 'updated_At' AND t26_ . object_class = 'App\\Entity\\Annonce' AND t26_ . foreign_key = a0_ . id WHERE a0_ . type = ? ORDER BY a0_ . id DESC
SELECT
a0_ . id AS id_0 ,
t1_ . content AS category_1 ,
t2_ . content AS marques_2 ,
t3_ . content AS modeles_3 ,
t4_ . content AS etats_4 ,
t5_ . content AS carosseries_5 ,
a0_ . year AS year_6 ,
t6_ . content AS kilometrage_7 ,
t7_ . content AS carburants_8 ,
t8_ . content AS transmission_9 ,
t9_ . content AS moteur_10 ,
t10_ . content AS entrainement_11 ,
t11_ . content AS couleur_ext_12 ,
t12_ . content AS couleur_int_13 ,
a0_ . numero_chassis AS numero_chassis_14 ,
t13_ . content AS consommationville_15 ,
t14_ . content AS consommation_route_16 ,
t15_ . content AS carosserie_equip_17 ,
t16_ . content AS transmission_equip_18 ,
t17_ . content AS interieur_equip_19 ,
t18_ . content AS exterieur_equip_20 ,
t19_ . content AS electronique_equip_21 ,
a0_ . dispo_securite AS dispo_securite_22 ,
a0_ . videos AS videos_23 ,
t20_ . content AS price_24 ,
t21_ . content AS description_25 ,
t22_ . content AS descriptionadd_26 ,
t23_ . content AS specificationtechniques_27 ,
t24_ . content AS infosgenerales_28 ,
a0_ . brochure_filename AS brochure_filename_29 ,
a0_ . brochure_size AS brochure_size_30 ,
t25_ . content AS created_at_31 ,
t26_ . content AS updated_at_32 ,
a0_ . device AS device_33 ,
a0_ . regions AS regions_34 ,
a0_ . villes AS villes_35 ,
a0_ . communes AS communes_36 ,
a0_ . address AS address_37 ,
a0_ . type AS type_38 ,
a0_ . urgent AS urgent_39 ,
a0_ . nbrcylindre AS nbrcylindre_40 ,
a0_ . numero_enregistrement AS numero_enregistrement_41 ,
a0_ . is_favoris AS is_favoris_42 ,
a0_ . has_co2 AS has_co2_43 ,
a0_ . export_price AS export_price_44 ,
a0_ . bargan_price AS bargan_price_45 ,
a0_ . is_active AS is_active_46 ,
a0_ . int_moto AS int_moto_47 ,
a0_ . electro_moto AS electro_moto_48 ,
a0_ . disposec_moto AS disposec_moto_49 ,
a0_ . dispconf_moto AS dispconf_moto_50 ,
a0_ . lon AS lon_51 ,
a0_ . lat AS lat_52 ,
a0_ . duration AS duration_53 ,
a0_ . comments AS comments_54 ,
a0_ . note AS note_55 ,
a0_ . is_compared AS is_compared_56 ,
a0_ . user_id AS user_id_57
FROM
annonce a0_
LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en'
AND t1_ . field = 'category'
AND t1_ . object_class = 'App\\Entity\\Annonce'
AND t1_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en'
AND t2_ . field = 'marques'
AND t2_ . object_class = 'App\\Entity\\Annonce'
AND t2_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en'
AND t3_ . field = 'modeles'
AND t3_ . object_class = 'App\\Entity\\Annonce'
AND t3_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en'
AND t4_ . field = 'etats'
AND t4_ . object_class = 'App\\Entity\\Annonce'
AND t4_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en'
AND t5_ . field = 'carosseries'
AND t5_ . object_class = 'App\\Entity\\Annonce'
AND t5_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en'
AND t6_ . field = 'kilometrage'
AND t6_ . object_class = 'App\\Entity\\Annonce'
AND t6_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t7_ ON t7_ . locale = 'en'
AND t7_ . field = 'carburants'
AND t7_ . object_class = 'App\\Entity\\Annonce'
AND t7_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t8_ ON t8_ . locale = 'en'
AND t8_ . field = 'transmission'
AND t8_ . object_class = 'App\\Entity\\Annonce'
AND t8_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t9_ ON t9_ . locale = 'en'
AND t9_ . field = 'moteur'
AND t9_ . object_class = 'App\\Entity\\Annonce'
AND t9_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t10_ ON t10_ . locale = 'en'
AND t10_ . field = 'entrainement'
AND t10_ . object_class = 'App\\Entity\\Annonce'
AND t10_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t11_ ON t11_ . locale = 'en'
AND t11_ . field = 'couleurExt'
AND t11_ . object_class = 'App\\Entity\\Annonce'
AND t11_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t12_ ON t12_ . locale = 'en'
AND t12_ . field = 'couleurInt'
AND t12_ . object_class = 'App\\Entity\\Annonce'
AND t12_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t13_ ON t13_ . locale = 'en'
AND t13_ . field = 'consommationville'
AND t13_ . object_class = 'App\\Entity\\Annonce'
AND t13_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t14_ ON t14_ . locale = 'en'
AND t14_ . field = 'consommationRoute'
AND t14_ . object_class = 'App\\Entity\\Annonce'
AND t14_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t15_ ON t15_ . locale = 'en'
AND t15_ . field = 'carosserieEquip'
AND t15_ . object_class = 'App\\Entity\\Annonce'
AND t15_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t16_ ON t16_ . locale = 'en'
AND t16_ . field = 'transmissionEquip'
AND t16_ . object_class = 'App\\Entity\\Annonce'
AND t16_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t17_ ON t17_ . locale = 'en'
AND t17_ . field = 'InterieurEquip'
AND t17_ . object_class = 'App\\Entity\\Annonce'
AND t17_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t18_ ON t18_ . locale = 'en'
AND t18_ . field = 'exterieurEquip'
AND t18_ . object_class = 'App\\Entity\\Annonce'
AND t18_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t19_ ON t19_ . locale = 'en'
AND t19_ . field = 'electroniqueEquip'
AND t19_ . object_class = 'App\\Entity\\Annonce'
AND t19_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t20_ ON t20_ . locale = 'en'
AND t20_ . field = 'price'
AND t20_ . object_class = 'App\\Entity\\Annonce'
AND t20_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t21_ ON t21_ . locale = 'en'
AND t21_ . field = 'description'
AND t21_ . object_class = 'App\\Entity\\Annonce'
AND t21_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t22_ ON t22_ . locale = 'en'
AND t22_ . field = 'descriptionadd'
AND t22_ . object_class = 'App\\Entity\\Annonce'
AND t22_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t23_ ON t23_ . locale = 'en'
AND t23_ . field = 'specificationtechniques'
AND t23_ . object_class = 'App\\Entity\\Annonce'
AND t23_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t24_ ON t24_ . locale = 'en'
AND t24_ . field = 'infosgenerales'
AND t24_ . object_class = 'App\\Entity\\Annonce'
AND t24_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t25_ ON t25_ . locale = 'en'
AND t25_ . field = 'created_At'
AND t25_ . object_class = 'App\\Entity\\Annonce'
AND t25_ . foreign_key = a0_ . id
LEFT JOIN ext_translations t26_ ON t26_ . locale = 'en'
AND t26_ . field = 'updated_At'
AND t26_ . object_class = 'App\\Entity\\Annonce'
AND t26_ . foreign_key = a0_ . id
WHERE
a0_ . type = ?
ORDER BY
a0_ . id DESC
Copy
SELECT a0_ . id AS id_0 , t1_ . content AS category_1 , t2_ . content AS marques_2 , t3_ . content AS modeles_3 , t4_ . content AS etats_4 , t5_ . content AS carosseries_5 , a0_ . year AS year_6 , t6_ . content AS kilometrage_7 , t7_ . content AS carburants_8 , t8_ . content AS transmission_9 , t9_ . content AS moteur_10 , t10_ . content AS entrainement_11 , t11_ . content AS couleur_ext_12 , t12_ . content AS couleur_int_13 , a0_ . numero_chassis AS numero_chassis_14 , t13_ . content AS consommationville_15 , t14_ . content AS consommation_route_16 , t15_ . content AS carosserie_equip_17 , t16_ . content AS transmission_equip_18 , t17_ . content AS interieur_equip_19 , t18_ . content AS exterieur_equip_20 , t19_ . content AS electronique_equip_21 , a0_ . dispo_securite AS dispo_securite_22 , a0_ . videos AS videos_23 , t20_ . content AS price_24 , t21_ . content AS description_25 , t22_ . content AS descriptionadd_26 , t23_ . content AS specificationtechniques_27 , t24_ . content AS infosgenerales_28 , a0_ . brochure_filename AS brochure_filename_29 , a0_ . brochure_size AS brochure_size_30 , t25_ . content AS created_at_31 , t26_ . content AS updated_at_32 , a0_ . device AS device_33 , a0_ . regions AS regions_34 , a0_ . villes AS villes_35 , a0_ . communes AS communes_36 , a0_ . address AS address_37 , a0_ . type AS type_38 , a0_ . urgent AS urgent_39 , a0_ . nbrcylindre AS nbrcylindre_40 , a0_ . numero_enregistrement AS numero_enregistrement_41 , a0_ . is_favoris AS is_favoris_42 , a0_ . has_co2 AS has_co2_43 , a0_ . export_price AS export_price_44 , a0_ . bargan_price AS bargan_price_45 , a0_ . is_active AS is_active_46 , a0_ . int_moto AS int_moto_47 , a0_ . electro_moto AS electro_moto_48 , a0_ . disposec_moto AS disposec_moto_49 , a0_ . dispconf_moto AS dispconf_moto_50 , a0_ . lon AS lon_51 , a0_ . lat AS lat_52 , a0_ . duration AS duration_53 , a0_ . comments AS comments_54 , a0_ . note AS note_55 , a0_ . is_compared AS is_compared_56 , a0_ . user_id AS user_id_57 FROM annonce a0_ LEFT JOIN ext_translations t1_ ON t1_ . locale = 'en' AND t1_ . field = 'category' AND t1_ . object_class = 'App\\Entity\\Annonce' AND t1_ . foreign_key = a0_ . id LEFT JOIN ext_translations t2_ ON t2_ . locale = 'en' AND t2_ . field = 'marques' AND t2_ . object_class = 'App\\Entity\\Annonce' AND t2_ . foreign_key = a0_ . id LEFT JOIN ext_translations t3_ ON t3_ . locale = 'en' AND t3_ . field = 'modeles' AND t3_ . object_class = 'App\\Entity\\Annonce' AND t3_ . foreign_key = a0_ . id LEFT JOIN ext_translations t4_ ON t4_ . locale = 'en' AND t4_ . field = 'etats' AND t4_ . object_class = 'App\\Entity\\Annonce' AND t4_ . foreign_key = a0_ . id LEFT JOIN ext_translations t5_ ON t5_ . locale = 'en' AND t5_ . field = 'carosseries' AND t5_ . object_class = 'App\\Entity\\Annonce' AND t5_ . foreign_key = a0_ . id LEFT JOIN ext_translations t6_ ON t6_ . locale = 'en' AND t6_ . field = 'kilometrage' AND t6_ . object_class = 'App\\Entity\\Annonce' AND t6_ . foreign_key = a0_ . id LEFT JOIN ext_translations t7_ ON t7_ . locale = 'en' AND t7_ . field = 'carburants' AND t7_ . object_class = 'App\\Entity\\Annonce' AND t7_ . foreign_key = a0_ . id LEFT JOIN ext_translations t8_ ON t8_ . locale = 'en' AND t8_ . field = 'transmission' AND t8_ . object_class = 'App\\Entity\\Annonce' AND t8_ . foreign_key = a0_ . id LEFT JOIN ext_translations t9_ ON t9_ . locale = 'en' AND t9_ . field = 'moteur' AND t9_ . object_class = 'App\\Entity\\Annonce' AND t9_ . foreign_key = a0_ . id LEFT JOIN ext_translations t10_ ON t10_ . locale = 'en' AND t10_ . field = 'entrainement' AND t10_ . object_class = 'App\\Entity\\Annonce' AND t10_ . foreign_key = a0_ . id LEFT JOIN ext_translations t11_ ON t11_ . locale = 'en' AND t11_ . field = 'couleurExt' AND t11_ . object_class = 'App\\Entity\\Annonce' AND t11_ . foreign_key = a0_ . id LEFT JOIN ext_translations t12_ ON t12_ . locale = 'en' AND t12_ . field = 'couleurInt' AND t12_ . object_class = 'App\\Entity\\Annonce' AND t12_ . foreign_key = a0_ . id LEFT JOIN ext_translations t13_ ON t13_ . locale = 'en' AND t13_ . field = 'consommationville' AND t13_ . object_class = 'App\\Entity\\Annonce' AND t13_ . foreign_key = a0_ . id LEFT JOIN ext_translations t14_ ON t14_ . locale = 'en' AND t14_ . field = 'consommationRoute' AND t14_ . object_class = 'App\\Entity\\Annonce' AND t14_ . foreign_key = a0_ . id LEFT JOIN ext_translations t15_ ON t15_ . locale = 'en' AND t15_ . field = 'carosserieEquip' AND t15_ . object_class = 'App\\Entity\\Annonce' AND t15_ . foreign_key = a0_ . id LEFT JOIN ext_translations t16_ ON t16_ . locale = 'en' AND t16_ . field = 'transmissionEquip' AND t16_ . object_class = 'App\\Entity\\Annonce' AND t16_ . foreign_key = a0_ . id LEFT JOIN ext_translations t17_ ON t17_ . locale = 'en' AND t17_ . field = 'InterieurEquip' AND t17_ . object_class = 'App\\Entity\\Annonce' AND t17_ . foreign_key = a0_ . id LEFT JOIN ext_translations t18_ ON t18_ . locale = 'en' AND t18_ . field = 'exterieurEquip' AND t18_ . object_class = 'App\\Entity\\Annonce' AND t18_ . foreign_key = a0_ . id LEFT JOIN ext_translations t19_ ON t19_ . locale = 'en' AND t19_ . field = 'electroniqueEquip' AND t19_ . object_class = 'App\\Entity\\Annonce' AND t19_ . foreign_key = a0_ . id LEFT JOIN ext_translations t20_ ON t20_ . locale = 'en' AND t20_ . field = 'price' AND t20_ . object_class = 'App\\Entity\\Annonce' AND t20_ . foreign_key = a0_ . id LEFT JOIN ext_translations t21_ ON t21_ . locale = 'en' AND t21_ . field = 'description' AND t21_ . object_class = 'App\\Entity\\Annonce' AND t21_ . foreign_key = a0_ . id LEFT JOIN ext_translations t22_ ON t22_ . locale = 'en' AND t22_ . field = 'descriptionadd' AND t22_ . object_class = 'App\\Entity\\Annonce' AND t22_ . foreign_key = a0_ . id LEFT JOIN ext_translations t23_ ON t23_ . locale = 'en' AND t23_ . field = 'specificationtechniques' AND t23_ . object_class = 'App\\Entity\\Annonce' AND t23_ . foreign_key = a0_ . id LEFT JOIN ext_translations t24_ ON t24_ . locale = 'en' AND t24_ . field = 'infosgenerales' AND t24_ . object_class = 'App\\Entity\\Annonce' AND t24_ . foreign_key = a0_ . id LEFT JOIN ext_translations t25_ ON t25_ . locale = 'en' AND t25_ . field = 'created_At' AND t25_ . object_class = 'App\\Entity\\Annonce' AND t25_ . foreign_key = a0_ . id LEFT JOIN ext_translations t26_ ON t26_ . locale = 'en' AND t26_ . field = 'updated_At' AND t26_ . object_class = 'App\\Entity\\Annonce' AND t26_ . foreign_key = a0_ . id WHERE a0_ . type = 'Gold' ORDER BY a0_ . id DESC ;
Copy
74
8.34 ms
SELECT t1 . id AS id_2 , t1 . email AS email_3 , t1 . roles AS roles_4 , t1 . password AS password_5 , t1 . type_compte AS type_compte_6 , t1 . is_verified AS is_verified_7 , t1 . tel AS tel_8 , t1 . approve AS approve_9 , t1 . facebook_id AS facebook_id_10 , t1 . is_super_admin AS is_super_admin_11 , t1 . facebook AS facebook_12 , t1 . twitter AS twitter_13 , t1 . instagram AS instagram_14 , t1 . linkedin AS linkedin_15 , t1 . youtube AS youtube_16 , t1 . whatsapp AS whatsapp_17 , t1 . pinterest AS pinterest_18 , t1 . facebook_access_token AS facebook_access_token_19 , t1 . twitter_id AS twitter_id_20 , t1 . twitter_access_token AS twitter_access_token_21 , t1 . google_id AS google_id_22 , t1 . google_access_token AS google_access_token_23 , t0 . logo AS logo_24 , t0 . nom_professionel AS nom_professionel_25 , t0 . addresse AS addresse_26 , t0 . marques AS marques_27 , t0 . website AS website_28 , t0 . image_size AS image_size_29 , t0 . updated_at AS updated_at_30 , t0 . description AS description_31 , t1 . compte FROM professionel t0 INNER JOIN user t1 ON t0 . id = t1 . id
SELECT t1 . id AS id_2 , t1 . email AS email_3 , t1 . roles AS roles_4 , t1 . password AS password_5 , t1 . type_compte AS type_compte_6 , t1 . is_verified AS is_verified_7 , t1 . tel AS tel_8 , t1 . approve AS approve_9 , t1 . facebook_id AS facebook_id_10 , t1 . is_super_admin AS is_super_admin_11 , t1 . facebook AS facebook_12 , t1 . twitter AS twitter_13 , t1 . instagram AS instagram_14 , t1 . linkedin AS linkedin_15 , t1 . youtube AS youtube_16 , t1 . whatsapp AS whatsapp_17 , t1 . pinterest AS pinterest_18 , t1 . facebook_access_token AS facebook_access_token_19 , t1 . twitter_id AS twitter_id_20 , t1 . twitter_access_token AS twitter_access_token_21 , t1 . google_id AS google_id_22 , t1 . google_access_token AS google_access_token_23 , t0 . logo AS logo_24 , t0 . nom_professionel AS nom_professionel_25 , t0 . addresse AS addresse_26 , t0 . marques AS marques_27 , t0 . website AS website_28 , t0 . image_size AS image_size_29 , t0 . updated_at AS updated_at_30 , t0 . description AS description_31 , t1 . compte FROM professionel t0 INNER JOIN user t1 ON t0 . id = t1 . id ;
Copy
75
1.22 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"59 "
"en "
"App\Entity\User "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '59' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\User' ;
Copy
76
1.15 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . username AS username_3 , t0 . email AS email_4 , t0 . telephone AS telephone_5 , t0 . category AS category_6 , t0 . marque AS marque_7 , t0 . modele AS modele_8 , t0 . budget AS budget_9 , t0 . transmission AS transmission_10 , t0 . carburant AS carburant_11 , t0 . prevision AS prevision_12 , t0 . period1 AS period1_13 , t0 . period2 AS period2_14 , t0 . wished_options AS wished_options_15 , t0 . nb_portes AS nb_portes_16 , t0 . reference AS reference_17 , t0 . type_annonce AS type_annonce_18 , t0 . created_at AS created_at_19 FROM depot_recherche t0
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . username AS username_3 , t0 . email AS email_4 , t0 . telephone AS telephone_5 , t0 . category AS category_6 , t0 . marque AS marque_7 , t0 . modele AS modele_8 , t0 . budget AS budget_9 , t0 . transmission AS transmission_10 , t0 . carburant AS carburant_11 , t0 . prevision AS prevision_12 , t0 . period1 AS period1_13 , t0 . period2 AS period2_14 , t0 . wished_options AS wished_options_15 , t0 . nb_portes AS nb_portes_16 , t0 . reference AS reference_17 , t0 . type_annonce AS type_annonce_18 , t0 . created_at AS created_at_19 FROM depot_recherche t0 ;
Copy
77
3.65 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"1 "
"en "
"App\Entity\DepotRecherche "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '1' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\DepotRecherche' ;
Copy
78
0.15 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"2 "
"en "
"App\Entity\DepotRecherche "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '2' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\DepotRecherche' ;
Copy
79
8.52 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"3 "
"en "
"App\Entity\DepotRecherche "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '3' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\DepotRecherche' ;
Copy
80
0.23 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"4 "
"en "
"App\Entity\DepotRecherche "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '4' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\DepotRecherche' ;
Copy
81
0.13 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"5 "
"en "
"App\Entity\DepotRecherche "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '5' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\DepotRecherche' ;
Copy
82
1.58 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"6 "
"en "
"App\Entity\DepotRecherche "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '6' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\DepotRecherche' ;
Copy
83
6.17 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"7 "
"en "
"App\Entity\DepotRecherche "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '7' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\DepotRecherche' ;
Copy
84
2.04 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"8 "
"en "
"App\Entity\DepotRecherche "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '8' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\DepotRecherche' ;
Copy
85
0.16 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"9 "
"en "
"App\Entity\DepotRecherche "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '9' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\DepotRecherche' ;
Copy
86
0.14 ms
SELECT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . image_pub AS image_pub_2 , p0_ . created_at AS created_at_3 , p0_ . image_size AS image_size_4 , p0_ . updated_at AS updated_at_5 , p0_ . description AS description_6 , p0_ . admin_id AS admin_id_7 FROM pub_infos p0_ ORDER BY p0_ . id DESC LIMIT 3
SELECT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . image_pub AS image_pub_2 , p0_ . created_at AS created_at_3 , p0_ . image_size AS image_size_4 , p0_ . updated_at AS updated_at_5 , p0_ . description AS description_6 , p0_ . admin_id AS admin_id_7 FROM pub_infos p0_ ORDER BY p0_ . id DESC LIMIT 3 ;
Copy
87
8.12 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"4 "
"en "
"App\Entity\PubInfos "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '4' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\PubInfos' ;
Copy
88
0.21 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"3 "
"en "
"App\Entity\PubInfos "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '3' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\PubInfos' ;
Copy
89
0.13 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"2 "
"en "
"App\Entity\PubInfos "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '2' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\PubInfos' ;
Copy
90
0.96 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . validity AS validity_3 , t0 . location AS location_4 , t0 . category AS category_5 , t0 . link AS link_6 , t0 . file_pub AS file_pub_7 , t0 . file_size AS file_size_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . expireted_at AS expireted_at_11 , t0 . back_link AS back_link_12 FROM pub t0 WHERE t0 . location = ?
Parameters :
[
"Entéte du site "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . validity AS validity_3 , t0 . location AS location_4 , t0 . category AS category_5 , t0 . link AS link_6 , t0 . file_pub AS file_pub_7 , t0 . file_size AS file_size_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . expireted_at AS expireted_at_11 , t0 . back_link AS back_link_12 FROM pub t0 WHERE t0 . location = 'Entéte du site' ;
Copy
91
4.09 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"1 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '1' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
92
0.15 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"2 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '2' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
93
0.14 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"15 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '15' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
94
0.13 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"23 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '23' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
95
0.13 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"24 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '24' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
96
0.13 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"25 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '25' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
97
0.13 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"26 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '26' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
98
2.75 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"27 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '27' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
99
0.15 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"28 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '28' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
100
0.16 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"29 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '29' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
101
0.13 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"30 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '30' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
102
0.14 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"31 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '31' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
103
0.13 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"38 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '38' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
104
9.44 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"39 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '39' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
105
0.16 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . validity AS validity_3 , t0 . location AS location_4 , t0 . category AS category_5 , t0 . link AS link_6 , t0 . file_pub AS file_pub_7 , t0 . file_size AS file_size_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . expireted_at AS expireted_at_11 , t0 . back_link AS back_link_12 FROM pub t0 WHERE t0 . location = ?
Parameters :
[
"Banière home "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . validity AS validity_3 , t0 . location AS location_4 , t0 . category AS category_5 , t0 . link AS link_6 , t0 . file_pub AS file_pub_7 , t0 . file_size AS file_size_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . expireted_at AS expireted_at_11 , t0 . back_link AS back_link_12 FROM pub t0 WHERE t0 . location = 'Banière home' ;
Copy
106
0.13 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"40 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '40' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
107
3.93 ms
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"43 "
"en "
"App\Entity\Pub "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '43' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Pub' ;
Copy
108
11.91 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 106 ;
Copy
109
3.66 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 105 ;
Copy
110
0.19 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 103 ;
Copy
111
0.15 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 102 ;
Copy
112
0.44 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 96 ;
Copy
113
0.40 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 94 ;
Copy
114
2.58 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 93 ;
Copy
115
2.90 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 90 ;
Copy
116
3.04 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 83 ;
Copy
117
0.24 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 82 ;
Copy
118
1.25 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 77 ;
Copy
119
3.97 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 71 ;
Copy
120
1.25 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 67 ;
Copy
121
6.17 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 66 ;
Copy
122
3.26 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 64 ;
Copy
123
10.25 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 62 ;
Copy
124
4.46 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 59 ;
Copy
125
0.18 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 58 ;
Copy
126
0.15 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 57 ;
Copy
127
0.14 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 56 ;
Copy
128
0.14 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 51 ;
Copy
129
1.73 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 44 ;
Copy
130
8.33 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 100 ;
Copy
131
3.18 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 98 ;
Copy
132
0.21 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 95 ;
Copy
133
0.65 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 91 ;
Copy
134
0.82 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 85 ;
Copy
135
2.86 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 84 ;
Copy
136
5.28 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 80 ;
Copy
137
1.63 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 69 ;
Copy
138
3.46 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 63 ;
Copy
139
0.14 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 60 ;
Copy
140
0.92 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 55 ;
Copy
141
10.43 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 53 ;
Copy
142
0.47 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 32 ;
Copy
143
4.43 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 31 ;
Copy
144
5.89 ms
SELECT t0 . id AS id_1 , t0 . article_id AS article_id_2 , t0 . commenter_id AS commenter_id_3 FROM comment t0 WHERE t0 . article_id = ?
SELECT t0 . id AS id_1 , t0 . article_id AS article_id_2 , t0 . commenter_id AS commenter_id_3 FROM comment t0 WHERE t0 . article_id = 58 ;
Copy
145
3.45 ms
SELECT t0 . id AS id_1 , t0 . article_id AS article_id_2 , t0 . commenter_id AS commenter_id_3 FROM comment t0 WHERE t0 . article_id = ?
SELECT t0 . id AS id_1 , t0 . article_id AS article_id_2 , t0 . commenter_id AS commenter_id_3 FROM comment t0 WHERE t0 . article_id = 57 ;
Copy
146
5.18 ms
SELECT t0 . id AS id_1 , t0 . article_id AS article_id_2 , t0 . commenter_id AS commenter_id_3 FROM comment t0 WHERE t0 . article_id = ?
SELECT t0 . id AS id_1 , t0 . article_id AS article_id_2 , t0 . commenter_id AS commenter_id_3 FROM comment t0 WHERE t0 . article_id = 56 ;
Copy