Symfony Profiler

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

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_richiesta_colloquio g0_
  INNER JOIN gs_colloquio g1_ ON g0_.colloquio_id = g1_.id
WHERE
  g0_.stato = ?
  AND g1_.docente_id = ?
  AND g1_.abilitato = ?
  AND g1_.data >= ?

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_richiesta_colloquio g0_ INNER JOIN gs_colloquio g1_ ON g0_.colloquio_id = g1_.id WHERE g0_.stato = 'R' AND g1_.docente_id = 948 AND g1_.abilitato = 1 AND g1_.data >= '2026-06-10';

SELECT
  g0_.appuntamento AS appuntamento_0,
  g0_.messaggio AS messaggio_1,
  g1_.tipo AS tipo_2,
  g1_.data AS data_3,
  g1_.luogo AS luogo_4,
  g2_.nome AS nome_5,
  g2_.cognome AS cognome_6,
  g2_.sesso AS sesso_7,
  g2_.data_nascita AS data_nascita_8,
  g3_.anno AS anno_9,
  g3_.sezione AS sezione_10,
  g3_.gruppo AS gruppo_11
FROM
  gs_richiesta_colloquio g0_
  INNER JOIN gs_utente g2_ ON g0_.alunno_id = g2_.id
  AND g2_.ruolo IN ('ALU')
  INNER JOIN gs_classe g3_ ON g2_.classe_id = g3_.id
  INNER JOIN gs_colloquio g1_ ON g0_.colloquio_id = g1_.id
WHERE
  g0_.stato = ?
  AND g1_.docente_id = ?
  AND g1_.abilitato = ?
  AND g1_.data BETWEEN ?
  AND ?
ORDER BY
  g1_.data ASC,
  g0_.appuntamento ASC

SELECT g0_.appuntamento AS appuntamento_0, g0_.messaggio AS messaggio_1, g1_.tipo AS tipo_2, g1_.data AS data_3, g1_.luogo AS luogo_4, g2_.nome AS nome_5, g2_.cognome AS cognome_6, g2_.sesso AS sesso_7, g2_.data_nascita AS data_nascita_8, g3_.anno AS anno_9, g3_.sezione AS sezione_10, g3_.gruppo AS gruppo_11 FROM gs_richiesta_colloquio g0_ INNER JOIN gs_utente g2_ ON g0_.alunno_id = g2_.id AND g2_.ruolo IN ('ALU') INNER JOIN gs_classe g3_ ON g2_.classe_id = g3_.id INNER JOIN gs_colloquio g1_ ON g0_.colloquio_id = g1_.id WHERE g0_.stato = 'C' AND g1_.docente_id = 948 AND g1_.abilitato = 1 AND g1_.data BETWEEN '2026-06-10' AND '2026-06-13' ORDER BY g1_.data ASC, g0_.appuntamento ASC;

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione g0_
  INNER JOIN gs_comunicazione_utente g1_ ON (g1_.comunicazione_id = g0_.id)
WHERE
  (
    g1_.utente_id = ?
    AND g1_.letto IS NULL
  )
  AND g0_.categoria IN ('A')

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione g0_ INNER JOIN gs_comunicazione_utente g1_ ON (g1_.comunicazione_id = g0_.id) WHERE (g1_.utente_id = 948 AND g1_.letto IS NULL) AND g0_.categoria IN ('A');

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione_utente g0_
  INNER JOIN gs_comunicazione g1_ ON (
    g0_.comunicazione_id = g1_.id
    AND g0_.utente_id = ?
  )
  AND g1_.categoria IN ('C')
WHERE
  g0_.letto IS NULL
  AND g1_.stato = 'P'

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione_utente g0_ INNER JOIN gs_comunicazione g1_ ON (g0_.comunicazione_id = g1_.id AND g0_.utente_id = 948) AND g1_.categoria IN ('C') WHERE g0_.letto IS NULL AND g1_.stato = 'P';

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione g0_
WHERE
  (
    g0_.tipo = ?
    AND g0_.autore_id = ?
    AND g0_.data = ?
  )
  AND g0_.categoria IN ('A')

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione g0_ WHERE (g0_.tipo = 'V' AND g0_.autore_id = 948 AND g0_.data = '2026-06-10') AND g0_.categoria IN ('A');

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione g0_
  INNER JOIN gs_cattedra g1_ ON g0_.cattedra_id = g1_.id
  INNER JOIN gs_comunicazione_utente g2_ ON (g2_.comunicazione_id = g0_.id)
  INNER JOIN gs_cattedra g3_ ON (
    g3_.classe_id = g1_.classe_id
    AND g3_.docente_id = ?
    AND g3_.alunno_id = g2_.utente_id
  )
WHERE
  (
    g0_.autore_id <> ?
    AND g0_.tipo = ?
    AND g0_.data = ?
    AND g3_.attiva = ?
  )
  AND g0_.categoria IN ('A')

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione g0_ INNER JOIN gs_cattedra g1_ ON g0_.cattedra_id = g1_.id INNER JOIN gs_comunicazione_utente g2_ ON (g2_.comunicazione_id = g0_.id) INNER JOIN gs_cattedra g3_ ON (g3_.classe_id = g1_.classe_id AND g3_.docente_id = 948 AND g3_.alunno_id = g2_.utente_id) WHERE (g0_.autore_id <> 948 AND g0_.tipo = 'V' AND g0_.data = '2026-06-10' AND g3_.attiva = 1) AND g0_.categoria IN ('A');

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione g0_
WHERE
  (
    g0_.tipo = ?
    AND g0_.autore_id = ?
    AND g0_.data BETWEEN ?
    AND ?
  )
  AND g0_.categoria IN ('A')

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione g0_ WHERE (g0_.tipo = 'V' AND g0_.autore_id = 948 AND g0_.data BETWEEN '2026-06-11' AND '2026-06-13') AND g0_.categoria IN ('A');

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione g0_
  INNER JOIN gs_cattedra g1_ ON g0_.cattedra_id = g1_.id
  INNER JOIN gs_comunicazione_utente g2_ ON (g2_.comunicazione_id = g0_.id)
  INNER JOIN gs_cattedra g3_ ON (
    g3_.classe_id = g1_.classe_id
    AND g3_.docente_id = ?
    AND g3_.alunno_id = g2_.utente_id
  )
WHERE
  (
    g0_.autore_id <> ?
    AND g0_.tipo = ?
    AND g0_.data BETWEEN ?
    AND ?
    AND g3_.attiva = ?
  )
  AND g0_.categoria IN ('A')

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione g0_ INNER JOIN gs_cattedra g1_ ON g0_.cattedra_id = g1_.id INNER JOIN gs_comunicazione_utente g2_ ON (g2_.comunicazione_id = g0_.id) INNER JOIN gs_cattedra g3_ ON (g3_.classe_id = g1_.classe_id AND g3_.docente_id = 948 AND g3_.alunno_id = g2_.utente_id) WHERE (g0_.autore_id <> 948 AND g0_.tipo = 'V' AND g0_.data BETWEEN '2026-06-11' AND '2026-06-13' AND g3_.attiva = 1) AND g0_.categoria IN ('A');

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione g0_
WHERE
  (
    g0_.tipo = ?
    AND g0_.autore_id = ?
    AND g0_.data = ?
  )
  AND g0_.categoria IN ('A')

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione g0_ WHERE (g0_.tipo = 'P' AND g0_.autore_id = 948 AND g0_.data = '2026-06-10') AND g0_.categoria IN ('A');

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione g0_
  INNER JOIN gs_cattedra g1_ ON g0_.cattedra_id = g1_.id
  INNER JOIN gs_comunicazione_utente g2_ ON (g2_.comunicazione_id = g0_.id)
  INNER JOIN gs_cattedra g3_ ON (
    g3_.classe_id = g1_.classe_id
    AND g3_.docente_id = ?
    AND g3_.alunno_id = g2_.utente_id
  )
WHERE
  (
    g0_.autore_id <> ?
    AND g0_.tipo = ?
    AND g0_.data = ?
    AND g3_.attiva = ?
  )
  AND g0_.categoria IN ('A')

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione g0_ INNER JOIN gs_cattedra g1_ ON g0_.cattedra_id = g1_.id INNER JOIN gs_comunicazione_utente g2_ ON (g2_.comunicazione_id = g0_.id) INNER JOIN gs_cattedra g3_ ON (g3_.classe_id = g1_.classe_id AND g3_.docente_id = 948 AND g3_.alunno_id = g2_.utente_id) WHERE (g0_.autore_id <> 948 AND g0_.tipo = 'P' AND g0_.data = '2026-06-10' AND g3_.attiva = 1) AND g0_.categoria IN ('A');

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione g0_
WHERE
  (
    g0_.tipo = ?
    AND g0_.autore_id = ?
    AND g0_.data = ?
  )
  AND g0_.categoria IN ('A')

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione g0_ WHERE (g0_.tipo = 'P' AND g0_.autore_id = 948 AND g0_.data = '2026-06-11') AND g0_.categoria IN ('A');

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  gs_comunicazione g0_
  INNER JOIN gs_cattedra g1_ ON g0_.cattedra_id = g1_.id
  INNER JOIN gs_comunicazione_utente g2_ ON (g2_.comunicazione_id = g0_.id)
  INNER JOIN gs_cattedra g3_ ON (
    g3_.classe_id = g1_.classe_id
    AND g3_.docente_id = ?
    AND g3_.alunno_id = g2_.utente_id
  )
WHERE
  (
    g0_.autore_id <> ?
    AND g0_.tipo = ?
    AND g0_.data = ?
    AND g3_.attiva = ?
  )
  AND g0_.categoria IN ('A')

SELECT COUNT(g0_.id) AS sclr_0 FROM gs_comunicazione g0_ INNER JOIN gs_cattedra g1_ ON g0_.cattedra_id = g1_.id INNER JOIN gs_comunicazione_utente g2_ ON (g2_.comunicazione_id = g0_.id) INNER JOIN gs_cattedra g3_ ON (g3_.classe_id = g1_.classe_id AND g3_.docente_id = 948 AND g3_.alunno_id = g2_.utente_id) WHERE (g0_.autore_id <> 948 AND g0_.tipo = 'P' AND g0_.data = '2026-06-11' AND g3_.attiva = 1) AND g0_.categoria IN ('A');