https://zelenyvzdelavacifond.sk/clanky/online-webinar-zvf-6-2024-uz-zrealizovany

Query Metrics

40 Database Queries
15 Different statements
37.46 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.

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\Metatag\MetatagPattern 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.
Score\CmsBundle\Entity\Document\Document No errors.
Score\CmsBundle\Entity\Document\DocumentLevel No errors.
Score\CmsBundle\Entity\Document\DocumentCategory No errors.
Score\CmsBundle\Entity\Document\DocumentDescription No errors.
Score\CmsBundle\Entity\Document\DocumentFile No errors.
Score\CmsBundle\Entity\Access\AccessDocument No errors.
Score\CmsBundle\Entity\Block\BlockJointDocument No errors.
Score\CmsBundle\Entity\Metatag\MetatagDocument No errors.
Score\CmsBundle\Entity\Block\Block No errors.