GET https://registro.kennedysalerno.gespar.it/lezioni/registro/firme/205

Response
200 OK
Browse referrer URL
IP
212.216.148.239
Profiled on
Token
79bf55

Query Metrics

221 Database Queries
30 Different statements
57.91 ms Query time
0 Invalid entities
29 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.21 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.dati AS dati_30, t0.ruolo, t0.tipo AS tipo_31, t0.segreteria AS segreteria_32, t0.sede_id AS sede_id_33, t0.responsabile_bes AS responsabile_bes_34, t0.rspp AS rspp_35, t0.responsabile_bes_sede_id AS responsabile_bes_sede_id_36, t0.sede_id AS sede_id_37, t0.bes AS bes_38, t0.note_bes AS note_bes_39, t0.autorizza_entrata AS autorizza_entrata_40, t0.autorizza_uscita AS autorizza_uscita_41, t0.note AS note_42, t0.frequenza_estero AS frequenza_estero_43, t0.religione AS religione_44, t0.credito3 AS credito3_45, t0.credito4 AS credito4_46, t0.giustifica_online AS giustifica_online_47, t0.richiesta_certificato AS richiesta_certificato_48, t0.foto AS foto_49, t0.classe_id AS classe_id_50, t0.giustifica_online AS giustifica_online_51, t0.alunno_id AS alunno_id_52 FROM gs_utente t0 WHERE t0.id = ? AND t0.ruolo IN ('UTE', 'AMM', 'ATA', 'DOC', 'STA', 'PRE', 'ALU', 'GEN')
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.48 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: 
[
  205
  64
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.32 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: 
[
  35
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.42 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.25 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.59 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-03-12"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.23 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.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: 
[
  "giorni_festivi_istituto"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.25 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-03-10"
  "F"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.22 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: 
[
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.41 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.dati AS dati_30, t0.responsabile_bes AS responsabile_bes_31, t0.rspp AS rspp_32, t0.responsabile_bes_sede_id AS responsabile_bes_sede_id_33, t0.ruolo, t0.sede_id AS sede_id_34 FROM gs_utente t0 WHERE t0.id = ? AND t0.ruolo IN ('DOC', 'STA', 'PRE')
Parameters: 
[
  92
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.39 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.30 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-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 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_inizio"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.18 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.18 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.37 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-03-11"
  1
  "3"
  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-03-11"
  1
  "3"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.43 ms 
SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione g0_ INNER JOIN gs_comunicazione_classe g1_ ON (g1_.comunicazione_id = g0_.id) WHERE (g0_.stato = 'P' AND g1_.classe_id = ? AND g1_.letto IS NULL) AND g0_.categoria IN ('A') ORDER BY g0_.data ASC
Parameters: 
[
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.53 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.tipo AS tipo_3, g0_.cifrato AS cifrato_4, g0_.firma AS firma_5, g0_.stato AS stato_6, g0_.titolo AS titolo_7, g0_.data AS data_8, g0_.anno AS anno_9, g0_.speciali AS speciali_10, g0_.ata AS ata_11, g0_.coordinatori AS coordinatori_12, g0_.filtro_coordinatori AS filtro_coordinatori_13, g0_.docenti AS docenti_14, g0_.filtro_docenti AS filtro_docenti_15, g0_.genitori AS genitori_16, g0_.filtro_genitori AS filtro_genitori_17, g0_.rappresentanti_genitori AS rappresentanti_genitori_18, g0_.filtro_rappresentanti_genitori AS filtro_rappresentanti_genitori_19, g0_.alunni AS alunni_20, g0_.filtro_alunni AS filtro_alunni_21, g0_.rappresentanti_alunni AS rappresentanti_alunni_22, g0_.filtro_rappresentanti_alunni AS filtro_rappresentanti_alunni_23, g0_.esterni AS esterni_24, g0_.numero AS numero_25, g0_.categoria AS categoria_26, g0_.autore_id AS autore_id_27 FROM gs_comunicazione g0_ INNER JOIN gs_comunicazione_classe g1_ ON (g1_.comunicazione_id = g0_.id AND g1_.classe_id = ?) WHERE (g0_.stato = 'P' AND g0_.anno = 0 AND g1_.letto IS NULL) AND g0_.categoria IN ('C') ORDER BY g0_.data ASC, g0_.numero ASC
Parameters: 
[
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
21 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-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.23 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
23 0.19 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
24 0.19 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
25 0.51 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-03-11"
  1
  "3"
]
View formatted query    View runnable query    Explain query    View query backtrace
26 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-03-11"
  1
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.16 ms 
SELECT 1 FROM gs_ext_docente_status LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.26 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
29 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.37 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.29 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.27 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
33 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
34 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
35 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.21 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
38 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
39 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
40 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-03-11"
  2
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
42 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
43 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
44 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.21 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
46 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
48 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.20 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
51 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
52 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
53 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_.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-03-11"
  3
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.21 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.20 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
56 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
57 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.19 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.20 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
61 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.19 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.20 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
64 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
65 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
66 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_.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-03-11"
  4
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.22 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
68 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
69 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
70 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
71 0.21 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
72 0.28 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
73 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
74 0.27 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
75 0.25 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
76 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
77 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
78 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
79 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-03-11"
  5
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
80 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
81 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
82 0.36 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
83 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
84 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
85 0.21 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
86 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
87 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
88 0.18 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
89 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
90 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
91 0.19 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
92 0.31 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-03-11"
  6
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
93 0.19 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
94 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
95 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
96 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
97 0.19 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
98 0.21 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
99 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
100 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
101 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
102 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
103 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
104 0.19 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
105 0.30 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-03-11"
  7
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
106 0.21 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
107 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
108 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
109 0.19 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
110 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
111 0.21 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
112 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
113 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
114 0.23 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
115 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
116 0.24 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
117 0.18 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
118 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-03-11"
  8
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
119 0.26 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
120 0.21 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
121 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
122 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
123 0.18 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
124 0.20 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
125 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
126 0.19 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
127 0.18 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
128 0.20 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
129 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
130 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
131 0.30 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-03-11"
  9
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
132 0.17 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
133 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
134 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
135 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
136 0.19 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
137 0.21 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
138 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
139 0.19 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
140 0.17 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
141 0.21 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
142 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
143 0.18 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
144 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-03-11"
  10
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
145 0.90 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.argomento AS argomento_3, g0_.attivita AS attivita_4, g0_.tipo AS tipo_5, g0_.lezione_id AS lezione_id_6, g0_.docente_id AS docente_id_7, g0_.alunno_id AS alunno_id_8 FROM gs_firma g0_ INNER JOIN gs_utente g1_ ON g0_.docente_id = g1_.id AND g1_.ruolo IN ('DOC', 'STA', 'PRE') WHERE (g0_.lezione_id = ?) AND g0_.tipo IN ('N', 'S') ORDER BY g1_.cognome ASC, g1_.nome ASC
Parameters: 
[
  14073
]
View formatted query    View runnable query    Explain query    View query backtrace
146 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
147 0.21 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
148 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
149 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
150 0.18 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
151 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
152 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
153 0.19 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
154 0.19 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
155 0.20 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
156 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
157 0.19 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
158 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-03-11"
  11
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
159 0.78 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.argomento AS argomento_3, g0_.attivita AS attivita_4, g0_.tipo AS tipo_5, g0_.lezione_id AS lezione_id_6, g0_.docente_id AS docente_id_7, g0_.alunno_id AS alunno_id_8 FROM gs_firma g0_ INNER JOIN gs_utente g1_ ON g0_.docente_id = g1_.id AND g1_.ruolo IN ('DOC', 'STA', 'PRE') WHERE (g0_.lezione_id = ?) AND g0_.tipo IN ('N', 'S') ORDER BY g1_.cognome ASC, g1_.nome ASC
Parameters: 
[
  14074
]
View formatted query    View runnable query    Explain query    View query backtrace
160 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
161 0.21 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
162 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
163 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
164 0.19 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
165 0.21 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
166 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
167 0.19 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
168 0.17 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
169 0.19 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
170 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
171 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
172 0.30 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-03-11"
  12
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
173 0.17 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
174 0.20 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
175 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
176 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
177 0.18 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
178 0.20 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
179 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
180 0.19 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
181 0.26 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
182 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
183 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
184 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
185 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_.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-03-11"
  13
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
186 0.25 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
187 0.20 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
188 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
189 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
190 0.17 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
191 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
192 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
193 0.19 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
194 0.18 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
195 0.21 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
196 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
197 0.27 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
198 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-03-11"
  14
  5
  "A"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
199 0.20 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
200 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
201 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
202 0.19 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
203 0.17 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
204 0.20 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
205 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
206 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
207 0.17 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
208 0.19 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: 
[
  64
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
209 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
210 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
211 0.39 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-03-11"
  "2026-03-11"
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
212 0.46 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-03-11"
  "2026-03-11"
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
213 0.26 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
214 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"
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
215 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: 
[
  5
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
216 0.64 ms 
SELECT g0_.id AS id_0 FROM gs_utente g0_ WHERE (g0_.classe_id = ? AND g0_.frequenza_estero = 0) AND g0_.ruolo IN ('ALU')
Parameters: 
[
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
217 0.15 ms 
SELECT 1 FROM gs_ext_alunno_status LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
218 0.48 ms 
SELECT DISTINCT s.alunno_id FROM gs_ext_alunno_status s WHERE s.alunno_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  154
  157
  160
  331
  337
  541
  601
  642
  651
  717
  720
  723
  726
  729
  732
  906
  909
  976
  992
  995
  998
  1001
]
View formatted query    View runnable query    Explain query    View query backtrace
219 0.35 ms 
SELECT s.alunno_id FROM gs_ext_alunno_status s WHERE s.alunno_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s.stato IN (?) AND ? BETWEEN s.valid_from AND COALESCE(s.valid_to, '9999-12-31')
Parameters: 
[
  154
  157
  160
  331
  337
  541
  601
  642
  651
  717
  720
  723
  726
  729
  732
  906
  909
  976
  992
  995
  998
  1001
  "ATTIVO"
  "2026-03-11"
]
View formatted query    View runnable query    Explain query    View query backtrace
220 1.09 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-03-11"
  "2026-03-11"
  "2026-03-11"
  "2026-03-11"
  154
  157
  160
  331
  337
  541
  601
  642
  651
  717
  720
  723
  726
  729
  732
  906
  909
  995
  998
  1001
]
View formatted query    View runnable query    Explain query    View query backtrace
221 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: 
[
  2
]
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 2
App\Entity\Lezione 2
App\Entity\Firma 2
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\Comunicazione No errors.
App\Entity\Avviso No errors.
App\Entity\ComunicazioneClasse No errors.
App\Entity\Circolare No errors.
App\Entity\Lezione No errors.
App\Entity\ModuloFormativo No errors.
App\Entity\Scrutinio No errors.
App\Entity\Firma No errors.
App\Entity\FirmaSostegno No errors.
App\Entity\Annotazione No errors.
App\Entity\Nota No errors.
App\Entity\Assenza No errors.
App\Entity\Entrata No errors.
App\Entity\Uscita No errors.
App\Entity\Presenza No errors.