Symfony Profiler

Query Metrics

29 Database Queries

5 Different statements

22.57 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.95 ms
(35.21%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  11
]

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.token_create AS token_create_5,
  t0.date_ask AS date_ask_6,
  t0.active AS active_7,
  t8.id AS id_9,
  t8.name AS name_10,
  t8.lastname AS lastname_11,
  t8.type_account AS type_account_12,
  t8.phone AS phone_13,
  t8.job AS job_14,
  t8.entreprise AS entreprise_15,
  t8.activite AS activite_16,
  t8.logo AS logo_17,
  t8.adresse AS adresse_18,
  t8.mail_entreprise AS mail_entreprise_19,
  t8.phone_entreprise AS phone_entreprise_20,
  t8.presentation AS presentation_21,
  t8.url_site AS url_site_22,
  t8.url_linkedin AS url_linkedin_23,
  t8.url_facebook AS url_facebook_24,
  t8.picture AS picture_25,
  t8.pseudo AS pseudo_26,
  t8.pseudo_detail AS pseudo_detail_27,
  t8.role AS role_28,
  t8.is_shown_on_map AS is_shown_on_map_29,
  t8.is_active AS is_active_30,
  t8.video AS video_31,
  t8.url_instagram AS url_instagram_32,
  t8.url_twitter AS url_twitter_33,
  t8.audio AS audio_34,
  t8.postal_code AS postal_code_35,
  t8.city AS city_36,
  t8.user_id AS user_id_37
FROM
  user t0
  LEFT JOIN account t8 ON t8.user_id = t0.id
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.token_create AS token_create_5, t0.date_ask AS date_ask_6, t0.active AS active_7, t8.id AS id_9, t8.name AS name_10, t8.lastname AS lastname_11, t8.type_account AS type_account_12, t8.phone AS phone_13, t8.job AS job_14, t8.entreprise AS entreprise_15, t8.activite AS activite_16, t8.logo AS logo_17, t8.adresse AS adresse_18, t8.mail_entreprise AS mail_entreprise_19, t8.phone_entreprise AS phone_entreprise_20, t8.presentation AS presentation_21, t8.url_site AS url_site_22, t8.url_linkedin AS url_linkedin_23, t8.url_facebook AS url_facebook_24, t8.picture AS picture_25, t8.pseudo AS pseudo_26, t8.pseudo_detail AS pseudo_detail_27, t8.role AS role_28, t8.is_shown_on_map AS is_shown_on_map_29, t8.is_active AS is_active_30, t8.video AS video_31, t8.url_instagram AS url_instagram_32, t8.url_twitter AS url_twitter_33, t8.audio AS audio_34, t8.postal_code AS postal_code_35, t8.city AS city_36, t8.user_id AS user_id_37 FROM user t0 LEFT JOIN account t8 ON t8.user_id = t0.id WHERE t0.id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 359)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\User->__get (line 73)
8	App\Entity\User->getRoles (line 71)
9	App\Repository\AccountRepository->App\Repository\{closure} (line 1)
10	array_filter (line 70)
11	App\Repository\AccountRepository->findAllSortedByFormatName (line 78)
12	App\Controller\AccountController->listing (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

7.61 ms
(33.72%)

SELECT t0.id AS id_1, t0.value AS value_2, t0.weight AS weight_3, t0.key_type AS key_type_4 FROM tag t0 INNER JOIN account_tag ON t0.id = account_tag.tag_id WHERE account_tag.account_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.weight AS weight_3,
  t0.key_type AS key_type_4
FROM
  tag t0
  INNER JOIN account_tag ON t0.id = account_tag.tag_id
WHERE
  account_tag.account_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.weight AS weight_3, t0.key_type AS key_type_4 FROM tag t0 INNER JOIN account_tag ON t0.id = account_tag.tag_id WHERE account_tag.account_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2724)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 601)
8	App\Entity\Account->getSearch (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 119)
10	__TwigTemplate_6b05cac48626a37f6457e8170caa6036->block_body (line 446)
11	Twig\Template->yieldBlock (line 183)
12	__TwigTemplate_f16ba98b09b41d522b430636cb404aa3->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_6b05cac48626a37f6457e8170caa6036->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 84)
22	App\Controller\AccountController->listing (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

4.30 ms
(19.04%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.lastname AS lastname_2, a0_.type_account AS type_account_3, a0_.phone AS phone_4, a0_.job AS job_5, a0_.entreprise AS entreprise_6, a0_.activite AS activite_7, a0_.logo AS logo_8, a0_.adresse AS adresse_9, a0_.mail_entreprise AS mail_entreprise_10, a0_.phone_entreprise AS phone_entreprise_11, a0_.presentation AS presentation_12, a0_.url_site AS url_site_13, a0_.url_linkedin AS url_linkedin_14, a0_.url_facebook AS url_facebook_15, a0_.picture AS picture_16, a0_.pseudo AS pseudo_17, a0_.pseudo_detail AS pseudo_detail_18, a0_.role AS role_19, a0_.is_shown_on_map AS is_shown_on_map_20, a0_.is_active AS is_active_21, a0_.video AS video_22, a0_.url_instagram AS url_instagram_23, a0_.url_twitter AS url_twitter_24, a0_.audio AS audio_25, a0_.postal_code AS postal_code_26, a0_.city AS city_27, CASE WHEN a0_.pseudo IS NOT NULL AND a0_.pseudo <> '' THEN a0_.pseudo ELSE CONCAT(a0_.name, ' ', a0_.lastname) END AS sclr_28, a0_.user_id AS user_id_29 FROM account a0_ INNER JOIN user u1_ ON a0_.user_id = u1_.id WHERE u1_.active IS NOT NULL AND u1_.active <> 0 AND u1_.active <> ? ORDER BY sclr_28 ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.lastname AS lastname_2,
  a0_.type_account AS type_account_3,
  a0_.phone AS phone_4,
  a0_.job AS job_5,
  a0_.entreprise AS entreprise_6,
  a0_.activite AS activite_7,
  a0_.logo AS logo_8,
  a0_.adresse AS adresse_9,
  a0_.mail_entreprise AS mail_entreprise_10,
  a0_.phone_entreprise AS phone_entreprise_11,
  a0_.presentation AS presentation_12,
  a0_.url_site AS url_site_13,
  a0_.url_linkedin AS url_linkedin_14,
  a0_.url_facebook AS url_facebook_15,
  a0_.picture AS picture_16,
  a0_.pseudo AS pseudo_17,
  a0_.pseudo_detail AS pseudo_detail_18,
  a0_.role AS role_19,
  a0_.is_shown_on_map AS is_shown_on_map_20,
  a0_.is_active AS is_active_21,
  a0_.video AS video_22,
  a0_.url_instagram AS url_instagram_23,
  a0_.url_twitter AS url_twitter_24,
  a0_.audio AS audio_25,
  a0_.postal_code AS postal_code_26,
  a0_.city AS city_27,
  CASE WHEN a0_.pseudo IS NOT NULL
  AND a0_.pseudo <> '' THEN
    a0_.pseudo
  ELSE
    CONCAT(a0_.name, ' ', a0_.lastname)
  END AS sclr_28,
  a0_.user_id AS user_id_29
FROM
  account a0_
  INNER JOIN user u1_ ON a0_.user_id = u1_.id
WHERE
  u1_.active IS NOT NULL
  AND u1_.active <> 0
  AND u1_.active <> ?
ORDER BY
  sclr_28 ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.lastname AS lastname_2, a0_.type_account AS type_account_3, a0_.phone AS phone_4, a0_.job AS job_5, a0_.entreprise AS entreprise_6, a0_.activite AS activite_7, a0_.logo AS logo_8, a0_.adresse AS adresse_9, a0_.mail_entreprise AS mail_entreprise_10, a0_.phone_entreprise AS phone_entreprise_11, a0_.presentation AS presentation_12, a0_.url_site AS url_site_13, a0_.url_linkedin AS url_linkedin_14, a0_.url_facebook AS url_facebook_15, a0_.picture AS picture_16, a0_.pseudo AS pseudo_17, a0_.pseudo_detail AS pseudo_detail_18, a0_.role AS role_19, a0_.is_shown_on_map AS is_shown_on_map_20, a0_.is_active AS is_active_21, a0_.video AS video_22, a0_.url_instagram AS url_instagram_23, a0_.url_twitter AS url_twitter_24, a0_.audio AS audio_25, a0_.postal_code AS postal_code_26, a0_.city AS city_27, CASE WHEN a0_.pseudo IS NOT NULL AND a0_.pseudo <> '' THEN a0_.pseudo ELSE CONCAT(a0_.name, ' ', a0_.lastname) END AS sclr_28, a0_.user_id AS user_id_29 FROM account a0_ INNER JOIN user u1_ ON a0_.user_id = u1_.id WHERE u1_.active IS NOT NULL AND u1_.active <> 0 AND u1_.active <> 1 ORDER BY sclr_28 ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 68)
7	App\Repository\AccountRepository->findAllSortedByFormatName (line 78)
8	App\Controller\AccountController->listing (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.48 ms
(6.54%)

SELECT t0.id AS id_1, t0.title_key AS title_key_2, t0.title_value AS title_value_3 FROM title t0 WHERE t0.title_key = ? LIMIT 1

Parameters:

[
  "membres"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title_key AS title_key_2,
  t0.title_value AS title_value_3
FROM
  title t0
WHERE
  t0.title_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title_key AS title_key_2, t0.title_value AS title_value_3 FROM title t0 WHERE t0.title_key = 'membres' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 212)
5	App\Controller\DefaultController->title (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 78)
13	__TwigTemplate_eef4f729aae91d49d56ef6bdff0e8267->doDisplay (line 402)
14	Twig\Template->yield (line 83)
15	__TwigTemplate_6b05cac48626a37f6457e8170caa6036->block_body (line 446)
16	Twig\Template->yieldBlock (line 183)
17	__TwigTemplate_f16ba98b09b41d522b430636cb404aa3->doDisplay (line 402)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_6b05cac48626a37f6457e8170caa6036->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 243)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 84)
27	App\Controller\AccountController->listing (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

1.24 ms
(5.49%)

SELECT t0.id AS id_1, t0.description_key AS description_key_2, t0.description_value AS description_value_3 FROM description t0 WHERE t0.description_key = ? LIMIT 1

Parameters:

[
  "membres"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description_key AS description_key_2,
  t0.description_value AS description_value_3
FROM
  description t0
WHERE
  t0.description_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.description_key AS description_key_2, t0.description_value AS description_value_3 FROM description t0 WHERE t0.description_key = 'membres' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 224)
5	App\Controller\DefaultController->description (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 78)
13	__TwigTemplate_3c9c32e7476ec6f48f7f34c911fc2807->doDisplay (line 402)
14	Twig\Template->yield (line 86)
15	__TwigTemplate_6b05cac48626a37f6457e8170caa6036->block_body (line 446)
16	Twig\Template->yieldBlock (line 183)
17	__TwigTemplate_f16ba98b09b41d522b430636cb404aa3->doDisplay (line 402)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_6b05cac48626a37f6457e8170caa6036->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 243)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 84)
27	App\Controller\AccountController->listing (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	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.

Entities Mapping

Class	Mapping errors
App\Entity\Account	No errors.
App\Entity\User	No errors.
App\Entity\Article	No errors.
App\Entity\Tag	No errors.
App\Entity\Title	No errors.
App\Entity\ArticleCategory	No errors.
App\Entity\ArticleContent	No errors.
App\Entity\Member	No errors.
App\Entity\Description	No errors.

Symfony Profiler

GET https://www.lodp-test.nerepix.fr/membres

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping