Symfony Profiler

Query Metrics

9 Database Queries

7 Different statements

3.57 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.08 ms
(30.24%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 432)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\PublicationController->show (line 42)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.65 ms
(18.26%)

UPDATE publication SET view_count = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  publication
SET
  view_count = ?
WHERE
  id = ?

UPDATE publication SET view_count = 4 WHERE id = 3;

#	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 1139)
4	Doctrine\ORM\UnitOfWork->commit (line 407)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\PublicationController->show (line 42)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.47 ms
(13.07%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.gender AS gender_6, t0.birth_date AS birth_date_7, t0.image_path AS image_path_8, t0.rejection_note AS rejection_note_9, t0.view_count AS view_count_10, t0.owner_id AS owner_id_11, t0.province_id AS province_id_12, t0.locality_id AS locality_id_13, t0.animal_type_id AS animal_type_id_14 FROM publication t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.summary AS summary_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.gender AS gender_6,
  t0.birth_date AS birth_date_7,
  t0.image_path AS image_path_8,
  t0.rejection_note AS rejection_note_9,
  t0.view_count AS view_count_10,
  t0.owner_id AS owner_id_11,
  t0.province_id AS province_id_12,
  t0.locality_id AS locality_id_13,
  t0.animal_type_id AS animal_type_id_14
FROM
  publication t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.gender AS gender_6, t0.birth_date AS birth_date_7, t0.image_path AS image_path_8, t0.rejection_note AS rejection_note_9, t0.view_count AS view_count_10, t0.owner_id AS owner_id_11, t0.province_id AS province_id_12, t0.locality_id AS locality_id_13, t0.animal_type_id AS animal_type_id_14 FROM publication t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\PublicationController->show (line 28)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.41 ms
(11.45%)

INSERT INTO visit_log (path, referer, created_at) VALUES (?, ?, ?)

Parameters:

[
  "/publicaciones/3"
  null
  "2025-12-09 22:31:34"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO visit_log (path, referer, created_at)
VALUES
  (?, ?, ?)

INSERT INTO visit_log (path, referer, created_at) VALUES ('/publicaciones/3', NULL, '2025-12-09 22:31:34');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->commit (line 402)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\VisitLogger->log (line 25)
7	App\Controller\PublicationController->show (line 44)
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\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.36 ms
(9.98%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.phone AS phone_6, t0.city AS city_7, t0.can_publish AS can_publish_8, t0.reset_token AS reset_token_9, t0.reset_requested_at AS reset_requested_at_10, t0.created_at AS created_at_11, t0.province_id AS province_id_12, t0.locality_id AS locality_id_13 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.full_name AS full_name_5,
  t0.phone AS phone_6,
  t0.city AS city_7,
  t0.can_publish AS can_publish_8,
  t0.reset_token AS reset_token_9,
  t0.reset_requested_at AS reset_requested_at_10,
  t0.created_at AS created_at_11,
  t0.province_id AS province_id_12,
  t0.locality_id AS locality_id_13
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.phone AS phone_6, t0.city AS city_7, t0.can_publish AS can_publish_8, t0.reset_token AS reset_token_9, t0.reset_requested_at AS reset_requested_at_10, t0.created_at AS created_at_11, t0.province_id AS province_id_12, t0.locality_id AS locality_id_13 FROM `user` t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\User->__get (line 153)
7	App\Entity\User->getFullName (line 138)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_6b230fabe3736aa5abe71cd202cc38e8::block_body (line 193)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_f56c58d0045534d7bc246b56cf37129d->doDisplay (line 208)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_6b230fabe3736aa5abe71cd202cc38e8->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\PublicationController->show (line 46)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.33 ms
(9.32%)

SELECT h0_.id AS id_0, h0_.chip_label AS chip_label_1, h0_.headline AS headline_2, h0_.lede AS lede_3, h0_.hero_background_path AS hero_background_path_4, h0_.meta_title AS meta_title_5, h0_.meta_description AS meta_description_6, h0_.meta_keywords AS meta_keywords_7, h0_.logo_path AS logo_path_8 FROM homepage_settings h0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.chip_label AS chip_label_1,
  h0_.headline AS headline_2,
  h0_.lede AS lede_3,
  h0_.hero_background_path AS hero_background_path_4,
  h0_.meta_title AS meta_title_5,
  h0_.meta_description AS meta_description_6,
  h0_.meta_keywords AS meta_keywords_7,
  h0_.logo_path AS logo_path_8
FROM
  homepage_settings h0_
LIMIT
  1

SELECT h0_.id AS id_0, h0_.chip_label AS chip_label_1, h0_.headline AS headline_2, h0_.lede AS lede_3, h0_.hero_background_path AS hero_background_path_4, h0_.meta_title AS meta_title_5, h0_.meta_description AS meta_description_6, h0_.meta_keywords AS meta_keywords_7, h0_.logo_path AS logo_path_8 FROM homepage_settings h0_ LIMIT 1;

#	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\HomepageSettingsRepository->getSingleton (line 24)
7	App\Controller\PublicationController->show (line 48)
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\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.27 ms
(7.68%)

"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 381)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\PublicationController->show (line 42)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	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\Publication	1
App\Entity\User	1
App\Entity\VisitLog	1
App\Entity\HomepageSettings	1

Entities Mapping

Class	Mapping errors
App\Entity\Publication	No errors.
App\Entity\User	No errors.
App\Entity\Province	No errors.
App\Entity\Locality	No errors.
App\Entity\AnimalType	No errors.
App\Entity\VisitLog	No errors.
App\Entity\HomepageSettings	No errors.

Symfony Profiler

GET https://adoptaconamor.shophardware.com.ar/publicaciones/3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping