Symfony Profiler

Query Metrics

80 Database Queries

5 Different statements

1281.41 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1199.88 ms
(93.64%)

SELECT t0.id AS id_1, t0.data AS data_2, t0.data_ordine AS data_ordine_3, t0.idordine AS idordine_4, t0.codice AS codice_5, t0.prodotto AS prodotto_6, t0.nome_sito AS nome_sito_7, t0.cliente AS cliente_8, t0.tipo_cliente AS tipo_cliente_9, t0.indirizzo AS indirizzo_10, t0.nicotina AS nicotina_11, t0.ml AS ml_12, t0.carico AS carico_13, t0.scarico AS scarico_14, t0.giacenza AS giacenza_15, t0.ml_totali_caricati AS ml_totali_caricati_16, t0.ml_totali_scaricati AS ml_totali_scaricati_17, t0.causale AS causale_18, t0.senza_nicotina AS senza_nicotina_19, t0.note AS note_20, t0.lotto_scadenza AS lotto_scadenza_21, t0.prezzo AS prezzo_22, t0.bolla_id AS bolla_id_23, t0.nome_id AS nome_id_24, t0.account_id AS account_id_25, t0.puntivendita_id AS puntivendita_id_26 FROM adm_elenco_movimenti t0 WHERE t0.bolla_id = ?

Parameters:

[
  1503
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.data AS data_2,
  t0.data_ordine AS data_ordine_3,
  t0.idordine AS idordine_4,
  t0.codice AS codice_5,
  t0.prodotto AS prodotto_6,
  t0.nome_sito AS nome_sito_7,
  t0.cliente AS cliente_8,
  t0.tipo_cliente AS tipo_cliente_9,
  t0.indirizzo AS indirizzo_10,
  t0.nicotina AS nicotina_11,
  t0.ml AS ml_12,
  t0.carico AS carico_13,
  t0.scarico AS scarico_14,
  t0.giacenza AS giacenza_15,
  t0.ml_totali_caricati AS ml_totali_caricati_16,
  t0.ml_totali_scaricati AS ml_totali_scaricati_17,
  t0.causale AS causale_18,
  t0.senza_nicotina AS senza_nicotina_19,
  t0.note AS note_20,
  t0.lotto_scadenza AS lotto_scadenza_21,
  t0.prezzo AS prezzo_22,
  t0.bolla_id AS bolla_id_23,
  t0.nome_id AS nome_id_24,
  t0.account_id AS account_id_25,
  t0.puntivendita_id AS puntivendita_id_26
FROM
  adm_elenco_movimenti t0
WHERE
  t0.bolla_id = ?

SELECT t0.id AS id_1, t0.data AS data_2, t0.data_ordine AS data_ordine_3, t0.idordine AS idordine_4, t0.codice AS codice_5, t0.prodotto AS prodotto_6, t0.nome_sito AS nome_sito_7, t0.cliente AS cliente_8, t0.tipo_cliente AS tipo_cliente_9, t0.indirizzo AS indirizzo_10, t0.nicotina AS nicotina_11, t0.ml AS ml_12, t0.carico AS carico_13, t0.scarico AS scarico_14, t0.giacenza AS giacenza_15, t0.ml_totali_caricati AS ml_totali_caricati_16, t0.ml_totali_scaricati AS ml_totali_scaricati_17, t0.causale AS causale_18, t0.senza_nicotina AS senza_nicotina_19, t0.note AS note_20, t0.lotto_scadenza AS lotto_scadenza_21, t0.prezzo AS prezzo_22, t0.bolla_id AS bolla_id_23, t0.nome_id AS nome_id_24, t0.account_id AS account_id_25, t0.puntivendita_id AS puntivendita_id_26 FROM adm_elenco_movimenti t0 WHERE t0.bolla_id = 1503;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 425)
9	Doctrine\ORM\PersistentCollection->offsetGet (line 914)
10	App\Controller\ADMController->print_all_invoice (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

52.65 ms
(4.11%)

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.numero_vicinato AS numero_vicinato_5, t0.numero_ordinale AS numero_ordinale_6, t0.registration_date AS registration_date_7, t0.last_modify AS last_modify_8, t0.status AS status_9, t0.indirizzo AS indirizzo_10, t0.localita AS localita_11, t0.provincia AS provincia_12, t0.altri_dati AS altri_dati_13, t0.account_id AS account_id_14 FROM adm_punti_vendita t0 WHERE t0.account_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.numero_vicinato AS numero_vicinato_5,
  t0.numero_ordinale AS numero_ordinale_6,
  t0.registration_date AS registration_date_7,
  t0.last_modify AS last_modify_8,
  t0.status AS status_9,
  t0.indirizzo AS indirizzo_10,
  t0.localita AS localita_11,
  t0.provincia AS provincia_12,
  t0.altri_dati AS altri_dati_13,
  t0.account_id AS account_id_14
FROM
  adm_punti_vendita t0
WHERE
  t0.account_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.numero_vicinato AS numero_vicinato_5, t0.numero_ordinale AS numero_ordinale_6, t0.registration_date AS registration_date_7, t0.last_modify AS last_modify_8, t0.status AS status_9, t0.indirizzo AS indirizzo_10, t0.localita AS localita_11, t0.provincia AS provincia_12, t0.altri_dati AS altri_dati_13, t0.account_id AS account_id_14 FROM adm_punti_vendita t0 WHERE t0.account_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 913)
4	App\Controller\ADMController->print_all_invoice (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

24.93 ms
(1.95%)

SELECT t0.id AS id_1, t0.primo_ordine AS primo_ordine_2, t0.idordine AS idordine_3, t0.numero AS numero_4, t0.data_bolla AS data_bolla_5, t0.note AS note_6, t0.is_carico AS is_carico_7, t0.account_id AS account_id_8, t0.puntivendita_id AS puntivendita_id_9 FROM adm_bolle t0 WHERE t0.id = ?

Parameters:

[
  "1503"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.primo_ordine AS primo_ordine_2,
  t0.idordine AS idordine_3,
  t0.numero AS numero_4,
  t0.data_bolla AS data_bolla_5,
  t0.note AS note_6,
  t0.is_carico AS is_carico_7,
  t0.account_id AS account_id_8,
  t0.puntivendita_id AS puntivendita_id_9
FROM
  adm_bolle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.primo_ordine AS primo_ordine_2, t0.idordine AS idordine_3, t0.numero AS numero_4, t0.data_bolla AS data_bolla_5, t0.note AS note_6, t0.is_carico AS is_carico_7, t0.account_id AS account_id_8, t0.puntivendita_id AS puntivendita_id_9 FROM adm_bolle t0 WHERE t0.id = '1503';

#	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 906)
6	App\Controller\ADMController->print_all_invoice (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

3.07 ms
(0.24%)

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.88 ms
(0.07%)

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 936)
9	App\Controller\ADMController->print_all_invoice (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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\Bolle	No errors.
App\Entity\ADM\PuntiVendita	No errors.
App\Entity\ADM\ElencoMovimenti	No errors.
App\Entity\ADM\DBNomi	No errors.
App\Entity\ADM\Categorie	No errors.
App\Entity\ADM\Sigla	The association App\Entity\ADM\Sigla#account refers to the inverse side field App\Entity\ADM\Account#sigle which does not exist.
App\Entity\ADM\MovimentiCategorie	The association App\Entity\ADM\MovimentiCategorie#account refers to the inverse side field App\Entity\ADM\Account#movimenti_categorie which does not exist.
App\Entity\ADM\ElencoMovimentiGiornaliero	The association App\Entity\ADM\ElencoMovimentiGiornaliero#account refers to the inverse side field App\Entity\ADM\Account#movimenti_giornalieri which does not exist.

Symfony Profiler

GET https://www.danielecutilli.it/gestionale_adm/print-all-invoice/1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,15…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping