GET https://reg.salerno.istitutokennedy.net/lezioni/voti/quadro

Query Metrics

22 Database Queries
19 Different statements
14.45 ms Query time
0 Invalid entities
7 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.76 ms
(12.17%)
1
SELECT g0_.id AS id_0, g1_.id AS id_1, g1_.tipo AS tipo_2, g1_.argomento AS argomento_3, g1_.ordine AS ordine_4, g1_.visibile AS visibile_5, g1_.media AS media_6, g1_.voto AS voto_7, g1_.giudizio AS giudizio_8, g2_.data AS data_9, g3_.id AS id_10, g3_.nome AS nome_11, g3_.cognome AS cognome_12 FROM gs_valutazione g1_ INNER JOIN gs_utente g0_ ON g1_.alunno_id = g0_.id AND g0_.ruolo IN ('ALU') INNER JOIN gs_lezione g2_ ON g1_.lezione_id = g2_.id INNER JOIN gs_utente g3_ ON g1_.docente_id = g3_.id AND g3_.ruolo IN ('DOC', 'STA', 'PRE') INNER JOIN gs_classe g4_ ON g2_.classe_id = g4_.id WHERE g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND g1_.materia_id = ? AND g2_.data BETWEEN ? AND ? AND g4_.anno = ? AND g4_.sezione = ? ORDER BY g2_.data DESC, g1_.ordine DESC
Parameters:
[
  992
  154
  157
  160
  331
  337
  601
  642
  651
  717
  720
  723
  726
  729
  732
  906
  909
  976
  995
  998
  1001
  31
  "2026-02-01"
  "2026-06-10"
  5
  "A"
]
1.60 ms
(11.05%)
1
SELECT g0_.id AS id_0, g1_.cognome AS cognome_1, g1_.nome AS nome_2, g1_.codice_fiscale AS codice_fiscale_3, g1_.numeri_telefono AS numeri_telefono_4, g1_.spid AS spid_5, g1_.username AS username_6, g1_.email AS email_7, g1_.ultimo_accesso AS ultimo_accesso_8 FROM gs_utente g0_ INNER JOIN gs_utente g1_ ON (g1_.alunno_id = g0_.id) AND g1_.ruolo IN ('GEN') WHERE (g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND g0_.ruolo IN ('ALU') ORDER BY g1_.username ASC
Parameters:
[
  992
  154
  157
  160
  331
  337
  601
  642
  651
  717
  720
  723
  726
  729
  732
  906
  909
  976
  995
  998
  1001
]
1.28 ms
(8.87%)
1
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:
[
  3
]
1.02 ms
(7.07%)
1
SELECT g0_.id AS id_0 FROM gs_utente g0_ WHERE (g0_.classe_id = ? AND g0_.abilitato = 1 AND g0_.frequenza_estero = 0 AND NOT EXISTS (SELECT g1_.id FROM gs_cambio_classe g1_ WHERE (g1_.alunno_id = g0_.id AND g1_.inizio <= ? AND g1_.fine >= ?) AND (g1_.classe_id IS NULL OR g1_.classe_id <> ?))) AND g0_.ruolo IN ('ALU')
Parameters:
[
  31
  "2026-02-01"
  "2026-06-10"
  31
]
1.01 ms
(6.98%)
2
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"
]
0.85 ms
(5.90%)
2
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:
[
  3
  "ATTIVO"
  "2026-02-01"
]
0.79 ms
(5.49%)
1
SELECT g0_.id AS id_0, g0_.cognome AS cognome_1, g0_.nome AS nome_2, g0_.data_nascita AS data_nascita_3, g0_.sesso AS sesso_4, g0_.citta AS citta_5, g0_.bes AS bes_6, g0_.note_bes AS note_bes_7, g0_.autorizza_entrata AS autorizza_entrata_8, g0_.autorizza_uscita AS autorizza_uscita_9, g0_.note AS note_10, g0_.religione AS religione_11, g0_.username AS username_12, g0_.ultimo_accesso AS ultimo_accesso_13, (g0_.classe_id) AS sclr_14 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:
[
  992
  154
  157
  160
  331
  337
  601
  642
  651
  717
  720
  723
  726
  729
  732
  906
  909
  976
  995
  998
  1001
]
0.77 ms
(5.32%)
2
SELECT DISTINCT s.docente_id FROM gs_ext_docente_status s WHERE s.docente_id IN (?)
Parameters:
[
  3
]
0.68 ms
(4.69%)
1
SELECT COUNT(g0_.id) AS sclr_0 FROM gs_cattedra g0_ INNER JOIN gs_classe g1_ ON g0_.classe_id = g1_.id WHERE g0_.docente_id = ? AND g0_.materia_id = ? AND g0_.attiva = 1 AND g0_.tipo <> 'S' AND g1_.anno = ? AND g1_.sezione = ? AND (g1_.gruppo IS NULL OR g1_.gruppo = '' OR g1_.gruppo = ?)
Parameters:
[
  3
  31
  5
  "A"
  null
]
0.61 ms
(4.25%)
1
SELECT s.alunno_id FROM gs_ext_alunno_status s WHERE s.alunno_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s.stato IN (?) AND s.valid_from <= ? AND (s.valid_to IS NULL OR s.valid_to = '0000-00-00' OR s.valid_to >= ?)
Parameters:
[
  154
  157
  160
  331
  337
  601
  642
  651
  717
  720
  723
  726
  729
  732
  906
  909
  976
  992
  995
  998
  1001
  "ATTIVO"
  "2026-06-10"
  "2026-02-01"
]
0.60 ms
(4.14%)
1
SELECT DISTINCT s.alunno_id FROM gs_ext_alunno_status s WHERE s.alunno_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  154
  157
  160
  331
  337
  601
  642
  651
  717
  720
  723
  726
  729
  732
  906
  909
  976
  992
  995
  998
  1001
]
0.56 ms
(3.89%)
1
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
]
0.52 ms
(3.59%)
1
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:
[
  210
  3
  1
]
0.51 ms
(3.50%)
1
SELECT g0_.id AS id_0 FROM gs_utente g0_ INNER JOIN gs_cambio_classe g1_ ON (g0_.id = g1_.alunno_id) WHERE (g0_.frequenza_estero = 0 AND g1_.inizio <= ? AND g1_.fine >= ? AND g1_.classe_id = ? AND (g0_.classe_id IS NULL OR g0_.classe_id <> ?)) AND g0_.ruolo IN ('ALU')
Parameters:
[
  "2026-06-10"
  "2026-02-01"
  31
  31
]
0.43 ms
(2.96%)
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 = ? AND t0.classe_id = ? LIMIT 1
Parameters:
[
  "F"
  31
]
0.42 ms
(2.87%)
1
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:
[
  31
]
0.40 ms
(2.76%)
1
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:
[
  31
]
0.34 ms
(2.35%)
1
SELECT 1 FROM gs_ext_docente_status LIMIT 1
Parameters:
[]
0.31 ms
(2.13%)
1
SELECT 1 FROM gs_ext_alunno_status LIMIT 1
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 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\Corso No errors.
App\Entity\Orario No errors.
App\Entity\Scrutinio No errors.
App\Entity\CambioClasse No errors.
App\Entity\Valutazione No errors.
App\Entity\Lezione No errors.