Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

61 Database Queries

30 Different statements

14.11 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.idiresa AS idiresa_4, t0.iscontact AS iscontact_5, t0.taux AS taux_6, t0.prefixetarif AS prefixetarif_7, t0.suffixetarif AS suffixetarif_8, t0.lieu_id AS lieu_id_9, t0.commercialisation AS commercialisation_10, t0.etat AS etat_11, t0.destination_idiresa AS destination_idiresa_12, t0.depot_id AS depot_id_13, t0.etefr_id AS etefr_id_14, t0.eteen_id AS eteen_id_15, t0.hiverfr_id AS hiverfr_id_16, t0.hiveren_id AS hiveren_id_17, t0.saisonfr_id AS saisonfr_id_18, t0.saisonen_id AS saisonen_id_19 FROM residence t0 WHERE t0.idiresa = ? LIMIT 1
SELECT t0.id AS id_1, t0.res_lieu AS res_lieu_2, t0.picto_theme AS picto_theme_3, t0.info_adress AS info_adress_4, t0.info_gps AS info_gps_5, t0.info_gmap AS info_gmap_6, t0.seo_title AS seo_title_7, t0.seo_desc AS seo_desc_8, t0.res_bigdesc AS res_bigdesc_9, t0.plus_infos_residence AS plus_infos_residence_10, t0.res_shortdesc AS res_shortdesc_11, t0.ouverture AS ouverture_12, t0.plus AS plus_13, t0.plus_family AS plus_family_14, t0.plus_bienetre AS plus_bienetre_15, t0.plus_mention AS plus_mention_16, t0.info_car AS info_car_17, t0.info_plane AS info_plane_18, t0.info_train AS info_train_19, t0.info_check_in AS info_check_in_20, t0.info_check_out AS info_check_out_21, t0.info_reception AS info_reception_22, t0.info_pool AS info_pool_23, t0.info_taxanddeposit AS info_taxanddeposit_24, t0.logo1_name AS logo1_name_25, t0.logo1_title AS logo1_title_26, t0.logo2_name AS logo2_name_27, t0.logo2_title AS logo2_title_28, t0.info_cancel AS info_cancel_29, t0.info_discover AS info_discover_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.is_translated AS is_translated_33, t0.residence_id AS residence_id_34, t0.lang_id AS lang_id_35 FROM infos_residence t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.etat = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.id_iresa AS id_iresa_3, t0.photo_profil AS photo_profil_4, t0.description_popin AS description_popin_5, t0.photo_popin AS photo_popin_6, t0.service_inc AS service_inc_7, t0.service_noinc AS service_noinc_8, t0.presta_inc AS presta_inc_9, t0.presta_noinc AS presta_noinc_10, t0.nom AS nom_11, t0.description AS description_12, t0.picto AS picto_13, t0.suffixe AS suffixe_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.residence_id AS residence_id_18, t0.lang_id AS lang_id_19 FROM infos_formule_base t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.idiresa AS idiresa_3, t0.code_traduction AS code_traduction_4, t0.cap_min AS cap_min_5, t0.cap_max AS cap_max_6, t0.pax_max AS pax_max_7, t0.pax_min AS pax_min_8, t0.res_personne AS res_personne_9, t0.res_superficie AS res_superficie_10, t0.res_pmr AS res_pmr_11, t0.rub_big_desc AS rub_big_desc_12, t0.mise_avant AS mise_avant_13, t0.mise_avant_desc AS mise_avant_desc_14, t0.commercialisation AS commercialisation_15, t0.etat AS etat_16, t0.info_room AS info_room_17, t0.info_bathroom AS info_bathroom_18, t0.info_exterior AS info_exterior_19, t0.info_clim AS info_clim_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_translated AS is_translated_23, t0.lang_id AS lang_id_24, t0.residence_id AS residence_id_25, t26.id AS id_27, t26.typologie_id AS typologie_id_28, t26.media_id AS media_id_29 FROM typologie t0 LEFT JOIN typologie_media t26 ON t26.typologie_id = t0.id WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.etat = ?
SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.text AS text_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_translated AS is_translated_7, t0.residence_id AS residence_id_8, t0.lang_id AS lang_id_9 FROM infos_discover t0 WHERE t0.lang_id = ? AND t0.residence_id = ?
SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.anchor AS anchor_3, t0.link AS link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_translated AS is_translated_7, t0.residence_id AS residence_id_8, t0.lang_id AS lang_id_9 FROM infos_discover_link t0 WHERE t0.lang_id = ? AND t0.residence_id = ?
SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.anchor AS anchor_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_translated AS is_translated_8, t0.residence_id AS residence_id_9, t0.lang_id AS lang_id_10 FROM infos_event t0 WHERE t0.lang_id = ? AND t0.residence_id = ?
SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.anchor AS anchor_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_translated AS is_translated_8, t0.residence_id AS residence_id_9, t0.lang_id AS lang_id_10 FROM infos_event t0 WHERE t0.lang_id = ? AND t0.residence_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_.state = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC
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_.state = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC
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_.state = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC
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_.state = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.idiresa AS idiresa_4, t0.iscontact AS iscontact_5, t0.taux AS taux_6, t0.prefixetarif AS prefixetarif_7, t0.suffixetarif AS suffixetarif_8, t0.lieu_id AS lieu_id_9, t0.commercialisation AS commercialisation_10, t0.etat AS etat_11, t0.destination_idiresa AS destination_idiresa_12, t0.depot_id AS depot_id_13, t0.etefr_id AS etefr_id_14, t0.eteen_id AS eteen_id_15, t0.hiverfr_id AS hiverfr_id_16, t0.hiveren_id AS hiveren_id_17, t0.saisonfr_id AS saisonfr_id_18, t0.saisonen_id AS saisonen_id_19 FROM residence t0 WHERE t0.idiresa = ? LIMIT 1
SELECT t0.id AS id_1, t0.res_lieu AS res_lieu_2, t0.picto_theme AS picto_theme_3, t0.info_adress AS info_adress_4, t0.info_gps AS info_gps_5, t0.info_gmap AS info_gmap_6, t0.seo_title AS seo_title_7, t0.seo_desc AS seo_desc_8, t0.res_bigdesc AS res_bigdesc_9, t0.plus_infos_residence AS plus_infos_residence_10, t0.res_shortdesc AS res_shortdesc_11, t0.ouverture AS ouverture_12, t0.plus AS plus_13, t0.plus_family AS plus_family_14, t0.plus_bienetre AS plus_bienetre_15, t0.plus_mention AS plus_mention_16, t0.info_car AS info_car_17, t0.info_plane AS info_plane_18, t0.info_train AS info_train_19, t0.info_check_in AS info_check_in_20, t0.info_check_out AS info_check_out_21, t0.info_reception AS info_reception_22, t0.info_pool AS info_pool_23, t0.info_taxanddeposit AS info_taxanddeposit_24, t0.logo1_name AS logo1_name_25, t0.logo1_title AS logo1_title_26, t0.logo2_name AS logo2_name_27, t0.logo2_title AS logo2_title_28, t0.info_cancel AS info_cancel_29, t0.info_discover AS info_discover_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.is_translated AS is_translated_33, t0.residence_id AS residence_id_34, t0.lang_id AS lang_id_35 FROM infos_residence t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.id_iresa AS id_iresa_3, t0.photo_profil AS photo_profil_4, t0.description_popin AS description_popin_5, t0.photo_popin AS photo_popin_6, t0.service_inc AS service_inc_7, t0.service_noinc AS service_noinc_8, t0.presta_inc AS presta_inc_9, t0.presta_noinc AS presta_noinc_10, t0.nom AS nom_11, t0.description AS description_12, t0.picto AS picto_13, t0.suffixe AS suffixe_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.residence_id AS residence_id_18, t0.lang_id AS lang_id_19 FROM infos_formule_base t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.commercialisation = ?
SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.id_iresa = ? AND t0.residence_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.id_iresa = ? AND t0.residence_id = ? 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 = ?
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SELECT DATABASE()
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'ateya_preprod' AND TABLE_NAME = 'migration_versions' ORDER BY ORDINAL_POSITION ASC
SELECT DATABASE()
SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!50116 , c.UPDATE_RULE, c.DELETE_RULE */ FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /*!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_NAME = 'migration_versions' AND k.TABLE_SCHEMA = 'ateya_preprod' /*!50116 AND c.CONSTRAINT_SCHEMA = 'ateya_preprod' */ORDER BY k.ORDINAL_POSITION
SELECT DATABASE()
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'migration_versions' AND TABLE_SCHEMA = 'ateya_preprod' ORDER BY SEQ_IN_INDEX ASC
SELECT t.ENGINE,
       t.AUTO_INCREMENT,
       t.TABLE_COMMENT,
       t.CREATE_OPTIONS,
       t.TABLE_COLLATION,
       ccsa.CHARACTER_SET_NAME
FROM information_schema.TABLES t
    INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa
        ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'migration_versions'
SELECT * FROM migration_versions
SELECT DATABASE()
SELECT count(p0_.id) AS sclr_0 FROM promo p0_ WHERE p0_.date_debut >= ?
SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? AND p0_.date_fin <= ? ORDER BY p0_.prix_total ASC
SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree < ? AND p0_.date_debut >= ? ORDER BY p0_.prix_total ASC
SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? ORDER BY p0_.prix_total ASC
SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? AND p0_.date_fin <= ? ORDER BY p0_.prix_total ASC
SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? AND p0_.date_fin <= ? AND p0_.environnement = ? ORDER BY p0_.prix_total ASC
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_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ?
SELECT d0_.id AS id_0, d0_.id_iresa AS id_iresa_1, d0_.code_traduction AS code_traduction_2, d0_.titre_court AS titre_court_3, d0_.titre_long AS titre_long_4, d0_.introduction AS introduction_5, d0_.slug AS slug_6, d0_.etat AS etat_7, d0_.level AS level_8, d0_.meta_title AS meta_title_9, d0_.meta_description AS meta_description_10, d0_.seo_title AS seo_title_11, d0_.seo_content AS seo_content_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14, d0_.is_translated AS is_translated_15, d0_.parent_id AS parent_id_16, d0_.lang_id AS lang_id_17 FROM destination d0_ LEFT JOIN residence r1_ ON (r1_.lieu_id = d0_.id_iresa) LEFT JOIN option_residence o2_ ON r1_.id = o2_.residence_id WHERE d0_.etat = 1 AND d0_.lang_id = ? AND (((o2_.etat = 1 AND o2_.lang_id = ?) OR (o2_.etat IS NULL AND o2_.lang_id IS NULL))) ORDER BY d0_.id ASC
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.id_iresa AS id_iresa_2, t0.code_traduction AS code_traduction_3, t0.nom AS nom_4, t0.description AS description_5, t0.slug AS slug_6, t0.ordre AS ordre_7, t0.titre AS titre_8, t0.etat AS etat_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_translated AS is_translated_12, t0.lang_id AS lang_id_13 FROM theme t0 WHERE t0.lang_id = ? AND t0.etat = ? ORDER BY t0.ordre ASC
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.etat AS etat_3 FROM nomfiche t0
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.idiresa AS idiresa_4, t0.iscontact AS iscontact_5, t0.taux AS taux_6, t0.prefixetarif AS prefixetarif_7, t0.suffixetarif AS suffixetarif_8, t0.lieu_id AS lieu_id_9, t0.commercialisation AS commercialisation_10, t0.etat AS etat_11, t0.destination_idiresa AS destination_idiresa_12, t0.depot_id AS depot_id_13, t0.etefr_id AS etefr_id_14, t0.eteen_id AS eteen_id_15, t0.hiverfr_id AS hiverfr_id_16, t0.hiveren_id AS hiveren_id_17, t0.saisonfr_id AS saisonfr_id_18, t0.saisonen_id AS saisonen_id_19 FROM residence t0 WHERE t0.idiresa = ? LIMIT 1
SELECT t0.id AS id_1, t0.res_lieu AS res_lieu_2, t0.picto_theme AS picto_theme_3, t0.info_adress AS info_adress_4, t0.info_gps AS info_gps_5, t0.info_gmap AS info_gmap_6, t0.seo_title AS seo_title_7, t0.seo_desc AS seo_desc_8, t0.res_bigdesc AS res_bigdesc_9, t0.plus_infos_residence AS plus_infos_residence_10, t0.res_shortdesc AS res_shortdesc_11, t0.ouverture AS ouverture_12, t0.plus AS plus_13, t0.plus_family AS plus_family_14, t0.plus_bienetre AS plus_bienetre_15, t0.plus_mention AS plus_mention_16, t0.info_car AS info_car_17, t0.info_plane AS info_plane_18, t0.info_train AS info_train_19, t0.info_check_in AS info_check_in_20, t0.info_check_out AS info_check_out_21, t0.info_reception AS info_reception_22, t0.info_pool AS info_pool_23, t0.info_taxanddeposit AS info_taxanddeposit_24, t0.logo1_name AS logo1_name_25, t0.logo1_title AS logo1_title_26, t0.logo2_name AS logo2_name_27, t0.logo2_title AS logo2_title_28, t0.info_cancel AS info_cancel_29, t0.info_discover AS info_discover_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.is_translated AS is_translated_33, t0.residence_id AS residence_id_34, t0.lang_id AS lang_id_35 FROM infos_residence t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.id_iresa AS id_iresa_3, t0.photo_profil AS photo_profil_4, t0.description_popin AS description_popin_5, t0.photo_popin AS photo_popin_6, t0.service_inc AS service_inc_7, t0.service_noinc AS service_noinc_8, t0.presta_inc AS presta_inc_9, t0.presta_noinc AS presta_noinc_10, t0.nom AS nom_11, t0.description AS description_12, t0.picto AS picto_13, t0.suffixe AS suffixe_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.residence_id AS residence_id_18, t0.lang_id AS lang_id_19 FROM infos_formule_base t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.commercialisation = ?
SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.id_iresa = ? AND t0.residence_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.id_iresa = ? AND t0.residence_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.idiresa AS idiresa_3, t0.code_traduction AS code_traduction_4, t0.cap_min AS cap_min_5, t0.cap_max AS cap_max_6, t0.pax_max AS pax_max_7, t0.pax_min AS pax_min_8, t0.res_personne AS res_personne_9, t0.res_superficie AS res_superficie_10, t0.res_pmr AS res_pmr_11, t0.rub_big_desc AS rub_big_desc_12, t0.mise_avant AS mise_avant_13, t0.mise_avant_desc AS mise_avant_desc_14, t0.commercialisation AS commercialisation_15, t0.etat AS etat_16, t0.info_room AS info_room_17, t0.info_bathroom AS info_bathroom_18, t0.info_exterior AS info_exterior_19, t0.info_clim AS info_clim_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_translated AS is_translated_23, t0.lang_id AS lang_id_24, t0.residence_id AS residence_id_25, t26.id AS id_27, t26.typologie_id AS typologie_id_28, t26.media_id AS media_id_29 FROM typologie t0 LEFT JOIN typologie_media t26 ON t26.typologie_id = t0.id WHERE t0.lang_id = ? AND t0.idiresa = ? LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.idiresa AS idiresa_3, t0.code_traduction AS code_traduction_4, t0.cap_min AS cap_min_5, t0.cap_max AS cap_max_6, t0.pax_max AS pax_max_7, t0.pax_min AS pax_min_8, t0.res_personne AS res_personne_9, t0.res_superficie AS res_superficie_10, t0.res_pmr AS res_pmr_11, t0.rub_big_desc AS rub_big_desc_12, t0.mise_avant AS mise_avant_13, t0.mise_avant_desc AS mise_avant_desc_14, t0.commercialisation AS commercialisation_15, t0.etat AS etat_16, t0.info_room AS info_room_17, t0.info_bathroom AS info_bathroom_18, t0.info_exterior AS info_exterior_19, t0.info_clim AS info_clim_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_translated AS is_translated_23, t0.lang_id AS lang_id_24, t0.residence_id AS residence_id_25, t26.id AS id_27, t26.typologie_id AS typologie_id_28, t26.media_id AS media_id_29 FROM typologie t0 LEFT JOIN typologie_media t26 ON t26.typologie_id = t0.id WHERE t0.lang_id = ? AND t0.idiresa = ? 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_.commercialisation = 1 AND o1_.etat = 1 AND o1_.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

#▲	Time	Info
1	0.46 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: [`"en"`] 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 = 'en' LIMIT 1;
2	0.11 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;
3	0.09 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: [`"en"`] 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 = 'en' LIMIT 1;
4	0.08 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.11 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.idiresa AS idiresa_4, t0.iscontact AS iscontact_5, t0.taux AS taux_6, t0.prefixetarif AS prefixetarif_7, t0.suffixetarif AS suffixetarif_8, t0.lieu_id AS lieu_id_9, t0.commercialisation AS commercialisation_10, t0.etat AS etat_11, t0.destination_idiresa AS destination_idiresa_12, t0.depot_id AS depot_id_13, t0.etefr_id AS etefr_id_14, t0.eteen_id AS eteen_id_15, t0.hiverfr_id AS hiverfr_id_16, t0.hiveren_id AS hiveren_id_17, t0.saisonfr_id AS saisonfr_id_18, t0.saisonen_id AS saisonen_id_19 FROM residence t0 WHERE t0.idiresa = ? LIMIT 1 Parameters: [`"122"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.idiresa AS idiresa_4, t0.iscontact AS iscontact_5, t0.taux AS taux_6, t0.prefixetarif AS prefixetarif_7, t0.suffixetarif AS suffixetarif_8, t0.lieu_id AS lieu_id_9, t0.commercialisation AS commercialisation_10, t0.etat AS etat_11, t0.destination_idiresa AS destination_idiresa_12, t0.depot_id AS depot_id_13, t0.etefr_id AS etefr_id_14, t0.eteen_id AS eteen_id_15, t0.hiverfr_id AS hiverfr_id_16, t0.hiveren_id AS hiveren_id_17, t0.saisonfr_id AS saisonfr_id_18, t0.saisonen_id AS saisonen_id_19 FROM residence t0 WHERE t0.idiresa = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.idiresa AS idiresa_4, t0.iscontact AS iscontact_5, t0.taux AS taux_6, t0.prefixetarif AS prefixetarif_7, t0.suffixetarif AS suffixetarif_8, t0.lieu_id AS lieu_id_9, t0.commercialisation AS commercialisation_10, t0.etat AS etat_11, t0.destination_idiresa AS destination_idiresa_12, t0.depot_id AS depot_id_13, t0.etefr_id AS etefr_id_14, t0.eteen_id AS eteen_id_15, t0.hiverfr_id AS hiverfr_id_16, t0.hiveren_id AS hiveren_id_17, t0.saisonfr_id AS saisonfr_id_18, t0.saisonen_id AS saisonen_id_19 FROM residence t0 WHERE t0.idiresa = '122' LIMIT 1;
6	0.17 ms	SELECT t0.id AS id_1, t0.res_lieu AS res_lieu_2, t0.picto_theme AS picto_theme_3, t0.info_adress AS info_adress_4, t0.info_gps AS info_gps_5, t0.info_gmap AS info_gmap_6, t0.seo_title AS seo_title_7, t0.seo_desc AS seo_desc_8, t0.res_bigdesc AS res_bigdesc_9, t0.plus_infos_residence AS plus_infos_residence_10, t0.res_shortdesc AS res_shortdesc_11, t0.ouverture AS ouverture_12, t0.plus AS plus_13, t0.plus_family AS plus_family_14, t0.plus_bienetre AS plus_bienetre_15, t0.plus_mention AS plus_mention_16, t0.info_car AS info_car_17, t0.info_plane AS info_plane_18, t0.info_train AS info_train_19, t0.info_check_in AS info_check_in_20, t0.info_check_out AS info_check_out_21, t0.info_reception AS info_reception_22, t0.info_pool AS info_pool_23, t0.info_taxanddeposit AS info_taxanddeposit_24, t0.logo1_name AS logo1_name_25, t0.logo1_title AS logo1_title_26, t0.logo2_name AS logo2_name_27, t0.logo2_title AS logo2_title_28, t0.info_cancel AS info_cancel_29, t0.info_discover AS info_discover_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.is_translated AS is_translated_33, t0.residence_id AS residence_id_34, t0.lang_id AS lang_id_35 FROM infos_residence t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1 Parameters: [`2 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.res_lieu AS res_lieu_2, t0.picto_theme AS picto_theme_3, t0.info_adress AS info_adress_4, t0.info_gps AS info_gps_5, t0.info_gmap AS info_gmap_6, t0.seo_title AS seo_title_7, t0.seo_desc AS seo_desc_8, t0.res_bigdesc AS res_bigdesc_9, t0.plus_infos_residence AS plus_infos_residence_10, t0.res_shortdesc AS res_shortdesc_11, t0.ouverture AS ouverture_12, t0.plus AS plus_13, t0.plus_family AS plus_family_14, t0.plus_bienetre AS plus_bienetre_15, t0.plus_mention AS plus_mention_16, t0.info_car AS info_car_17, t0.info_plane AS info_plane_18, t0.info_train AS info_train_19, t0.info_check_in AS info_check_in_20, t0.info_check_out AS info_check_out_21, t0.info_reception AS info_reception_22, t0.info_pool AS info_pool_23, t0.info_taxanddeposit AS info_taxanddeposit_24, t0.logo1_name AS logo1_name_25, t0.logo1_title AS logo1_title_26, t0.logo2_name AS logo2_name_27, t0.logo2_title AS logo2_title_28, t0.info_cancel AS info_cancel_29, t0.info_discover AS info_discover_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.is_translated AS is_translated_33, t0.residence_id AS residence_id_34, t0.lang_id AS lang_id_35 FROM infos_residence t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.res_lieu AS res_lieu_2, t0.picto_theme AS picto_theme_3, t0.info_adress AS info_adress_4, t0.info_gps AS info_gps_5, t0.info_gmap AS info_gmap_6, t0.seo_title AS seo_title_7, t0.seo_desc AS seo_desc_8, t0.res_bigdesc AS res_bigdesc_9, t0.plus_infos_residence AS plus_infos_residence_10, t0.res_shortdesc AS res_shortdesc_11, t0.ouverture AS ouverture_12, t0.plus AS plus_13, t0.plus_family AS plus_family_14, t0.plus_bienetre AS plus_bienetre_15, t0.plus_mention AS plus_mention_16, t0.info_car AS info_car_17, t0.info_plane AS info_plane_18, t0.info_train AS info_train_19, t0.info_check_in AS info_check_in_20, t0.info_check_out AS info_check_out_21, t0.info_reception AS info_reception_22, t0.info_pool AS info_pool_23, t0.info_taxanddeposit AS info_taxanddeposit_24, t0.logo1_name AS logo1_name_25, t0.logo1_title AS logo1_title_26, t0.logo2_name AS logo2_name_27, t0.logo2_title AS logo2_title_28, t0.info_cancel AS info_cancel_29, t0.info_discover AS info_discover_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.is_translated AS is_translated_33, t0.residence_id AS residence_id_34, t0.lang_id AS lang_id_35 FROM infos_residence t0 WHERE t0.lang_id = 2 AND t0.residence_id = 80 LIMIT 1;
7	0.11 ms	SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.etat = ? Parameters: [`2 80 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.etat = ? SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = 2 AND t0.residence_id = 80 AND t0.etat = 1;
8	0.11 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.id_iresa AS id_iresa_3, t0.photo_profil AS photo_profil_4, t0.description_popin AS description_popin_5, t0.photo_popin AS photo_popin_6, t0.service_inc AS service_inc_7, t0.service_noinc AS service_noinc_8, t0.presta_inc AS presta_inc_9, t0.presta_noinc AS presta_noinc_10, t0.nom AS nom_11, t0.description AS description_12, t0.picto AS picto_13, t0.suffixe AS suffixe_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.residence_id AS residence_id_18, t0.lang_id AS lang_id_19 FROM infos_formule_base t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1 Parameters: [`2 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.id_iresa AS id_iresa_3, t0.photo_profil AS photo_profil_4, t0.description_popin AS description_popin_5, t0.photo_popin AS photo_popin_6, t0.service_inc AS service_inc_7, t0.service_noinc AS service_noinc_8, t0.presta_inc AS presta_inc_9, t0.presta_noinc AS presta_noinc_10, t0.nom AS nom_11, t0.description AS description_12, t0.picto AS picto_13, t0.suffixe AS suffixe_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.residence_id AS residence_id_18, t0.lang_id AS lang_id_19 FROM infos_formule_base t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.id_iresa AS id_iresa_3, t0.photo_profil AS photo_profil_4, t0.description_popin AS description_popin_5, t0.photo_popin AS photo_popin_6, t0.service_inc AS service_inc_7, t0.service_noinc AS service_noinc_8, t0.presta_inc AS presta_inc_9, t0.presta_noinc AS presta_noinc_10, t0.nom AS nom_11, t0.description AS description_12, t0.picto AS picto_13, t0.suffixe AS suffixe_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.residence_id AS residence_id_18, t0.lang_id AS lang_id_19 FROM infos_formule_base t0 WHERE t0.lang_id = 2 AND t0.residence_id = 80 LIMIT 1;
9	0.13 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.idiresa AS idiresa_3, t0.code_traduction AS code_traduction_4, t0.cap_min AS cap_min_5, t0.cap_max AS cap_max_6, t0.pax_max AS pax_max_7, t0.pax_min AS pax_min_8, t0.res_personne AS res_personne_9, t0.res_superficie AS res_superficie_10, t0.res_pmr AS res_pmr_11, t0.rub_big_desc AS rub_big_desc_12, t0.mise_avant AS mise_avant_13, t0.mise_avant_desc AS mise_avant_desc_14, t0.commercialisation AS commercialisation_15, t0.etat AS etat_16, t0.info_room AS info_room_17, t0.info_bathroom AS info_bathroom_18, t0.info_exterior AS info_exterior_19, t0.info_clim AS info_clim_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_translated AS is_translated_23, t0.lang_id AS lang_id_24, t0.residence_id AS residence_id_25, t26.id AS id_27, t26.typologie_id AS typologie_id_28, t26.media_id AS media_id_29 FROM typologie t0 LEFT JOIN typologie_media t26 ON t26.typologie_id = t0.id WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.etat = ? Parameters: [`2 80 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.idiresa AS idiresa_3, t0.code_traduction AS code_traduction_4, t0.cap_min AS cap_min_5, t0.cap_max AS cap_max_6, t0.pax_max AS pax_max_7, t0.pax_min AS pax_min_8, t0.res_personne AS res_personne_9, t0.res_superficie AS res_superficie_10, t0.res_pmr AS res_pmr_11, t0.rub_big_desc AS rub_big_desc_12, t0.mise_avant AS mise_avant_13, t0.mise_avant_desc AS mise_avant_desc_14, t0.commercialisation AS commercialisation_15, t0.etat AS etat_16, t0.info_room AS info_room_17, t0.info_bathroom AS info_bathroom_18, t0.info_exterior AS info_exterior_19, t0.info_clim AS info_clim_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_translated AS is_translated_23, t0.lang_id AS lang_id_24, t0.residence_id AS residence_id_25, t26.id AS id_27, t26.typologie_id AS typologie_id_28, t26.media_id AS media_id_29 FROM typologie t0 LEFT JOIN typologie_media t26 ON t26.typologie_id = t0.id WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.etat = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.idiresa AS idiresa_3, t0.code_traduction AS code_traduction_4, t0.cap_min AS cap_min_5, t0.cap_max AS cap_max_6, t0.pax_max AS pax_max_7, t0.pax_min AS pax_min_8, t0.res_personne AS res_personne_9, t0.res_superficie AS res_superficie_10, t0.res_pmr AS res_pmr_11, t0.rub_big_desc AS rub_big_desc_12, t0.mise_avant AS mise_avant_13, t0.mise_avant_desc AS mise_avant_desc_14, t0.commercialisation AS commercialisation_15, t0.etat AS etat_16, t0.info_room AS info_room_17, t0.info_bathroom AS info_bathroom_18, t0.info_exterior AS info_exterior_19, t0.info_clim AS info_clim_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_translated AS is_translated_23, t0.lang_id AS lang_id_24, t0.residence_id AS residence_id_25, t26.id AS id_27, t26.typologie_id AS typologie_id_28, t26.media_id AS media_id_29 FROM typologie t0 LEFT JOIN typologie_media t26 ON t26.typologie_id = t0.id WHERE t0.lang_id = 2 AND t0.residence_id = 80 AND t0.etat = 1;
10	0.10 ms	SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.text AS text_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_translated AS is_translated_7, t0.residence_id AS residence_id_8, t0.lang_id AS lang_id_9 FROM infos_discover t0 WHERE t0.lang_id = ? AND t0.residence_id = ? Parameters: [`2 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.text AS text_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_translated AS is_translated_7, t0.residence_id AS residence_id_8, t0.lang_id AS lang_id_9 FROM infos_discover t0 WHERE t0.lang_id = ? AND t0.residence_id = ? SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.text AS text_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_translated AS is_translated_7, t0.residence_id AS residence_id_8, t0.lang_id AS lang_id_9 FROM infos_discover t0 WHERE t0.lang_id = 2 AND t0.residence_id = 80;
11	0.10 ms	SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.anchor AS anchor_3, t0.link AS link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_translated AS is_translated_7, t0.residence_id AS residence_id_8, t0.lang_id AS lang_id_9 FROM infos_discover_link t0 WHERE t0.lang_id = ? AND t0.residence_id = ? Parameters: [`2 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.anchor AS anchor_3, t0.link AS link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_translated AS is_translated_7, t0.residence_id AS residence_id_8, t0.lang_id AS lang_id_9 FROM infos_discover_link t0 WHERE t0.lang_id = ? AND t0.residence_id = ? SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.anchor AS anchor_3, t0.link AS link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_translated AS is_translated_7, t0.residence_id AS residence_id_8, t0.lang_id AS lang_id_9 FROM infos_discover_link t0 WHERE t0.lang_id = 2 AND t0.residence_id = 80;
12	0.09 ms	SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.anchor AS anchor_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_translated AS is_translated_8, t0.residence_id AS residence_id_9, t0.lang_id AS lang_id_10 FROM infos_event t0 WHERE t0.lang_id = ? AND t0.residence_id = ? Parameters: [`2 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.anchor AS anchor_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_translated AS is_translated_8, t0.residence_id AS residence_id_9, t0.lang_id AS lang_id_10 FROM infos_event t0 WHERE t0.lang_id = ? AND t0.residence_id = ? SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.anchor AS anchor_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_translated AS is_translated_8, t0.residence_id AS residence_id_9, t0.lang_id AS lang_id_10 FROM infos_event t0 WHERE t0.lang_id = 2 AND t0.residence_id = 80;
13	0.09 ms	SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.anchor AS anchor_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_translated AS is_translated_8, t0.residence_id AS residence_id_9, t0.lang_id AS lang_id_10 FROM infos_event t0 WHERE t0.lang_id = ? AND t0.residence_id = ? Parameters: [`1 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.anchor AS anchor_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_translated AS is_translated_8, t0.residence_id AS residence_id_9, t0.lang_id AS lang_id_10 FROM infos_event t0 WHERE t0.lang_id = ? AND t0.residence_id = ? SELECT t0.id AS id_1, t0.code_traduction AS code_traduction_2, t0.title AS title_3, t0.anchor AS anchor_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_translated AS is_translated_8, t0.residence_id AS residence_id_9, t0.lang_id AS lang_id_10 FROM infos_event t0 WHERE t0.lang_id = 1 AND t0.residence_id = 80;
14	0.25 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_.state = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC Parameters: [`80 "header" 1 "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_.state = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 80 AND m0_.location = 'header' AND m0_.state = 1 AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC;
15	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_.state = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC Parameters: [`80 "content" 1 "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_.state = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 80 AND m0_.location = 'content' AND m0_.state = 1 AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC;
16	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_.state = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC Parameters: [`80 "header" 1 "SEASON_2" 2`] 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_.state = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 80 AND m0_.location = 'header' AND m0_.state = 1 AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 2 ORDER BY m0_.id ASC;
17	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_.state = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC Parameters: [`80 "content" 1 "SEASON_2" 2`] 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_.state = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 80 AND m0_.location = 'content' AND m0_.state = 1 AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 2 ORDER BY m0_.id ASC;
18	0.20 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.idiresa AS idiresa_4, t0.iscontact AS iscontact_5, t0.taux AS taux_6, t0.prefixetarif AS prefixetarif_7, t0.suffixetarif AS suffixetarif_8, t0.lieu_id AS lieu_id_9, t0.commercialisation AS commercialisation_10, t0.etat AS etat_11, t0.destination_idiresa AS destination_idiresa_12, t0.depot_id AS depot_id_13, t0.etefr_id AS etefr_id_14, t0.eteen_id AS eteen_id_15, t0.hiverfr_id AS hiverfr_id_16, t0.hiveren_id AS hiveren_id_17, t0.saisonfr_id AS saisonfr_id_18, t0.saisonen_id AS saisonen_id_19 FROM residence t0 WHERE t0.idiresa = ? LIMIT 1 Parameters: [`122`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.idiresa AS idiresa_4, t0.iscontact AS iscontact_5, t0.taux AS taux_6, t0.prefixetarif AS prefixetarif_7, t0.suffixetarif AS suffixetarif_8, t0.lieu_id AS lieu_id_9, t0.commercialisation AS commercialisation_10, t0.etat AS etat_11, t0.destination_idiresa AS destination_idiresa_12, t0.depot_id AS depot_id_13, t0.etefr_id AS etefr_id_14, t0.eteen_id AS eteen_id_15, t0.hiverfr_id AS hiverfr_id_16, t0.hiveren_id AS hiveren_id_17, t0.saisonfr_id AS saisonfr_id_18, t0.saisonen_id AS saisonen_id_19 FROM residence t0 WHERE t0.idiresa = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.idiresa AS idiresa_4, t0.iscontact AS iscontact_5, t0.taux AS taux_6, t0.prefixetarif AS prefixetarif_7, t0.suffixetarif AS suffixetarif_8, t0.lieu_id AS lieu_id_9, t0.commercialisation AS commercialisation_10, t0.etat AS etat_11, t0.destination_idiresa AS destination_idiresa_12, t0.depot_id AS depot_id_13, t0.etefr_id AS etefr_id_14, t0.eteen_id AS eteen_id_15, t0.hiverfr_id AS hiverfr_id_16, t0.hiveren_id AS hiveren_id_17, t0.saisonfr_id AS saisonfr_id_18, t0.saisonen_id AS saisonen_id_19 FROM residence t0 WHERE t0.idiresa = 122 LIMIT 1;
19	0.17 ms	SELECT t0.id AS id_1, t0.res_lieu AS res_lieu_2, t0.picto_theme AS picto_theme_3, t0.info_adress AS info_adress_4, t0.info_gps AS info_gps_5, t0.info_gmap AS info_gmap_6, t0.seo_title AS seo_title_7, t0.seo_desc AS seo_desc_8, t0.res_bigdesc AS res_bigdesc_9, t0.plus_infos_residence AS plus_infos_residence_10, t0.res_shortdesc AS res_shortdesc_11, t0.ouverture AS ouverture_12, t0.plus AS plus_13, t0.plus_family AS plus_family_14, t0.plus_bienetre AS plus_bienetre_15, t0.plus_mention AS plus_mention_16, t0.info_car AS info_car_17, t0.info_plane AS info_plane_18, t0.info_train AS info_train_19, t0.info_check_in AS info_check_in_20, t0.info_check_out AS info_check_out_21, t0.info_reception AS info_reception_22, t0.info_pool AS info_pool_23, t0.info_taxanddeposit AS info_taxanddeposit_24, t0.logo1_name AS logo1_name_25, t0.logo1_title AS logo1_title_26, t0.logo2_name AS logo2_name_27, t0.logo2_title AS logo2_title_28, t0.info_cancel AS info_cancel_29, t0.info_discover AS info_discover_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.is_translated AS is_translated_33, t0.residence_id AS residence_id_34, t0.lang_id AS lang_id_35 FROM infos_residence t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1 Parameters: [`2 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.res_lieu AS res_lieu_2, t0.picto_theme AS picto_theme_3, t0.info_adress AS info_adress_4, t0.info_gps AS info_gps_5, t0.info_gmap AS info_gmap_6, t0.seo_title AS seo_title_7, t0.seo_desc AS seo_desc_8, t0.res_bigdesc AS res_bigdesc_9, t0.plus_infos_residence AS plus_infos_residence_10, t0.res_shortdesc AS res_shortdesc_11, t0.ouverture AS ouverture_12, t0.plus AS plus_13, t0.plus_family AS plus_family_14, t0.plus_bienetre AS plus_bienetre_15, t0.plus_mention AS plus_mention_16, t0.info_car AS info_car_17, t0.info_plane AS info_plane_18, t0.info_train AS info_train_19, t0.info_check_in AS info_check_in_20, t0.info_check_out AS info_check_out_21, t0.info_reception AS info_reception_22, t0.info_pool AS info_pool_23, t0.info_taxanddeposit AS info_taxanddeposit_24, t0.logo1_name AS logo1_name_25, t0.logo1_title AS logo1_title_26, t0.logo2_name AS logo2_name_27, t0.logo2_title AS logo2_title_28, t0.info_cancel AS info_cancel_29, t0.info_discover AS info_discover_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.is_translated AS is_translated_33, t0.residence_id AS residence_id_34, t0.lang_id AS lang_id_35 FROM infos_residence t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.res_lieu AS res_lieu_2, t0.picto_theme AS picto_theme_3, t0.info_adress AS info_adress_4, t0.info_gps AS info_gps_5, t0.info_gmap AS info_gmap_6, t0.seo_title AS seo_title_7, t0.seo_desc AS seo_desc_8, t0.res_bigdesc AS res_bigdesc_9, t0.plus_infos_residence AS plus_infos_residence_10, t0.res_shortdesc AS res_shortdesc_11, t0.ouverture AS ouverture_12, t0.plus AS plus_13, t0.plus_family AS plus_family_14, t0.plus_bienetre AS plus_bienetre_15, t0.plus_mention AS plus_mention_16, t0.info_car AS info_car_17, t0.info_plane AS info_plane_18, t0.info_train AS info_train_19, t0.info_check_in AS info_check_in_20, t0.info_check_out AS info_check_out_21, t0.info_reception AS info_reception_22, t0.info_pool AS info_pool_23, t0.info_taxanddeposit AS info_taxanddeposit_24, t0.logo1_name AS logo1_name_25, t0.logo1_title AS logo1_title_26, t0.logo2_name AS logo2_name_27, t0.logo2_title AS logo2_title_28, t0.info_cancel AS info_cancel_29, t0.info_discover AS info_discover_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.is_translated AS is_translated_33, t0.residence_id AS residence_id_34, t0.lang_id AS lang_id_35 FROM infos_residence t0 WHERE t0.lang_id = 2 AND t0.residence_id = 80 LIMIT 1;
20	0.12 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.id_iresa AS id_iresa_3, t0.photo_profil AS photo_profil_4, t0.description_popin AS description_popin_5, t0.photo_popin AS photo_popin_6, t0.service_inc AS service_inc_7, t0.service_noinc AS service_noinc_8, t0.presta_inc AS presta_inc_9, t0.presta_noinc AS presta_noinc_10, t0.nom AS nom_11, t0.description AS description_12, t0.picto AS picto_13, t0.suffixe AS suffixe_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.residence_id AS residence_id_18, t0.lang_id AS lang_id_19 FROM infos_formule_base t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1 Parameters: [`2 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.id_iresa AS id_iresa_3, t0.photo_profil AS photo_profil_4, t0.description_popin AS description_popin_5, t0.photo_popin AS photo_popin_6, t0.service_inc AS service_inc_7, t0.service_noinc AS service_noinc_8, t0.presta_inc AS presta_inc_9, t0.presta_noinc AS presta_noinc_10, t0.nom AS nom_11, t0.description AS description_12, t0.picto AS picto_13, t0.suffixe AS suffixe_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.residence_id AS residence_id_18, t0.lang_id AS lang_id_19 FROM infos_formule_base t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.id_iresa AS id_iresa_3, t0.photo_profil AS photo_profil_4, t0.description_popin AS description_popin_5, t0.photo_popin AS photo_popin_6, t0.service_inc AS service_inc_7, t0.service_noinc AS service_noinc_8, t0.presta_inc AS presta_inc_9, t0.presta_noinc AS presta_noinc_10, t0.nom AS nom_11, t0.description AS description_12, t0.picto AS picto_13, t0.suffixe AS suffixe_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.residence_id AS residence_id_18, t0.lang_id AS lang_id_19 FROM infos_formule_base t0 WHERE t0.lang_id = 2 AND t0.residence_id = 80 LIMIT 1;
21	0.11 ms	SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.commercialisation = ? Parameters: [`2 80 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.commercialisation = ? SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = 2 AND t0.residence_id = 80 AND t0.commercialisation = 1;
22	0.35 ms	SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.id_iresa = ? AND t0.residence_id = ? LIMIT 1 Parameters: [`2 1232 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.id_iresa = ? AND t0.residence_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = 2 AND t0.id_iresa = 1232 AND t0.residence_id = 80 LIMIT 1;
23	0.27 ms	SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.id_iresa = ? AND t0.residence_id = ? LIMIT 1 Parameters: [`2 1233 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.id_iresa = ? AND t0.residence_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = 2 AND t0.id_iresa = 1233 AND t0.residence_id = 80 LIMIT 1;
24	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: [`"en"`] 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 = 'en' LIMIT 1;
25	0.12 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" 2`] 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 = 2;
26	0.38 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
27	0.19 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
28	0.11 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
29	0.44 ms	SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'ateya_preprod' AND TABLE_NAME = 'migration_versions' ORDER BY ORDINAL_POSITION ASC Parameters: [] View formatted query View runnable query Explain query SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'ateya_preprod' AND TABLE_NAME = 'migration_versions' ORDER BY ORDINAL_POSITION ASC SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'ateya_preprod' AND TABLE_NAME = 'migration_versions' ORDER BY ORDINAL_POSITION ASC;
30	0.10 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
31	0.61 ms	SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /!50116 , c.UPDATE_RULE, c.DELETE_RULE / FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_NAME = 'migration_versions' AND k.TABLE_SCHEMA = 'ateya_preprod' /!50116 AND c.CONSTRAINT_SCHEMA = 'ateya_preprod' /ORDER BY k.ORDINAL_POSITION Parameters: [] View formatted query View runnable query Explain query SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /!50116 , c.UPDATE_RULE, c.DELETE_RULE / FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_NAME = 'migration_versions' AND k.TABLE_SCHEMA = 'ateya_preprod' /!50116 AND c.CONSTRAINT_SCHEMA = 'ateya_preprod' / ORDER BY k.ORDINAL_POSITION SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /!50116 , c.UPDATE_RULE, c.DELETE_RULE / FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_NAME = 'migration_versions' AND k.TABLE_SCHEMA = 'ateya_preprod' /!50116 AND c.CONSTRAINT_SCHEMA = 'ateya_preprod' /ORDER BY k.ORDINAL_POSITION;
32	0.09 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
33	0.15 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'migration_versions' AND TABLE_SCHEMA = 'ateya_preprod' ORDER BY SEQ_IN_INDEX ASC Parameters: [] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'migration_versions' AND TABLE_SCHEMA = 'ateya_preprod' ORDER BY SEQ_IN_INDEX ASC SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'migration_versions' AND TABLE_SCHEMA = 'ateya_preprod' ORDER BY SEQ_IN_INDEX ASC;
34	0.65 ms	SELECT t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'migration_versions' Parameters: [] View formatted query View runnable query Explain query SELECT t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'migration_versions' SELECT t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'migration_versions';
35	0.10 ms	SELECT * FROM migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM migration_versions SELECT * FROM migration_versions;
36	0.16 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
37	0.51 ms	SELECT count(p0_.id) AS sclr_0 FROM promo p0_ WHERE p0_.date_debut >= ? Parameters: [`"2024-11-22 12:58:28"`] View formatted query View runnable query Explain query SELECT count(p0_.id) AS sclr_0 FROM promo p0_ WHERE p0_.date_debut >= ? SELECT count(p0_.id) AS sclr_0 FROM promo p0_ WHERE p0_.date_debut >= '2024-11-22 12:58:28';
38	0.62 ms	SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? AND p0_.date_fin <= ? ORDER BY p0_.prix_total ASC Parameters: [`7 "2024-11-22 12:58:28" "2024-12-06 12:58:28"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? AND p0_.date_fin <= ? ORDER BY p0_.prix_total ASC SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = 7 AND p0_.date_debut >= '2024-11-22 12:58:28' AND p0_.date_fin <= '2024-12-06 12:58:28' ORDER BY p0_.prix_total ASC;
39	0.75 ms	SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree < ? AND p0_.date_debut >= ? ORDER BY p0_.prix_total ASC Parameters: [`7 "2024-11-21 12:58:28"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree < ? AND p0_.date_debut >= ? ORDER BY p0_.prix_total ASC SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree < 7 AND p0_.date_debut >= '2024-11-21 12:58:28' ORDER BY p0_.prix_total ASC;
40	2.17 ms	SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? ORDER BY p0_.prix_total ASC Parameters: [`14 "2024-11-21 12:58:28"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? ORDER BY p0_.prix_total ASC SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = 14 AND p0_.date_debut >= '2024-11-21 12:58:28' ORDER BY p0_.prix_total ASC;
41	0.19 ms	SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? AND p0_.date_fin <= ? ORDER BY p0_.prix_total ASC Parameters: [`7 "2025-07-03 00:00:00" "2025-08-28 00:00:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? AND p0_.date_fin <= ? ORDER BY p0_.prix_total ASC SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = 7 AND p0_.date_debut >= '2025-07-03 00:00:00' AND p0_.date_fin <= '2025-08-28 00:00:00' ORDER BY p0_.prix_total ASC;
42	0.21 ms	SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? AND p0_.date_fin <= ? AND p0_.environnement = ? ORDER BY p0_.prix_total ASC Parameters: [`7 "2024-11-01 00:00:00" "2025-04-30 00:00:00" "montagne"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? AND p0_.date_fin <= ? AND p0_.environnement = ? ORDER BY p0_.prix_total ASC SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = 7 AND p0_.date_debut >= '2024-11-01 00:00:00' AND p0_.date_fin <= '2025-04-30 00:00:00' AND p0_.environnement = 'montagne' ORDER BY p0_.prix_total ASC;
43	0.14 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: [`"en"`] 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 = 'en' LIMIT 1;
44	0.15 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_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`2`] 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_.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_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = 2;
45	0.20 ms	SELECT d0_.id AS id_0, d0_.id_iresa AS id_iresa_1, d0_.code_traduction AS code_traduction_2, d0_.titre_court AS titre_court_3, d0_.titre_long AS titre_long_4, d0_.introduction AS introduction_5, d0_.slug AS slug_6, d0_.etat AS etat_7, d0_.level AS level_8, d0_.meta_title AS meta_title_9, d0_.meta_description AS meta_description_10, d0_.seo_title AS seo_title_11, d0_.seo_content AS seo_content_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14, d0_.is_translated AS is_translated_15, d0_.parent_id AS parent_id_16, d0_.lang_id AS lang_id_17 FROM destination d0_ LEFT JOIN residence r1_ ON (r1_.lieu_id = d0_.id_iresa) LEFT JOIN option_residence o2_ ON r1_.id = o2_.residence_id WHERE d0_.etat = 1 AND d0_.lang_id = ? AND (((o2_.etat = 1 AND o2_.lang_id = ?) OR (o2_.etat IS NULL AND o2_.lang_id IS NULL))) ORDER BY d0_.id ASC Parameters: [`2 2`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.id_iresa AS id_iresa_1, d0_.code_traduction AS code_traduction_2, d0_.titre_court AS titre_court_3, d0_.titre_long AS titre_long_4, d0_.introduction AS introduction_5, d0_.slug AS slug_6, d0_.etat AS etat_7, d0_.level AS level_8, d0_.meta_title AS meta_title_9, d0_.meta_description AS meta_description_10, d0_.seo_title AS seo_title_11, d0_.seo_content AS seo_content_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14, d0_.is_translated AS is_translated_15, d0_.parent_id AS parent_id_16, d0_.lang_id AS lang_id_17 FROM destination d0_ LEFT JOIN residence r1_ ON (r1_.lieu_id = d0_.id_iresa) LEFT JOIN option_residence o2_ ON r1_.id = o2_.residence_id WHERE d0_.etat = 1 AND d0_.lang_id = ? AND ( ( ( o2_.etat = 1 AND o2_.lang_id = ? ) OR ( o2_.etat IS NULL AND o2_.lang_id IS NULL ) ) ) ORDER BY d0_.id ASC SELECT d0_.id AS id_0, d0_.id_iresa AS id_iresa_1, d0_.code_traduction AS code_traduction_2, d0_.titre_court AS titre_court_3, d0_.titre_long AS titre_long_4, d0_.introduction AS introduction_5, d0_.slug AS slug_6, d0_.etat AS etat_7, d0_.level AS level_8, d0_.meta_title AS meta_title_9, d0_.meta_description AS meta_description_10, d0_.seo_title AS seo_title_11, d0_.seo_content AS seo_content_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14, d0_.is_translated AS is_translated_15, d0_.parent_id AS parent_id_16, d0_.lang_id AS lang_id_17 FROM destination d0_ LEFT JOIN residence r1_ ON (r1_.lieu_id = d0_.id_iresa) LEFT JOIN option_residence o2_ ON r1_.id = o2_.residence_id WHERE d0_.etat = 1 AND d0_.lang_id = 2 AND (((o2_.etat = 1 AND o2_.lang_id = 2) OR (o2_.etat IS NULL AND o2_.lang_id IS NULL))) ORDER BY d0_.id ASC;
46	0.15 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: [`"en"`] 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 = 'en' LIMIT 1;
47	0.11 ms	SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.code_traduction AS code_traduction_3, t0.nom AS nom_4, t0.description AS description_5, t0.slug AS slug_6, t0.ordre AS ordre_7, t0.titre AS titre_8, t0.etat AS etat_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_translated AS is_translated_12, t0.lang_id AS lang_id_13 FROM theme t0 WHERE t0.lang_id = ? AND t0.etat = ? ORDER BY t0.ordre ASC Parameters: [`2 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.code_traduction AS code_traduction_3, t0.nom AS nom_4, t0.description AS description_5, t0.slug AS slug_6, t0.ordre AS ordre_7, t0.titre AS titre_8, t0.etat AS etat_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_translated AS is_translated_12, t0.lang_id AS lang_id_13 FROM theme t0 WHERE t0.lang_id = ? AND t0.etat = ? ORDER BY t0.ordre ASC SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.code_traduction AS code_traduction_3, t0.nom AS nom_4, t0.description AS description_5, t0.slug AS slug_6, t0.ordre AS ordre_7, t0.titre AS titre_8, t0.etat AS etat_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_translated AS is_translated_12, t0.lang_id AS lang_id_13 FROM theme t0 WHERE t0.lang_id = 2 AND t0.etat = 1 ORDER BY t0.ordre ASC;
48	0.18 ms	SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.etat AS etat_3 FROM nomfiche t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.etat AS etat_3 FROM nomfiche t0 SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.etat AS etat_3 FROM nomfiche t0;
49	0.12 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: [`"en"`] 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 = 'en' LIMIT 1;
50	0.08 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;
51	0.20 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.idiresa AS idiresa_4, t0.iscontact AS iscontact_5, t0.taux AS taux_6, t0.prefixetarif AS prefixetarif_7, t0.suffixetarif AS suffixetarif_8, t0.lieu_id AS lieu_id_9, t0.commercialisation AS commercialisation_10, t0.etat AS etat_11, t0.destination_idiresa AS destination_idiresa_12, t0.depot_id AS depot_id_13, t0.etefr_id AS etefr_id_14, t0.eteen_id AS eteen_id_15, t0.hiverfr_id AS hiverfr_id_16, t0.hiveren_id AS hiveren_id_17, t0.saisonfr_id AS saisonfr_id_18, t0.saisonen_id AS saisonen_id_19 FROM residence t0 WHERE t0.idiresa = ? LIMIT 1 Parameters: [`"122"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.idiresa AS idiresa_4, t0.iscontact AS iscontact_5, t0.taux AS taux_6, t0.prefixetarif AS prefixetarif_7, t0.suffixetarif AS suffixetarif_8, t0.lieu_id AS lieu_id_9, t0.commercialisation AS commercialisation_10, t0.etat AS etat_11, t0.destination_idiresa AS destination_idiresa_12, t0.depot_id AS depot_id_13, t0.etefr_id AS etefr_id_14, t0.eteen_id AS eteen_id_15, t0.hiverfr_id AS hiverfr_id_16, t0.hiveren_id AS hiveren_id_17, t0.saisonfr_id AS saisonfr_id_18, t0.saisonen_id AS saisonen_id_19 FROM residence t0 WHERE t0.idiresa = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.idiresa AS idiresa_4, t0.iscontact AS iscontact_5, t0.taux AS taux_6, t0.prefixetarif AS prefixetarif_7, t0.suffixetarif AS suffixetarif_8, t0.lieu_id AS lieu_id_9, t0.commercialisation AS commercialisation_10, t0.etat AS etat_11, t0.destination_idiresa AS destination_idiresa_12, t0.depot_id AS depot_id_13, t0.etefr_id AS etefr_id_14, t0.eteen_id AS eteen_id_15, t0.hiverfr_id AS hiverfr_id_16, t0.hiveren_id AS hiveren_id_17, t0.saisonfr_id AS saisonfr_id_18, t0.saisonen_id AS saisonen_id_19 FROM residence t0 WHERE t0.idiresa = '122' LIMIT 1;
52	0.20 ms	SELECT t0.id AS id_1, t0.res_lieu AS res_lieu_2, t0.picto_theme AS picto_theme_3, t0.info_adress AS info_adress_4, t0.info_gps AS info_gps_5, t0.info_gmap AS info_gmap_6, t0.seo_title AS seo_title_7, t0.seo_desc AS seo_desc_8, t0.res_bigdesc AS res_bigdesc_9, t0.plus_infos_residence AS plus_infos_residence_10, t0.res_shortdesc AS res_shortdesc_11, t0.ouverture AS ouverture_12, t0.plus AS plus_13, t0.plus_family AS plus_family_14, t0.plus_bienetre AS plus_bienetre_15, t0.plus_mention AS plus_mention_16, t0.info_car AS info_car_17, t0.info_plane AS info_plane_18, t0.info_train AS info_train_19, t0.info_check_in AS info_check_in_20, t0.info_check_out AS info_check_out_21, t0.info_reception AS info_reception_22, t0.info_pool AS info_pool_23, t0.info_taxanddeposit AS info_taxanddeposit_24, t0.logo1_name AS logo1_name_25, t0.logo1_title AS logo1_title_26, t0.logo2_name AS logo2_name_27, t0.logo2_title AS logo2_title_28, t0.info_cancel AS info_cancel_29, t0.info_discover AS info_discover_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.is_translated AS is_translated_33, t0.residence_id AS residence_id_34, t0.lang_id AS lang_id_35 FROM infos_residence t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1 Parameters: [`2 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.res_lieu AS res_lieu_2, t0.picto_theme AS picto_theme_3, t0.info_adress AS info_adress_4, t0.info_gps AS info_gps_5, t0.info_gmap AS info_gmap_6, t0.seo_title AS seo_title_7, t0.seo_desc AS seo_desc_8, t0.res_bigdesc AS res_bigdesc_9, t0.plus_infos_residence AS plus_infos_residence_10, t0.res_shortdesc AS res_shortdesc_11, t0.ouverture AS ouverture_12, t0.plus AS plus_13, t0.plus_family AS plus_family_14, t0.plus_bienetre AS plus_bienetre_15, t0.plus_mention AS plus_mention_16, t0.info_car AS info_car_17, t0.info_plane AS info_plane_18, t0.info_train AS info_train_19, t0.info_check_in AS info_check_in_20, t0.info_check_out AS info_check_out_21, t0.info_reception AS info_reception_22, t0.info_pool AS info_pool_23, t0.info_taxanddeposit AS info_taxanddeposit_24, t0.logo1_name AS logo1_name_25, t0.logo1_title AS logo1_title_26, t0.logo2_name AS logo2_name_27, t0.logo2_title AS logo2_title_28, t0.info_cancel AS info_cancel_29, t0.info_discover AS info_discover_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.is_translated AS is_translated_33, t0.residence_id AS residence_id_34, t0.lang_id AS lang_id_35 FROM infos_residence t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.res_lieu AS res_lieu_2, t0.picto_theme AS picto_theme_3, t0.info_adress AS info_adress_4, t0.info_gps AS info_gps_5, t0.info_gmap AS info_gmap_6, t0.seo_title AS seo_title_7, t0.seo_desc AS seo_desc_8, t0.res_bigdesc AS res_bigdesc_9, t0.plus_infos_residence AS plus_infos_residence_10, t0.res_shortdesc AS res_shortdesc_11, t0.ouverture AS ouverture_12, t0.plus AS plus_13, t0.plus_family AS plus_family_14, t0.plus_bienetre AS plus_bienetre_15, t0.plus_mention AS plus_mention_16, t0.info_car AS info_car_17, t0.info_plane AS info_plane_18, t0.info_train AS info_train_19, t0.info_check_in AS info_check_in_20, t0.info_check_out AS info_check_out_21, t0.info_reception AS info_reception_22, t0.info_pool AS info_pool_23, t0.info_taxanddeposit AS info_taxanddeposit_24, t0.logo1_name AS logo1_name_25, t0.logo1_title AS logo1_title_26, t0.logo2_name AS logo2_name_27, t0.logo2_title AS logo2_title_28, t0.info_cancel AS info_cancel_29, t0.info_discover AS info_discover_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.is_translated AS is_translated_33, t0.residence_id AS residence_id_34, t0.lang_id AS lang_id_35 FROM infos_residence t0 WHERE t0.lang_id = 2 AND t0.residence_id = 80 LIMIT 1;
53	0.16 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.id_iresa AS id_iresa_3, t0.photo_profil AS photo_profil_4, t0.description_popin AS description_popin_5, t0.photo_popin AS photo_popin_6, t0.service_inc AS service_inc_7, t0.service_noinc AS service_noinc_8, t0.presta_inc AS presta_inc_9, t0.presta_noinc AS presta_noinc_10, t0.nom AS nom_11, t0.description AS description_12, t0.picto AS picto_13, t0.suffixe AS suffixe_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.residence_id AS residence_id_18, t0.lang_id AS lang_id_19 FROM infos_formule_base t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1 Parameters: [`2 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.id_iresa AS id_iresa_3, t0.photo_profil AS photo_profil_4, t0.description_popin AS description_popin_5, t0.photo_popin AS photo_popin_6, t0.service_inc AS service_inc_7, t0.service_noinc AS service_noinc_8, t0.presta_inc AS presta_inc_9, t0.presta_noinc AS presta_noinc_10, t0.nom AS nom_11, t0.description AS description_12, t0.picto AS picto_13, t0.suffixe AS suffixe_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.residence_id AS residence_id_18, t0.lang_id AS lang_id_19 FROM infos_formule_base t0 WHERE t0.lang_id = ? AND t0.residence_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.id_iresa AS id_iresa_3, t0.photo_profil AS photo_profil_4, t0.description_popin AS description_popin_5, t0.photo_popin AS photo_popin_6, t0.service_inc AS service_inc_7, t0.service_noinc AS service_noinc_8, t0.presta_inc AS presta_inc_9, t0.presta_noinc AS presta_noinc_10, t0.nom AS nom_11, t0.description AS description_12, t0.picto AS picto_13, t0.suffixe AS suffixe_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.residence_id AS residence_id_18, t0.lang_id AS lang_id_19 FROM infos_formule_base t0 WHERE t0.lang_id = 2 AND t0.residence_id = 80 LIMIT 1;
54	0.17 ms	SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.commercialisation = ? Parameters: [`2 80 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.residence_id = ? AND t0.commercialisation = ? SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = 2 AND t0.residence_id = 80 AND t0.commercialisation = 1;
55	0.17 ms	SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.id_iresa = ? AND t0.residence_id = ? LIMIT 1 Parameters: [`2 1232 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.id_iresa = ? AND t0.residence_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = 2 AND t0.id_iresa = 1232 AND t0.residence_id = 80 LIMIT 1;
56	0.16 ms	SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.id_iresa = ? AND t0.residence_id = ? LIMIT 1 Parameters: [`2 1233 80`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = ? AND t0.id_iresa = ? AND t0.residence_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.type AS type_3, t0.nom AS nom_4, t0.description AS description_5, t0.service_inc AS service_inc_6, t0.service_noinc AS service_noinc_7, t0.picto AS picto_8, t0.photo_profil AS photo_profil_9, t0.description_popin AS description_popin_10, t0.photo_popin AS photo_popin_11, t0.suffixe AS suffixe_12, t0.fiche AS fiche_13, t0.commercialisation AS commercialisation_14, t0.etat AS etat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_translated AS is_translated_18, t0.residence_id AS residence_id_19, t0.lang_id AS lang_id_20 FROM package t0 WHERE t0.lang_id = 2 AND t0.id_iresa = 1233 AND t0.residence_id = 80 LIMIT 1;
57	0.17 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.idiresa AS idiresa_3, t0.code_traduction AS code_traduction_4, t0.cap_min AS cap_min_5, t0.cap_max AS cap_max_6, t0.pax_max AS pax_max_7, t0.pax_min AS pax_min_8, t0.res_personne AS res_personne_9, t0.res_superficie AS res_superficie_10, t0.res_pmr AS res_pmr_11, t0.rub_big_desc AS rub_big_desc_12, t0.mise_avant AS mise_avant_13, t0.mise_avant_desc AS mise_avant_desc_14, t0.commercialisation AS commercialisation_15, t0.etat AS etat_16, t0.info_room AS info_room_17, t0.info_bathroom AS info_bathroom_18, t0.info_exterior AS info_exterior_19, t0.info_clim AS info_clim_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_translated AS is_translated_23, t0.lang_id AS lang_id_24, t0.residence_id AS residence_id_25, t26.id AS id_27, t26.typologie_id AS typologie_id_28, t26.media_id AS media_id_29 FROM typologie t0 LEFT JOIN typologie_media t26 ON t26.typologie_id = t0.id WHERE t0.lang_id = ? AND t0.idiresa = ? LIMIT 1 Parameters: [`2 1232`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.idiresa AS idiresa_3, t0.code_traduction AS code_traduction_4, t0.cap_min AS cap_min_5, t0.cap_max AS cap_max_6, t0.pax_max AS pax_max_7, t0.pax_min AS pax_min_8, t0.res_personne AS res_personne_9, t0.res_superficie AS res_superficie_10, t0.res_pmr AS res_pmr_11, t0.rub_big_desc AS rub_big_desc_12, t0.mise_avant AS mise_avant_13, t0.mise_avant_desc AS mise_avant_desc_14, t0.commercialisation AS commercialisation_15, t0.etat AS etat_16, t0.info_room AS info_room_17, t0.info_bathroom AS info_bathroom_18, t0.info_exterior AS info_exterior_19, t0.info_clim AS info_clim_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_translated AS is_translated_23, t0.lang_id AS lang_id_24, t0.residence_id AS residence_id_25, t26.id AS id_27, t26.typologie_id AS typologie_id_28, t26.media_id AS media_id_29 FROM typologie t0 LEFT JOIN typologie_media t26 ON t26.typologie_id = t0.id WHERE t0.lang_id = ? AND t0.idiresa = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.idiresa AS idiresa_3, t0.code_traduction AS code_traduction_4, t0.cap_min AS cap_min_5, t0.cap_max AS cap_max_6, t0.pax_max AS pax_max_7, t0.pax_min AS pax_min_8, t0.res_personne AS res_personne_9, t0.res_superficie AS res_superficie_10, t0.res_pmr AS res_pmr_11, t0.rub_big_desc AS rub_big_desc_12, t0.mise_avant AS mise_avant_13, t0.mise_avant_desc AS mise_avant_desc_14, t0.commercialisation AS commercialisation_15, t0.etat AS etat_16, t0.info_room AS info_room_17, t0.info_bathroom AS info_bathroom_18, t0.info_exterior AS info_exterior_19, t0.info_clim AS info_clim_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_translated AS is_translated_23, t0.lang_id AS lang_id_24, t0.residence_id AS residence_id_25, t26.id AS id_27, t26.typologie_id AS typologie_id_28, t26.media_id AS media_id_29 FROM typologie t0 LEFT JOIN typologie_media t26 ON t26.typologie_id = t0.id WHERE t0.lang_id = 2 AND t0.idiresa = 1232 LIMIT 1;
58	0.11 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.idiresa AS idiresa_3, t0.code_traduction AS code_traduction_4, t0.cap_min AS cap_min_5, t0.cap_max AS cap_max_6, t0.pax_max AS pax_max_7, t0.pax_min AS pax_min_8, t0.res_personne AS res_personne_9, t0.res_superficie AS res_superficie_10, t0.res_pmr AS res_pmr_11, t0.rub_big_desc AS rub_big_desc_12, t0.mise_avant AS mise_avant_13, t0.mise_avant_desc AS mise_avant_desc_14, t0.commercialisation AS commercialisation_15, t0.etat AS etat_16, t0.info_room AS info_room_17, t0.info_bathroom AS info_bathroom_18, t0.info_exterior AS info_exterior_19, t0.info_clim AS info_clim_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_translated AS is_translated_23, t0.lang_id AS lang_id_24, t0.residence_id AS residence_id_25, t26.id AS id_27, t26.typologie_id AS typologie_id_28, t26.media_id AS media_id_29 FROM typologie t0 LEFT JOIN typologie_media t26 ON t26.typologie_id = t0.id WHERE t0.lang_id = ? AND t0.idiresa = ? LIMIT 1 Parameters: [`2 1233`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.idiresa AS idiresa_3, t0.code_traduction AS code_traduction_4, t0.cap_min AS cap_min_5, t0.cap_max AS cap_max_6, t0.pax_max AS pax_max_7, t0.pax_min AS pax_min_8, t0.res_personne AS res_personne_9, t0.res_superficie AS res_superficie_10, t0.res_pmr AS res_pmr_11, t0.rub_big_desc AS rub_big_desc_12, t0.mise_avant AS mise_avant_13, t0.mise_avant_desc AS mise_avant_desc_14, t0.commercialisation AS commercialisation_15, t0.etat AS etat_16, t0.info_room AS info_room_17, t0.info_bathroom AS info_bathroom_18, t0.info_exterior AS info_exterior_19, t0.info_clim AS info_clim_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_translated AS is_translated_23, t0.lang_id AS lang_id_24, t0.residence_id AS residence_id_25, t26.id AS id_27, t26.typologie_id AS typologie_id_28, t26.media_id AS media_id_29 FROM typologie t0 LEFT JOIN typologie_media t26 ON t26.typologie_id = t0.id WHERE t0.lang_id = ? AND t0.idiresa = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.idiresa AS idiresa_3, t0.code_traduction AS code_traduction_4, t0.cap_min AS cap_min_5, t0.cap_max AS cap_max_6, t0.pax_max AS pax_max_7, t0.pax_min AS pax_min_8, t0.res_personne AS res_personne_9, t0.res_superficie AS res_superficie_10, t0.res_pmr AS res_pmr_11, t0.rub_big_desc AS rub_big_desc_12, t0.mise_avant AS mise_avant_13, t0.mise_avant_desc AS mise_avant_desc_14, t0.commercialisation AS commercialisation_15, t0.etat AS etat_16, t0.info_room AS info_room_17, t0.info_bathroom AS info_bathroom_18, t0.info_exterior AS info_exterior_19, t0.info_clim AS info_clim_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_translated AS is_translated_23, t0.lang_id AS lang_id_24, t0.residence_id AS residence_id_25, t26.id AS id_27, t26.typologie_id AS typologie_id_28, t26.media_id AS media_id_29 FROM typologie t0 LEFT JOIN typologie_media t26 ON t26.typologie_id = t0.id WHERE t0.lang_id = 2 AND t0.idiresa = 1233 LIMIT 1;
59	0.10 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: [`"en"`] 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 = 'en' LIMIT 1;
60	0.15 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_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = ? Parameters: [`2`] 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_.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_.commercialisation = 1 AND o1_.etat = 1 AND o1_.lang_id = 2;
61	0.13 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: [`"en"`] 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 = 'en' LIMIT 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\Residence	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\OptionResidence	No errors.
App\Entity\TypologieMedia	No errors.
App\Entity\MediaHebergement	No errors.
App\Entity\Page	No errors.
App\Entity\typeoffre	No errors.
App\Entity\dateoffre	No errors.
App\Entity\CatalogOrder	No errors.
App\Entity\echeancier	No errors.
App\Entity\Service	No errors.
App\Entity\Theme	No errors.
App\Entity\slider	No errors.
App\Entity\Catalog	No errors.
App\Entity\Transaction	No errors.
App\Entity\nomfiche	No errors.
App\Entity\Promo	No errors.
App\Entity\Destination	No errors.
App\Entity\miseenavant	No errors.
App\Entity\compte	No errors.
App\Entity\partenaire	No errors.
App\Entity\User	No errors.
App\Entity\pays	No errors.
App\Entity\commande	No errors.
App\Entity\blog	No errors.
App\Entity\InscritNewsletter	No errors.
App\Entity\assurance	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

https://preprod.ateya-vacances.fr/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CDefaultController%253A%253Anewsletter

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping