Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

71 Database Queries

5 Different statements

15.84 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 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 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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.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 m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.etat AS etat_3, p0_.photo_profil AS photo_profil_4, p0_.slug AS slug_5, p0_.code_traduction AS code_traduction_6, p0_.titre_actif AS titre_actif_7, p0_.type AS type_8, p0_.redirection AS redirection_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.is_translated AS is_translated_12, p0_.lang_id AS lang_id_13 FROM page p0_ WHERE p0_.code_traduction = ? AND p0_.lang_id = ?

#▲	Time	Info
1	0.54 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"fr"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = 'fr' LIMIT 1;
2	0.17 ms	SELECT t0.id AS id_1, t0.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	2.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 >= ? ORDER BY p0_.prix_total ASC Parameters: [`14 "2024-11-21 07:23:42"`] 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 07:23:42' ORDER BY p0_.prix_total ASC;
4	0.44 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: [`124`] 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 = 124 LIMIT 1;
5	0.21 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`85 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 85 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
6	0.19 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: [`300`] 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 = 300 LIMIT 1;
7	0.15 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`142 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 142 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
8	0.34 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: [`117`] 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 = 117 LIMIT 1;
9	0.17 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`75 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 75 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
10	0.27 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: [`4`] 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 = 4 LIMIT 1;
11	0.16 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`9 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 9 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
12	0.27 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: [`111`] 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 = 111 LIMIT 1;
13	0.32 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`70 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 70 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
14	0.16 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: [`153`] 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 = 153 LIMIT 1;
15	0.13 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`119 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 119 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
16	0.27 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: [`123`] 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 = 123 LIMIT 1;
17	0.17 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`81 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 81 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
18	0.28 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: [`163`] 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 = 163 LIMIT 1;
19	0.17 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`122 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 122 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
20	0.16 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: [`55`] 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 = 55 LIMIT 1;
21	0.15 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`49 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 49 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
22	0.26 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: [`181`] 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 = 181 LIMIT 1;
23	0.16 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`138 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 138 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
24	0.26 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: [`148`] 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 = 148 LIMIT 1;
25	0.17 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`116 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 116 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
26	0.17 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: [`130`] 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 = 130 LIMIT 1;
27	0.13 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`89 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 89 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
28	0.12 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: [`172`] 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 = 172 LIMIT 1;
29	0.13 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`129 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 129 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
30	0.13 ms	SELECT 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: [`152`] 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 = 152 LIMIT 1;
31	0.12 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`114 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 114 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
32	0.26 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: [`149`] 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 = 149 LIMIT 1;
33	0.27 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`117 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 117 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
34	0.25 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: [`312`] 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 = 312 LIMIT 1;
35	0.17 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`149 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 149 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
36	0.15 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: [`2`] 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 = 2 LIMIT 1;
37	0.15 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`4 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 4 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
38	0.28 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: [`159`] 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 = 159 LIMIT 1;
39	0.12 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`113 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 113 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
40	0.23 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: [`120`] 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 = 120 LIMIT 1;
41	0.13 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`78 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 78 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
42	0.26 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: [`116`] 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 = 116 LIMIT 1;
43	0.15 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`74 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 74 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
44	0.19 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: [`144`] 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 = 144 LIMIT 1;
45	0.16 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`103 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 103 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
46	0.23 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: [`64`] 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 = 64 LIMIT 1;
47	0.15 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`57 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 57 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
48	0.26 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: [`345`] 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 = 345 LIMIT 1;
49	0.12 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`159 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 159 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
50	0.12 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: [`23`] 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 = 23 LIMIT 1;
51	0.13 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`17 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 17 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
52	0.13 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: [`151`] 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 = 151 LIMIT 1;
53	0.26 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`120 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 120 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
54	0.27 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: [`67`] 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 = 67 LIMIT 1;
55	0.15 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`59 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 59 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
56	0.26 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: [`368`] 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 = 368 LIMIT 1;
57	0.13 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`173 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 173 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
58	0.22 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: [`63`] 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 = 63 LIMIT 1;
59	0.12 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`58 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 58 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
60	0.13 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: [`25`] 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 = 25 LIMIT 1;
61	0.12 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`19 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 19 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
62	0.30 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: [`360`] 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 = 360 LIMIT 1;
63	0.13 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`171 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 171 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
64	0.15 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: [`303`] 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 = 303 LIMIT 1;
65	0.13 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`144 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 144 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
66	0.28 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: [`357`] 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 = 357 LIMIT 1;
67	0.13 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`169 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 169 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
68	0.13 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: [`350`] 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 = 350 LIMIT 1;
69	0.12 ms	SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 Parameters: [`160 "content" "SEASON_2" 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND ( m0_.season = ? OR m0_.season IS NULL OR m0_.season = '' ) AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1 SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = 160 AND m0_.location = 'content' AND (m0_.season = 'SEASON_2' OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = 1 ORDER BY m0_.id ASC LIMIT 1;
70	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: [`"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;
71	0.16 ms	SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.etat AS etat_3, p0_.photo_profil AS photo_profil_4, p0_.slug AS slug_5, p0_.code_traduction AS code_traduction_6, p0_.titre_actif AS titre_actif_7, p0_.type AS type_8, p0_.redirection AS redirection_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.is_translated AS is_translated_12, p0_.lang_id AS lang_id_13 FROM page p0_ WHERE p0_.code_traduction = ? AND p0_.lang_id = ? Parameters: [`"19" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.etat AS etat_3, p0_.photo_profil AS photo_profil_4, p0_.slug AS slug_5, p0_.code_traduction AS code_traduction_6, p0_.titre_actif AS titre_actif_7, p0_.type AS type_8, p0_.redirection AS redirection_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.is_translated AS is_translated_12, p0_.lang_id AS lang_id_13 FROM page p0_ WHERE p0_.code_traduction = ? AND p0_.lang_id = ? SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.etat AS etat_3, p0_.photo_profil AS photo_profil_4, p0_.slug AS slug_5, p0_.code_traduction AS code_traduction_6, p0_.titre_actif AS titre_actif_7, p0_.type AS type_8, p0_.redirection AS redirection_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.is_translated AS is_translated_12, p0_.lang_id AS lang_id_13 FROM page p0_ WHERE p0_.code_traduction = '19' AND p0_.lang_id = 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Language	No errors.
App\Entity\media	No errors.
App\Entity\Promo	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\Page	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping