Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.47 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.02 ms

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.code AS code_2, e0_.event_start_at AS event_start_at_3, e0_.event_end_at AS event_end_at_4, e0_.description AS description_5, e0_.reservation AS reservation_6, e0_.is_active AS is_active_7, e0_.is_canceled AS is_canceled_8, e0_.is_archived AS is_archived_9, e0_.is_public AS is_public_10, e0_.access_code AS access_code_11, e0_.created_at AS created_at_12, e0_.updated_at AS updated_at_13, a1_.id AS id_14, a1_.name AS name_15, a1_.code AS code_16, a1_.start_at AS start_at_17, a1_.end_at AS end_at_18, a1_.registration_start_at AS registration_start_at_19, a1_.registration_end_at AS registration_end_at_20, a1_.description AS description_21, a1_.document AS document_22, a1_.orchestra AS orchestra_23, a1_.price AS price_24, a1_.price_child AS price_child_25, a1_.reservation AS reservation_26, a1_.observations AS observations_27, a1_.is_canceled AS is_canceled_28, a1_.is_public AS is_public_29, a1_.access_code AS access_code_30, a1_.max_capacity AS max_capacity_31, a1_.created_at AS created_at_32, a1_.updated_at AS updated_at_33, p2_.id AS id_34, p2_.name AS name_35, p2_.address AS address_36, p2_.capacity AS capacity_37, p2_.created_at AS created_at_38, p2_.updated_at AS updated_at_39, a1_.event_id AS event_id_40, a1_.form_id AS form_id_41, a1_.place_id AS place_id_42 FROM event e0_ LEFT JOIN activity a1_ ON e0_.id = a1_.event_id LEFT JOIN place p2_ ON a1_.place_id = p2_.id WHERE e0_.is_archived = ? AND COALESCE(e0_.event_end_at, e0_.event_start_at) >= ? AND (e0_.description IS NOT NULL AND e0_.description <> '') AND ((e0_.is_public = ?) OR (EXISTS (SELECT 1 AS sclr_43 FROM activity a3_ WHERE a3_.event_id = e0_.id AND a3_.is_public = ? AND a3_.description IS NOT NULL AND a3_.description <> ''))) ORDER BY e0_.event_start_at ASC

Parameters:

[
  0
  "2026-06-28 00:00:00"
  1
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.code AS code_2,
  e0_.event_start_at AS event_start_at_3,
  e0_.event_end_at AS event_end_at_4,
  e0_.description AS description_5,
  e0_.reservation AS reservation_6,
  e0_.is_active AS is_active_7,
  e0_.is_canceled AS is_canceled_8,
  e0_.is_archived AS is_archived_9,
  e0_.is_public AS is_public_10,
  e0_.access_code AS access_code_11,
  e0_.created_at AS created_at_12,
  e0_.updated_at AS updated_at_13,
  a1_.id AS id_14,
  a1_.name AS name_15,
  a1_.code AS code_16,
  a1_.start_at AS start_at_17,
  a1_.end_at AS end_at_18,
  a1_.registration_start_at AS registration_start_at_19,
  a1_.registration_end_at AS registration_end_at_20,
  a1_.description AS description_21,
  a1_.document AS document_22,
  a1_.orchestra AS orchestra_23,
  a1_.price AS price_24,
  a1_.price_child AS price_child_25,
  a1_.reservation AS reservation_26,
  a1_.observations AS observations_27,
  a1_.is_canceled AS is_canceled_28,
  a1_.is_public AS is_public_29,
  a1_.access_code AS access_code_30,
  a1_.max_capacity AS max_capacity_31,
  a1_.created_at AS created_at_32,
  a1_.updated_at AS updated_at_33,
  p2_.id AS id_34,
  p2_.name AS name_35,
  p2_.address AS address_36,
  p2_.capacity AS capacity_37,
  p2_.created_at AS created_at_38,
  p2_.updated_at AS updated_at_39,
  a1_.event_id AS event_id_40,
  a1_.form_id AS form_id_41,
  a1_.place_id AS place_id_42
FROM
  event e0_
  LEFT JOIN activity a1_ ON e0_.id = a1_.event_id
  LEFT JOIN place p2_ ON a1_.place_id = p2_.id
WHERE
  e0_.is_archived = ?
  AND COALESCE(
    e0_.event_end_at, e0_.event_start_at
  ) >= ?
  AND (
    e0_.description IS NOT NULL
    AND e0_.description <> ''
  )
  AND (
    (e0_.is_public = ?)
    OR (
      EXISTS (
        SELECT
          1 AS sclr_43
        FROM
          activity a3_
        WHERE
          a3_.event_id = e0_.id
          AND a3_.is_public = ?
          AND a3_.description IS NOT NULL
          AND a3_.description <> ''
      )
    )
  )
ORDER BY
  e0_.event_start_at ASC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.code AS code_2, e0_.event_start_at AS event_start_at_3, e0_.event_end_at AS event_end_at_4, e0_.description AS description_5, e0_.reservation AS reservation_6, e0_.is_active AS is_active_7, e0_.is_canceled AS is_canceled_8, e0_.is_archived AS is_archived_9, e0_.is_public AS is_public_10, e0_.access_code AS access_code_11, e0_.created_at AS created_at_12, e0_.updated_at AS updated_at_13, a1_.id AS id_14, a1_.name AS name_15, a1_.code AS code_16, a1_.start_at AS start_at_17, a1_.end_at AS end_at_18, a1_.registration_start_at AS registration_start_at_19, a1_.registration_end_at AS registration_end_at_20, a1_.description AS description_21, a1_.document AS document_22, a1_.orchestra AS orchestra_23, a1_.price AS price_24, a1_.price_child AS price_child_25, a1_.reservation AS reservation_26, a1_.observations AS observations_27, a1_.is_canceled AS is_canceled_28, a1_.is_public AS is_public_29, a1_.access_code AS access_code_30, a1_.max_capacity AS max_capacity_31, a1_.created_at AS created_at_32, a1_.updated_at AS updated_at_33, p2_.id AS id_34, p2_.name AS name_35, p2_.address AS address_36, p2_.capacity AS capacity_37, p2_.created_at AS created_at_38, p2_.updated_at AS updated_at_39, a1_.event_id AS event_id_40, a1_.form_id AS form_id_41, a1_.place_id AS place_id_42 FROM event e0_ LEFT JOIN activity a1_ ON e0_.id = a1_.event_id LEFT JOIN place p2_ ON a1_.place_id = p2_.id WHERE e0_.is_archived = 0 AND COALESCE(e0_.event_end_at, e0_.event_start_at) >= '2026-06-28 00:00:00' AND (e0_.description IS NOT NULL AND e0_.description <> '') AND ((e0_.is_public = 1) OR (EXISTS (SELECT 1 AS sclr_43 FROM activity a3_ WHERE a3_.event_id = e0_.id AND a3_.is_public = 1 AND a3_.description IS NOT NULL AND a3_.description <> ''))) ORDER BY e0_.event_start_at ASC;

#	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->findUpcomingEventsForHomepage (line 63)
7	App\Controller\HomeController->index (line 17)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 8)

0.45 ms

SELECT f0_.id AS id_0, f0_.content AS content_1, f0_.type AS type_2, f0_.unpublished_at AS unpublished_at_3, f0_.is_active AS is_active_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6 FROM flash_message f0_ WHERE f0_.is_active = ? AND (f0_.unpublished_at IS NULL OR f0_.unpublished_at > ?) LIMIT 1

Parameters:

[
  1
  "2026-06-30 23:51:39"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.content AS content_1,
  f0_.type AS type_2,
  f0_.unpublished_at AS unpublished_at_3,
  f0_.is_active AS is_active_4,
  f0_.created_at AS created_at_5,
  f0_.updated_at AS updated_at_6
FROM
  flash_message f0_
WHERE
  f0_.is_active = ?
  AND (
    f0_.unpublished_at IS NULL
    OR f0_.unpublished_at > ?
  )
LIMIT
  1

SELECT f0_.id AS id_0, f0_.content AS content_1, f0_.type AS type_2, f0_.unpublished_at AS unpublished_at_3, f0_.is_active AS is_active_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6 FROM flash_message f0_ WHERE f0_.is_active = 1 AND (f0_.unpublished_at IS NULL OR f0_.unpublished_at > '2026-06-30 23:51:39') LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\Repository\FlashMessageRepository->findActiveForDisplay (line 41)
7	App\Controller\HomeController->index (line 20)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 8)

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

Entities Mapping

Class	Mapping errors
App\Entity\Event	No errors.
App\Entity\Activity	No errors.
App\Entity\Place	No errors.
App\Entity\Form	No errors.
App\Entity\FlashMessage	No errors.

Symfony Profiler

GET https://comitedesfetestaissy.alkar0.com/

Configuration Settings

Theme

Page Width