Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

10.25 ms Query time

0 Invalid entities

0 Managed entities

Time▼

Count

Info

5.66 ms
(55.21%)

SELECT COUNT(u0_.id) AS sclr_0 FROM "user" u0_ WHERE u0_.email NOT LIKE ?

Parameters:

[
  "demo-%@plmail.invalid"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  "user" u0_
WHERE
  u0_.email NOT LIKE ?

SELECT COUNT(u0_.id) AS sclr_0 FROM "user" u0_ WHERE u0_.email NOT LIKE 'demo-%@plmail.invalid';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\User\UserRepository->countExcludingDemoVisitors (line 147)
8	App\Service\Setup\InstallGuard->isAvailable (line 39)
9	App\Controller\Auth\SecurityController->login (line 39)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
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)

4.59 ms
(44.79%)

SELECT minimum_level FROM log_settings ORDER BY id ASC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  minimum_level
FROM
  log_settings
ORDER BY
  id ASC
LIMIT
  1

SELECT minimum_level FROM log_settings ORDER BY id ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 330)
2	App\Service\Monitoring\LogLevelResolver->fromDatabase (line 104)
3	App\Service\Monitoring\LogLevelResolver->level (line 75)
4	App\Infrastructure\Doctrine\Logging\DoctrineLogHandler->isHandling (line 94)
5	Monolog\Handler\AbstractProcessingHandler->handle (line 34)
6	Monolog\Logger->addRecord (line 399)
7	Monolog\Logger->info (line 615)
8	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 106)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
15	Symfony\Component\HttpKernel\Kernel->handle (line 143)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	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\Embeddable\Appearance	No errors.
App\Entity\Embeddable\AiPreferences	No errors.
App\Entity\Embeddable\CategorySorting	No errors.
App\Entity\User\User	No errors.