Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.02 ms Query time

0 Invalid entities

176 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.60 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM bt_brands t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "lizzie"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  bt_brands t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM bt_brands t0 WHERE t0.slug = 'lizzie' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2.14 ms

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.lft AS lft_2, b0_.lvl AS lvl_3, b0_.rgt AS rgt_4, b0_.slug AS slug_5, b0_.nb_products AS nb_products_6 FROM bt_categories b0_ ORDER BY b0_.root_id ASC, b0_.lft ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.lft AS lft_2,
  b0_.lvl AS lvl_3,
  b0_.rgt AS rgt_4,
  b0_.slug AS slug_5,
  b0_.nb_products AS nb_products_6
FROM
  bt_categories b0_
ORDER BY
  b0_.root_id ASC,
  b0_.lft ASC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.lft AS lft_2, b0_.lvl AS lvl_3, b0_.rgt AS rgt_4, b0_.slug AS slug_5, b0_.nb_products AS nb_products_6 FROM bt_categories b0_ ORDER BY b0_.root_id ASC, b0_.lft 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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 1084)
7	Gedmo\Tree\Entity\Repository\NestedTreeRepository->getNodesHierarchy (line 88)
8	Gedmo\Tree\RepositoryUtils->childrenHierarchy (line 138)
9	Gedmo\Tree\Entity\Repository\AbstractTreeRepository->childrenHierarchy (line 25)
10	App\Controller\IncludesController->menu (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 194)
18	__TwigTemplate_86a39c94f5100e54fda29fd7a5dfe4e3->doDisplay (line 388)
19	Twig\Template->yield (line 55)
20	__TwigTemplate_917fd7641a2723c56225b69fa9778929->doDisplay (line 388)
21	Twig\Template->yield (line 344)
22	Twig\Template->display (line 359)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 334)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 48)
29	App\Controller\CategoryController->brand (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.75 ms

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.lft AS lft_2, b0_.lvl AS lvl_3, b0_.rgt AS rgt_4, b0_.slug AS slug_5, b0_.nb_products AS nb_products_6, b1_.id AS id_7, b1_.title AS title_8, b1_.lft AS lft_9, b1_.lvl AS lvl_10, b1_.rgt AS rgt_11, b1_.slug AS slug_12, b1_.nb_products AS nb_products_13, b0_.root_id AS root_id_14, b0_.parent_id AS parent_id_15, b1_.root_id AS root_id_16, b1_.parent_id AS parent_id_17 FROM bt_categories b0_ INNER JOIN bt_categories b1_ ON b0_.parent_id = b1_.id WHERE b0_.lvl <> 0 ORDER BY b0_.lft ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.lft AS lft_2,
  b0_.lvl AS lvl_3,
  b0_.rgt AS rgt_4,
  b0_.slug AS slug_5,
  b0_.nb_products AS nb_products_6,
  b1_.id AS id_7,
  b1_.title AS title_8,
  b1_.lft AS lft_9,
  b1_.lvl AS lvl_10,
  b1_.rgt AS rgt_11,
  b1_.slug AS slug_12,
  b1_.nb_products AS nb_products_13,
  b0_.root_id AS root_id_14,
  b0_.parent_id AS parent_id_15,
  b1_.root_id AS root_id_16,
  b1_.parent_id AS parent_id_17
FROM
  bt_categories b0_
  INNER JOIN bt_categories b1_ ON b0_.parent_id = b1_.id
WHERE
  b0_.lvl <> 0
ORDER BY
  b0_.lft ASC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.lft AS lft_2, b0_.lvl AS lvl_3, b0_.rgt AS rgt_4, b0_.slug AS slug_5, b0_.nb_products AS nb_products_6, b1_.id AS id_7, b1_.title AS title_8, b1_.lft AS lft_9, b1_.lvl AS lvl_10, b1_.rgt AS rgt_11, b1_.slug AS slug_12, b1_.nb_products AS nb_products_13, b0_.root_id AS root_id_14, b0_.parent_id AS parent_id_15, b1_.root_id AS root_id_16, b1_.parent_id AS parent_id_17 FROM bt_categories b0_ INNER JOIN bt_categories b1_ ON b0_.parent_id = b1_.id WHERE b0_.lvl <> 0 ORDER BY b0_.lft 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 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 187)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 423)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 94)
24	App\Controller\IncludesController->search (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 161)
32	__TwigTemplate_917fd7641a2723c56225b69fa9778929->block_body (line 432)
33	Twig\Template->yieldBlock (line 321)
34	__TwigTemplate_86a39c94f5100e54fda29fd7a5dfe4e3->doDisplay (line 388)
35	Twig\Template->yield (line 55)
36	__TwigTemplate_917fd7641a2723c56225b69fa9778929->doDisplay (line 388)
37	Twig\Template->yield (line 344)
38	Twig\Template->display (line 359)
39	Twig\Template->render (line 51)
40	Twig\TemplateWrapper->render (line 334)
41	Twig\Environment->render (line 431)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 48)
45	App\Controller\CategoryController->brand (line 183)
46	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
47	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
48	Symfony\Component\HttpKernel\Kernel->handle (line 35)
49	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
50	require_once (line 5)

0.53 ms

SELECT b0_.id AS id_0, b0_.code AS code_1, b0_.name AS name_2, b0_.department_name_uppercase AS department_name_uppercase_3, b0_.slug AS slug_4, b0_.department_name_soundex AS department_name_soundex_5 FROM bt_departments b0_ ORDER BY b0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.code AS code_1,
  b0_.name AS name_2,
  b0_.department_name_uppercase AS department_name_uppercase_3,
  b0_.slug AS slug_4,
  b0_.department_name_soundex AS department_name_soundex_5
FROM
  bt_departments b0_
ORDER BY
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.code AS code_1, b0_.name AS name_2, b0_.department_name_uppercase AS department_name_uppercase_3, b0_.slug AS slug_4, b0_.department_name_soundex AS department_name_soundex_5 FROM bt_departments b0_ ORDER BY b0_.name 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 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 187)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 423)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 94)
24	App\Controller\IncludesController->search (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 161)
32	__TwigTemplate_917fd7641a2723c56225b69fa9778929->block_body (line 432)
33	Twig\Template->yieldBlock (line 321)
34	__TwigTemplate_86a39c94f5100e54fda29fd7a5dfe4e3->doDisplay (line 388)
35	Twig\Template->yield (line 55)
36	__TwigTemplate_917fd7641a2723c56225b69fa9778929->doDisplay (line 388)
37	Twig\Template->yield (line 344)
38	Twig\Template->display (line 359)
39	Twig\Template->render (line 51)
40	Twig\TemplateWrapper->render (line 334)
41	Twig\Environment->render (line 431)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 48)
45	App\Controller\CategoryController->brand (line 183)
46	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
47	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
48	Symfony\Component\HttpKernel\Kernel->handle (line 35)
49	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
50	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\Department	101
App\Entity\Category	74
App\Entity\Brand	1

Entities Mapping

Class	Mapping errors
App\Entity\Brand	No errors.
App\Entity\Product	No errors.
App\Entity\Category	No errors.
App\Entity\User	No errors.
App\Entity\TrocProduct	No errors.
App\Entity\Favorite	No errors.
App\Entity\Image	No errors.
App\Entity\Box	No errors.
App\Entity\Evaluation	No errors.
App\Entity\Transaction	No errors.
App\Entity\NotificationType	No errors.
App\Entity\Troc	No errors.
App\Entity\Message	No errors.
App\Entity\Department	No errors.
App\Entity\Notification	No errors.
Gedmo\Tree\Entity\MappedSuperclass\AbstractClosure	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://area51.beautytroc.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CIncludesController%253A%253Asearch

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping