Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

749.14 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

748.14 ms

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, COUNT(b0_.name) AS sclr_3 FROM bt_brands b0_ LEFT JOIN bt_products b1_ ON b0_.id = b1_.brand_id WHERE b1_.statut = 1 GROUP BY b0_.id, b0_.slug ORDER BY LOWER(b0_.name) ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2,
  COUNT(b0_.name) AS sclr_3
FROM
  bt_brands b0_
  LEFT JOIN bt_products b1_ ON b0_.id = b1_.brand_id
WHERE
  b1_.statut = 1
GROUP BY
  b0_.id,
  b0_.slug
ORDER BY
  LOWER(b0_.name) ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, COUNT(b0_.name) AS sclr_3 FROM bt_brands b0_ LEFT JOIN bt_products b1_ ON b0_.id = b1_.brand_id WHERE b1_.statut = 1 GROUP BY b0_.id, b0_.slug ORDER BY LOWER(b0_.name) ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 828)
2	Doctrine\DBAL\Connection->executeCacheQuery (line 767)
3	Doctrine\DBAL\Connection->executeQuery (line 27)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
5	Doctrine\ORM\Query->_doExecute (line 935)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
7	Doctrine\ORM\AbstractQuery->execute (line 701)
8	Doctrine\ORM\AbstractQuery->getArrayResult (line 39)
9	App\Repository\BrandRepository->getBrands (line 30)
10	App\Controller\DefaultController->brands (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.00 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_aa3e743099fd80b60119acdf13d15872->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 32)
29	App\Controller\DefaultController->brands (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)

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

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/nos-marques

Configuration Settings

Theme

Page Width