Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.30 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.30 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.ruolo, t0.tipo AS tipo_30, t0.segreteria AS segreteria_31, t0.sede_id AS sede_id_32, t0.responsabile_bes AS responsabile_bes_33, t0.rspp AS rspp_34, t0.responsabile_bes_sede_id AS responsabile_bes_sede_id_35, t0.sede_id AS sede_id_36, t0.bes AS bes_37, t0.note_bes AS note_bes_38, t0.autorizza_entrata AS autorizza_entrata_39, t0.autorizza_uscita AS autorizza_uscita_40, t0.note AS note_41, t0.frequenza_estero AS frequenza_estero_42, t0.religione AS religione_43, t0.credito3 AS credito3_44, t0.credito4 AS credito4_45, t0.giustifica_online AS giustifica_online_46, t0.richiesta_certificato AS richiesta_certificato_47, t0.foto AS foto_48, t0.classe_id AS classe_id_49, t0.giustifica_online AS giustifica_online_50, t0.alunno_id AS alunno_id_51 FROM gs_utente t0 WHERE t0.username = ? AND t0.abilitato = ? AND t0.ruolo IN ('UTE', 'AMM', 'ATA', 'DOC', 'STA', 'PRE', 'ALU', 'GEN') LIMIT 1

Parameters:

[
  "raffaele.savarise@giua.edu.it"
  1
]

View formatted query View runnable query Explain query View query backtrace

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.ruolo,
  t0.tipo AS tipo_30,
  t0.segreteria AS segreteria_31,
  t0.sede_id AS sede_id_32,
  t0.responsabile_bes AS responsabile_bes_33,
  t0.rspp AS rspp_34,
  t0.responsabile_bes_sede_id AS responsabile_bes_sede_id_35,
  t0.sede_id AS sede_id_36,
  t0.bes AS bes_37,
  t0.note_bes AS note_bes_38,
  t0.autorizza_entrata AS autorizza_entrata_39,
  t0.autorizza_uscita AS autorizza_uscita_40,
  t0.note AS note_41,
  t0.frequenza_estero AS frequenza_estero_42,
  t0.religione AS religione_43,
  t0.credito3 AS credito3_44,
  t0.credito4 AS credito4_45,
  t0.giustifica_online AS giustifica_online_46,
  t0.richiesta_certificato AS richiesta_certificato_47,
  t0.foto AS foto_48,
  t0.classe_id AS classe_id_49,
  t0.giustifica_online AS giustifica_online_50,
  t0.alunno_id AS alunno_id_51
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.ruolo, t0.tipo AS tipo_30, t0.segreteria AS segreteria_31, t0.sede_id AS sede_id_32, t0.responsabile_bes AS responsabile_bes_33, t0.rspp AS rspp_34, t0.responsabile_bes_sede_id AS responsabile_bes_sede_id_35, t0.sede_id AS sede_id_36, t0.bes AS bes_37, t0.note_bes AS note_bes_38, t0.autorizza_entrata AS autorizza_entrata_39, t0.autorizza_uscita AS autorizza_uscita_40, t0.note AS note_41, t0.frequenza_estero AS frequenza_estero_42, t0.religione AS religione_43, t0.credito3 AS credito3_44, t0.credito4 AS credito4_45, t0.giustifica_online AS giustifica_online_46, t0.richiesta_certificato AS richiesta_certificato_47, t0.foto AS foto_48, t0.classe_id AS classe_id_49, t0.giustifica_online AS giustifica_online_50, t0.alunno_id AS alunno_id_51 FROM gs_utente t0 WHERE t0.username = 'raffaele.savarise@giua.edu.it' AND t0.abilitato = 1 AND t0.ruolo IN ('UTE', 'AMM', 'ATA', 'DOC', 'STA', 'PRE', 'ALU', 'GEN') LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 125)
4	App\Security\FormAuthenticator->getUser (line 87)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
18	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
19	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 11)

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

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.

Symfony Profiler

POST https://registro.kennedypontecagnano.gespar.it/login/form/

Configuration Settings

Theme

Page Width