Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

6.89 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

5.36 ms

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.short_content AS short_content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.is_published AS is_published_7, a0_.media AS media_8, a0_.published_at AS published_at_9, a0_.author_id AS author_id_10, a0_.competition_id AS competition_id_11 FROM article a0_ ORDER BY a0_.published_at DESC LIMIT 10 OFFSET 40

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.content AS content_3,
  a0_.short_content AS short_content_4,
  a0_.created_at AS created_at_5,
  a0_.updated_at AS updated_at_6,
  a0_.is_published AS is_published_7,
  a0_.media AS media_8,
  a0_.published_at AS published_at_9,
  a0_.author_id AS author_id_10,
  a0_.competition_id AS competition_id_11
FROM
  article a0_
ORDER BY
  a0_.published_at DESC
LIMIT
  10
OFFSET
  40

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.short_content AS short_content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.is_published AS is_published_7, a0_.media AS media_8, a0_.published_at AS published_at_9, a0_.author_id AS author_id_10, a0_.competition_id AS competition_id_11 FROM article a0_ ORDER BY a0_.published_at DESC LIMIT 10 OFFSET 40;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 27)
7	App\Repository\ArticleRepository->paginate (line 23)
8	App\Controller\ArticleController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.79 ms

SELECT COUNT(a0_.id) AS sclr_0 FROM article a0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  article a0_

SELECT COUNT(a0_.id) AS sclr_0 FROM article a0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 32)
8	App\Repository\ArticleRepository->paginate (line 23)
9	App\Controller\ArticleController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.74 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.icon AS icon_5, t0.code AS code_6, t0.league AS league_7, t0.season AS season_8, t0.sport_id AS sport_id_9 FROM competition t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.icon AS icon_5,
  t0.code AS code_6,
  t0.league AS league_7,
  t0.season AS season_8,
  t0.sport_id AS sport_id_9
FROM
  competition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.icon AS icon_5, t0.code AS code_6, t0.league AS league_7, t0.season AS season_8, t0.sport_id AS sport_id_9 FROM competition t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Competition::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Competition->__get (line 99)
8	App\Entity\Competition->__toString (line 120)
9	Twig\Runtime\EscaperRuntime->escape (line 125)
10	__TwigTemplate_5b6f0a2a2d83b616e70417579a096998->block_body (line 431)
11	Twig\Template->yieldBlock (line 214)
12	__TwigTemplate_a186ad43b42505cd70fd4e4e54550594->doDisplay (line 387)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_5b6f0a2a2d83b616e70417579a096998->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 25)
23	App\Controller\ArticleController->index (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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.

Entities Mapping

Class	Mapping errors
App\Entity\Article	No errors.
App\Entity\User	No errors.
App\Entity\Competition	No errors.
App\Entity\Category	No errors.
App\Entity\Sport	No errors.
App\Entity\Round	No errors.
App\Entity\Competitor	No errors.
App\Entity\Game	No errors.
App\Entity\UserCompetition	No errors.
App\Entity\League	No errors.

Symfony Profiler

GET https://gg.betfor.fun/articles/?page=5

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping