Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

10.65 ms Query time

0 Invalid entities

12 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.37 ms
(22.30%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.description AS description_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.provisioning_pending AS provisioning_pending_8, t0.provisioning_attempts AS provisioning_attempts_9, t0.provisioned_at AS provisioned_at_10, t0.user_info_id AS user_info_id_11 FROM domaine t0 WHERE t0.type = ?

Parameters:

[
  "system"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.description AS description_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.provisioning_pending AS provisioning_pending_8,
  t0.provisioning_attempts AS provisioning_attempts_9,
  t0.provisioned_at AS provisioned_at_10,
  t0.user_info_id AS user_info_id_11
FROM
  domaine t0
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.description AS description_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.provisioning_pending AS provisioning_pending_8, t0.provisioning_attempts AS provisioning_attempts_9, t0.provisioned_at AS provisioned_at_10, t0.user_info_id AS user_info_id_11 FROM domaine t0 WHERE t0.type = 'system';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Service\SystemDomainService->getSystemDomains (line 27)
5	App\Service\SystemDomainService->isSystemDomain (line 50)
6	App\EventSubscriber\ClientDomainRoutingSubscriber->onKernelRequest (line 66)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
13	Symfony\Component\HttpKernel\Kernel->handle (line 143)
14	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
15	frankenphp_handle_request (line 72)
16	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
17	require_once (line 32)
18	require_once (line 6)

1.68 ms
(15.80%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.objectif_site AS objectif_site_4, t0.secteur_activite AS secteur_activite_5, t0.consentement_rgpd AS consentement_rgpd_6, t0.outils_tiers AS outils_tiers_7, t0.nom_de_rue AS nom_de_rue_8, t0.numero AS numero_9, t0.code_postal AS code_postal_10, t0.ville AS ville_11, t0.pays AS pays_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted AS deleted_16, t0.owner_id AS owner_id_17, t0.dtype, t0.raison_sociale AS raison_sociale_18, t0.forme_juridique AS forme_juridique_19, t0.siret AS siret_20, t0.tva_intracom AS tva_intracom_21, t0.nom_responsable_legal AS nom_responsable_legal_22, t0.type_projet AS type_projet_23 FROM user_information t0 WHERE t0.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.telephone AS telephone_3,
  t0.objectif_site AS objectif_site_4,
  t0.secteur_activite AS secteur_activite_5,
  t0.consentement_rgpd AS consentement_rgpd_6,
  t0.outils_tiers AS outils_tiers_7,
  t0.nom_de_rue AS nom_de_rue_8,
  t0.numero AS numero_9,
  t0.code_postal AS code_postal_10,
  t0.ville AS ville_11,
  t0.pays AS pays_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.deleted AS deleted_16,
  t0.owner_id AS owner_id_17,
  t0.dtype,
  t0.raison_sociale AS raison_sociale_18,
  t0.forme_juridique AS forme_juridique_19,
  t0.siret AS siret_20,
  t0.tva_intracom AS tva_intracom_21,
  t0.nom_responsable_legal AS nom_responsable_legal_22,
  t0.type_projet AS type_projet_23
FROM
  user_information t0
WHERE
  t0.id = ?
  AND t0.dtype IN (
    'user_info', 'entreprise', 'autre'
  )

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.objectif_site AS objectif_site_4, t0.secteur_activite AS secteur_activite_5, t0.consentement_rgpd AS consentement_rgpd_6, t0.outils_tiers AS outils_tiers_7, t0.nom_de_rue AS nom_de_rue_8, t0.numero AS numero_9, t0.code_postal AS code_postal_10, t0.ville AS ville_11, t0.pays AS pays_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted AS deleted_16, t0.owner_id AS owner_id_17, t0.dtype, t0.raison_sociale AS raison_sociale_18, t0.forme_juridique AS forme_juridique_19, t0.siret AS siret_20, t0.tva_intracom AS tva_intracom_21, t0.nom_responsable_legal AS nom_responsable_legal_22, t0.type_projet AS type_projet_23 FROM user_information t0 WHERE t0.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 782)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2535)
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 176)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 967)
8	Doctrine\ORM\EntityRepository->findBy (line 110)
9	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
10	App\Service\SystemDomainService->getSystemDomains (line 27)
11	App\Service\SystemDomainService->isSystemDomain (line 50)
12	App\EventSubscriber\ClientDomainRoutingSubscriber->onKernelRequest (line 66)
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 162)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
19	Symfony\Component\HttpKernel\Kernel->handle (line 143)
20	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
21	frankenphp_handle_request (line 72)
22	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
23	require_once (line 32)
24	require_once (line 6)

1.24 ms
(11.66%)

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.subscription_active AS subscription_active_8, t0.stripe_subscription_id AS stripe_subscription_id_9, t0.pennylane_customer_id AS pennylane_customer_id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.subscription_end_date AS subscription_end_date_14, t0.pricing_plan_id AS pricing_plan_id_15 FROM "user" t0 WHERE t0.id = ?

Parameters:

[
  5
]

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.subscription_active AS subscription_active_8,
  t0.stripe_subscription_id AS stripe_subscription_id_9,
  t0.pennylane_customer_id AS pennylane_customer_id_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.subscription_end_date AS subscription_end_date_14,
  t0.pricing_plan_id AS pricing_plan_id_15
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.subscription_active AS subscription_active_8, t0.stripe_subscription_id AS stripe_subscription_id_9, t0.pennylane_customer_id AS pennylane_customer_id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.subscription_end_date AS subscription_end_date_14, t0.pricing_plan_id AS pricing_plan_id_15 FROM "user" t0 WHERE t0.id = 5;

#	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 1801)
5	__TwigTemplate_366ec263ee9b2701704a1789fb403cf7::doDisplay (line 159)
6	Twig\Template->yield (line 411)
7	__TwigTemplate_d0440356595d18b828b3cfff023e79a5->doDisplay (line 54)
8	Twig\Template->yield (line 411)
9	Twig\Template->display (line 366)
10	Twig\Template->render (line 381)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	App\Service\PageRenderService->renderPageLogic (line 96)
14	App\Controller\HomeController->handleClientHome (line 237)
15	App\Controller\HomeController->index (line 180)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
18	Symfony\Component\HttpKernel\Kernel->handle (line 143)
19	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
20	frankenphp_handle_request (line 72)
21	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
22	require_once (line 32)
23	require_once (line 6)

1.13 ms
(10.57%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.home_page AS home_page_4, t0.folder AS folder_5, t0.published AS published_6, t0.protected AS protected_7, t0.type_page AS type_page_8, t0.description AS description_9, t0.title_seo AS title_seo_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.deleted AS deleted_14, t0.site_id AS site_id_15 FROM page t0 WHERE t0.site_id = ? AND t0.home_page = ? AND t0.published = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.home_page AS home_page_4,
  t0.folder AS folder_5,
  t0.published AS published_6,
  t0.protected AS protected_7,
  t0.type_page AS type_page_8,
  t0.description AS description_9,
  t0.title_seo AS title_seo_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.deleted AS deleted_14,
  t0.site_id AS site_id_15
FROM
  page t0
WHERE
  t0.site_id = ?
  AND t0.home_page = ?
  AND t0.published = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.home_page AS home_page_4, t0.folder AS folder_5, t0.published AS published_6, t0.protected AS protected_7, t0.type_page AS type_page_8, t0.description AS description_9, t0.title_seo AS title_seo_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.deleted AS deleted_14, t0.site_id AS site_id_15 FROM page t0 WHERE t0.site_id = 19 AND t0.home_page = 1 AND t0.published = 1 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\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\HomeController->handleClientHome (line 220)
5	App\Controller\HomeController->index (line 180)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
8	Symfony\Component\HttpKernel\Kernel->handle (line 143)
9	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
10	frankenphp_handle_request (line 72)
11	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
12	require_once (line 32)
13	require_once (line 6)

1.03 ms
(9.65%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.domaine_id AS domaine_id_5, s0_.site_id AS site_id_6, s0_.user_id AS user_id_7 FROM sub_domain s0_ INNER JOIN domaine d1_ ON s0_.domaine_id = d1_.id WHERE s0_.name = ? AND (d1_.url = ? OR d1_.url = ?)

Parameters:

[
  "bbernier3"
  "devlogiciel.com"
  ".devlogiciel.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.created_at AS created_at_2,
  s0_.updated_at AS updated_at_3,
  s0_.deleted_at AS deleted_at_4,
  s0_.domaine_id AS domaine_id_5,
  s0_.site_id AS site_id_6,
  s0_.user_id AS user_id_7
FROM
  sub_domain s0_
  INNER JOIN domaine d1_ ON s0_.domaine_id = d1_.id
WHERE
  s0_.name = ?
  AND (
    d1_.url = ?
    OR d1_.url = ?
  )

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.domaine_id AS domaine_id_5, s0_.site_id AS site_id_6, s0_.user_id AS user_id_7 FROM sub_domain s0_ INNER JOIN domaine d1_ ON s0_.domaine_id = d1_.id WHERE s0_.name = 'bbernier3' AND (d1_.url = 'devlogiciel.com' OR d1_.url = '.devlogiciel.com');

#	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->getOneOrNullResult (line 737)
6	App\Controller\HomeController->resolveSite (line 280)
7	App\Controller\HomeController->handleClientHome (line 218)
8	App\Controller\HomeController->index (line 180)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
11	Symfony\Component\HttpKernel\Kernel->handle (line 143)
12	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
13	frankenphp_handle_request (line 72)
14	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
15	require_once (line 32)
16	require_once (line 6)

0.99 ms
(9.31%)

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 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "bbernier3.devlogiciel.com"
]

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
WHERE
  t0.name = ?
LIMIT
  1

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 WHERE t0.name = 'bbernier3.devlogiciel.com' 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\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\HomeController->resolveSite (line 264)
5	App\Controller\HomeController->handleClientHome (line 218)
6	App\Controller\HomeController->index (line 180)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
9	Symfony\Component\HttpKernel\Kernel->handle (line 143)
10	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
11	frankenphp_handle_request (line 72)
12	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
13	require_once (line 32)
14	require_once (line 6)

0.91 ms
(8.58%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.published AS published_3, t0.is_template AS is_template_4, t0.is_in_catalogue AS is_in_catalogue_5, t0.screenshot_path AS screenshot_path_6, t0.background_color AS background_color_7, t0.favicon AS favicon_8, t0.description AS description_9, t0.custom_sender_email AS custom_sender_email_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.deleted AS deleted_14, t0.owner_id AS owner_id_15, t0.category_id AS category_id_16 FROM site t0 WHERE t0.id = ?

Parameters:

[
  19
]

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.is_template AS is_template_4,
  t0.is_in_catalogue AS is_in_catalogue_5,
  t0.screenshot_path AS screenshot_path_6,
  t0.background_color AS background_color_7,
  t0.favicon AS favicon_8,
  t0.description AS description_9,
  t0.custom_sender_email AS custom_sender_email_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.deleted AS deleted_14,
  t0.owner_id AS owner_id_15,
  t0.category_id AS category_id_16
FROM
  site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.published AS published_3, t0.is_template AS is_template_4, t0.is_in_catalogue AS is_in_catalogue_5, t0.screenshot_path AS screenshot_path_6, t0.background_color AS background_color_7, t0.favicon AS favicon_8, t0.description AS description_9, t0.custom_sender_email AS custom_sender_email_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.deleted AS deleted_14, t0.owner_id AS owner_id_15, t0.category_id AS category_id_16 FROM site t0 WHERE t0.id = 19;

#	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	App\Entity\Site::isPublished (line 176)
5	App\Controller\HomeController->resolveSite (line 297)
6	App\Controller\HomeController->handleClientHome (line 218)
7	App\Controller\HomeController->index (line 180)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
12	frankenphp_handle_request (line 72)
13	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
14	require_once (line 32)
15	require_once (line 6)

0.76 ms
(7.10%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.background_color AS background_color_3, t0.is_synced AS is_synced_4, t0.page_id AS page_id_5, t0.bloc_id AS bloc_id_6 FROM page_bloc t0 WHERE t0.page_id = ?

Parameters:

[
  67
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.background_color AS background_color_3,
  t0.is_synced AS is_synced_4,
  t0.page_id AS page_id_5,
  t0.bloc_id AS bloc_id_6
FROM
  page_bloc t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.background_color AS background_color_3, t0.is_synced AS is_synced_4, t0.page_id AS page_id_5, t0.bloc_id AS bloc_id_6 FROM page_bloc t0 WHERE t0.page_id = 67;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->isEmpty (line 446)
9	App\Service\PageRenderService->renderPageLogic (line 63)
10	App\Controller\HomeController->handleClientHome (line 237)
11	App\Controller\HomeController->index (line 180)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
14	Symfony\Component\HttpKernel\Kernel->handle (line 143)
15	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
16	frankenphp_handle_request (line 72)
17	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
18	require_once (line 32)
19	require_once (line 6)

0.54 ms
(5.03%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.objectif_site AS objectif_site_4, t0.secteur_activite AS secteur_activite_5, t0.consentement_rgpd AS consentement_rgpd_6, t0.outils_tiers AS outils_tiers_7, t0.nom_de_rue AS nom_de_rue_8, t0.numero AS numero_9, t0.code_postal AS code_postal_10, t0.ville AS ville_11, t0.pays AS pays_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted AS deleted_16, t0.owner_id AS owner_id_17, t0.dtype, t0.raison_sociale AS raison_sociale_18, t0.forme_juridique AS forme_juridique_19, t0.siret AS siret_20, t0.tva_intracom AS tva_intracom_21, t0.nom_responsable_legal AS nom_responsable_legal_22, t0.type_projet AS type_projet_23 FROM user_information t0 WHERE t0.owner_id = ? AND t0.dtype IN ('user_info', 'entreprise', 'autre')

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.telephone AS telephone_3,
  t0.objectif_site AS objectif_site_4,
  t0.secteur_activite AS secteur_activite_5,
  t0.consentement_rgpd AS consentement_rgpd_6,
  t0.outils_tiers AS outils_tiers_7,
  t0.nom_de_rue AS nom_de_rue_8,
  t0.numero AS numero_9,
  t0.code_postal AS code_postal_10,
  t0.ville AS ville_11,
  t0.pays AS pays_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.deleted AS deleted_16,
  t0.owner_id AS owner_id_17,
  t0.dtype,
  t0.raison_sociale AS raison_sociale_18,
  t0.forme_juridique AS forme_juridique_19,
  t0.siret AS siret_20,
  t0.tva_intracom AS tva_intracom_21,
  t0.nom_responsable_legal AS nom_responsable_legal_22,
  t0.type_projet AS type_projet_23
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.telephone AS telephone_3, t0.objectif_site AS objectif_site_4, t0.secteur_activite AS secteur_activite_5, t0.consentement_rgpd AS consentement_rgpd_6, t0.outils_tiers AS outils_tiers_7, t0.nom_de_rue AS nom_de_rue_8, t0.numero AS numero_9, t0.code_postal AS code_postal_10, t0.ville AS ville_11, t0.pays AS pays_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted AS deleted_16, t0.owner_id AS owner_id_17, t0.dtype, t0.raison_sociale AS raison_sociale_18, t0.forme_juridique AS forme_juridique_19, t0.siret AS siret_20, t0.tva_intracom AS tva_intracom_21, t0.nom_responsable_legal AS nom_responsable_legal_22, t0.type_projet AS type_projet_23 FROM user_information t0 WHERE t0.owner_id = 5 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 2462)
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 176)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
9	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
10	Twig\Extension\CoreExtension::getAttribute (line 1801)
11	__TwigTemplate_366ec263ee9b2701704a1789fb403cf7::doDisplay (line 159)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_d0440356595d18b828b3cfff023e79a5->doDisplay (line 54)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	App\Service\PageRenderService->renderPageLogic (line 96)
20	App\Controller\HomeController->handleClientHome (line 237)
21	App\Controller\HomeController->index (line 180)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
24	Symfony\Component\HttpKernel\Kernel->handle (line 143)
25	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():51} (line 62)
26	frankenphp_handle_request (line 72)
27	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 72)
28	require_once (line 32)
29	require_once (line 6)

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\Domaine	5
App\Entity\UserInformation	2
App\Entity\User	2
App\Entity\SubDomain	1
App\Entity\Site	1
App\Entity\Page	1

Entities Mapping

Class	Mapping errors
App\Entity\Domaine	No errors.
App\Entity\UserInformation	No errors.
App\Entity\User	No errors.
App\Entity\EntrepriseUserInfo	No errors.
App\Entity\AutreUserInfo	No errors.
App\Entity\SubDomain	No errors.
App\Entity\Site	No errors.
App\Entity\SiteCategory	No errors.
App\Entity\Page	No errors.
App\Entity\NewsletterSubscription	No errors.
App\Entity\Newsletter	No errors.
App\Entity\Employee	No errors.
App\Entity\AppointmentType	No errors.
App\Entity\PageBloc	No errors.
App\Entity\Bloc	No errors.
App\Entity\PricingPlan	No errors.
App\Entity\AvisUtilisateurs	No errors.
App\Entity\Ticket	No errors.
App\Entity\NewsletterLog	No errors.
App\Entity\Appointment	No errors.

GET https://bbernier3.devlogiciel.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping