Symfony Profiler

SELECT
  to_char(created_at, 'YYYY-MM') AS month_stat,
  COUNT(*) AS hits
FROM
  cms_stat
WHERE
  source_id = :source_id
  AND source_type = 'subpage'
GROUP BY
  month_stat

SELECT to_char(created_at,'YYYY-MM') AS month_stat, COUNT(*) AS hits 
            FROM cms_stat 
            WHERE source_id = 'homepage'
            AND source_type = 'subpage'
            GROUP BY month_stat
            ;

SELECT
  NEXTVAL('cms_stat_id_seq')

SELECT NEXTVAL('cms_stat_id_seq');

SELECT
  t0.name AS name_1,
  t0.perex AS perex_2,
  t0.content AS content_3,
  t0.lang AS lang_4,
  t0.module AS module_5,
  t0.action AS action_6,
  t0.params AS params_7,
  t0.type AS type_8,
  t0.sort_order AS sort_order_9,
  t0.description AS description_10,
  t0.id AS id_11,
  t0.visibility AS visibility_12,
  t0.created_at AS created_at_13,
  t0.edited_at AS edited_at_14,
  t0.last_check_at AS last_check_at_15,
  t0.next_check_at AS next_check_at_16
FROM
  cms_block t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.perex AS perex_2, t0.content AS content_3, t0.lang AS lang_4, t0.module AS module_5, t0.action AS action_6, t0.params AS params_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.description AS description_10, t0.id AS id_11, t0.visibility AS visibility_12, t0.created_at AS created_at_13, t0.edited_at AS edited_at_14, t0.last_check_at AS last_check_at_15, t0.next_check_at AS next_check_at_16 FROM cms_block t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.sort_order AS sort_order_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t0.lang AS lang_5,
  t0.place AS place_6,
  t0.page_id AS page_id_7,
  t0.block_id AS block_id_8
FROM
  cms_page_block t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.lang AS lang_5, t0.place AS place_6, t0.page_id AS page_id_7, t0.block_id AS block_id_8 FROM cms_page_block t0 WHERE t0.page_id = 5;

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 (94958, '2025-07-29 21:01:55', 'node-fetch/1.0 (+https://github.com/bitinn/node-fetch)', 'subpage', 'api_request', 'homepage', NULL, '/api/pages/5', 'Domovská stránka', NULL, 1, '2025-07-29 21:01:55', '2025-07-29 21:01:55', NULL);

SELECT
  t0.name AS name_1,
  t0.title AS title_2,
  t0.link_name AS link_name_3,
  t0.lvl AS lvl_4,
  t0.sort_order AS sort_order_5,
  t0.seo_id AS seo_id_6,
  t0.content AS content_7,
  t0.status AS status_8,
  t0.lang AS lang_9,
  t0.parent_id AS parent_id_10,
  t0.config_data AS config_data_11,
  t0.layout AS layout_12,
  t0.redirect_url AS redirect_url_13,
  t0.redirect_window AS redirect_window_14,
  t0.icon AS icon_15,
  t0.teaser AS teaser_16,
  t0.p_search AS p_search_17,
  t0.id AS id_18,
  t0.visibility AS visibility_19,
  t0.created_at AS created_at_20,
  t0.edited_at AS edited_at_21,
  t0.last_check_at AS last_check_at_22,
  t0.next_check_at AS next_check_at_23,
  t0.parent_id AS parent_id_24
FROM
  cms_page t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.title AS title_2, t0.link_name AS link_name_3, t0.lvl AS lvl_4, t0.sort_order AS sort_order_5, t0.seo_id AS seo_id_6, t0.content AS content_7, t0.status AS status_8, t0.lang AS lang_9, t0.parent_id AS parent_id_10, t0.config_data AS config_data_11, t0.layout AS layout_12, t0.redirect_url AS redirect_url_13, t0.redirect_window AS redirect_window_14, t0.icon AS icon_15, t0.teaser AS teaser_16, t0.p_search AS p_search_17, t0.id AS id_18, t0.visibility AS visibility_19, t0.created_at AS created_at_20, t0.edited_at AS edited_at_21, t0.last_check_at AS last_check_at_22, t0.next_check_at AS next_check_at_23, t0.parent_id AS parent_id_24 FROM cms_page t0 WHERE t0.id = 5 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.item_id AS item_id_2,
  t0.visibility AS visibility_3,
  t0.created_at AS created_at_4,
  t0.edited_at AS edited_at_5,
  t0.last_check_at AS last_check_at_6,
  t0.next_check_at AS next_check_at_7,
  t0.item_id AS item_id_8,
  t0.site_id AS site_id_9,
  t0.item_type
FROM
  cms_site_items t0
WHERE
  t0.item_id = ?
  AND t0.item_type IN ('page')

SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.visibility AS visibility_3, t0.created_at AS created_at_4, t0.edited_at AS edited_at_5, t0.last_check_at AS last_check_at_6, t0.next_check_at AS next_check_at_7, t0.item_id AS item_id_8, t0.site_id AS site_id_9, t0.item_type FROM cms_site_items t0 WHERE t0.item_id = 5 AND t0.item_type IN ('page');

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

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;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";