Symfony Profiler

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.publicationStartsAt AS publicationStartsAt_1
FROM
  article a0_
WHERE
  a0_.status = ?
  AND a0_.publicationStartsAt < ?
ORDER BY
  a0_.publicationStartsAt DESC
LIMIT
  12
OFFSET
  528

SELECT DISTINCT a0_.id AS id_0, a0_.publicationStartsAt AS publicationStartsAt_1 FROM article a0_ WHERE a0_.status = 'published' AND a0_.publicationStartsAt < '2026-07-05 15:24:53' ORDER BY a0_.publicationStartsAt DESC LIMIT 12 OFFSET 528;

SELECT
  t0.id AS id_1,
  t0.facebookConnection_pageId AS facebookConnection_pageId_2,
  t0.facebookConnection_token AS facebookConnection_token_3,
  t0.team_id AS team_id_4,
  t0.seasonSettings_id AS seasonSettings_id_5,
  t0.selection_id AS selection_id_6
FROM
  settings t0
WHERE
  t0.selection_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.facebookConnection_pageId AS facebookConnection_pageId_2, t0.facebookConnection_token AS facebookConnection_token_3, t0.team_id AS team_id_4, t0.seasonSettings_id AS seasonSettings_id_5, t0.selection_id AS selection_id_6 FROM settings t0 WHERE t0.selection_id = 1 LIMIT 1;

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
WHERE
  a0_.status = ?
  AND a0_.publicationStartsAt < ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.status = 'published' AND a0_.publicationStartsAt < '2026-07-05 15:24:53';

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.rounds AS rounds_3,
  t0.sort AS sort_4,
  t0.season_year AS season_year_5,
  t0.season_startYear AS season_startYear_6,
  t0.season_endYear AS season_endYear_7,
  t0.competition_id AS competition_id_8
FROM
  football_competition_execution t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.year AS year_2, t0.rounds AS rounds_3, t0.sort AS sort_4, t0.season_year AS season_year_5, t0.season_startYear AS season_startYear_6, t0.season_endYear AS season_endYear_7, t0.competition_id AS competition_id_8 FROM football_competition_execution t0 WHERE t0.id = 59;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.description AS description_2,
  a0_.body AS body_3,
  a0_.status AS status_4,
  a0_.createdAt AS createdAt_5,
  a0_.thumbnail AS thumbnail_6,
  a0_.publicationStartsAt AS publicationStartsAt_7,
  a0_.media AS media_8,
  a0_.youtubeVideos AS youtubeVideos_9,
  a0_.facebookGallery AS facebookGallery_10,
  a0_.category_id AS category_id_11
FROM
  article a0_
WHERE
  a0_.status = ?
  AND a0_.publicationStartsAt < ?
  AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.publicationStartsAt DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.body AS body_3, a0_.status AS status_4, a0_.createdAt AS createdAt_5, a0_.thumbnail AS thumbnail_6, a0_.publicationStartsAt AS publicationStartsAt_7, a0_.media AS media_8, a0_.youtubeVideos AS youtubeVideos_9, a0_.facebookGallery AS facebookGallery_10, a0_.category_id AS category_id_11 FROM article a0_ WHERE a0_.status = 'published' AND a0_.publicationStartsAt < '2026-07-05 15:24:53' AND a0_.id IN (446, 445, 444, 443, 442, 441, 440, 439, 438, 437, 436, 435) ORDER BY a0_.publicationStartsAt DESC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.url AS url_2,
  s0_.logo AS logo_3,
  s0_.position AS position_4,
  s0_.exposed AS exposed_5,
  s0_.active AS active_6
FROM
  sponsor s0_
WHERE
  s0_.active = ?
  AND s0_.exposed = ?
ORDER BY
  s0_.position ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.url AS url_2, s0_.logo AS logo_3, s0_.position AS position_4, s0_.exposed AS exposed_5, s0_.active AS active_6 FROM sponsor s0_ WHERE s0_.active = 1 AND s0_.exposed = 1 ORDER BY s0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.currentSeason_year AS currentSeason_year_2,
  t0.currentSeason_startYear AS currentSeason_startYear_3,
  t0.currentSeason_endYear AS currentSeason_endYear_4,
  t0.firstSeason_year AS firstSeason_year_5,
  t0.firstSeason_startYear AS firstSeason_startYear_6,
  t0.firstSeason_endYear AS firstSeason_endYear_7,
  t0.currentSeasonTeam_id AS currentSeasonTeam_id_8,
  t0.mainCompetitionExecution_id AS mainCompetitionExecution_id_9
FROM
  settings_season t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.currentSeason_year AS currentSeason_year_2, t0.currentSeason_startYear AS currentSeason_startYear_3, t0.currentSeason_endYear AS currentSeason_endYear_4, t0.firstSeason_year AS firstSeason_year_5, t0.firstSeason_startYear AS firstSeason_startYear_6, t0.firstSeason_endYear AS firstSeason_endYear_7, t0.currentSeasonTeam_id AS currentSeasonTeam_id_8, t0.mainCompetitionExecution_id AS mainCompetitionExecution_id_9 FROM settings_season t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.shortName AS shortName_4,
  t0.settings_overtime AS settings_overtime_5,
  t0.settings_penalties AS settings_penalties_6,
  t0.logos_id AS logos_id_7
FROM
  football_competition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.shortName AS shortName_4, t0.settings_overtime AS settings_overtime_5, t0.settings_penalties AS settings_penalties_6, t0.logos_id AS logos_id_7 FROM football_competition t0 WHERE t0.id = 9;

SELECT
  f0_.id AS id_0,
  f0_.year AS year_1,
  f0_.rounds AS rounds_2,
  f0_.sort AS sort_3,
  f0_.season_year AS season_year_4,
  f0_.season_startYear AS season_startYear_5,
  f0_.season_endYear AS season_endYear_6,
  f0_.competition_id AS competition_id_7
FROM
  football_competition_execution f0_
WHERE
  f0_.season_year = ?
ORDER BY
  f0_.sort ASC

SELECT f0_.id AS id_0, f0_.year AS year_1, f0_.rounds AS rounds_2, f0_.sort AS sort_3, f0_.season_year AS season_year_4, f0_.season_startYear AS season_startYear_5, f0_.season_endYear AS season_endYear_6, f0_.competition_id AS competition_id_7 FROM football_competition_execution f0_ WHERE f0_.season_year = 2026 ORDER BY f0_.sort ASC;