Redirect 302 redirect from POST @coordinatore_scrutinio_voti (5cf2f5)

GET https://reg.pontecagnano.istitutokennedy.net/coordinatore/scrutinio/10

Response
200 OK
Browse referrer URL
IP
188.12.125.141
Profiled on
Token
eb5d17

Query Metrics

21 Database Queries
11 Different statements
11.81 ms Query time
0 Invalid entities
199 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
]
View formatted query    View runnable query    Explain query    View query backtrace
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
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.73 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"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.52 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, g0_.orario_id AS orario_id_11 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
5 0.45 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"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.44 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
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.78 ms 
SELECT g0_.id AS id_0, g0_.nome AS nome_1, g0_.cognome AS cognome_2, g0_.data_nascita AS data_nascita_3, g0_.religione AS religione_4, g0_.bes AS bes_5 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
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.53 ms 
SELECT g0_.id AS id_0, g0_.nome AS nome_1, g0_.nome_breve AS nome_breve_2, g0_.tipo AS tipo_3, g0_.ordinamento AS ordinamento_4 FROM gs_materia g0_ WHERE g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND g0_.tipo <> 'S' ORDER BY g0_.ordinamento ASC
Parameters: 
[
  15
  9
  10
  8
  30
  24
  11
  14
  6
  7
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.42 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.tipo = ? LIMIT 1
Parameters: 
[
  "E"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.38 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.tipo = ? LIMIT 1
Parameters: 
[
  "C"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 1.84 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY g0_.data ASC
Parameters: 
[
  "P"
  5
  "A"
  589
  552
  631
  76
  91
  625
  94
  533
  555
  682
  103
  79
  482
  106
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.43 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: 
[
  6
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.47 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: 
[
  7
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.38 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: 
[
  8
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.37 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: 
[
  9
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.37 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: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.36 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: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.37 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: 
[
  14
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.34 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: 
[
  15
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.38 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: 
[
  24
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.37 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: 
[
  30
]
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\VotoScrutinio 168
App\Entity\Utente 15
App\Entity\Materia 12
App\Entity\Classe 1
App\Entity\Sede 1
App\Entity\Corso 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\DefinizioneConsiglio No errors.
App\Entity\DefinizioneScrutinio No errors.
App\Entity\Scrutinio No errors.
App\Entity\Materia No errors.
App\Entity\VotoScrutinio No errors.