Symfony Profiler

Query Metrics

14 Database Queries

6 Different statements

10.29 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.51 ms
(53.61%)

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = ? AND INSTR(g1_.ruolo, ?) > 0 ORDER BY g1_.ordinamento ASC

Parameters:

[
  "help"
  "N"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'help' AND INSTR(g1_.ruolo, 'N') > 0 ORDER BY g1_.ordinamento ASC;

#	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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 46)
7	App\Repository\MenuRepository->menu (line 123)
8	App\Util\ConfigLoader->caricaMenu (line 66)
9	App\Util\ConfigLoader->carica (line 150)
10	App\Controller\AppController->info (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 11)

1.59 ms
(15.41%)

SELECT g0_.categoria AS categoria_0, g0_.parametro AS parametro_1, g0_.valore AS valore_2 FROM gs_configurazione g0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.categoria AS categoria_0,
  g0_.parametro AS parametro_1,
  g0_.valore AS valore_2
FROM
  gs_configurazione g0_

SELECT g0_.categoria AS categoria_0, g0_.parametro AS parametro_1, g0_.valore AS valore_2 FROM gs_configurazione g0_;

#	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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 68)
7	App\Repository\ConfigurazioneRepository->load (line 59)
8	App\Util\ConfigLoader->carica (line 150)
9	App\Controller\AppController->info (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 11)

1.48 ms
(14.44%)

SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.nome AS nome_4, t0.token AS token_5, t0.attiva AS attiva_6, t0.css AS css_7, t0.notifica AS notifica_8, t0.download AS download_9, t0.abilitati AS abilitati_10, t0.dati AS dati_11 FROM gs_app t0 WHERE t0.attiva = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.creato AS creato_2,
  t0.modificato AS modificato_3,
  t0.nome AS nome_4,
  t0.token AS token_5,
  t0.attiva AS attiva_6,
  t0.css AS css_7,
  t0.notifica AS notifica_8,
  t0.download AS download_9,
  t0.abilitati AS abilitati_10,
  t0.dati AS dati_11
FROM
  gs_app t0
WHERE
  t0.attiva = ?

SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.nome AS nome_4, t0.token AS token_5, t0.attiva AS attiva_6, t0.css AS css_7, t0.notifica AS notifica_8, t0.download AS download_9, t0.abilitati AS abilitati_10, t0.dati AS dati_11 FROM gs_app t0 WHERE t0.attiva = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 152)
4	App\Controller\AppController->info (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 11)

0.65 ms
(6.27%)

SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.tipo AS tipo_4, t0.tipo_sigla AS tipo_sigla_5, t0.nome AS nome_6, t0.nome_breve AS nome_breve_7, t0.email AS email_8, t0.pec AS pec_9, t0.url_sito AS url_sito_10, t0.url_registro AS url_registro_11, t0.firma_preside AS firma_preside_12, t0.email_amministratore AS email_amministratore_13, t0.email_notifiche AS email_notifiche_14 FROM gs_istituto t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.creato AS creato_2,
  t0.modificato AS modificato_3,
  t0.tipo AS tipo_4,
  t0.tipo_sigla AS tipo_sigla_5,
  t0.nome AS nome_6,
  t0.nome_breve AS nome_breve_7,
  t0.email AS email_8,
  t0.pec AS pec_9,
  t0.url_sito AS url_sito_10,
  t0.url_registro AS url_registro_11,
  t0.firma_preside AS firma_preside_12,
  t0.email_amministratore AS email_amministratore_13,
  t0.email_notifiche AS email_notifiche_14
FROM
  gs_istituto t0

SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.tipo AS tipo_4, t0.tipo_sigla AS tipo_sigla_5, t0.nome AS nome_6, t0.nome_breve AS nome_breve_7, t0.email AS email_8, t0.pec AS pec_9, t0.url_sito AS url_sito_10, t0.url_registro AS url_registro_11, t0.firma_preside AS firma_preside_12, t0.email_amministratore AS email_amministratore_13, t0.email_notifiche AS email_notifiche_14 FROM gs_istituto t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 96)
4	Doctrine\ORM\EntityRepository->findAll (line 81)
5	App\Util\ConfigLoader->caricaIstituto (line 64)
6	App\Util\ConfigLoader->carica (line 150)
7	App\Controller\AppController->info (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 11)

0.56 ms
(5.47%)

SELECT g0_.nome AS nome_0, g0_.nome_breve AS nome_breve_1, g0_.citta AS citta_2, g0_.indirizzo1 AS indirizzo1_3, g0_.indirizzo2 AS indirizzo2_4, g0_.telefono AS telefono_5 FROM gs_sede g0_ ORDER BY g0_.ordinamento ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.nome AS nome_0,
  g0_.nome_breve AS nome_breve_1,
  g0_.citta AS citta_2,
  g0_.indirizzo1 AS indirizzo1_3,
  g0_.indirizzo2 AS indirizzo2_4,
  g0_.telefono AS telefono_5
FROM
  gs_sede g0_
ORDER BY
  g0_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.nome_breve AS nome_breve_1, g0_.citta AS citta_2, g0_.indirizzo1 AS indirizzo1_3, g0_.indirizzo2 AS indirizzo2_4, g0_.telefono AS telefono_5 FROM gs_sede g0_ ORDER BY g0_.ordinamento ASC;

#	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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 102)
7	App\Util\ConfigLoader->caricaIstituto (line 64)
8	App\Util\ConfigLoader->carica (line 150)
9	App\Controller\AppController->info (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 11)

0.49 ms
(4.80%)

SELECT g0_.selettore AS selettore_0, g0_.nome AS nome_1, g0_.descrizione AS descrizione_2 FROM gs_menu g0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.selettore AS selettore_0,
  g0_.nome AS nome_1,
  g0_.descrizione AS descrizione_2
FROM
  gs_menu g0_

SELECT g0_.selettore AS selettore_0, g0_.nome AS nome_1, g0_.descrizione AS descrizione_2 FROM gs_menu g0_;

#	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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 168)
7	App\Repository\MenuRepository->listaMenu (line 121)
8	App\Util\ConfigLoader->caricaMenu (line 66)
9	App\Util\ConfigLoader->carica (line 150)
10	App\Controller\AppController->info (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 11)

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\Istituto	1

Entities Mapping

Class	Mapping errors
App\Entity\Configurazione	No errors.
App\Entity\Istituto	No errors.
App\Entity\Sede	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuOpzione	No errors.
App\Entity\App	No errors.

Symfony Profiler

GET https://registroelettronico.gespar.it/app/info/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping