Query Metrics
40
Database Queries
15
Different statements
37.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
10.45 ms (27.91%) |
17 |
SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.link AS LINK_3, t0.lvl AS LVL_4, t0.sort_order AS SORT_ORDER_5, t0.m_type AS M_TYPE_6, t0.lang AS LANG_7, t0.root_id AS ROOT_ID_8, t0.link_type AS LINK_TYPE_9, t0.link_type_data AS LINK_TYPE_DATA_10, t0.parent_id AS PARENT_ID_11, t0.visibility AS VISIBILITY_12, t0.isDeleted AS ISDELETED_13, t0.created_at AS CREATED_AT_14, t0.edited_at AS EDITED_AT_15, t0.m_page_id AS M_PAGE_ID_16, t0.parent_id2 AS PARENT_ID2_17 FROM cms_menu t0 WHERE t0.parent_id2 = ? ORDER BY t0.sort_order ASC
Parameters:
[
1
]
|
|
5.64 ms (15.05%) |
10 |
SELECT t0.name AS NAME_1, t0.title AS TITLE_2, t0.menu_name AS MENU_NAME_3, t0.link_name AS LINK_NAME_4, t0.lvl AS LVL_5, t0.sort_order AS SORT_ORDER_6, t0.seo_id AS SEO_ID_7, t0.content AS CONTENT_8, t0.status AS STATUS_9, t0.lang AS LANG_10, t0.parent_id AS PARENT_ID_11, t0.config_data AS CONFIG_DATA_12, t0.layout AS LAYOUT_13, t0.redirect_url AS REDIRECT_URL_14, t0.redirect_window AS REDIRECT_WINDOW_15, t0.icon AS ICON_16, t0.teaser AS TEASER_17, t0.p_search AS P_SEARCH_18, t0.user_id AS USER_ID_19, t0.id AS ID_20, t0.visibility AS VISIBILITY_21, t0.isDeleted AS ISDELETED_22, t0.created_at AS CREATED_AT_23, t0.edited_at AS EDITED_AT_24, t0.parent_id AS PARENT_ID_25, t0.redirect_to_id AS REDIRECT_TO_ID_26 FROM cms_page t0 WHERE t0.id = ?
Parameters:
[
41
]
|
|
3.03 ms (8.08%) |
1 |
ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' NLS_SORT = 'XSLOVAK' NLS_LENGTH_SEMANTICS = 'CHAR'
Parameters:
[] |
|
2.48 ms (6.63%) |
1 |
SELECT cms_stat_id_seq.nextval FROM DUAL
Parameters:
[] |
|
2.33 ms (6.22%) |
1 |
INSERT INTO cms_stat (id, created_at, browser, source_type, stat_type, source_id, referer, source_url, source_title, session_id, visibility, isDeleted, edited_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 143504 "2026-10-14 19:02:35" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "score_public_articles_detail" "request" "online-webinar-zvf-6-2024-uz-zrealizovany" null "/clanky/online-webinar-zvf-6-2024-uz-zrealizovany" "" null 1 0 "2026-10-14 19:02:35" ] |
|
2.01 ms (5.36%) |
1 |
SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.link AS LINK_3, t0.lvl AS LVL_4, t0.sort_order AS SORT_ORDER_5, t0.m_type AS M_TYPE_6, t0.lang AS LANG_7, t0.root_id AS ROOT_ID_8, t0.link_type AS LINK_TYPE_9, t0.link_type_data AS LINK_TYPE_DATA_10, t0.parent_id AS PARENT_ID_11, t0.visibility AS VISIBILITY_12, t0.isDeleted AS ISDELETED_13, t0.created_at AS CREATED_AT_14, t0.edited_at AS EDITED_AT_15, t0.m_page_id AS M_PAGE_ID_16, t0.parent_id2 AS PARENT_ID2_17 FROM cms_menu t0 WHERE t0.root_id IS NULL ORDER BY t0.created_at ASC, t0.id ASC
Parameters:
[] |
|
1.88 ms (5.03%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.62 ms (4.34%) |
1 |
SELECT c0_.code AS CODE_0, c0_.name AS NAME_1, c0_.value AS VALUE_2, c0_.o_params AS O_PARAMS_3, c0_.id AS ID_4, c0_.visibility AS VISIBILITY_5, c0_.isDeleted AS ISDELETED_6, c0_.created_at AS CREATED_AT_7, c0_.edited_at AS EDITED_AT_8 FROM cms_option c0_ WHERE c0_.code IS NOT NULL AND c0_.visibility = ?
Parameters:
[
1
]
|
|
1.47 ms (3.92%) |
1 |
SELECT t0.entity_id AS ENTITY_ID_1, t0.sort_order AS SORT_ORDER_2, t0.j_place AS J_PLACE_3, t0.j_params AS J_PARAMS_4, t0.id AS ID_5, t0.visibility AS VISIBILITY_6, t0.isDeleted AS ISDELETED_7, t0.created_at AS CREATED_AT_8, t0.edited_at AS EDITED_AT_9, t0.block_id AS BLOCK_ID_10, t0.entity_id AS ENTITY_ID_11, t0.joint_entity FROM cms_block_joint t0 WHERE t0.entity_id = ? AND t0.joint_entity IN ('article') ORDER BY t0.sort_order ASC, t0.j_place ASC
Parameters:
[
61
]
|
|
1.35 ms (3.60%) |
1 |
SELECT a.* FROM (SELECT c0_.name AS NAME_0, c0_.icon AS ICON_1, c0_.teaser AS TEASER_2, c0_.body AS BODY_3, c0_.published AS PUBLISHED_4, c0_.created_by AS CREATED_BY_5, c0_.priority AS PRIORITY_6, c0_.author AS AUTHOR_7, c0_.published_from AS PUBLISHED_FROM_8, c0_.published_to AS PUBLISHED_TO_9, c0_.slug AS SLUG_10, c0_.seo_title AS SEO_TITLE_11, c0_.metadata AS METADATA_12, c0_.search AS SEARCH_13, c0_.id AS ID_14, c0_.visibility AS VISIBILITY_15, c0_.isDeleted AS ISDELETED_16, c0_.created_at AS CREATED_AT_17, c0_.edited_at AS EDITED_AT_18 FROM cms_article c0_ WHERE c0_.published = 1 AND (c0_.isDeleted = 0 OR c0_.isDeleted IS NULL) AND c0_.id <> ? AND ((c0_.published_from < ? OR c0_.published_from IS NULL) AND (c0_.published_to > ? OR c0_.published_to IS NULL)) ORDER BY c0_.priority DESC, c0_.published_from DESC) a WHERE ROWNUM <= 4
Parameters:
[ 61 "2026-10-14 19:02:35" "2026-10-14 19:02:35" ] |
|
1.34 ms (3.58%) |
1 |
SELECT t0.d_is_external AS D_IS_EXTERNAL_1, t0.d_url AS D_URL_2, t0.d_filename AS D_FILENAME_3, t0.d_size AS D_SIZE_4, t0.d_type AS D_TYPE_5, t0.d_language AS D_LANGUAGE_6, t0.d_info AS D_INFO_7, t0.d_is_current AS D_IS_CURRENT_8, t0.d_code AS D_CODE_9, t0.d_extension AS D_EXTENSION_10, t0.id AS ID_11, t0.visibility AS VISIBILITY_12, t0.isDeleted AS ISDELETED_13, t0.created_at AS CREATED_AT_14, t0.edited_at AS EDITED_AT_15, t0.document_id AS DOCUMENT_ID_16 FROM cms_document_file t0 WHERE t0.document_id = ? ORDER BY t0.created_at ASC
Parameters:
[
102
]
|
|
1.33 ms (3.54%) |
1 |
SELECT a.* FROM (SELECT t0.d_name AS D_NAME_1, t0.d_full_name AS D_FULL_NAME_2, t0.d_teaser AS D_TEASER_3, t0.d_description AS D_DESCRIPTION_4, t0.d_has_detail AS D_HAS_DETAIL_5, t0.d_public AS D_PUBLIC_6, t0.d_search AS D_SEARCH_7, t0.d_version AS D_VERSION_8, t0.d_code AS D_CODE_9, t0.d_seoId AS D_SEOID_10, t0.d_year AS D_YEAR_11, t0.d_icon AS D_ICON_12, t0.d_params AS D_PARAMS_13, t0.id AS ID_14, t0.visibility AS VISIBILITY_15, t0.isDeleted AS ISDELETED_16, t0.created_at AS CREATED_AT_17, t0.edited_at AS EDITED_AT_18 FROM cms_document t0 WHERE t0.d_code = ?) a WHERE ROWNUM <= 1
Parameters:
[
"120a731cc4be5e47"
]
|
|
1.24 ms (3.31%) |
1 |
SELECT a.* FROM (SELECT t0.name AS NAME_1, t0.icon AS ICON_2, t0.teaser AS TEASER_3, t0.body AS BODY_4, t0.published AS PUBLISHED_5, t0.created_by AS CREATED_BY_6, t0.priority AS PRIORITY_7, t0.author AS AUTHOR_8, t0.published_from AS PUBLISHED_FROM_9, t0.published_to AS PUBLISHED_TO_10, t0.slug AS SLUG_11, t0.seo_title AS SEO_TITLE_12, t0.metadata AS METADATA_13, t0.search AS SEARCH_14, t0.id AS ID_15, t0.visibility AS VISIBILITY_16, t0.isDeleted AS ISDELETED_17, t0.created_at AS CREATED_AT_18, t0.edited_at AS EDITED_AT_19 FROM cms_article t0 WHERE t0.slug = ? AND t0.published = ?) a WHERE ROWNUM <= 1
Parameters:
[ "online-webinar-zvf-6-2024-uz-zrealizovany" 1 ] |
|
1.14 ms (3.04%) |
1 |
SELECT t0.entity_id AS ENTITY_ID_1, t0.m_value AS M_VALUE_2, t0.m_userId AS M_USERID_3, t0.id AS ID_4, t0.visibility AS VISIBILITY_5, t0.isDeleted AS ISDELETED_6, t0.created_at AS CREATED_AT_7, t0.edited_at AS EDITED_AT_8, t0.pattern_id AS PATTERN_ID_9, t0.entity_id AS ENTITY_ID_10, t0.tag_entity FROM cms_metatag t0 WHERE t0.entity_id = ? AND t0.tag_entity IN ('article')
Parameters:
[
61
]
|
|
0.15 ms (0.40%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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.