Symfony Profiler

Query Metrics

12 Database Queries

7 Different statements

2.04 ms Query time

2 Invalid entities

19 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.59 ms
(77.94%)

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.active AS active_3, n0_.public AS public_4, n0_.slug AS slug_5, n0_.created AS created_6, n0_.updated AS updated_7, n0_.image_id AS image_id_8, n0_.creator_id AS creator_id_9, n0_.news_category_id AS news_category_id_10 FROM news n0_ WHERE n0_.active IN (?) AND n0_.public IN (?) AND n0_.id IN (?, ?, ?) ORDER BY n0_.id DESC

Parameters:

[
  true
  true
  1658
  1586
  1569
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.description AS description_2,
  n0_.active AS active_3,
  n0_.public AS public_4,
  n0_.slug AS slug_5,
  n0_.created AS created_6,
  n0_.updated AS updated_7,
  n0_.image_id AS image_id_8,
  n0_.creator_id AS creator_id_9,
  n0_.news_category_id AS news_category_id_10
FROM
  news n0_
WHERE
  n0_.active IN (?)
  AND n0_.public IN (?)
  AND n0_.id IN (?, ?, ?)
ORDER BY
  n0_.id DESC

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.active AS active_3, n0_.public AS public_4, n0_.slug AS slug_5, n0_.created AS created_6, n0_.updated AS updated_7, n0_.image_id AS image_id_8, n0_.creator_id AS creator_id_9, n0_.news_category_id AS news_category_id_10 FROM news n0_ WHERE n0_.active IN (1) AND n0_.public IN (1) AND n0_.id IN (1658, 1586, 1569) ORDER BY n0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 171)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 57)
8	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 260)
9	Pagerfanta\Pagerfanta->getCurrentPageResults (line 249)
10	App\Service\UtilsService->getListResponse (line 563)
11	App\Controller\Api\NewsController->list (line 114)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.11 ms
(5.47%)

SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.eloa_url AS eloa_url_4, t0.eloa_order AS eloa_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agency_id AS agency_id_8, t0.vehicle_id AS vehicle_id_9 FROM image t0 WHERE t0.id = ?

Parameters:

[
  4183411
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.position AS position_3,
  t0.eloa_url AS eloa_url_4,
  t0.eloa_order AS eloa_order_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.agency_id AS agency_id_8,
  t0.vehicle_id AS vehicle_id_9
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.eloa_url AS eloa_url_4, t0.eloa_order AS eloa_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agency_id AS agency_id_8, t0.vehicle_id AS vehicle_id_9 FROM image t0 WHERE t0.id = 4183411;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\Image::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Image->__get (line 184)
7	App\Entity\Image->getImage (line 150)
8	App\Mapper\Api\ImageMapper->mapToDTO (line 18)
9	App\Mapper\Api\NewsMapper->mapToDTO (line 28)
10	App\Service\UtilsService->App\Service\{closure} (line 570)
11	array_map (line 569)
12	App\Service\UtilsService::getListResponse (line 569)
13	App\Controller\Api\NewsController->list (line 114)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 197)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

0.10 ms
(4.93%)

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 INNER JOIN news_country ON t0.id = news_country.country_id WHERE news_country.news_id = ?

Parameters:

[
  1658
]

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
  INNER JOIN news_country ON t0.id = news_country.country_id
WHERE
  news_country.news_id = ?

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 INNER JOIN news_country ON t0.id = news_country.country_id WHERE news_country.news_id = 1658;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1143)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1065)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3322)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 157)
7	App\Mapper\Api\NewsMapper->mapToDTO (line 35)
8	App\Service\UtilsService->App\Service\{closure} (line 570)
9	array_map (line 569)
10	App\Service\UtilsService::getListResponse (line 569)
11	App\Controller\Api\NewsController->list (line 114)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.08 ms
(4.07%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM news_category t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  news_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM news_category t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\NewsCategory::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\NewsCategory->__get (line 184)
7	App\Entity\NewsCategory->getName (line 39)
8	App\Mapper\Api\NewsCategoryMapper->mapToDTO (line 15)
9	App\Mapper\Api\NewsMapper->mapToDTO (line 27)
10	App\Service\UtilsService->App\Service\{closure} (line 570)
11	array_map (line 569)
12	App\Service\UtilsService::getListResponse (line 569)
13	App\Controller\Api\NewsController->list (line 114)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 197)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

0.07 ms
(3.28%)

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:

[
  "fr"
]

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 = 'fr' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 364)
4	Doctrine\ORM\EntityRepository->__call (line 275)
5	App\EventSubscriber\TimezoneSubscriber->onKernelRequest (line 30)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.05 ms
(2.50%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.active AS active_3, n0_.public AS public_4, n0_.slug AS slug_5, n0_.created AS created_6, n0_.updated AS updated_7 FROM news n0_ WHERE n0_.active IN (?) AND n0_.public IN (?) ORDER BY n0_.id DESC) dctrn_result) dctrn_table

Parameters:

[
  true
  true
]

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_.name AS name_1,
          n0_.description AS description_2,
          n0_.active AS active_3,
          n0_.public AS public_4,
          n0_.slug AS slug_5,
          n0_.created AS created_6,
          n0_.updated AS updated_7
        FROM
          news n0_
        WHERE
          n0_.active IN (?)
          AND n0_.public IN (?)
        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_.name AS name_1, n0_.description AS description_2, n0_.active AS active_3, n0_.public AS public_4, n0_.slug AS slug_5, n0_.created AS created_6, n0_.updated AS updated_7 FROM news n0_ WHERE n0_.active IN (1) AND n0_.public IN (1) ORDER BY n0_.id DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 942)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 120)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getNbResults (line 42)
8	Pagerfanta\Pagerfanta->getNbResults (line 292)
9	Pagerfanta\Pagerfanta->calculateNbPages (line 318)
10	Pagerfanta\Pagerfanta->getNbPages (line 300)
11	Pagerfanta\Pagerfanta->hasNextPage (line 383)
12	App\Service\UtilsService->nextPageUriTrait (line 63)
13	App\Service\UtilsService->resultIndexTrait (line 35)
14	App\Service\UtilsService->getListResponse (line 562)
15	App\Controller\Api\NewsController->list (line 114)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 197)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.04 ms
(1.82%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.active AS active_3, n0_.public AS public_4, n0_.slug AS slug_5, n0_.created AS created_6, n0_.updated AS updated_7 FROM news n0_ WHERE n0_.active IN (?) AND n0_.public IN (?)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 3

Parameters:

[
  true
  true
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.name AS name_1,
          n0_.description AS description_2,
          n0_.active AS active_3,
          n0_.public AS public_4,
          n0_.slug AS slug_5,
          n0_.created AS created_6,
          n0_.updated AS updated_7
        FROM
          news n0_
        WHERE
          n0_.active IN (?)
          AND n0_.public IN (?)
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  3

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.active AS active_3, n0_.public AS public_4, n0_.slug AS slug_5, n0_.created AS created_6, n0_.updated AS updated_7 FROM news n0_ WHERE n0_.active IN (1) AND n0_.public IN (1)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 3;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 942)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 153)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 57)
8	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 260)
9	Pagerfanta\Pagerfanta->getCurrentPageResults (line 249)
10	App\Service\UtilsService->getListResponse (line 563)
11	App\Controller\Api\NewsController->list (line 114)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	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\Country	9
App\Entity\News	3
App\Entity\Image	3
App\Entity\User	2
App\Entity\NewsCategory	2

Entities Mapping

Class	Mapping errors
App\Entity\Country	No errors.
App\Entity\Department	No errors.
App\Entity\News	No errors.
App\Entity\Image	No errors.
App\Entity\User	The mappings App\Entity\User#relaunch and App\Entity\Relaunch#user are inconsistent with each other. The field App\Entity\User#saleAgreements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SaleAgreement#user does not contain the required 'inversedBy="saleAgreements"' attribute. The field App\Entity\User#invoices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Invoice#user does not contain the required 'inversedBy="invoices"' attribute.
App\Entity\NewsCategory	No errors.
App\Entity\Agency	No errors.
App\Entity\Vehicle	The field App\Entity\Vehicle#saleAgreements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SaleAgreement#vehicle does not contain the required 'inversedBy="saleAgreements"' attribute. The field App\Entity\Vehicle#invoices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Invoice#vehicle does not contain the required 'inversedBy="invoices"' attribute.

Symfony Profiler

GET https://preprod.api.agenceauto.com/fr/api/news?maxPerPage=3&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping