Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.13 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.77 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.descriptif AS descriptif_3, t0.ingredients AS ingredients_4, t0.instructions AS instructions_5, t0.temps_prepa AS temps_prepa_6, t0.temps_cuisson AS temps_cuisson_7, t0.image AS image_8, t0.status AS status_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.difficulty AS difficulty_12, t0.category AS category_13, t0.tags AS tags_14, t0.user_id AS user_id_15 FROM recette t0 WHERE t0.status = ? ORDER BY t0.created_at DESC LIMIT 3

Parameters:

[
  "completed"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.descriptif AS descriptif_3,
  t0.ingredients AS ingredients_4,
  t0.instructions AS instructions_5,
  t0.temps_prepa AS temps_prepa_6,
  t0.temps_cuisson AS temps_cuisson_7,
  t0.image AS image_8,
  t0.status AS status_9,
  t0.slug AS slug_10,
  t0.created_at AS created_at_11,
  t0.difficulty AS difficulty_12,
  t0.category AS category_13,
  t0.tags AS tags_14,
  t0.user_id AS user_id_15
FROM
  recette t0
WHERE
  t0.status = ?
ORDER BY
  t0.created_at DESC
LIMIT
  3

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.descriptif AS descriptif_3, t0.ingredients AS ingredients_4, t0.instructions AS instructions_5, t0.temps_prepa AS temps_prepa_6, t0.temps_cuisson AS temps_cuisson_7, t0.image AS image_8, t0.status AS status_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.difficulty AS difficulty_12, t0.category AS category_13, t0.tags AS tags_14, t0.user_id AS user_id_15 FROM recette t0 WHERE t0.status = 'completed' ORDER BY t0.created_at DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 133)
4	App\Controller\RecetteController->recentRecette (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 52)
12	__TwigTemplate_386922b5a7e00066b3a08872292b7964->doDisplay (line 393)
13	Twig\Template->yield (line 130)
14	__TwigTemplate_f3152e53c84eee6a93256cc596df52bd->block_body (line 437)
15	Twig\Template->yieldBlock (line 85)
16	__TwigTemplate_13bdc3cec97ab85397cc7940569117bc->doDisplay (line 393)
17	Twig\Template->yield (line 55)
18	__TwigTemplate_f3152e53c84eee6a93256cc596df52bd->doDisplay (line 393)
19	Twig\Template->yield (line 349)
20	Twig\Template->display (line 364)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 37)
27	App\Controller\HomeController->index (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

2.36 ms

SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.descriptif AS descriptif_2, r0_.ingredients AS ingredients_3, r0_.instructions AS instructions_4, r0_.temps_prepa AS temps_prepa_5, r0_.temps_cuisson AS temps_cuisson_6, r0_.image AS image_7, r0_.status AS status_8, r0_.slug AS slug_9, r0_.created_at AS created_at_10, r0_.difficulty AS difficulty_11, r0_.category AS category_12, r0_.tags AS tags_13, r0_.user_id AS user_id_14 FROM recette r0_ WHERE r0_.status = ? AND r0_.category = ? ORDER BY RAND() ASC LIMIT 1

Parameters:

[
  "completed"
  "dessert"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.nom AS nom_1,
  r0_.descriptif AS descriptif_2,
  r0_.ingredients AS ingredients_3,
  r0_.instructions AS instructions_4,
  r0_.temps_prepa AS temps_prepa_5,
  r0_.temps_cuisson AS temps_cuisson_6,
  r0_.image AS image_7,
  r0_.status AS status_8,
  r0_.slug AS slug_9,
  r0_.created_at AS created_at_10,
  r0_.difficulty AS difficulty_11,
  r0_.category AS category_12,
  r0_.tags AS tags_13,
  r0_.user_id AS user_id_14
FROM
  recette r0_
WHERE
  r0_.status = ?
  AND r0_.category = ?
ORDER BY
  RAND() ASC
LIMIT
  1

SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.descriptif AS descriptif_2, r0_.ingredients AS ingredients_3, r0_.instructions AS instructions_4, r0_.temps_prepa AS temps_prepa_5, r0_.temps_cuisson AS temps_cuisson_6, r0_.image AS image_7, r0_.status AS status_8, r0_.slug AS slug_9, r0_.created_at AS created_at_10, r0_.difficulty AS difficulty_11, r0_.category AS category_12, r0_.tags AS tags_13, r0_.user_id AS user_id_14 FROM recette r0_ WHERE r0_.status = 'completed' AND r0_.category = 'dessert' ORDER BY RAND() ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 991)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 52)
7	App\Repository\RecetteRepository->findAleaDessert (line 124)
8	App\Controller\RecetteController->dessertDuJour (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 51)
16	__TwigTemplate_7d96db0cc8ca6944b6ca9df6d6182945->doDisplay (line 393)
17	Twig\Template->yield (line 133)
18	__TwigTemplate_f3152e53c84eee6a93256cc596df52bd->block_body (line 437)
19	Twig\Template->yieldBlock (line 85)
20	__TwigTemplate_13bdc3cec97ab85397cc7940569117bc->doDisplay (line 393)
21	Twig\Template->yield (line 55)
22	__TwigTemplate_f3152e53c84eee6a93256cc596df52bd->doDisplay (line 393)
23	Twig\Template->yield (line 349)
24	Twig\Template->display (line 364)
25	Twig\Template->render (line 35)
26	Twig\TemplateWrapper->render (line 306)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 37)
31	App\Controller\HomeController->index (line 178)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	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.

Entities Mapping

Class	Mapping errors
App\Entity\Recette	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://recettes.gleclere.tech/

Configuration Settings

Theme