Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.09 ms Query time

0 Invalid entities

#▲

Time

Info

0.99 ms

SELECT count(s0_.ID) AS sclr_0 FROM spl_foto s0_ WHERE UNIX_TIMESTAMP(s0_.AddTime) > ?

Parameters:

[
  1781038800
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(s0_.ID) AS sclr_0
FROM
  spl_foto s0_
WHERE
  UNIX_TIMESTAMP(s0_.AddTime) > ?

SELECT count(s0_.ID) AS sclr_0 FROM spl_foto s0_ WHERE UNIX_TIMESTAMP(s0_.AddTime) > 1781038800;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 23)
8	App\Repository\SplFotoRepository->getNewPhotoCount (line 34)
9	App\Controller\StatisticGlobalController->statisticGlobal (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.55 ms

SELECT count(s0_.ID) AS sclr_0 FROM spl_comments s0_ WHERE UNIX_TIMESTAMP(s0_.DateCreated) > ? AND s0_.invis = 0

Parameters:

[
  1781038800
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(s0_.ID) AS sclr_0
FROM
  spl_comments s0_
WHERE
  UNIX_TIMESTAMP(s0_.DateCreated) > ?
  AND s0_.invis = 0

SELECT count(s0_.ID) AS sclr_0 FROM spl_comments s0_ WHERE UNIX_TIMESTAMP(s0_.DateCreated) > 1781038800 AND s0_.invis = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 24)
8	App\Repository\SplCommentsRepository->getNewCommentsCount (line 37)
9	App\Controller\StatisticGlobalController->statisticGlobal (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.91 ms

SELECT count(s0_.ID) AS sclr_0 FROM spl_comps s0_ WHERE UNIX_TIMESTAMP(s0_.CreatedTime) > ?

Parameters:

[
  1781038800
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(s0_.ID) AS sclr_0
FROM
  spl_comps s0_
WHERE
  UNIX_TIMESTAMP(s0_.CreatedTime) > ?

SELECT count(s0_.ID) AS sclr_0 FROM spl_comps s0_ WHERE UNIX_TIMESTAMP(s0_.CreatedTime) > 1781038800;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 50)
8	App\Repository\SplCompRepository->getNewCompsCount (line 40)
9	App\Controller\StatisticGlobalController->statisticGlobal (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.63 ms

SELECT count(r0_.ID) AS sclr_0 FROM rating_main r0_ WHERE UNIX_TIMESTAMP(r0_.LastChangedTime) > ?

Parameters:

[
  1781038800
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(r0_.ID) AS sclr_0
FROM
  rating_main r0_
WHERE
  UNIX_TIMESTAMP(r0_.LastChangedTime) > ?

SELECT count(r0_.ID) AS sclr_0 FROM rating_main r0_ WHERE UNIX_TIMESTAMP(r0_.LastChangedTime) > 1781038800;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 23)
8	App\Repository\RatingMainRepository->getNewRatingsCount (line 43)
9	App\Controller\StatisticGlobalController->statisticGlobal (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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.