Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.77 ms Query time

0 Invalid entities

117 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.77 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.icon_url AS icon_url_2, c0_.description AS description_3, c0_.slug AS slug_4, c0_.active AS active_5, s1_.name AS name_6, s1_.icon_url AS icon_url_7, s1_.description AS description_8, s1_.price AS price_9, s1_.slug AS slug_10, s1_.active AS active_11, s1_.id AS id_12, s1_.category_id AS category_id_13 FROM category c0_ INNER JOIN sub_category s1_ ON c0_.id = s1_.category_id WHERE c0_.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.icon_url AS icon_url_2,
  c0_.description AS description_3,
  c0_.slug AS slug_4,
  c0_.active AS active_5,
  s1_.name AS name_6,
  s1_.icon_url AS icon_url_7,
  s1_.description AS description_8,
  s1_.price AS price_9,
  s1_.slug AS slug_10,
  s1_.active AS active_11,
  s1_.id AS id_12,
  s1_.category_id AS category_id_13
FROM
  category c0_
  INNER JOIN sub_category s1_ ON c0_.id = s1_.category_id
WHERE
  c0_.active = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.icon_url AS icon_url_2, c0_.description AS description_3, c0_.slug AS slug_4, c0_.active AS active_5, s1_.name AS name_6, s1_.icon_url AS icon_url_7, s1_.description AS description_8, s1_.price AS price_9, s1_.slug AS slug_10, s1_.active AS active_11, s1_.id AS id_12, s1_.category_id AS category_id_13 FROM category c0_ INNER JOIN sub_category s1_ ON c0_.id = s1_.category_id WHERE c0_.active = 1;

#	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 30)
7	App\Repository\CategoryRepository->findAll (line 18)
8	App\Service\CategoryService->getAllCategories (line 21)
9	App\Twig\CategoryExtension->getGlobals (line 352)
10	Twig\ExtensionSet->getGlobals (line 901)
11	Twig\Environment->getGlobals (line 384)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 334)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 21)
20	App\Controller\HomeController->index (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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\SubCategory	104
App\Entity\Category	13

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\SubCategory	No errors.
App\Entity\User	No errors.
App\Entity\Commande	No errors.

Symfony Profiler

GET https://6myworker.com/

Configuration Settings

Theme

Page Width