Query Metrics
6
Database Queries
6
Different statements
10.78 ms
Query time
2
Invalid entities
26
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.13 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 12:24:49" "hu" ] |
| 2 | 2.08 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 m1_.lang = ? 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:
[ "hu" "kezdolap" "kezdolap" "kezdolap" "kezdolap" ] |
| 3 | 1.93 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_.lang = ? AND p0_.id = ? LIMIT 1
Parameters:
[ "hu" 2 ] |
| 4 | 1.56 ms |
SELECT t0.id AS id_1, t0.assigned_function AS assigned_function_2, t0.condition AS condition_3 FROM page_condition t0 WHERE t0.assigned_function = ? LIMIT 1
Parameters:
[
"homepage"
]
|
| 5 | 1.50 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, p2_.id AS id_26, p2_.template AS template_27, p2_.content_type AS content_type_28, p2_.assigned_function AS assigned_function_29, p2_.valid_from AS valid_from_30, p2_.valid_to AS valid_to_31, p3_.id AS id_32, p3_.lang AS lang_33, p3_.title AS title_34, p3_.is_titlevisible AS is_titlevisible_35, p3_.title_tag AS title_tag_36, p3_.is_title_tag_automatic AS is_title_tag_automatic_37, p3_.meta_description AS meta_description_38, p3_.meta_keywords AS meta_keywords_39, p3_.tags AS tags_40, p3_.created_at AS created_at_41, p3_.updated_at AS updated_at_42, p3_.created_by AS created_by_43, p3_.updated_by AS updated_by_44, p3_.is_updated_at_automatic AS is_updated_at_automatic_45, p3_.is_active AS is_active_46, p3_.is_searchable AS is_searchable_47, p3_.is_language_active AS is_language_active_48, p3_.page_id AS page_id_49, p3_.test_field AS test_field_50, m0_.clone_parent_menu_id AS clone_parent_menu_id_51, m0_.page_id AS page_id_52, m1_.menu_id AS menu_id_53, p3_.page_id AS page_id_54 FROM menu m0_ INNER JOIN menu_translation m1_ ON m0_.id = m1_.menu_id INNER JOIN page p2_ ON m0_.page_id = p2_.id INNER JOIN page_translation p3_ ON p2_.id = p3_.page_id WHERE m1_.lang = ? AND p3_.lang = ? AND m0_.is_concated = 1 AND m0_.path LIKE ? AND m0_.level = ? AND m1_.is_active = 1 ORDER BY m0_.path ASC
Parameters:
[ "hu" "hu" "%" 1 ] |
| 6 | 1.58 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" 2 14 15 ] |
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 | 6 |
| App\Core\Entity\InnerContent | 6 |
| App\CSMSSite\CoimbraGroupBundle\Entity\Core\Page | 4 |
| App\CSMSSite\CoimbraGroupBundle\Entity\Core\PageTranslation | 4 |
| App\CSMSSite\CoimbraGroupBundle\Entity\Core\Menu | 3 |
| App\CSMSSite\CoimbraGroupBundle\Entity\Core\MenuTranslation | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Core\Entity\Page | No errors. |
| App\CSMSSite\CoimbraGroupBundle\Entity\Core\Page | No errors. |
| App\Core\Entity\PageTranslation | No errors. |
| App\CSMSSite\CoimbraGroupBundle\Entity\Core\PageTranslation | No errors. |
| App\Core\Entity\Menu |
|
| App\CSMSSite\CoimbraGroupBundle\Entity\Core\Menu |
|
| App\Core\Entity\MenuTranslation | No errors. |
| App\CSMSSite\CoimbraGroupBundle\Entity\Core\MenuTranslation | No errors. |
| App\Core\Entity\PageCondition | No errors. |
| App\Core\Entity\ContentConnector | No errors. |
| App\Core\Entity\InnerContent | No errors. |