Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.content AS content_2,
  c0_.teaser AS teaser_3,
  c0_.date_from AS date_from_4,
  c0_.date_to AS date_to_5,
  c0_.time_from AS time_from_6,
  c0_.time_to AS time_to_7,
  c0_.published_from AS published_from_8,
  c0_.published_to AS published_to_9,
  c0_.url_link AS url_link_10,
  c0_.location AS location_11,
  c0_.organizer AS organizer_12,
  c0_.phone AS phone_13,
  c0_.email AS email_14,
  c0_.published AS published_15,
  c0_.slug AS slug_16,
  c0_.contact_person AS contact_person_17,
  c0_.created_by AS created_by_18,
  c0_.icon AS icon_19,
  c0_.category AS category_20,
  c0_.e_search AS e_search_21,
  c0_.visibility AS visibility_22,
  c0_.created_at AS created_at_23,
  c0_.edited_at AS edited_at_24,
  c0_.last_check_at AS last_check_at_25,
  c0_.next_check_at AS next_check_at_26
FROM
  cms_event c0_
  LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id
  AND c1_.item_type IN ('event')
  LEFT JOIN cms_language_info c2_ ON (
    c0_.id = c2_.entity_id
    AND c2_.entity_name = 'Event'
  )
WHERE
  c1_.site_id = ?
ORDER BY
  c0_.date_from DESC
LIMIT
  10

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.content AS content_2, c0_.teaser AS teaser_3, c0_.date_from AS date_from_4, c0_.date_to AS date_to_5, c0_.time_from AS time_from_6, c0_.time_to AS time_to_7, c0_.published_from AS published_from_8, c0_.published_to AS published_to_9, c0_.url_link AS url_link_10, c0_.location AS location_11, c0_.organizer AS organizer_12, c0_.phone AS phone_13, c0_.email AS email_14, c0_.published AS published_15, c0_.slug AS slug_16, c0_.contact_person AS contact_person_17, c0_.created_by AS created_by_18, c0_.icon AS icon_19, c0_.category AS category_20, c0_.e_search AS e_search_21, c0_.visibility AS visibility_22, c0_.created_at AS created_at_23, c0_.edited_at AS edited_at_24, c0_.last_check_at AS last_check_at_25, c0_.next_check_at AS next_check_at_26 FROM cms_event c0_ LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id AND c1_.item_type IN ('event') LEFT JOIN cms_language_info c2_ ON (c0_.id = c2_.entity_id AND c2_.entity_name = 'Event') WHERE c1_.site_id = '1' ORDER BY c0_.date_from DESC LIMIT 10;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  cms_event c0_
  LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id
  AND c1_.item_type IN ('event')
  LEFT JOIN cms_language_info c2_ ON (
    c0_.id = c2_.entity_id
    AND c2_.entity_name = 'Event'
  )
WHERE
  c1_.site_id = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM cms_event c0_ LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id AND c1_.item_type IN ('event') LEFT JOIN cms_language_info c2_ ON (c0_.id = c2_.entity_id AND c2_.entity_name = 'Event') WHERE c1_.site_id = '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 ('event')

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

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
  to_char(created_at, 'YYYY-MM') AS month_stat,
  COUNT(*) AS hits
FROM
  cms_stat
WHERE
  source_id = :source_id
  AND source_type = 'score_public_events_detail'
GROUP BY
  month_stat

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

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 ('event')

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

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

SELECT to_char(created_at,'YYYY-MM') AS month_stat, COUNT(*) AS hits 
            FROM cms_stat 
            WHERE source_id = 'hvd-inspire-ps-lepsie-data'
            AND source_type = 'score_public_events_detail'
            GROUP BY month_stat
            ;

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 ('event')

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

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

SELECT to_char(created_at,'YYYY-MM') AS month_stat, COUNT(*) AS hits 
            FROM cms_stat 
            WHERE source_id = 'inspire-hvd-mig-workshop'
            AND source_type = 'score_public_events_detail'
            GROUP BY month_stat
            ;

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 ('event')

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

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

SELECT to_char(created_at,'YYYY-MM') AS month_stat, COUNT(*) AS hits 
            FROM cms_stat 
            WHERE source_id = '25-inspire-espus-skolenie'
            AND source_type = 'score_public_events_detail'
            GROUP BY month_stat
            ;

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 ('event')

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

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

SELECT to_char(created_at,'YYYY-MM') AS month_stat, COUNT(*) AS hits 
            FROM cms_stat 
            WHERE source_id = '24-inspire-espus-skolenie'
            AND source_type = 'score_public_events_detail'
            GROUP BY month_stat
            ;

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 ('event')

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

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

SELECT to_char(created_at,'YYYY-MM') AS month_stat, COUNT(*) AS hits 
            FROM cms_stat 
            WHERE source_id = '23-inspire-espus-skolenie'
            AND source_type = 'score_public_events_detail'
            GROUP BY month_stat
            ;

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 ('event')

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

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

SELECT to_char(created_at,'YYYY-MM') AS month_stat, COUNT(*) AS hits 
            FROM cms_stat 
            WHERE source_id = '22-inspire-espus-skolenie'
            AND source_type = 'score_public_events_detail'
            GROUP BY month_stat
            ;

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 ('event')

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

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

SELECT to_char(created_at,'YYYY-MM') AS month_stat, COUNT(*) AS hits 
            FROM cms_stat 
            WHERE source_id = '21-inspire-espus-skolenie'
            AND source_type = 'score_public_events_detail'
            GROUP BY month_stat
            ;

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 ('event')

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

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

SELECT to_char(created_at,'YYYY-MM') AS month_stat, COUNT(*) AS hits 
            FROM cms_stat 
            WHERE source_id = '20-inspire-espus-skolenie'
            AND source_type = 'score_public_events_detail'
            GROUP BY month_stat
            ;

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 ('event')

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

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

SELECT to_char(created_at,'YYYY-MM') AS month_stat, COUNT(*) AS hits 
            FROM cms_stat 
            WHERE source_id = '19-inspire-espus-skolenie'
            AND source_type = 'score_public_events_detail'
            GROUP BY month_stat
            ;