Query Metrics

174 Database Queries
11 Different statements
175.86 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
59.81 ms
(34.01%)
66
SELECT t0.id AS id_1, t0.type AS type_2, t0.locale AS locale_3, t0.path AS path_4, t0.page_id AS page_id_5 FROM path t0 WHERE t0.page_id = ?
Parameters:
[
  222
]
54.37 ms
(30.92%)
64
SELECT t0.id AS id_1, t0.type AS type_2, t0.caching_level AS caching_level_3, t0.global_title AS global_title_4, t0.global_description AS global_description_5, t0.title AS title_6, t0.description AS description_7, t0.content_properties AS content_properties_8, t0.locale AS locale_9, t0.slices AS slices_10, t0.breadcrumb AS breadcrumb_11, t0.status AS status_12, t0.update_comment AS update_comment_13, t0.published AS published_14, t0.expired AS expired_15, t0.created AS created_16, t0.updated AS updated_17, t0.template AS template_18, t0.visibility AS visibility_19, t0.seo_title AS seo_title_20, t0.seo_description AS seo_description_21, t0.no_index AS no_index_22, t0.no_follow AS no_follow_23, t0.site_map AS site_map_24, t0.og_title AS og_title_25, t0.og_type AS og_type_26, t0.og_description AS og_description_27, t0.twitter_title AS twitter_title_28, t0.twitter_description AS twitter_description_29, t0.twitter_card AS twitter_card_30, t0.master_id AS master_id_31, t0.lastPublisher_id AS lastPublisher_id_32, t0.author_id AS author_id_33, t0.lastUpdater_id AS lastUpdater_id_34, t0.ogImage_id AS ogImage_id_35, t0.twitterImage_id AS twitterImage_id_36 FROM page t0 WHERE t0.id = ?
Parameters:
[
  222
]
19.51 ms
(11.09%)
2
SELECT t0.id AS id_1, t0.media_id AS media_id_2 FROM cloudinary_media t0 WHERE t0.id = ?
Parameters:
[
  400
]
14.25 ms
(8.10%)
31
SELECT t0.id AS id_1, t0.label AS label_2, t0.type AS type_3, t0.target AS target_4, t0.link AS link_5, t0.class AS class_6, t0.position AS position_7, t0.page_id AS page_id_8, t0.menu_id AS menu_id_9, t0.parent_id AS parent_id_10 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  5889
]
7.45 ms
(4.23%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.global_name AS global_name_3, t0.global_description AS global_description_4, t0.name AS name_5, t0.description AS description_6, t0.locale AS locale_7, t0.created AS created_8, t0.updated AS updated_9, t0.master_id AS master_id_10, t0.author_id AS author_id_11, t0.lastUpdater_id AS lastUpdater_id_12 FROM tag t0 INNER JOIN page_tags ON t0.id = page_tags.tag_id WHERE page_tags.page_id = ?
Parameters:
[
  222
]
5.80 ms
(3.30%)
1
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.caching_level AS caching_level_2, p0_.global_title AS global_title_3, p0_.global_description AS global_description_4, p0_.title AS title_5, p0_.description AS description_6, p0_.content_properties AS content_properties_7, p0_.locale AS locale_8, p0_.slices AS slices_9, p0_.breadcrumb AS breadcrumb_10, p0_.status AS status_11, p0_.update_comment AS update_comment_12, p0_.published AS published_13, p0_.expired AS expired_14, p0_.created AS created_15, p0_.updated AS updated_16, p0_.template AS template_17, p0_.visibility AS visibility_18, p0_.seo_title AS seo_title_19, p0_.seo_description AS seo_description_20, p0_.no_index AS no_index_21, p0_.no_follow AS no_follow_22, p0_.site_map AS site_map_23, p0_.og_title AS og_title_24, p0_.og_type AS og_type_25, p0_.og_description AS og_description_26, p0_.twitter_title AS twitter_title_27, p0_.twitter_description AS twitter_description_28, p0_.twitter_card AS twitter_card_29, p0_.master_id AS master_id_30, p0_.lastPublisher_id AS lastPublisher_id_31, p0_.author_id AS author_id_32, p0_.lastUpdater_id AS lastUpdater_id_33, p0_.ogImage_id AS ogImage_id_34, p0_.twitterImage_id AS twitterImage_id_35 FROM page p0_ WHERE p0_.type = ? AND p0_.locale = ?
Parameters:
[
  "home"
  "fr"
]
4.83 ms
(2.74%)
2
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.reference AS reference_2, m0_.locale AS locale_3, m0_.created AS created_4, m0_.updated AS updated_5, m0_.master_id AS master_id_6, m0_.author_id AS author_id_7, m0_.lastUpdater_id AS lastUpdater_id_8 FROM menu m0_ WHERE m0_.reference = ? AND m0_.locale = ?
Parameters:
[
  "header-secondary"
  "fr"
]
4.17 ms
(2.37%)
2
SELECT t0.id AS id_1, t0.label AS label_2, t0.type AS type_3, t0.target AS target_4, t0.link AS link_5, t0.class AS class_6, t0.position AS position_7, t0.page_id AS page_id_8, t0.menu_id AS menu_id_9, t0.parent_id AS parent_id_10 FROM menu_item t0 WHERE t0.menu_id = ? ORDER BY t0.id ASC
Parameters:
[
  2
]
3.42 ms
(1.94%)
2
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.caching_level AS caching_level_2, p0_.global_title AS global_title_3, p0_.global_description AS global_description_4, p0_.title AS title_5, p0_.description AS description_6, p0_.content_properties AS content_properties_7, p0_.locale AS locale_8, p0_.slices AS slices_9, p0_.breadcrumb AS breadcrumb_10, p0_.status AS status_11, p0_.update_comment AS update_comment_12, p0_.published AS published_13, p0_.expired AS expired_14, p0_.created AS created_15, p0_.updated AS updated_16, p0_.template AS template_17, p0_.visibility AS visibility_18, p0_.seo_title AS seo_title_19, p0_.seo_description AS seo_description_20, p0_.no_index AS no_index_21, p0_.no_follow AS no_follow_22, p0_.site_map AS site_map_23, p0_.og_title AS og_title_24, p0_.og_type AS og_type_25, p0_.og_description AS og_description_26, p0_.twitter_title AS twitter_title_27, p0_.twitter_description AS twitter_description_28, p0_.twitter_card AS twitter_card_29, p0_.master_id AS master_id_30, p0_.lastPublisher_id AS lastPublisher_id_31, p0_.author_id AS author_id_32, p0_.lastUpdater_id AS lastUpdater_id_33, p0_.ogImage_id AS ogImage_id_34, p0_.twitterImage_id AS twitterImage_id_35 FROM page p0_ WHERE p0_.type = ? AND p0_.master_id IS NULL
Parameters:
[
  "login"
]
1.14 ms
(0.65%)
2
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.type AS type_3, t0.title AS title_4, t0.alt AS alt_5, t0.description AS description_6, t0.copyright AS copyright_7, t0.credits AS credits_8, t0.tags AS tags_9, t0.original_format AS original_format_10, t0.config AS config_11 FROM cloudinary_media_model t0 WHERE t0.id = ?
Parameters:
[
  400
]
1.13 ms
(0.64%)
1
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.locale AS locale_2, p0_.path AS path_3, p0_.page_id AS page_id_4 FROM path p0_ WHERE p0_.path = ? AND p0_.locale = ?
Parameters:
[
  "rapport-d-activite/rapport-d-activite-2016"
  "fr"
]

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\Path No errors.
App\Entity\Page No errors.
App\Entity\Tag No errors.
App\Entity\BackUser No errors.
App\Entity\Utils\Cloudinary\Media No errors.
App\Entity\Menu\Item No errors.
App\Entity\Utils\Cloudinary\MediaModel No errors.
App\Entity\Menu No errors.