Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.42 ms Query time

0 Invalid entities

7 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.36 ms

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.cognome AS cognome_3, t0.email AS email_4, t0.password AS password_5, t0.ruolo AS ruolo_6, t0.telefono AS telefono_7, t0.email_verificata AS email_verificata_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM users t0 WHERE t0.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.cognome AS cognome_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.ruolo AS ruolo_6,
  t0.telefono AS telefono_7,
  t0.email_verificata AS email_verificata_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.cognome AS cognome_3, t0.email AS email_4, t0.password AS password_5, t0.ruolo AS ruolo_6, t0.telefono AS telefono_7, t0.email_verificata AS email_verificata_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM users t0 WHERE t0.id = 1;

#	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	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.34 ms

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.slug AS slug_3, t0.descrizione AS descrizione_4, t0.prezzo AS prezzo_5, t0.prezzo_scontato AS prezzo_scontato_6, t0.tipo AS tipo_7, t0.stato_pittura AS stato_pittura_8, t0.scala AS scala_9, t0.sistema_gioco AS sistema_gioco_10, t0.fazione AS fazione_11, t0.quantita_stock AS quantita_stock_12, t0.disponibile AS disponibile_13, t0.in_evidenza AS in_evidenza_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.categoria_id AS categoria_id_17, t0.usato_richiesta_id AS usato_richiesta_id_18 FROM prodotti t0 WHERE t0.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.slug AS slug_3,
  t0.descrizione AS descrizione_4,
  t0.prezzo AS prezzo_5,
  t0.prezzo_scontato AS prezzo_scontato_6,
  t0.tipo AS tipo_7,
  t0.stato_pittura AS stato_pittura_8,
  t0.scala AS scala_9,
  t0.sistema_gioco AS sistema_gioco_10,
  t0.fazione AS fazione_11,
  t0.quantita_stock AS quantita_stock_12,
  t0.disponibile AS disponibile_13,
  t0.in_evidenza AS in_evidenza_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.categoria_id AS categoria_id_17,
  t0.usato_richiesta_id AS usato_richiesta_id_18
FROM
  prodotti t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.slug AS slug_3, t0.descrizione AS descrizione_4, t0.prezzo AS prezzo_5, t0.prezzo_scontato AS prezzo_scontato_6, t0.tipo AS tipo_7, t0.stato_pittura AS stato_pittura_8, t0.scala AS scala_9, t0.sistema_gioco AS sistema_gioco_10, t0.fazione AS fazione_11, t0.quantita_stock AS quantita_stock_12, t0.disponibile AS disponibile_13, t0.in_evidenza AS in_evidenza_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.categoria_id AS categoria_id_17, t0.usato_richiesta_id AS usato_richiesta_id_18 FROM prodotti t0 WHERE t0.id = '1';

#	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	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.40 ms

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.slug AS slug_3, t0.immagine AS immagine_4, t0.ordine AS ordine_5, t0.attiva AS attiva_6, t0.parent_id AS parent_id_7 FROM categorie t0 WHERE t0.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.slug AS slug_3,
  t0.immagine AS immagine_4,
  t0.ordine AS ordine_5,
  t0.attiva AS attiva_6,
  t0.parent_id AS parent_id_7
FROM
  categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.slug AS slug_3, t0.immagine AS immagine_4, t0.ordine AS ordine_5, t0.attiva AS attiva_6, t0.parent_id AS parent_id_7 FROM categorie t0 WHERE t0.id = 1;

#	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 295)
4	Proxies\__CG__\App\Entity\Categoria::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Categoria->__get (line 153)
7	App\Entity\Categoria->getNome (line 52)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_27e0adcadaa2b00c97650b814de0321b::block_admin_content (line 249)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_2d860b9db930ae6bb685dfaaab8c344c->block_body (line 220)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_6b3e18ff30a8e513ca848f376cd2f39a->doDisplay (line 260)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_2d860b9db930ae6bb685dfaaab8c344c->doDisplay (line 57)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_27e0adcadaa2b00c97650b814de0321b->doDisplay (line 57)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	App\Controller\Admin\CatalogoAdminController->show (line 65)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.31 ms

SELECT t0.id AS id_1, t0.url AS url_2, t0.ordine AS ordine_3, t0.prodotto_id AS prodotto_id_4 FROM prodotti_immagini t0 WHERE t0.prodotto_id = ? ORDER BY t0.ordine ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.ordine AS ordine_3,
  t0.prodotto_id AS prodotto_id_4
FROM
  prodotti_immagini t0
WHERE
  t0.prodotto_id = ?
ORDER BY
  t0.ordine ASC

SELECT t0.id AS id_1, t0.url AS url_2, t0.ordine AS ordine_3, t0.prodotto_id AS prodotto_id_4 FROM prodotti_immagini t0 WHERE t0.prodotto_id = 1 ORDER BY t0.ordine ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_27e0adcadaa2b00c97650b814de0321b::block_admin_content (line 351)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_2d860b9db930ae6bb685dfaaab8c344c->block_body (line 220)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_6b3e18ff30a8e513ca848f376cd2f39a->doDisplay (line 260)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_2d860b9db930ae6bb685dfaaab8c344c->doDisplay (line 57)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_27e0adcadaa2b00c97650b814de0321b->doDisplay (line 57)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	App\Controller\Admin\CatalogoAdminController->show (line 65)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	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\ProdottoImmagine	4
App\Entity\User	1
App\Entity\Prodotto	1
App\Entity\Categoria	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Indirizzo	No errors.
App\Entity\Carrello	No errors.
App\Entity\Ordine	No errors.
App\Entity\UsatoRichiesta	No errors.
App\Entity\MessaggioContatto	No errors.
App\Entity\Prodotto	No errors.
App\Entity\Categoria	No errors.
App\Entity\ProdottoImmagine	No errors.

Symfony Profiler

GET https://www.miniaturemarketplace.it/admin/catalogo/1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping