Symfony Profiler

Query Metrics

107 Database Queries

8 Different statements

54.25 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

30.30 ms
(55.85%)

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.classi AS classi_7 FROM gs_modulo_formativo t0 WHERE t0.id = ?

Parameters:

[
  0
]

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.nome AS nome_4,
  t0.nome_breve AS nome_breve_5,
  t0.tipo AS tipo_6,
  t0.classi AS classi_7
FROM
  gs_modulo_formativo t0
WHERE
  t0.id = ?

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.classi AS classi_7 FROM gs_modulo_formativo t0 WHERE t0.id = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 2103)
7	App\Util\RegistroUtil->argomenti (line 165)
8	App\Controller\LezioniController->argomenti (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 47)

14.06 ms
(25.91%)

SELECT g0_.id AS id_0, g0_.data AS data_1, g0_.ora AS ora_2, g0_.argomento AS argomento_3, g0_.attivita AS attivita_4, (g0_.modulo_formativo_id) AS sclr_5, g1_.id AS id_6, g2_.durata AS durata_7 FROM gs_lezione g0_ INNER JOIN gs_classe g3_ ON g0_.classe_id = g3_.id LEFT JOIN gs_firma g4_ ON (g0_.id = g4_.lezione_id AND g4_.docente_id = ?) AND g4_.tipo IN ('N', 'S') LEFT JOIN gs_utente g1_ ON g4_.docente_id = g1_.id AND g1_.ruolo IN ('DOC', 'STA', 'PRE') INNER JOIN gs_scansione_oraria g2_ ON (g0_.ora = g2_.ora AND (WEEKDAY(g0_.data) + 1) = g2_.giorno) INNER JOIN gs_orario g5_ ON g2_.orario_id = g5_.id WHERE g0_.materia_id = ? AND g0_.data BETWEEN g5_.inizio AND g5_.fine AND (g3_.orario_id = g5_.id OR (g3_.orario_id IS NULL AND g5_.sede_id = g3_.sede_id)) AND g3_.anno = ? AND g3_.sezione = ? AND (g3_.id = ?) ORDER BY g0_.data DESC, g0_.ora ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.data AS data_1,
  g0_.ora AS ora_2,
  g0_.argomento AS argomento_3,
  g0_.attivita AS attivita_4,
  (g0_.modulo_formativo_id) AS sclr_5,
  g1_.id AS id_6,
  g2_.durata AS durata_7
FROM
  gs_lezione g0_
  INNER JOIN gs_classe g3_ ON g0_.classe_id = g3_.id
  LEFT JOIN gs_firma g4_ ON (
    g0_.id = g4_.lezione_id
    AND g4_.docente_id = ?
  )
  AND g4_.tipo IN ('N', 'S')
  LEFT JOIN gs_utente g1_ ON g4_.docente_id = g1_.id
  AND g1_.ruolo IN ('DOC', 'STA', 'PRE')
  INNER JOIN gs_scansione_oraria g2_ ON (
    g0_.ora = g2_.ora
    AND (
      WEEKDAY(g0_.data) + 1
    ) = g2_.giorno
  )
  INNER JOIN gs_orario g5_ ON g2_.orario_id = g5_.id
WHERE
  g0_.materia_id = ?
  AND g0_.data BETWEEN g5_.inizio
  AND g5_.fine
  AND (
    g3_.orario_id = g5_.id
    OR (
      g3_.orario_id IS NULL
      AND g5_.sede_id = g3_.sede_id
    )
  )
  AND g3_.anno = ?
  AND g3_.sezione = ?
  AND (g3_.id = ?)
ORDER BY
  g0_.data DESC,
  g0_.ora ASC

SELECT g0_.id AS id_0, g0_.data AS data_1, g0_.ora AS ora_2, g0_.argomento AS argomento_3, g0_.attivita AS attivita_4, (g0_.modulo_formativo_id) AS sclr_5, g1_.id AS id_6, g2_.durata AS durata_7 FROM gs_lezione g0_ INNER JOIN gs_classe g3_ ON g0_.classe_id = g3_.id LEFT JOIN gs_firma g4_ ON (g0_.id = g4_.lezione_id AND g4_.docente_id = 59) AND g4_.tipo IN ('N', 'S') LEFT JOIN gs_utente g1_ ON g4_.docente_id = g1_.id AND g1_.ruolo IN ('DOC', 'STA', 'PRE') INNER JOIN gs_scansione_oraria g2_ ON (g0_.ora = g2_.ora AND (WEEKDAY(g0_.data) + 1) = g2_.giorno) INNER JOIN gs_orario g5_ ON g2_.orario_id = g5_.id WHERE g0_.materia_id = 24 AND g0_.data BETWEEN g5_.inizio AND g5_.fine AND (g3_.orario_id = g5_.id OR (g3_.orario_id IS NULL AND g5_.sede_id = g3_.sede_id)) AND g3_.anno = 1 AND g3_.sezione = 'A' AND (g3_.id = 5) ORDER BY g0_.data DESC, g0_.ora ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 2048)
7	App\Util\RegistroUtil->argomenti (line 165)
8	App\Controller\LezioniController->argomenti (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 47)

4.52 ms
(8.33%)

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:

[
  24
]

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.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 = ?

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\Materia::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Materia->__get (line 205)
8	App\Entity\Materia->getTipo (line 143)
9	App\Controller\LezioniController->argomenti (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 47)

1.82 ms
(3.36%)

SELECT g0_.nome AS nome_0, g0_.cognome AS cognome_1 FROM gs_firma g1_ INNER JOIN gs_utente g0_ ON g1_.docente_id = g0_.id AND g0_.ruolo IN ('DOC', 'STA', 'PRE') WHERE (g1_.lezione_id = ? AND g1_.docente_id <> ? AND g1_.tipo NOT IN ('S')) AND g1_.tipo IN ('N', 'S') ORDER BY g0_.cognome ASC, g0_.nome ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.nome AS nome_0,
  g0_.cognome AS cognome_1
FROM
  gs_firma g1_
  INNER JOIN gs_utente g0_ ON g1_.docente_id = g0_.id
  AND g0_.ruolo IN ('DOC', 'STA', 'PRE')
WHERE
  (
    g1_.lezione_id = ?
    AND g1_.docente_id <> ?
    AND g1_.tipo NOT IN ('S')
  )
  AND g1_.tipo IN ('N', 'S')
ORDER BY
  g0_.cognome ASC,
  g0_.nome ASC

SELECT g0_.nome AS nome_0, g0_.cognome AS cognome_1 FROM gs_firma g1_ INNER JOIN gs_utente g0_ ON g1_.docente_id = g0_.id AND g0_.ruolo IN ('DOC', 'STA', 'PRE') WHERE (g1_.lezione_id = 9514 AND g1_.docente_id <> 59 AND g1_.tipo NOT IN ('S')) AND g1_.tipo IN ('N', 'S') ORDER BY g0_.cognome ASC, g0_.nome ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 2065)
7	App\Util\RegistroUtil->argomenti (line 165)
8	App\Controller\LezioniController->argomenti (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 47)

1.29 ms
(2.39%)

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:

[
  59
]

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 214)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 54)
13	App\Util\LogProcessor->processRecord (line 378)
14	Monolog\Logger->addRecord (line 594)
15	Monolog\Logger->debug (line 304)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->postProcess (line 150)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 47)

1.08 ms
(1.99%)

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:

[
  5
]

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.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 = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\Classe::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Classe->__get (line 192)
8	App\Entity\Classe->getAnno (line 2018)
9	App\Util\RegistroUtil->argomenti (line 165)
10	App\Controller\LezioniController->argomenti (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 47)

0.60 ms
(1.10%)

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:

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.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

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 = 317 AND t0.docente_id = 59 AND t0.attiva = 1 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 135)
4	App\Controller\LezioniController->argomenti (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 47)

0.58 ms
(1.07%)

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:

[
  16
]

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 784)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2530)
4	Doctrine\ORM\UnitOfWork->createEntity (line 176)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 60)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 171)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 748)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
10	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
11	Proxies\__CG__\App\Entity\Classe::Doctrine\ORM\Proxy\{closure} (line 100)
12	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
13	Proxies\__CG__\App\Entity\Classe->__get (line 192)
14	App\Entity\Classe->getAnno (line 2018)
15	App\Util\RegistroUtil->argomenti (line 165)
16	App\Controller\LezioniController->argomenti (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 47)

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\Lezione	No errors.
App\Entity\Firma	No errors.
App\Entity\ScansioneOraria	No errors.
App\Entity\FirmaSostegno	No errors.
App\Entity\ModuloFormativo	No errors.

Symfony Profiler

GET https://reg.salerno.istitutokennedy.net/lezioni/argomenti

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping