Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content AS content_3,
  t0.teaser AS teaser_4,
  t0.date_from AS date_from_5,
  t0.date_to AS date_to_6,
  t0.time_from AS time_from_7,
  t0.time_to AS time_to_8,
  t0.published_from AS published_from_9,
  t0.published_to AS published_to_10,
  t0.url_link AS url_link_11,
  t0.location AS location_12,
  t0.organizer AS organizer_13,
  t0.phone AS phone_14,
  t0.email AS email_15,
  t0.published AS published_16,
  t0.slug AS slug_17,
  t0.contact_person AS contact_person_18,
  t0.created_by AS created_by_19,
  t0.icon AS icon_20,
  t0.category AS category_21,
  t0.e_search AS e_search_22,
  t0.visibility AS visibility_23,
  t0.created_at AS created_at_24,
  t0.edited_at AS edited_at_25,
  t0.last_check_at AS last_check_at_26,
  t0.next_check_at AS next_check_at_27
FROM
  cms_event t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.teaser AS teaser_4, t0.date_from AS date_from_5, t0.date_to AS date_to_6, t0.time_from AS time_from_7, t0.time_to AS time_to_8, t0.published_from AS published_from_9, t0.published_to AS published_to_10, t0.url_link AS url_link_11, t0.location AS location_12, t0.organizer AS organizer_13, t0.phone AS phone_14, t0.email AS email_15, t0.published AS published_16, t0.slug AS slug_17, t0.contact_person AS contact_person_18, t0.created_by AS created_by_19, t0.icon AS icon_20, t0.category AS category_21, t0.e_search AS e_search_22, t0.visibility AS visibility_23, t0.created_at AS created_at_24, t0.edited_at AS edited_at_25, t0.last_check_at AS last_check_at_26, t0.next_check_at AS next_check_at_27 FROM cms_event t0 WHERE t0.id = 19 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 ('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 = 19 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 = '5-inspire-espus-workshop'
            AND source_type = 'score_public_events_detail'
            GROUP BY month_stat
            ;

SELECT
  NEXTVAL('cms_stat_id_seq')

SELECT NEXTVAL('cms_stat_id_seq');

"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,
  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 (95250, '2025-08-02 20:36:53', 'node-fetch/1.0 (+https://github.com/bitinn/node-fetch)', 'score_public_events_detail', 'api_request', '5-inspire-espus-workshop', NULL, '/api/events/19', '5.INSPIRE ESPUS Workshop', NULL, 1, '2025-08-02 20:36:53', '2025-08-02 20:36:53', NULL);

"COMMIT"

"COMMIT";