Symfony Profiler

Query Metrics

86 Database Queries

5 Different statements

34.84 ms Query time

0 Invalid entities

88 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

31.68 ms
(90.93%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.active AS active_3, t0.force_display AS force_display_4, t0.type AS type_5, t0.date_add AS date_add_6, t0.date_up AS date_up_7, t0.level AS level_8, t0.name AS name_9, t0.description AS description_10, t0.slug AS slug_11, t0.parent_id AS parent_id_12 FROM mg_categories t0 WHERE t0.id = ? AND t0.active = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.active AS active_3,
  t0.force_display AS force_display_4,
  t0.type AS type_5,
  t0.date_add AS date_add_6,
  t0.date_up AS date_up_7,
  t0.level AS level_8,
  t0.name AS name_9,
  t0.description AS description_10,
  t0.slug AS slug_11,
  t0.parent_id AS parent_id_12
FROM
  mg_categories t0
WHERE
  t0.id = ?
  AND t0.active = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.active AS active_3, t0.force_display AS force_display_4, t0.type AS type_5, t0.date_add AS date_add_6, t0.date_up AS date_up_7, t0.level AS level_8, t0.name AS name_9, t0.description AS description_10, t0.slug AS slug_11, t0.parent_id AS parent_id_12 FROM mg_categories t0 WHERE t0.id = 2 AND t0.active = 1;

#	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\MenusController->displayMenuCat (line 77)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
12	__TwigTemplate_bfc9f02accdd7b8f73455dbf33d43544->doDisplay (line 248)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_4082c3540de010b9b60f2ec176451f64->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\SecurityController->login (line 25)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

1.41 ms
(4.05%)

SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.active AS active_2, m0_.force_display AS force_display_3, m0_.type AS type_4, m0_.date_add AS date_add_5, m0_.date_up AS date_up_6, m0_.level AS level_7, m0_.name AS name_8, m0_.description AS description_9, m0_.slug AS slug_10, m0_.parent_id AS parent_id_11 FROM mg_categories m0_ WHERE m0_.active = 1 AND m0_.id <> 1 AND m0_.level < 3 ORDER BY m0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.position AS position_1,
  m0_.active AS active_2,
  m0_.force_display AS force_display_3,
  m0_.type AS type_4,
  m0_.date_add AS date_add_5,
  m0_.date_up AS date_up_6,
  m0_.level AS level_7,
  m0_.name AS name_8,
  m0_.description AS description_9,
  m0_.slug AS slug_10,
  m0_.parent_id AS parent_id_11
FROM
  mg_categories m0_
WHERE
  m0_.active = 1
  AND m0_.id <> 1
  AND m0_.level < 3
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.active AS active_2, m0_.force_display AS force_display_3, m0_.type AS type_4, m0_.date_add AS date_add_5, m0_.date_up AS date_up_6, m0_.level AS level_7, m0_.name AS name_8, m0_.description AS description_9, m0_.slug AS slug_10, m0_.parent_id AS parent_id_11 FROM mg_categories m0_ WHERE m0_.active = 1 AND m0_.id <> 1 AND m0_.level < 3 ORDER BY m0_.position ASC;

#	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->getResult (line 688)
6	App\Repository\MgCategoriesRepository->buildMenuCat (line 33)
7	App\Controller\MenusController->displayMenuCat (line 66)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_bfc9f02accdd7b8f73455dbf33d43544->doDisplay (line 248)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_4082c3540de010b9b60f2ec176451f64->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
26	App\Controller\SecurityController->login (line 25)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.75 ms
(2.15%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slogan AS slogan_3, t0.seo_description AS seo_description_4, t0.email_contact AS email_contact_5, t0.email_order AS email_order_6, t0.logo AS logo_7, t0.nb_posts AS nb_posts_8 FROM mg_parameters t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slogan AS slogan_3,
  t0.seo_description AS seo_description_4,
  t0.email_contact AS email_contact_5,
  t0.email_order AS email_order_6,
  t0.logo AS logo_7,
  t0.nb_posts AS nb_posts_8
FROM
  mg_parameters t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slogan AS slogan_3, t0.seo_description AS seo_description_4, t0.email_contact AS email_contact_5, t0.email_order AS email_order_6, t0.logo AS logo_7, t0.nb_posts AS nb_posts_8 FROM mg_parameters 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	App\Services\AppService->getParams (line 20)
7	Twig\Extension\CoreExtension->getAttribute (line 1913)
8	__TwigTemplate_bfc9f02accdd7b8f73455dbf33d43544::doDisplay (line 64)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_4082c3540de010b9b60f2ec176451f64->doDisplay (line 54)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
19	App\Controller\SecurityController->login (line 25)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.62 ms
(1.78%)

SELECT t0.id AS id_1, t0.address_title AS address_title_2, t0.parameter_address_id AS parameter_address_id_3, t0.lang_id AS lang_id_4 FROM mg_parameters_addresses_title t0 WHERE t0.parameter_address_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.address_title AS address_title_2,
  t0.parameter_address_id AS parameter_address_id_3,
  t0.lang_id AS lang_id_4
FROM
  mg_parameters_addresses_title t0
WHERE
  t0.parameter_address_id = ?

SELECT t0.id AS id_1, t0.address_title AS address_title_2, t0.parameter_address_id AS parameter_address_id_3, t0.lang_id AS lang_id_4 FROM mg_parameters_addresses_title t0 WHERE t0.parameter_address_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1867)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1812)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_bfc9f02accdd7b8f73455dbf33d43544->doDisplay (line 282)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_4082c3540de010b9b60f2ec176451f64->doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
18	App\Controller\SecurityController->login (line 25)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

0.38 ms
(1.10%)

SELECT t0.id AS id_1, t0.address AS address_2, t0.zipcode AS zipcode_3, t0.town AS town_4, t0.phone AS phone_5, t0.mobile AS mobile_6, t0.email AS email_7, t0.map AS map_8, t0.opening_time AS opening_time_9 FROM mg_parameters_addresses t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.address AS address_2,
  t0.zipcode AS zipcode_3,
  t0.town AS town_4,
  t0.phone AS phone_5,
  t0.mobile AS mobile_6,
  t0.email AS email_7,
  t0.map AS map_8,
  t0.opening_time AS opening_time_9
FROM
  mg_parameters_addresses t0

SELECT t0.id AS id_1, t0.address AS address_2, t0.zipcode AS zipcode_3, t0.town AS town_4, t0.phone AS phone_5, t0.mobile AS mobile_6, t0.email AS email_7, t0.map AS map_8, t0.opening_time AS opening_time_9 FROM mg_parameters_addresses 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\Services\AppService->getAddressesSite (line 29)
6	Twig\Extension\CoreExtension->getAttribute (line 1913)
7	__TwigTemplate_bfc9f02accdd7b8f73455dbf33d43544::doDisplay (line 273)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_4082c3540de010b9b60f2ec176451f64->doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
18	App\Controller\SecurityController->login (line 25)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	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\MgCategories	82
App\Entity\MgParametersAddresses	2
App\Entity\MgParametersAddressesTitle	2
App\Entity\MgParameters	1
App\Entity\MgLanguages	1

Entities Mapping

Class	Mapping errors
App\Entity\MgParameters	No errors.
App\Entity\MgCategories	No errors.
App\Entity\MgPosts	No errors.
App\Entity\MgProducts	No errors.
App\Entity\MgUsers	No errors.
App\Entity\MgPostsLang	No errors.
App\Entity\MgSuppliers	No errors.
App\Entity\MgGammes	No errors.
App\Entity\MgCarriers	No errors.
App\Entity\MgTaxes	No errors.
App\Entity\MgProductsImages	No errors.
App\Entity\MgProductsNumerical	No errors.
App\Entity\MgPropertiesContents	No errors.
App\Entity\MgMovementsStocks	No errors.
App\Entity\MgAuthors	No errors.
App\Entity\MgOrdersContent	No errors.
App\Entity\MgParametersAddresses	No errors.
App\Entity\MgParametersAddressesTitle	No errors.
App\Entity\MgLanguages	No errors.

Symfony Profiler

GET https://www.cms-morgane.fr/customer/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping