Query Metrics
186
Database Queries
11
Different statements
113.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
46.89 ms (41.14%) |
65 |
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:
[
218
]
|
|
35.01 ms (30.73%) |
67 |
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:
[
218
]
|
|
20.18 ms (17.71%) |
37 |
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
]
|
|
2.77 ms (2.43%) |
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"
]
|
|
2.50 ms (2.19%) |
4 |
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
]
|
|
2.39 ms (2.10%) |
4 |
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" ] |
|
1.06 ms (0.93%) |
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" ] |
|
0.94 ms (0.82%) |
2 |
SELECT t0.id AS id_1, t0.media_id AS media_id_2 FROM cloudinary_media t0 WHERE t0.id = ?
Parameters:
[
392
]
|
|
0.92 ms (0.81%) |
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:
[
392
]
|
|
0.86 ms (0.75%) |
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-2019-2020" "fr" ] |
|
0.45 ms (0.40%) |
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:
[
218
]
|
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. |