Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

89.15 ms Query time

0 Invalid entities

6 Managed entities

Queries

Group similar statements

#▲

Time

Info

3.10 ms

SELECT r0_.uuid AS uuid_0, r0_.slug AS slug_1, r0_.cuuid AS cuuid_2, r0_.category AS category_3, r0_.title AS title_4, r0_.description AS description_5, r0_.preparation AS preparation_6, r0_.ingredients AS ingredients_7, r0_.translation AS translation_8, r0_.source AS source_9, r0_.author AS author_10, r0_.cover AS cover_11, r0_.images AS images_12, r0_.impressions AS impressions_13, r0_.created_at AS created_at_14, r0_.updated_at AS updated_at_15, r0_.active AS active_16 FROM recipe r0_ WHERE r0_.uuid = ?

Parameters:

[
  "019d4e12-3a87-7912-b480-63f3ef73a4d0"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.uuid AS uuid_0,
  r0_.slug AS slug_1,
  r0_.cuuid AS cuuid_2,
  r0_.category AS category_3,
  r0_.title AS title_4,
  r0_.description AS description_5,
  r0_.preparation AS preparation_6,
  r0_.ingredients AS ingredients_7,
  r0_.translation AS translation_8,
  r0_.source AS source_9,
  r0_.author AS author_10,
  r0_.cover AS cover_11,
  r0_.images AS images_12,
  r0_.impressions AS impressions_13,
  r0_.created_at AS created_at_14,
  r0_.updated_at AS updated_at_15,
  r0_.active AS active_16
FROM
  recipe r0_
WHERE
  r0_.uuid = ?

SELECT r0_.uuid AS uuid_0, r0_.slug AS slug_1, r0_.cuuid AS cuuid_2, r0_.category AS category_3, r0_.title AS title_4, r0_.description AS description_5, r0_.preparation AS preparation_6, r0_.ingredients AS ingredients_7, r0_.translation AS translation_8, r0_.source AS source_9, r0_.author AS author_10, r0_.cover AS cover_11, r0_.images AS images_12, r0_.impressions AS impressions_13, r0_.created_at AS created_at_14, r0_.updated_at AS updated_at_15, r0_.active AS active_16 FROM recipe r0_ WHERE r0_.uuid = '019d4e12-3a87-7912-b480-63f3ef73a4d0';

#	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->getOneOrNullResult (line 737)
6	App\Repository\RecipeRepository->findOneByUuid (line 68)
7	App\Controller\RecipeController->{closure:App\Controller\RecipeController::index():29} (line 30)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
9	Symfony\Component\Cache\LockRegistry::compute (line 112)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 67)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
15	App\Controller\RecipeController->index (line 29)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 191)
19	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
20	frankenphp_handle_request (line 57)
21	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
22	require_once (line 32)
23	require_once (line 5)

86.04 ms

SELECT r0_.uuid AS uuid_0, r0_.slug AS slug_1, r0_.cuuid AS cuuid_2, r0_.category AS category_3, r0_.title AS title_4, r0_.description AS description_5, r0_.preparation AS preparation_6, r0_.ingredients AS ingredients_7, r0_.translation AS translation_8, r0_.source AS source_9, r0_.author AS author_10, r0_.cover AS cover_11, r0_.images AS images_12, r0_.impressions AS impressions_13, r0_.created_at AS created_at_14, r0_.updated_at AS updated_at_15, r0_.active AS active_16 FROM recipe r0_ WHERE r0_.cuuid = ? AND r0_.uuid <> ? ORDER BY r0_.cuuid ASC LIMIT 5

Parameters:

[
  Symfony\Component\Uid\UuidV4 {#1153
    __toString(): "6cc2fe5b-280b-43a0-80b5-465e93668fc6"
  }
  Symfony\Component\Uid\UuidV7 {#6181
    __toString(): "019d4e12-3a87-7912-b480-63f3ef73a4d0"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  r0_.uuid AS uuid_0,
  r0_.slug AS slug_1,
  r0_.cuuid AS cuuid_2,
  r0_.category AS category_3,
  r0_.title AS title_4,
  r0_.description AS description_5,
  r0_.preparation AS preparation_6,
  r0_.ingredients AS ingredients_7,
  r0_.translation AS translation_8,
  r0_.source AS source_9,
  r0_.author AS author_10,
  r0_.cover AS cover_11,
  r0_.images AS images_12,
  r0_.impressions AS impressions_13,
  r0_.created_at AS created_at_14,
  r0_.updated_at AS updated_at_15,
  r0_.active AS active_16
FROM
  recipe r0_
WHERE
  r0_.cuuid = ?
  AND r0_.uuid <> ?
ORDER BY
  r0_.cuuid ASC
LIMIT
  5

SELECT r0_.uuid AS uuid_0, r0_.slug AS slug_1, r0_.cuuid AS cuuid_2, r0_.category AS category_3, r0_.title AS title_4, r0_.description AS description_5, r0_.preparation AS preparation_6, r0_.ingredients AS ingredients_7, r0_.translation AS translation_8, r0_.source AS source_9, r0_.author AS author_10, r0_.cover AS cover_11, r0_.images AS images_12, r0_.impressions AS impressions_13, r0_.created_at AS created_at_14, r0_.updated_at AS updated_at_15, r0_.active AS active_16 FROM recipe r0_ WHERE r0_.cuuid = '6cc2fe5b-280b-43a0-80b5-465e93668fc6' AND r0_.uuid <> '019d4e12-3a87-7912-b480-63f3ef73a4d0' ORDER BY r0_.cuuid ASC LIMIT 5;

#	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\RecipeRepository->findSameRecipesByCategory (line 161)
7	App\Controller\RecipeController->{closure:App\Controller\RecipeController::index():45} (line 53)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
9	Symfony\Component\Cache\LockRegistry::compute (line 112)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 67)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
15	App\Controller\RecipeController->index (line 45)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 191)
19	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
20	frankenphp_handle_request (line 57)
21	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
22	require_once (line 32)
23	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\Recipe	6

Entities Mapping

Class	Mapping errors
App\Entity\RecipeSearch	No errors.
App\Entity\Recipe	No errors.

Symfony Profiler

GET https://myr.sorin.dok.twn.ro/ja/reshipi/sarada/sakusakuno-chun-noasuparagasuto-gan-ju-sarada-habukinua-tian-e-no-dafna-r/019d4e12-3a87-7912-b480-63f3ef73a4d0

Configuration Settings

Theme

Page Width