| 1 |
1.46 ms |
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_;
|
| 2 |
0.74 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
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;
|
| 3 |
0.71 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
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;
|
| 4 |
0.48 ms |
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_;
|
| 5 |
0.97 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"
]
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;
|
| 6 |
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: [
"user"
"N"
]
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 = 'user' AND INSTR(g1_.ruolo, 'N') > 0 ORDER BY g1_.ordinamento ASC;
|
| 7 |
0.69 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"
]
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 = 'info' AND INSTR(g1_.ruolo, 'N') > 0 ORDER BY g1_.ordinamento ASC;
|
| 8 |
0.70 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"
]
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 = 'main' AND INSTR(g1_.ruolo, 'N') > 0 ORDER BY g1_.ordinamento ASC;
|
| 9 |
0.69 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"
]
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 = 'sistema' AND INSTR(g1_.ruolo, 'N') > 0 ORDER BY g1_.ordinamento ASC;
|
| 10 |
0.61 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"
]
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 = 'scuola' AND INSTR(g1_.ruolo, 'N') > 0 ORDER BY g1_.ordinamento ASC;
|
| 11 |
0.61 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"
]
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 = 'ata' AND INSTR(g1_.ruolo, 'N') > 0 ORDER BY g1_.ordinamento ASC;
|
| 12 |
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: [
"docenti"
"N"
]
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 = 'docenti' AND INSTR(g1_.ruolo, 'N') > 0 ORDER BY g1_.ordinamento ASC;
|
| 13 |
0.52 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"
]
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 = 'alunni' AND INSTR(g1_.ruolo, 'N') > 0 ORDER BY g1_.ordinamento ASC;
|