Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.44 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.44 ms
(100.00%)

SELECT i0_.id AS id_0, i0_.ip_address AS ip_address_1, i0_.block_type AS block_type_2, i0_.reason AS reason_3, i0_.blocked_at AS blocked_at_4, i0_.expires_at AS expires_at_5, i0_.attempt_count AS attempt_count_6, i0_.is_active AS is_active_7, i0_.metadata AS metadata_8, i0_.unlocked_at AS unlocked_at_9, i0_.country AS country_10, i0_.city AS city_11, i0_.isp AS isp_12, i0_.blocked_by_id AS blocked_by_id_13, i0_.unlocked_by_id AS unlocked_by_id_14 FROM ip_blocks i0_ WHERE i0_.ip_address = ? AND i0_.is_active = ?

Parameters:

[
  "216.73.216.236"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.ip_address AS ip_address_1,
  i0_.block_type AS block_type_2,
  i0_.reason AS reason_3,
  i0_.blocked_at AS blocked_at_4,
  i0_.expires_at AS expires_at_5,
  i0_.attempt_count AS attempt_count_6,
  i0_.is_active AS is_active_7,
  i0_.metadata AS metadata_8,
  i0_.unlocked_at AS unlocked_at_9,
  i0_.country AS country_10,
  i0_.city AS city_11,
  i0_.isp AS isp_12,
  i0_.blocked_by_id AS blocked_by_id_13,
  i0_.unlocked_by_id AS unlocked_by_id_14
FROM
  ip_blocks i0_
WHERE
  i0_.ip_address = ?
  AND i0_.is_active = ?

SELECT i0_.id AS id_0, i0_.ip_address AS ip_address_1, i0_.block_type AS block_type_2, i0_.reason AS reason_3, i0_.blocked_at AS blocked_at_4, i0_.expires_at AS expires_at_5, i0_.attempt_count AS attempt_count_6, i0_.is_active AS is_active_7, i0_.metadata AS metadata_8, i0_.unlocked_at AS unlocked_at_9, i0_.country AS country_10, i0_.city AS city_11, i0_.isp AS isp_12, i0_.blocked_by_id AS blocked_by_id_13, i0_.unlocked_by_id AS unlocked_by_id_14 FROM ip_blocks i0_ WHERE i0_.ip_address = '216.73.216.236' AND i0_.is_active = 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\IpBlockRepository->findActiveBlockByIp (line 56)
7	App\Service\Security\IpBlockingService->getActiveBlock (line 524)
8	App\EventListener\IpBlockingRequestListener->onKernelRequest (line 55)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 197)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	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\IpBlock	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://shop.yimalabs.com/public/login

Configuration Settings

Theme

Page Width