Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

21.99 ms Query time

0 Invalid entities

268 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.97 ms
(72.61%)

SELECT b0_.id AS id_0, b0_.old_id AS old_id_1, b0_.username AS username_2, b0_.name AS name_3, b0_.master_image AS master_image_4, b0_.bio AS bio_5, b0_.capacity AS capacity_6, b0_.etat AS etat_7, b0_.comment AS comment_8, b0_.statut AS statut_9, b0_.pattern AS pattern_10, b0_.datetime AS datetime_11, b0_.expiration AS expiration_12, b0_.slug AS slug_13, b0_.view AS view_14, b1_.id AS id_15, b1_.username AS username_16, b1_.username_canonical AS username_canonical_17, b1_.old_username_canonical AS old_username_canonical_18, b1_.email AS email_19, b1_.email_canonical AS email_canonical_20, b1_.enabled AS enabled_21, b1_.salt AS salt_22, b1_.password AS password_23, b1_.last_login AS last_login_24, b1_.confirmation_token AS confirmation_token_25, b1_.password_requested_at AS password_requested_at_26, b1_.star AS star_27, b1_.roles AS roles_28, b1_.user_avatar AS user_avatar_29, b1_.user_regdate AS user_regdate_30, b1_.user_phone AS user_phone_31, b1_.user_trocs AS user_trocs_32, b1_.user_products AS user_products_33, b1_.user_moyenne AS user_moyenne_34, b1_.user_name AS user_name_35, b1_.user_first_name AS user_first_name_36, b1_.user_address AS user_address_37, b1_.user_complementary_address AS user_complementary_address_38, b1_.user_cp AS user_cp_39, b1_.user_city AS user_city_40, b1_.biography AS biography_41, b1_.facebook_id AS facebook_id_42, b1_.facebook_access_token AS facebook_access_token_43, b1_.twitter_id AS twitter_id_44, b1_.twitter_access_token AS twitter_access_token_45, b1_.wallet AS wallet_46, b1_.latitude AS latitude_47, b1_.longitude AS longitude_48, b2_.id AS id_49, b2_.name AS name_50, b2_.slug AS slug_51, b3_.id AS id_52, b3_.title AS title_53, b3_.lft AS lft_54, b3_.lvl AS lvl_55, b3_.rgt AS rgt_56, b3_.slug AS slug_57, b3_.nb_products AS nb_products_58, b4_.id AS id_59, b4_.title AS title_60, b4_.lft AS lft_61, b4_.lvl AS lvl_62, b4_.rgt AS rgt_63, b4_.slug AS slug_64, b4_.nb_products AS nb_products_65, b0_.user_id AS user_id_66, b0_.brand_id AS brand_id_67, b0_.parent_category_id AS parent_category_id_68, b0_.category_id AS category_id_69, b0_.box_id AS box_id_70, b3_.root_id AS root_id_71, b3_.parent_id AS parent_id_72, b4_.root_id AS root_id_73, b4_.parent_id AS parent_id_74 FROM bt_products b0_ INNER JOIN bt_users b1_ ON b0_.user_id = b1_.id INNER JOIN bt_brands b2_ ON b0_.brand_id = b2_.id INNER JOIN bt_categories b3_ ON b0_.parent_category_id = b3_.id INNER JOIN bt_categories b4_ ON b0_.category_id = b4_.id WHERE b0_.statut = ? AND b0_.category_id = ? ORDER BY b0_.datetime DESC LIMIT 40

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.old_id AS old_id_1,
  b0_.username AS username_2,
  b0_.name AS name_3,
  b0_.master_image AS master_image_4,
  b0_.bio AS bio_5,
  b0_.capacity AS capacity_6,
  b0_.etat AS etat_7,
  b0_.comment AS comment_8,
  b0_.statut AS statut_9,
  b0_.pattern AS pattern_10,
  b0_.datetime AS datetime_11,
  b0_.expiration AS expiration_12,
  b0_.slug AS slug_13,
  b0_.view AS view_14,
  b1_.id AS id_15,
  b1_.username AS username_16,
  b1_.username_canonical AS username_canonical_17,
  b1_.old_username_canonical AS old_username_canonical_18,
  b1_.email AS email_19,
  b1_.email_canonical AS email_canonical_20,
  b1_.enabled AS enabled_21,
  b1_.salt AS salt_22,
  b1_.password AS password_23,
  b1_.last_login AS last_login_24,
  b1_.confirmation_token AS confirmation_token_25,
  b1_.password_requested_at AS password_requested_at_26,
  b1_.star AS star_27,
  b1_.roles AS roles_28,
  b1_.user_avatar AS user_avatar_29,
  b1_.user_regdate AS user_regdate_30,
  b1_.user_phone AS user_phone_31,
  b1_.user_trocs AS user_trocs_32,
  b1_.user_products AS user_products_33,
  b1_.user_moyenne AS user_moyenne_34,
  b1_.user_name AS user_name_35,
  b1_.user_first_name AS user_first_name_36,
  b1_.user_address AS user_address_37,
  b1_.user_complementary_address AS user_complementary_address_38,
  b1_.user_cp AS user_cp_39,
  b1_.user_city AS user_city_40,
  b1_.biography AS biography_41,
  b1_.facebook_id AS facebook_id_42,
  b1_.facebook_access_token AS facebook_access_token_43,
  b1_.twitter_id AS twitter_id_44,
  b1_.twitter_access_token AS twitter_access_token_45,
  b1_.wallet AS wallet_46,
  b1_.latitude AS latitude_47,
  b1_.longitude AS longitude_48,
  b2_.id AS id_49,
  b2_.name AS name_50,
  b2_.slug AS slug_51,
  b3_.id AS id_52,
  b3_.title AS title_53,
  b3_.lft AS lft_54,
  b3_.lvl AS lvl_55,
  b3_.rgt AS rgt_56,
  b3_.slug AS slug_57,
  b3_.nb_products AS nb_products_58,
  b4_.id AS id_59,
  b4_.title AS title_60,
  b4_.lft AS lft_61,
  b4_.lvl AS lvl_62,
  b4_.rgt AS rgt_63,
  b4_.slug AS slug_64,
  b4_.nb_products AS nb_products_65,
  b0_.user_id AS user_id_66,
  b0_.brand_id AS brand_id_67,
  b0_.parent_category_id AS parent_category_id_68,
  b0_.category_id AS category_id_69,
  b0_.box_id AS box_id_70,
  b3_.root_id AS root_id_71,
  b3_.parent_id AS parent_id_72,
  b4_.root_id AS root_id_73,
  b4_.parent_id AS parent_id_74
FROM
  bt_products b0_
  INNER JOIN bt_users b1_ ON b0_.user_id = b1_.id
  INNER JOIN bt_brands b2_ ON b0_.brand_id = b2_.id
  INNER JOIN bt_categories b3_ ON b0_.parent_category_id = b3_.id
  INNER JOIN bt_categories b4_ ON b0_.category_id = b4_.id
WHERE
  b0_.statut = ?
  AND b0_.category_id = ?
ORDER BY
  b0_.datetime DESC
LIMIT
  40

SELECT b0_.id AS id_0, b0_.old_id AS old_id_1, b0_.username AS username_2, b0_.name AS name_3, b0_.master_image AS master_image_4, b0_.bio AS bio_5, b0_.capacity AS capacity_6, b0_.etat AS etat_7, b0_.comment AS comment_8, b0_.statut AS statut_9, b0_.pattern AS pattern_10, b0_.datetime AS datetime_11, b0_.expiration AS expiration_12, b0_.slug AS slug_13, b0_.view AS view_14, b1_.id AS id_15, b1_.username AS username_16, b1_.username_canonical AS username_canonical_17, b1_.old_username_canonical AS old_username_canonical_18, b1_.email AS email_19, b1_.email_canonical AS email_canonical_20, b1_.enabled AS enabled_21, b1_.salt AS salt_22, b1_.password AS password_23, b1_.last_login AS last_login_24, b1_.confirmation_token AS confirmation_token_25, b1_.password_requested_at AS password_requested_at_26, b1_.star AS star_27, b1_.roles AS roles_28, b1_.user_avatar AS user_avatar_29, b1_.user_regdate AS user_regdate_30, b1_.user_phone AS user_phone_31, b1_.user_trocs AS user_trocs_32, b1_.user_products AS user_products_33, b1_.user_moyenne AS user_moyenne_34, b1_.user_name AS user_name_35, b1_.user_first_name AS user_first_name_36, b1_.user_address AS user_address_37, b1_.user_complementary_address AS user_complementary_address_38, b1_.user_cp AS user_cp_39, b1_.user_city AS user_city_40, b1_.biography AS biography_41, b1_.facebook_id AS facebook_id_42, b1_.facebook_access_token AS facebook_access_token_43, b1_.twitter_id AS twitter_id_44, b1_.twitter_access_token AS twitter_access_token_45, b1_.wallet AS wallet_46, b1_.latitude AS latitude_47, b1_.longitude AS longitude_48, b2_.id AS id_49, b2_.name AS name_50, b2_.slug AS slug_51, b3_.id AS id_52, b3_.title AS title_53, b3_.lft AS lft_54, b3_.lvl AS lvl_55, b3_.rgt AS rgt_56, b3_.slug AS slug_57, b3_.nb_products AS nb_products_58, b4_.id AS id_59, b4_.title AS title_60, b4_.lft AS lft_61, b4_.lvl AS lvl_62, b4_.rgt AS rgt_63, b4_.slug AS slug_64, b4_.nb_products AS nb_products_65, b0_.user_id AS user_id_66, b0_.brand_id AS brand_id_67, b0_.parent_category_id AS parent_category_id_68, b0_.category_id AS category_id_69, b0_.box_id AS box_id_70, b3_.root_id AS root_id_71, b3_.parent_id AS parent_id_72, b4_.root_id AS root_id_73, b4_.parent_id AS parent_id_74 FROM bt_products b0_ INNER JOIN bt_users b1_ ON b0_.user_id = b1_.id INNER JOIN bt_brands b2_ ON b0_.brand_id = b2_.id INNER JOIN bt_categories b3_ ON b0_.parent_category_id = b3_.id INNER JOIN bt_categories b4_ ON b0_.category_id = b4_.id WHERE b0_.statut = 1 AND b0_.category_id = 43 ORDER BY b0_.datetime DESC LIMIT 40;

#	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 96)
7	App\Repository\ProductRepository->findByWithUser (line 81)
8	App\Twig\Components\ProductGrid->getItems (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 76)
10	__TwigTemplate_96639fa04a6490256265b24a40805525->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
15	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
16	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 202)
17	__TwigTemplate_f3a80043b39a640e74d5919fe011ec02->block_body (line 432)
18	Twig\Template->yieldBlock (line 321)
19	__TwigTemplate_86a39c94f5100e54fda29fd7a5dfe4e3->doDisplay (line 388)
20	Twig\Template->yield (line 55)
21	__TwigTemplate_f3a80043b39a640e74d5919fe011ec02->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 56)
30	App\Controller\CategoryController->_view (line 31)
31	App\Controller\CategoryController->view (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

3.08 ms
(13.99%)

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_f3a80043b39a640e74d5919fe011ec02->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 56)
29	App\Controller\CategoryController->_view (line 31)
30	App\Controller\CategoryController->view (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

1.40 ms
(6.34%)

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 169)
32	__TwigTemplate_f3a80043b39a640e74d5919fe011ec02->block_body (line 432)
33	Twig\Template->yieldBlock (line 321)
34	__TwigTemplate_86a39c94f5100e54fda29fd7a5dfe4e3->doDisplay (line 388)
35	Twig\Template->yield (line 55)
36	__TwigTemplate_f3a80043b39a640e74d5919fe011ec02->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 56)
45	App\Controller\CategoryController->_view (line 31)
46	App\Controller\CategoryController->view (line 183)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
49	Symfony\Component\HttpKernel\Kernel->handle (line 35)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
51	require_once (line 5)

1.12 ms
(5.09%)

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 169)
32	__TwigTemplate_f3a80043b39a640e74d5919fe011ec02->block_body (line 432)
33	Twig\Template->yieldBlock (line 321)
34	__TwigTemplate_86a39c94f5100e54fda29fd7a5dfe4e3->doDisplay (line 388)
35	Twig\Template->yield (line 55)
36	__TwigTemplate_f3a80043b39a640e74d5919fe011ec02->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 56)
45	App\Controller\CategoryController->_view (line 31)
46	App\Controller\CategoryController->view (line 183)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
49	Symfony\Component\HttpKernel\Kernel->handle (line 35)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
51	require_once (line 5)

0.43 ms
(1.96%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "huiles"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.slug AS slug_6,
  t0.nb_products AS nb_products_7,
  t0.root_id AS root_id_8,
  t0.parent_id AS parent_id_9
FROM
  bt_categories t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.slug = 'huiles' 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 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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\Product	40
App\Entity\User	28
App\Entity\Brand	23
App\Entity\Box	2

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\Product	No errors.
App\Entity\User	No errors.
App\Entity\Brand	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/catalogue/soins-du-corps/huiles

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping