Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.88 ms Query time

1 Invalid entities

6 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.52 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.active AS active_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.is_subscription_active AS is_subscription_active_8, t0.stripe_subscription_id AS stripe_subscription_id_9, t0.pennylane_customer_id AS pennylane_customer_id_10, t0.pricing_plan_id AS pricing_plan_id_11 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.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.active AS active_6,
  t0.stripe_customer_id AS stripe_customer_id_7,
  t0.is_subscription_active AS is_subscription_active_8,
  t0.stripe_subscription_id AS stripe_subscription_id_9,
  t0.pennylane_customer_id AS pennylane_customer_id_10,
  t0.pricing_plan_id AS pricing_plan_id_11
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.active AS active_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.is_subscription_active AS is_subscription_active_8, t0.stripe_subscription_id AS stripe_subscription_id_9, t0.pennylane_customer_id AS pennylane_customer_id_10, t0.pricing_plan_id AS pricing_plan_id_11 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\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
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 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
22	frankenphp_handle_request (line 45)
23	Runtime\FrankenPhpSymfony\Runner::run (line 45)
24	require_once (line 32)
25	require_once (line 5)

0.37 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.mail AS mail_3, t0.telephone AS telephone_4, t0.objectif_site AS objectif_site_5, t0.secteur_activite AS secteur_activite_6, t0.consentement_rgpd AS consentement_rgpd_7, t0.outils_tiers AS outils_tiers_8, t0.nom_de_rue AS nom_de_rue_9, t0.numero AS numero_10, t0.code_postale AS code_postale_11, t0.ville AS ville_12, t0.pays AS pays_13, t0.owner_id AS owner_id_14, t0.dtype, t0.raison_sociale AS raison_sociale_15, t0.forme_juridique AS forme_juridique_16, t0.siret AS siret_17, t0.tva_intracom AS tva_intracom_18, t0.nom_responsable_legal AS nom_responsable_legal_19, t0.type_projet AS type_projet_20 FROM user_information t0 WHERE t0.owner_id = ? AND t0.dtype IN ('user_info', 'entreprise', 'autre')

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.mail AS mail_3,
  t0.telephone AS telephone_4,
  t0.objectif_site AS objectif_site_5,
  t0.secteur_activite AS secteur_activite_6,
  t0.consentement_rgpd AS consentement_rgpd_7,
  t0.outils_tiers AS outils_tiers_8,
  t0.nom_de_rue AS nom_de_rue_9,
  t0.numero AS numero_10,
  t0.code_postale AS code_postale_11,
  t0.ville AS ville_12,
  t0.pays AS pays_13,
  t0.owner_id AS owner_id_14,
  t0.dtype,
  t0.raison_sociale AS raison_sociale_15,
  t0.forme_juridique AS forme_juridique_16,
  t0.siret AS siret_17,
  t0.tva_intracom AS tva_intracom_18,
  t0.nom_responsable_legal AS nom_responsable_legal_19,
  t0.type_projet AS type_projet_20
FROM
  user_information t0
WHERE
  t0.owner_id = ?
  AND t0.dtype IN (
    'user_info', 'entreprise', 'autre'
  )

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.mail AS mail_3, t0.telephone AS telephone_4, t0.objectif_site AS objectif_site_5, t0.secteur_activite AS secteur_activite_6, t0.consentement_rgpd AS consentement_rgpd_7, t0.outils_tiers AS outils_tiers_8, t0.nom_de_rue AS nom_de_rue_9, t0.numero AS numero_10, t0.code_postale AS code_postale_11, t0.ville AS ville_12, t0.pays AS pays_13, t0.owner_id AS owner_id_14, t0.dtype, t0.raison_sociale AS raison_sociale_15, t0.forme_juridique AS forme_juridique_16, t0.siret AS siret_17, t0.tva_intracom AS tva_intracom_18, t0.nom_responsable_legal AS nom_responsable_legal_19, t0.type_projet AS type_projet_20 FROM user_information t0 WHERE t0.owner_id = 1 AND t0.dtype IN ('user_info', 'entreprise', 'autre');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 176)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
9	Doctrine\ORM\EntityManager->find (line 366)
10	Doctrine\ORM\EntityRepository->find (line 86)
11	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
12	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
13	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
14	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
28	frankenphp_handle_request (line 45)
29	Runtime\FrankenPhpSymfony\Runner::run (line 45)
30	require_once (line 32)
31	require_once (line 5)

0.64 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.domaine_id AS domaine_id_6, t0.site_id AS site_id_7, t0.user_id AS user_id_8 FROM sub_domain t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.domaine_id AS domaine_id_6,
  t0.site_id AS site_id_7,
  t0.user_id AS user_id_8
FROM
  sub_domain t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.domaine_id AS domaine_id_6, t0.site_id AS site_id_7, t0.user_id AS user_id_8 FROM sub_domain 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\Admin\AdminDomainController->index (line 21)
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	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
10	frankenphp_handle_request (line 45)
11	Runtime\FrankenPhpSymfony\Runner::run (line 45)
12	require_once (line 32)
13	require_once (line 5)

0.36 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.published AS published_3, t0.owner_id AS owner_id_4 FROM site t0 WHERE t0.id = ?

Parameters:

[
  78
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.published AS published_3,
  t0.owner_id AS owner_id_4
FROM
  site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.published AS published_3, t0.owner_id AS owner_id_4 FROM site t0 WHERE t0.id = 78;

#	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::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Site::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Site->__get (line 153)
7	App\Entity\Site->getName (line 69)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_7ff00eb28e03070564474aa61ea8be77::block_body (line 182)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_265ecae6d530c4b5e55d76ada0631b74->doDisplay (line 86)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_7ff00eb28e03070564474aa61ea8be77->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\Admin\AdminDomainController->index (line 20)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
27	frankenphp_handle_request (line 45)
28	Runtime\FrankenPhpSymfony\Runner::run (line 45)
29	require_once (line 32)
30	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\User	1
App\Entity\UserInformation	1
App\Entity\PricingPlan	1
App\Entity\SubDomain	1
App\Entity\Domaine	1
App\Entity\Site	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserInformation	No errors.
App\Entity\PricingPlan	No errors.
App\Entity\EntrepriseUserInfo	No errors.
App\Entity\AutreUserInfo	No errors.
App\Entity\Domaine	No errors.
App\Entity\Site	No errors.
App\Entity\Page	No errors.
App\Entity\NewsletterSubscription	No errors.
App\Entity\Newsletter	No errors.
App\Entity\SubDomain	The association App\Entity\SubDomain#user refers to the inverse side field App\Entity\User#ownedSubDomains which does not exist.
App\Entity\Functionality	No errors.
App\Entity\PromoCode	No errors.
App\Entity\PageBloc	No errors.

Symfony Profiler

GET https://pep.devlogiciel.com/admin/domaines/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping