Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.57 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.03 ms
(65.56%)

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.starts_at AS starts_at_4, e0_.ends_at AS ends_at_5, e0_.venue AS venue_6, e0_.address AS address_7, e0_.price AS price_8, e0_.external_link AS external_link_9, e0_.status AS status_10, e0_.created_at AS created_at_11, e0_.updated_at AS updated_at_12, e0_.deleted_at AS deleted_at_13, m1_.id AS id_14, m1_.original_name AS original_name_15, m1_.file_name AS file_name_16, m1_.mime_type AS mime_type_17, m1_.size AS size_18, m1_.width AS width_19, m1_.height AS height_20, m1_.duration_seconds AS duration_seconds_21, m1_.alt AS alt_22, m1_.created_at AS created_at_23, m1_.deleted_at AS deleted_at_24, e0_.poster_id AS poster_id_25, m1_.uploaded_by_id AS uploaded_by_id_26 FROM event e0_ LEFT JOIN media m1_ ON e0_.poster_id = m1_.id AND (m1_.deleted_at IS NULL) WHERE (e0_.status = ? AND COALESCE(e0_.ends_at, e0_.starts_at) >= ?) AND (e0_.deleted_at IS NULL) ORDER BY e0_.starts_at ASC LIMIT 20

Parameters:

[
  "PUBLISHED"
  "2026-08-07 03:10:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.slug AS slug_2,
  e0_.description AS description_3,
  e0_.starts_at AS starts_at_4,
  e0_.ends_at AS ends_at_5,
  e0_.venue AS venue_6,
  e0_.address AS address_7,
  e0_.price AS price_8,
  e0_.external_link AS external_link_9,
  e0_.status AS status_10,
  e0_.created_at AS created_at_11,
  e0_.updated_at AS updated_at_12,
  e0_.deleted_at AS deleted_at_13,
  m1_.id AS id_14,
  m1_.original_name AS original_name_15,
  m1_.file_name AS file_name_16,
  m1_.mime_type AS mime_type_17,
  m1_.size AS size_18,
  m1_.width AS width_19,
  m1_.height AS height_20,
  m1_.duration_seconds AS duration_seconds_21,
  m1_.alt AS alt_22,
  m1_.created_at AS created_at_23,
  m1_.deleted_at AS deleted_at_24,
  e0_.poster_id AS poster_id_25,
  m1_.uploaded_by_id AS uploaded_by_id_26
FROM
  event e0_
  LEFT JOIN media m1_ ON e0_.poster_id = m1_.id
  AND (m1_.deleted_at IS NULL)
WHERE
  (
    e0_.status = ?
    AND COALESCE(e0_.ends_at, e0_.starts_at) >= ?
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.starts_at ASC
LIMIT
  20

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.starts_at AS starts_at_4, e0_.ends_at AS ends_at_5, e0_.venue AS venue_6, e0_.address AS address_7, e0_.price AS price_8, e0_.external_link AS external_link_9, e0_.status AS status_10, e0_.created_at AS created_at_11, e0_.updated_at AS updated_at_12, e0_.deleted_at AS deleted_at_13, m1_.id AS id_14, m1_.original_name AS original_name_15, m1_.file_name AS file_name_16, m1_.mime_type AS mime_type_17, m1_.size AS size_18, m1_.width AS width_19, m1_.height AS height_20, m1_.duration_seconds AS duration_seconds_21, m1_.alt AS alt_22, m1_.created_at AS created_at_23, m1_.deleted_at AS deleted_at_24, e0_.poster_id AS poster_id_25, m1_.uploaded_by_id AS uploaded_by_id_26 FROM event e0_ LEFT JOIN media m1_ ON e0_.poster_id = m1_.id AND (m1_.deleted_at IS NULL) WHERE (e0_.status = 'PUBLISHED' AND COALESCE(e0_.ends_at, e0_.starts_at) >= '2026-08-07 03:10:59') AND (e0_.deleted_at IS NULL) ORDER BY e0_.starts_at ASC LIMIT 20;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\EventRepository->findUpcomingEvents (line 46)
7	App\Controller\Site\EventController->index (line 26)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.54 ms
(34.44%)

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.starts_at AS starts_at_4, e0_.ends_at AS ends_at_5, e0_.venue AS venue_6, e0_.address AS address_7, e0_.price AS price_8, e0_.external_link AS external_link_9, e0_.status AS status_10, e0_.created_at AS created_at_11, e0_.updated_at AS updated_at_12, e0_.deleted_at AS deleted_at_13, m1_.id AS id_14, m1_.original_name AS original_name_15, m1_.file_name AS file_name_16, m1_.mime_type AS mime_type_17, m1_.size AS size_18, m1_.width AS width_19, m1_.height AS height_20, m1_.duration_seconds AS duration_seconds_21, m1_.alt AS alt_22, m1_.created_at AS created_at_23, m1_.deleted_at AS deleted_at_24, e0_.poster_id AS poster_id_25, m1_.uploaded_by_id AS uploaded_by_id_26 FROM event e0_ LEFT JOIN media m1_ ON e0_.poster_id = m1_.id AND (m1_.deleted_at IS NULL) WHERE (e0_.status = ? AND COALESCE(e0_.ends_at, e0_.starts_at) < ?) AND (e0_.deleted_at IS NULL) ORDER BY e0_.starts_at DESC LIMIT 6

Parameters:

[
  "PUBLISHED"
  "2026-08-07 03:10:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.slug AS slug_2,
  e0_.description AS description_3,
  e0_.starts_at AS starts_at_4,
  e0_.ends_at AS ends_at_5,
  e0_.venue AS venue_6,
  e0_.address AS address_7,
  e0_.price AS price_8,
  e0_.external_link AS external_link_9,
  e0_.status AS status_10,
  e0_.created_at AS created_at_11,
  e0_.updated_at AS updated_at_12,
  e0_.deleted_at AS deleted_at_13,
  m1_.id AS id_14,
  m1_.original_name AS original_name_15,
  m1_.file_name AS file_name_16,
  m1_.mime_type AS mime_type_17,
  m1_.size AS size_18,
  m1_.width AS width_19,
  m1_.height AS height_20,
  m1_.duration_seconds AS duration_seconds_21,
  m1_.alt AS alt_22,
  m1_.created_at AS created_at_23,
  m1_.deleted_at AS deleted_at_24,
  e0_.poster_id AS poster_id_25,
  m1_.uploaded_by_id AS uploaded_by_id_26
FROM
  event e0_
  LEFT JOIN media m1_ ON e0_.poster_id = m1_.id
  AND (m1_.deleted_at IS NULL)
WHERE
  (
    e0_.status = ?
    AND COALESCE(e0_.ends_at, e0_.starts_at) < ?
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.starts_at DESC
LIMIT
  6

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.starts_at AS starts_at_4, e0_.ends_at AS ends_at_5, e0_.venue AS venue_6, e0_.address AS address_7, e0_.price AS price_8, e0_.external_link AS external_link_9, e0_.status AS status_10, e0_.created_at AS created_at_11, e0_.updated_at AS updated_at_12, e0_.deleted_at AS deleted_at_13, m1_.id AS id_14, m1_.original_name AS original_name_15, m1_.file_name AS file_name_16, m1_.mime_type AS mime_type_17, m1_.size AS size_18, m1_.width AS width_19, m1_.height AS height_20, m1_.duration_seconds AS duration_seconds_21, m1_.alt AS alt_22, m1_.created_at AS created_at_23, m1_.deleted_at AS deleted_at_24, e0_.poster_id AS poster_id_25, m1_.uploaded_by_id AS uploaded_by_id_26 FROM event e0_ LEFT JOIN media m1_ ON e0_.poster_id = m1_.id AND (m1_.deleted_at IS NULL) WHERE (e0_.status = 'PUBLISHED' AND COALESCE(e0_.ends_at, e0_.starts_at) < '2026-08-07 03:10:59') AND (e0_.deleted_at IS NULL) ORDER BY e0_.starts_at DESC LIMIT 6;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\EventRepository->findPastEvents (line 67)
7	App\Controller\Site\EventController->index (line 27)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Event	3

Entities Mapping

Class	Mapping errors
App\Entity\Event	No errors.
App\Entity\Media	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://edec.espacedjago.com/agenda

Configuration Settings

Theme

Page Width