Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

10.27 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.78 ms
(17.36%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.role AS role_3, t0.photo AS photo_4, t0.facebook AS facebook_5, t0.twiter AS twiter_6, t0.linkedin AS linkedin_7 FROM equipe t0 ORDER BY t0.id ASC LIMIT 4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.role AS role_3,
  t0.photo AS photo_4,
  t0.facebook AS facebook_5,
  t0.twiter AS twiter_6,
  t0.linkedin AS linkedin_7
FROM
  equipe t0
ORDER BY
  t0.id ASC
LIMIT
  4

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.role AS role_3, t0.photo AS photo_4, t0.facebook AS facebook_5, t0.twiter AS twiter_6, t0.linkedin AS linkedin_7 FROM equipe t0 ORDER BY t0.id ASC LIMIT 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\HomeController->home (line 41)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

1.50 ms
(14.65%)

SELECT t0.id AS id_1, t0.image AS image_2 FROM slide t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2
FROM
  slide t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.image AS image_2 FROM slide t0 WHERE t0.id = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 235)
4	Doctrine\ORM\EntityRepository->__call (line 158)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 95)
6	App\Controller\HomeController->home (line 35)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

1.36 ms
(13.25%)

SELECT t0.id AS id_1, t0.pays AS pays_2, t0.ville AS ville_3, t0.site AS site_4, t0.desciption AS desciption_5, t0.image1 AS image1_6, t0.image2 AS image2_7, t0.image3 AS image3_8, t0.statut AS statut_9, t0.montant AS montant_10, t0.langue AS langue_11, t0.duree_conseillee AS duree_conseillee_12, t0.notation AS notation_13, t0.circuit AS circuit_14 FROM destination t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.pays AS pays_2,
  t0.ville AS ville_3,
  t0.site AS site_4,
  t0.desciption AS desciption_5,
  t0.image1 AS image1_6,
  t0.image2 AS image2_7,
  t0.image3 AS image3_8,
  t0.statut AS statut_9,
  t0.montant AS montant_10,
  t0.langue AS langue_11,
  t0.duree_conseillee AS duree_conseillee_12,
  t0.notation AS notation_13,
  t0.circuit AS circuit_14
FROM
  destination t0

SELECT t0.id AS id_1, t0.pays AS pays_2, t0.ville AS ville_3, t0.site AS site_4, t0.desciption AS desciption_5, t0.image1 AS image1_6, t0.image2 AS image2_7, t0.image3 AS image3_8, t0.statut AS statut_9, t0.montant AS montant_10, t0.langue AS langue_11, t0.duree_conseillee AS duree_conseillee_12, t0.notation AS notation_13, t0.circuit AS circuit_14 FROM destination t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\HomeController->home (line 37)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

1.26 ms
(12.25%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.pays AS pays_3, t0.ville AS ville_4, t0.montant AS montant_5, t0.description AS description_6, t0.image1 AS image1_7, t0.image2 AS image2_8, t0.image3 AS image3_9, t0.statut AS statut_10, t0.jour AS jour_11, t0.image4 AS image4_12 FROM circuit t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.pays AS pays_3,
  t0.ville AS ville_4,
  t0.montant AS montant_5,
  t0.description AS description_6,
  t0.image1 AS image1_7,
  t0.image2 AS image2_8,
  t0.image3 AS image3_9,
  t0.statut AS statut_10,
  t0.jour AS jour_11,
  t0.image4 AS image4_12
FROM
  circuit t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.pays AS pays_3, t0.ville AS ville_4, t0.montant AS montant_5, t0.description AS description_6, t0.image1 AS image1_7, t0.image2 AS image2_8, t0.image3 AS image3_9, t0.statut AS statut_10, t0.jour AS jour_11, t0.image4 AS image4_12 FROM circuit t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\HomeController->home (line 38)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

1.22 ms
(11.86%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.image AS image_3, t0.description AS description_4, t0.montant AS montant_5, t0.statut AS statut_6 FROM activite t0 ORDER BY t0.id ASC LIMIT 4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.montant AS montant_5,
  t0.statut AS statut_6
FROM
  activite t0
ORDER BY
  t0.id ASC
LIMIT
  4

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.image AS image_3, t0.description AS description_4, t0.montant AS montant_5, t0.statut AS statut_6 FROM activite t0 ORDER BY t0.id ASC LIMIT 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\HomeController->home (line 42)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

1.12 ms
(10.92%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description1 AS description1_3, t0.description2 AS description2_4, t0.lien AS lien_5, t0.image_file_name AS image_file_name_6 FROM slide_description t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description1 AS description1_3,
  t0.description2 AS description2_4,
  t0.lien AS lien_5,
  t0.image_file_name AS image_file_name_6
FROM
  slide_description t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description1 AS description1_3, t0.description2 AS description2_4, t0.lien AS lien_5, t0.image_file_name AS image_file_name_6 FROM slide_description t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\HomeController->home (line 36)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

1.10 ms
(10.69%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_creation AS date_creation_3, t0.editeur AS editeur_4, t0.image AS image_5, t0.description AS description_6, t0.slug AS slug_7, t0.is_active AS is_active_8, t0.categorie_id AS categorie_id_9 FROM blog t0 ORDER BY t0.id ASC LIMIT 2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.date_creation AS date_creation_3,
  t0.editeur AS editeur_4,
  t0.image AS image_5,
  t0.description AS description_6,
  t0.slug AS slug_7,
  t0.is_active AS is_active_8,
  t0.categorie_id AS categorie_id_9
FROM
  blog t0
ORDER BY
  t0.id ASC
LIMIT
  2

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_creation AS date_creation_3, t0.editeur AS editeur_4, t0.image AS image_5, t0.description AS description_6, t0.slug AS slug_7, t0.is_active AS is_active_8, t0.categorie_id AS categorie_id_9 FROM blog t0 ORDER BY t0.id ASC LIMIT 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\HomeController->home (line 40)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.93 ms
(9.02%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4 FROM categorie t0 ORDER BY t0.id ASC LIMIT 8

Parameters:

[]

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
FROM
  categorie t0
ORDER BY
  t0.id ASC
LIMIT
  8

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4 FROM categorie t0 ORDER BY t0.id ASC LIMIT 8;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\HomeController->home (line 39)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\SlideDescription	2
App\Entity\Destination	2
App\Entity\Equipe	2
App\Entity\Slide	1
App\Entity\Circuit	1
App\Entity\Blog	1
App\Entity\BlogCategorie	1
App\Entity\Activite	1

Entities Mapping

Class	Mapping errors
App\Entity\Slide	No errors.
App\Entity\SlideDescription	No errors.
App\Entity\Destination	No errors.
App\Entity\Circuit	No errors.
App\Entity\Categorie	No errors.
App\Entity\Blog	No errors.
App\Entity\BlogCategorie	No errors.
App\Entity\Equipe	No errors.
App\Entity\Activite	No errors.

Symfony Profiler

GET https://suntravelsetservices.net/public/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping