Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

0.99 ms Query time

1 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.35 ms
(35.20%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.titre AS titre_3, t0.meta_description AS meta_description_4, t0.meta_title AS meta_title_5, t0.blocs AS blocs_6, t0.active AS active_7, t0.systeme AS systeme_8, t0.ordre AS ordre_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.site_id AS site_id_12 FROM agence_page t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.titre AS titre_3,
  t0.meta_description AS meta_description_4,
  t0.meta_title AS meta_title_5,
  t0.blocs AS blocs_6,
  t0.active AS active_7,
  t0.systeme AS systeme_8,
  t0.ordre AS ordre_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.site_id AS site_id_12
FROM
  agence_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.titre AS titre_3, t0.meta_description AS meta_description_4, t0.meta_title AS meta_title_5, t0.blocs AS blocs_6, t0.active AS active_7, t0.systeme AS systeme_8, t0.ordre AS ordre_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.site_id AS site_id_12 FROM agence_page t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	App\Controller\Admin\AgenceSiteController->editPage (line 121)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 4)

0.27 ms
(27.58%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.adresse AS adresse_6, t0.npa AS npa_7, t0.actif AS actif_8, t0.afficher_listing AS afficher_listing_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t12.id AS id_13, t12.theme AS theme_14, t12.logo_path AS logo_path_15, t12.primary_color AS primary_color_16, t12.secondary_color AS secondary_color_17, t12.default_resolution AS default_resolution_18, t12.created_at AS created_at_19, t12.updated_at AS updated_at_20, t12.agence_id AS agence_id_21, t0.subscription_plan_id AS subscription_plan_id_22 FROM agence t0 LEFT JOIN agence_pdf_settings t12 ON t12.agence_id = t0.id WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ville AS ville_3,
  t0.telephone AS telephone_4,
  t0.email AS email_5,
  t0.adresse AS adresse_6,
  t0.npa AS npa_7,
  t0.actif AS actif_8,
  t0.afficher_listing AS afficher_listing_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t12.id AS id_13,
  t12.theme AS theme_14,
  t12.logo_path AS logo_path_15,
  t12.primary_color AS primary_color_16,
  t12.secondary_color AS secondary_color_17,
  t12.default_resolution AS default_resolution_18,
  t12.created_at AS created_at_19,
  t12.updated_at AS updated_at_20,
  t12.agence_id AS agence_id_21,
  t0.subscription_plan_id AS subscription_plan_id_22
FROM
  agence t0
  LEFT JOIN agence_pdf_settings t12 ON t12.agence_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.adresse AS adresse_6, t0.npa AS npa_7, t0.actif AS actif_8, t0.afficher_listing AS afficher_listing_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t12.id AS id_13, t12.theme AS theme_14, t12.logo_path AS logo_path_15, t12.primary_color AS primary_color_16, t12.secondary_color AS secondary_color_17, t12.default_resolution AS default_resolution_18, t12.created_at AS created_at_19, t12.updated_at AS updated_at_20, t12.agence_id AS agence_id_21, t0.subscription_plan_id AS subscription_plan_id_22 FROM agence t0 LEFT JOIN agence_pdf_settings t12 ON t12.agence_id = t0.id WHERE t0.id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1795)
5	__TwigTemplate_30043360690ace6cbdd462e047871699::block_breadcrumb (line 136)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_5c24f48faeb9243ee611d5862e8cd0cd->block_page_header (line 240)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_5c24f48faeb9243ee611d5862e8cd0cd->doDisplay (line 111)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_30043360690ace6cbdd462e047871699->doDisplay (line 59)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
20	App\Controller\Admin\AgenceSiteController->editPage (line 141)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 4)

0.22 ms
(22.04%)

SELECT t0.id AS id_1, t0.domaine AS domaine_2, t0.actif AS actif_3, t0.template AS template_4, t0.config AS config_5, t0.infos AS infos_6, t0.menu AS menu_7, t0.seo AS seo_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.agence_id AS agence_id_11 FROM agence_site t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.domaine AS domaine_2,
  t0.actif AS actif_3,
  t0.template AS template_4,
  t0.config AS config_5,
  t0.infos AS infos_6,
  t0.menu AS menu_7,
  t0.seo AS seo_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.agence_id AS agence_id_11
FROM
  agence_site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.domaine AS domaine_2, t0.actif AS actif_3, t0.template AS template_4, t0.config AS config_5, t0.infos AS infos_6, t0.menu AS menu_7, t0.seo AS seo_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.agence_id AS agence_id_11 FROM agence_site t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	App\Controller\Admin\AgenceSiteController->editPage (line 120)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 4)

0.15 ms
(15.18%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.roles AS roles_5, t0.password AS password_6, t0.actif AS actif_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.agence_role AS agence_role_10, t0.active_session_token AS active_session_token_11, t0.agence_id AS agence_id_12 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.prenom AS prenom_3,
  t0.nom AS nom_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.actif AS actif_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.agence_role AS agence_role_10,
  t0.active_session_token AS active_session_token_11,
  t0.agence_id AS agence_id_12
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.roles AS roles_5, t0.password AS password_6, t0.actif AS actif_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.agence_role AS agence_role_10, t0.active_session_token AS active_session_token_11, t0.agence_id AS agence_id_12 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 191)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 4)

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\User	1
App\Entity\AgenceSite	1
App\Entity\Agence	1
App\Entity\AgencePage	1
App\Entity\SubscriptionPlan	1
App\Entity\AgencePdfSettings	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Agence	The field App\Entity\Agence#pdfSettings is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AgencePdfSettings#agence does not contain the required 'inversedBy: "pdfSettings"' attribute.
App\Entity\AgenceSite	No errors.
App\Entity\AgencePage	No errors.
App\Entity\AgencePdfSettings	No errors.
App\Entity\SubscriptionPlan	No errors.
App\Entity\AgencePdfTemplate	No errors.
App\Entity\SubscriptionOption	No errors.

Symfony Profiler

GET https://dev.casaq.ch/admin/sites/1/pages/1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping