GET https://reg.salerno.istitutokennedy.net/lezioni/registro/edit/318/6/2026-05-28/3

Response
200 OK
Browse referrer URL
IP
93.38.233.32
Profiled on
Token
051b6a

Query Metrics

20 Database Queries
17 Different statements
10.14 ms Query time
0 Invalid entities
15 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.26 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: 
[
  59
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.55 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: 
[
  6
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.46 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.classe_id = ? AND t0.attiva = ? LIMIT 1
Parameters: 
[
  318
  59
  6
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.55 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.data AS data_3, g0_.descrizione AS descrizione_4, g0_.tipo AS tipo_5, g0_.sede_id AS sede_id_6 FROM gs_festivita g0_ WHERE (g0_.sede_id IS NULL OR g0_.sede_id = ?) AND g0_.tipo = ? AND g0_.data = ?
Parameters: 
[
  1
  "F"
  "2026-05-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.48 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
6 0.41 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
7 0.38 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
8 0.59 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.data AS data_3, g0_.ora AS ora_4, g0_.gruppo AS gruppo_5, g0_.tipo_gruppo AS tipo_gruppo_6, g0_.argomento AS argomento_7, g0_.attivita AS attivita_8, g0_.sostituzione AS sostituzione_9, g0_.classe_id AS classe_id_10, g0_.materia_id AS materia_id_11, g0_.modulo_formativo_id AS modulo_formativo_id_12 FROM gs_lezione g0_ INNER JOIN gs_classe g1_ ON g0_.classe_id = g1_.id WHERE g0_.data = ? AND g0_.ora = ? AND g1_.anno = ? AND g1_.sezione = ? AND g1_.id = ? ORDER BY g0_.gruppo ASC
Parameters: 
[
  "2026-05-28"
  3
  2
  "A"
  6
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.59 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')
Parameters: 
[
  20869
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.30 ms 
SELECT 1 FROM gs_ext_docente_status LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.36 ms 
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters: 
[
  59
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.42 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(NULLIF(s.valid_to, '0000-00-00'), '9999-12-31')
Parameters: 
[
  59
  "ATTIVO"
  "2026-05-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.49 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: 
[
  2
  "A"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.61 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: 
[
  37
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.41 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"
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.35 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"
  45
]
View formatted query    View runnable query    Explain query    View query backtrace
17 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.orario AS orario_6 FROM gs_corso t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.35 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
19 0.38 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_.classi AS classi_6 FROM gs_modulo_formativo g0_ ORDER BY g0_.tipo ASC, g0_.nome_breve ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.84 ms 
SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.attiva AS attiva_3, g0_.supplenza AS supplenza_4, g0_.tipo AS tipo_5, g0_.materia_id AS materia_id_6, g0_.docente_id AS docente_id_7, g0_.classe_id AS classe_id_8, g0_.alunno_id AS alunno_id_9, g0_.docente_supplenza_id AS docente_supplenza_id_10 FROM gs_cattedra g0_ INNER JOIN gs_materia g1_ ON g0_.materia_id = g1_.id LEFT JOIN gs_utente g2_ ON g0_.alunno_id = g2_.id AND g2_.ruolo IN ('ALU') WHERE g0_.docente_id = ? AND g0_.classe_id = ? AND g0_.attiva = 1 AND g1_.tipo IN ('N', 'E') ORDER BY g1_.nome_breve ASC, g2_.cognome ASC, g2_.nome ASC
Parameters: 
[
  59
  6
]
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\Classe 3
App\Entity\Configurazione 3
App\Entity\Utente 2
App\Entity\Corso 2
App\Entity\Sede 1
App\Entity\Cattedra 1
App\Entity\Materia 1
App\Entity\Lezione 1
App\Entity\Firma 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\Cattedra No errors.
App\Entity\Materia No errors.
App\Entity\Festivita No errors.
App\Entity\Configurazione No errors.
App\Entity\Lezione No errors.
App\Entity\ModuloFormativo No errors.
App\Entity\Firma No errors.
App\Entity\FirmaSostegno No errors.
App\Entity\Scrutinio No errors.