Symfony Profiler

Query Metrics

21 Database Queries

5 Different statements

57.68 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

16.76 ms
(29.06%)

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.logo AS logo_2, d0_.description AS description_3, d0_.is_active AS is_active_4 FROM domain d0_ ORDER BY d0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.title AS title_1,
  d0_.logo AS logo_2,
  d0_.description AS description_3,
  d0_.is_active AS is_active_4
FROM
  domain d0_
ORDER BY
  d0_.id DESC

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.logo AS logo_2, d0_.description AS description_3, d0_.is_active AS is_active_4 FROM domain d0_ ORDER BY d0_.id DESC;

#	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\DomainRepository->findAllDomains (line 777)
8	App\Controller\ClientController->getAll (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

15.93 ms
(27.61%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.domaine_id AS domaine_id_6 FROM category t0 WHERE t0.domaine_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.logo AS logo_3,
  t0.description AS description_4,
  t0.is_active AS is_active_5,
  t0.domaine_id AS domaine_id_6
FROM
  category t0
WHERE
  t0.domaine_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.domaine_id AS domaine_id_6 FROM category t0 WHERE t0.domaine_id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 176)
8	Symfony\Component\Serializer\Serializer->normalize (line 223)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
11	Symfony\Component\Serializer\Serializer->normalize (line 177)
12	Symfony\Component\Serializer\Serializer->normalize (line 138)
13	Symfony\Component\Serializer\Serializer->serialize (line 47)
14	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 154)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 780)
16	App\Controller\ClientController->getAll (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)

10.69 ms
(18.54%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.price AS price_5, t0.duration AS duration_6, t0.is_active AS is_active_7, t0.product_id AS product_id_8 FROM sub_product t0 WHERE t0.product_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.logo AS logo_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.duration AS duration_6,
  t0.is_active AS is_active_7,
  t0.product_id AS product_id_8
FROM
  sub_product t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.price AS price_5, t0.duration AS duration_6, t0.is_active AS is_active_7, t0.product_id AS product_id_8 FROM sub_product t0 WHERE t0.product_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 176)
8	Symfony\Component\Serializer\Serializer->normalize (line 223)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
11	Symfony\Component\Serializer\Serializer->normalize (line 177)
12	Symfony\Component\Serializer\Serializer->normalize (line 223)
13	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
15	Symfony\Component\Serializer\Serializer->normalize (line 177)
16	Symfony\Component\Serializer\Serializer->normalize (line 223)
17	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
18	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
19	Symfony\Component\Serializer\Serializer->normalize (line 177)
20	Symfony\Component\Serializer\Serializer->normalize (line 138)
21	Symfony\Component\Serializer\Serializer->serialize (line 47)
22	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 154)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 780)
24	App\Controller\ClientController->getAll (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

8.21 ms
(14.23%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4, t0.price AS price_5, t0.is_active AS is_active_6, t0.duration AS duration_7, t0.subcategory_id AS subcategory_id_8, t0.category_id AS category_id_9 FROM product t0 WHERE t0.category_id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.logo AS logo_4,
  t0.price AS price_5,
  t0.is_active AS is_active_6,
  t0.duration AS duration_7,
  t0.subcategory_id AS subcategory_id_8,
  t0.category_id AS category_id_9
FROM
  product t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4, t0.price AS price_5, t0.is_active AS is_active_6, t0.duration AS duration_7, t0.subcategory_id AS subcategory_id_8, t0.category_id AS category_id_9 FROM product t0 WHERE t0.category_id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 176)
8	Symfony\Component\Serializer\Serializer->normalize (line 223)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
11	Symfony\Component\Serializer\Serializer->normalize (line 177)
12	Symfony\Component\Serializer\Serializer->normalize (line 223)
13	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
15	Symfony\Component\Serializer\Serializer->normalize (line 177)
16	Symfony\Component\Serializer\Serializer->normalize (line 138)
17	Symfony\Component\Serializer\Serializer->serialize (line 47)
18	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 154)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 780)
20	App\Controller\ClientController->getAll (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

6.09 ms
(10.56%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.category_id AS category_id_6 FROM sub_category t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.logo AS logo_3,
  t0.description AS description_4,
  t0.is_active AS is_active_5,
  t0.category_id AS category_id_6
FROM
  sub_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.category_id AS category_id_6 FROM sub_category t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\SubCategory::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\SubCategory->__get (line 61)
8	App\Entity\SubCategory->getTitle (line 412)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 99)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 152)
11	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 194)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
14	Symfony\Component\Serializer\Serializer->normalize (line 223)
15	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
17	Symfony\Component\Serializer\Serializer->normalize (line 177)
18	Symfony\Component\Serializer\Serializer->normalize (line 223)
19	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
21	Symfony\Component\Serializer\Serializer->normalize (line 177)
22	Symfony\Component\Serializer\Serializer->normalize (line 223)
23	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 58)
24	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
25	Symfony\Component\Serializer\Serializer->normalize (line 177)
26	Symfony\Component\Serializer\Serializer->normalize (line 138)
27	Symfony\Component\Serializer\Serializer->serialize (line 47)
28	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 154)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 780)
30	App\Controller\ClientController->getAll (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	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
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\Domain	No errors.
App\Entity\Category	No errors.
App\Entity\SubCategory	No errors.
App\Entity\Product	No errors.
App\Entity\SubProduct	No errors.

Symfony Profiler

GET https://flyspa-api.dvpt.pulsweb.ch/api/client/domaines?limit=10&page=0

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping