Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

2.28 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.29 ms
(56.52%)

SELECT t0.id AS id_1, t0.plaque AS plaque_2, t0.annee_general AS annee_general_3, t0.kilometrage AS kilometrage_4, t0.carburant AS carburant_5, t0.boite AS boite_6, t0.date_vente AS date_vente_7, t0.prix_voulu AS prix_voulu_8, t0.type AS type_9, t0.image_snd AS image_snd_10, t0.image_thrd AS image_thrd_11, t0.image_four AS image_four_12, t0.image_five AS image_five_13, t0.image_main AS image_main_14, t0.description AS description_15, t0.titre AS titre_16 FROM general t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.plaque AS plaque_2,
  t0.annee_general AS annee_general_3,
  t0.kilometrage AS kilometrage_4,
  t0.carburant AS carburant_5,
  t0.boite AS boite_6,
  t0.date_vente AS date_vente_7,
  t0.prix_voulu AS prix_voulu_8,
  t0.type AS type_9,
  t0.image_snd AS image_snd_10,
  t0.image_thrd AS image_thrd_11,
  t0.image_four AS image_four_12,
  t0.image_five AS image_five_13,
  t0.image_main AS image_main_14,
  t0.description AS description_15,
  t0.titre AS titre_16
FROM
  general t0

SELECT t0.id AS id_1, t0.plaque AS plaque_2, t0.annee_general AS annee_general_3, t0.kilometrage AS kilometrage_4, t0.carburant AS carburant_5, t0.boite AS boite_6, t0.date_vente AS date_vente_7, t0.prix_voulu AS prix_voulu_8, t0.type AS type_9, t0.image_snd AS image_snd_10, t0.image_thrd AS image_thrd_11, t0.image_four AS image_four_12, t0.image_five AS image_five_13, t0.image_main AS image_main_14, t0.description AS description_15, t0.titre AS titre_16 FROM general t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 36)
6	App\Controller\GetVehiculesController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.25 ms
(10.89%)

SELECT DISTINCT g0_.type AS type_0 FROM general g0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT g0_.type AS type_0
FROM
  general g0_

SELECT DISTINCT g0_.type AS type_0 FROM general g0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 100)
7	App\Form\FiltreType->getTypesFromDatabase (line 27)
8	App\Form\FiltreType->buildForm (line 102)
9	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
11	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
12	Symfony\Component\Form\FormFactory->createBuilder (line 28)
13	Symfony\Component\Form\FormFactory->create (line 344)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 40)
15	App\Controller\GetVehiculesController->index (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.22 ms
(9.53%)

SELECT t0.id AS id_1, t0.modele_machine AS modele_machine_2, t0.accessoires AS accessoires_3, t0.annee_machine AS annee_machine_4, t0.temps_utilisation AS temps_utilisation_5, t0.poids AS poids_6, t0.etat AS etat_7, t0.certification AS certification_8, t0.image_snd AS image_snd_9, t0.image_thrd AS image_thrd_10, t0.image_four AS image_four_11, t0.image_five AS image_five_12, t0.image_main AS image_main_13, t0.type AS type_14, t0.prix_voulu AS prix_voulu_15, t0.description AS description_16, t0.titre AS titre_17 FROM machine t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.modele_machine AS modele_machine_2,
  t0.accessoires AS accessoires_3,
  t0.annee_machine AS annee_machine_4,
  t0.temps_utilisation AS temps_utilisation_5,
  t0.poids AS poids_6,
  t0.etat AS etat_7,
  t0.certification AS certification_8,
  t0.image_snd AS image_snd_9,
  t0.image_thrd AS image_thrd_10,
  t0.image_four AS image_four_11,
  t0.image_five AS image_five_12,
  t0.image_main AS image_main_13,
  t0.type AS type_14,
  t0.prix_voulu AS prix_voulu_15,
  t0.description AS description_16,
  t0.titre AS titre_17
FROM
  machine t0

SELECT t0.id AS id_1, t0.modele_machine AS modele_machine_2, t0.accessoires AS accessoires_3, t0.annee_machine AS annee_machine_4, t0.temps_utilisation AS temps_utilisation_5, t0.poids AS poids_6, t0.etat AS etat_7, t0.certification AS certification_8, t0.image_snd AS image_snd_9, t0.image_thrd AS image_thrd_10, t0.image_four AS image_four_11, t0.image_five AS image_five_12, t0.image_main AS image_main_13, t0.type AS type_14, t0.prix_voulu AS prix_voulu_15, t0.description AS description_16, t0.titre AS titre_17 FROM machine t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 37)
6	App\Controller\GetVehiculesController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.15 ms
(6.60%)

SELECT t0.id AS id_1, t0.modele_remorque AS modele_remorque_2, t0.caracteristiques AS caracteristiques_3, t0.essieu AS essieu_4, t0.annee_remorque AS annee_remorque_5, t0.image_snd AS image_snd_6, t0.image_thrd AS image_thrd_7, t0.image_four AS image_four_8, t0.image_five AS image_five_9, t0.image_main AS image_main_10, t0.type AS type_11, t0.prix_voulu AS prix_voulu_12, t0.description AS description_13, t0.titre AS titre_14 FROM remorque t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.modele_remorque AS modele_remorque_2,
  t0.caracteristiques AS caracteristiques_3,
  t0.essieu AS essieu_4,
  t0.annee_remorque AS annee_remorque_5,
  t0.image_snd AS image_snd_6,
  t0.image_thrd AS image_thrd_7,
  t0.image_four AS image_four_8,
  t0.image_five AS image_five_9,
  t0.image_main AS image_main_10,
  t0.type AS type_11,
  t0.prix_voulu AS prix_voulu_12,
  t0.description AS description_13,
  t0.titre AS titre_14
FROM
  remorque t0

SELECT t0.id AS id_1, t0.modele_remorque AS modele_remorque_2, t0.caracteristiques AS caracteristiques_3, t0.essieu AS essieu_4, t0.annee_remorque AS annee_remorque_5, t0.image_snd AS image_snd_6, t0.image_thrd AS image_thrd_7, t0.image_four AS image_four_8, t0.image_five AS image_five_9, t0.image_main AS image_main_10, t0.type AS type_11, t0.prix_voulu AS prix_voulu_12, t0.description AS description_13, t0.titre AS titre_14 FROM remorque t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 38)
6	App\Controller\GetVehiculesController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.13 ms
(5.66%)

SELECT DISTINCT r0_.type AS type_0 FROM remorque r0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT r0_.type AS type_0
FROM
  remorque r0_

SELECT DISTINCT r0_.type AS type_0 FROM remorque r0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 115)
7	App\Form\FiltreType->getTypesFromDatabase (line 27)
8	App\Form\FiltreType->buildForm (line 102)
9	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
11	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
12	Symfony\Component\Form\FormFactory->createBuilder (line 28)
13	Symfony\Component\Form\FormFactory->create (line 344)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 40)
15	App\Controller\GetVehiculesController->index (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.12 ms
(5.44%)

SELECT DISTINCT m0_.type AS type_0 FROM machine m0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT m0_.type AS type_0
FROM
  machine m0_

SELECT DISTINCT m0_.type AS type_0 FROM machine m0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 107)
7	App\Form\FiltreType->getTypesFromDatabase (line 27)
8	App\Form\FiltreType->buildForm (line 102)
9	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
11	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
12	Symfony\Component\Form\FormFactory->createBuilder (line 28)
13	Symfony\Component\Form\FormFactory->create (line 344)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 40)
15	App\Controller\GetVehiculesController->index (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.12 ms
(5.36%)

SELECT DISTINCT g0_.carburant AS carburant_0 FROM general g0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT g0_.carburant AS carburant_0
FROM
  general g0_

SELECT DISTINCT g0_.carburant AS carburant_0 FROM general g0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 130)
7	App\Form\FiltreType->getCarburantFromDatabase (line 28)
8	App\Form\FiltreType->buildForm (line 102)
9	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
11	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
12	Symfony\Component\Form\FormFactory->createBuilder (line 28)
13	Symfony\Component\Form\FormFactory->create (line 344)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 40)
15	App\Controller\GetVehiculesController->index (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	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\General	No errors.
App\Entity\Machine	No errors.
App\Entity\Remorque	No errors.

Symfony Profiler

GET https://apltruck.com/vehicules

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping