Query Metrics
3
Database Queries
3
Different statements
6.20 ms
Query time
2
Invalid entities
6
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.74 ms |
SELECT p0_.id AS id_0, p0_.template AS template_1, p0_.content_type AS content_type_2, p0_.assigned_function AS assigned_function_3, p0_.valid_from AS valid_from_4, p0_.valid_to AS valid_to_5, p1_.id AS id_6, p1_.lang AS lang_7, p1_.title AS title_8, p1_.is_titlevisible AS is_titlevisible_9, p1_.title_tag AS title_tag_10, p1_.is_title_tag_automatic AS is_title_tag_automatic_11, p1_.meta_description AS meta_description_12, p1_.meta_keywords AS meta_keywords_13, p1_.tags AS tags_14, p1_.created_at AS created_at_15, p1_.updated_at AS updated_at_16, p1_.created_by AS created_by_17, p1_.updated_by AS updated_by_18, p1_.is_updated_at_automatic AS is_updated_at_automatic_19, p1_.is_active AS is_active_20, p1_.is_searchable AS is_searchable_21, p1_.is_language_active AS is_language_active_22, p1_.page_id AS page_id_23, p1_.test_field AS test_field_24, p1_.page_id AS page_id_25 FROM page p0_ INNER JOIN page_translation p1_ ON p0_.id = p1_.page_id WHERE p1_.is_active = 1 AND p0_.content_type LIKE ? AND (? BETWEEN p0_.valid_from AND p0_.valid_to) AND p1_.lang = ? LIMIT 1
Parameters:
[ "error_page" "2025-12-11 14:21:26" "hu" ] |
| 2 | 1.86 ms |
SELECT m0_.id AS id_0, m0_.page_id AS page_id_1, m0_.menu_group AS menu_group_2, m0_.is_popup AS is_popup_3, m0_.path AS path_4, m0_.level AS level_5, m0_.clone_parent_menu_id AS clone_parent_menu_id_6, m0_.is_internal AS is_internal_7, m0_.is_concated AS is_concated_8, m0_.is_archive AS is_archive_9, m0_.special_attribute AS special_attribute_10, m0_.is_editable AS is_editable_11, m1_.id AS id_12, m1_.lang AS lang_13, m1_.is_language_active AS is_language_active_14, m1_.is_active AS is_active_15, m1_.name AS name_16, m1_.slug AS slug_17, m1_.concated_slug AS concated_slug_18, m1_.concated_slug_archive AS concated_slug_archive_19, m1_.is_slug_visible AS is_slug_visible_20, m1_.url AS url_21, m1_.visibility AS visibility_22, m1_.dynamic_route_generator AS dynamic_route_generator_23, m1_.is_automatic_dynamic_route_generator AS is_automatic_dynamic_route_generator_24, m1_.menu_id AS menu_id_25, m0_.clone_parent_menu_id AS clone_parent_menu_id_26, m0_.page_id AS page_id_27, m1_.menu_id AS menu_id_28 FROM menu m0_ INNER JOIN menu_translation m1_ ON m0_.id = m1_.menu_id WHERE m1_.is_active = 1 AND (LOCATE(m1_.concated_slug, ?) = 1 OR LOCATE(m1_.concated_slug_archive, ?) = 1 OR LOCATE(CONCAT(m1_.lang, '/', m1_.concated_slug), ?) = 1 OR LOCATE(CONCAT(m1_.lang, '/', m1_.concated_slug_archive), ?) = 1) ORDER BY m1_.concated_slug DESC LIMIT 1
Parameters:
[ "robots.txt" "robots.txt" "robots.txt" "robots.txt" ] |
| 3 | 1.60 ms |
SELECT c0_.id AS id_0, c0_.content_id AS content_id_1, c0_.inner_content_id AS inner_content_id_2, c0_.lang AS lang_3, c0_.place_id AS place_id_4, i1_.id AS id_5, i1_.lang AS lang_6, i1_.refer AS refer_7, i1_.content AS content_8, i1_.is_shared_content AS is_shared_content_9, c0_.inner_content_id AS inner_content_id_10 FROM content_connector c0_ INNER JOIN inner_content i1_ ON c0_.inner_content_id = i1_.id WHERE c0_.lang = ? AND c0_.content_id IN (?)
Parameters:
[ "hu" 1 ] |
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\Core\Entity\ContentConnector | 2 |
| App\Core\Entity\InnerContent | 2 |
| App\CSMSSite\CoimbraITSBundle\Entity\Core\Page | 1 |
| App\CSMSSite\CoimbraITSBundle\Entity\Core\PageTranslation | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Core\Entity\Page | No errors. |
| App\CSMSSite\CoimbraITSBundle\Entity\Core\Page | No errors. |
| App\Core\Entity\PageTranslation | No errors. |
| App\CSMSSite\CoimbraITSBundle\Entity\Core\PageTranslation | No errors. |
| App\Core\Entity\Menu |
|
| App\CSMSSite\CoimbraITSBundle\Entity\Core\Menu |
|
| App\Core\Entity\MenuTranslation | No errors. |
| App\CSMSSite\CoimbraITSBundle\Entity\Core\MenuTranslation | No errors. |
| App\Core\Entity\ContentConnector | No errors. |
| App\Core\Entity\InnerContent | No errors. |