Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.74 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.23 ms

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.lang AS lang_2, b0_.content AS content_3, b0_.image AS image_4, b0_.selector AS selector_5, b0_.updated_at AS updated_at_6, b0_.created_at AS created_at_7 FROM blog b0_) 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
          b0_.id AS id_0,
          b0_.title AS title_1,
          b0_.lang AS lang_2,
          b0_.content AS content_3,
          b0_.image AS image_4,
          b0_.selector AS selector_5,
          b0_.updated_at AS updated_at_6,
          b0_.created_at AS created_at_7
        FROM
          blog b0_
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.lang AS lang_2, b0_.content AS content_3, b0_.image AS image_4, b0_.selector AS selector_5, b0_.updated_at AS updated_at_6, b0_.created_at AS created_at_7 FROM blog b0_) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 29)
8	App\Core\Repository\ServiceEntityRepository->paginate (line 55)
9	App\Repository\BlogRepository->findLatestPaginated (line 292)
10	App\Controller\Api\Front\FrontApiController->listBlog (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.51 ms

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.lang AS lang_2, b0_.content AS content_3, b0_.image AS image_4, b0_.selector AS selector_5, b0_.updated_at AS updated_at_6, b0_.created_at AS created_at_7 FROM blog b0_ LIMIT 50

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.lang AS lang_2,
  b0_.content AS content_3,
  b0_.image AS image_4,
  b0_.selector AS selector_5,
  b0_.updated_at AS updated_at_6,
  b0_.created_at AS created_at_7
FROM
  blog b0_
LIMIT
  50

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.lang AS lang_2, b0_.content AS content_3, b0_.image AS image_4, b0_.selector AS selector_5, b0_.updated_at AS updated_at_6, b0_.created_at AS created_at_7 FROM blog b0_ LIMIT 50;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 177)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 49)
8	App\Core\Repository\ServiceEntityRepository->paginate (line 55)
9	App\Repository\BlogRepository->findLatestPaginated (line 292)
10	App\Controller\Api\Front\FrontApiController->listBlog (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
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\Entity\Blog	No errors.

Symfony Profiler

GET https://dev.doctozed.com/front/v1/blog?withPagination=true

Configuration Settings

Theme