GET https://registro.kennedybattipaglia.gespar.it/lezioni/registro/firme/34/1/2026-05-11

Response
200 OK
Browse referrer URL
IP
93.150.202.227
Profiled on
Token
730ad3

Query Metrics

125 Database Queries
25 Different statements
58.60 ms Query time
0 Invalid entities
24 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.08 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.username AS username_4, t0.password AS password_5, t0.email AS email_6, t0.token AS token_7, t0.token_creato AS token_creato_8, t0.prelogin AS prelogin_9, t0.prelogin_creato AS prelogin_creato_10, t0.abilitato AS abilitato_11, t0.spid AS spid_12, t0.ultimo_accesso AS ultimo_accesso_13, t0.otp AS otp_14, t0.ultimo_otp AS ultimo_otp_15, t0.dispositivo AS dispositivo_16, t0.nome AS nome_17, t0.cognome AS cognome_18, t0.sesso AS sesso_19, t0.data_nascita AS data_nascita_20, t0.comune_nascita AS comune_nascita_21, t0.provincia_nascita AS provincia_nascita_22, t0.codice_fiscale AS codice_fiscale_23, t0.citta AS citta_24, t0.provincia AS provincia_25, t0.indirizzo AS indirizzo_26, t0.numeri_telefono AS numeri_telefono_27, t0.notifica AS notifica_28, t0.rappresentante AS rappresentante_29, t0.ruolo, t0.tipo AS tipo_30, t0.segreteria AS segreteria_31, t0.sede_id AS sede_id_32, t0.responsabile_bes AS responsabile_bes_33, t0.rspp AS rspp_34, t0.responsabile_bes_sede_id AS responsabile_bes_sede_id_35, t0.sede_id AS sede_id_36, t0.bes AS bes_37, t0.note_bes AS note_bes_38, t0.autorizza_entrata AS autorizza_entrata_39, t0.autorizza_uscita AS autorizza_uscita_40, t0.note AS note_41, t0.frequenza_estero AS frequenza_estero_42, t0.religione AS religione_43, t0.credito3 AS credito3_44, t0.credito4 AS credito4_45, t0.giustifica_online AS giustifica_online_46, t0.richiesta_certificato AS richiesta_certificato_47, t0.foto AS foto_48, t0.classe_id AS classe_id_49, t0.giustifica_online AS giustifica_online_50, t0.alunno_id AS alunno_id_51 FROM gs_utente t0 WHERE t0.id = ? AND t0.ruolo IN ('UTE', 'AMM', 'ATA', 'DOC', 'STA', 'PRE', 'ALU', 'GEN')
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.52 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.attiva AS attiva_4, t0.supplenza AS supplenza_5, t0.tipo AS tipo_6, t0.materia_id AS materia_id_7, t0.docente_id AS docente_id_8, t0.classe_id AS classe_id_9, t0.alunno_id AS alunno_id_10, t0.docente_supplenza_id AS docente_supplenza_id_11 FROM gs_cattedra t0 WHERE t0.id = ? AND t0.docente_id = ? AND t0.attiva = ? LIMIT 1
Parameters: 
[
  34
  10
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.33 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.nome AS nome_4, t0.nome_breve AS nome_breve_5, t0.tipo AS tipo_6, t0.valutazione AS valutazione_7, t0.media AS media_8, t0.ordinamento AS ordinamento_9 FROM gs_materia t0 WHERE t0.id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.29 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.categoria AS categoria_4, t0.parametro AS parametro_5, t0.descrizione AS descrizione_6, t0.valore AS valore_7, t0.gestito AS gestito_8 FROM gs_configurazione t0 WHERE t0.parametro = ? LIMIT 1
Parameters: 
[
  "anno_fine"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.30 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.categoria AS categoria_4, t0.parametro AS parametro_5, t0.descrizione AS descrizione_6, t0.valore AS valore_7, t0.gestito AS gestito_8 FROM gs_configurazione t0 WHERE t0.parametro = ? LIMIT 1
Parameters: 
[
  "giorni_festivi_istituto"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.28 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.data AS data_4, t0.descrizione AS descrizione_5, t0.tipo AS tipo_6, t0.sede_id AS sede_id_7 FROM gs_festivita t0 WHERE t0.data = ? AND t0.sede_id IS NULL
Parameters: 
[
  "2026-05-12"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.26 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.categoria AS categoria_4, t0.parametro AS parametro_5, t0.descrizione AS descrizione_6, t0.valore AS valore_7, t0.gestito AS gestito_8 FROM gs_configurazione t0 WHERE t0.parametro = ? LIMIT 1
Parameters: 
[
  "anno_inizio"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.20 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.categoria AS categoria_4, t0.parametro AS parametro_5, t0.descrizione AS descrizione_6, t0.valore AS valore_7, t0.gestito AS gestito_8 FROM gs_configurazione t0 WHERE t0.parametro = ? LIMIT 1
Parameters: 
[
  "giorni_festivi_istituto"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.22 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.categoria AS categoria_4, t0.parametro AS parametro_5, t0.descrizione AS descrizione_6, t0.valore AS valore_7, t0.gestito AS gestito_8 FROM gs_configurazione t0 WHERE t0.parametro = ? LIMIT 1
Parameters: 
[
  "giorni_festivi_istituto"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.26 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.data AS data_4, t0.descrizione AS descrizione_5, t0.tipo AS tipo_6, t0.sede_id AS sede_id_7 FROM gs_festivita t0 WHERE t0.data = ? AND t0.sede_id IS NULL AND t0.tipo = ?
Parameters: 
[
  "2026-05-09"
  "F"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.28 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.anno AS anno_4, t0.sezione AS sezione_5, t0.gruppo AS gruppo_6, t0.ore_settimanali AS ore_settimanali_7, t0.sede_id AS sede_id_8, t0.corso_id AS corso_id_9, t0.coordinatore_id AS coordinatore_id_10, t0.segretario_id AS segretario_id_11 FROM gs_classe t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.37 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.data AS data_3, g0_.descrizione AS descrizione_4, g0_.tipo AS tipo_5, g0_.sede_id AS sede_id_6 FROM gs_festivita g0_ WHERE (g0_.sede_id IS NULL OR g0_.sede_id = ?) AND g0_.tipo = ? ORDER BY g0_.data ASC
Parameters: 
[
  1
  "F"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.32 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.data AS data_3, g0_.descrizione AS descrizione_4, g0_.tipo AS tipo_5, g0_.sede_id AS sede_id_6 FROM gs_festivita g0_ WHERE (g0_.sede_id IS NULL OR g0_.sede_id = ?) AND g0_.tipo = ? AND g0_.data = ?
Parameters: 
[
  1
  "F"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.24 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.categoria AS categoria_4, t0.parametro AS parametro_5, t0.descrizione AS descrizione_6, t0.valore AS valore_7, t0.gestito AS gestito_8 FROM gs_configurazione t0 WHERE t0.parametro = ? LIMIT 1
Parameters: 
[
  "anno_inizio"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.21 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.categoria AS categoria_4, t0.parametro AS parametro_5, t0.descrizione AS descrizione_6, t0.valore AS valore_7, t0.gestito AS gestito_8 FROM gs_configurazione t0 WHERE t0.parametro = ? LIMIT 1
Parameters: 
[
  "anno_fine"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.20 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.categoria AS categoria_4, t0.parametro AS parametro_5, t0.descrizione AS descrizione_6, t0.valore AS valore_7, t0.gestito AS gestito_8 FROM gs_configurazione t0 WHERE t0.parametro = ? LIMIT 1
Parameters: 
[
  "giorni_festivi_istituto"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.40 ms 
SELECT g0_.inizio AS inizio_0 FROM gs_scansione_oraria g0_ INNER JOIN gs_orario g1_ ON g0_.orario_id = g1_.id WHERE ? BETWEEN g1_.inizio AND g1_.fine AND g1_.sede_id = ? AND g0_.giorno = ? AND g0_.ora = ? LIMIT 1
Parameters: 
[
  "2026-05-12"
  1
  "2"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.44 ms 
SELECT g0_.fine AS fine_0 FROM gs_scansione_oraria g0_ INNER JOIN gs_orario g1_ ON g0_.orario_id = g1_.id WHERE ? BETWEEN g1_.inizio AND g1_.fine AND g1_.sede_id = ? AND g0_.giorno = ? ORDER BY g0_.ora DESC LIMIT 1
Parameters: 
[
  "2026-05-12"
  1
  "2"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.28 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.data AS data_3, g0_.descrizione AS descrizione_4, g0_.tipo AS tipo_5, g0_.sede_id AS sede_id_6 FROM gs_festivita g0_ WHERE (g0_.sede_id IS NULL OR g0_.sede_id = ?) AND g0_.tipo = ? AND g0_.data = ?
Parameters: 
[
  1
  "F"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.22 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.categoria AS categoria_4, t0.parametro AS parametro_5, t0.descrizione AS descrizione_6, t0.valore AS valore_7, t0.gestito AS gestito_8 FROM gs_configurazione t0 WHERE t0.parametro = ? LIMIT 1
Parameters: 
[
  "anno_inizio"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.22 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.categoria AS categoria_4, t0.parametro AS parametro_5, t0.descrizione AS descrizione_6, t0.valore AS valore_7, t0.gestito AS gestito_8 FROM gs_configurazione t0 WHERE t0.parametro = ? LIMIT 1
Parameters: 
[
  "anno_fine"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.20 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.categoria AS categoria_4, t0.parametro AS parametro_5, t0.descrizione AS descrizione_6, t0.valore AS valore_7, t0.gestito AS gestito_8 FROM gs_configurazione t0 WHERE t0.parametro = ? LIMIT 1
Parameters: 
[
  "giorni_festivi_istituto"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.42 ms 
SELECT g0_.giorno AS giorno_0, g0_.ora AS ora_1, g0_.inizio AS inizio_2, g0_.fine AS fine_3, g0_.durata AS durata_4 FROM gs_scansione_oraria g0_ INNER JOIN gs_orario g1_ ON g0_.orario_id = g1_.id WHERE ? BETWEEN g1_.inizio AND g1_.fine AND g1_.sede_id = ? AND g0_.giorno = ? ORDER BY g0_.ora ASC
Parameters: 
[
  "2026-05-11"
  1
  "1"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.41 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.data AS data_3, g0_.ora AS ora_4, g0_.gruppo AS gruppo_5, g0_.tipo_gruppo AS tipo_gruppo_6, g0_.argomento AS argomento_7, g0_.attivita AS attivita_8, g0_.sostituzione AS sostituzione_9, g0_.classe_id AS classe_id_10, g0_.materia_id AS materia_id_11, g0_.modulo_formativo_id AS modulo_formativo_id_12 FROM gs_lezione g0_ INNER JOIN gs_classe g1_ ON g0_.classe_id = g1_.id WHERE g0_.data = ? AND g0_.ora = ? AND g1_.anno = ? AND g1_.sezione = ? AND g1_.id = ? ORDER BY g0_.gruppo ASC
Parameters: 
[
  "2026-05-11"
  1
  1
  "A"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.19 ms 
SELECT 1 FROM gs_ext_docente_status LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.25 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.24 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.30 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.26 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.29 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.27 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.28 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.23 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.23 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.29 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.22 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.40 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.data AS data_3, g0_.ora AS ora_4, g0_.gruppo AS gruppo_5, g0_.tipo_gruppo AS tipo_gruppo_6, g0_.argomento AS argomento_7, g0_.attivita AS attivita_8, g0_.sostituzione AS sostituzione_9, g0_.classe_id AS classe_id_10, g0_.materia_id AS materia_id_11, g0_.modulo_formativo_id AS modulo_formativo_id_12 FROM gs_lezione g0_ INNER JOIN gs_classe g1_ ON g0_.classe_id = g1_.id WHERE g0_.data = ? AND g0_.ora = ? AND g1_.anno = ? AND g1_.sezione = ? AND g1_.id = ? ORDER BY g0_.gruppo ASC
Parameters: 
[
  "2026-05-11"
  2
  1
  "A"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.22 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.27 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.21 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.26 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.27 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.34 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.25 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.26 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.30 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.22 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.34 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.data AS data_3, g0_.ora AS ora_4, g0_.gruppo AS gruppo_5, g0_.tipo_gruppo AS tipo_gruppo_6, g0_.argomento AS argomento_7, g0_.attivita AS attivita_8, g0_.sostituzione AS sostituzione_9, g0_.classe_id AS classe_id_10, g0_.materia_id AS materia_id_11, g0_.modulo_formativo_id AS modulo_formativo_id_12 FROM gs_lezione g0_ INNER JOIN gs_classe g1_ ON g0_.classe_id = g1_.id WHERE g0_.data = ? AND g0_.ora = ? AND g1_.anno = ? AND g1_.sezione = ? AND g1_.id = ? ORDER BY g0_.gruppo ASC
Parameters: 
[
  "2026-05-11"
  3
  1
  "A"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.25 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.23 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.27 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.21 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.22 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.25 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.33 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.25 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.22 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.23 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.30 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.21 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.36 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.data AS data_3, g0_.ora AS ora_4, g0_.gruppo AS gruppo_5, g0_.tipo_gruppo AS tipo_gruppo_6, g0_.argomento AS argomento_7, g0_.attivita AS attivita_8, g0_.sostituzione AS sostituzione_9, g0_.classe_id AS classe_id_10, g0_.materia_id AS materia_id_11, g0_.modulo_formativo_id AS modulo_formativo_id_12 FROM gs_lezione g0_ INNER JOIN gs_classe g1_ ON g0_.classe_id = g1_.id WHERE g0_.data = ? AND g0_.ora = ? AND g1_.anno = ? AND g1_.sezione = ? AND g1_.id = ? ORDER BY g0_.gruppo ASC
Parameters: 
[
  "2026-05-11"
  4
  1
  "A"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
65 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.22 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.34 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.25 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
69 0.25 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
70 0.27 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
71 0.35 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
72 0.24 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
73 0.24 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
74 0.32 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
75 0.33 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
76 0.24 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
77 0.38 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.data AS data_3, g0_.ora AS ora_4, g0_.gruppo AS gruppo_5, g0_.tipo_gruppo AS tipo_gruppo_6, g0_.argomento AS argomento_7, g0_.attivita AS attivita_8, g0_.sostituzione AS sostituzione_9, g0_.classe_id AS classe_id_10, g0_.materia_id AS materia_id_11, g0_.modulo_formativo_id AS modulo_formativo_id_12 FROM gs_lezione g0_ INNER JOIN gs_classe g1_ ON g0_.classe_id = g1_.id WHERE g0_.data = ? AND g0_.ora = ? AND g1_.anno = ? AND g1_.sezione = ? AND g1_.id = ? ORDER BY g0_.gruppo ASC
Parameters: 
[
  "2026-05-11"
  5
  1
  "A"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
78 3.44 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
79 9.47 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
80 10.85 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
81 0.90 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
82 0.24 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
83 0.26 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
84 0.31 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
85 0.22 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
86 0.21 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
87 0.23 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
88 0.27 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
89 0.22 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
90 0.37 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.data AS data_3, g0_.ora AS ora_4, g0_.gruppo AS gruppo_5, g0_.tipo_gruppo AS tipo_gruppo_6, g0_.argomento AS argomento_7, g0_.attivita AS attivita_8, g0_.sostituzione AS sostituzione_9, g0_.classe_id AS classe_id_10, g0_.materia_id AS materia_id_11, g0_.modulo_formativo_id AS modulo_formativo_id_12 FROM gs_lezione g0_ INNER JOIN gs_classe g1_ ON g0_.classe_id = g1_.id WHERE g0_.data = ? AND g0_.ora = ? AND g1_.anno = ? AND g1_.sezione = ? AND g1_.id = ? ORDER BY g0_.gruppo ASC
Parameters: 
[
  "2026-05-11"
  6
  1
  "A"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
91 0.25 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
92 0.22 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
93 0.27 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
94 0.20 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
95 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
96 0.26 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
97 0.28 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
98 0.20 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
99 0.19 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
100 0.22 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
101 0.29 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
102 0.20 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
103 0.33 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.data AS data_3, g0_.ora AS ora_4, g0_.gruppo AS gruppo_5, g0_.tipo_gruppo AS tipo_gruppo_6, g0_.argomento AS argomento_7, g0_.attivita AS attivita_8, g0_.sostituzione AS sostituzione_9, g0_.classe_id AS classe_id_10, g0_.materia_id AS materia_id_11, g0_.modulo_formativo_id AS modulo_formativo_id_12 FROM gs_lezione g0_ INNER JOIN gs_classe g1_ ON g0_.classe_id = g1_.id WHERE g0_.data = ? AND g0_.ora = ? AND g1_.anno = ? AND g1_.sezione = ? AND g1_.id = ? ORDER BY g0_.gruppo ASC
Parameters: 
[
  "2026-05-11"
  7
  1
  "A"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
104 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
105 0.30 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
106 0.28 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
107 0.22 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
108 0.21 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
109 0.24 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
110 0.29 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
111 0.21 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
112 0.19 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
113 0.22 ms 
SELECT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  10
  "ATTIVO"
  "2026-05-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
114 0.27 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
115 0.22 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
116 0.53 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.data AS data_3, g0_.testo AS testo_4, g0_.visibile AS visibile_5, g0_.avviso_id AS avviso_id_6, g0_.classe_id AS classe_id_7, g0_.docente_id AS docente_id_8 FROM gs_annotazione g0_ INNER JOIN gs_utente g1_ ON g0_.docente_id = g1_.id AND g1_.ruolo IN ('DOC', 'STA', 'PRE') INNER JOIN gs_classe g2_ ON g0_.classe_id = g2_.id WHERE g0_.data BETWEEN ? AND ? AND g2_.anno = ? AND g2_.sezione = ? ORDER BY g0_.data ASC, g0_.modificato DESC
Parameters: 
[
  "2026-05-11"
  "2026-05-11"
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
117 0.45 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.tipo AS tipo_3, g0_.data AS data_4, g0_.testo AS testo_5, g0_.provvedimento AS provvedimento_6, g0_.annullata AS annullata_7, g0_.classe_id AS classe_id_8, g0_.docente_id AS docente_id_9, g0_.docente_provvedimento_id AS docente_provvedimento_id_10 FROM gs_nota g0_ INNER JOIN gs_utente g1_ ON g0_.docente_id = g1_.id AND g1_.ruolo IN ('DOC', 'STA', 'PRE') INNER JOIN gs_classe g2_ ON g0_.classe_id = g2_.id LEFT JOIN gs_utente g3_ ON g0_.docente_provvedimento_id = g3_.id AND g3_.ruolo IN ('DOC', 'STA', 'PRE') WHERE g0_.data BETWEEN ? AND ? AND g2_.anno = ? AND g2_.sezione = ? ORDER BY g0_.data ASC, g0_.modificato DESC
Parameters: 
[
  "2026-05-11"
  "2026-05-11"
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
118 0.28 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
119 0.22 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.periodo AS periodo_4, t0.data AS data_5, t0.inizio AS inizio_6, t0.fine AS fine_7, t0.stato AS stato_8, t0.dati AS dati_9, t0.visibile AS visibile_10, t0.sincronizzazione AS sincronizzazione_11, t0.classe_id AS classe_id_12 FROM gs_scrutinio t0 WHERE t0.periodo = ? AND t0.classe_id = ? LIMIT 1
Parameters: 
[
  "F"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
120 0.25 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.anno AS anno_3, g0_.sezione AS sezione_4, g0_.gruppo AS gruppo_5, g0_.ore_settimanali AS ore_settimanali_6, g0_.sede_id AS sede_id_7, g0_.corso_id AS corso_id_8, g0_.coordinatore_id AS coordinatore_id_9, g0_.segretario_id AS segretario_id_10 FROM gs_classe g0_ WHERE g0_.anno = ? AND g0_.sezione = ? AND g0_.gruppo <> '' ORDER BY g0_.gruppo ASC
Parameters: 
[
  1
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
121 0.64 ms 
SELECT g0_.id AS id_0 FROM gs_utente g0_ WHERE (g0_.classe_id = ? AND g0_.frequenza_estero = 0 AND NOT EXISTS (SELECT g1_.id FROM gs_cambio_classe g1_ WHERE (g1_.alunno_id = g0_.id AND ? BETWEEN g1_.inizio AND g1_.fine) AND (g1_.classe_id IS NULL OR g1_.classe_id <> ?))) AND g0_.ruolo IN ('ALU')
Parameters: 
[
  1
  "2026-05-11"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
122 0.29 ms 
SELECT g0_.id AS id_0 FROM gs_utente g0_ INNER JOIN gs_cambio_classe g1_ ON (g0_.id = g1_.alunno_id) WHERE (g0_.frequenza_estero = 0 AND ? BETWEEN g1_.inizio AND g1_.fine AND g1_.classe_id = ?) AND g0_.ruolo IN ('ALU')
Parameters: 
[
  "2026-05-11"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
123 0.16 ms 
SELECT 1 FROM gs_ext_alunno_status LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
124 0.74 ms 
SELECT g0_.id AS id_0, g0_.cognome AS cognome_1, g0_.nome AS nome_2, g0_.data_nascita AS data_nascita_3, g1_.id AS id_4, g2_.id AS id_5, g2_.ora AS ora_6, g3_.id AS id_7, g3_.ora AS ora_8, g4_.id AS id_9, g4_.ora_inizio AS ora_inizio_10, g4_.ora_fine AS ora_fine_11, g4_.tipo AS tipo_12, g4_.descrizione AS descrizione_13 FROM gs_utente g0_ LEFT JOIN gs_assenza g1_ ON (g0_.id = g1_.alunno_id AND g1_.data = ?) LEFT JOIN gs_entrata g2_ ON (g0_.id = g2_.alunno_id AND g2_.data = ?) LEFT JOIN gs_uscita g3_ ON (g0_.id = g3_.alunno_id AND g3_.data = ?) LEFT JOIN gs_presenza g4_ ON (g0_.id = g4_.alunno_id AND g4_.data = ?) WHERE (g0_.id IN (?, ?, ?)) AND g0_.ruolo IN ('ALU') ORDER BY g0_.cognome ASC, g0_.nome ASC, g0_.data_nascita ASC
Parameters: 
[
  "2026-05-11"
  "2026-05-11"
  "2026-05-11"
  "2026-05-11"
  21
  24
  27
]
View formatted query    View runnable query    Explain query    View query backtrace
125 0.20 ms 
SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.nome AS nome_4, t0.nome_breve AS nome_breve_5, t0.orario AS orario_6 FROM gs_corso t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Festivita 15
App\Entity\Configurazione 3
App\Entity\Utente 1
App\Entity\Cattedra 1
App\Entity\Materia 1
App\Entity\Classe 1
App\Entity\Sede 1
App\Entity\Corso 1

Entities Mapping

Class Mapping errors
App\Entity\Utente No errors.
App\Entity\Amministratore No errors.
App\Entity\Ata No errors.
App\Entity\Sede No errors.
App\Entity\Docente No errors.
App\Entity\Staff No errors.
App\Entity\Preside No errors.
App\Entity\Alunno No errors.
App\Entity\Classe No errors.
App\Entity\Genitore No errors.
App\Entity\Cattedra No errors.
App\Entity\Materia No errors.
App\Entity\Festivita No errors.
App\Entity\Configurazione No errors.
App\Entity\Corso No errors.
App\Entity\ScansioneOraria No errors.
App\Entity\Orario No errors.
App\Entity\Lezione No errors.
App\Entity\ModuloFormativo No errors.
App\Entity\Scrutinio No errors.
App\Entity\Annotazione No errors.
App\Entity\Comunicazione No errors.
App\Entity\Avviso No errors.
App\Entity\Nota No errors.
App\Entity\CambioClasse No errors.
App\Entity\Assenza No errors.
App\Entity\Entrata No errors.
App\Entity\Uscita No errors.
App\Entity\Presenza No errors.