Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

5.08 ms Query time

1 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.37 ms
(86.02%)

SELECT a0_.id AS id_0, a0_.text AS text_1, a0_.style AS style_2, a0_.dismissable AS dismissable_3, a0_.display_from AS display_from_4, a0_.display_until AS display_until_5, a0_.target AS target_6 FROM alert a0_ WHERE (a0_.display_from IS NULL OR a0_.display_from <= ?) AND (a0_.display_until IS NULL OR a0_.display_until >= ?) ORDER BY a0_.id ASC LIMIT 5

Parameters:

[
  "2026-02-27 15:20:11"
  "2026-02-27 15:20:11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.text AS text_1,
  a0_.style AS style_2,
  a0_.dismissable AS dismissable_3,
  a0_.display_from AS display_from_4,
  a0_.display_until AS display_until_5,
  a0_.target AS target_6
FROM
  alert a0_
WHERE
  (
    a0_.display_from IS NULL
    OR a0_.display_from <= ?
  )
  AND (
    a0_.display_until IS NULL
    OR a0_.display_until >= ?
  )
ORDER BY
  a0_.id ASC
LIMIT
  5

SELECT a0_.id AS id_0, a0_.text AS text_1, a0_.style AS style_2, a0_.dismissable AS dismissable_3, a0_.display_from AS display_from_4, a0_.display_until AS display_until_5, a0_.target AS target_6 FROM alert a0_ WHERE (a0_.display_from IS NULL OR a0_.display_from <= '2026-02-27 15:20:11') AND (a0_.display_until IS NULL OR a0_.display_until >= '2026-02-27 15:20:11') ORDER BY a0_.id ASC LIMIT 5;

#	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\System\AlertRepository->findAll (line 35)
7	App\EventSubscriber\AlertSubscriber->onKernelController (line 22)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.71 ms
(13.98%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.performed_by AS performed_by_4, t0.title AS title_5, t0.summary AS summary_6, t0.actions AS actions_7, t0.conclusions AS conclusions_8, t0.notes AS notes_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.privacy AS privacy_12, t0.item_id AS item_id_13, t0.gallery_id AS gallery_id_14 FROM intervention t0 WHERE t0.id = ?

Parameters:

[
  "tiktok"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.type AS type_3,
  t0.performed_by AS performed_by_4,
  t0.title AS title_5,
  t0.summary AS summary_6,
  t0.actions AS actions_7,
  t0.conclusions AS conclusions_8,
  t0.notes AS notes_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.privacy AS privacy_12,
  t0.item_id AS item_id_13,
  t0.gallery_id AS gallery_id_14
FROM
  intervention t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.type AS type_3, t0.performed_by AS performed_by_4, t0.title AS title_5, t0.summary AS summary_6, t0.actions AS actions_7, t0.conclusions AS conclusions_8, t0.notes AS notes_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.privacy AS privacy_12, t0.item_id AS item_id_13, t0.gallery_id AS gallery_id_14 FROM intervention t0 WHERE t0.id = 'tiktok';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	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

Entities Mapping

Class	Mapping errors
App\Entity\System\Alert	No errors.
App\Entity\Intervention\Intervention	No errors.
App\Entity\Item\Item	No errors.
App\Entity\Gallery\Gallery	The field App\Entity\Gallery\Gallery#intervention is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Intervention\Intervention#gallery does not contain the required 'inversedBy: "intervention"' attribute.

Symfony Profiler

GET https://www.coffeeine.mikamatto.com/item/PETD7/intervention/tiktok

Configuration Settings

Theme

Page Width