Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.30 ms Query time

0 Invalid entities

250 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.55 ms
(42.52%)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM make m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.slug AS slug_2
FROM
  make m0_
WHERE
  m0_.id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
ORDER BY
  m0_.name ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM make m0_ WHERE m0_.id IN (142, 166, 110, 214, 221, 206, 70, 183, 1, 2, 208, 174, 254, 151, 76, 3, 140, 152, 167, 4, 202, 121, 102, 145, 190, 5, 6, 146, 143, 132, 89, 230, 127, 106, 149, 181, 84, 235, 7, 8, 204, 228, 9, 73, 118, 168, 96, 86, 164, 107, 165, 72, 87, 10, 219, 11, 82, 12, 128, 177, 13, 14, 233, 15, 100, 236, 154, 217, 139, 211, 114, 117, 226, 16, 95, 213, 104, 108, 189, 248, 103, 203, 75, 83, 97, 17, 18, 137, 153, 80, 187, 19, 94, 81, 193, 116, 112, 196, 200, 20, 115, 21, 71, 250, 22, 156, 79, 23, 201, 109, 234, 24, 138, 25, 207, 26, 27, 229, 69, 28, 192, 29, 30, 126, 158, 31, 32, 33, 34, 35, 178, 162, 36, 37, 171, 38, 232, 223, 188, 198, 224, 40, 179, 125, 205, 41, 42, 241, 39, 98, 43, 257, 194, 44, 218, 45, 222, 46, 47, 251, 99, 239, 184, 191, 175, 111, 252, 48, 182, 144, 141, 169, 49, 163, 244, 253, 50, 210, 186, 170, 51, 91, 77, 90, 124, 157, 245, 85, 52, 150, 249, 53, 155, 256, 93, 101, 131, 54, 227, 209, 195, 225, 78, 247, 212, 148, 74, 55, 215, 180, 56, 172, 57, 123, 220, 58, 240, 59, 60, 61, 88, 237, 62, 242, 63, 216, 113, 122, 105, 136, 64, 185, 159, 246, 65, 120, 199, 231, 243, 147, 119, 133, 66, 255, 67, 173, 197, 68, 238) ORDER BY m0_.name ASC;

#	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 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 57)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 268)
9	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
10	Pagerfanta\Pagerfanta->getCurrentPageResults (line 538)
11	App\Service\UtilsService->getListResponse (line 102)
12	App\Controller\Api\MakeController->list (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.33 ms
(25.80%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_1 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM make m0_) dctrn_result_inner ORDER BY name_1 ASC) dctrn_result LIMIT 616

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      name_1
    FROM
      (
        SELECT
          m0_.id AS id_0,
          m0_.name AS name_1,
          m0_.slug AS slug_2
        FROM
          make m0_
      ) dctrn_result_inner
    ORDER BY
      name_1 ASC
  ) dctrn_result
LIMIT
  616

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_1 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM make m0_) dctrn_result_inner ORDER BY name_1 ASC) dctrn_result LIMIT 616;

#	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 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 57)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 268)
9	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
10	Pagerfanta\Pagerfanta->getCurrentPageResults (line 538)
11	App\Service\UtilsService->getListResponse (line 102)
12	App\Controller\Api\MakeController->list (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.30 ms
(23.05%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM make m0_ ORDER BY m0_.name ASC) 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
          m0_.id AS id_0,
          m0_.name AS name_1,
          m0_.slug AS slug_2
        FROM
          make m0_
        ORDER BY
          m0_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM make m0_ ORDER BY m0_.name ASC) 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 42)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getNbResults (line 300)
9	Pagerfanta\Pagerfanta->getNbResults (line 326)
10	Pagerfanta\Pagerfanta->calculateNbPages (line 308)
11	Pagerfanta\Pagerfanta->getNbPages (line 395)
12	Pagerfanta\Pagerfanta->hasNextPage (line 64)
13	App\Service\UtilsService->nextPageUriTrait (line 34)
14	App\Service\UtilsService->resultIndexTrait (line 537)
15	App\Service\UtilsService->getListResponse (line 102)
16	App\Controller\Api\MakeController->list (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.11 ms
(8.63%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "es"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.tax AS tax_3,
  t0.reference_eloa AS reference_eloa_4,
  t0.label AS label_5
FROM
  country t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 WHERE t0.code = 'es' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 364)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 275)
5	Doctrine\ORM\EntityRepository->__call (line 30)
6	App\EventSubscriber\TimezoneSubscriber->onKernelRequest (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Make	249
App\Entity\Country	1

Entities Mapping

Class	Mapping errors
App\Entity\Country	No errors.
App\Entity\Department	No errors.
App\Entity\Make	No errors.
App\Entity\Model	No errors.

Symfony Profiler

GET https://preprod.api.agenceauto.com/es/api/make?maxPerPage=616&orderByName=ASC

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping