Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

27.85 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

20.04 ms
(71.96%)

SELECT g0_.id AS id_0, g0_.pagina AS pagina_1, g0_.contatore AS contatore_2, g0_.data AS data_3 FROM gest_visite_giornaliere g0_ WHERE g0_.pagina = '/perche-noi/allevamento-professionale' AND g0_.data = '2024-12-23'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.pagina AS pagina_1,
  g0_.contatore AS contatore_2,
  g0_.data AS data_3
FROM
  gest_visite_giornaliere g0_
WHERE
  g0_.pagina = '/perche-noi/allevamento-professionale'
  AND g0_.data = '2024-12-23'

SELECT g0_.id AS id_0, g0_.pagina AS pagina_1, g0_.contatore AS contatore_2, g0_.data AS data_3 FROM gest_visite_giornaliere g0_ WHERE g0_.pagina = '/perche-noi/allevamento-professionale' AND g0_.data = '2024-12-23';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 43)
7	App\UtilityClass\Functions->registra_pagina_giornaliera (line 38)
8	App\UtilityClass\Functions->registra_pagina (line 31)
9	App\Controller\PercheNoiController->allevamento (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

5.33 ms
(19.14%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1427)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 259)
4	Doctrine\ORM\EntityManager->flush (line 37)
5	App\UtilityClass\Functions->registra_pagina (line 31)
6	App\Controller\PercheNoiController->allevamento (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

1.18 ms
(4.23%)

SELECT t0.id AS id_1, t0.pagina AS pagina_2, t0.path AS path_3, t0.contatore AS contatore_4 FROM gest_pagine t0 WHERE t0.pagina = ? LIMIT 1

Parameters:

[
  "/perche-noi/allevamento-professionale"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.pagina AS pagina_2,
  t0.path AS path_3,
  t0.contatore AS contatore_4
FROM
  gest_pagine t0
WHERE
  t0.pagina = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.pagina AS pagina_2, t0.path AS path_3, t0.contatore AS contatore_4 FROM gest_pagine t0 WHERE t0.pagina = '/perche-noi/allevamento-professionale' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 735)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 27)
5	App\UtilityClass\Functions->registra_pagina (line 31)
6	App\Controller\PercheNoiController->allevamento (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.49 ms
(1.78%)

INSERT INTO gest_visite_giornaliere (pagina, contatore, data) VALUES (?, ?, ?)

Parameters:

[
  "/perche-noi/allevamento-professionale"
  "1"
  "2024-12-23 04:13:42"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO gest_visite_giornaliere (pagina, contatore, data)
VALUES
  (?, ?, ?)

INSERT INTO gest_visite_giornaliere (pagina, contatore, data) VALUES ('/perche-noi/allevamento-professionale', '1', '2024-12-23 04:13:42');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 250)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1048)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 399)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 53)
7	App\UtilityClass\Functions->registra_pagina_giornaliera (line 38)
8	App\UtilityClass\Functions->registra_pagina (line 31)
9	App\Controller\PercheNoiController->allevamento (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.46 ms
(1.64%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 259)
3	Doctrine\ORM\EntityManager->flush (line 37)
4	App\UtilityClass\Functions->registra_pagina (line 31)
5	App\Controller\PercheNoiController->allevamento (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.35 ms
(1.26%)

UPDATE gest_pagine SET contatore = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  gest_pagine
SET
  contatore = ?
WHERE
  id = ?

UPDATE gest_pagine SET contatore = 463 WHERE id = 19;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 491)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 375)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1126)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 404)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 37)
7	App\UtilityClass\Functions->registra_pagina (line 31)
8	App\Controller\PercheNoiController->allevamento (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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\GestPagine	No errors.
App\Entity\GestVisiteGiornaliere	No errors.

Symfony Profiler

GET https://www.mondogolden.it/perche-noi/allevamento-professionale

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping