Query Metrics
37
Database Queries
12
Different statements
43.82 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.94 ms |
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 | 2.63 ms |
SELECT cms_stat_id_seq.nextval FROM DUAL
Parameters:
[] |
| 3 | 0.15 ms |
"START TRANSACTION"
Parameters:
[] |
| 4 | 2.74 ms |
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:
[ 123896 "2026-10-03 10:48:11" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0 Safari/537.36" "score_public_articles_list" "request" "" null "/clanky/" "" null 1 0 "2026-10-03 10:48:11" ] |
| 5 | 1.93 ms |
"COMMIT"
Parameters:
[] |
| 6 | 2.07 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT ID_14 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 = ? AND (c0_.isDeleted = 0 OR c0_.isDeleted IS NULL) 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, c0_.name ASC) dctrn_result) dctrn_table
Parameters:
[ 1 "2026-10-03 10:48:11" "2026-10-03 10:48:11" ] |
| 7 | 3.15 ms |
SELECT a.* FROM (SELECT DISTINCT ID_14, MIN(SCLR_19) AS dctrn_minrownum 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, ROW_NUMBER() OVER(ORDER BY c0_.priority DESC, c0_.published_from DESC, c0_.name ASC) AS SCLR_19 FROM cms_article c0_ WHERE c0_.published = ? AND (c0_.isDeleted = 0 OR c0_.isDeleted IS NULL) AND ((c0_.published_from < ? OR c0_.published_from IS NULL) AND (c0_.published_to > ? OR c0_.published_to IS NULL))) dctrn_result GROUP BY ID_14 ORDER BY dctrn_minrownum ASC) a WHERE ROWNUM <= 6
Parameters:
[ 1 "2026-10-03 10:48:11" "2026-10-03 10:48:11" ] |
| 8 | 1.35 ms |
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 = ? AND (c0_.isDeleted = 0 OR c0_.isDeleted IS NULL) AND ((c0_.published_from < ? OR c0_.published_from IS NULL) AND (c0_.published_to > ? OR c0_.published_to IS NULL)) AND c0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY c0_.priority DESC, c0_.published_from DESC, c0_.name ASC
Parameters:
[ 1 "2026-10-03 10:48:11" "2026-10-03 10:48:11" 181 161 141 121 101 81 ] |
| 9 | 1.98 ms |
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
]
|
| 10 | 2.20 ms |
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:
[] |
| 11 | 1.94 ms |
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
]
|
| 12 | 0.85 ms |
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:
[
10
]
|
| 13 | 0.85 ms |
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:
[
42
]
|
| 14 | 0.88 ms |
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:
[
61
]
|
| 15 | 1.80 ms |
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
]
|
| 16 | 0.71 ms |
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:
[
62
]
|
| 17 | 0.81 ms |
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:
[
7
]
|
| 18 | 0.63 ms |
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:
[
16
]
|
| 19 | 0.69 ms |
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:
[
41
]
|
| 20 | 0.62 ms |
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:
[
9
]
|
| 21 | 0.69 ms |
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:
[
8
]
|
| 22 | 0.45 ms |
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:
[
10
]
|
| 23 | 0.60 ms |
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:
[
9
]
|
| 24 | 0.42 ms |
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:
[
11
]
|
| 25 | 0.55 ms |
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:
[
12
]
|
| 26 | 0.44 ms |
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:
[
12
]
|
| 27 | 0.54 ms |
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:
[
13
]
|
| 28 | 0.48 ms |
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:
[
13
]
|
| 29 | 0.57 ms |
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:
[
14
]
|
| 30 | 0.67 ms |
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:
[
15
]
|
| 31 | 0.50 ms |
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:
[
14
]
|
| 32 | 0.59 ms |
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:
[
16
]
|
| 33 | 0.45 ms |
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:
[
15
]
|
| 34 | 0.75 ms |
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:
[
17
]
|
| 35 | 0.62 ms |
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:
[
21
]
|
| 36 | 0.80 ms |
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:
[
21
]
|
| 37 | 0.77 ms |
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:
[
2
]
|
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 |
|---|---|
| Score\CmsBundle\Entity\Stat | No errors. |
| Score\CmsBundle\Entity\Article\Article | No errors. |
| Score\CmsBundle\Entity\Multisite\SiteItem | No errors. |
| Score\CmsBundle\Entity\Multisite\SiteItemArticle | No errors. |
| Score\CmsBundle\Entity\Article\ArticleCategory | No errors. |
| Score\CmsBundle\Entity\Access\Access | No errors. |
| Score\CmsBundle\Entity\Access\AccessArticle | No errors. |
| Score\CmsBundle\Entity\Block\BlockJoint | No errors. |
| Score\CmsBundle\Entity\Block\BlockJointArticle | No errors. |
| Score\CmsBundle\Entity\Metatag\Metatag | No errors. |
| Score\CmsBundle\Entity\Metatag\MetatagArticle | No errors. |
| Score\CmsBundle\Entity\Option | No errors. |
| Score\CmsBundle\Entity\Menu | No errors. |
| Score\CmsBundle\Entity\Page\Page | No errors. |
| Score\CmsBundle\Entity\Multisite\SiteItemMenu | No errors. |
| Score\CmsBundle\Entity\Multisite\SiteItemPage | No errors. |
| Score\CmsBundle\Entity\Access\AccessPage | No errors. |
| Score\CmsBundle\Entity\Block\BlockJointPage | No errors. |
| Score\CmsBundle\Entity\Metatag\MetatagPage | No errors. |