Symfony Profiler

Query Metrics

23 Database Queries

2 Different statements

9.60 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.73 ms
(90.94%)

SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 WHERE t0.parent_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.second_name AS second_name_2,
  t0.reference AS reference_3,
  t0.icon AS icon_4,
  t0.score AS score_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.slug AS slug_8,
  t0.id AS id_9,
  t0.parent_id AS parent_id_10,
  t0.popular_category_id AS popular_category_id_11,
  t0.quotation_id AS quotation_id_12
FROM
  category t0
WHERE
  t0.parent_id = ?

SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 WHERE t0.parent_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2708)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 396)
8	Doctrine\ORM\PersistentCollection->count (line 1127)
9	twig_length_filter (line 113)
10	__TwigTemplate_acb8d6a1034e0bfc5e8b82a4661e210a->block_body (line 171)
11	Twig\Template->displayBlock (line 77)
12	__TwigTemplate_e718d897106eb0a446639ba624f18da7->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 49)
15	__TwigTemplate_acb8d6a1034e0bfc5e8b82a4661e210a->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 18)
24	App\Controller\CategoryController->allCategories (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 23)

0.87 ms
(9.06%)

SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 WHERE t0.parent_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.second_name AS second_name_2,
  t0.reference AS reference_3,
  t0.icon AS icon_4,
  t0.score AS score_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.slug AS slug_8,
  t0.id AS id_9,
  t0.parent_id AS parent_id_10,
  t0.popular_category_id AS popular_category_id_11,
  t0.quotation_id AS quotation_id_12
FROM
  category t0
WHERE
  t0.parent_id IS NULL

SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 WHERE t0.parent_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 16)
5	App\Controller\CategoryController->allCategories (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 23)

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.

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\PopularCategory	No errors.
App\Entity\Quotation	No errors.
App\Entity\Establishment	No errors.
App\Entity\JobOffert	No errors.

Symfony Profiler

GET http://193.70.3.237/all/categories

Configuration Settings

Theme