Symfony Profiler

Query Metrics

43 Database Queries

5 Different statements

17.79 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.48 ms
(64.52%)

SELECT t0.id AS id_1, t0.quantites AS quantites_2, t0.proprietaire_id AS proprietaire_id_3 FROM panier t0 WHERE t0.proprietaire_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantites AS quantites_2,
  t0.proprietaire_id AS proprietaire_id_3
FROM
  panier t0
WHERE
  t0.proprietaire_id = ?

SELECT t0.id AS id_1, t0.quantites AS quantites_2, t0.proprietaire_id AS proprietaire_id_3 FROM panier t0 WHERE t0.proprietaire_id = 9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 808)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2440)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 487)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 145)
12	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 67)
13	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 133)
15	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 178)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

4.82 ms
(27.07%)

SELECT t0.id AS id_1, t0.nom_structure AS nom_structure_2, t0.type_structure AS type_structure_3, t0.types_projet AS types_projet_4, t0.volume_vehicule AS volume_vehicule_5, t0.manutention AS manutention_6, t0.adresse AS adresse_7, t0.nom_contact AS nom_contact_8, t0.email_contact AS email_contact_9, t0.telephone_contact AS telephone_contact_10, t0.site_web AS site_web_11, t0.linkedin AS linkedin_12, t0.ressources AS ressources_13, t0.details AS details_14, t0.validation AS validation_15, t0.user_id AS user_id_16 FROM filiere t0 WHERE t0.user_id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom_structure AS nom_structure_2,
  t0.type_structure AS type_structure_3,
  t0.types_projet AS types_projet_4,
  t0.volume_vehicule AS volume_vehicule_5,
  t0.manutention AS manutention_6,
  t0.adresse AS adresse_7,
  t0.nom_contact AS nom_contact_8,
  t0.email_contact AS email_contact_9,
  t0.telephone_contact AS telephone_contact_10,
  t0.site_web AS site_web_11,
  t0.linkedin AS linkedin_12,
  t0.ressources AS ressources_13,
  t0.details AS details_14,
  t0.validation AS validation_15,
  t0.user_id AS user_id_16
FROM
  filiere t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.nom_structure AS nom_structure_2, t0.type_structure AS type_structure_3, t0.types_projet AS types_projet_4, t0.volume_vehicule AS volume_vehicule_5, t0.manutention AS manutention_6, t0.adresse AS adresse_7, t0.nom_contact AS nom_contact_8, t0.email_contact AS email_contact_9, t0.telephone_contact AS telephone_contact_10, t0.site_web AS site_web_11, t0.linkedin AS linkedin_12, t0.ressources AS ressources_13, t0.details AS details_14, t0.validation AS validation_15, t0.user_id AS user_id_16 FROM filiere t0 WHERE t0.user_id = 9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 808)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2440)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 487)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 145)
12	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 67)
13	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 133)
15	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 178)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.71 ms
(3.99%)

SELECT u0_.id AS id_0, u0_.login AS login_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.prenom AS prenom_4, u0_.nom AS nom_5, u0_.datedenaissance AS datedenaissance_6, u0_.lieudenaissance AS lieudenaissance_7, u0_.adresse AS adresse_8, u0_.contact AS contact_9, u0_.rib AS rib_10, u0_.siret AS siret_11, u0_.securitesociale AS securitesociale_12, u0_.email AS email_13, u0_.contacturgence AS contacturgence_14, u0_.contacturgencetel AS contacturgencetel_15, u0_.photo AS photo_16, u0_.permis AS permis_17, u0_.autres AS autres_18 FROM `user` u0_ WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.login AS login_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.prenom AS prenom_4,
  u0_.nom AS nom_5,
  u0_.datedenaissance AS datedenaissance_6,
  u0_.lieudenaissance AS lieudenaissance_7,
  u0_.adresse AS adresse_8,
  u0_.contact AS contact_9,
  u0_.rib AS rib_10,
  u0_.siret AS siret_11,
  u0_.securitesociale AS securitesociale_12,
  u0_.email AS email_13,
  u0_.contacturgence AS contacturgence_14,
  u0_.contacturgencetel AS contacturgencetel_15,
  u0_.photo AS photo_16,
  u0_.permis AS permis_17,
  u0_.autres AS autres_18
FROM
  `user` u0_
WHERE
  u0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT u0_.id AS id_0, u0_.login AS login_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.prenom AS prenom_4, u0_.nom AS nom_5, u0_.datedenaissance AS datedenaissance_6, u0_.lieudenaissance AS lieudenaissance_7, u0_.adresse AS adresse_8, u0_.contact AS contact_9, u0_.rib AS rib_10, u0_.siret AS siret_11, u0_.securitesociale AS securitesociale_12, u0_.email AS email_13, u0_.contacturgence AS contacturgence_14, u0_.contacturgencetel AS contacturgencetel_15, u0_.photo AS photo_16, u0_.permis AS permis_17, u0_.autres AS autres_18 FROM `user` u0_ WHERE u0_.id IN (277, 257, 14, 280, 282, 275, 278, 284, 283, 274, 72, 26, 11, 58, 9, 276, 272, 166, 281, 251);

#	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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 67)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 133)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.60 ms
(3.36%)

SELECT DISTINCT u0_.id AS id_0 FROM `user` u0_ LIMIT 20 OFFSET 40

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT u0_.id AS id_0
FROM
  `user` u0_
LIMIT
  20 OFFSET 40

SELECT DISTINCT u0_.id AS id_0 FROM `user` u0_ LIMIT 20 OFFSET 40;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 67)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 133)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.19 ms
(1.06%)

SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  `user` u0_

SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 68)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 29)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 133)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
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\User	The field App\Entity\User#panier is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Panier#proprietaire does not contain the required 'inversedBy="panier"' attribute.
App\Entity\Suivi	No errors.
App\Entity\Filiere	No errors.
App\Entity\Panier	No errors.
App\Entity\Reservation	No errors.

Symfony Profiler

GET https://bereup.online/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CUserCrudController&page=3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping