Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

46 Database Queries

7 Different statements

7.05 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_0, t0_.id_iresa AS id_iresa_1, t0_.code_traduction AS code_traduction_2, t0_.nom AS nom_3, t0_.description AS description_4, t0_.slug AS slug_5, t0_.ordre AS ordre_6, t0_.titre AS titre_7, t0_.etat AS etat_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.is_translated AS is_translated_11, t0_.lang_id AS lang_id_12 FROM theme t0_ WHERE t0_.code_traduction = ? AND t0_.lang_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 r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 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_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 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_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 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_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 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_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 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_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 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_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 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_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 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_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 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_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 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 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.55 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.40 ms	SELECT t0_.id AS id_0, t0_.id_iresa AS id_iresa_1, t0_.code_traduction AS code_traduction_2, t0_.nom AS nom_3, t0_.description AS description_4, t0_.slug AS slug_5, t0_.ordre AS ordre_6, t0_.titre AS titre_7, t0_.etat AS etat_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.is_translated AS is_translated_11, t0_.lang_id AS lang_id_12 FROM theme t0_ WHERE t0_.code_traduction = ? AND t0_.lang_id = ? Parameters: [`"82" 1`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.id_iresa AS id_iresa_1, t0_.code_traduction AS code_traduction_2, t0_.nom AS nom_3, t0_.description AS description_4, t0_.slug AS slug_5, t0_.ordre AS ordre_6, t0_.titre AS titre_7, t0_.etat AS etat_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.is_translated AS is_translated_11, t0_.lang_id AS lang_id_12 FROM theme t0_ WHERE t0_.code_traduction = ? AND t0_.lang_id = ? SELECT t0_.id AS id_0, t0_.id_iresa AS id_iresa_1, t0_.code_traduction AS code_traduction_2, t0_.nom AS nom_3, t0_.description AS description_4, t0_.slug AS slug_5, t0_.ordre AS ordre_6, t0_.titre AS titre_7, t0_.etat AS etat_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.is_translated AS is_translated_11, t0_.lang_id AS lang_id_12 FROM theme t0_ WHERE t0_.code_traduction = '82' AND t0_.lang_id = 1;
3	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;
4	0.18 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.18 ms	SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`153 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 153 AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = 1;
6	0.19 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: [`119 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 = 119 AND i0_.lang_id = 1 LIMIT 1;
7	0.15 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: [`119 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 = 119 AND i0_.lang_id = 1;
8	0.14 ms	SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 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_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 2 AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = 1;
9	0.17 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;
10	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: [`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;
11	0.13 ms	SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`4 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 4 AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = 1;
12	0.15 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: [`9 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 = 9 AND i0_.lang_id = 1 LIMIT 1;
13	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: [`9 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 = 9 AND i0_.lang_id = 1;
14	0.13 ms	SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`124 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 124 AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = 1;
15	0.15 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: [`85 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 = 85 AND i0_.lang_id = 1 LIMIT 1;
16	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: [`85 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 = 85 AND i0_.lang_id = 1;
17	0.13 ms	SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`123 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 123 AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = 1;
18	0.15 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: [`81 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 = 81 AND i0_.lang_id = 1 LIMIT 1;
19	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: [`81 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 = 81 AND i0_.lang_id = 1;
20	0.13 ms	SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`117 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 117 AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = 1;
21	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: [`75 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 = 75 AND i0_.lang_id = 1 LIMIT 1;
22	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: [`75 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 = 75 AND i0_.lang_id = 1;
23	0.13 ms	SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`130 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 130 AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = 1;
24	0.12 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: [`89 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 = 89 AND i0_.lang_id = 1 LIMIT 1;
25	0.10 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: [`89 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 = 89 AND i0_.lang_id = 1;
26	0.10 ms	SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`368 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 368 AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = 1;
27	0.28 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: [`173 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 = 173 AND i0_.lang_id = 1 LIMIT 1;
28	0.10 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: [`173 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 = 173 AND i0_.lang_id = 1;
29	0.10 ms	SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`159 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 159 AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = 1;
30	0.12 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: [`113 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 = 113 AND i0_.lang_id = 1 LIMIT 1;
31	0.10 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: [`113 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 = 113 AND i0_.lang_id = 1;
32	0.10 ms	SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`174 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = ? AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.ville AS ville_2, r0_.idiresa AS idiresa_3, r0_.iscontact AS iscontact_4, r0_.taux AS taux_5, r0_.prefixetarif AS prefixetarif_6, r0_.suffixetarif AS suffixetarif_7, r0_.lieu_id AS lieu_id_8, r0_.commercialisation AS commercialisation_9, r0_.etat AS etat_10, r0_.destination_idiresa AS destination_idiresa_11, r0_.depot_id AS depot_id_12, r0_.etefr_id AS etefr_id_13, r0_.eteen_id AS eteen_id_14, r0_.hiverfr_id AS hiverfr_id_15, r0_.hiveren_id AS hiveren_id_16, r0_.saisonfr_id AS saisonfr_id_17, r0_.saisonen_id AS saisonen_id_18 FROM residence r0_ LEFT JOIN option_residence o1_ ON r0_.id = o1_.residence_id WHERE r0_.idiresa = 174 AND r0_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = 1;
33	0.12 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: [`134 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 = 134 AND i0_.lang_id = 1 LIMIT 1;
34	0.10 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: [`134 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 = 134 AND i0_.lang_id = 1;
35	0.18 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: [`119 "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 = 119 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;
36	0.19 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;
37	0.15 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: [`9 "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 = 9 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;
38	0.11 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: [`85 "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 = 85 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;
39	0.10 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: [`81 "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 = 81 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;
40	0.10 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: [`75 "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 = 75 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;
41	0.10 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: [`89 "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 = 89 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;
42	0.10 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: [`173 "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 = 173 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;
43	0.10 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: [`113 "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 = 113 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;
44	0.11 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: [`134 "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 = 134 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;
45	0.17 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;
46	0.21 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\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\Page	No errors.

Symfony Profiler

https://preprod.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