Symfony Profiler

Query Metrics

13 Database Queries

3 Different statements

5.92 ms Query time

0 Invalid entities

710 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.26 ms
(38.12%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.doc AS doc_7, t0.intro AS intro_8, t0.is_code AS is_code_9, t0.is_title_show AS is_title_show_10, t0.is_show_intro AS is_show_intro_11, t0.is_archived AS is_archived_12, t0.is_show_created AS is_show_created_13, t0.is_show_read_more AS is_show_read_more_14, t0.is_show_category AS is_show_category_15, t0.is_show_support AS is_show_support_16, t0.is_show_theme AS is_show_theme_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.is_suppr_image AS is_suppr_image_20, t0.is_suppr_doc AS is_suppr_doc_21, t0.author_id AS author_id_22, t0.etablissement_id AS etablissement_id_23, t0.theme_id AS theme_id_24, t0.support_id AS support_id_25 FROM article t0 ORDER BY t0.id DESC

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.content AS content_4,
  t0.image_name AS image_name_5,
  t0.image_size AS image_size_6,
  t0.doc AS doc_7,
  t0.intro AS intro_8,
  t0.is_code AS is_code_9,
  t0.is_title_show AS is_title_show_10,
  t0.is_show_intro AS is_show_intro_11,
  t0.is_archived AS is_archived_12,
  t0.is_show_created AS is_show_created_13,
  t0.is_show_read_more AS is_show_read_more_14,
  t0.is_show_category AS is_show_category_15,
  t0.is_show_support AS is_show_support_16,
  t0.is_show_theme AS is_show_theme_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.is_suppr_image AS is_suppr_image_20,
  t0.is_suppr_doc AS is_suppr_doc_21,
  t0.author_id AS author_id_22,
  t0.etablissement_id AS etablissement_id_23,
  t0.theme_id AS theme_id_24,
  t0.support_id AS support_id_25
FROM
  article t0
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.doc AS doc_7, t0.intro AS intro_8, t0.is_code AS is_code_9, t0.is_title_show AS is_title_show_10, t0.is_show_intro AS is_show_intro_11, t0.is_archived AS is_archived_12, t0.is_show_created AS is_show_created_13, t0.is_show_read_more AS is_show_read_more_14, t0.is_show_category AS is_show_category_15, t0.is_show_support AS is_show_support_16, t0.is_show_theme AS is_show_theme_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.is_suppr_image AS is_suppr_image_20, t0.is_suppr_doc AS is_suppr_doc_21, t0.author_id AS author_id_22, t0.etablissement_id AS etablissement_id_23, t0.theme_id AS theme_id_24, t0.support_id AS support_id_25 FROM article t0 ORDER BY t0.id DESC;

#	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	App\Controller\Webapp\ArticleController->index (line 49)
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 34)
9	require_once (line 32)
10	require_once (line 5)

2.04 ms
(34.43%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_activ AS is_activ_7, t0.is_verified AS is_verified_8, t0.login_name AS login_name_9, t0.avatar_name AS avatar_name_10, t0.avatar_size AS avatar_size_11, t0.typeuser AS typeuser_12, t0.adress1 AS adress1_13, t0.adress2 AS adress2_14, t0.zipcode AS zipcode_15, t0.city AS city_16, t0.phone_desk AS phone_desk_17, t0.phone_gsm AS phone_gsm_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.etablissement_id AS etablissement_id_21 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  20
]

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.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.is_activ AS is_activ_7,
  t0.is_verified AS is_verified_8,
  t0.login_name AS login_name_9,
  t0.avatar_name AS avatar_name_10,
  t0.avatar_size AS avatar_size_11,
  t0.typeuser AS typeuser_12,
  t0.adress1 AS adress1_13,
  t0.adress2 AS adress2_14,
  t0.zipcode AS zipcode_15,
  t0.city AS city_16,
  t0.phone_desk AS phone_desk_17,
  t0.phone_gsm AS phone_gsm_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.etablissement_id AS etablissement_id_21
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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_activ AS is_activ_7, t0.is_verified AS is_verified_8, t0.login_name AS login_name_9, t0.avatar_name AS avatar_name_10, t0.avatar_size AS avatar_size_11, t0.typeuser AS typeuser_12, t0.adress1 AS adress1_13, t0.adress2 AS adress2_14, t0.zipcode AS zipcode_15, t0.city AS city_16, t0.phone_desk AS phone_desk_17, t0.phone_gsm AS phone_gsm_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.etablissement_id AS etablissement_id_21 FROM `user` t0 WHERE t0.id = 20;

#	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\Admin\User::{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\Admin\User->__get (line 153)
7	App\Entity\Admin\User->__toString (line 534)
8	Twig\Runtime\EscaperRuntime->escape (line 126)
9	__TwigTemplate_64872d58f73ef33fcb6609caa04e5fa8->doDisplay (line 78)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1527)
15	__TwigTemplate_5d3f62e2a7d3c82d3b0499ff2b502a94::block_main (line 167)
16	Twig\Template->yieldBlock (line 458)
17	__TwigTemplate_b0685dc2bf954123d148e04c5dfdce9b->doDisplay (line 96)
18	Twig\Template->yield (line 411)
19	__TwigTemplate_5d3f62e2a7d3c82d3b0499ff2b502a94->doDisplay (line 57)
20	Twig\Template->yield (line 411)
21	Twig\Template->display (line 366)
22	Twig\Template->render (line 381)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
28	App\Controller\Webapp\ArticleController->index (line 56)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
33	require_once (line 32)
34	require_once (line 5)

1.62 ms
(27.45%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM theme t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.image_size AS image_size_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  theme t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM theme 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\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Gestapp\Theme::{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\Gestapp\Theme->__get (line 153)
7	App\Entity\Gestapp\Theme->__toString (line 90)
8	Twig\Runtime\EscaperRuntime->escape (line 126)
9	__TwigTemplate_64872d58f73ef33fcb6609caa04e5fa8->doDisplay (line 84)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1527)
15	__TwigTemplate_5d3f62e2a7d3c82d3b0499ff2b502a94::block_main (line 167)
16	Twig\Template->yieldBlock (line 458)
17	__TwigTemplate_b0685dc2bf954123d148e04c5dfdce9b->doDisplay (line 96)
18	Twig\Template->yield (line 411)
19	__TwigTemplate_5d3f62e2a7d3c82d3b0499ff2b502a94->doDisplay (line 57)
20	Twig\Template->yield (line 411)
21	Twig\Template->display (line 366)
22	Twig\Template->render (line 381)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
28	App\Controller\Webapp\ArticleController->index (line 56)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
33	require_once (line 32)
34	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\Webapp\Article	631
App\Entity\Admin\Etablissement	38
App\Entity\Admin\User	31
App\Entity\Gestapp\Theme	6
App\Entity\Gestapp\Support	4

Entities Mapping

Class	Mapping errors
App\Entity\Webapp\Article	No errors.
App\Entity\Admin\User	No errors.
App\Entity\Admin\Etablissement	No errors.
App\Entity\Gestapp\Theme	No errors.
App\Entity\Gestapp\Support	No errors.
App\Entity\Webapp\Category	No errors.
App\Entity\Webapp\Section	No errors.
App\Entity\Gestapp\Ressources	No errors.
App\Entity\Admin\Message	No errors.
App\Entity\Webapp\Comment	No errors.
App\Entity\Webapp\Page	No errors.

Symfony Profiler

GET https://www.collegiens-citoyens.francas40.fr/webapp/articles/?direction=asc&page=16

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping