Symfony Profiler

SELECT
  e0_.id_eventtype AS id_eventtype_0,
  e0_.eventtype_name AS eventtype_name_1
FROM
  eventtypes e0_
ORDER BY
  e0_.id_eventtype ASC

SELECT e0_.id_eventtype AS id_eventtype_0, e0_.eventtype_name AS eventtype_name_1 FROM eventtypes e0_ ORDER BY e0_.id_eventtype ASC;

SELECT
  g0_.id_group AS id_group_0,
  g0_.groupname AS groupname_1,
  g0_.description AS description_2
FROM
groups
  g0_
WHERE
  g0_.has_site = 1
ORDER BY
  g0_.groupname ASC

SELECT g0_.id_group AS id_group_0, g0_.groupname AS groupname_1, g0_.description AS description_2 FROM groups g0_ WHERE g0_.has_site = 1 ORDER BY g0_.groupname ASC;

SELECT
  MONTH(e0_.start_on) AS sclr_0,
  YEAR(e0_.start_on) AS sclr_1,
  e0_.id_event AS id_event_2,
  e0_.title AS title_3,
  e0_.shorttitle AS shorttitle_4,
  e0_.id_eventtype AS id_eventtype_5,
  e0_.start_on AS start_on_6,
  e0_.end_on AS end_on_7,
  e0_.summary AS summary_8,
  e0_.city AS city_9,
  c1_.country AS country_10,
  e0_.is_open AS is_open_11,
  e0_.status AS status_12
FROM
  events e0_
  LEFT JOIN countries c1_ ON (c1_.id_country = e0_.id_country)
  LEFT JOIN event_groups e2_ ON (e2_.id_event = e0_.id_event)
  LEFT JOIN event_labels e3_ ON (
    e3_.id_event = e0_.id_event
    AND e3_.id_group = e2_.id_group
  )
WHERE
  e0_.status = 1
  AND (
    (
      (
        e0_.start_on BETWEEN ?
        AND ?
      )
      OR (
        e0_.end_on BETWEEN ?
        AND ?
      )
    )
    OR (
      (e0_.start_on < ?)
      AND (e0_.end_on > ?)
    )
  )
  AND e0_.status = 1
GROUP BY
  e0_.id_event
ORDER BY
  e0_.start_on ASC

SELECT MONTH(e0_.start_on) AS sclr_0, YEAR(e0_.start_on) AS sclr_1, e0_.id_event AS id_event_2, e0_.title AS title_3, e0_.shorttitle AS shorttitle_4, e0_.id_eventtype AS id_eventtype_5, e0_.start_on AS start_on_6, e0_.end_on AS end_on_7, e0_.summary AS summary_8, e0_.city AS city_9, c1_.country AS country_10, e0_.is_open AS is_open_11, e0_.status AS status_12 FROM events e0_ LEFT JOIN countries c1_ ON (c1_.id_country = e0_.id_country) LEFT JOIN event_groups e2_ ON (e2_.id_event = e0_.id_event) LEFT JOIN event_labels e3_ ON (e3_.id_event = e0_.id_event AND e3_.id_group = e2_.id_group) WHERE e0_.status = 1 AND (((e0_.start_on BETWEEN '2026-06-25' AND '2026-09-30') OR (e0_.end_on BETWEEN '2026-06-25' AND '2026-09-30')) OR ((e0_.start_on < '2026-09-30') AND (e0_.end_on > '2026-06-25'))) AND e0_.status = 1 GROUP BY e0_.id_event ORDER BY e0_.start_on ASC;

SELECT
  DISTINCT (
    YEAR(e0_.start_on)
  ) AS sclr_0
FROM
  events e0_
WHERE
  e0_.start_on <> 0
  AND e0_.status = 1
ORDER BY
  e0_.start_on ASC

SELECT DISTINCT (YEAR(e0_.start_on)) AS sclr_0 FROM events e0_ WHERE e0_.start_on <> 0 AND e0_.status = 1 ORDER BY e0_.start_on ASC;

SELECT
  count(e0_.id_ind) AS sclr_0
FROM
  event_participants e0_
WHERE
  e0_.id_event = ?
  AND e0_.status <> 3

SELECT count(e0_.id_ind) AS sclr_0 FROM event_participants e0_ WHERE e0_.id_event = 4020 AND e0_.status <> 3;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_presentations e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_presentations e0_ WHERE e0_.id_event = 4020;

SELECT
  count(a0_.id_doc) AS sclr_0
FROM
  agendaitem_documents a0_
WHERE
  a0_.id_event = ?

SELECT count(a0_.id_doc) AS sclr_0 FROM agendaitem_documents a0_ WHERE a0_.id_event = 4020;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_backgrounddocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_backgrounddocs e0_ WHERE e0_.id_event = 4020;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_otherdocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_otherdocs e0_ WHERE e0_.id_event = 4020;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_reports e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_reports e0_ WHERE e0_.id_event = 4020;

SELECT
  count(e0_.id_ind) AS sclr_0
FROM
  event_participants e0_
WHERE
  e0_.id_event = ?
  AND e0_.status <> 3

SELECT count(e0_.id_ind) AS sclr_0 FROM event_participants e0_ WHERE e0_.id_event = 4834 AND e0_.status <> 3;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_presentations e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_presentations e0_ WHERE e0_.id_event = 4834;

SELECT
  count(a0_.id_doc) AS sclr_0
FROM
  agendaitem_documents a0_
WHERE
  a0_.id_event = ?

SELECT count(a0_.id_doc) AS sclr_0 FROM agendaitem_documents a0_ WHERE a0_.id_event = 4834;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_backgrounddocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_backgrounddocs e0_ WHERE e0_.id_event = 4834;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_otherdocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_otherdocs e0_ WHERE e0_.id_event = 4834;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_reports e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_reports e0_ WHERE e0_.id_event = 4834;

SELECT
  count(e0_.id_ind) AS sclr_0
FROM
  event_participants e0_
WHERE
  e0_.id_event = ?
  AND e0_.status <> 3

SELECT count(e0_.id_ind) AS sclr_0 FROM event_participants e0_ WHERE e0_.id_event = 4861 AND e0_.status <> 3;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_presentations e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_presentations e0_ WHERE e0_.id_event = 4861;

SELECT
  count(a0_.id_doc) AS sclr_0
FROM
  agendaitem_documents a0_
WHERE
  a0_.id_event = ?

SELECT count(a0_.id_doc) AS sclr_0 FROM agendaitem_documents a0_ WHERE a0_.id_event = 4861;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_backgrounddocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_backgrounddocs e0_ WHERE e0_.id_event = 4861;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_otherdocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_otherdocs e0_ WHERE e0_.id_event = 4861;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_reports e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_reports e0_ WHERE e0_.id_event = 4861;

SELECT
  count(e0_.id_ind) AS sclr_0
FROM
  event_participants e0_
WHERE
  e0_.id_event = ?
  AND e0_.status <> 3

SELECT count(e0_.id_ind) AS sclr_0 FROM event_participants e0_ WHERE e0_.id_event = 4857 AND e0_.status <> 3;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_presentations e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_presentations e0_ WHERE e0_.id_event = 4857;

SELECT
  count(a0_.id_doc) AS sclr_0
FROM
  agendaitem_documents a0_
WHERE
  a0_.id_event = ?

SELECT count(a0_.id_doc) AS sclr_0 FROM agendaitem_documents a0_ WHERE a0_.id_event = 4857;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_backgrounddocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_backgrounddocs e0_ WHERE e0_.id_event = 4857;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_otherdocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_otherdocs e0_ WHERE e0_.id_event = 4857;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_reports e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_reports e0_ WHERE e0_.id_event = 4857;

SELECT
  count(e0_.id_ind) AS sclr_0
FROM
  event_participants e0_
WHERE
  e0_.id_event = ?
  AND e0_.status <> 3

SELECT count(e0_.id_ind) AS sclr_0 FROM event_participants e0_ WHERE e0_.id_event = 4858 AND e0_.status <> 3;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_presentations e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_presentations e0_ WHERE e0_.id_event = 4858;

SELECT
  count(a0_.id_doc) AS sclr_0
FROM
  agendaitem_documents a0_
WHERE
  a0_.id_event = ?

SELECT count(a0_.id_doc) AS sclr_0 FROM agendaitem_documents a0_ WHERE a0_.id_event = 4858;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_backgrounddocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_backgrounddocs e0_ WHERE e0_.id_event = 4858;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_otherdocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_otherdocs e0_ WHERE e0_.id_event = 4858;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_reports e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_reports e0_ WHERE e0_.id_event = 4858;

SELECT
  count(e0_.id_ind) AS sclr_0
FROM
  event_participants e0_
WHERE
  e0_.id_event = ?
  AND e0_.status <> 3

SELECT count(e0_.id_ind) AS sclr_0 FROM event_participants e0_ WHERE e0_.id_event = 4929 AND e0_.status <> 3;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_presentations e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_presentations e0_ WHERE e0_.id_event = 4929;

SELECT
  count(a0_.id_doc) AS sclr_0
FROM
  agendaitem_documents a0_
WHERE
  a0_.id_event = ?

SELECT count(a0_.id_doc) AS sclr_0 FROM agendaitem_documents a0_ WHERE a0_.id_event = 4929;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_backgrounddocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_backgrounddocs e0_ WHERE e0_.id_event = 4929;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_otherdocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_otherdocs e0_ WHERE e0_.id_event = 4929;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_reports e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_reports e0_ WHERE e0_.id_event = 4929;

SELECT
  count(e0_.id_ind) AS sclr_0
FROM
  event_participants e0_
WHERE
  e0_.id_event = ?
  AND e0_.status <> 3

SELECT count(e0_.id_ind) AS sclr_0 FROM event_participants e0_ WHERE e0_.id_event = 4930 AND e0_.status <> 3;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_presentations e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_presentations e0_ WHERE e0_.id_event = 4930;

SELECT
  count(a0_.id_doc) AS sclr_0
FROM
  agendaitem_documents a0_
WHERE
  a0_.id_event = ?

SELECT count(a0_.id_doc) AS sclr_0 FROM agendaitem_documents a0_ WHERE a0_.id_event = 4930;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_backgrounddocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_backgrounddocs e0_ WHERE e0_.id_event = 4930;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_otherdocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_otherdocs e0_ WHERE e0_.id_event = 4930;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_reports e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_reports e0_ WHERE e0_.id_event = 4930;

SELECT
  count(e0_.id_ind) AS sclr_0
FROM
  event_participants e0_
WHERE
  e0_.id_event = ?
  AND e0_.status <> 3

SELECT count(e0_.id_ind) AS sclr_0 FROM event_participants e0_ WHERE e0_.id_event = 4958 AND e0_.status <> 3;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_presentations e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_presentations e0_ WHERE e0_.id_event = 4958;

SELECT
  count(a0_.id_doc) AS sclr_0
FROM
  agendaitem_documents a0_
WHERE
  a0_.id_event = ?

SELECT count(a0_.id_doc) AS sclr_0 FROM agendaitem_documents a0_ WHERE a0_.id_event = 4958;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_backgrounddocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_backgrounddocs e0_ WHERE e0_.id_event = 4958;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_otherdocs e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_otherdocs e0_ WHERE e0_.id_event = 4958;

SELECT
  count(e0_.id_doc) AS sclr_0
FROM
  event_reports e0_
WHERE
  e0_.id_event = ?

SELECT count(e0_.id_doc) AS sclr_0 FROM event_reports e0_ WHERE e0_.id_event = 4958;