Symfony Profiler

SELECT
  g0_.id AS id_0,
  g0_.creato AS creato_1,
  g0_.modificato AS modificato_2,
  g0_.periodo AS periodo_3,
  g0_.orale AS orale_4,
  g0_.scritto AS scritto_5,
  g0_.pratico AS pratico_6,
  g0_.unico AS unico_7,
  g0_.debito AS debito_8,
  g0_.recupero AS recupero_9,
  g0_.assenze AS assenze_10,
  g0_.dati AS dati_11,
  g0_.alunno_id AS alunno_id_12,
  g0_.classe_id AS classe_id_13,
  g0_.materia_id AS materia_id_14,
  g0_.docente_id AS docente_id_15
FROM
  gs_proposta_voto g0_
WHERE
  g0_.periodo = ?
  AND g0_.alunno_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )
  AND g0_.materia_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT g0_.id AS id_0, g0_.creato AS creato_1, g0_.modificato AS modificato_2, g0_.periodo AS periodo_3, g0_.orale AS orale_4, g0_.scritto AS scritto_5, g0_.pratico AS pratico_6, g0_.unico AS unico_7, g0_.debito AS debito_8, g0_.recupero AS recupero_9, g0_.assenze AS assenze_10, g0_.dati AS dati_11, g0_.alunno_id AS alunno_id_12, g0_.classe_id AS classe_id_13, g0_.materia_id AS materia_id_14, g0_.docente_id AS docente_id_15 FROM gs_proposta_voto g0_ WHERE g0_.periodo = 'P' AND g0_.alunno_id IN (485, 580, 536, 622, 539, 121, 592, 542, 558, 488, 491, 494, 497, 163, 434, 500, 175) AND g0_.materia_id IN (24, 30, 6, 7, 8, 9, 11, 14, 10);

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')

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 = 685 AND t0.ruolo IN ('DOC', 'STA', 'PRE');

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

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 = 16) WHERE (g0_.data_proposte <= '2026-06-10') AND g0_.tipo IN ('S') ORDER BY g0_.data DESC LIMIT 1;

SELECT
  DISTINCT 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_
  INNER JOIN gs_cattedra g1_ ON (g1_.materia_id = g0_.id)
  INNER JOIN gs_classe g2_ ON g1_.classe_id = g2_.id
WHERE
  g1_.attiva = 1
  AND g1_.tipo = 'N'
  AND g0_.tipo <> 'S'
  AND g2_.id = ?
ORDER BY
  g0_.ordinamento ASC

SELECT DISTINCT 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_ INNER JOIN gs_cattedra g1_ ON (g1_.materia_id = g0_.id) INNER JOIN gs_classe g2_ ON g1_.classe_id = g2_.id WHERE g1_.attiva = 1 AND g1_.tipo = 'N' AND g0_.tipo <> 'S' AND g2_.id = 16 ORDER BY g0_.ordinamento ASC;

SELECT
  g0_.valore AS valore_0
FROM
  gs_configurazione g0_
WHERE
  g0_.parametro = ?

SELECT g0_.valore AS valore_0 FROM gs_configurazione g0_ WHERE g0_.parametro = 'voti_finali_R';

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 = 9 AND t0.ruolo IN ('UTE', 'AMM', 'ATA', 'DOC', 'STA', 'PRE', 'ALU', 'GEN');

SELECT
  g0_.id AS id_0
FROM
  gs_utente g0_
WHERE
  (
    g0_.classe_id = ?
    AND g0_.frequenza_estero = 0
    AND NOT EXISTS (
      SELECT
        g1_.id
      FROM
        gs_cambio_classe g1_
      WHERE
        (
          g1_.alunno_id = g0_.id
          AND ? BETWEEN g1_.inizio
          AND g1_.fine
        )
        AND (
          g1_.classe_id IS NULL
          OR g1_.classe_id <> ?
        )
    )
  )
  AND g0_.ruolo IN ('ALU')

SELECT g0_.id AS id_0 FROM gs_utente g0_ WHERE (g0_.classe_id = 16 AND g0_.frequenza_estero = 0 AND NOT EXISTS (SELECT g1_.id FROM gs_cambio_classe g1_ WHERE (g1_.alunno_id = g0_.id AND '2026-01-31' BETWEEN g1_.inizio AND g1_.fine) AND (g1_.classe_id IS NULL OR g1_.classe_id <> 16))) AND g0_.ruolo IN ('ALU');

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

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 (121, 163, 175, 434, 485, 488, 491, 494, 497, 500, 536, 539, 542, 558, 580, 592, 622, 670, 679, 689, 714, 717, 723, 741, 744)) AND g0_.ruolo IN ('ALU') ORDER BY g0_.cognome ASC, g0_.nome ASC, g0_.data_nascita ASC;

SELECT
  DISTINCT s.alunno_id
FROM
  gs_ext_alunno_status s
WHERE
  s.alunno_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT DISTINCT s.alunno_id FROM gs_ext_alunno_status s WHERE s.alunno_id IN (485, 580, 723, 536, 622, 539, 121, 592, 679, 542, 558, 714, 670, 488, 741, 491, 744, 494, 497, 717, 163, 434, 689, 500, 175);

SELECT
  s.alunno_id
FROM
  gs_ext_alunno_status s
WHERE
  s.alunno_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND s.stato IN (?)
  AND ? BETWEEN s.valid_from
  AND COALESCE(
    NULLIF(s.valid_to, '0000-00-00'),
    '9999-12-31'
  )

SELECT s.alunno_id FROM gs_ext_alunno_status s WHERE s.alunno_id IN (485, 580, 723, 536, 622, 539, 121, 592, 679, 542, 558, 714, 670, 488, 741, 491, 744, 494, 497, 717, 163, 434, 689, 500, 175) AND s.stato IN ('ATTIVO') AND '2026-01-31' BETWEEN s.valid_from AND COALESCE(NULLIF(s.valid_to, '0000-00-00'), '9999-12-31');

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 = 16;

SELECT
  t0.id AS id_1,
  t0.creato AS creato_2,
  t0.modificato AS modificato_3,
  t0.data AS data_4,
  t0.argomenti AS argomenti_5,
  t0.dati AS dati_6,
  t0.periodo AS periodo_7,
  t0.data_proposte AS data_proposte_8,
  t0.struttura AS struttura_9,
  t0.classi_visibili AS classi_visibili_10,
  t0.tipo
FROM
  gs_definizione_consiglio t0
WHERE
  t0.periodo = ?
  AND t0.tipo IN ('S')
LIMIT
  1

SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.data AS data_4, t0.argomenti AS argomenti_5, t0.dati AS dati_6, t0.periodo AS periodo_7, t0.data_proposte AS data_proposte_8, t0.struttura AS struttura_9, t0.classi_visibili AS classi_visibili_10, t0.tipo FROM gs_definizione_consiglio t0 WHERE t0.periodo = 'P' AND t0.tipo IN ('S') LIMIT 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 ? BETWEEN g1_.inizio
    AND g1_.fine
    AND g1_.classe_id = ?
  )
  AND g0_.ruolo IN ('ALU')

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 '2026-01-31' BETWEEN g1_.inizio AND g1_.fine AND g1_.classe_id = 16) AND g0_.ruolo IN ('ALU');

SELECT
  1
FROM
  gs_ext_alunno_status
LIMIT
  1

SELECT 1 FROM gs_ext_alunno_status LIMIT 1;