Query Metrics
14
Database Queries
6
Different statements
10.29 ms
Query time
0
Invalid entities
1
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.59 ms |
SELECT g0_.categoria AS categoria_0, g0_.parametro AS parametro_1, g0_.valore AS valore_2 FROM gs_configurazione g0_
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 2 | 0.65 ms |
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:
[]
|
||||||||||||||||||||||||||||||||
| 3 | 0.56 ms |
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:
[]
|
||||||||||||||||||||||||||||||||
| 4 | 0.49 ms |
SELECT g0_.selettore AS selettore_0, g0_.nome AS nome_1, g0_.descrizione AS descrizione_2 FROM gs_menu g0_
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 5 | 0.94 ms |
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" ]
|
||||||||||||||||||||||||||||||||
| 6 | 0.56 ms |
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:
[ "user" "N" ]
|
||||||||||||||||||||||||||||||||
| 7 | 0.58 ms |
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:
[ "info" "N" ]
|
||||||||||||||||||||||||||||||||
| 8 | 0.59 ms |
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:
[ "main" "N" ]
|
||||||||||||||||||||||||||||||||
| 9 | 0.68 ms |
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:
[ "sistema" "N" ]
|
||||||||||||||||||||||||||||||||
| 10 | 0.56 ms |
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:
[ "scuola" "N" ]
|
||||||||||||||||||||||||||||||||
| 11 | 0.54 ms |
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:
[ "ata" "N" ]
|
||||||||||||||||||||||||||||||||
| 12 | 0.51 ms |
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:
[ "docenti" "N" ]
|
||||||||||||||||||||||||||||||||
| 13 | 0.57 ms |
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:
[ "alunni" "N" ]
|
||||||||||||||||||||||||||||||||
| 14 | 1.48 ms |
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
]
|
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. |