Symfony Profiler

Query Metrics

21 Database Queries

4 Different statements

0.92 ms Query time

0 Invalid entities

18 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.57 ms
(62.53%)

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?

Parameters:

[
  "16"
  "fr"
  "App\Entity\Surgery"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '16' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Surgery';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 105)
7	Gedmo\Translatable\TranslatableListener->postLoad (line 529)
8	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
10	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
11	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 177)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
15	Doctrine\ORM\AbstractQuery->execute (line 886)
16	Doctrine\ORM\AbstractQuery->getResult (line 688)
17	App\Repository\SurgeryOperationRepository->getSurgeriesGroupedByCategory (line 47)
18	App\Controller\Unauthenticated\ContactController->index (line 40)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.24 ms
(25.90%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.weight AS weight_3, s0_.editor_state AS editor_state_4, s0_.html_content AS html_content_5, c1_.id AS id_6, c1_.name AS name_7, c1_.slug AS slug_8, c1_.created_at AS created_at_9, c1_.updated_at AS updated_at_10, s0_.category_id AS category_id_11, s0_.metadata_id AS metadata_id_12, c1_.metadata_id AS metadata_id_13 FROM surgery s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.weight AS weight_3,
  s0_.editor_state AS editor_state_4,
  s0_.html_content AS html_content_5,
  c1_.id AS id_6,
  c1_.name AS name_7,
  c1_.slug AS slug_8,
  c1_.created_at AS created_at_9,
  c1_.updated_at AS updated_at_10,
  s0_.category_id AS category_id_11,
  s0_.metadata_id AS metadata_id_12,
  c1_.metadata_id AS metadata_id_13
FROM
  surgery s0_
  LEFT JOIN category c1_ ON s0_.category_id = c1_.id

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.weight AS weight_3, s0_.editor_state AS editor_state_4, s0_.html_content AS html_content_5, c1_.id AS id_6, c1_.name AS name_7, c1_.slug AS slug_8, c1_.created_at AS created_at_9, c1_.updated_at AS updated_at_10, s0_.category_id AS category_id_11, s0_.metadata_id AS metadata_id_12, c1_.metadata_id AS metadata_id_13 FROM surgery s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\SurgeryOperationRepository->getSurgeriesGroupedByCategory (line 47)
7	App\Controller\Unauthenticated\ContactController->index (line 40)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.06 ms
(6.77%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.weight AS weight_3, s0_.editor_state AS editor_state_4, s0_.html_content AS html_content_5, s0_.category_id AS category_id_6, s0_.metadata_id AS metadata_id_7 FROM surgery s0_ ORDER BY s0_.weight DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.weight AS weight_3,
  s0_.editor_state AS editor_state_4,
  s0_.html_content AS html_content_5,
  s0_.category_id AS category_id_6,
  s0_.metadata_id AS metadata_id_7
FROM
  surgery s0_
ORDER BY
  s0_.weight DESC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.weight AS weight_3, s0_.editor_state AS editor_state_4, s0_.html_content AS html_content_5, s0_.category_id AS category_id_6, s0_.metadata_id AS metadata_id_7 FROM surgery s0_ ORDER BY s0_.weight DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\SurgeryOperationRepository->getSurgeriesByWeight (line 28)
7	App\Controller\Unauthenticated\ContactController->index (line 41)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.04 ms
(4.79%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.page_title AS page_title_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.keywords AS keywords_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail_id AS thumbnail_id_11 FROM page_metadata t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "contact-page"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.meta_description AS meta_description_4,
  t0.page_title AS page_title_5,
  t0.og_title AS og_title_6,
  t0.og_description AS og_description_7,
  t0.keywords AS keywords_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.thumbnail_id AS thumbnail_id_11
FROM
  page_metadata t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.page_title AS page_title_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.keywords AS keywords_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.thumbnail_id AS thumbnail_id_11 FROM page_metadata t0 WHERE t0.slug = 'contact-page' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\Unauthenticated\ContactController->index (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)

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\Surgery	15
App\Entity\Category	3

Entities Mapping

Class	Mapping errors
App\Entity\Surgery	No errors.
App\Entity\Category	No errors.
App\Entity\PageMetadata	No errors.
App\Entity\WYSIWYGAsset	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
App\Entity\MediaObject	No errors.
App\Entity\StaticMediaObject	No errors.
App\Entity\Post	No errors.
App\Entity\VisitorMessage	No errors.
App\Entity\User	No errors.
App\Entity\PostCategory	No errors.
App\Entity\DocumentMediaObject	No errors.
App\Entity\FAQItem	No errors.
App\Entity\FeedBack	No errors.
App\Entity\JobApplication	No errors.
App\Entity\JobApplicationStatus	No errors.
App\Entity\JobOffer	No errors.
App\Entity\JobOfferContractType	No errors.
App\Entity\Languages	No errors.
App\Entity\Practitioner	No errors.
App\Entity\ServiceAPI	No errors.
App\Entity\TermsAndConditions	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://cliniquechampel.w-ap.dev/fr/contact

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping