Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.62 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.06 ms
(65.04%)

SELECT c0_.id AS id_0, c0_.titolo AS titolo_1, c0_.nome AS nome_2, c0_.tipo AS tipo_3, c0_.gruppo AS gruppo_4, c0_.predefinito AS predefinito_5, c0_.valore AS valore_6, c0_.obbligatorio AS obbligatorio_7, c0_.descrizione AS descrizione_8, c0_.ordine AS ordine_9, c0_.data_eliminazione AS data_eliminazione_10, c0_.eliminato_da_id AS eliminato_da_id_11 FROM configurazione c0_ WHERE (c0_.nome = ?) AND (c0_.data_eliminazione IS NULL)

Parameters:

[
  "white_black_list"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.titolo AS titolo_1,
  c0_.nome AS nome_2,
  c0_.tipo AS tipo_3,
  c0_.gruppo AS gruppo_4,
  c0_.predefinito AS predefinito_5,
  c0_.valore AS valore_6,
  c0_.obbligatorio AS obbligatorio_7,
  c0_.descrizione AS descrizione_8,
  c0_.ordine AS ordine_9,
  c0_.data_eliminazione AS data_eliminazione_10,
  c0_.eliminato_da_id AS eliminato_da_id_11
FROM
  configurazione c0_
WHERE
  (c0_.nome = ?)
  AND (c0_.data_eliminazione IS NULL)

SELECT c0_.id AS id_0, c0_.titolo AS titolo_1, c0_.nome AS nome_2, c0_.tipo AS tipo_3, c0_.gruppo AS gruppo_4, c0_.predefinito AS predefinito_5, c0_.valore AS valore_6, c0_.obbligatorio AS obbligatorio_7, c0_.descrizione AS descrizione_8, c0_.ordine AS ordine_9, c0_.data_eliminazione AS data_eliminazione_10, c0_.eliminato_da_id AS eliminato_da_id_11 FROM configurazione c0_ WHERE (c0_.nome = 'white_black_list') AND (c0_.data_eliminazione IS NULL);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 29)
7	App\Repository\ConfigurazioneRepository->findByName (line 34)
8	App\EventListener\IpCheck->onKernelRequest (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.57 ms
(34.96%)

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.data_eliminazione AS data_eliminazione_3, t0.eliminato_da_id AS eliminato_da_id_4 FROM white_black_list t0 WHERE ((t0.data_eliminazione IS NULL))

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.data_eliminazione AS data_eliminazione_3,
  t0.eliminato_da_id AS eliminato_da_id_4
FROM
  white_black_list t0
WHERE
  (
    (t0.data_eliminazione IS NULL)
  )

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.data_eliminazione AS data_eliminazione_3, t0.eliminato_da_id AS eliminato_da_id_4 FROM white_black_list t0 WHERE ((t0.data_eliminazione IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 35)
5	App\EventListener\IpCheck->onKernelRequest (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 20)

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.

Entities Mapping

Class	Mapping errors
App\Entity\Configurazione	No errors.
App\Entity\Utente	No errors.
App\Entity\WhiteBlackList	No errors.

Symfony Profiler

GET https://apitest.ichron.cloud/_profiler

Configuration Settings

Theme