| 1 |
0.91 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.47 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 |
0.41 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.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;
|
| 4 |
0.29 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.slug = ? LIMIT 1
Parameters: [
"coworking"
]
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 = 'coworking' LIMIT 1;
|
| 5 |
0.52 ms |
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, t0.home AS home_15, t0.agence_id AS agence_id_16 FROM secteur t0 WHERE t0.url = ? LIMIT 1
Parameters: [
"/offres-immobilier/location/coworking/paris-75005/"
]
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, t0.home AS home_15, t0.agence_id AS agence_id_16 FROM secteur t0 WHERE t0.url = '/offres-immobilier/location/coworking/paris-75005/' LIMIT 1;
|
| 6 |
0.27 ms |
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;
|
| 7 |
0.76 ms |
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 = 7 AND o0_.directe = 1
Parameters: [
"paris-75005"
]
SELECT count(DISTINCT o0_.id) AS sclr_0 FROM offres o0_ WHERE o0_.slug_ville_cp = 'paris-75005' AND o0_.nature_id = 1 AND o0_.type_id = 7 AND o0_.directe = 1;
|
| 8 |
0.67 ms |
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 = 7 AND o0_.directe = 1 ORDER BY o0_.date_modif ASC LIMIT 16
Parameters: [
"paris-75005"
]
SELECT DISTINCT o0_.id AS id_0, o0_.date_modif AS date_modif_1 FROM offres o0_ WHERE o0_.slug_ville_cp = 'paris-75005' AND o0_.nature_id = 1 AND o0_.type_id = 7 AND o0_.directe = 1 ORDER BY o0_.date_modif ASC LIMIT 16;
|
| 9 |
0.76 ms |
SELECT o0_.slug_ville_cp AS slug_ville_cp_0, o0_.ville AS ville_1, o0_.cp AS cp_2, o0_.departement_slug AS departement_slug_3, COUNT(o0_.id) AS sclr_4 FROM offres o0_ WHERE o0_.slug_ville_cp <> ? AND o0_.cp LIKE ? AND o0_.nature_id = 1 AND o0_.type_id = 7 GROUP BY o0_.slug_ville_cp ORDER BY o0_.ville ASC
Parameters: [
"paris-75005"
"75%"
]
SELECT o0_.slug_ville_cp AS slug_ville_cp_0, o0_.ville AS ville_1, o0_.cp AS cp_2, o0_.departement_slug AS departement_slug_3, COUNT(o0_.id) AS sclr_4 FROM offres o0_ WHERE o0_.slug_ville_cp <> 'paris-75005' AND o0_.cp LIKE '75%' AND o0_.nature_id = 1 AND o0_.type_id = 7 GROUP BY o0_.slug_ville_cp ORDER BY o0_.ville ASC;
|
| 10 |
0.94 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_.price_min AS price_min_76, o0_.price_max AS price_max_77, o0_.price_max_uom AS price_max_uom_78, o0_.price_average AS price_average_79, o0_.price_uom_text AS price_uom_text_80, o0_.price_gross_rent_price AS price_gross_rent_price_81, o0_.price_gross_rent_price_text AS price_gross_rent_price_text_82, o0_.nature_id AS nature_id_83, o0_.type_id AS type_id_84, o0_.agence_id AS agence_id_85, o0_.page_index_id AS page_index_id_86 FROM offres o0_ WHERE o0_.slug_ville_cp = ? AND o0_.nature_id = 1 AND o0_.type_id = 7 AND o0_.directe = 1 ORDER BY o0_.date_modif ASC LIMIT 16
Parameters: [
"paris-75005"
]
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_.price_min AS price_min_76,
o0_.price_max AS price_max_77,
o0_.price_max_uom AS price_max_uom_78,
o0_.price_average AS price_average_79,
o0_.price_uom_text AS price_uom_text_80,
o0_.price_gross_rent_price AS price_gross_rent_price_81,
o0_.price_gross_rent_price_text AS price_gross_rent_price_text_82,
o0_.nature_id AS nature_id_83,
o0_.type_id AS type_id_84,
o0_.agence_id AS agence_id_85,
o0_.page_index_id AS page_index_id_86
FROM
offres o0_
WHERE
o0_.slug_ville_cp = ?
AND o0_.nature_id = 1
AND o0_.type_id = 7
AND o0_.directe = 1
ORDER BY
o0_.date_modif ASC
LIMIT
16
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_.price_min AS price_min_76, o0_.price_max AS price_max_77, o0_.price_max_uom AS price_max_uom_78, o0_.price_average AS price_average_79, o0_.price_uom_text AS price_uom_text_80, o0_.price_gross_rent_price AS price_gross_rent_price_81, o0_.price_gross_rent_price_text AS price_gross_rent_price_text_82, o0_.nature_id AS nature_id_83, o0_.type_id AS type_id_84, o0_.agence_id AS agence_id_85, o0_.page_index_id AS page_index_id_86 FROM offres o0_ WHERE o0_.slug_ville_cp = 'paris-75005' AND o0_.nature_id = 1 AND o0_.type_id = 7 AND o0_.directe = 1 ORDER BY o0_.date_modif ASC LIMIT 16;
|
| 11 |
1.03 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_.price_min AS price_min_76, o0_.price_max AS price_max_77, o0_.price_max_uom AS price_max_uom_78, o0_.price_average AS price_average_79, o0_.price_uom_text AS price_uom_text_80, o0_.price_gross_rent_price AS price_gross_rent_price_81, o0_.price_gross_rent_price_text AS price_gross_rent_price_text_82, o0_.nature_id AS nature_id_83, o0_.type_id AS type_id_84, o0_.agence_id AS agence_id_85, o0_.page_index_id AS page_index_id_86 FROM offres o1_, offres o0_ WHERE o0_.slug_ville_cp = ? AND o0_.nature_id = 1 AND o0_.type_id = 7 AND o0_.directe = 0
Parameters: [
"paris-75005"
]
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_.price_min AS price_min_76,
o0_.price_max AS price_max_77,
o0_.price_max_uom AS price_max_uom_78,
o0_.price_average AS price_average_79,
o0_.price_uom_text AS price_uom_text_80,
o0_.price_gross_rent_price AS price_gross_rent_price_81,
o0_.price_gross_rent_price_text AS price_gross_rent_price_text_82,
o0_.nature_id AS nature_id_83,
o0_.type_id AS type_id_84,
o0_.agence_id AS agence_id_85,
o0_.page_index_id AS page_index_id_86
FROM
offres o1_,
offres o0_
WHERE
o0_.slug_ville_cp = ?
AND o0_.nature_id = 1
AND o0_.type_id = 7
AND o0_.directe = 0
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_.price_min AS price_min_76, o0_.price_max AS price_max_77, o0_.price_max_uom AS price_max_uom_78, o0_.price_average AS price_average_79, o0_.price_uom_text AS price_uom_text_80, o0_.price_gross_rent_price AS price_gross_rent_price_81, o0_.price_gross_rent_price_text AS price_gross_rent_price_text_82, o0_.nature_id AS nature_id_83, o0_.type_id AS type_id_84, o0_.agence_id AS agence_id_85, o0_.page_index_id AS page_index_id_86 FROM offres o1_, offres o0_ WHERE o0_.slug_ville_cp = 'paris-75005' AND o0_.nature_id = 1 AND o0_.type_id = 7 AND o0_.directe = 0;
|
| 12 |
0.33 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.date_maj AS date_maj_3, t0.intro AS intro_4, t0.description AS description_5, t0.libelle_btn_phone AS libelle_btn_phone_6, t0.libelle_btn_form AS libelle_btn_form_7 FROM bloc_no_result t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.image AS image_2, t0.date_maj AS date_maj_3, t0.intro AS intro_4, t0.description AS description_5, t0.libelle_btn_phone AS libelle_btn_phone_6, t0.libelle_btn_form AS libelle_btn_form_7 FROM bloc_no_result t0 WHERE t0.id = 1;
|
| 13 |
0.37 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;
|
| 14 |
0.75 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, t0.presentation AS presentation_12, t0.logiciel_type AS logiciel_type_13, t0.logiciel_id AS logiciel_id_14, t0.email_demande AS email_demande_15, t0.slug AS slug_16, t0.titre AS titre_17, t0.image AS image_18, t0.title AS title_19, t0.meta_desc AS meta_desc_20, t0.titre_og AS titre_og_21, t0.desc_og AS desc_og_22, t0.image_og AS image_og_23, t0.calendy AS calendy_24 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, t0.presentation AS presentation_12, t0.logiciel_type AS logiciel_type_13, t0.logiciel_id AS logiciel_id_14, t0.email_demande AS email_demande_15, t0.slug AS slug_16, t0.titre AS titre_17, t0.image AS image_18, t0.title AS title_19, t0.meta_desc AS meta_desc_20, t0.titre_og AS titre_og_21, t0.desc_og AS desc_og_22, t0.image_og AS image_og_23, t0.calendy AS calendy_24 FROM agence t0 ORDER BY t0.ordre ASC;
|
| 15 |
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.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;
|
| 16 |
0.27 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;
|
| 17 |
0.28 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;
|
| 18 |
0.25 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;
|
| 19 |
85.66 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;
|
| 20 |
0.84 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;
|
| 21 |
0.36 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;
|
| 22 |
0.29 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;
|
| 23 |
0.27 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ordre AS ordre_3, t0.title AS title_4, t0.url AS url_5, t0.targert AS targert_6, t0.type AS type_7 FROM menu t0
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ordre AS ordre_3, t0.title AS title_4, t0.url AS url_5, t0.targert AS targert_6, t0.type AS type_7 FROM menu t0;
|
| 24 |
0.29 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.accroche AS accroche_3, t0.btn_libelle AS btn_libelle_4, t0.btn_lien AS btn_lien_5, t0.btn_title AS btn_title_6, t0.bloc_un_nom AS bloc_un_nom_7, t0.bloc_un_lien AS bloc_un_lien_8, t0.bloc_un_title AS bloc_un_title_9, t0.bloc_deux_nom AS bloc_deux_nom_10, t0.bloc_deux_lien AS bloc_deux_lien_11, t0.bloc_deux_title AS bloc_deux_title_12, t0.bloc_trois_nom AS bloc_trois_nom_13, t0.bloc_trois_lien AS bloc_trois_lien_14, t0.bloc_trois_title AS bloc_trois_title_15 FROM menu_mega t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.accroche AS accroche_3, t0.btn_libelle AS btn_libelle_4, t0.btn_lien AS btn_lien_5, t0.btn_title AS btn_title_6, t0.bloc_un_nom AS bloc_un_nom_7, t0.bloc_un_lien AS bloc_un_lien_8, t0.bloc_un_title AS bloc_un_title_9, t0.bloc_deux_nom AS bloc_deux_nom_10, t0.bloc_deux_lien AS bloc_deux_lien_11, t0.bloc_deux_title AS bloc_deux_title_12, t0.bloc_trois_nom AS bloc_trois_nom_13, t0.bloc_trois_lien AS bloc_trois_lien_14, t0.bloc_trois_title AS bloc_trois_title_15 FROM menu_mega t0 WHERE t0.id = 1;
|
| 25 |
0.29 ms |
SELECT t0.id AS id_1, t0.bloc_un_nom AS bloc_un_nom_2, t0.bloc_deux_nom AS bloc_deux_nom_3, t0.bloc_trois_nom AS bloc_trois_nom_4 FROM footer t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.bloc_un_nom AS bloc_un_nom_2, t0.bloc_deux_nom AS bloc_deux_nom_3, t0.bloc_trois_nom AS bloc_trois_nom_4 FROM footer t0 WHERE t0.id = 1;
|
| 26 |
0.30 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;
|
| 27 |
0.30 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;
|
| 28 |
0.29 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;
|
| 29 |
0.27 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;
|
| 30 |
0.28 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;
|
| 31 |
0.38 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.ordre AS ordre_5, t0.libelle AS libelle_6, t0.type AS type_7, t0.menu_mega_deux_id AS menu_mega_deux_id_8, t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9, t0.menu_mega_id AS menu_mega_id_10, t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11, t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12 FROM menu_link t0 WHERE t0.menu_mega_id = ? ORDER BY t0.ordre ASC
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.ordre AS ordre_5, t0.libelle AS libelle_6, t0.type AS type_7, t0.menu_mega_deux_id AS menu_mega_deux_id_8, t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9, t0.menu_mega_id AS menu_mega_id_10, t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11, t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12 FROM menu_link t0 WHERE t0.menu_mega_id = 1 ORDER BY t0.ordre ASC;
|
| 32 |
0.32 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.ordre AS ordre_5, t0.libelle AS libelle_6, t0.type AS type_7, t0.menu_mega_deux_id AS menu_mega_deux_id_8, t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9, t0.menu_mega_id AS menu_mega_id_10, t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11, t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12 FROM menu_link t0 WHERE t0.menu_mega_menu_deux_id = ? ORDER BY t0.ordre ASC
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.ordre AS ordre_5, t0.libelle AS libelle_6, t0.type AS type_7, t0.menu_mega_deux_id AS menu_mega_deux_id_8, t0.menu_mega_deux_deux_id AS menu_mega_deux_deux_id_9, t0.menu_mega_id AS menu_mega_id_10, t0.menu_mega_menu_deux_id AS menu_mega_menu_deux_id_11, t0.menu_mega_menu_trois_id AS menu_mega_menu_trois_id_12 FROM menu_link t0 WHERE t0.menu_mega_menu_deux_id = 1 ORDER BY t0.ordre ASC;
|
| 33 |
0.79 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_id = ? ORDER BY t0.ordre ASC
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_id = 1 ORDER BY t0.ordre ASC;
|
| 34 |
0.67 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_deux_id = ? ORDER BY t0.ordre ASC
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_deux_id = 1 ORDER BY t0.ordre ASC;
|
| 35 |
0.63 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_trois_id = ? ORDER BY t0.ordre ASC
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.target AS target_4, t0.libelle AS libelle_5, t0.ordre AS ordre_6, t0.type AS type_7, t0.footer_id AS footer_id_8, t0.footer_deux_id AS footer_deux_id_9, t0.footer_trois_id AS footer_trois_id_10, t0.footer_big_id AS footer_big_id_11, t0.footer_big_deux_id AS footer_big_deux_id_12, t0.footer_big_trois_id AS footer_big_trois_id_13 FROM footer_link t0 WHERE t0.footer_trois_id = 1 ORDER BY t0.ordre ASC;
|