https://croqvacances.horai-software.com/colonie-de-vacances-surf-camp-ados_280.html

Query Metrics

44 Database Queries
33 Different statements
33.13 ms Query time
13 Invalid entities

Queries

Group similar statements

# Time Info
1 8.03 ms
SELECT t0.id AS id_1, t0.role AS role_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.date AS date_5, t0.url AS url_6, t0.statut AS statut_7 FROM notification t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "/colonie-de-vacances-surf-camp-ados_280.html"
]
2 0.79 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.route AS route_3, s0_.argument AS argument_4, s0_.path AS path_5 FROM seo s0_ WHERE s0_.path = ? ORDER BY s0_.id DESC
Parameters:
[
  "/colonie-de-vacances-surf-camp-ados_280.html"
]
3 1.15 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.activites AS activites_3, s0_.updated_date AS updated_date_4, s0_.hebergement AS hebergement_5, s0_.is_active AS is_active_6, s0_.is_bientot AS is_bientot_7, s0_.is_objectif_zero_co2 AS is_objectif_zero_co2_8, s0_.position AS position_9, s0_.age_min AS age_min_10, s0_.age_max AS age_max_11, s0_.is_sejour_location AS is_sejour_location_12, s0_.is_sejour_court AS is_sejour_court_13, s0_.notre_avis AS notre_avis_14, s0_.tarifs AS tarifs_15, s0_.places_count AS places_count_16, s0_.legacy_id AS legacy_id_17, s0_.intro AS intro_18, s0_.price AS price_19, s0_.duree AS duree_20, s0_.encadrement AS encadrement_21, s0_.nombre AS nombre_22, s0_.duree_integer AS duree_integer_23, s0_.tranport AS tranport_24, s0_.transport AS transport_25, s0_.compris AS compris_26, s0_.noncompris AS noncompris_27, s0_.information_complementaire AS information_complementaire_28, s0_.url AS url_29, s0_.sejour_type AS sejour_type_30, s0_.video_link AS video_link_31, s0_.activites_fiche_sejour AS activites_fiche_sejour_32, s0_.lien_youtube AS lien_youtube_33, s0_.location_id AS location_id_34, s0_.tranche_age1_id AS tranche_age1_id_35, s0_.tranche_age2_id AS tranche_age2_id_36 FROM sejour s0_ WHERE s0_.url = ?
Parameters:
[
  "/colonie-de-vacances-surf-camp-ados_280.html"
]
4 1.76 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.text AS text_2, a0_.link_label AS link_label_3, a0_.link_url AS link_url_4, a0_.alt_attribute AS alt_attribute_5, a0_.creation_date AS creation_date_6, a0_.updated_date AS updated_date_7, a0_.is_active AS is_active_8, a0_.is_une AS is_une_9, a0_.img AS img_10, a0_.legacy_id AS legacy_id_11, a0_.is_blog AS is_blog_12, a0_.type AS type_13, a0_.path AS path_14 FROM article a0_ WHERE a0_.path = ?
Parameters:
[
  "/colonie-de-vacances-surf-camp-ados_280.html"
]
5 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "bannerOnline"
]
6 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "banner"
]
7 0.20 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.is_active = ?
Parameters:
[
  1
]
8 0.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.slug AS slug_5, t0.age AS age_6, t0.is_active AS is_active_7 FROM age t0 WHERE t0.is_active = ? ORDER BY t0.age ASC
Parameters:
[
  1
]
9 1.36 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.slug AS slug_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.flag AS flag_9 FROM country t0 WHERE t0.is_active = ? ORDER BY t0.position ASC, t0.title ASC
Parameters:
[
  1
]
10 1.02 ms
SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.code_gen AS code_gen_2, s0_.date_debut AS date_debut_3, s0_.date_fin AS date_fin_4, s0_.prix AS prix_5, s0_.place_dispo AS place_dispo_6, s0_.media_statut AS media_statut_7, s0_.last_update AS last_update_8, s0_.legacy_id AS legacy_id_9, s0_.override_places_dispos AS override_places_dispos_10, s0_.sejour_id AS sejour_id_11 FROM sejour_session s0_ WHERE s0_.date_debut > ? ORDER BY s0_.date_debut ASC
Parameters:
[
  "2025-10-25 21:23:39"
]
11 0.62 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.activites AS activites_4, t0.updated_date AS updated_date_5, t0.hebergement AS hebergement_6, t0.is_active AS is_active_7, t0.is_bientot AS is_bientot_8, t0.is_objectif_zero_co2 AS is_objectif_zero_co2_9, t0.position AS position_10, t0.age_min AS age_min_11, t0.age_max AS age_max_12, t0.is_sejour_location AS is_sejour_location_13, t0.is_sejour_court AS is_sejour_court_14, t0.notre_avis AS notre_avis_15, t0.tarifs AS tarifs_16, t0.places_count AS places_count_17, t0.legacy_id AS legacy_id_18, t0.intro AS intro_19, t0.price AS price_20, t0.duree AS duree_21, t0.encadrement AS encadrement_22, t0.nombre AS nombre_23, t0.duree_integer AS duree_integer_24, t0.tranport AS tranport_25, t0.transport AS transport_26, t0.compris AS compris_27, t0.noncompris AS noncompris_28, t0.information_complementaire AS information_complementaire_29, t0.url AS url_30, t0.sejour_type AS sejour_type_31, t0.video_link AS video_link_32, t0.activites_fiche_sejour AS activites_fiche_sejour_33, t0.lien_youtube AS lien_youtube_34, t0.location_id AS location_id_35, t0.tranche_age1_id AS tranche_age1_id_36, t0.tranche_age2_id AS tranche_age2_id_37 FROM sejour t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  68
  136
  137
  279
  8
  11
  278
  220
  215
  272
  209
  273
  217
  275
]
12 0.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.bottom_description AS bottom_description_3, t0.top_description AS top_description_4, t0.is_active AS is_active_5, t0.slug AS slug_6 FROM ville_desservie t0 WHERE t0.is_active = ? ORDER BY t0.title ASC
Parameters:
[
  1
]
13 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.allowed_format AS allowed_format_3, t0.type AS type_4, t0.is_mandatory AS is_mandatory_5, t0.is_editable_by_director AS is_editable_by_director_6, t0.has_fill_in_process AS has_fill_in_process_7, t0.has_to_be_returned AS has_to_be_returned_8, t0.has_prio AS has_prio_9, t0.published_in AS published_in_10, t0.modele AS modele_11, t0.fields AS fields_12, t0.is_unique AS is_unique_13, t0.is_deletable AS is_deletable_14, t0.is_espace_parent AS is_espace_parent_15, t0.is_espace_directeur AS is_espace_directeur_16, t0.is_private AS is_private_17, t0.is_factory AS is_factory_18, t0.is_in_admin AS is_in_admin_19, t0.modele_entity AS modele_entity_20, t0.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_21, t0.referent AS referent_22, t0.interval AS interval_23, t0.interaction_template_id AS interaction_template_id_24 FROM media_categorie t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "imageFond"
]
14 1.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.media_categorie_id = ?
Parameters:
[
  40
]
15 1.10 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.is_activite = ? AND t0.is_active = ? ORDER BY t0.title ASC
Parameters:
[
  0
  1
]
16 0.59 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.top_description AS top_description_3, t0.bottom_description AS bottom_description_4, t0.is_active AS is_active_5, t0.legacy_id AS legacy_id_6, t0.slug AS slug_7, t0.is_activite AS is_activite_8 FROM theme t0 WHERE t0.is_activite = ? AND t0.is_active = ? ORDER BY t0.title ASC
Parameters:
[
  1
  1
]
17 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "saisonActuelle"
]
18 0.20 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "ete"
]
19 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "animateurs"
]
20 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "destinations"
]
21 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "themes"
]
22 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "années"
]
23 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "enfants"
]
24 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "colonies"
]
25 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.link_label AS link_label_4, t0.link_url AS link_url_5, t0.alt_attribute AS alt_attribute_6, t0.creation_date AS creation_date_7, t0.updated_date AS updated_date_8, t0.is_active AS is_active_9, t0.is_une AS is_une_10, t0.img AS img_11, t0.legacy_id AS legacy_id_12, t0.is_blog AS is_blog_13, t0.type AS type_14, t0.path AS path_15 FROM article t0 WHERE t0.is_une = ? ORDER BY t0.creation_date DESC LIMIT 1
Parameters:
[
  1
]
26 5.62 ms
SELECT t0.id AS id_1, t0.role AS role_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.date AS date_5, t0.url AS url_6, t0.statut AS statut_7 FROM notification t0 WHERE t0.statut = ? ORDER BY t0.date DESC LIMIT 10
Parameters:
[
  "open"
]
27 0.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.activites AS activites_4, t0.updated_date AS updated_date_5, t0.hebergement AS hebergement_6, t0.is_active AS is_active_7, t0.is_bientot AS is_bientot_8, t0.is_objectif_zero_co2 AS is_objectif_zero_co2_9, t0.position AS position_10, t0.age_min AS age_min_11, t0.age_max AS age_max_12, t0.is_sejour_location AS is_sejour_location_13, t0.is_sejour_court AS is_sejour_court_14, t0.notre_avis AS notre_avis_15, t0.tarifs AS tarifs_16, t0.places_count AS places_count_17, t0.legacy_id AS legacy_id_18, t0.intro AS intro_19, t0.price AS price_20, t0.duree AS duree_21, t0.encadrement AS encadrement_22, t0.nombre AS nombre_23, t0.duree_integer AS duree_integer_24, t0.tranport AS tranport_25, t0.transport AS transport_26, t0.compris AS compris_27, t0.noncompris AS noncompris_28, t0.information_complementaire AS information_complementaire_29, t0.url AS url_30, t0.sejour_type AS sejour_type_31, t0.video_link AS video_link_32, t0.activites_fiche_sejour AS activites_fiche_sejour_33, t0.lien_youtube AS lien_youtube_34, t0.location_id AS location_id_35, t0.tranche_age1_id AS tranche_age1_id_36, t0.tranche_age2_id AS tranche_age2_id_37 FROM sejour t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "280"
]
28 0.41 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.code_gen AS code_gen_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.place_dispo AS place_dispo_7, t0.media_statut AS media_statut_8, t0.last_update AS last_update_9, t0.legacy_id AS legacy_id_10, t0.override_places_dispos AS override_places_dispos_11, t0.sejour_id AS sejour_id_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.activites AS activites_17, t13.updated_date AS updated_date_18, t13.hebergement AS hebergement_19, t13.is_active AS is_active_20, t13.is_bientot AS is_bientot_21, t13.is_objectif_zero_co2 AS is_objectif_zero_co2_22, t13.position AS position_23, t13.age_min AS age_min_24, t13.age_max AS age_max_25, t13.is_sejour_location AS is_sejour_location_26, t13.is_sejour_court AS is_sejour_court_27, t13.notre_avis AS notre_avis_28, t13.tarifs AS tarifs_29, t13.places_count AS places_count_30, t13.legacy_id AS legacy_id_31, t13.intro AS intro_32, t13.price AS price_33, t13.duree AS duree_34, t13.encadrement AS encadrement_35, t13.nombre AS nombre_36, t13.duree_integer AS duree_integer_37, t13.tranport AS tranport_38, t13.transport AS transport_39, t13.compris AS compris_40, t13.noncompris AS noncompris_41, t13.information_complementaire AS information_complementaire_42, t13.url AS url_43, t13.sejour_type AS sejour_type_44, t13.video_link AS video_link_45, t13.activites_fiche_sejour AS activites_fiche_sejour_46, t13.lien_youtube AS lien_youtube_47, t13.location_id AS location_id_48, t13.tranche_age1_id AS tranche_age1_id_49, t13.tranche_age2_id AS tranche_age2_id_50 FROM sejour_session t0 INNER JOIN sejour t13 ON t0.sejour_id = t13.id WHERE t0.sejour_id = ? ORDER BY t0.date_debut ASC
Parameters:
[
  280
]
29 0.44 ms
SELECT t0.id AS id_1, t0.is_goa AS is_goa_2, t0.origin AS origin_3, t0.legacy_id AS legacy_id_4, t0.statut AS statut_5, t0.tranche_age AS tranche_age_6, t0.code AS code_7, t0.created_date AS created_date_8, t0.updated_date AS updated_date_9, t0.enfant_id AS enfant_id_10, t0.parent_id AS parent_id_11, t0.responsable_id AS responsable_id_12, t0.sejour_session_id AS sejour_session_id_13, t14.id AS id_15, t14.code AS code_16, t14.code_gen AS code_gen_17, t14.date_debut AS date_debut_18, t14.date_fin AS date_fin_19, t14.prix AS prix_20, t14.place_dispo AS place_dispo_21, t14.media_statut AS media_statut_22, t14.last_update AS last_update_23, t14.legacy_id AS legacy_id_24, t14.override_places_dispos AS override_places_dispos_25, t14.sejour_id AS sejour_id_26, t0.majoration_transport_aller_id AS majoration_transport_aller_id_27, t0.majoration_transport_retour_id AS majoration_transport_retour_id_28, t0.commande_id AS commande_id_29, t0.enterprise_option_sejour_session_id AS enterprise_option_sejour_session_id_30 FROM inscription t0 INNER JOIN sejour_session t14 ON t0.sejour_session_id = t14.id WHERE t0.sejour_session_id = ?
Parameters:
[
  1148
]
30 0.16 ms
"START TRANSACTION"
Parameters:
[]
31 0.25 ms
UPDATE article SET updated_date = ? WHERE id = ?
Parameters:
[
  "2025-10-25"
  18
]
32 0.12 ms
"COMMIT"
Parameters:
[]
33 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.type AS type_4, t0.parameters AS parameters_5 FROM front_option t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "phrase"
]
34 0.32 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.annee_affichee AS annee_affichee_4, t0.top_description AS top_description_5, t0.bottom_description AS bottom_description_6, t0.is_active AS is_active_7 FROM saison t0 INNER JOIN sejour_saison ON t0.id = sejour_saison.saison_id WHERE sejour_saison.sejour_id = ?
Parameters:
[
  280
]
35 0.44 ms
SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.code_gen AS code_gen_2, s0_.date_debut AS date_debut_3, s0_.date_fin AS date_fin_4, s0_.prix AS prix_5, s0_.place_dispo AS place_dispo_6, s0_.media_statut AS media_statut_7, s0_.last_update AS last_update_8, s0_.legacy_id AS legacy_id_9, s0_.override_places_dispos AS override_places_dispos_10, s0_.sejour_id AS sejour_id_11 FROM sejour_session s0_ LEFT JOIN inscription i1_ ON s0_.id = i1_.sejour_session_id WHERE s0_.date_debut > ? AND s0_.sejour_id = ? AND s0_.place_dispo >= ? GROUP BY s0_.id ORDER BY s0_.date_debut ASC
Parameters:
[
  "2025-10-25 21:23:39"
  280
  0
]
36 0.34 ms
SELECT t0.id AS id_1, t0.nbre_souhaite AS nbre_souhaite_2, t0.nbre_booke AS nbre_booke_3, t0.creation_date AS creation_date_4, t0.end_date AS end_date_5, t0.statut AS statut_6, t0.is_individuel AS is_individuel_7, t0.enterprise_id AS enterprise_id_8, t0.enterprise_request_id AS enterprise_request_id_9, t0.sejour_session_id AS sejour_session_id_10 FROM enterprise_option_sejour_session t0 WHERE t0.sejour_session_id = ?
Parameters:
[
  1148
]
37 1.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.file_path AS file_path_4, t0.attributes AS attributes_5, t0.alt_attribute AS alt_attribute_6, t0.is_standalone AS is_standalone_7, t0.is_migrated AS is_migrated_8, t0.position AS position_9, t0.updated_date AS updated_date_10, t0.legacy_id AS legacy_id_11, t0.is_validated AS is_validated_12, t0.rejected_reason AS rejected_reason_13, t0.media_categorie_id AS media_categorie_id_14, t15.id AS id_16, t15.name AS name_17, t15.allowed_format AS allowed_format_18, t15.type AS type_19, t15.is_mandatory AS is_mandatory_20, t15.is_editable_by_director AS is_editable_by_director_21, t15.has_fill_in_process AS has_fill_in_process_22, t15.has_to_be_returned AS has_to_be_returned_23, t15.has_prio AS has_prio_24, t15.published_in AS published_in_25, t15.modele AS modele_26, t15.fields AS fields_27, t15.is_unique AS is_unique_28, t15.is_deletable AS is_deletable_29, t15.is_espace_parent AS is_espace_parent_30, t15.is_espace_directeur AS is_espace_directeur_31, t15.is_private AS is_private_32, t15.is_factory AS is_factory_33, t15.is_in_admin AS is_in_admin_34, t15.modele_entity AS modele_entity_35, t15.has_to_be_validate_by_admin AS has_to_be_validate_by_admin_36, t15.referent AS referent_37, t15.interval AS interval_38, t15.interaction_template_id AS interaction_template_id_39, t0.media_parent_id AS media_parent_id_40, t41.id AS id_42, t41.name AS name_43, t41.description AS description_44, t41.file_path AS file_path_45, t41.attributes AS attributes_46, t41.alt_attribute AS alt_attribute_47, t41.is_standalone AS is_standalone_48, t41.is_migrated AS is_migrated_49, t41.position AS position_50, t41.updated_date AS updated_date_51, t41.legacy_id AS legacy_id_52, t41.is_validated AS is_validated_53, t41.rejected_reason AS rejected_reason_54, t41.media_categorie_id AS media_categorie_id_55, t41.media_parent_id AS media_parent_id_56, t41.sejour_id AS sejour_id_57, t41.candidature_id AS candidature_id_58, t41.contact_id AS contact_id_59, t41.sejour_session_id AS sejour_session_id_60, t41.inscription_id AS inscription_id_61, t41.saison_id AS saison_id_62, t0.sejour_id AS sejour_id_63, t0.candidature_id AS candidature_id_64, t0.contact_id AS contact_id_65, t0.sejour_session_id AS sejour_session_id_66, t0.inscription_id AS inscription_id_67, t0.saison_id AS saison_id_68 FROM media t0 INNER JOIN media_categorie t15 ON t0.media_categorie_id = t15.id LEFT JOIN media t41 ON t0.media_parent_id = t41.id WHERE t0.sejour_id = ?
Parameters:
[
  280
]
38 0.45 ms
SELECT m0_.id AS id_0, m0_.ville AS ville_1, m0_.price AS price_2, m0_.is_active AS is_active_3, m0_.sejour_id AS sejour_id_4, m0_.saison_id AS saison_id_5 FROM majoration_transport m0_ INNER JOIN sejour_session_majoration_transport s1_ ON m0_.id = s1_.majoration_transport_id WHERE s1_.sejour_session_id = ? AND m0_.is_active = ? AND s1_.direction = ? ORDER BY m0_.ville ASC
Parameters:
[
  null
  1
  "aller"
]
39 0.21 ms
SELECT m0_.id AS id_0, m0_.ville AS ville_1, m0_.price AS price_2, m0_.is_active AS is_active_3, m0_.sejour_id AS sejour_id_4, m0_.saison_id AS saison_id_5 FROM majoration_transport m0_ INNER JOIN sejour_session_majoration_transport s1_ ON m0_.id = s1_.majoration_transport_id WHERE s1_.sejour_session_id = ? AND s1_.is_active = ? AND s1_.direction = ? AND m0_.is_active = ? ORDER BY m0_.ville ASC
Parameters:
[
  null
  1
  "retour"
  1
]
40 0.42 ms
SELECT t0.id AS id_1, t0.min AS min_2, t0.max AS max_3 FROM tranche_age t0 WHERE t0.id = ?
Parameters:
[
  31
]
41 0.23 ms
SELECT t0.id AS id_1, t0.min AS min_2, t0.max AS max_3 FROM tranche_age t0 WHERE t0.id = ?
Parameters:
[
  15
]
42 0.41 ms
SELECT t0.id AS id_1, t0.street AS street_2, t0.zip_code AS zip_code_3, t0.city AS city_4, t0.house_number AS house_number_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.country AS country_8, t0.title AS title_9, t0.telephone AS telephone_10, t11.id AS id_12, t11.title AS title_13, t11.description AS description_14, t11.activites AS activites_15, t11.updated_date AS updated_date_16, t11.hebergement AS hebergement_17, t11.is_active AS is_active_18, t11.is_bientot AS is_bientot_19, t11.is_objectif_zero_co2 AS is_objectif_zero_co2_20, t11.position AS position_21, t11.age_min AS age_min_22, t11.age_max AS age_max_23, t11.is_sejour_location AS is_sejour_location_24, t11.is_sejour_court AS is_sejour_court_25, t11.notre_avis AS notre_avis_26, t11.tarifs AS tarifs_27, t11.places_count AS places_count_28, t11.legacy_id AS legacy_id_29, t11.intro AS intro_30, t11.price AS price_31, t11.duree AS duree_32, t11.encadrement AS encadrement_33, t11.nombre AS nombre_34, t11.duree_integer AS duree_integer_35, t11.tranport AS tranport_36, t11.transport AS transport_37, t11.compris AS compris_38, t11.noncompris AS noncompris_39, t11.information_complementaire AS information_complementaire_40, t11.url AS url_41, t11.sejour_type AS sejour_type_42, t11.video_link AS video_link_43, t11.activites_fiche_sejour AS activites_fiche_sejour_44, t11.lien_youtube AS lien_youtube_45, t11.location_id AS location_id_46, t11.tranche_age1_id AS tranche_age1_id_47, t11.tranche_age2_id AS tranche_age2_id_48, t0.departement_id AS departement_id_49 FROM location t0 LEFT JOIN sejour t11 ON t11.location_id = t0.id WHERE t0.id = ?
Parameters:
[
  72939
]
43 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.country_id AS country_id_4, t0.media_id AS media_id_5 FROM departement t0 WHERE t0.id = ?
Parameters:
[
  86
]
44 0.32 ms
SELECT t0.id AS id_1, t0.ville AS ville_2, t0.price AS price_3, t0.is_active AS is_active_4, t0.sejour_id AS sejour_id_5, t0.saison_id AS saison_id_6 FROM majoration_transport t0 WHERE t0.sejour_id = ? ORDER BY t0.ville ASC
Parameters:
[
  280
]

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\Notification No errors.
App\Entity\Seo No errors.
App\Entity\Sejour
  • The mappings App\Entity\Sejour#countries and App\Entity\Country#sejours are inconsistent with each other.
  • The association App\Entity\Sejour#trancheAges refers to the inverse side field App\Entity\TrancheAge#sejours which does not exist.
  • The mappings App\Entity\Sejour#whitelists and App\Entity\SejourWhitelist#sejour are inconsistent with each other.
App\Entity\Location
  • The mappings App\Entity\Location#contactForFamilleAccueils and App\Entity\Contact#location are inconsistent with each other.
App\Entity\TrancheAge No errors.
App\Entity\SejourSession
  • The mappings App\Entity\SejourSession#sejourSessionMajorationTransports and App\Entity\SejourSessionMajorationTransport#sejourSession are inconsistent with each other.
App\Entity\Theme No errors.
App\Entity\Country No errors.
App\Entity\MajorationTransport
  • The mappings App\Entity\MajorationTransport#sejourSessionMajorationTransports and App\Entity\SejourSessionMajorationTransport#majorationTransport are inconsistent with each other.
App\Entity\SejourEquipier No errors.
App\Entity\Saison No errors.
App\Entity\Media
  • The mappings App\Entity\Media#mediaChildren and App\Entity\Media#mediaParent are inconsistent with each other.
  • The mappings App\Entity\Media#mediaCategorie and App\Entity\MediaCategorie#media are inconsistent with each other.
  • The field App\Entity\Media#mediaParent is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Media#mediaParent does not contain the required 'mappedBy="mediaParent"' attribute.
  • If association App\Entity\Media#mediaParent is many-to-one, then the inversed side App\Entity\Media#mediaParent has to be one-to-many.
App\Entity\Property No errors.
App\Entity\Temoignage No errors.
App\Entity\SejourWhitelist
  • The association App\Entity\SejourWhitelist#user refers to the inverse side field App\Entity\User#sejourwhitelist which does not exist.
  • The association App\Entity\SejourWhitelist#sejour refers to the inverse side field App\Entity\Sejour#sejourwhitelist which does not exist.
App\Entity\Article No errors.
App\Entity\FrontOption No errors.
App\Entity\Age No errors.
App\Entity\Departement No errors.
App\Entity\MessageParent No errors.
App\Entity\Inscription
  • The mappings App\Entity\Inscription#responsable and App\Entity\Contact#inscriptionParents are inconsistent with each other.
  • The mappings App\Entity\Inscription#tiersDeConfiance and App\Entity\TiersDeConfiance#inscription are inconsistent with each other.
App\Entity\Equipier No errors.
App\Entity\SejourSessionEquipier No errors.
App\Entity\SejourSessionMajorationTransport
  • The association App\Entity\SejourSessionMajorationTransport#sejourSession refers to the inverse side field App\Entity\SejourSession#SejourSessionMajorationTransport which does not exist.
  • The association App\Entity\SejourSessionMajorationTransport#majorationTransport refers to the inverse side field App\Entity\MajorationTransport#sejourSessionMajorationTransport which does not exist.
App\Entity\MessageDirecteurAuxParents No errors.
App\Entity\EnterpriseOptionSejourSession No errors.
App\Entity\SejourSessionPicture
  • The association App\Entity\SejourSessionPicture#userValid refers to the inverse side field App\Entity\User#medias which does not exist.
  • The association App\Entity\SejourSessionPicture#userCreated refers to the inverse side field App\Entity\User#medias which does not exist.
App\Entity\VilleDesservie No errors.
App\Entity\MediaCategorie
  • The association App\Entity\MediaCategorie#media refers to the owning side field App\Entity\Media#MediaCategorie which does not exist.
App\Entity\InteractionTemplate No errors.
App\Entity\SejourSessionMediaCategorie
  • The association App\Entity\SejourSessionMediaCategorie#sejourSession refers to the inverse side field App\Entity\SejourSession#sejourSessionMediaCategories which does not exist.
App\Entity\ContactMediaCategorie
  • The association App\Entity\ContactMediaCategorie#contact refers to the inverse side field App\Entity\Contact#contactMediaCategories which does not exist.
App\Entity\ArticleMediaCategorie
  • The association App\Entity\ArticleMediaCategorie#article refers to the inverse side field App\Entity\Article#articleMediaCategories which does not exist.
App\Entity\Candidature No errors.
App\Entity\Contact No errors.
App\Entity\EmailInfo No errors.
App\Entity\Commande No errors.
App\Entity\Enterprise No errors.
App\Entity\EnterpriseRequest No errors.