Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

3.69 ms Query time

0 Invalid entities

0 Managed entities

Time▼

Count

Info

3.69 ms
(100.00%)

UPDATE attendance SET clock_out = auto_out, auto_closed = 1 WHERE clock_out IS NULL AND auto_out IS NOT NULL AND auto_out <= ?

Parameters:

[
  "2026-10-19 17:11:22"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  attendance
SET
  clock_out = auto_out,
  auto_closed = 1
WHERE
  clock_out IS NULL
  AND auto_out IS NOT NULL
  AND auto_out <= ?

UPDATE attendance SET clock_out = auto_out, auto_closed = 1 WHERE clock_out IS NULL AND auto_out IS NOT NULL AND auto_out <= '2026-10-19 17:11:22';

#	File/Call
1	Doctrine\ORM\Query\Exec\SingleTableDeleteUpdateExecutor->execute (line 38)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	App\EventSubscriber\AutoClockOutSubscriber->sweep (line 26)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 164)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
12	Symfony\Component\HttpKernel\Kernel->handle (line 143)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Amount of managed objects

Class	Mapping errors
App\Entity\Attendance	No errors.