Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

2.39 ms Query time

2 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.65 ms

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 13:51:38"
  "2026-02-27 13:51:38"
]

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 13:51:38') AND (a0_.display_until IS NULL OR a0_.display_until >= '2026-02-27 13:51:38') 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)

1.47 ms

SELECT t0.id AS id_1, t0.category AS category_2, t0.item_code AS item_code_3, t0.opened_at AS opened_at_4, t0.legacy_code AS legacy_code_5, t0.access_key AS access_key_6, t0.brand AS brand_7, t0.model AS model_8, t0.title AS title_9, t0.picture AS picture_10, t0.description AS description_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.date AS date_15, t0.date_accuracy AS date_accuracy_16, t0.date_estimated AS date_estimated_17, t0.gallery_id AS gallery_id_18 FROM item t0 WHERE t0.item_code = ? LIMIT 1

Parameters:

[
  "facebook"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.category AS category_2,
  t0.item_code AS item_code_3,
  t0.opened_at AS opened_at_4,
  t0.legacy_code AS legacy_code_5,
  t0.access_key AS access_key_6,
  t0.brand AS brand_7,
  t0.model AS model_8,
  t0.title AS title_9,
  t0.picture AS picture_10,
  t0.description AS description_11,
  t0.notes AS notes_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.date AS date_15,
  t0.date_accuracy AS date_accuracy_16,
  t0.date_estimated AS date_estimated_17,
  t0.gallery_id AS gallery_id_18
FROM
  item t0
WHERE
  t0.item_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.category AS category_2, t0.item_code AS item_code_3, t0.opened_at AS opened_at_4, t0.legacy_code AS legacy_code_5, t0.access_key AS access_key_6, t0.brand AS brand_7, t0.model AS model_8, t0.title AS title_9, t0.picture AS picture_10, t0.description AS description_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.date AS date_15, t0.date_accuracy AS date_accuracy_16, t0.date_estimated AS date_estimated_17, t0.gallery_id AS gallery_id_18 FROM item t0 WHERE t0.item_code = 'facebook' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
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 35)
12	require_once (line 29)
13	require_once (line 5)

0.27 ms

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 13:51:38"
  "2026-02-27 13:51:38"
]

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 13:51:38') AND (a0_.display_until IS NULL OR a0_.display_until >= '2026-02-27 13:51:38') 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\EventListener\ErrorListener->onKernelException (line 99)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	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\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.
App\Entity\Intervention\Intervention	No errors.
App\Entity\Listing\Listing	The association App\Entity\Listing\Listing#customer refers to the inverse side field App\Entity\User\User#purchases which does not exist.
App\Entity\Money\CashFlow	No errors.
App\Entity\Gallery\Image	No errors.

Symfony Profiler

GET https://www.coffeeine.mikamatto.com/item/facebook

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping