1
0.34 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
0.28 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
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 :
[
"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.18 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
0.33 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.27 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
0.26 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
0.26 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 = 5 ;
Copy
9
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 :
[
"33 "
"en "
"App\Entity\Annonce "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '33' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\Annonce' ;
Copy
10
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 :
[
"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
11
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 :
[
"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
12
0.18 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\User "
]
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\\User' ;
Copy
13
0.18 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\Annonce "
]
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\\Annonce' ;
Copy
14
0.18 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\Annonce "
]
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\\Annonce' ;
Copy
15
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 :
[
"27 "
"en "
"App\Entity\Annonce "
]
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\\Annonce' ;
Copy
16
21.48 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
0.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 :
[
"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
0.50 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
0.25 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.38 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
21
0.37 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
22
0.21 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
23
0.20 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 :
[
"20 "
"en "
"App\Entity\User "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '20' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\User' ;
Copy
24
0.18 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\User "
]
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\\User' ;
Copy
25
0.18 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 :
[
"34 "
"en "
"App\Entity\User "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '34' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\User' ;
Copy
26
0.18 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 :
[
"36 "
"en "
"App\Entity\User "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '36' AND e0_ . locale = 'en' AND e0_ . object_class = 'App\\Entity\\User' ;
Copy
27
0.21 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
28
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 :
[
"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
29
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 :
[
"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
30
0.18 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
31
0.18 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
32
0.18 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
33
0.18 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
34
0.18 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
35
0.18 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
36
0.20 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
37
0.19 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
38
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 :
[
"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
39
0.71 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
40
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 :
[
"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
41
0.28 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
42
0.20 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
43
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 :
[
"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
44
0.18 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
45
0.18 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
46
0.18 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
47
0.18 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
48
0.18 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
49
0.18 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
50
0.20 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
51
0.18 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
52
0.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 :
[
"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
53
0.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 :
[
"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
54
0.18 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
55
0.29 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
56
0.20 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
57
0.26 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