https://croqvacances.horai-software.com/actualite-vacances_de_la_toussaint_des_colos_pour_nos_chers_bambins-22.html

Query Metrics

27 Database Queries
18 Different statements
30.91 ms Query time
13 Invalid entities

Queries

Group similar statements

# Time Info
1 11.11 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:
[
  "/actualite-vacances_de_la_toussaint_des_colos_pour_nos_chers_bambins-22.html"
]
2 0.80 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:
[
  "/actualite-vacances_de_la_toussaint_des_colos_pour_nos_chers_bambins-22.html"
]
3 1.16 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:
[
  "/actualite-vacances_de_la_toussaint_des_colos_pour_nos_chers_bambins-22.html"
]
4 1.79 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:
[
  "/actualite-vacances_de_la_toussaint_des_colos_pour_nos_chers_bambins-22.html"
]
5 0.26 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.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:
[
  "banner"
]
7 0.29 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.53 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.09 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.42 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-26 14:50:08"
]
11 0.75 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
  280
  279
  8
  11
  278
  220
  215
  272
  209
  273
  217
  275
]
12 0.52 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.40 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 0.77 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.13 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.58 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.22 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.26 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.20 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.16 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.18 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.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:
[
  "colonies"
]
25 0.38 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.82 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.34 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.id = ? LIMIT 1
Parameters:
[
  "22"
]

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\Article No errors.
App\Entity\FrontOption 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\Age No errors.
App\Entity\Country No errors.
App\Entity\Departement No errors.
App\Entity\SejourSession
  • The mappings App\Entity\SejourSession#sejourSessionMajorationTransports and App\Entity\SejourSessionMajorationTransport#sejourSession are inconsistent with each other.
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\Temoignage 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\Theme 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\Property 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\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.