Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.name AS name_1,
          c0_.icon AS icon_2,
          c0_.teaser AS teaser_3,
          c0_.body AS body_4,
          c0_.published AS published_5,
          c0_.created_by AS created_by_6,
          c0_.priority AS priority_7,
          c0_.author AS author_8,
          c0_.published_from AS published_from_9,
          c0_.published_to AS published_to_10,
          c0_.slug AS slug_11,
          c0_.seo_title AS seo_title_12,
          c0_.metadata AS metadata_13,
          c0_.search AS search_14,
          c0_.category AS category_15,
          c0_.visibility AS visibility_16,
          c0_.created_at AS created_at_17,
          c0_.edited_at AS edited_at_18,
          c0_.last_check_at AS last_check_at_19,
          c0_.next_check_at AS next_check_at_20
        FROM
          cms_article c0_
        WHERE
          c0_.published = ?
          AND (
            (
              c0_.published_from < ?
              OR c0_.published_from IS NULL
            )
            AND (
              c0_.published_to > ?
              OR c0_.published_to IS NULL
            )
          )
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.icon AS icon_2, c0_.teaser AS teaser_3, c0_.body AS body_4, c0_.published AS published_5, c0_.created_by AS created_by_6, c0_.priority AS priority_7, c0_.author AS author_8, c0_.published_from AS published_from_9, c0_.published_to AS published_to_10, c0_.slug AS slug_11, c0_.seo_title AS seo_title_12, c0_.metadata AS metadata_13, c0_.search AS search_14, c0_.category AS category_15, c0_.visibility AS visibility_16, c0_.created_at AS created_at_17, c0_.edited_at AS edited_at_18, c0_.last_check_at AS last_check_at_19, c0_.next_check_at AS next_check_at_20 FROM cms_article c0_ WHERE c0_.published = 1 AND ((c0_.published_from < '2024-11-23 17:54:05' OR c0_.published_from IS NULL) AND (c0_.published_to > '2024-11-23 17:54:05' OR c0_.published_to IS NULL))) dctrn_result) dctrn_table;

SELECT
  NEXTVAL('cms_stat_id_seq')

SELECT NEXTVAL('cms_stat_id_seq');

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.icon AS icon_2,
  c0_.teaser AS teaser_3,
  c0_.body AS body_4,
  c0_.published AS published_5,
  c0_.created_by AS created_by_6,
  c0_.priority AS priority_7,
  c0_.author AS author_8,
  c0_.published_from AS published_from_9,
  c0_.published_to AS published_to_10,
  c0_.slug AS slug_11,
  c0_.seo_title AS seo_title_12,
  c0_.metadata AS metadata_13,
  c0_.search AS search_14,
  c0_.category AS category_15,
  c0_.visibility AS visibility_16,
  c0_.created_at AS created_at_17,
  c0_.edited_at AS edited_at_18,
  c0_.last_check_at AS last_check_at_19,
  c0_.next_check_at AS next_check_at_20
FROM
  cms_article c0_
WHERE
  c0_.published = ?
  AND (
    (
      c0_.published_from < ?
      OR c0_.published_from IS NULL
    )
    AND (
      c0_.published_to > ?
      OR c0_.published_to IS NULL
    )
  )
  AND c0_.id IN (?, ?, ?, ?, ?, ?)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.icon AS icon_2, c0_.teaser AS teaser_3, c0_.body AS body_4, c0_.published AS published_5, c0_.created_by AS created_by_6, c0_.priority AS priority_7, c0_.author AS author_8, c0_.published_from AS published_from_9, c0_.published_to AS published_to_10, c0_.slug AS slug_11, c0_.seo_title AS seo_title_12, c0_.metadata AS metadata_13, c0_.search AS search_14, c0_.category AS category_15, c0_.visibility AS visibility_16, c0_.created_at AS created_at_17, c0_.edited_at AS edited_at_18, c0_.last_check_at AS last_check_at_19, c0_.next_check_at AS next_check_at_20 FROM cms_article c0_ WHERE c0_.published = 1 AND ((c0_.published_from < '2024-11-23 17:54:05' OR c0_.published_from IS NULL) AND (c0_.published_to > '2024-11-23 17:54:05' OR c0_.published_to IS NULL)) AND c0_.id IN (126, 194, 326, 360, 385, 371);

INSERT INTO cms_stat (
  id, created_at, browser, source_type,
  stat_type, source_id, referer, source_url,
  source_title, session_id, visibility,
  edited_at, last_check_at, next_check_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO cms_stat (id, created_at, browser, source_type, stat_type, source_id, referer, source_url, source_title, session_id, visibility, edited_at, last_check_at, next_check_at) VALUES (80712, '2024-11-23 17:54:05', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'score_public_articles_list', 'request', '', NULL, '/clanky/?p=51', '', NULL, 1, '2024-11-23 17:54:05', '2024-11-23 17:54:05', NULL);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.link AS link_3,
  t0.parent_id AS parent_id_4,
  t0.lvl AS lvl_5,
  t0.sort_order AS sort_order_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.visibility AS visibility_11,
  t0.created_at AS created_at_12,
  t0.edited_at AS edited_at_13,
  t0.last_check_at AS last_check_at_14,
  t0.next_check_at AS next_check_at_15
FROM
  cms_menu t0
WHERE
  t0.parent_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.parent_id AS parent_id_4, t0.lvl AS lvl_5, t0.sort_order AS sort_order_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.visibility AS visibility_11, t0.created_at AS created_at_12, t0.edited_at AS edited_at_13, t0.last_check_at AS last_check_at_14, t0.next_check_at AS next_check_at_15 FROM cms_menu t0 WHERE t0.parent_id = 0 LIMIT 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_.created_at AS created_at_6,
  c0_.edited_at AS edited_at_7,
  c0_.last_check_at AS last_check_at_8,
  c0_.next_check_at AS next_check_at_9
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_.created_at AS created_at_6, c0_.edited_at AS edited_at_7, c0_.last_check_at AS last_check_at_8, c0_.next_check_at AS next_check_at_9 FROM cms_option c0_ WHERE c0_.code IS NOT NULL AND c0_.visibility = 1;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      c0_.id AS id_0,
      c0_.name AS name_1,
      c0_.icon AS icon_2,
      c0_.teaser AS teaser_3,
      c0_.body AS body_4,
      c0_.published AS published_5,
      c0_.created_by AS created_by_6,
      c0_.priority AS priority_7,
      c0_.author AS author_8,
      c0_.published_from AS published_from_9,
      c0_.published_to AS published_to_10,
      c0_.slug AS slug_11,
      c0_.seo_title AS seo_title_12,
      c0_.metadata AS metadata_13,
      c0_.search AS search_14,
      c0_.category AS category_15,
      c0_.visibility AS visibility_16,
      c0_.created_at AS created_at_17,
      c0_.edited_at AS edited_at_18,
      c0_.last_check_at AS last_check_at_19,
      c0_.next_check_at AS next_check_at_20
    FROM
      cms_article c0_
    WHERE
      c0_.published = ?
      AND (
        (
          c0_.published_from < ?
          OR c0_.published_from IS NULL
        )
        AND (
          c0_.published_to > ?
          OR c0_.published_to IS NULL
        )
      )
  ) dctrn_result
LIMIT
  6 OFFSET 300

SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.icon AS icon_2, c0_.teaser AS teaser_3, c0_.body AS body_4, c0_.published AS published_5, c0_.created_by AS created_by_6, c0_.priority AS priority_7, c0_.author AS author_8, c0_.published_from AS published_from_9, c0_.published_to AS published_to_10, c0_.slug AS slug_11, c0_.seo_title AS seo_title_12, c0_.metadata AS metadata_13, c0_.search AS search_14, c0_.category AS category_15, c0_.visibility AS visibility_16, c0_.created_at AS created_at_17, c0_.edited_at AS edited_at_18, c0_.last_check_at AS last_check_at_19, c0_.next_check_at AS next_check_at_20 FROM cms_article c0_ WHERE c0_.published = 1 AND ((c0_.published_from < '2024-11-23 17:54:05' OR c0_.published_from IS NULL) AND (c0_.published_to > '2024-11-23 17:54:05' OR c0_.published_to IS NULL))) dctrn_result LIMIT 6 OFFSET 300;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.link AS link_3,
  t0.parent_id AS parent_id_4,
  t0.lvl AS lvl_5,
  t0.sort_order AS sort_order_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.visibility AS visibility_11,
  t0.created_at AS created_at_12,
  t0.edited_at AS edited_at_13,
  t0.last_check_at AS last_check_at_14,
  t0.next_check_at AS next_check_at_15
FROM
  cms_menu t0
WHERE
  t0.root_id = ?
ORDER BY
  t0.lvl ASC,
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.parent_id AS parent_id_4, t0.lvl AS lvl_5, t0.sort_order AS sort_order_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.visibility AS visibility_11, t0.created_at AS created_at_12, t0.edited_at AS edited_at_13, t0.last_check_at AS last_check_at_14, t0.next_check_at AS next_check_at_15 FROM cms_menu t0 WHERE t0.root_id = 1 ORDER BY t0.lvl ASC, t0.sort_order ASC;

"START TRANSACTION"

"START TRANSACTION";