https://croqvacances.horai-software.com/file/Fiche-Itinerant/695595_periple-en-bretagne

Query Metrics

55 Database Queries
20 Different statements
52.43 ms Query time
16 Invalid entities

Grouped Statements

Show all queries

Time Count Info
13.92 ms
(26.54%)
2
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:
[
  "/file/Fiche-Itinerant/695595_periple-en-bretagne"
]
10.78 ms
(20.56%)
2
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"
]
4.87 ms
(9.29%)
4
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
]
4.32 ms
(8.23%)
18
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"
]
3.57 ms
(6.80%)
2
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:
[
  "/file/Fiche-Itinerant/695595_periple-en-bretagne"
]
2.92 ms
(5.56%)
2
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
]
2.51 ms
(4.79%)
2
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
]
1.56 ms
(2.98%)
2
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:
[
  "/file/Fiche-Itinerant/695595_periple-en-bretagne"
]
1.39 ms
(2.65%)
2
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 13:31:21"
]
1.03 ms
(1.97%)
2
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:
[
  "/file/Fiche-Itinerant/695595_periple-en-bretagne"
]
0.93 ms
(1.78%)
2
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
]
0.91 ms
(1.73%)
1
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "Croq_prod_db"
]
0.58 ms
(1.10%)
2
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
]
0.56 ms
(1.07%)
2
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"
]
0.50 ms
(0.95%)
1
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
]
0.46 ms
(0.87%)
2
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
]
0.44 ms
(0.83%)
1
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.id = ? LIMIT 1
Parameters:
[
  "695595"
]
0.42 ms
(0.81%)
2
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
]
0.41 ms
(0.78%)
2
SELECT DATABASE()
Parameters:
[]
0.37 ms
(0.70%)
2
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"
]

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.
App\Entity\Compta No errors.
App\Entity\TiersDeConfiance
  • The association App\Entity\TiersDeConfiance#inscription refers to the inverse side field App\Entity\Inscription#tiersDeConfiances which does not exist.
App\Entity\Commande No errors.
App\Entity\ContactForFamilleAccueil No errors.
App\Entity\Metier No errors.
App\Entity\EmployeeContract No errors.
App\Entity\Enterprise No errors.
App\Entity\EnterpriseRequest No errors.
App\Entity\User No errors.
App\Entity\ContactPropertyValue No errors.
App\Entity\Job No errors.
App\Entity\ContactComment No errors.
App\Entity\DemandeSejourCorse No errors.
App\Entity\LegacyEmploye No errors.
App\Entity\ReductionRequest No errors.
App\Entity\ComptaType No errors.
App\Entity\Reduction No errors.
App\Entity\ConnexionLog No errors.
App\Entity\ArticlePresse No errors.
App\Entity\Ticket
  • The association App\Entity\Ticket#personneAssocie refers to the inverse side field App\Entity\Contact#ticket which does not exist.
  • The association App\Entity\Ticket#createdBy refers to the inverse side field App\Entity\User#ticket which does not exist.
App\Entity\DemandeRappel No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\ContactRappel No errors.
App\Entity\TicketComment
  • The association App\Entity\TicketComment#user refers to the inverse side field App\Entity\User#TicketComment which does not exist.
App\Entity\Newsletter No errors.
App\Entity\RedirectReponse No errors.
App\Entity\FaqDirecteur No errors.
App\Entity\CroqinfoAbonne No errors.
App\Entity\ReductionItem No errors.
App\Croqvacances\CookieConsentBundle\Entity\Cook2 No errors.
Cron\CronBundle\Entity\CronJob No errors.
Cron\CronBundle\Entity\CronReport No errors.
Vich\UploaderBundle\Entity\File No errors.