Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.71 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.04 ms
(81.89%)

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 50

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
  50

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 50;

#	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.67 ms
(18.11%)

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)

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.

Symfony Profiler

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

Configuration Settings

Theme