Symfony Profiler

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

SELECT
  cms_stat_id_seq.nextval
FROM
  DUAL

SELECT cms_stat_id_seq.nextval FROM DUAL;

"START TRANSACTION"

"START TRANSACTION";

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 (167094, '2026-10-24 08:58:20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; Amazonbot/0.1; +https://developer.amazon.com/support/amazonbot) Chrome/119.0.6045.214 Safari/537.36', 'score_public_articles_list', 'request', '', NULL, '/clanky/?amp=&p=1%3D', '', NULL, 1, 0, '2026-10-24 08:58:20');

"COMMIT"

"COMMIT";

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-24 08:58:21' OR c0_.published_from IS NULL) AND (c0_.published_to > '2026-10-24 08:58:21' OR c0_.published_to IS NULL)) ORDER BY c0_.priority DESC, c0_.published_from DESC, c0_.name ASC) dctrn_result) dctrn_table;