GET https://recette.espacepro.groupe-nap.com/page/entreprendre_avec_nap

Query Metrics

29 Database Queries
5 Different statements
16.65 ms Query time
1 Invalid entities
52 Managed entities

Grouped Statements

Show all queries

Time Count Info
10.68 ms
(64.15%)
25
SELECT t0.name AS name_1, t0.label AS label_2, t0.section AS section_3, t0.advanced AS advanced_4, t0.active AS active_5, t0.only_shop AS only_shop_6, t0.only_cash_register AS only_cash_register_7, t0.to_initialize AS to_initialize_8, t0.id AS id_9, t0.creator AS creator_10, t0.creation_date AS creation_date_11, t0.last_update_user AS last_update_user_12, t0.update_date AS update_date_13, t0.visible_if_contract AS visible_if_contract_14, t0.visible_if_type AS visible_if_type_15, t0.page_id AS page_id_16 FROM direct_access t0 WHERE t0.page_id = ?
Parameters:
[
  113
]
3.23 ms
(19.38%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.label AS label_2, p0_.route AS route_3, p0_.linked_autoco_service AS linked_autoco_service_4, p0_.linked_service AS linked_service_5, p0_.linked_contact AS linked_contact_6, p0_.type AS type_7, p0_.real_page AS real_page_8, p0_.active AS active_9, p0_.start_date AS start_date_10, p0_.end_date AS end_date_11, p0_.creator AS creator_12, p0_.last_update_user AS last_update_user_13, p0_.creation_date AS creation_date_14, p0_.last_update_date AS last_update_date_15, p0_.menu_position AS menu_position_16, p0_.main_page AS main_page_17, p0_.admin_page AS admin_page_18, p0_.external_link AS external_link_19, p0_.slug AS slug_20, p0_.visible_if_contract AS visible_if_contract_21, p0_.visible_if_type AS visible_if_type_22, p0_.is_showcase AS is_showcase_23, p0_.image AS image_24, p0_.meta_title AS meta_title_25, p0_.meta_description AS meta_description_26, p0_.not_in_cash_register AS not_in_cash_register_27, p1_.id AS id_28, p1_.creator AS creator_29, p1_.last_update_user AS last_update_user_30, p1_.creation_date AS creation_date_31, p1_.last_update_date AS last_update_date_32, p2_.id AS id_33, p2_.name AS name_34, p2_.label AS label_35, p2_.route AS route_36, p2_.linked_autoco_service AS linked_autoco_service_37, p2_.linked_service AS linked_service_38, p2_.linked_contact AS linked_contact_39, p2_.type AS type_40, p2_.real_page AS real_page_41, p2_.active AS active_42, p2_.start_date AS start_date_43, p2_.end_date AS end_date_44, p2_.creator AS creator_45, p2_.last_update_user AS last_update_user_46, p2_.creation_date AS creation_date_47, p2_.last_update_date AS last_update_date_48, p2_.menu_position AS menu_position_49, p2_.main_page AS main_page_50, p2_.admin_page AS admin_page_51, p2_.external_link AS external_link_52, p2_.slug AS slug_53, p2_.visible_if_contract AS visible_if_contract_54, p2_.visible_if_type AS visible_if_type_55, p2_.is_showcase AS is_showcase_56, p2_.image AS image_57, p2_.meta_title AS meta_title_58, p2_.meta_description AS meta_description_59, p2_.not_in_cash_register AS not_in_cash_register_60, p3_.id AS id_61, p3_.creator AS creator_62, p3_.last_update_user AS last_update_user_63, p3_.creation_date AS creation_date_64, p3_.last_update_date AS last_update_date_65, p4_.id AS id_66, p4_.name AS name_67, p4_.label AS label_68, p4_.route AS route_69, p4_.linked_autoco_service AS linked_autoco_service_70, p4_.linked_service AS linked_service_71, p4_.linked_contact AS linked_contact_72, p4_.type AS type_73, p4_.real_page AS real_page_74, p4_.active AS active_75, p4_.start_date AS start_date_76, p4_.end_date AS end_date_77, p4_.creator AS creator_78, p4_.last_update_user AS last_update_user_79, p4_.creation_date AS creation_date_80, p4_.last_update_date AS last_update_date_81, p4_.menu_position AS menu_position_82, p4_.main_page AS main_page_83, p4_.admin_page AS admin_page_84, p4_.external_link AS external_link_85, p4_.slug AS slug_86, p4_.visible_if_contract AS visible_if_contract_87, p4_.visible_if_type AS visible_if_type_88, p4_.is_showcase AS is_showcase_89, p4_.image AS image_90, p4_.meta_title AS meta_title_91, p4_.meta_description AS meta_description_92, p4_.not_in_cash_register AS not_in_cash_register_93, p0_.category_id AS category_id_94, p0_.image_gallery_id AS image_gallery_id_95, p1_.page_parent_id AS page_parent_id_96, p1_.page_child_id AS page_child_id_97, p2_.category_id AS category_id_98, p2_.image_gallery_id AS image_gallery_id_99, p3_.page_parent_id AS page_parent_id_100, p3_.page_child_id AS page_child_id_101, p4_.category_id AS category_id_102, p4_.image_gallery_id AS image_gallery_id_103 FROM page p0_ LEFT JOIN page_in_page p1_ ON p0_.id = p1_.page_parent_id LEFT JOIN page p2_ ON p1_.page_child_id = p2_.id AND (p2_.active = 1 AND ((p2_.start_date < ? AND p2_.end_date > ?) OR (p2_.start_date < ? AND p2_.end_date IS NULL) OR (p2_.start_date IS NULL AND p2_.end_date > ?) OR (p2_.start_date IS NULL AND p2_.end_date IS NULL))) LEFT JOIN page_in_page p3_ ON p2_.id = p3_.page_parent_id LEFT JOIN page p4_ ON p3_.page_child_id = p4_.id AND (p4_.active = 1 AND ((p4_.start_date < ? AND p4_.end_date > ?) OR (p4_.start_date < ? AND p4_.end_date IS NULL) OR (p4_.start_date IS NULL AND p4_.end_date > ?) OR (p4_.start_date IS NULL AND p4_.end_date IS NULL))) WHERE p0_.is_showcase = 1 AND p0_.main_page = 1 ORDER BY p0_.menu_position ASC
Parameters:
[
  "2026-03-12 03:33:30"
  "2026-03-12 03:33:30"
  "2026-03-12 03:33:30"
  "2026-03-12 03:33:30"
  "2026-03-12 03:33:30"
  "2026-03-12 03:33:30"
  "2026-03-12 03:33:30"
  "2026-03-12 03:33:30"
]
1.29 ms
(7.76%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.label AS label_2, p0_.route AS route_3, p0_.linked_autoco_service AS linked_autoco_service_4, p0_.linked_service AS linked_service_5, p0_.linked_contact AS linked_contact_6, p0_.type AS type_7, p0_.real_page AS real_page_8, p0_.active AS active_9, p0_.start_date AS start_date_10, p0_.end_date AS end_date_11, p0_.creator AS creator_12, p0_.last_update_user AS last_update_user_13, p0_.creation_date AS creation_date_14, p0_.last_update_date AS last_update_date_15, p0_.menu_position AS menu_position_16, p0_.main_page AS main_page_17, p0_.admin_page AS admin_page_18, p0_.external_link AS external_link_19, p0_.slug AS slug_20, p0_.visible_if_contract AS visible_if_contract_21, p0_.visible_if_type AS visible_if_type_22, p0_.is_showcase AS is_showcase_23, p0_.image AS image_24, p0_.meta_title AS meta_title_25, p0_.meta_description AS meta_description_26, p0_.not_in_cash_register AS not_in_cash_register_27, a1_.id AS id_28, a1_.order_number AS order_number_29, a1_.creator AS creator_30, a1_.last_update_user AS last_update_user_31, a1_.creation_date AS creation_date_32, a1_.last_update_date AS last_update_date_33, p0_.category_id AS category_id_34, p0_.image_gallery_id AS image_gallery_id_35, a1_.article_id AS article_id_36, a1_.page_id AS page_id_37 FROM page p0_ LEFT JOIN article_in_page a1_ ON p0_.id = a1_.page_id WHERE p0_.is_showcase = 1 AND p0_.active = ? AND p0_.slug = ? ORDER BY a1_.order_number ASC
Parameters:
[
  1
  "entreprendre_avec_nap"
]
0.85 ms
(5.13%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.subtitles AS subtitles_4, t0.to_publish AS to_publish_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.visible_if_contract AS visible_if_contract_8, t0.visible_if_type AS visible_if_type_9, t0.creator AS creator_10, t0.last_update_user AS last_update_user_11, t0.creation_date AS creation_date_12, t0.last_update_date AS last_update_date_13, t0.title AS title_14, t0.is_showcase AS is_showcase_15 FROM article t0 WHERE t0.id = ?
Parameters:
[
  334
]
0.60 ms
(3.58%)
1
SELECT t0.id AS id_1, t0.creator AS creator_2, t0.last_update_user AS last_update_user_3, t0.creation_date AS creation_date_4, t0.last_update_date AS last_update_date_5, t0.page_have_footers_id AS page_have_footers_id_6, t0.page_is_footers_id AS page_is_footers_id_7 FROM page_footer_link t0 WHERE t0.page_have_footers_id = ?
Parameters:
[
  113
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Page 25
App\Entity\PageInPage 21
App\Entity\PageFooterLink 4
App\Entity\ArticleInPage 1
App\Entity\Article 1

Entities Mapping

Class Mapping errors
App\Entity\Page No errors.
App\Entity\ArticleInPage No errors.
App\Entity\Category No errors.
App\Entity\ImageGallery No errors.
App\Entity\Article No errors.
App\Entity\UserPageAccess No errors.
App\Entity\PageInPage No errors.
App\Entity\PageFooterLink No errors.
App\Entity\DirectAccess No errors.
App\Entity\User No errors.
App\Entity\MessageForUser No errors.
App\Entity\MyInformations\ShopEvent No errors.
App\Entity\MyInformations\ShopPicture No errors.
App\Entity\MyInformations\ShopSocial No errors.
App\Entity\MyInformations\ShopDetailsExport No errors.
App\Entity\MyInformations\ShopDescription No errors.
App\Entity\OfficeLibrairie\UserBookReturn
  • The field 'App\Entity\OfficeLibrairie\UserBookReturn#pvuht' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\TestProfile No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\GMB\GeneratedDescription No errors.
App\Entity\Notification No errors.
App\Entity\EventSources No errors.
App\Entity\PowerBiConfig No errors.
App\Entity\Actuality No errors.
App\Entity\Message No errors.
App\Entity\ModelContent No errors.
App\Entity\JobsOffer No errors.
App\Entity\Event No errors.
App\Entity\Tobacco\TobaccoUnsoldDeclaration No errors.
App\Entity\Tobacco\TobaccoParam No errors.
App\Entity\Tobacco\TobaccoExport No errors.
App\Entity\Tobacco\TobaccoLineDeclaration No errors.
App\Entity\OfficeLibrairie\BookReturnedLot No errors.
App\Entity\OfficeLibrairie\UserBookReturnLot No errors.
App\Entity\OfficeLibrairie\BookReturn No errors.
Vich\UploaderBundle\Entity\File No errors.