Symfony Profiler

SELECT
  c0_.name AS name_0,
  c0_.title AS title_1,
  c0_.link_name AS link_name_2,
  c0_.lvl AS lvl_3,
  c0_.sort_order AS sort_order_4,
  c0_.seo_id AS seo_id_5,
  c0_.content AS content_6,
  c0_.status AS status_7,
  c0_.lang AS lang_8,
  c0_.parent_id AS parent_id_9,
  c0_.config_data AS config_data_10,
  c0_.layout AS layout_11,
  c0_.redirect_url AS redirect_url_12,
  c0_.redirect_window AS redirect_window_13,
  c0_.icon AS icon_14,
  c0_.teaser AS teaser_15,
  c0_.p_search AS p_search_16,
  c0_.id AS id_17,
  c0_.visibility AS visibility_18,
  c0_.created_at AS created_at_19,
  c0_.edited_at AS edited_at_20,
  c0_.last_check_at AS last_check_at_21,
  c0_.next_check_at AS next_check_at_22,
  c0_.parent_id AS parent_id_23
FROM
  cms_page c0_
  LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id
  AND c1_.item_type IN ('page')
  LEFT JOIN cms_language_info c2_ ON (
    c0_.id = c2_.entity_id
    AND c2_.entity_name = 'Page'
  )
WHERE
  c0_.seo_id = ?
LIMIT
  20

SELECT c0_.name AS name_0, c0_.title AS title_1, c0_.link_name AS link_name_2, c0_.lvl AS lvl_3, c0_.sort_order AS sort_order_4, c0_.seo_id AS seo_id_5, c0_.content AS content_6, c0_.status AS status_7, c0_.lang AS lang_8, c0_.parent_id AS parent_id_9, c0_.config_data AS config_data_10, c0_.layout AS layout_11, c0_.redirect_url AS redirect_url_12, c0_.redirect_window AS redirect_window_13, c0_.icon AS icon_14, c0_.teaser AS teaser_15, c0_.p_search AS p_search_16, c0_.id AS id_17, c0_.visibility AS visibility_18, c0_.created_at AS created_at_19, c0_.edited_at AS edited_at_20, c0_.last_check_at AS last_check_at_21, c0_.next_check_at AS next_check_at_22, c0_.parent_id AS parent_id_23 FROM cms_page c0_ LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id AND c1_.item_type IN ('page') LEFT JOIN cms_language_info c2_ ON (c0_.id = c2_.entity_id AND c2_.entity_name = 'Page') WHERE c0_.seo_id = 'koordinacia/pracovne-skupiny' LIMIT 20;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  cms_page c0_
  LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id
  AND c1_.item_type IN ('page')
  LEFT JOIN cms_language_info c2_ ON (
    c0_.id = c2_.entity_id
    AND c2_.entity_name = 'Page'
  )
WHERE
  c0_.seo_id = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM cms_page c0_ LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id AND c1_.item_type IN ('page') LEFT JOIN cms_language_info c2_ ON (c0_.id = c2_.entity_id AND c2_.entity_name = 'Page') WHERE c0_.seo_id = 'koordinacia/pracovne-skupiny';

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;

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 = ?
  AND t0.visibility = ?
ORDER BY
  t0.id 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.parent_id = 6676 AND t0.visibility = 1 ORDER BY t0.id ASC;

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 = 68 AND t0.item_type IN ('page');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.visibility AS visibility_4,
  t0.created_at AS created_at_5,
  t0.edited_at AS edited_at_6,
  t0.last_check_at AS last_check_at_7,
  t0.next_check_at AS next_check_at_8
FROM
  cms_site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.visibility AS visibility_4, t0.created_at AS created_at_5, t0.edited_at AS edited_at_6, t0.last_check_at AS last_check_at_7, t0.next_check_at AS next_check_at_8 FROM cms_site t0 WHERE t0.id = 1;

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

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

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 = 'koordinacia/pracovne-skupiny'
            AND source_type = 'subpage'
            GROUP BY month_stat
            ;