Symfony Profiler

Query Metrics

10 Database Queries

6 Different statements

3.89 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.29 ms
(33.19%)

SELECT t0.id AS id_1, t0.image AS image_2, t0.titre AS titre_3, t0.btn AS btn_4, t0.lien AS lien_5 FROM slider t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.titre AS titre_3,
  t0.btn AS btn_4,
  t0.lien AS lien_5
FROM
  slider t0

SELECT t0.id AS id_1, t0.image AS image_2, t0.titre AS titre_3, t0.btn AS btn_4, t0.lien AS lien_5 FROM slider t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
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\AccueilController->index (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

1.29 ms
(33.09%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.featured AS featured_5, t0.image_service AS image_service_6, t0.slug AS slug_7, t0.reference_systeme AS reference_systeme_8, t0.reference_manuel AS reference_manuel_9, t0.cree_le AS cree_le_10, t0.modifie_le AS modifie_le_11 FROM services t0 WHERE t0.reference_manuel = ? LIMIT 1

Parameters:

[
  "S0000011"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.featured AS featured_5,
  t0.image_service AS image_service_6,
  t0.slug AS slug_7,
  t0.reference_systeme AS reference_systeme_8,
  t0.reference_manuel AS reference_manuel_9,
  t0.cree_le AS cree_le_10,
  t0.modifie_le AS modifie_le_11
FROM
  services t0
WHERE
  t0.reference_manuel = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.featured AS featured_5, t0.image_service AS image_service_6, t0.slug AS slug_7, t0.reference_systeme AS reference_systeme_8, t0.reference_manuel AS reference_manuel_9, t0.cree_le AS cree_le_10, t0.modifie_le AS modifie_le_11 FROM services t0 WHERE t0.reference_manuel = 'S0000011' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 38)
5	App\Controller\AccueilController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.58 ms
(14.82%)

SELECT p0_.id AS id_0, p0_.prix AS prix_1, p0_.stock AS stock_2, p0_.qte_vendu AS qte_vendu_3, p0_.qte_approvisionne AS qte_approvisionne_4, p0_.qte_retourne AS qte_retourne_5, p0_.nb_reportion AS nb_reportion_6, p0_.stock_en_portion AS stock_en_portion_7, p0_.reference_systeme AS reference_systeme_8, p0_.reference_manuel AS reference_manuel_9, p0_.cree_le AS cree_le_10, p0_.modifie_le AS modifie_le_11, p0_.service_id AS service_id_12, p0_.produit_id AS produit_id_13 FROM prix_aapplique p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN famille f2_ ON p1_.famille_id = f2_.id INNER JOIN services s3_ ON p0_.service_id = s3_.id WHERE s3_.reference_manuel = ? LIMIT 5

Parameters:

[
  "S0000011"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.prix AS prix_1,
  p0_.stock AS stock_2,
  p0_.qte_vendu AS qte_vendu_3,
  p0_.qte_approvisionne AS qte_approvisionne_4,
  p0_.qte_retourne AS qte_retourne_5,
  p0_.nb_reportion AS nb_reportion_6,
  p0_.stock_en_portion AS stock_en_portion_7,
  p0_.reference_systeme AS reference_systeme_8,
  p0_.reference_manuel AS reference_manuel_9,
  p0_.cree_le AS cree_le_10,
  p0_.modifie_le AS modifie_le_11,
  p0_.service_id AS service_id_12,
  p0_.produit_id AS produit_id_13
FROM
  prix_aapplique p0_
  INNER JOIN produit p1_ ON p0_.produit_id = p1_.id
  INNER JOIN famille f2_ ON p1_.famille_id = f2_.id
  INNER JOIN services s3_ ON p0_.service_id = s3_.id
WHERE
  s3_.reference_manuel = ?
LIMIT
  5

SELECT p0_.id AS id_0, p0_.prix AS prix_1, p0_.stock AS stock_2, p0_.qte_vendu AS qte_vendu_3, p0_.qte_approvisionne AS qte_approvisionne_4, p0_.qte_retourne AS qte_retourne_5, p0_.nb_reportion AS nb_reportion_6, p0_.stock_en_portion AS stock_en_portion_7, p0_.reference_systeme AS reference_systeme_8, p0_.reference_manuel AS reference_manuel_9, p0_.cree_le AS cree_le_10, p0_.modifie_le AS modifie_le_11, p0_.service_id AS service_id_12, p0_.produit_id AS produit_id_13 FROM prix_aapplique p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN famille f2_ ON p1_.famille_id = f2_.id INNER JOIN services s3_ ON p0_.service_id = s3_.id WHERE s3_.reference_manuel = 'S0000011' LIMIT 5;

#	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 125)
7	App\Repository\PrixAAppliqueRepository->findProduitFamilleByServiceFeat (line 47)
8	App\Controller\AccueilController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.31 ms
(8.08%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.slogan AS slogan_3, t0.description AS description_4, t0.photo AS photo_5, t0.video AS video_6 FROM presentation t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.slogan AS slogan_3,
  t0.description AS description_4,
  t0.photo AS photo_5,
  t0.video AS video_6
FROM
  presentation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.slogan AS slogan_3, t0.description AS description_4, t0.photo AS photo_5, t0.video AS video_6 FROM presentation 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 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 48)
7	App\Controller\AccueilController->index (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.28 ms
(7.08%)

SELECT t0.id AS id_1, t0.icone AS icone_2, t0.titre AS titre_3, t0.description AS description_4, t0.is_active AS is_active_5 FROM facilities t0 WHERE t0.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.icone AS icone_2,
  t0.titre AS titre_3,
  t0.description AS description_4,
  t0.is_active AS is_active_5
FROM
  facilities t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.icone AS icone_2, t0.titre AS titre_3, t0.description AS description_4, t0.is_active AS is_active_5 FROM facilities t0 WHERE t0.is_active = 1;

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

0.14 ms
(3.73%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.featured AS featured_5, t0.image_service AS image_service_6, t0.slug AS slug_7, t0.reference_systeme AS reference_systeme_8, t0.reference_manuel AS reference_manuel_9, t0.cree_le AS cree_le_10, t0.modifie_le AS modifie_le_11 FROM services t0 WHERE t0.featured = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.featured AS featured_5,
  t0.image_service AS image_service_6,
  t0.slug AS slug_7,
  t0.reference_systeme AS reference_systeme_8,
  t0.reference_manuel AS reference_manuel_9,
  t0.cree_le AS cree_le_10,
  t0.modifie_le AS modifie_le_11
FROM
  services t0
WHERE
  t0.featured = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.featured AS featured_5, t0.image_service AS image_service_6, t0.slug AS slug_7, t0.reference_systeme AS reference_systeme_8, t0.reference_manuel AS reference_manuel_9, t0.cree_le AS cree_le_10, t0.modifie_le AS modifie_le_11 FROM services t0 WHERE t0.featured = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 45)
5	App\Controller\AccueilController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\Slider	No errors.
App\Entity\Services	No errors.
App\Entity\PrixAApplique	No errors.
App\Entity\DemandeProduitService	No errors.
App\Entity\LivraisonServices	No errors.
App\Entity\TableServices	No errors.
App\Entity\AffectationMateriel	No errors.
App\Entity\Employe	No errors.
App\Entity\MouvementStock	No errors.
App\Entity\SortiesStock	No errors.
App\Entity\Produit	No errors.
App\Entity\Famille	No errors.
App\Entity\Presentation	No errors.
App\Entity\Facilities	No errors.

Symfony Profiler

GET https://reservation.complexehotelierlabonte.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping