1
1.31 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' )
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'
)
Copy
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 = 426 AND t0 . ruolo IN ('UTE' , 'AMM' , 'ATA' , 'DOC' , 'STA' , 'PRE' , 'ALU' , 'GEN' );
Copy
2
0.57 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 , t0 . orario_id AS orario_id_12 FROM gs_classe t0 WHERE t0 . id = ?
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 , t0 . orario_id AS orario_id_12 FROM gs_classe t0 WHERE t0 . id = 10 ;
Copy
3
0.93 ms
SELECT g0_ . id AS id_0 , g0_ . creato AS creato_1 , g0_ . modificato AS modificato_2 , g0_ . nome AS nome_3 , g0_ . nome_breve AS nome_breve_4 , g0_ . tipo AS tipo_5 , g0_ . valutazione AS valutazione_6 , g0_ . media AS media_7 , g0_ . ordinamento AS ordinamento_8 FROM gs_materia g0_ INNER JOIN gs_cattedra g1_ ON (g1_ . materia_id = g0_ . id ) INNER JOIN gs_classe g2_ ON g1_ . classe_id = g2_ . id WHERE g0_ . id = ? AND g1_ . attiva = 1 AND g1_ . tipo = 'N' AND g2_ . sede_id = ? AND g2_ . corso_id = ? AND g2_ . anno = ? AND g2_ . sezione = ? AND (g2_ . gruppo = ? OR g2_ . gruppo = '' OR g2_ . gruppo IS NULL ) LIMIT 1
Parameters :
[
6
1
3
5
"A "
null
]
SELECT g0_ . id AS id_0 , g0_ . creato AS creato_1 , g0_ . modificato AS modificato_2 , g0_ . nome AS nome_3 , g0_ . nome_breve AS nome_breve_4 , g0_ . tipo AS tipo_5 , g0_ . valutazione AS valutazione_6 , g0_ . media AS media_7 , g0_ . ordinamento AS ordinamento_8 FROM gs_materia g0_ INNER JOIN gs_cattedra g1_ ON (g1_ . materia_id = g0_ . id ) INNER JOIN gs_classe g2_ ON g1_ . classe_id = g2_ . id WHERE g0_ . id = 6 AND g1_ . attiva = 1 AND g1_ . tipo = 'N' AND g2_ . sede_id = 1 AND g2_ . corso_id = 3 AND g2_ . anno = 5 AND g2_ . sezione = 'A' AND (g2_ . gruppo = NULL OR g2_ . gruppo = '' OR g2_ . gruppo IS NULL ) LIMIT 1 ;
Copy
4
0.68 ms
SELECT g0_ . periodo AS periodo_0 , g1_ . stato AS stato_1 FROM gs_definizione_consiglio g0_ LEFT JOIN gs_scrutinio g1_ ON (g1_ . periodo = g0_ . periodo AND g1_ . classe_id = ? ) WHERE (g0_ . data_proposte < = ? ) AND g0_ . tipo IN ('S' ) ORDER BY g0_ . data DESC LIMIT 1
Parameters :
[
10
"2026-06-10 "
]
SELECT g0_ . periodo AS periodo_0 , g1_ . stato AS stato_1 FROM gs_definizione_consiglio g0_ LEFT JOIN gs_scrutinio g1_ ON (g1_ . periodo = g0_ . periodo AND g1_ . classe_id = 10 ) WHERE (g0_ . data_proposte < = '2026-06-10' ) AND g0_ . tipo IN ('S' ) ORDER BY g0_ . data DESC LIMIT 1 ;
Copy
5
0.48 ms
SELECT g0_ . id AS id_0 , g0_ . creato AS creato_1 , g0_ . modificato AS modificato_2 , g0_ . periodo AS periodo_3 , g0_ . data AS data_4 , g0_ . inizio AS inizio_5 , g0_ . fine AS fine_6 , g0_ . stato AS stato_7 , g0_ . dati AS dati_8 , g0_ . visibile AS visibile_9 , g0_ . sincronizzazione AS sincronizzazione_10 , g0_ . classe_id AS classe_id_11 FROM gs_scrutinio g0_ WHERE g0_ . classe_id = ? AND g0_ . periodo = ? LIMIT 1
SELECT g0_ . id AS id_0 , g0_ . creato AS creato_1 , g0_ . modificato AS modificato_2 , g0_ . periodo AS periodo_3 , g0_ . data AS data_4 , g0_ . inizio AS inizio_5 , g0_ . fine AS fine_6 , g0_ . stato AS stato_7 , g0_ . dati AS dati_8 , g0_ . visibile AS visibile_9 , g0_ . sincronizzazione AS sincronizzazione_10 , g0_ . classe_id AS classe_id_11 FROM gs_scrutinio g0_ WHERE g0_ . classe_id = 10 AND g0_ . periodo = 'P' LIMIT 1 ;
Copy
6
0.43 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
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 = 'P' AND t0 . classe_id = 10 LIMIT 1 ;
Copy
7
0.97 ms
SELECT g0_ . id AS id_0 , g0_ . creato AS creato_1 , g0_ . modificato AS modificato_2 , g0_ . username AS username_3 , g0_ . password AS password_4 , g0_ . email AS email_5 , g0_ . token AS token_6 , g0_ . token_creato AS token_creato_7 , g0_ . prelogin AS prelogin_8 , g0_ . prelogin_creato AS prelogin_creato_9 , g0_ . abilitato AS abilitato_10 , g0_ . spid AS spid_11 , g0_ . ultimo_accesso AS ultimo_accesso_12 , g0_ . otp AS otp_13 , g0_ . ultimo_otp AS ultimo_otp_14 , g0_ . dispositivo AS dispositivo_15 , g0_ . nome AS nome_16 , g0_ . cognome AS cognome_17 , g0_ . sesso AS sesso_18 , g0_ . data_nascita AS data_nascita_19 , g0_ . comune_nascita AS comune_nascita_20 , g0_ . provincia_nascita AS provincia_nascita_21 , g0_ . codice_fiscale AS codice_fiscale_22 , g0_ . citta AS citta_23 , g0_ . provincia AS provincia_24 , g0_ . indirizzo AS indirizzo_25 , g0_ . numeri_telefono AS numeri_telefono_26 , g0_ . notifica AS notifica_27 , g0_ . rappresentante AS rappresentante_28 , g0_ . dati AS dati_29 , g0_ . bes AS bes_30 , g0_ . note_bes AS note_bes_31 , g0_ . autorizza_entrata AS autorizza_entrata_32 , g0_ . autorizza_uscita AS autorizza_uscita_33 , g0_ . note AS note_34 , g0_ . frequenza_estero AS frequenza_estero_35 , g0_ . religione AS religione_36 , g0_ . credito3 AS credito3_37 , g0_ . credito4 AS credito4_38 , g0_ . giustifica_online AS giustifica_online_39 , g0_ . richiesta_certificato AS richiesta_certificato_40 , g0_ . foto AS foto_41 , g0_ . ruolo AS ruolo_42 , g0_ . classe_id AS classe_id_43 FROM gs_utente g0_ WHERE (g0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND g0_ . ruolo IN ('ALU' ) ORDER BY g0_ . cognome ASC , g0_ . nome ASC , g0_ . data_nascita ASC
Parameters :
[
589
552
631
76
91
625
94
533
555
682
103
79
482
106
]
SELECT
g0_ . id AS id_0 ,
g0_ . creato AS creato_1 ,
g0_ . modificato AS modificato_2 ,
g0_ . username AS username_3 ,
g0_ . password AS password_4 ,
g0_ . email AS email_5 ,
g0_ . token AS token_6 ,
g0_ . token_creato AS token_creato_7 ,
g0_ . prelogin AS prelogin_8 ,
g0_ . prelogin_creato AS prelogin_creato_9 ,
g0_ . abilitato AS abilitato_10 ,
g0_ . spid AS spid_11 ,
g0_ . ultimo_accesso AS ultimo_accesso_12 ,
g0_ . otp AS otp_13 ,
g0_ . ultimo_otp AS ultimo_otp_14 ,
g0_ . dispositivo AS dispositivo_15 ,
g0_ . nome AS nome_16 ,
g0_ . cognome AS cognome_17 ,
g0_ . sesso AS sesso_18 ,
g0_ . data_nascita AS data_nascita_19 ,
g0_ . comune_nascita AS comune_nascita_20 ,
g0_ . provincia_nascita AS provincia_nascita_21 ,
g0_ . codice_fiscale AS codice_fiscale_22 ,
g0_ . citta AS citta_23 ,
g0_ . provincia AS provincia_24 ,
g0_ . indirizzo AS indirizzo_25 ,
g0_ . numeri_telefono AS numeri_telefono_26 ,
g0_ . notifica AS notifica_27 ,
g0_ . rappresentante AS rappresentante_28 ,
g0_ . dati AS dati_29 ,
g0_ . bes AS bes_30 ,
g0_ . note_bes AS note_bes_31 ,
g0_ . autorizza_entrata AS autorizza_entrata_32 ,
g0_ . autorizza_uscita AS autorizza_uscita_33 ,
g0_ . note AS note_34 ,
g0_ . frequenza_estero AS frequenza_estero_35 ,
g0_ . religione AS religione_36 ,
g0_ . credito3 AS credito3_37 ,
g0_ . credito4 AS credito4_38 ,
g0_ . giustifica_online AS giustifica_online_39 ,
g0_ . richiesta_certificato AS richiesta_certificato_40 ,
g0_ . foto AS foto_41 ,
g0_ . ruolo AS ruolo_42 ,
g0_ . classe_id AS classe_id_43
FROM
gs_utente g0_
WHERE
(
g0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
)
AND g0_ . ruolo IN ('ALU' )
ORDER BY
g0_ . cognome ASC ,
g0_ . nome ASC ,
g0_ . data_nascita ASC
Copy
SELECT g0_ . id AS id_0 , g0_ . creato AS creato_1 , g0_ . modificato AS modificato_2 , g0_ . username AS username_3 , g0_ . password AS password_4 , g0_ . email AS email_5 , g0_ . token AS token_6 , g0_ . token_creato AS token_creato_7 , g0_ . prelogin AS prelogin_8 , g0_ . prelogin_creato AS prelogin_creato_9 , g0_ . abilitato AS abilitato_10 , g0_ . spid AS spid_11 , g0_ . ultimo_accesso AS ultimo_accesso_12 , g0_ . otp AS otp_13 , g0_ . ultimo_otp AS ultimo_otp_14 , g0_ . dispositivo AS dispositivo_15 , g0_ . nome AS nome_16 , g0_ . cognome AS cognome_17 , g0_ . sesso AS sesso_18 , g0_ . data_nascita AS data_nascita_19 , g0_ . comune_nascita AS comune_nascita_20 , g0_ . provincia_nascita AS provincia_nascita_21 , g0_ . codice_fiscale AS codice_fiscale_22 , g0_ . citta AS citta_23 , g0_ . provincia AS provincia_24 , g0_ . indirizzo AS indirizzo_25 , g0_ . numeri_telefono AS numeri_telefono_26 , g0_ . notifica AS notifica_27 , g0_ . rappresentante AS rappresentante_28 , g0_ . dati AS dati_29 , g0_ . bes AS bes_30 , g0_ . note_bes AS note_bes_31 , g0_ . autorizza_entrata AS autorizza_entrata_32 , g0_ . autorizza_uscita AS autorizza_uscita_33 , g0_ . note AS note_34 , g0_ . frequenza_estero AS frequenza_estero_35 , g0_ . religione AS religione_36 , g0_ . credito3 AS credito3_37 , g0_ . credito4 AS credito4_38 , g0_ . giustifica_online AS giustifica_online_39 , g0_ . richiesta_certificato AS richiesta_certificato_40 , g0_ . foto AS foto_41 , g0_ . ruolo AS ruolo_42 , g0_ . classe_id AS classe_id_43 FROM gs_utente g0_ WHERE (g0_ . id IN (589 , 552 , 631 , 76 , 91 , 625 , 94 , 533 , 555 , 682 , 103 , 79 , 482 , 106 )) AND g0_ . ruolo IN ('ALU' ) ORDER BY g0_ . cognome ASC , g0_ . nome ASC , g0_ . data_nascita ASC ;
Copy
8
1.48 ms
SELECT g0_ . periodo AS periodo_0 , (g1_ . materia_id ) AS sclr_1 , (g1_ . alunno_id ) AS sclr_2 , g1_ . id AS id_3 , g1_ . creato AS creato_4 , g1_ . modificato AS modificato_5 , g1_ . orale AS orale_6 , g1_ . scritto AS scritto_7 , g1_ . pratico AS pratico_8 , g1_ . unico AS unico_9 , g1_ . debito AS debito_10 , g1_ . recupero AS recupero_11 , g1_ . assenze AS assenze_12 , g1_ . dati AS dati_13 , g1_ . scrutinio_id AS scrutinio_id_14 , g1_ . alunno_id AS alunno_id_15 , g1_ . materia_id AS materia_id_16 FROM gs_voto_scrutinio g1_ INNER JOIN gs_scrutinio g0_ ON g1_ . scrutinio_id = g0_ . id INNER JOIN gs_classe g2_ ON g0_ . classe_id = g2_ . id WHERE (g0_ . periodo = ? AND g2_ . anno = ? AND g2_ . sezione = ? ) AND g1_ . alunno_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND g1_ . materia_id IN (? ) ORDER BY g0_ . data ASC
Parameters :
[
"P "
5
"A "
589
552
631
76
91
625
94
533
555
682
103
79
482
106
6
]
SELECT g0_ . periodo AS periodo_0 , (g1_ . materia_id ) AS sclr_1 , (g1_ . alunno_id ) AS sclr_2 , g1_ . id AS id_3 , g1_ . creato AS creato_4 , g1_ . modificato AS modificato_5 , g1_ . orale AS orale_6 , g1_ . scritto AS scritto_7 , g1_ . pratico AS pratico_8 , g1_ . unico AS unico_9 , g1_ . debito AS debito_10 , g1_ . recupero AS recupero_11 , g1_ . assenze AS assenze_12 , g1_ . dati AS dati_13 , g1_ . scrutinio_id AS scrutinio_id_14 , g1_ . alunno_id AS alunno_id_15 , g1_ . materia_id AS materia_id_16 FROM gs_voto_scrutinio g1_ INNER JOIN gs_scrutinio g0_ ON g1_ . scrutinio_id = g0_ . id INNER JOIN gs_classe g2_ ON g0_ . classe_id = g2_ . id WHERE (g0_ . periodo = 'P' AND g2_ . anno = 5 AND g2_ . sezione = 'A' ) AND g1_ . alunno_id IN (589 , 552 , 631 , 76 , 91 , 625 , 94 , 533 , 555 , 682 , 103 , 79 , 482 , 106 ) AND g1_ . materia_id IN (6 ) ORDER BY g0_ . data ASC ;
Copy
9
0.72 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 . classe_id = ? AND t0 . periodo = ? LIMIT 1
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 . classe_id = 10 AND t0 . periodo = 'P' LIMIT 1 ;
Copy
10
0.74 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 589 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
11
0.46 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 552 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
12
0.43 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 631 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
13
0.42 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 76 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
14
0.40 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 91 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
15
0.40 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 625 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
16
0.46 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 94 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
17
0.52 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 533 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
18
0.50 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 555 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
19
0.47 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 682 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
20
0.42 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 103 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
21
0.47 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 79 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
22
0.42 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 482 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
23
0.40 ms
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = ? AND t0 . alunno_id = ? AND t0 . materia_id = ? LIMIT 2
SELECT t0 . id AS id_1 , t0 . creato AS creato_2 , t0 . modificato AS modificato_3 , t0 . orale AS orale_4 , t0 . scritto AS scritto_5 , t0 . pratico AS pratico_6 , t0 . unico AS unico_7 , t0 . debito AS debito_8 , t0 . recupero AS recupero_9 , t0 . assenze AS assenze_10 , t0 . dati AS dati_11 , t0 . scrutinio_id AS scrutinio_id_12 , t0 . alunno_id AS alunno_id_13 , t0 . materia_id AS materia_id_14 FROM gs_voto_scrutinio t0 WHERE t0 . scrutinio_id = 6 AND t0 . alunno_id = 106 AND t0 . materia_id = 6 LIMIT 2 ;
Copy
24
0.26 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
25
0.42 ms
UPDATE gs_voto_scrutinio SET unico = ? , modificato = ? WHERE id = ?
Parameters :
[
6
"2026-06-10 12:20:03 "
1274
]
UPDATE gs_voto_scrutinio SET unico = 6 , modificato = '2026-06-10 12:20:03' WHERE id = 1274 ;
Copy
26
0.94 ms
"COMMIT"