Query Metrics

3 Database Queries
3 Different statements
6.20 ms Query time
2 Invalid entities
6 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.74 ms
(44.16%)
1
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"
]
1.86 ms
(30.02%)
1
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"
]
1.60 ms
(25.83%)
1
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
  • The target entity 'App\Core\Entity\Menu' specified on App\Core\Entity\Menu#clone is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\CSMSSite\CoimbraITSBundle\Entity\Core\Menu
  • The target entity 'App\Core\Entity\Menu' specified on App\CSMSSite\CoimbraITSBundle\Entity\Core\Menu#clone is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
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.