Symfony Profiler

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

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 = 1 ORDER BY t0.sort_order ASC;

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 = ?

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 = 41;

SELECT
  *
FROM
  (
    SELECT
      a.*,
      ROWNUM AS doctrine_rownum
    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 <= 12
  )
WHERE
  doctrine_rownum >= 7

SELECT * FROM (SELECT a.*, ROWNUM AS doctrine_rownum 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 = 1 AND (c0_.isDeleted = 0 OR c0_.isDeleted IS NULL) AND ((c0_.published_from < '2026-10-22 14:49:13' OR c0_.published_from IS NULL) AND (c0_.published_to > '2026-10-22 14:49:13' OR c0_.published_to IS NULL))) dctrn_result GROUP BY ID_14 ORDER BY dctrn_minrownum ASC) a WHERE ROWNUM <= 12) WHERE doctrine_rownum >= 7;

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

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 = 1 AND (c0_.isDeleted = 0 OR c0_.isDeleted IS NULL) AND ((c0_.published_from < '2026-10-22 14:49:13' OR c0_.published_from IS NULL) AND (c0_.published_to > '2026-10-22 14:49:13' OR c0_.published_to IS NULL)) ORDER BY c0_.priority DESC, c0_.published_from DESC, c0_.name ASC) dctrn_result) dctrn_table;

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

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;

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 = ?

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 = 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
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

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 (159288, '2026-10-22 14:49:13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; PerplexityBot/1.0; +https://perplexity.ai/perplexitybot)', 'score_public_articles_list', 'request', '', NULL, '/clanky/?amp=&p=2&p%253D1==', '', NULL, 1, 0, '2026-10-22 14:49:13');

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

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_.published_from < '2026-10-22 14:49:13' OR c0_.published_from IS NULL) AND (c0_.published_to > '2026-10-22 14:49:13' OR c0_.published_to IS NULL)) AND c0_.id IN (61, 41, 21) ORDER BY c0_.priority DESC, c0_.published_from DESC, c0_.name ASC;

SELECT
  cms_stat_id_seq.nextval
FROM
  DUAL

SELECT cms_stat_id_seq.nextval FROM DUAL;

"COMMIT"

"COMMIT";

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'

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';

"START TRANSACTION"

"START TRANSACTION";