Query Metrics
29
Database Queries
5
Different statements
4.82 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.53 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"en"
]
|
2 | 0.16 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"fr"
]
|
3 | 0.29 ms |
SELECT p0_.id AS id_0, p0_.environnement AS environnement_1, p0_.region AS region_2, p0_.slug_region AS slug_region_3, p0_.lieu AS lieu_4, p0_.departement AS departement_5, p0_.slug_lieu AS slug_lieu_6, p0_.ville AS ville_7, p0_.slug_ville AS slug_ville_8, p0_.nom AS nom_9, p0_.typologie AS typologie_10, p0_.date_debut AS date_debut_11, p0_.date_fin AS date_fin_12, p0_.duree AS duree_13, p0_.id_lieu AS id_lieu_14, p0_.id_lieu_hebergement AS id_lieu_hebergement_15, p0_.id_prestation AS id_prestation_16, p0_.id_typologie AS id_typologie_17, p0_.montant_taux_promo AS montant_taux_promo_18, p0_.montant_valeur_promo AS montant_valeur_promo_19, p0_.id_prestation_hebergement AS id_prestation_hebergement_20, p0_.prix_brut AS prix_brut_21, p0_.prix_total AS prix_total_22, p0_.status AS status_23, p0_.date_created AS date_created_24 FROM promo p0_ WHERE p0_.duree = ? AND p0_.date_debut >= ? AND p0_.date_fin <= ? AND p0_.environnement = ? ORDER BY p0_.prix_total ASC
Parameters:
[ 7 "2024-11-01 00:00:00" "2025-04-30 00:00:00" "montagne" ] |
4 | 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:
[
300
]
|
5 | 0.19 ms |
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
Parameters:
[ 142 "content" "SEASON_2" 2 ] |
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:
[
181
]
|
7 | 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:
[ 138 "content" "SEASON_2" 2 ] |
8 | 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:
[
312
]
|
9 | 0.19 ms |
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.name AS name_2, m0_.description AS description_3, m0_.title AS title_4, m0_.state AS state_5, m0_.date_created AS date_created_6, m0_.date_updated AS date_updated_7, m0_.season AS season_8, m0_.residence_id AS residence_id_9, m0_.lang_id AS lang_id_10 FROM media_residence m0_ WHERE m0_.residence_id = ? AND m0_.location = ? AND (m0_.season = ? OR m0_.season IS NULL OR m0_.season = '') AND m0_.lang_id = ? ORDER BY m0_.id ASC LIMIT 1
Parameters:
[ 149 "content" "SEASON_2" 2 ] |
10 | 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:
[
357
]
|
11 | 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" 2 ] |
12 | 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:
[
144
]
|
13 | 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:
[ 103 "content" "SEASON_2" 2 ] |
14 | 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:
[
64
]
|
15 | 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:
[ 57 "content" "SEASON_2" 2 ] |
16 | 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:
[
63
]
|
17 | 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:
[ 58 "content" "SEASON_2" 2 ] |
18 | 0.14 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
]
|
19 | 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" 2 ] |
20 | 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:
[
67
]
|
21 | 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:
[ 59 "content" "SEASON_2" 2 ] |
22 | 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:
[
360
]
|
23 | 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" 2 ] |
24 | 0.33 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:
[
324
]
|
25 | 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:
[ 153 "content" "SEASON_2" 2 ] |
26 | 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:
[
303
]
|
27 | 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:
[ 144 "content" "SEASON_2" 2 ] |
28 | 0.15 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"en"
]
|
29 | 0.13 ms |
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.etat AS etat_3, p0_.photo_profil AS photo_profil_4, p0_.slug AS slug_5, p0_.code_traduction AS code_traduction_6, p0_.titre_actif AS titre_actif_7, p0_.type AS type_8, p0_.redirection AS redirection_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.is_translated AS is_translated_12, p0_.lang_id AS lang_id_13 FROM page p0_ WHERE p0_.code_traduction = ? AND p0_.lang_id = ?
Parameters:
[ "19" 2 ] |
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. |