Symfony Profiler

Query Metrics

22 Database Queries

10 Different statements

31.29 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

19.06 ms
(60.93%)

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 = '/' 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 = '/'
  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 = '/' 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 18)
9	App\Controller\HomeController->index (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)

3.19 ms
(10.21%)

SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.nome_foto AS nome_foto_3, t0.nome_foto_webp AS nome_foto_webp_4, t0.link_youtube AS link_youtube_5, t0.tipo AS tipo_6, t0.myme AS myme_7, t0.attivo AS attivo_8, t0.update_at AS update_at_9, t0.foto_cucciolo_id AS foto_cucciolo_id_10, t0.foto_genitore_id AS foto_genitore_id_11, t0.foto_cucciolata_id AS foto_cucciolata_id_12 FROM gest_foto t0 WHERE t0.foto_cucciolo_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titolo AS titolo_2,
  t0.nome_foto AS nome_foto_3,
  t0.nome_foto_webp AS nome_foto_webp_4,
  t0.link_youtube AS link_youtube_5,
  t0.tipo AS tipo_6,
  t0.myme AS myme_7,
  t0.attivo AS attivo_8,
  t0.update_at AS update_at_9,
  t0.foto_cucciolo_id AS foto_cucciolo_id_10,
  t0.foto_genitore_id AS foto_genitore_id_11,
  t0.foto_cucciolata_id AS foto_cucciolata_id_12
FROM
  gest_foto t0
WHERE
  t0.foto_cucciolo_id = ?

SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.nome_foto AS nome_foto_3, t0.nome_foto_webp AS nome_foto_webp_4, t0.link_youtube AS link_youtube_5, t0.tipo AS tipo_6, t0.myme AS myme_7, t0.attivo AS attivo_8, t0.update_at AS update_at_9, t0.foto_cucciolo_id AS foto_cucciolo_id_10, t0.foto_genitore_id AS foto_genitore_id_11, t0.foto_cucciolata_id AS foto_cucciolata_id_12 FROM gest_foto t0 WHERE t0.foto_cucciolo_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1801)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1746)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2699)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 625)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 187)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 653)
8	twig_slice (line 683)
9	twig_first (line 126)
10	__TwigTemplate_4738b60c8a31d9fb31a46a898b81e17f->block_body (line 171)
11	Twig\Template->displayBlock (line 127)
12	__TwigTemplate_7a0cfd6276fd5c79cfa1b7c7279570f6->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 50)
15	__TwigTemplate_4738b60c8a31d9fb31a46a898b81e17f->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 30)
24	App\Controller\HomeController->index (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

2.14 ms
(6.85%)

"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 18)
6	App\Controller\HomeController->index (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.84 ms
(5.88%)

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:

[
  "/"
]

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 = '/' 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 18)
6	App\Controller\HomeController->index (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.38 ms
(4.40%)

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 = 9921 WHERE id = 5;

#	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 18)
8	App\Controller\HomeController->index (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)

1.07 ms
(3.40%)

SELECT t0.id AS id_1, t0.numero_cuccioli AS numero_cuccioli_2, t0.youtube AS youtube_3, t0.madre_id AS madre_id_4, t0.padre_id AS padre_id_5, t0.foto_madre_id AS foto_madre_id_6, t0.foto_padre_id AS foto_padre_id_7, t8.id AS id_9, t8.titolo AS titolo_10, t8.testo AS testo_11, t8.data_annuncio AS data_annuncio_12, t8.attivo AS attivo_13, t8.id_cucciolata_id AS id_cucciolata_id_14 FROM gest_cucciolate t0 LEFT JOIN gest_annunci t8 ON t8.id_cucciolata_id = t0.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.numero_cuccioli AS numero_cuccioli_2,
  t0.youtube AS youtube_3,
  t0.madre_id AS madre_id_4,
  t0.padre_id AS padre_id_5,
  t0.foto_madre_id AS foto_madre_id_6,
  t0.foto_padre_id AS foto_padre_id_7,
  t8.id AS id_9,
  t8.titolo AS titolo_10,
  t8.testo AS testo_11,
  t8.data_annuncio AS data_annuncio_12,
  t8.attivo AS attivo_13,
  t8.id_cucciolata_id AS id_cucciolata_id_14
FROM
  gest_cucciolate t0
  LEFT JOIN gest_annunci t8 ON t8.id_cucciolata_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numero_cuccioli AS numero_cuccioli_2, t0.youtube AS youtube_3, t0.madre_id AS madre_id_4, t0.padre_id AS padre_id_5, t0.foto_madre_id AS foto_madre_id_6, t0.foto_padre_id AS foto_padre_id_7, t8.id AS id_9, t8.titolo AS titolo_10, t8.testo AS testo_11, t8.data_annuncio AS data_annuncio_12, t8.attivo AS attivo_13, t8.id_cucciolata_id AS id_cucciolata_id_14 FROM gest_cucciolate t0 LEFT JOIN gest_annunci t8 ON t8.id_cucciolata_id = t0.id WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 735)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 753)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 287)
5	Proxies\__CG__\App\Entity\GestCucciolate::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 118)
7	Proxies\__CG__\App\Entity\GestCucciolate->__get (line 168)
8	App\Entity\GestCucciolate->getCuccioli (line 25)
9	App\Controller\HomeController->index (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)

1.03 ms
(3.30%)

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.sesso AS sesso_3, t0.colore AS colore_4, t0.stato AS stato_5, t0.prezzo AS prezzo_6, t0.contatore AS contatore_7, t0.cucciolata_id AS cucciolata_id_8 FROM gest_cuccioli t0 WHERE t0.cucciolata_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.sesso AS sesso_3,
  t0.colore AS colore_4,
  t0.stato AS stato_5,
  t0.prezzo AS prezzo_6,
  t0.contatore AS contatore_7,
  t0.cucciolata_id AS cucciolata_id_8
FROM
  gest_cuccioli t0
WHERE
  t0.cucciolata_id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.sesso AS sesso_3, t0.colore AS colore_4, t0.stato AS stato_5, t0.prezzo AS prezzo_6, t0.contatore AS contatore_7, t0.cucciolata_id AS cucciolata_id_8 FROM gest_cuccioli t0 WHERE t0.cucciolata_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1801)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1746)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2699)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 625)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 187)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 26)
8	App\Controller\HomeController->index (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)

0.65 ms
(2.07%)

SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.testo AS testo_3, t0.data_annuncio AS data_annuncio_4, t0.attivo AS attivo_5, t0.id_cucciolata_id AS id_cucciolata_id_6 FROM gest_annunci t0 WHERE t0.attivo = ? ORDER BY t0.data_annuncio ASC

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titolo AS titolo_2,
  t0.testo AS testo_3,
  t0.data_annuncio AS data_annuncio_4,
  t0.attivo AS attivo_5,
  t0.id_cucciolata_id AS id_cucciolata_id_6
FROM
  gest_annunci t0
WHERE
  t0.attivo = ?
ORDER BY
  t0.data_annuncio ASC

SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.testo AS testo_3, t0.data_annuncio AS data_annuncio_4, t0.attivo AS attivo_5, t0.id_cucciolata_id AS id_cucciolata_id_6 FROM gest_annunci t0 WHERE t0.attivo = '1' ORDER BY t0.data_annuncio ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 906)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 20)
5	App\Controller\HomeController->index (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.50 ms
(1.61%)

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

Parameters:

[
  "/"
  "1"
  "2024-12-23 00:08:12"
]

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 ('/', '1', '2024-12-23 00:08:12');

#	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 18)
9	App\Controller\HomeController->index (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.42 ms
(1.36%)

"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 18)
5	App\Controller\HomeController->index (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)

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.
App\Entity\GestAnnunci	No errors.
App\Entity\GestCucciolate	No errors.
App\Entity\GestAdulti	No errors.
App\Entity\GestFoto	No errors.
App\Entity\GestCuccioli	No errors.

Symfony Profiler

GET https://www.mondogolden.it/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping