Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.05 ms Query time

0 Invalid entities

14 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.22 ms

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.subtitle AS subtitle_2, f0_.slug AS slug_3, f0_.description AS description_4, f0_.full_description AS full_description_5, f0_.image AS image_6, f0_.icon AS icon_7, f0_.duration AS duration_8, f0_.duration_unit AS duration_unit_9, f0_.price AS price_10, f0_.is_active AS is_active_11, f0_.is_featured AS is_featured_12, f0_.sort_order AS sort_order_13, f0_.objectives AS objectives_14, f0_.prerequisites AS prerequisites_15, f0_.program AS program_16, f0_.certification AS certification_17, f0_.program_filename AS program_filename_18, f0_.created_at AS created_at_19, f0_.updated_at AS updated_at_20, c1_.id AS id_21, c1_.name AS name_22, c1_.slug AS slug_23, c1_.color AS color_24, c1_.icon AS icon_25, f0_.category_id AS category_id_26 FROM formation f0_ LEFT JOIN category c1_ ON f0_.category_id = c1_.id WHERE f0_.is_active = 1 ORDER BY f0_.sort_order ASC, f0_.title ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.subtitle AS subtitle_2,
  f0_.slug AS slug_3,
  f0_.description AS description_4,
  f0_.full_description AS full_description_5,
  f0_.image AS image_6,
  f0_.icon AS icon_7,
  f0_.duration AS duration_8,
  f0_.duration_unit AS duration_unit_9,
  f0_.price AS price_10,
  f0_.is_active AS is_active_11,
  f0_.is_featured AS is_featured_12,
  f0_.sort_order AS sort_order_13,
  f0_.objectives AS objectives_14,
  f0_.prerequisites AS prerequisites_15,
  f0_.program AS program_16,
  f0_.certification AS certification_17,
  f0_.program_filename AS program_filename_18,
  f0_.created_at AS created_at_19,
  f0_.updated_at AS updated_at_20,
  c1_.id AS id_21,
  c1_.name AS name_22,
  c1_.slug AS slug_23,
  c1_.color AS color_24,
  c1_.icon AS icon_25,
  f0_.category_id AS category_id_26
FROM
  formation f0_
  LEFT JOIN category c1_ ON f0_.category_id = c1_.id
WHERE
  f0_.is_active = 1
ORDER BY
  f0_.sort_order ASC,
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.subtitle AS subtitle_2, f0_.slug AS slug_3, f0_.description AS description_4, f0_.full_description AS full_description_5, f0_.image AS image_6, f0_.icon AS icon_7, f0_.duration AS duration_8, f0_.duration_unit AS duration_unit_9, f0_.price AS price_10, f0_.is_active AS is_active_11, f0_.is_featured AS is_featured_12, f0_.sort_order AS sort_order_13, f0_.objectives AS objectives_14, f0_.prerequisites AS prerequisites_15, f0_.program AS program_16, f0_.certification AS certification_17, f0_.program_filename AS program_filename_18, f0_.created_at AS created_at_19, f0_.updated_at AS updated_at_20, c1_.id AS id_21, c1_.name AS name_22, c1_.slug AS slug_23, c1_.color AS color_24, c1_.icon AS icon_25, f0_.category_id AS category_id_26 FROM formation f0_ LEFT JOIN category c1_ ON f0_.category_id = c1_.id WHERE f0_.is_active = 1 ORDER BY f0_.sort_order ASC, f0_.title ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\FormationRepository->findAllActive (line 39)
7	App\Controller\CalendarController->index (line 19)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.83 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.color AS color_4, t0.icon AS icon_5 FROM category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.color AS color_4,
  t0.icon AS icon_5
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.color AS color_4, t0.icon AS icon_5 FROM category t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Twig\AppExtension->getGlobals (line 16)
6	Twig\ExtensionSet->getGlobals (line 365)
7	Twig\Environment->getGlobals (line 908)
8	Twig\Template->yield (line 406)
9	Twig\Template->display (line 366)
10	Twig\Template->render (line 381)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
16	App\Controller\CalendarController->index (line 18)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
19	Symfony\Component\HttpKernel\Kernel->handle (line 143)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	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\Formation	10
App\Entity\Category	4

Entities Mapping

Class	Mapping errors
App\Entity\Formation	No errors.
App\Entity\Category	No errors.
App\Entity\FormationSession	No errors.

GET http://www.guardianfrance.fr/calendrier

Configuration Settings

Theme

Page Width