| 1 |
1.27 ms |
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;
|
| 2 |
0.49 ms |
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;
|
| 3 |
1.29 ms |
SELECT t0.id AS id_1, t0.ref_interne AS ref_interne_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.photo1 AS photo1_6, t0.descriptif AS descriptif_7, t0.accroche AS accroche_8, t0.condifi AS condifi_9, t0.prestimm AS prestimm_10, t0.equipement AS equipement_11, t0.dispo AS dispo_12, t0.desserte AS desserte_13, t0.nom_consultant AS nom_consultant_14, t0.tel_consultant AS tel_consultant_15, t0.tel_port_consultant AS tel_port_consultant_16, t0.mail_consultant AS mail_consultant_17, t0.divisible AS divisible_18, t0.date_modif AS date_modif_19, t0.url_virtuelle AS url_virtuelle_20, t0.dpe_chiffre AS dpe_chiffre_21, t0.dpe_lettre AS dpe_lettre_22, t0.ges_chiffre AS ges_chiffre_23, t0.ges_lettre AS ges_lettre_24, t0.surface_div AS surface_div_25, t0.surface_totale AS surface_totale_26, t0.latitude AS latitude_27, t0.longitude AS longitude_28, t0.prix_vente_global AS prix_vente_global_29, t0.loyer_global AS loyer_global_30, t0.honos_pourcent AS honos_pourcent_31, t0.honos_montant AS honos_montant_32, t0.photo2 AS photo2_33, t0.photo3 AS photo3_34, t0.photo4 AS photo4_35, t0.photo5 AS photo5_36, t0.photo6 AS photo6_37, t0.photo7 AS photo7_38, t0.photo8 AS photo8_39, t0.photo9 AS photo9_40, t0.photo10 AS photo10_41, t0.photo11 AS photo11_42, t0.photo12 AS photo12_43, t0.photo13 AS photo13_44, t0.photo14 AS photo14_45, t0.photo15 AS photo15_46, t0.plan1 AS plan1_47, t0.plan2 AS plan2_48, t0.plan3 AS plan3_49, t0.plan4 AS plan4_50, t0.plan5 AS plan5_51, t0.plan6 AS plan6_52, t0.plan7 AS plan7_53, t0.plan8 AS plan8_54, t0.plan9 AS plan9_55, t0.plan10 AS plan10_56, t0.plan11 AS plan11_57, t0.plan12 AS plan12_58, t0.plan13 AS plan13_59, t0.plan14 AS plan14_60, t0.plan15 AS plan15_61, t0.slug_ville_cp AS slug_ville_cp_62, t0.slug_ville AS slug_ville_63, t0.slug_type AS slug_type_64, t0.slug_nature AS slug_nature_65, t0.slug_nature_second AS slug_nature_second_66, t0.slug_detail_url AS slug_detail_url_67, t0.directe AS directe_68, t0.archive AS archive_69, t0.loyer_mcarre AS loyer_mcarre_70, t0.prix_mcarre AS prix_mcarre_71, t0.detail_surfaces AS detail_surfaces_72, t0.departement AS departement_73, t0.departement_slug AS departement_slug_74, t0.departement_libelle AS departement_libelle_75, t0.import AS import_76, t0.nature_id AS nature_id_77, t0.type_id AS type_id_78 FROM offres t0 WHERE t0.slug_detail_url = ? LIMIT 1
Parameters: [
"bureaux-a-louer-biarritz-64200-64-0243"
]
SELECT
t0.id AS id_1,
t0.ref_interne AS ref_interne_2,
t0.adresse AS adresse_3,
t0.cp AS cp_4,
t0.ville AS ville_5,
t0.photo1 AS photo1_6,
t0.descriptif AS descriptif_7,
t0.accroche AS accroche_8,
t0.condifi AS condifi_9,
t0.prestimm AS prestimm_10,
t0.equipement AS equipement_11,
t0.dispo AS dispo_12,
t0.desserte AS desserte_13,
t0.nom_consultant AS nom_consultant_14,
t0.tel_consultant AS tel_consultant_15,
t0.tel_port_consultant AS tel_port_consultant_16,
t0.mail_consultant AS mail_consultant_17,
t0.divisible AS divisible_18,
t0.date_modif AS date_modif_19,
t0.url_virtuelle AS url_virtuelle_20,
t0.dpe_chiffre AS dpe_chiffre_21,
t0.dpe_lettre AS dpe_lettre_22,
t0.ges_chiffre AS ges_chiffre_23,
t0.ges_lettre AS ges_lettre_24,
t0.surface_div AS surface_div_25,
t0.surface_totale AS surface_totale_26,
t0.latitude AS latitude_27,
t0.longitude AS longitude_28,
t0.prix_vente_global AS prix_vente_global_29,
t0.loyer_global AS loyer_global_30,
t0.honos_pourcent AS honos_pourcent_31,
t0.honos_montant AS honos_montant_32,
t0.photo2 AS photo2_33,
t0.photo3 AS photo3_34,
t0.photo4 AS photo4_35,
t0.photo5 AS photo5_36,
t0.photo6 AS photo6_37,
t0.photo7 AS photo7_38,
t0.photo8 AS photo8_39,
t0.photo9 AS photo9_40,
t0.photo10 AS photo10_41,
t0.photo11 AS photo11_42,
t0.photo12 AS photo12_43,
t0.photo13 AS photo13_44,
t0.photo14 AS photo14_45,
t0.photo15 AS photo15_46,
t0.plan1 AS plan1_47,
t0.plan2 AS plan2_48,
t0.plan3 AS plan3_49,
t0.plan4 AS plan4_50,
t0.plan5 AS plan5_51,
t0.plan6 AS plan6_52,
t0.plan7 AS plan7_53,
t0.plan8 AS plan8_54,
t0.plan9 AS plan9_55,
t0.plan10 AS plan10_56,
t0.plan11 AS plan11_57,
t0.plan12 AS plan12_58,
t0.plan13 AS plan13_59,
t0.plan14 AS plan14_60,
t0.plan15 AS plan15_61,
t0.slug_ville_cp AS slug_ville_cp_62,
t0.slug_ville AS slug_ville_63,
t0.slug_type AS slug_type_64,
t0.slug_nature AS slug_nature_65,
t0.slug_nature_second AS slug_nature_second_66,
t0.slug_detail_url AS slug_detail_url_67,
t0.directe AS directe_68,
t0.archive AS archive_69,
t0.loyer_mcarre AS loyer_mcarre_70,
t0.prix_mcarre AS prix_mcarre_71,
t0.detail_surfaces AS detail_surfaces_72,
t0.departement AS departement_73,
t0.departement_slug AS departement_slug_74,
t0.departement_libelle AS departement_libelle_75,
t0.import AS import_76,
t0.nature_id AS nature_id_77,
t0.type_id AS type_id_78
FROM
offres t0
WHERE
t0.slug_detail_url = ?
LIMIT
1
SELECT t0.id AS id_1, t0.ref_interne AS ref_interne_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.photo1 AS photo1_6, t0.descriptif AS descriptif_7, t0.accroche AS accroche_8, t0.condifi AS condifi_9, t0.prestimm AS prestimm_10, t0.equipement AS equipement_11, t0.dispo AS dispo_12, t0.desserte AS desserte_13, t0.nom_consultant AS nom_consultant_14, t0.tel_consultant AS tel_consultant_15, t0.tel_port_consultant AS tel_port_consultant_16, t0.mail_consultant AS mail_consultant_17, t0.divisible AS divisible_18, t0.date_modif AS date_modif_19, t0.url_virtuelle AS url_virtuelle_20, t0.dpe_chiffre AS dpe_chiffre_21, t0.dpe_lettre AS dpe_lettre_22, t0.ges_chiffre AS ges_chiffre_23, t0.ges_lettre AS ges_lettre_24, t0.surface_div AS surface_div_25, t0.surface_totale AS surface_totale_26, t0.latitude AS latitude_27, t0.longitude AS longitude_28, t0.prix_vente_global AS prix_vente_global_29, t0.loyer_global AS loyer_global_30, t0.honos_pourcent AS honos_pourcent_31, t0.honos_montant AS honos_montant_32, t0.photo2 AS photo2_33, t0.photo3 AS photo3_34, t0.photo4 AS photo4_35, t0.photo5 AS photo5_36, t0.photo6 AS photo6_37, t0.photo7 AS photo7_38, t0.photo8 AS photo8_39, t0.photo9 AS photo9_40, t0.photo10 AS photo10_41, t0.photo11 AS photo11_42, t0.photo12 AS photo12_43, t0.photo13 AS photo13_44, t0.photo14 AS photo14_45, t0.photo15 AS photo15_46, t0.plan1 AS plan1_47, t0.plan2 AS plan2_48, t0.plan3 AS plan3_49, t0.plan4 AS plan4_50, t0.plan5 AS plan5_51, t0.plan6 AS plan6_52, t0.plan7 AS plan7_53, t0.plan8 AS plan8_54, t0.plan9 AS plan9_55, t0.plan10 AS plan10_56, t0.plan11 AS plan11_57, t0.plan12 AS plan12_58, t0.plan13 AS plan13_59, t0.plan14 AS plan14_60, t0.plan15 AS plan15_61, t0.slug_ville_cp AS slug_ville_cp_62, t0.slug_ville AS slug_ville_63, t0.slug_type AS slug_type_64, t0.slug_nature AS slug_nature_65, t0.slug_nature_second AS slug_nature_second_66, t0.slug_detail_url AS slug_detail_url_67, t0.directe AS directe_68, t0.archive AS archive_69, t0.loyer_mcarre AS loyer_mcarre_70, t0.prix_mcarre AS prix_mcarre_71, t0.detail_surfaces AS detail_surfaces_72, t0.departement AS departement_73, t0.departement_slug AS departement_slug_74, t0.departement_libelle AS departement_libelle_75, t0.import AS import_76, t0.nature_id AS nature_id_77, t0.type_id AS type_id_78 FROM offres t0 WHERE t0.slug_detail_url = 'bureaux-a-louer-biarritz-64200-64-0243' LIMIT 1;
|
| 4 |
1.04 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.tel AS tel_5, t0.fax AS fax_6, t0.image AS image_7, t0.update_at AS update_at_8, t0.lien1 AS lien1_9, t0.lien2 AS lien2_10, t0.fonction AS fonction_11, t0.equipe_id AS equipe_id_12 FROM collaborateurs t0 WHERE t0.email = ? LIMIT 1
Parameters: [
"guillaume.decoral@evolis-ie.com"
]
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.tel AS tel_5, t0.fax AS fax_6, t0.image AS image_7, t0.update_at AS update_at_8, t0.lien1 AS lien1_9, t0.lien2 AS lien2_10, t0.fonction AS fonction_11, t0.equipe_id AS equipe_id_12 FROM collaborateurs t0 WHERE t0.email = 'guillaume.decoral@evolis-ie.com' LIMIT 1;
|
| 5 |
0.47 ms |
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.id = ?
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.id = 1;
|
| 6 |
0.36 ms |
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.id = ?
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.id = 1;
|
| 7 |
0.81 ms |
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_.nature_id = ? AND o0_.type_id = ? AND ((o0_.surface_totale >= ? AND o0_.surface_totale <= ?) OR o0_.surface_div >= ? AND o0_.surface_div <= ?) AND ((o0_.loyer_global >= ? AND o0_.loyer_global <= ?)) AND o0_.cp LIKE ?
Parameters: [
1
1
64.0
104.0
64.0
104.0
0
100000000
"64200%"
]
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_.nature_id = ?
AND o0_.type_id = ?
AND (
(
o0_.surface_totale >= ?
AND o0_.surface_totale <= ?
)
OR o0_.surface_div >= ?
AND o0_.surface_div <= ?
)
AND (
(
o0_.loyer_global >= ?
AND o0_.loyer_global <= ?
)
)
AND o0_.cp LIKE ?
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_.nature_id = 1 AND o0_.type_id = 1 AND ((o0_.surface_totale >= 64 AND o0_.surface_totale <= 104) OR o0_.surface_div >= 64 AND o0_.surface_div <= 104) AND ((o0_.loyer_global >= 0 AND o0_.loyer_global <= 100000000)) AND o0_.cp LIKE '64200%';
|
| 8 |
0.45 ms |
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;
|
| 9 |
0.38 ms |
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;
|
| 10 |
0.38 ms |
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;
|
| 11 |
0.32 ms |
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;
|
| 12 |
0.34 ms |
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;
|
| 13 |
0.32 ms |
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;
|
| 14 |
90.41 ms |
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;
|
| 15 |
0.59 ms |
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;
|
| 16 |
0.37 ms |
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 = 2;
|
| 17 |
0.33 ms |
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;
|
| 18 |
0.26 ms |
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;
|
| 19 |
0.25 ms |
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;
|
| 20 |
0.25 ms |
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 = 2;
|
| 21 |
0.23 ms |
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 = 3;
|
| 22 |
0.27 ms |
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;
|
| 23 |
0.49 ms |
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;
|
| 24 |
0.37 ms |
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;
|
| 25 |
0.32 ms |
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;
|
| 26 |
0.36 ms |
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;
|
| 27 |
0.65 ms |
SELECT t0.id AS id_1, t0.ref_interne AS ref_interne_2, t0.lib_etage AS lib_etage_3, t0.num AS num_4, t0.surface AS surface_5, t0.loyer AS loyer_6, t0.prix AS prix_7, t0.charge AS charge_8, t0.batiment AS batiment_9, t0.lot AS lot_10, t0.escalier AS escalier_11, t0.dispo AS dispo_12, t0.import AS import_13, t0.offre_id AS offre_id_14 FROM surfaces t0 WHERE t0.offre_id = ?
SELECT t0.id AS id_1, t0.ref_interne AS ref_interne_2, t0.lib_etage AS lib_etage_3, t0.num AS num_4, t0.surface AS surface_5, t0.loyer AS loyer_6, t0.prix AS prix_7, t0.charge AS charge_8, t0.batiment AS batiment_9, t0.lot AS lot_10, t0.escalier AS escalier_11, t0.dispo AS dispo_12, t0.import AS import_13, t0.offre_id AS offre_id_14 FROM surfaces t0 WHERE t0.offre_id = 668;
|