Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.32 ms Query time

0 Invalid entities

0 Managed entities

#▲

Time

Info

2.32 ms

SELECT s0_.id AS id_0, s0_.ip AS ip_1, s0_.reproche AS reproche_2, s0_.date_crea AS date_crea_3 FROM secur_ipbann s0_ WHERE s0_.ip = ?

Parameters:

[
  "216.73.216.20"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.ip AS ip_1,
  s0_.reproche AS reproche_2,
  s0_.date_crea AS date_crea_3
FROM
  secur_ipbann s0_
WHERE
  s0_.ip = ?

SELECT s0_.id AS id_0, s0_.ip AS ip_1, s0_.reproche AS reproche_2, s0_.date_crea AS date_crea_3 FROM secur_ipbann s0_ WHERE s0_.ip = '216.73.216.20';

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 34)
7	App\Repository\SecurIpbannRepository->findIP (line 1320)
8	App\Controller\SecurityController->ifBanniUser (line 418)
9	App\Controller\SecurityController->secur_oubli (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Amount of managed objects

Class	Mapping errors
App\Entity\SecurIpbann	No errors.