122.86 ms
1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . recherche AS recherche_3 , t0 . longitude AS longitude_4 , t0 . latitude AS latitude_5 FROM localisations t0 ORDER BY t0 . libelle ASC
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . recherche AS recherche_3 , t0 . longitude AS longitude_4 , t0 . latitude AS latitude_5 FROM localisations t0 ORDER BY t0 . libelle ASC ; Copy
1.14 ms
2
SELECT t0_ . id AS id_0 , t0_ . libelle AS libelle_1 , t0_ . description AS description_2 , t0_ . image AS image_3 , t0_ . courant AS courant_4 , t0_ . dirname AS dirname_5 , t0_ . color_prime AS color_prime_6 , t0_ . color_second AS color_second_7 , t0_ . color_third AS color_third_8 , t0_ . date_maj AS date_maj_9 , t0_ . text_color_prime AS text_color_prime_10 , t0_ . text_color_second AS text_color_second_11 , t0_ . color_seperateur AS color_seperateur_12 FROM template t0_ WHERE t0_ . courant = ? LIMIT 1
SELECT t0_ . id AS id_0 , t0_ . libelle AS libelle_1 , t0_ . description AS description_2 , t0_ . image AS image_3 , t0_ . courant AS courant_4 , t0_ . dirname AS dirname_5 , t0_ . color_prime AS color_prime_6 , t0_ . color_second AS color_second_7 , t0_ . color_third AS color_third_8 , t0_ . date_maj AS date_maj_9 , t0_ . text_color_prime AS text_color_prime_10 , t0_ . text_color_second AS text_color_second_11 , t0_ . color_seperateur AS color_seperateur_12 FROM template t0_ WHERE t0_ . courant = 1 LIMIT 1 ; Copy
0.95 ms
1
SELECT o0_ . id AS id_0 , o0_ . ref_interne AS ref_interne_1 , o0_ . adresse AS adresse_2 , o0_ . cp AS cp_3 , o0_ . ville AS ville_4 , o0_ . photo1 AS photo1_5 , o0_ . descriptif AS descriptif_6 , o0_ . accroche AS accroche_7 , o0_ . condifi AS condifi_8 , o0_ . prestimm AS prestimm_9 , o0_ . equipement AS equipement_10 , o0_ . dispo AS dispo_11 , o0_ . desserte AS desserte_12 , o0_ . nom_consultant AS nom_consultant_13 , o0_ . tel_consultant AS tel_consultant_14 , o0_ . tel_port_consultant AS tel_port_consultant_15 , o0_ . mail_consultant AS mail_consultant_16 , o0_ . divisible AS divisible_17 , o0_ . date_modif AS date_modif_18 , o0_ . url_virtuelle AS url_virtuelle_19 , o0_ . dpe_chiffre AS dpe_chiffre_20 , o0_ . dpe_lettre AS dpe_lettre_21 , o0_ . ges_chiffre AS ges_chiffre_22 , o0_ . ges_lettre AS ges_lettre_23 , o0_ . surface_div AS surface_div_24 , o0_ . surface_totale AS surface_totale_25 , o0_ . latitude AS latitude_26 , o0_ . longitude AS longitude_27 , o0_ . prix_vente_global AS prix_vente_global_28 , o0_ . loyer_global AS loyer_global_29 , o0_ . honos_pourcent AS honos_pourcent_30 , o0_ . honos_montant AS honos_montant_31 , o0_ . photo2 AS photo2_32 , o0_ . photo3 AS photo3_33 , o0_ . photo4 AS photo4_34 , o0_ . photo5 AS photo5_35 , o0_ . photo6 AS photo6_36 , o0_ . photo7 AS photo7_37 , o0_ . photo8 AS photo8_38 , o0_ . photo9 AS photo9_39 , o0_ . photo10 AS photo10_40 , o0_ . photo11 AS photo11_41 , o0_ . photo12 AS photo12_42 , o0_ . photo13 AS photo13_43 , o0_ . photo14 AS photo14_44 , o0_ . photo15 AS photo15_45 , o0_ . plan1 AS plan1_46 , o0_ . plan2 AS plan2_47 , o0_ . plan3 AS plan3_48 , o0_ . plan4 AS plan4_49 , o0_ . plan5 AS plan5_50 , o0_ . plan6 AS plan6_51 , o0_ . plan7 AS plan7_52 , o0_ . plan8 AS plan8_53 , o0_ . plan9 AS plan9_54 , o0_ . plan10 AS plan10_55 , o0_ . plan11 AS plan11_56 , o0_ . plan12 AS plan12_57 , o0_ . plan13 AS plan13_58 , o0_ . plan14 AS plan14_59 , o0_ . plan15 AS plan15_60 , o0_ . slug_ville_cp AS slug_ville_cp_61 , o0_ . slug_ville AS slug_ville_62 , o0_ . slug_type AS slug_type_63 , o0_ . slug_nature AS slug_nature_64 , o0_ . slug_nature_second AS slug_nature_second_65 , o0_ . slug_detail_url AS slug_detail_url_66 , o0_ . directe AS directe_67 , o0_ . archive AS archive_68 , o0_ . loyer_mcarre AS loyer_mcarre_69 , o0_ . prix_mcarre AS prix_mcarre_70 , o0_ . detail_surfaces AS detail_surfaces_71 , o0_ . departement AS departement_72 , o0_ . departement_slug AS departement_slug_73 , o0_ . departement_libelle AS departement_libelle_74 , o0_ . import AS import_75 , o0_ . nature_id AS nature_id_76 , o0_ . type_id AS type_id_77 FROM offres o0_ WHERE o0_ . slug_ville_cp = ? AND o0_ . nature_id = 1 AND o0_ . type_id = 1 ORDER BY o0_ . date_modif DESC LIMIT 16
Parameters :
[
"saint-jean-de-luz-64500 "
]
SELECT
o0_ . id AS id_0 ,
o0_ . ref_interne AS ref_interne_1 ,
o0_ . adresse AS adresse_2 ,
o0_ . cp AS cp_3 ,
o0_ . ville AS ville_4 ,
o0_ . photo1 AS photo1_5 ,
o0_ . descriptif AS descriptif_6 ,
o0_ . accroche AS accroche_7 ,
o0_ . condifi AS condifi_8 ,
o0_ . prestimm AS prestimm_9 ,
o0_ . equipement AS equipement_10 ,
o0_ . dispo AS dispo_11 ,
o0_ . desserte AS desserte_12 ,
o0_ . nom_consultant AS nom_consultant_13 ,
o0_ . tel_consultant AS tel_consultant_14 ,
o0_ . tel_port_consultant AS tel_port_consultant_15 ,
o0_ . mail_consultant AS mail_consultant_16 ,
o0_ . divisible AS divisible_17 ,
o0_ . date_modif AS date_modif_18 ,
o0_ . url_virtuelle AS url_virtuelle_19 ,
o0_ . dpe_chiffre AS dpe_chiffre_20 ,
o0_ . dpe_lettre AS dpe_lettre_21 ,
o0_ . ges_chiffre AS ges_chiffre_22 ,
o0_ . ges_lettre AS ges_lettre_23 ,
o0_ . surface_div AS surface_div_24 ,
o0_ . surface_totale AS surface_totale_25 ,
o0_ . latitude AS latitude_26 ,
o0_ . longitude AS longitude_27 ,
o0_ . prix_vente_global AS prix_vente_global_28 ,
o0_ . loyer_global AS loyer_global_29 ,
o0_ . honos_pourcent AS honos_pourcent_30 ,
o0_ . honos_montant AS honos_montant_31 ,
o0_ . photo2 AS photo2_32 ,
o0_ . photo3 AS photo3_33 ,
o0_ . photo4 AS photo4_34 ,
o0_ . photo5 AS photo5_35 ,
o0_ . photo6 AS photo6_36 ,
o0_ . photo7 AS photo7_37 ,
o0_ . photo8 AS photo8_38 ,
o0_ . photo9 AS photo9_39 ,
o0_ . photo10 AS photo10_40 ,
o0_ . photo11 AS photo11_41 ,
o0_ . photo12 AS photo12_42 ,
o0_ . photo13 AS photo13_43 ,
o0_ . photo14 AS photo14_44 ,
o0_ . photo15 AS photo15_45 ,
o0_ . plan1 AS plan1_46 ,
o0_ . plan2 AS plan2_47 ,
o0_ . plan3 AS plan3_48 ,
o0_ . plan4 AS plan4_49 ,
o0_ . plan5 AS plan5_50 ,
o0_ . plan6 AS plan6_51 ,
o0_ . plan7 AS plan7_52 ,
o0_ . plan8 AS plan8_53 ,
o0_ . plan9 AS plan9_54 ,
o0_ . plan10 AS plan10_55 ,
o0_ . plan11 AS plan11_56 ,
o0_ . plan12 AS plan12_57 ,
o0_ . plan13 AS plan13_58 ,
o0_ . plan14 AS plan14_59 ,
o0_ . plan15 AS plan15_60 ,
o0_ . slug_ville_cp AS slug_ville_cp_61 ,
o0_ . slug_ville AS slug_ville_62 ,
o0_ . slug_type AS slug_type_63 ,
o0_ . slug_nature AS slug_nature_64 ,
o0_ . slug_nature_second AS slug_nature_second_65 ,
o0_ . slug_detail_url AS slug_detail_url_66 ,
o0_ . directe AS directe_67 ,
o0_ . archive AS archive_68 ,
o0_ . loyer_mcarre AS loyer_mcarre_69 ,
o0_ . prix_mcarre AS prix_mcarre_70 ,
o0_ . detail_surfaces AS detail_surfaces_71 ,
o0_ . departement AS departement_72 ,
o0_ . departement_slug AS departement_slug_73 ,
o0_ . departement_libelle AS departement_libelle_74 ,
o0_ . import AS import_75 ,
o0_ . nature_id AS nature_id_76 ,
o0_ . type_id AS type_id_77
FROM
offres o0_
WHERE
o0_ . slug_ville_cp = ?
AND o0_ . nature_id = 1
AND o0_ . type_id = 1
ORDER BY
o0_ . date_modif DESC
LIMIT
16 Copy
SELECT o0_ . id AS id_0 , o0_ . ref_interne AS ref_interne_1 , o0_ . adresse AS adresse_2 , o0_ . cp AS cp_3 , o0_ . ville AS ville_4 , o0_ . photo1 AS photo1_5 , o0_ . descriptif AS descriptif_6 , o0_ . accroche AS accroche_7 , o0_ . condifi AS condifi_8 , o0_ . prestimm AS prestimm_9 , o0_ . equipement AS equipement_10 , o0_ . dispo AS dispo_11 , o0_ . desserte AS desserte_12 , o0_ . nom_consultant AS nom_consultant_13 , o0_ . tel_consultant AS tel_consultant_14 , o0_ . tel_port_consultant AS tel_port_consultant_15 , o0_ . mail_consultant AS mail_consultant_16 , o0_ . divisible AS divisible_17 , o0_ . date_modif AS date_modif_18 , o0_ . url_virtuelle AS url_virtuelle_19 , o0_ . dpe_chiffre AS dpe_chiffre_20 , o0_ . dpe_lettre AS dpe_lettre_21 , o0_ . ges_chiffre AS ges_chiffre_22 , o0_ . ges_lettre AS ges_lettre_23 , o0_ . surface_div AS surface_div_24 , o0_ . surface_totale AS surface_totale_25 , o0_ . latitude AS latitude_26 , o0_ . longitude AS longitude_27 , o0_ . prix_vente_global AS prix_vente_global_28 , o0_ . loyer_global AS loyer_global_29 , o0_ . honos_pourcent AS honos_pourcent_30 , o0_ . honos_montant AS honos_montant_31 , o0_ . photo2 AS photo2_32 , o0_ . photo3 AS photo3_33 , o0_ . photo4 AS photo4_34 , o0_ . photo5 AS photo5_35 , o0_ . photo6 AS photo6_36 , o0_ . photo7 AS photo7_37 , o0_ . photo8 AS photo8_38 , o0_ . photo9 AS photo9_39 , o0_ . photo10 AS photo10_40 , o0_ . photo11 AS photo11_41 , o0_ . photo12 AS photo12_42 , o0_ . photo13 AS photo13_43 , o0_ . photo14 AS photo14_44 , o0_ . photo15 AS photo15_45 , o0_ . plan1 AS plan1_46 , o0_ . plan2 AS plan2_47 , o0_ . plan3 AS plan3_48 , o0_ . plan4 AS plan4_49 , o0_ . plan5 AS plan5_50 , o0_ . plan6 AS plan6_51 , o0_ . plan7 AS plan7_52 , o0_ . plan8 AS plan8_53 , o0_ . plan9 AS plan9_54 , o0_ . plan10 AS plan10_55 , o0_ . plan11 AS plan11_56 , o0_ . plan12 AS plan12_57 , o0_ . plan13 AS plan13_58 , o0_ . plan14 AS plan14_59 , o0_ . plan15 AS plan15_60 , o0_ . slug_ville_cp AS slug_ville_cp_61 , o0_ . slug_ville AS slug_ville_62 , o0_ . slug_type AS slug_type_63 , o0_ . slug_nature AS slug_nature_64 , o0_ . slug_nature_second AS slug_nature_second_65 , o0_ . slug_detail_url AS slug_detail_url_66 , o0_ . directe AS directe_67 , o0_ . archive AS archive_68 , o0_ . loyer_mcarre AS loyer_mcarre_69 , o0_ . prix_mcarre AS prix_mcarre_70 , o0_ . detail_surfaces AS detail_surfaces_71 , o0_ . departement AS departement_72 , o0_ . departement_slug AS departement_slug_73 , o0_ . departement_libelle AS departement_libelle_74 , o0_ . import AS import_75 , o0_ . nature_id AS nature_id_76 , o0_ . type_id AS type_id_77 FROM offres o0_ WHERE o0_ . slug_ville_cp = 'saint-jean-de-luz-64500' AND o0_ . nature_id = 1 AND o0_ . type_id = 1 ORDER BY o0_ . date_modif DESC LIMIT 16 ; Copy
0.94 ms
2
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . seo_url AS seo_url_3 , t0 . seo_titre AS seo_titre_4 , t0 . seo_desc AS seo_desc_5 , t0 . titre AS titre_6 , t0 . contenu_un AS contenu_un_7 , t0 . contenu_deux AS contenu_deux_8 , t0 . date_maj AS date_maj_9 , t0 . image AS image_10 , t0 . citation AS citation_11 , t0 . image_citation AS image_citation_12 , t0 . afficher_bloc_contact AS afficher_bloc_contact_13 , t0 . nature_offre AS nature_offre_14 , t0 . type_offre AS type_offre_15 , t0 . smin_offre AS smin_offre_16 , t0 . smax_offre AS smax_offre_17 , t0 . afficher_carrousel_offre AS afficher_carrousel_offre_18 , t0 . afficher_carrousel_crit AS afficher_carrousel_crit_19 , t0 . titre_offre AS titre_offre_20 , t0 . afficher_bouton_offre AS afficher_bouton_offre_21 , t0 . libelle_bouton_offre AS libelle_bouton_offre_22 , t0 . title_bouton_offre AS title_bouton_offre_23 , t0 . url_offre AS url_offre_24 , t0 . afficher_bloc_actus AS afficher_bloc_actus_25 , t0 . og_title AS og_title_26 , t0 . og_desc AS og_desc_27 , t0 . og_image AS og_image_28 , t0 . page_mere_id AS page_mere_id_29 FROM pages t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . seo_url AS seo_url_3 , t0 . seo_titre AS seo_titre_4 , t0 . seo_desc AS seo_desc_5 , t0 . titre AS titre_6 , t0 . contenu_un AS contenu_un_7 , t0 . contenu_deux AS contenu_deux_8 , t0 . date_maj AS date_maj_9 , t0 . image AS image_10 , t0 . citation AS citation_11 , t0 . image_citation AS image_citation_12 , t0 . afficher_bloc_contact AS afficher_bloc_contact_13 , t0 . nature_offre AS nature_offre_14 , t0 . type_offre AS type_offre_15 , t0 . smin_offre AS smin_offre_16 , t0 . smax_offre AS smax_offre_17 , t0 . afficher_carrousel_offre AS afficher_carrousel_offre_18 , t0 . afficher_carrousel_crit AS afficher_carrousel_crit_19 , t0 . titre_offre AS titre_offre_20 , t0 . afficher_bouton_offre AS afficher_bouton_offre_21 , t0 . libelle_bouton_offre AS libelle_bouton_offre_22 , t0 . title_bouton_offre AS title_bouton_offre_23 , t0 . url_offre AS url_offre_24 , t0 . afficher_bloc_actus AS afficher_bloc_actus_25 , t0 . og_title AS og_title_26 , t0 . og_desc AS og_desc_27 , t0 . og_image AS og_image_28 , t0 . page_mere_id AS page_mere_id_29 FROM pages t0 WHERE t0 . id = 1 ; Copy
0.79 ms
1
SELECT o0_ . id AS id_0 , o0_ . ref_interne AS ref_interne_1 , o0_ . adresse AS adresse_2 , o0_ . cp AS cp_3 , o0_ . ville AS ville_4 , o0_ . photo1 AS photo1_5 , o0_ . descriptif AS descriptif_6 , o0_ . accroche AS accroche_7 , o0_ . condifi AS condifi_8 , o0_ . prestimm AS prestimm_9 , o0_ . equipement AS equipement_10 , o0_ . dispo AS dispo_11 , o0_ . desserte AS desserte_12 , o0_ . nom_consultant AS nom_consultant_13 , o0_ . tel_consultant AS tel_consultant_14 , o0_ . tel_port_consultant AS tel_port_consultant_15 , o0_ . mail_consultant AS mail_consultant_16 , o0_ . divisible AS divisible_17 , o0_ . date_modif AS date_modif_18 , o0_ . url_virtuelle AS url_virtuelle_19 , o0_ . dpe_chiffre AS dpe_chiffre_20 , o0_ . dpe_lettre AS dpe_lettre_21 , o0_ . ges_chiffre AS ges_chiffre_22 , o0_ . ges_lettre AS ges_lettre_23 , o0_ . surface_div AS surface_div_24 , o0_ . surface_totale AS surface_totale_25 , o0_ . latitude AS latitude_26 , o0_ . longitude AS longitude_27 , o0_ . prix_vente_global AS prix_vente_global_28 , o0_ . loyer_global AS loyer_global_29 , o0_ . honos_pourcent AS honos_pourcent_30 , o0_ . honos_montant AS honos_montant_31 , o0_ . photo2 AS photo2_32 , o0_ . photo3 AS photo3_33 , o0_ . photo4 AS photo4_34 , o0_ . photo5 AS photo5_35 , o0_ . photo6 AS photo6_36 , o0_ . photo7 AS photo7_37 , o0_ . photo8 AS photo8_38 , o0_ . photo9 AS photo9_39 , o0_ . photo10 AS photo10_40 , o0_ . photo11 AS photo11_41 , o0_ . photo12 AS photo12_42 , o0_ . photo13 AS photo13_43 , o0_ . photo14 AS photo14_44 , o0_ . photo15 AS photo15_45 , o0_ . plan1 AS plan1_46 , o0_ . plan2 AS plan2_47 , o0_ . plan3 AS plan3_48 , o0_ . plan4 AS plan4_49 , o0_ . plan5 AS plan5_50 , o0_ . plan6 AS plan6_51 , o0_ . plan7 AS plan7_52 , o0_ . plan8 AS plan8_53 , o0_ . plan9 AS plan9_54 , o0_ . plan10 AS plan10_55 , o0_ . plan11 AS plan11_56 , o0_ . plan12 AS plan12_57 , o0_ . plan13 AS plan13_58 , o0_ . plan14 AS plan14_59 , o0_ . plan15 AS plan15_60 , o0_ . slug_ville_cp AS slug_ville_cp_61 , o0_ . slug_ville AS slug_ville_62 , o0_ . slug_type AS slug_type_63 , o0_ . slug_nature AS slug_nature_64 , o0_ . slug_nature_second AS slug_nature_second_65 , o0_ . slug_detail_url AS slug_detail_url_66 , o0_ . directe AS directe_67 , o0_ . archive AS archive_68 , o0_ . loyer_mcarre AS loyer_mcarre_69 , o0_ . prix_mcarre AS prix_mcarre_70 , o0_ . detail_surfaces AS detail_surfaces_71 , o0_ . departement AS departement_72 , o0_ . departement_slug AS departement_slug_73 , o0_ . departement_libelle AS departement_libelle_74 , o0_ . import AS import_75 , o0_ . nature_id AS nature_id_76 , o0_ . type_id AS type_id_77 FROM offres o0_ WHERE o0_ . slug_ville_cp = ? AND o0_ . nature_id = 1 AND o0_ . type_id = 1 AND o0_ . id IN (? ) ORDER BY o0_ . date_modif DESC
Parameters :
[
"saint-jean-de-luz-64500 "
679
]
SELECT
o0_ . id AS id_0 ,
o0_ . ref_interne AS ref_interne_1 ,
o0_ . adresse AS adresse_2 ,
o0_ . cp AS cp_3 ,
o0_ . ville AS ville_4 ,
o0_ . photo1 AS photo1_5 ,
o0_ . descriptif AS descriptif_6 ,
o0_ . accroche AS accroche_7 ,
o0_ . condifi AS condifi_8 ,
o0_ . prestimm AS prestimm_9 ,
o0_ . equipement AS equipement_10 ,
o0_ . dispo AS dispo_11 ,
o0_ . desserte AS desserte_12 ,
o0_ . nom_consultant AS nom_consultant_13 ,
o0_ . tel_consultant AS tel_consultant_14 ,
o0_ . tel_port_consultant AS tel_port_consultant_15 ,
o0_ . mail_consultant AS mail_consultant_16 ,
o0_ . divisible AS divisible_17 ,
o0_ . date_modif AS date_modif_18 ,
o0_ . url_virtuelle AS url_virtuelle_19 ,
o0_ . dpe_chiffre AS dpe_chiffre_20 ,
o0_ . dpe_lettre AS dpe_lettre_21 ,
o0_ . ges_chiffre AS ges_chiffre_22 ,
o0_ . ges_lettre AS ges_lettre_23 ,
o0_ . surface_div AS surface_div_24 ,
o0_ . surface_totale AS surface_totale_25 ,
o0_ . latitude AS latitude_26 ,
o0_ . longitude AS longitude_27 ,
o0_ . prix_vente_global AS prix_vente_global_28 ,
o0_ . loyer_global AS loyer_global_29 ,
o0_ . honos_pourcent AS honos_pourcent_30 ,
o0_ . honos_montant AS honos_montant_31 ,
o0_ . photo2 AS photo2_32 ,
o0_ . photo3 AS photo3_33 ,
o0_ . photo4 AS photo4_34 ,
o0_ . photo5 AS photo5_35 ,
o0_ . photo6 AS photo6_36 ,
o0_ . photo7 AS photo7_37 ,
o0_ . photo8 AS photo8_38 ,
o0_ . photo9 AS photo9_39 ,
o0_ . photo10 AS photo10_40 ,
o0_ . photo11 AS photo11_41 ,
o0_ . photo12 AS photo12_42 ,
o0_ . photo13 AS photo13_43 ,
o0_ . photo14 AS photo14_44 ,
o0_ . photo15 AS photo15_45 ,
o0_ . plan1 AS plan1_46 ,
o0_ . plan2 AS plan2_47 ,
o0_ . plan3 AS plan3_48 ,
o0_ . plan4 AS plan4_49 ,
o0_ . plan5 AS plan5_50 ,
o0_ . plan6 AS plan6_51 ,
o0_ . plan7 AS plan7_52 ,
o0_ . plan8 AS plan8_53 ,
o0_ . plan9 AS plan9_54 ,
o0_ . plan10 AS plan10_55 ,
o0_ . plan11 AS plan11_56 ,
o0_ . plan12 AS plan12_57 ,
o0_ . plan13 AS plan13_58 ,
o0_ . plan14 AS plan14_59 ,
o0_ . plan15 AS plan15_60 ,
o0_ . slug_ville_cp AS slug_ville_cp_61 ,
o0_ . slug_ville AS slug_ville_62 ,
o0_ . slug_type AS slug_type_63 ,
o0_ . slug_nature AS slug_nature_64 ,
o0_ . slug_nature_second AS slug_nature_second_65 ,
o0_ . slug_detail_url AS slug_detail_url_66 ,
o0_ . directe AS directe_67 ,
o0_ . archive AS archive_68 ,
o0_ . loyer_mcarre AS loyer_mcarre_69 ,
o0_ . prix_mcarre AS prix_mcarre_70 ,
o0_ . detail_surfaces AS detail_surfaces_71 ,
o0_ . departement AS departement_72 ,
o0_ . departement_slug AS departement_slug_73 ,
o0_ . departement_libelle AS departement_libelle_74 ,
o0_ . import AS import_75 ,
o0_ . nature_id AS nature_id_76 ,
o0_ . type_id AS type_id_77
FROM
offres o0_
WHERE
o0_ . slug_ville_cp = ?
AND o0_ . nature_id = 1
AND o0_ . type_id = 1
AND o0_ . id IN (? )
ORDER BY
o0_ . date_modif DESC Copy
SELECT o0_ . id AS id_0 , o0_ . ref_interne AS ref_interne_1 , o0_ . adresse AS adresse_2 , o0_ . cp AS cp_3 , o0_ . ville AS ville_4 , o0_ . photo1 AS photo1_5 , o0_ . descriptif AS descriptif_6 , o0_ . accroche AS accroche_7 , o0_ . condifi AS condifi_8 , o0_ . prestimm AS prestimm_9 , o0_ . equipement AS equipement_10 , o0_ . dispo AS dispo_11 , o0_ . desserte AS desserte_12 , o0_ . nom_consultant AS nom_consultant_13 , o0_ . tel_consultant AS tel_consultant_14 , o0_ . tel_port_consultant AS tel_port_consultant_15 , o0_ . mail_consultant AS mail_consultant_16 , o0_ . divisible AS divisible_17 , o0_ . date_modif AS date_modif_18 , o0_ . url_virtuelle AS url_virtuelle_19 , o0_ . dpe_chiffre AS dpe_chiffre_20 , o0_ . dpe_lettre AS dpe_lettre_21 , o0_ . ges_chiffre AS ges_chiffre_22 , o0_ . ges_lettre AS ges_lettre_23 , o0_ . surface_div AS surface_div_24 , o0_ . surface_totale AS surface_totale_25 , o0_ . latitude AS latitude_26 , o0_ . longitude AS longitude_27 , o0_ . prix_vente_global AS prix_vente_global_28 , o0_ . loyer_global AS loyer_global_29 , o0_ . honos_pourcent AS honos_pourcent_30 , o0_ . honos_montant AS honos_montant_31 , o0_ . photo2 AS photo2_32 , o0_ . photo3 AS photo3_33 , o0_ . photo4 AS photo4_34 , o0_ . photo5 AS photo5_35 , o0_ . photo6 AS photo6_36 , o0_ . photo7 AS photo7_37 , o0_ . photo8 AS photo8_38 , o0_ . photo9 AS photo9_39 , o0_ . photo10 AS photo10_40 , o0_ . photo11 AS photo11_41 , o0_ . photo12 AS photo12_42 , o0_ . photo13 AS photo13_43 , o0_ . photo14 AS photo14_44 , o0_ . photo15 AS photo15_45 , o0_ . plan1 AS plan1_46 , o0_ . plan2 AS plan2_47 , o0_ . plan3 AS plan3_48 , o0_ . plan4 AS plan4_49 , o0_ . plan5 AS plan5_50 , o0_ . plan6 AS plan6_51 , o0_ . plan7 AS plan7_52 , o0_ . plan8 AS plan8_53 , o0_ . plan9 AS plan9_54 , o0_ . plan10 AS plan10_55 , o0_ . plan11 AS plan11_56 , o0_ . plan12 AS plan12_57 , o0_ . plan13 AS plan13_58 , o0_ . plan14 AS plan14_59 , o0_ . plan15 AS plan15_60 , o0_ . slug_ville_cp AS slug_ville_cp_61 , o0_ . slug_ville AS slug_ville_62 , o0_ . slug_type AS slug_type_63 , o0_ . slug_nature AS slug_nature_64 , o0_ . slug_nature_second AS slug_nature_second_65 , o0_ . slug_detail_url AS slug_detail_url_66 , o0_ . directe AS directe_67 , o0_ . archive AS archive_68 , o0_ . loyer_mcarre AS loyer_mcarre_69 , o0_ . prix_mcarre AS prix_mcarre_70 , o0_ . detail_surfaces AS detail_surfaces_71 , o0_ . departement AS departement_72 , o0_ . departement_slug AS departement_slug_73 , o0_ . departement_libelle AS departement_libelle_74 , o0_ . import AS import_75 , o0_ . nature_id AS nature_id_76 , o0_ . type_id AS type_id_77 FROM offres o0_ WHERE o0_ . slug_ville_cp = 'saint-jean-de-luz-64500' AND o0_ . nature_id = 1 AND o0_ . type_id = 1 AND o0_ . id IN (679 ) ORDER BY o0_ . date_modif DESC ; Copy
0.76 ms
1
SELECT count (DISTINCT o0_ . id ) AS sclr_0 FROM offres o0_ WHERE o0_ . slug_ville_cp = ? AND o0_ . nature_id = 1 AND o0_ . type_id = 1
Parameters :
[
"saint-jean-de-luz-64500 "
]
SELECT count (DISTINCT o0_ . id ) AS sclr_0 FROM offres o0_ WHERE o0_ . slug_ville_cp = 'saint-jean-de-luz-64500' AND o0_ . nature_id = 1 AND o0_ . type_id = 1 ; Copy
0.72 ms
3
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 FROM footer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 FROM footer t0 WHERE t0 . id = 1 ; Copy
0.64 ms
1
SELECT o0_ . slug_ville_cp AS slug_ville_cp_0 , o0_ . ville AS ville_1 , COUNT (o0_ . id ) AS sclr_2 FROM offres o0_ WHERE o0_ . slug_ville_cp < > ? AND o0_ . nature_id = 1 AND o0_ . type_id = 1 GROUP BY o0_ . slug_ville_cp ORDER BY o0_ . ville ASC
Parameters :
[
"saint-jean-de-luz-64500 "
]
SELECT o0_ . slug_ville_cp AS slug_ville_cp_0 , o0_ . ville AS ville_1 , COUNT (o0_ . id ) AS sclr_2 FROM offres o0_ WHERE o0_ . slug_ville_cp < > 'saint-jean-de-luz-64500' AND o0_ . nature_id = 1 AND o0_ . type_id = 1 GROUP BY o0_ . slug_ville_cp ORDER BY o0_ . ville ASC ; Copy
0.61 ms
1
SELECT DISTINCT o0_ . id AS id_0 , o0_ . date_modif AS date_modif_1 FROM offres o0_ WHERE o0_ . slug_ville_cp = ? AND o0_ . nature_id = 1 AND o0_ . type_id = 1 ORDER BY o0_ . date_modif DESC LIMIT 16
Parameters :
[
"saint-jean-de-luz-64500 "
]
SELECT DISTINCT o0_ . id AS id_0 , o0_ . date_modif AS date_modif_1 FROM offres o0_ WHERE o0_ . slug_ville_cp = 'saint-jean-de-luz-64500' AND o0_ . nature_id = 1 AND o0_ . type_id = 1 ORDER BY o0_ . date_modif DESC LIMIT 16 ; Copy
0.57 ms
1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . image AS image_3 , t0 . url AS url_4 , t0 . title AS title_5 , t0 . alt AS alt_6 , t0 . date_maj AS date_maj_7 , t0 . actif AS actif_8 , t0 . description AS description_9 , t0 . seo_title AS seo_title_10 , t0 . seo_desc AS seo_desc_11 , t0 . og_title AS og_title_12 , t0 . og_desc AS og_desc_13 , t0 . og_image AS og_image_14 FROM secteur t0 WHERE t0 . url = ? LIMIT 1
Parameters :
[
"/offres-immobilier/location/bureaux/saint-jean-de-luz-64500/?direction=desc&page=1 "
]
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . image AS image_3 , t0 . url AS url_4 , t0 . title AS title_5 , t0 . alt AS alt_6 , t0 . date_maj AS date_maj_7 , t0 . actif AS actif_8 , t0 . description AS description_9 , t0 . seo_title AS seo_title_10 , t0 . seo_desc AS seo_desc_11 , t0 . og_title AS og_title_12 , t0 . og_desc AS og_desc_13 , t0 . og_image AS og_image_14 FROM secteur t0 WHERE t0 . url = '/offres-immobilier/location/bureaux/saint-jean-de-luz-64500/?direction=desc&page=1' LIMIT 1 ; Copy
0.55 ms
1
SELECT t0 . id AS id_1 , t0 . societe AS societe_2 , t0 . adresse AS adresse_3 , t0 . cp AS cp_4 , t0 . ville AS ville_5 , t0 . email AS email_6 , t0 . tel AS tel_7 , t0 . fax AS fax_8 , t0 . description AS description_9 , t0 . image AS image_10 , t0 . date_maj AS date_maj_11 , t0 . twitter AS twitter_12 , t0 . linkedin AS linkedin_13 , t0 . facebook AS facebook_14 , t0 . contact_titre AS contact_titre_15 , t0 . contact_span AS contact_span_16 , t0 . contact_texte AS contact_texte_17 , t0 . favico AS favico_18 , t0 . cle_google_map AS cle_google_map_19 , t0 . puce_google_map AS puce_google_map_20 , t0 . contact_fond AS contact_fond_21 , t0 . google_analytics AS google_analytics_22 , t0 . insta AS insta_23 FROM infos t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . societe AS societe_2 , t0 . adresse AS adresse_3 , t0 . cp AS cp_4 , t0 . ville AS ville_5 , t0 . email AS email_6 , t0 . tel AS tel_7 , t0 . fax AS fax_8 , t0 . description AS description_9 , t0 . image AS image_10 , t0 . date_maj AS date_maj_11 , t0 . twitter AS twitter_12 , t0 . linkedin AS linkedin_13 , t0 . facebook AS facebook_14 , t0 . contact_titre AS contact_titre_15 , t0 . contact_span AS contact_span_16 , t0 . contact_texte AS contact_texte_17 , t0 . favico AS favico_18 , t0 . cle_google_map AS cle_google_map_19 , t0 . puce_google_map AS puce_google_map_20 , t0 . contact_fond AS contact_fond_21 , t0 . google_analytics AS google_analytics_22 , t0 . insta AS insta_23 FROM infos t0 WHERE t0 . id = 1 ; Copy
0.52 ms
1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . afficher AS afficher_3 FROM tri_config t0
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . afficher AS afficher_3 FROM tri_config t0 ; Copy
0.51 ms
1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . libelle_second AS libelle_second_3 , t0 . libelle_third AS libelle_third_4 , t0 . slug AS slug_5 , t0 . slug_second AS slug_second_6 , t0 . slug_third AS slug_third_7 FROM offres_nature t0 WHERE t0 . slug = ? LIMIT 1
Parameters :
[
"location "
]
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . libelle_second AS libelle_second_3 , t0 . libelle_third AS libelle_third_4 , t0 . slug AS slug_5 , t0 . slug_second AS slug_second_6 , t0 . slug_third AS slug_third_7 FROM offres_nature t0 WHERE t0 . slug = 'location' LIMIT 1 ; Copy
0.51 ms
1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . libelle_second AS libelle_second_3 , t0 . slug AS slug_4 , t0 . slug_second AS slug_second_5 FROM offres_type t0 WHERE t0 . slug = ? LIMIT 1
Parameters :
[
"bureaux "
]
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . libelle_second AS libelle_second_3 , t0 . slug AS slug_4 , t0 . slug_second AS slug_second_5 FROM offres_type t0 WHERE t0 . slug = 'bureaux' LIMIT 1 ; Copy
0.51 ms
1
SELECT t0 . id AS id_1 , t0 . nb_lignes AS nb_lignes_2 , t0 . libelle AS libelle_3 , t0 . afficher_pagination AS afficher_pagination_4 , t0 . afficher_actus_similaires AS afficher_actus_similaires_5 , t0 . url_liste AS url_liste_6 , t0 . url_detail AS url_detail_7 , t0 . h1_liste AS h1_liste_8 , t0 . afficher_bloc_contact AS afficher_bloc_contact_9 , t0 . titre_actu_similaire AS titre_actu_similaire_10 , t0 . afficher_bloc_contact_detail AS afficher_bloc_contact_detail_11 , t0 . seo_title AS seo_title_12 , t0 . seo_desc AS seo_desc_13 , t0 . image_bg AS image_bg_14 , t0 . date_maj AS date_maj_15 FROM actus_config t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nb_lignes AS nb_lignes_2 , t0 . libelle AS libelle_3 , t0 . afficher_pagination AS afficher_pagination_4 , t0 . afficher_actus_similaires AS afficher_actus_similaires_5 , t0 . url_liste AS url_liste_6 , t0 . url_detail AS url_detail_7 , t0 . h1_liste AS h1_liste_8 , t0 . afficher_bloc_contact AS afficher_bloc_contact_9 , t0 . titre_actu_similaire AS titre_actu_similaire_10 , t0 . afficher_bloc_contact_detail AS afficher_bloc_contact_detail_11 , t0 . seo_title AS seo_title_12 , t0 . seo_desc AS seo_desc_13 , t0 . image_bg AS image_bg_14 , t0 . date_maj AS date_maj_15 FROM actus_config t0 WHERE t0 . id = 1 ; Copy
0.48 ms
1
SELECT t0 . id AS id_1 , t0 . societe AS societe_2 , t0 . adresse AS adresse_3 , t0 . cp AS cp_4 , t0 . ville AS ville_5 , t0 . secteur AS secteur_6 , t0 . picto AS picto_7 , t0 . date_maj AS date_maj_8 , t0 . email AS email_9 , t0 . tel AS tel_10 , t0 . ordre AS ordre_11 FROM agence t0 ORDER BY t0 . ordre ASC
SELECT t0 . id AS id_1 , t0 . societe AS societe_2 , t0 . adresse AS adresse_3 , t0 . cp AS cp_4 , t0 . ville AS ville_5 , t0 . secteur AS secteur_6 , t0 . picto AS picto_7 , t0 . date_maj AS date_maj_8 , t0 . email AS email_9 , t0 . tel AS tel_10 , t0 . ordre AS ordre_11 FROM agence t0 ORDER BY t0 . ordre ASC ; Copy
0.45 ms
1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . libelle_second AS libelle_second_3 , t0 . libelle_third AS libelle_third_4 , t0 . slug AS slug_5 , t0 . slug_second AS slug_second_6 , t0 . slug_third AS slug_third_7 FROM offres_nature t0
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . libelle_second AS libelle_second_3 , t0 . libelle_third AS libelle_third_4 , t0 . slug AS slug_5 , t0 . slug_second AS slug_second_6 , t0 . slug_third AS slug_third_7 FROM offres_nature t0 ; Copy
0.45 ms
1
SELECT t0 . id AS id_1 , t0 . nb_lignes AS nb_lignes_2 , t0 . libelle AS libelle_3 , t0 . afficher_pagination AS afficher_pagination_4 , t0 . url_liste AS url_liste_5 , t0 . url_detail AS url_detail_6 , t0 . h1_liste AS h1_liste_7 , t0 . afficher_bloc_contact AS afficher_bloc_contact_8 , t0 . afficher_bloc_contact_detail AS afficher_bloc_contact_detail_9 , t0 . seo_title AS seo_title_10 , t0 . seo_desc AS seo_desc_11 , t0 . image_bg AS image_bg_12 , t0 . date_maj AS date_maj_13 , t0 . afficher_unite_loyer AS afficher_unite_loyer_14 , t0 . afficher_loyer AS afficher_loyer_15 , t0 . afficher_prix AS afficher_prix_16 , t0 . afficher_unite_prix AS afficher_unite_prix_17 , t0 . slider_surface_max AS slider_surface_max_18 , t0 . afficher_tri AS afficher_tri_19 , t0 . afficher_favoris AS afficher_favoris_20 , t0 . button_contact AS button_contact_21 FROM offres_config t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nb_lignes AS nb_lignes_2 , t0 . libelle AS libelle_3 , t0 . afficher_pagination AS afficher_pagination_4 , t0 . url_liste AS url_liste_5 , t0 . url_detail AS url_detail_6 , t0 . h1_liste AS h1_liste_7 , t0 . afficher_bloc_contact AS afficher_bloc_contact_8 , t0 . afficher_bloc_contact_detail AS afficher_bloc_contact_detail_9 , t0 . seo_title AS seo_title_10 , t0 . seo_desc AS seo_desc_11 , t0 . image_bg AS image_bg_12 , t0 . date_maj AS date_maj_13 , t0 . afficher_unite_loyer AS afficher_unite_loyer_14 , t0 . afficher_loyer AS afficher_loyer_15 , t0 . afficher_prix AS afficher_prix_16 , t0 . afficher_unite_prix AS afficher_unite_prix_17 , t0 . slider_surface_max AS slider_surface_max_18 , t0 . afficher_tri AS afficher_tri_19 , t0 . afficher_favoris AS afficher_favoris_20 , t0 . button_contact AS button_contact_21 FROM offres_config t0 WHERE t0 . id = 1 ; Copy
0.40 ms
1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . libelle_second AS libelle_second_3 , t0 . slug AS slug_4 , t0 . slug_second AS slug_second_5 FROM offres_type t0
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . libelle_second AS libelle_second_3 , t0 . slug AS slug_4 , t0 . slug_second AS slug_second_5 FROM offres_type t0 ; Copy
0.38 ms
1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . photo AS photo_3 , t0 . update_at AS update_at_4 , t0 . type_offre_id AS type_offre_id_5 FROM offres_photos t0
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . photo AS photo_3 , t0 . update_at AS update_at_4 , t0 . type_offre_id AS type_offre_id_5 FROM offres_photos t0 ; Copy
0.28 ms
1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . description AS description_3 , t0 . image AS image_4 , t0 . actif AS actif_5 , t0 . date_maj AS date_maj_6 , t0 . nb AS nb_7 FROM secteur_config t0 WHERE t0 . actif = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . description AS description_3 , t0 . image AS image_4 , t0 . actif AS actif_5 , t0 . date_maj AS date_maj_6 , t0 . nb AS nb_7 FROM secteur_config t0 WHERE t0 . actif = 1 LIMIT 1 ; Copy
0.27 ms
1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . actif AS actif_3 , t0 . image AS image_4 , t0 . updated_at AS updated_at_5 , t0 . svg AS svg_6 , t0 . svg_header AS svg_header_7 , t0 . template_id AS template_id_8 FROM favoris_config t0 WHERE t0 . actif = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . actif AS actif_3 , t0 . image AS image_4 , t0 . updated_at AS updated_at_5 , t0 . svg AS svg_6 , t0 . svg_header AS svg_header_7 , t0 . template_id AS template_id_8 FROM favoris_config t0 WHERE t0 . actif = 1 LIMIT 1 ; Copy
0.27 ms
1
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . image AS image_3 , t0 . date_maj AS date_maj_4 , t0 . actif AS actif_5 , t0 . cle_api AS cle_api_6 , t0 . puce_map AS puce_map_7 , t0 . styles AS styles_8 FROM maps t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . image AS image_3 , t0 . date_maj AS date_maj_4 , t0 . actif AS actif_5 , t0 . cle_api AS cle_api_6 , t0 . puce_map AS puce_map_7 , t0 . styles AS styles_8 FROM maps t0 WHERE t0 . id = 1 ; Copy
0.27 ms
1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . actif AS actif_3 FROM partage_config t0
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . actif AS actif_3 FROM partage_config t0 ; Copy
0.25 ms
1
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 FROM menu t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 FROM menu t0 WHERE t0 . id = 1 ; Copy
0.25 ms
1
SELECT t0 . id AS id_1 , t0 . affichage AS affichage_2 , t0 . choix_affichage_carte AS choix_affichage_carte_3 , t0 . choix_affichage_mixte AS choix_affichage_mixte_4 , t0 . choix_affichage_liste AS choix_affichage_liste_5 FROM type_affichage t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . affichage AS affichage_2 , t0 . choix_affichage_carte AS choix_affichage_carte_3 , t0 . choix_affichage_mixte AS choix_affichage_mixte_4 , t0 . choix_affichage_liste AS choix_affichage_liste_5 FROM type_affichage t0 WHERE t0 . id = 1 ; Copy