Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

33.99 ms Query time

0 Invalid entities

#▲

Time

Info

2.17 ms

SELECT pg_try_advisory_lock(1)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  pg_try_advisory_lock(1)

SELECT pg_try_advisory_lock(1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 137)
3	App\Manager\MessageManager->getLock (line 66)
4	App\Manager\MessageManager->sendMessages (line 32)
5	App\Controller\CronController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 19)

27.86 ms

select m.id from message m where m.sent = false and m.scheduled_at <= now()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  m.id
from
  message m
where
  m.sent = false
  and m.scheduled_at <= now()

select m.id from message m where m.sent = false and m.scheduled_at <= now();

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 953)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 73)
3	App\Manager\MessageManager->sendMessages (line 32)
4	App\Controller\CronController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 19)

1.22 ms

select pg_advisory_unlock(1)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  pg_advisory_unlock(1)

select pg_advisory_unlock(1);

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 146)
2	App\Manager\MessageManager->releaseLock (line 132)
3	App\Manager\MessageManager->sendMessages (line 32)
4	App\Controller\CronController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 19)

2.74 ms

select q.id 
            from smartemailing_queue q 
            where processed_at is null

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  q.id
from
  smartemailing_queue q
where
  processed_at is null

select q.id 
            from smartemailing_queue q 
            where processed_at is null
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 953)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 69)
3	App\SmartEmailing\SmartEmailingManager->syncQueue (line 35)
4	App\Controller\CronController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 19)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

No loaded entities.