Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

14.16 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.11 ms
(78.48%)

SELECT n0_.id AS id_0, n0_.is_hidden AS is_hidden_1, n0_.slug AS slug_2, n0_.title AS title_3, n0_.description AS description_4, n0_.content AS content_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, n0_.published_at AS published_at_8, n0_.city_id AS city_id_9, n0_.source_id AS source_id_10, n0_.created_by_id AS created_by_id_11, n0_.updated_by_id AS updated_by_id_12 FROM news_post n0_ ORDER BY n0_.id DESC LIMIT 12 OFFSET 60

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.is_hidden AS is_hidden_1,
  n0_.slug AS slug_2,
  n0_.title AS title_3,
  n0_.description AS description_4,
  n0_.content AS content_5,
  n0_.created_at AS created_at_6,
  n0_.updated_at AS updated_at_7,
  n0_.published_at AS published_at_8,
  n0_.city_id AS city_id_9,
  n0_.source_id AS source_id_10,
  n0_.created_by_id AS created_by_id_11,
  n0_.updated_by_id AS updated_by_id_12
FROM
  news_post n0_
ORDER BY
  n0_.id DESC
LIMIT
  12
OFFSET
  60

SELECT n0_.id AS id_0, n0_.is_hidden AS is_hidden_1, n0_.slug AS slug_2, n0_.title AS title_3, n0_.description AS description_4, n0_.content AS content_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, n0_.published_at AS published_at_8, n0_.city_id AS city_id_9, n0_.source_id AS source_id_10, n0_.created_by_id AS created_by_id_11, n0_.updated_by_id AS updated_by_id_12 FROM news_post n0_ ORDER BY n0_.id DESC LIMIT 12 OFFSET 60;

#	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 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 177)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 36)
8	App\Shared\Infrastructure\Pagination\Paginator->paginate (line 62)
9	App\News\Infrastructure\Repository\PostRepository->findRecentIndex (line 16)
10	App\News\Infrastructure\Controller\NewsController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

3.05 ms
(21.52%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.is_hidden AS is_hidden_1, n0_.slug AS slug_2, n0_.title AS title_3, n0_.description AS description_4, n0_.content AS content_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, n0_.published_at AS published_at_8 FROM news_post n0_ ORDER BY n0_.id DESC) dctrn_result) dctrn_table

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.is_hidden AS is_hidden_1,
          n0_.slug AS slug_2,
          n0_.title AS title_3,
          n0_.description AS description_4,
          n0_.content AS content_5,
          n0_.created_at AS created_at_6,
          n0_.updated_at AS updated_at_7,
          n0_.published_at AS published_at_8
        FROM
          news_post n0_
        ORDER BY
          n0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.is_hidden AS is_hidden_1, n0_.slug AS slug_2, n0_.title AS title_3, n0_.description AS description_4, n0_.content AS content_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, n0_.published_at AS published_at_8 FROM news_post n0_ ORDER BY n0_.id DESC) dctrn_result) dctrn_table;

#	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 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 37)
8	App\Shared\Infrastructure\Pagination\Paginator->paginate (line 62)
9	App\News\Infrastructure\Repository\PostRepository->findRecentIndex (line 16)
10	App\News\Infrastructure\Controller\NewsController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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\News\Domain\Entity\Post	No errors.
App\Main\Domain\Entity\City	No errors.
App\News\Domain\Entity\Source	No errors.
App\Id\Domain\Entity\User	No errors.
App\S3\Domain\Entity\MediaObject	No errors.
App\News\Domain\Entity\Tag	No errors.
App\News\Domain\Entity\Comment	No errors.

Symfony Profiler

GET https://news.cpn.qa.x86lab.com/post/6

Configuration Settings

Theme