Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.64 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.83 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:

[
  "216.73.216.206"
]

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 = '216.73.216.206' 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.80 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:

[
  "216.73.216.206"
]

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

#	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

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