1
0.34 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_ WHERE a0_ . category = ? ORDER BY a0_ . created_at DESC
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_
WHERE
a0_ . category = ?
ORDER BY
a0_ . created_at DESC
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_ WHERE a0_ . category = 'Moto' ORDER BY a0_ . created_at DESC ;
Copy
2
0.30 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
3
0.24 ms
SELECT t0 . id AS id_4 , t0 . email AS email_5 , t0 . roles AS roles_6 , t0 . password AS password_7 , t0 . type_compte AS type_compte_8 , t0 . is_verified AS is_verified_9 , t0 . tel AS tel_10 , t0 . approve AS approve_11 , t0 . facebook_id AS facebook_id_12 , t0 . is_super_admin AS is_super_admin_13 , t0 . facebook AS facebook_14 , t0 . twitter AS twitter_15 , t0 . instagram AS instagram_16 , t0 . linkedin AS linkedin_17 , t0 . youtube AS youtube_18 , t0 . whatsapp AS whatsapp_19 , t0 . pinterest AS pinterest_20 , t0 . facebook_access_token AS facebook_access_token_21 , t0 . twitter_id AS twitter_id_22 , t0 . twitter_access_token AS twitter_access_token_23 , t0 . google_id AS google_id_24 , t0 . google_access_token AS google_access_token_25 , t0 . compte , t1 . logo AS logo_26 , t1 . nom_professionel AS nom_professionel_27 , t1 . addresse AS addresse_28 , t1 . marques AS marques_29 , t1 . website AS website_30 , t1 . image_size AS image_size_31 , t1 . updated_at AS updated_at_32 , t1 . description AS description_33 , t2 . prenom AS prenom_34 , t2 . nom AS nom_35 , t2 . civility AS civility_36 , t2 . photo AS photo_37 , t2 . image_size AS image_size_38 , t2 . updated_at AS updated_at_39 , t3 . photo AS photo_40 , t3 . image_size AS image_size_41 , t3 . updated_at AS updated_at_42 FROM user t0 LEFT JOIN professionel t1 ON t0 . id = t1 . id LEFT JOIN particulier t2 ON t0 . id = t2 . id LEFT JOIN admin t3 ON t0 . id = t3 . id WHERE t0 . id = ?
SELECT t0 . id AS id_4 , t0 . email AS email_5 , t0 . roles AS roles_6 , t0 . password AS password_7 , t0 . type_compte AS type_compte_8 , t0 . is_verified AS is_verified_9 , t0 . tel AS tel_10 , t0 . approve AS approve_11 , t0 . facebook_id AS facebook_id_12 , t0 . is_super_admin AS is_super_admin_13 , t0 . facebook AS facebook_14 , t0 . twitter AS twitter_15 , t0 . instagram AS instagram_16 , t0 . linkedin AS linkedin_17 , t0 . youtube AS youtube_18 , t0 . whatsapp AS whatsapp_19 , t0 . pinterest AS pinterest_20 , t0 . facebook_access_token AS facebook_access_token_21 , t0 . twitter_id AS twitter_id_22 , t0 . twitter_access_token AS twitter_access_token_23 , t0 . google_id AS google_id_24 , t0 . google_access_token AS google_access_token_25 , t0 . compte , t1 . logo AS logo_26 , t1 . nom_professionel AS nom_professionel_27 , t1 . addresse AS addresse_28 , t1 . marques AS marques_29 , t1 . website AS website_30 , t1 . image_size AS image_size_31 , t1 . updated_at AS updated_at_32 , t1 . description AS description_33 , t2 . prenom AS prenom_34 , t2 . nom AS nom_35 , t2 . civility AS civility_36 , t2 . photo AS photo_37 , t2 . image_size AS image_size_38 , t2 . updated_at AS updated_at_39 , t3 . photo AS photo_40 , t3 . image_size AS image_size_41 , t3 . updated_at AS updated_at_42 FROM user t0 LEFT JOIN professionel t1 ON t0 . id = t1 . id LEFT JOIN particulier t2 ON t0 . id = t2 . id LEFT JOIN admin t3 ON t0 . id = t3 . id WHERE t0 . id = 5 ;
Copy
4
0.23 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
5
0.21 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
6
0.20 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 :
[
"Inter Annonces "
]
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 = 'Inter Annonces' ;
Copy
7
0.28 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 33 ;
Copy
8
0.18 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 32 ;
Copy
9
0.18 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 31 ;
Copy
10
0.19 ms
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = ?
SELECT t0 . id AS id_1 , t0 . image_size AS image_size_2 , t0 . filename AS filename_3 , t0 . annonce_id AS annonce_id_4 FROM picture t0 WHERE t0 . annonce_id = 29 ;
Copy