Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.97 ms Query time

0 Invalid entities

118 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.50 ms
(52.12%)

SELECT t0.text AS text_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM pc t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.text AS text_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  pc t0

SELECT t0.text AS text_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM pc t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 36)
6	App\Controller\LegalController->pc (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.46 ms
(47.88%)

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 359)
10	Twig\ExtensionSet->getGlobals (line 900)
11	Twig\Environment->getGlobals (line 398)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 333)
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 37)
20	App\Controller\LegalController->pc (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
App\Entity\PC	1

Entities Mapping

Class	Mapping errors
App\Entity\PC	No 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://www.6myworker.com/politique_confidentialite

Configuration Settings

Theme

Page Width