Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

36 Database Queries

8 Different statements

5.51 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.value AS value_2, t0.canonical AS canonical_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.lang_id AS lang_id_8 FROM slug t0 WHERE t0.value = ? AND t0.lang_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.code_traduction AS code_traduction_3, t0.nom AS nom_4, t0.description AS description_5, t0.slug AS slug_6, t0.ordre AS ordre_7, t0.titre AS titre_8, t0.etat AS etat_9, t0.canonical AS canonical_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_translated AS is_translated_13, t0.lang_id AS lang_id_14 FROM theme t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ?
SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1
SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ?
SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ?
SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1
SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ?
SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ?
SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1
SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ?
SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ?
SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1
SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ?
SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ?
SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1
SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ?
SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ?
SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1
SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ?
SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ?
SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1
SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ?
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.etat AS etat_3, p0_.photo_profil AS photo_profil_4, p0_.slug AS slug_5, p0_.code_traduction AS code_traduction_6, p0_.titre_actif AS titre_actif_7, p0_.type AS type_8, p0_.redirection AS redirection_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.is_translated AS is_translated_12, p0_.lang_id AS lang_id_13 FROM PAGE p0_ WHERE p0_.code_traduction = ? AND p0_.lang_id = ?

#▲	Time	Info
1	0.53 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"fr"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = 'fr' LIMIT 1;
2	0.17 ms	SELECT t0.id AS id_1, t0.value AS value_2, t0.canonical AS canonical_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.lang_id AS lang_id_8 FROM slug t0 WHERE t0.value = ? AND t0.lang_id = ? LIMIT 1 Parameters: [`"week-ends-escapades" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.value AS value_2, t0.canonical AS canonical_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.lang_id AS lang_id_8 FROM slug t0 WHERE t0.value = ? AND t0.lang_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.value AS value_2, t0.canonical AS canonical_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.lang_id AS lang_id_8 FROM slug t0 WHERE t0.value = 'week-ends-escapades' AND t0.lang_id = 1 LIMIT 1;
3	0.17 ms	SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.code_traduction AS code_traduction_3, t0.nom AS nom_4, t0.description AS description_5, t0.slug AS slug_6, t0.ordre AS ordre_7, t0.titre AS titre_8, t0.etat AS etat_9, t0.canonical AS canonical_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_translated AS is_translated_13, t0.lang_id AS lang_id_14 FROM theme t0 WHERE t0.id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.code_traduction AS code_traduction_3, t0.nom AS nom_4, t0.description AS description_5, t0.slug AS slug_6, t0.ordre AS ordre_7, t0.titre AS titre_8, t0.etat AS etat_9, t0.canonical AS canonical_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_translated AS is_translated_13, t0.lang_id AS lang_id_14 FROM theme t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.code_traduction AS code_traduction_3, t0.nom AS nom_4, t0.description AS description_5, t0.slug AS slug_6, t0.ordre AS ordre_7, t0.titre AS titre_8, t0.etat AS etat_9, t0.canonical AS canonical_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_translated AS is_translated_13, t0.lang_id AS lang_id_14 FROM theme t0 WHERE t0.id = 16;
4	0.16 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"fr"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = 'fr' LIMIT 1;
5	0.21 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"fr"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = 'fr' LIMIT 1;
6	0.16 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"fr"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = 'fr' LIMIT 1;
7	0.20 ms	SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`122 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 122 AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = 1;
8	0.22 ms	SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 Parameters: [`80 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = 80 AND i0_.lang_id = 1 LIMIT 1;
9	0.14 ms	SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? Parameters: [`80 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = 80 AND i0_.lang_id = 1;
10	0.13 ms	SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`142 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 142 AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = 1;
11	0.14 ms	SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 Parameters: [`102 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = 102 AND i0_.lang_id = 1 LIMIT 1;
12	0.13 ms	SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? Parameters: [`102 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = 102 AND i0_.lang_id = 1;
13	0.14 ms	SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`116 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 116 AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = 1;
14	0.18 ms	SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 Parameters: [`74 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = 74 AND i0_.lang_id = 1 LIMIT 1;
15	0.13 ms	SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? Parameters: [`74 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = 74 AND i0_.lang_id = 1;
16	0.12 ms	SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`72 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 72 AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = 1;
17	0.14 ms	SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 Parameters: [`65 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = 65 AND i0_.lang_id = 1 LIMIT 1;
18	0.12 ms	SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? Parameters: [`65 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = 65 AND i0_.lang_id = 1;
19	0.11 ms	SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`73 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 73 AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = 1;
20	0.14 ms	SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 Parameters: [`66 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = 66 AND i0_.lang_id = 1 LIMIT 1;
21	0.12 ms	SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? Parameters: [`66 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = 66 AND i0_.lang_id = 1;
22	0.12 ms	SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`75 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 75 AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = 1;
23	0.13 ms	SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 Parameters: [`68 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = 68 AND i0_.lang_id = 1 LIMIT 1;
24	0.12 ms	SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? Parameters: [`68 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = 68 AND i0_.lang_id = 1;
25	0.11 ms	SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`2 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.destination_idiresa AS destination_idiresa_1, r0_.lieu_id AS lieu_id_2, r0_.commercialisation AS commercialisation_3, r0_.discontinued AS discontinued_4, r0_.nom AS nom_5, r0_.slug AS slug_6, r0_.ville AS ville_7, r0_.idiresa AS idiresa_8, r0_.iscontact AS iscontact_9, r0_.taux AS taux_10, r0_.prefixetarif AS prefixetarif_11, r0_.suffixetarif AS suffixetarif_12, r0_.depot_id AS depot_id_13, r0_.etefr_id AS etefr_id_14, r0_.eteen_id AS eteen_id_15, r0_.hiverfr_id AS hiverfr_id_16, r0_.hiveren_id AS hiveren_id_17, r0_.saisonfr_id AS saisonfr_id_18, r0_.saisonen_id AS saisonen_id_19 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 2 AND r0_.commercialisation = 1 AND r0_.discontinued = 0 AND o1_.etat = 1 AND o1_.lang_id = 1;
26	0.13 ms	SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 Parameters: [`4 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? LIMIT 1 SELECT i0_.id AS id_0, i0_.res_lieu AS res_lieu_1, i0_.picto_theme AS picto_theme_2, i0_.info_adress AS info_adress_3, i0_.info_gps AS info_gps_4, i0_.info_gmap AS info_gmap_5, i0_.seo_title AS seo_title_6, i0_.seo_desc AS seo_desc_7, i0_.res_bigdesc AS res_bigdesc_8, i0_.plus_infos_residence AS plus_infos_residence_9, i0_.res_shortdesc AS res_shortdesc_10, i0_.ouverture AS ouverture_11, i0_.plus AS plus_12, i0_.plus_family AS plus_family_13, i0_.plus_bienetre AS plus_bienetre_14, i0_.plus_mention AS plus_mention_15, i0_.info_car AS info_car_16, i0_.info_plane AS info_plane_17, i0_.info_train AS info_train_18, i0_.info_check_in AS info_check_in_19, i0_.info_check_out AS info_check_out_20, i0_.info_reception AS info_reception_21, i0_.info_pool AS info_pool_22, i0_.info_taxanddeposit AS info_taxanddeposit_23, i0_.logo1_name AS logo1_name_24, i0_.logo1_title AS logo1_title_25, i0_.logo2_name AS logo2_name_26, i0_.logo2_title AS logo2_title_27, i0_.info_cancel AS info_cancel_28, i0_.info_discover AS info_discover_29, i0_.created_at AS created_at_30, i0_.updated_at AS updated_at_31, i0_.is_translated AS is_translated_32, i0_.residence_id AS residence_id_33, i0_.lang_id AS lang_id_34 FROM infos_residence i0_ WHERE i0_.residence_id = 4 AND i0_.lang_id = 1 LIMIT 1;
27	0.11 ms	SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? Parameters: [`4 1`] View formatted query View runnable query Explain query SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = ? AND i0_.lang_id = ? SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.id_iresa AS id_iresa_2, i0_.photo_profil AS photo_profil_3, i0_.description_popin AS description_popin_4, i0_.photo_popin AS photo_popin_5, i0_.service_inc AS service_inc_6, i0_.service_noinc AS service_noinc_7, i0_.presta_inc AS presta_inc_8, i0_.presta_noinc AS presta_noinc_9, i0_.nom AS nom_10, i0_.description AS description_11, i0_.picto AS picto_12, i0_.suffixe AS suffixe_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.is_translated AS is_translated_16, i0_.residence_id AS residence_id_17, i0_.lang_id AS lang_id_18 FROM infos_formule_base i0_ WHERE i0_.residence_id = 4 AND i0_.lang_id = 1;
28	0.12 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`80 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 80 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
29	0.14 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`102 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 102 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
30	0.13 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`74 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 74 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
31	0.13 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`65 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 65 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
32	0.13 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`66 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 66 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
33	0.12 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`68 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 68 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
34	0.13 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`4 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 4 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
35	0.16 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"fr"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = 'fr' LIMIT 1;
36	0.17 ms	SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.etat AS etat_3, p0_.photo_profil AS photo_profil_4, p0_.slug AS slug_5, p0_.code_traduction AS code_traduction_6, p0_.titre_actif AS titre_actif_7, p0_.type AS type_8, p0_.redirection AS redirection_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.is_translated AS is_translated_12, p0_.lang_id AS lang_id_13 FROM PAGE p0_ WHERE p0_.code_traduction = ? AND p0_.lang_id = ? Parameters: [`"19" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.etat AS etat_3, p0_.photo_profil AS photo_profil_4, p0_.slug AS slug_5, p0_.code_traduction AS code_traduction_6, p0_.titre_actif AS titre_actif_7, p0_.type AS type_8, p0_.redirection AS redirection_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.is_translated AS is_translated_12, p0_.lang_id AS lang_id_13 FROM PAGE p0_ WHERE p0_.code_traduction = ? AND p0_.lang_id = ? SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.etat AS etat_3, p0_.photo_profil AS photo_profil_4, p0_.slug AS slug_5, p0_.code_traduction AS code_traduction_6, p0_.titre_actif AS titre_actif_7, p0_.type AS type_8, p0_.redirection AS redirection_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.is_translated AS is_translated_12, p0_.lang_id AS lang_id_13 FROM PAGE p0_ WHERE p0_.code_traduction = '19' AND p0_.lang_id = 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Slug	No errors.
App\Entity\Language	No errors.
App\Entity\media	No errors.
App\Entity\Theme	No errors.
App\Entity\Residence	No errors.
App\Entity\OptionResidence	No errors.
App\Entity\depot	No errors.
App\Entity\fiche	No errors.
App\Entity\InfosFormuleBase	No errors.
App\Entity\Package	No errors.
App\Entity\mediaResidence	No errors.
App\Entity\InfosResidence	No errors.
App\Entity\InfosEvent	No errors.
App\Entity\InfosDiscover	No errors.
App\Entity\InfosDiscoverLink	No errors.
App\Entity\Typologie	No errors.
App\Entity\offre	No errors.
App\Entity\ResidenceReplacementSuggestion	No errors.
App\Entity\Page	No errors.

Symfony Profiler

https://sandbox.ateya-vacances.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CPageController%253A%253Amenu

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping