Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

18.39 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.29 ms
(83.11%)

SELECT a0_.codice AS codice_0, a1_.denominazione AS denominazione_1, a0_.nome_sito AS nome_sito_2, SUM(a0_.scarico) AS sclr_3, a1_.capacita AS capacita_4, a1_.taglio AS taglio_5, a2_.data_bolla AS data_bolla_6 FROM adm_elenco_movimenti a0_ INNER JOIN adm_bolle a2_ ON a0_.bolla_id = a2_.id, adm_db_nomi a1_ WHERE a2_.data_bolla = ? AND a0_.scarico > 0 AND a0_.nome_id = a1_.id AND a0_.tipo_cliente = ? GROUP BY a0_.codice, a0_.nome_sito

Parameters:

[
  "2024-12-23"
  "privato"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.codice AS codice_0,
  a1_.denominazione AS denominazione_1,
  a0_.nome_sito AS nome_sito_2,
  SUM(a0_.scarico) AS sclr_3,
  a1_.capacita AS capacita_4,
  a1_.taglio AS taglio_5,
  a2_.data_bolla AS data_bolla_6
FROM
  adm_elenco_movimenti a0_
  INNER JOIN adm_bolle a2_ ON a0_.bolla_id = a2_.id,
  adm_db_nomi a1_
WHERE
  a2_.data_bolla = ?
  AND a0_.scarico > 0
  AND a0_.nome_id = a1_.id
  AND a0_.tipo_cliente = ?
GROUP BY
  a0_.codice,
  a0_.nome_sito

SELECT a0_.codice AS codice_0, a1_.denominazione AS denominazione_1, a0_.nome_sito AS nome_sito_2, SUM(a0_.scarico) AS sclr_3, a1_.capacita AS capacita_4, a1_.taglio AS taglio_5, a2_.data_bolla AS data_bolla_6 FROM adm_elenco_movimenti a0_ INNER JOIN adm_bolle a2_ ON a0_.bolla_id = a2_.id, adm_db_nomi a1_ WHERE a2_.data_bolla = '2024-12-23' AND a0_.scarico > 0 AND a0_.nome_id = a1_.id AND a0_.tipo_cliente = 'privato' GROUP BY a0_.codice, a0_.nome_sito;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 387)
7	App\Controller\ADMController->picklist (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

2.14 ms
(11.66%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nome_completo AS nome_completo_5, t0.username AS username_6, t0.account_id AS account_id_7 FROM admuser t0 WHERE t0.id = ?

Parameters:

[
  7
]

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.nome_completo AS nome_completo_5,
  t0.username AS username_6,
  t0.account_id AS account_id_7
FROM
  admuser 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.nome_completo AS nome_completo_5, t0.username AS username_6, t0.account_id AS account_id_7 FROM admuser t0 WHERE t0.id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.96 ms
(5.23%)

SELECT t0.id AS id_1, t0.codice AS codice_2, t0.ragione_sociale AS ragione_sociale_3, t0.partita_iva AS partita_iva_4, t0.registration_date AS registration_date_5, t0.last_modify AS last_modify_6, t0.status AS status_7, t0.indirizzo AS indirizzo_8, t0.localita AS localita_9, t0.altri_dati AS altri_dati_10, t0.logo AS logo_11 FROM adm_account t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.codice AS codice_2,
  t0.ragione_sociale AS ragione_sociale_3,
  t0.partita_iva AS partita_iva_4,
  t0.registration_date AS registration_date_5,
  t0.last_modify AS last_modify_6,
  t0.status AS status_7,
  t0.indirizzo AS indirizzo_8,
  t0.localita AS localita_9,
  t0.altri_dati AS altri_dati_10,
  t0.logo AS logo_11
FROM
  adm_account t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codice AS codice_2, t0.ragione_sociale AS ragione_sociale_3, t0.partita_iva AS partita_iva_4, t0.registration_date AS registration_date_5, t0.last_modify AS last_modify_6, t0.status AS status_7, t0.indirizzo AS indirizzo_8, t0.localita AS localita_9, t0.altri_dati AS altri_dati_10, t0.logo AS logo_11 FROM adm_account t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\ADM\Account::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\ADM\Account->__get (line 314)
8	App\Entity\ADM\Account->getLogo (line 1754)
9	Twig\Extension\CoreExtension::getAttribute (line 114)
10	__TwigTemplate_d67be981e92005385394c6f19bac15ec->doDisplay (line 393)
11	Twig\Template->yield (line 84)
12	__TwigTemplate_520a699d04a4506b3763d4ec9c42f31b->doDisplay (line 393)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_585563e97274063199086453ff5270af->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 391)
23	App\Controller\ADMController->picklist (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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.

Entities Mapping

Class	Mapping errors
App\Entity\ADM\ADMUser	No errors.
App\Entity\ADM\Account	No errors.
App\Entity\ADM\ElencoMovimenti	No errors.
App\Entity\ADM\Bolle	No errors.
App\Entity\ADM\DBNomi	No errors.
App\Entity\ADM\Categorie	No errors.
App\Entity\ADM\PuntiVendita	No errors.

Symfony Profiler

GET https://www.danielecutilli.it/gestionale_adm/picklist

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping