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 = 'score_public_articles_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-info-newsletter'
            AND source_type = 'score_public_articles_detail'
            GROUP BY month_stat
            ;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.teaser AS teaser_4,
  t0.body AS body_5,
  t0.published AS published_6,
  t0.created_by AS created_by_7,
  t0.priority AS priority_8,
  t0.author AS author_9,
  t0.published_from AS published_from_10,
  t0.published_to AS published_to_11,
  t0.slug AS slug_12,
  t0.seo_title AS seo_title_13,
  t0.metadata AS metadata_14,
  t0.search AS search_15,
  t0.category AS category_16,
  t0.visibility AS visibility_17,
  t0.created_at AS created_at_18,
  t0.edited_at AS edited_at_19,
  t0.last_check_at AS last_check_at_20,
  t0.next_check_at AS next_check_at_21
FROM
  cms_article t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.teaser AS teaser_4, t0.body AS body_5, t0.published AS published_6, t0.created_by AS created_by_7, t0.priority AS priority_8, t0.author AS author_9, t0.published_from AS published_from_10, t0.published_to AS published_to_11, t0.slug AS slug_12, t0.seo_title AS seo_title_13, t0.metadata AS metadata_14, t0.search AS search_15, t0.category AS category_16, t0.visibility AS visibility_17, t0.created_at AS created_at_18, t0.edited_at AS edited_at_19, t0.last_check_at AS last_check_at_20, t0.next_check_at AS next_check_at_21 FROM cms_article t0 WHERE t0.id = 235 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 ('article')

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

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;

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 (89412, '2025-05-09 22:01:28', 'node-fetch/1.0 (+https://github.com/bitinn/node-fetch)', 'score_public_articles_detail', 'api_request', 'inspire-info-newsletter', NULL, '/api/articles/235', 'INSPIRE INFO newsletter', NULL, 1, '2025-05-09 22:01:28', '2025-05-09 22:01:28', NULL);

"COMMIT"

"COMMIT";

SELECT
  NEXTVAL('cms_stat_id_seq')

SELECT NEXTVAL('cms_stat_id_seq');

"START TRANSACTION"

"START TRANSACTION";