Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.75 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.86 ms

SELECT t0.id AS id_1, t0.client_ip AS client_ip_2, t0.tipo_term AS tipo_term_3, t0.lotto_prod AS lotto_prod_4, t0.num_fase AS num_fase_5, t0.data_ora AS data_ora_6, t0.nome AS nome_7, t0.risorsa_id AS risorsa_id_8, t0.disp_stmp_etichette_id AS disp_stmp_etichette_id_9, t0.disp_stmp_laser_id AS disp_stmp_laser_id_10, t0.disp_bilancia_id AS disp_bilancia_id_11 FROM terminale t0 WHERE t0.client_ip = ? LIMIT 1

Parameters:

[
  "192.168.60.1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.client_ip AS client_ip_2,
  t0.tipo_term AS tipo_term_3,
  t0.lotto_prod AS lotto_prod_4,
  t0.num_fase AS num_fase_5,
  t0.data_ora AS data_ora_6,
  t0.nome AS nome_7,
  t0.risorsa_id AS risorsa_id_8,
  t0.disp_stmp_etichette_id AS disp_stmp_etichette_id_9,
  t0.disp_stmp_laser_id AS disp_stmp_laser_id_10,
  t0.disp_bilancia_id AS disp_bilancia_id_11
FROM
  terminale t0
WHERE
  t0.client_ip = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.client_ip AS client_ip_2, t0.tipo_term AS tipo_term_3, t0.lotto_prod AS lotto_prod_4, t0.num_fase AS num_fase_5, t0.data_ora AS data_ora_6, t0.nome AS nome_7, t0.risorsa_id AS risorsa_id_8, t0.disp_stmp_etichette_id AS disp_stmp_etichette_id_9, t0.disp_stmp_laser_id AS disp_stmp_laser_id_10, t0.disp_bilancia_id AS disp_bilancia_id_11 FROM terminale t0 WHERE t0.client_ip = '192.168.60.1' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 94)
4	App\EventSubscriber\TwigEventSubscriber->onKernelController (line 30)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 187)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
11	Symfony\Component\HttpKernel\Kernel->handle (line 155)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

0.89 ms

SELECT t0_.id AS id_0, t0_.client_ip AS client_ip_1, t0_.tipo_term AS tipo_term_2, t0_.lotto_prod AS lotto_prod_3, t0_.num_fase AS num_fase_4, t0_.data_ora AS data_ora_5, t0_.nome AS nome_6, t0_.risorsa_id AS risorsa_id_7, t0_.disp_stmp_etichette_id AS disp_stmp_etichette_id_8, t0_.disp_stmp_laser_id AS disp_stmp_laser_id_9, t0_.disp_bilancia_id AS disp_bilancia_id_10 FROM terminale t0_ WHERE t0_.client_ip = ?

Parameters:

[
  "192.168.60.1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.client_ip AS client_ip_1,
  t0_.tipo_term AS tipo_term_2,
  t0_.lotto_prod AS lotto_prod_3,
  t0_.num_fase AS num_fase_4,
  t0_.data_ora AS data_ora_5,
  t0_.nome AS nome_6,
  t0_.risorsa_id AS risorsa_id_7,
  t0_.disp_stmp_etichette_id AS disp_stmp_etichette_id_8,
  t0_.disp_stmp_laser_id AS disp_stmp_laser_id_9,
  t0_.disp_bilancia_id AS disp_bilancia_id_10
FROM
  terminale t0_
WHERE
  t0_.client_ip = ?

SELECT t0_.id AS id_0, t0_.client_ip AS client_ip_1, t0_.tipo_term AS tipo_term_2, t0_.lotto_prod AS lotto_prod_3, t0_.num_fase AS num_fase_4, t0_.data_ora AS data_ora_5, t0_.nome AS nome_6, t0_.risorsa_id AS risorsa_id_7, t0_.disp_stmp_etichette_id AS disp_stmp_etichette_id_8, t0_.disp_stmp_laser_id AS disp_stmp_laser_id_9, t0_.disp_bilancia_id AS disp_bilancia_id_10 FROM terminale t0_ WHERE t0_.client_ip = '192.168.60.1';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\TerminaleRepository->findOneByClientIP (line 40)
7	App\Controller\MainController->main_login (line 85)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
10	Symfony\Component\HttpKernel\Kernel->handle (line 155)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

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\Dispositivo	3
App\Entity\Terminale	1
App\Entity\Risorsa	1

Entities Mapping

Class	Mapping errors
App\Entity\Terminale	No errors.
App\Entity\Risorsa	No errors.
App\Entity\Dispositivo	No errors.

GET https://webprod.sistek.it/login

Configuration Settings

Theme

Page Width