Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

8.72 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

5.15 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:

[
  "39773543-cb61-41c9-9227-fe47d5a0e166"
]

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 = '39773543-cb61-41c9-9227-fe47d5a0e166';

#	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 67)
7	App\Controller\RecipeController->updateImpressions (line 84)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
12	frankenphp_handle_request (line 57)
13	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
14	require_once (line 32)
15	require_once (line 5)

0.59 ms

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Repository\RecipeRepository->updateImpressions (line 233)
4	App\Controller\RecipeController->updateImpressions (line 87)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
9	frankenphp_handle_request (line 57)
10	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
11	require_once (line 32)
12	require_once (line 5)

1.72 ms

UPDATE recipe SET impressions = ? WHERE uuid = ?

Parameters:

[
  1244
  "39773543-cb61-41c9-9227-fe47d5a0e166"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  recipe
SET
  impressions = ?
WHERE
  uuid = ?

UPDATE recipe SET impressions = 1244 WHERE uuid = '39773543-cb61-41c9-9227-fe47d5a0e166';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Repository\RecipeRepository->updateImpressions (line 233)
7	App\Controller\RecipeController->updateImpressions (line 87)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
12	frankenphp_handle_request (line 57)
13	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
14	require_once (line 32)
15	require_once (line 5)

1.26 ms

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Repository\RecipeRepository->updateImpressions (line 233)
4	App\Controller\RecipeController->updateImpressions (line 87)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner->{closure:Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run():40} (line 50)
9	frankenphp_handle_request (line 57)
10	Symfony\Component\Runtime\Runner\FrankenPhpWorkerRunner::run (line 57)
11	require_once (line 32)
12	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	1

Entities Mapping

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

Symfony Profiler

GET https://rey.sorin.dok.twn.ro/recipe-update-impressions/39773543-cb61-41c9-9227-fe47d5a0e166/image?dummy=1765034933

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping