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.username = ?
  AND t0.abilitato = ?
  AND t0.ruolo IN (
    'UTE', 'AMM', 'ATA', 'DOC', 'STA', 'PRE',
    'ALU', 'GEN'
  )
LIMIT
  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.username = 'sofia.letizia' AND t0.abilitato = 1 AND t0.ruolo IN ('UTE', 'AMM', 'ATA', 'DOC', 'STA', 'PRE', 'ALU', 'GEN') LIMIT 1;

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 = 'manutenzione_inizio';

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 = 'manutenzione_fine';

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 = 'id_provider';

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 = 'id_provider_tipo';

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 = 'otp_tipo';

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 = 'otp_tipo';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO gs_log (
  creato, username, ruolo, alias, ip,
  origine, tipo, categoria, azione,
  classe_entita, id_entita, dati, utente_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO gs_log (creato, username, ruolo, alias, ip, origine, tipo, categoria, azione, classe_entita, id_entita, dati, utente_id) VALUES ('2026-06-10 10:54:50', 'sofia.letizia', 'ROLE_DOCENTE', NULL, '188.12.125.141', 'App\\Controller\\LoginController::form', 'A', 'ACCESSO', 'Login', NULL, NULL, '{\"Login\":\"form\",\"Username\":\"sofia.letizia\",\"Ruolo\":\"ROLE_DOCENTE\",\"Lista profili\":[]}', 948);

UPDATE
  gs_utente
SET
  ultimo_accesso = ?,
  modificato = ?
WHERE
  id = ?

UPDATE gs_utente SET ultimo_accesso = '2026-06-10 10:54:50', modificato = '2026-06-10 10:54:50' WHERE id = 948;

"COMMIT"

"COMMIT";

SELECT
  g0_.categoria AS categoria_0,
  g0_.parametro AS parametro_1,
  g0_.valore AS valore_2
FROM
  gs_configurazione g0_

SELECT g0_.categoria AS categoria_0, g0_.parametro AS parametro_1, g0_.valore AS valore_2 FROM gs_configurazione g0_;

SELECT
  t0.id AS id_1,
  t0.creato AS creato_2,
  t0.modificato AS modificato_3,
  t0.tipo AS tipo_4,
  t0.tipo_sigla AS tipo_sigla_5,
  t0.nome AS nome_6,
  t0.nome_breve AS nome_breve_7,
  t0.email AS email_8,
  t0.pec AS pec_9,
  t0.url_sito AS url_sito_10,
  t0.url_registro AS url_registro_11,
  t0.firma_preside AS firma_preside_12,
  t0.email_amministratore AS email_amministratore_13,
  t0.email_notifiche AS email_notifiche_14
FROM
  gs_istituto t0

SELECT t0.id AS id_1, t0.creato AS creato_2, t0.modificato AS modificato_3, t0.tipo AS tipo_4, t0.tipo_sigla AS tipo_sigla_5, t0.nome AS nome_6, t0.nome_breve AS nome_breve_7, t0.email AS email_8, t0.pec AS pec_9, t0.url_sito AS url_sito_10, t0.url_registro AS url_registro_11, t0.firma_preside AS firma_preside_12, t0.email_amministratore AS email_amministratore_13, t0.email_notifiche AS email_notifiche_14 FROM gs_istituto t0;

SELECT
  g0_.nome AS nome_0,
  g0_.nome_breve AS nome_breve_1,
  g0_.citta AS citta_2,
  g0_.indirizzo1 AS indirizzo1_3,
  g0_.indirizzo2 AS indirizzo2_4,
  g0_.telefono AS telefono_5
FROM
  gs_sede g0_
ORDER BY
  g0_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.nome_breve AS nome_breve_1, g0_.citta AS citta_2, g0_.indirizzo1 AS indirizzo1_3, g0_.indirizzo2 AS indirizzo2_4, g0_.telefono AS telefono_5 FROM gs_sede g0_ ORDER BY g0_.ordinamento ASC;

SELECT
  g0_.selettore AS selettore_0,
  g0_.nome AS nome_1,
  g0_.descrizione AS descrizione_2
FROM
  gs_menu g0_

SELECT g0_.selettore AS selettore_0, g0_.nome AS nome_1, g0_.descrizione AS descrizione_2 FROM gs_menu g0_;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'help' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'user' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'info' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'main' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;

SELECT
  g0_.nome AS nome_0,
  g0_.descrizione AS descrizione_1,
  g0_.mega AS mega_2,
  g1_.nome AS nome_3,
  g1_.descrizione AS descrizione_4,
  g1_.url AS url_5,
  g1_.abilitato AS abilitato_6,
  g1_.icona AS icona_7,
  (g1_.sotto_menu_id) AS sclr_8
FROM
  gs_menu g0_
  INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id)
WHERE
  g0_.selettore = ?
  AND INSTR(g1_.ruolo, ?) > 0
ORDER BY
  g1_.ordinamento ASC

SELECT g0_.nome AS nome_0, g0_.descrizione AS descrizione_1, g0_.mega AS mega_2, g1_.nome AS nome_3, g1_.descrizione AS descrizione_4, g1_.url AS url_5, g1_.abilitato AS abilitato_6, g1_.icona AS icona_7, (g1_.sotto_menu_id) AS sclr_8 FROM gs_menu g0_ INNER JOIN gs_menu_opzione g1_ ON (g1_.menu_id = g0_.id) WHERE g0_.selettore = 'sistema' AND INSTR(g1_.ruolo, 'D') > 0 ORDER BY g1_.ordinamento ASC;