Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.15 ms Query time

0 Invalid entities

6 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.71 ms

SELECT p0_.id AS id_0, p0_.nome AS nome_1, p0_.slug AS slug_2, p0_.descrizione AS descrizione_3, p0_.prezzo AS prezzo_4, p0_.prezzo_scontato AS prezzo_scontato_5, p0_.tipo AS tipo_6, p0_.stato_pittura AS stato_pittura_7, p0_.scala AS scala_8, p0_.sistema_gioco AS sistema_gioco_9, p0_.fazione AS fazione_10, p0_.quantita_stock AS quantita_stock_11, p0_.disponibile AS disponibile_12, p0_.in_evidenza AS in_evidenza_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, c1_.id AS id_16, c1_.nome AS nome_17, c1_.slug AS slug_18, c1_.immagine AS immagine_19, c1_.ordine AS ordine_20, c1_.attiva AS attiva_21, p2_.id AS id_22, p2_.url AS url_23, p2_.ordine AS ordine_24, p0_.categoria_id AS categoria_id_25, p0_.usato_richiesta_id AS usato_richiesta_id_26, c1_.parent_id AS parent_id_27, p2_.prodotto_id AS prodotto_id_28 FROM prodotti p0_ LEFT JOIN categorie c1_ ON p0_.categoria_id = c1_.id LEFT JOIN prodotti_immagini p2_ ON p0_.id = p2_.prodotto_id WHERE p0_.disponibile = 1 AND (c1_.id = ? OR c1_.parent_id = ?) ORDER BY p0_.in_evidenza DESC, p0_.created_at DESC, p2_.ordine ASC

Parameters:

[
  "1"
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nome AS nome_1,
  p0_.slug AS slug_2,
  p0_.descrizione AS descrizione_3,
  p0_.prezzo AS prezzo_4,
  p0_.prezzo_scontato AS prezzo_scontato_5,
  p0_.tipo AS tipo_6,
  p0_.stato_pittura AS stato_pittura_7,
  p0_.scala AS scala_8,
  p0_.sistema_gioco AS sistema_gioco_9,
  p0_.fazione AS fazione_10,
  p0_.quantita_stock AS quantita_stock_11,
  p0_.disponibile AS disponibile_12,
  p0_.in_evidenza AS in_evidenza_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15,
  c1_.id AS id_16,
  c1_.nome AS nome_17,
  c1_.slug AS slug_18,
  c1_.immagine AS immagine_19,
  c1_.ordine AS ordine_20,
  c1_.attiva AS attiva_21,
  p2_.id AS id_22,
  p2_.url AS url_23,
  p2_.ordine AS ordine_24,
  p0_.categoria_id AS categoria_id_25,
  p0_.usato_richiesta_id AS usato_richiesta_id_26,
  c1_.parent_id AS parent_id_27,
  p2_.prodotto_id AS prodotto_id_28
FROM
  prodotti p0_
  LEFT JOIN categorie c1_ ON p0_.categoria_id = c1_.id
  LEFT JOIN prodotti_immagini p2_ ON p0_.id = p2_.prodotto_id
WHERE
  p0_.disponibile = 1
  AND (
    c1_.id = ?
    OR c1_.parent_id = ?
  )
ORDER BY
  p0_.in_evidenza DESC,
  p0_.created_at DESC,
  p2_.ordine ASC

SELECT p0_.id AS id_0, p0_.nome AS nome_1, p0_.slug AS slug_2, p0_.descrizione AS descrizione_3, p0_.prezzo AS prezzo_4, p0_.prezzo_scontato AS prezzo_scontato_5, p0_.tipo AS tipo_6, p0_.stato_pittura AS stato_pittura_7, p0_.scala AS scala_8, p0_.sistema_gioco AS sistema_gioco_9, p0_.fazione AS fazione_10, p0_.quantita_stock AS quantita_stock_11, p0_.disponibile AS disponibile_12, p0_.in_evidenza AS in_evidenza_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, c1_.id AS id_16, c1_.nome AS nome_17, c1_.slug AS slug_18, c1_.immagine AS immagine_19, c1_.ordine AS ordine_20, c1_.attiva AS attiva_21, p2_.id AS id_22, p2_.url AS url_23, p2_.ordine AS ordine_24, p0_.categoria_id AS categoria_id_25, p0_.usato_richiesta_id AS usato_richiesta_id_26, c1_.parent_id AS parent_id_27, p2_.prodotto_id AS prodotto_id_28 FROM prodotti p0_ LEFT JOIN categorie c1_ ON p0_.categoria_id = c1_.id LEFT JOIN prodotti_immagini p2_ ON p0_.id = p2_.prodotto_id WHERE p0_.disponibile = 1 AND (c1_.id = '1' OR c1_.parent_id = '1') ORDER BY p0_.in_evidenza DESC, p0_.created_at DESC, p2_.ordine ASC;

#	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->getResult (line 688)
6	App\Repository\ProdottoRepository->findPublici (line 85)
7	App\Controller\CatalogoController->index (line 26)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.23 ms

SELECT c0_.id AS id_0, c0_.nome AS nome_1, c0_.slug AS slug_2, c0_.immagine AS immagine_3, c0_.ordine AS ordine_4, c0_.attiva AS attiva_5, c1_.id AS id_6, c1_.nome AS nome_7, c1_.slug AS slug_8, c1_.immagine AS immagine_9, c1_.ordine AS ordine_10, c1_.attiva AS attiva_11, c0_.parent_id AS parent_id_12, c1_.parent_id AS parent_id_13 FROM categorie c0_ LEFT JOIN categorie c1_ ON c0_.parent_id = c1_.id ORDER BY c0_.nome ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nome AS nome_1,
  c0_.slug AS slug_2,
  c0_.immagine AS immagine_3,
  c0_.ordine AS ordine_4,
  c0_.attiva AS attiva_5,
  c1_.id AS id_6,
  c1_.nome AS nome_7,
  c1_.slug AS slug_8,
  c1_.immagine AS immagine_9,
  c1_.ordine AS ordine_10,
  c1_.attiva AS attiva_11,
  c0_.parent_id AS parent_id_12,
  c1_.parent_id AS parent_id_13
FROM
  categorie c0_
  LEFT JOIN categorie c1_ ON c0_.parent_id = c1_.id
ORDER BY
  c0_.nome ASC

SELECT c0_.id AS id_0, c0_.nome AS nome_1, c0_.slug AS slug_2, c0_.immagine AS immagine_3, c0_.ordine AS ordine_4, c0_.attiva AS attiva_5, c1_.id AS id_6, c1_.nome AS nome_7, c1_.slug AS slug_8, c1_.immagine AS immagine_9, c1_.ordine AS ordine_10, c1_.attiva AS attiva_11, c0_.parent_id AS parent_id_12, c1_.parent_id AS parent_id_13 FROM categorie c0_ LEFT JOIN categorie c1_ ON c0_.parent_id = c1_.id ORDER BY c0_.nome ASC;

#	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->getResult (line 688)
6	App\Repository\CategoriaRepository->findAllOrdered (line 40)
7	App\Controller\CatalogoController->index (line 27)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.22 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.parent_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.parent_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.parent_id = 1;

#	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->testEmpty (line 1423)
9	__TwigTemplate_26ab8759d7839cab0e58792cba2ac52a::block_body (line 245)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_1c452f0484b0254600c09ea041477928->doDisplay (line 297)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_26ab8759d7839cab0e58792cba2ac52a->doDisplay (line 54)
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 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	App\Controller\CatalogoController->index (line 29)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	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\Prodotto	1
App\Entity\Categoria	1

Entities Mapping

Class	Mapping errors
App\Entity\Prodotto	No errors.
App\Entity\Categoria	No errors.
App\Entity\ProdottoImmagine	No errors.
App\Entity\UsatoRichiesta	No errors.

Symfony Profiler

GET https://www.miniaturemarketplace.it/catalogo?categoria=1&disponibile=1&ordine=novita

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping