POST https://reg.pontecagnano.istitutokennedy.net/coordinatore/scrutinio/voti/10/6/P/0

Query Metrics

26 Database Queries
13 Different statements
15.70 ms Query time
0 Invalid entities
34 Managed entities

Queries

Group similar statements

# Time Info
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')
Parameters:
[
  426
]
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 = ?
Parameters:
[
  10
]
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
]
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"
]
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
Parameters:
[
  10
  "P"
]
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
Parameters:
[
  "P"
  10
]
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
]
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
]
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
Parameters:
[
  10
  "P"
]
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
Parameters:
[
  6
  589
  6
]
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
Parameters:
[
  6
  552
  6
]
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
Parameters:
[
  6
  631
  6
]
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
Parameters:
[
  6
  76
  6
]
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
Parameters:
[
  6
  91
  6
]
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
Parameters:
[
  6
  625
  6
]
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
Parameters:
[
  6
  94
  6
]
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
Parameters:
[
  6
  533
  6
]
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
Parameters:
[
  6
  555
  6
]
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
Parameters:
[
  6
  682
  6
]
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
Parameters:
[
  6
  103
  6
]
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
Parameters:
[
  6
  79
  6
]
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
Parameters:
[
  6
  482
  6
]
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
Parameters:
[
  6
  106
  6
]
24 0.26 ms
"START TRANSACTION"
Parameters:
[]
25 0.42 ms
UPDATE gs_voto_scrutinio SET unico = ?, modificato = ? WHERE id = ?
Parameters:
[
  6
  "2026-06-10 12:20:03"
  1274
]
26 0.94 ms
"COMMIT"
Parameters:
[]

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\Utente 15
App\Entity\VotoScrutinio 14
App\Entity\Classe 1
App\Entity\Sede 1
App\Entity\Corso 1
App\Entity\Materia 1
App\Entity\Scrutinio 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\Corso No errors.
App\Entity\Orario No errors.
App\Entity\Materia No errors.
App\Entity\Cattedra No errors.
App\Entity\DefinizioneConsiglio No errors.
App\Entity\DefinizioneScrutinio No errors.
App\Entity\Scrutinio No errors.
App\Entity\VotoScrutinio No errors.