Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

9 Database Queries

7 Different statements

4.73 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.50 ms
(52.83%)

SELECT r0_.id AS id_0, r0_.created_stamp AS created_stamp_1, r0_.ip_address AS ip_address_2, r0_.as_number AS as_number_3, r0_.as_country AS as_country_4, r0_.as_description AS as_description_5, r0_.vpn AS vpn_6, r0_.consumer AS consumer_7, r0_.caller_id AS caller_id_8, r0_.config_id AS config_id_9 FROM request r0_ WHERE r0_.ip_address = ? AND r0_.config_id IS NOT NULL ORDER BY r0_.created_stamp DESC LIMIT 1

Parameters:

[
  "2607:fb90:cb2e:4376:9166:7641:bddb:3927"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.created_stamp AS created_stamp_1,
  r0_.ip_address AS ip_address_2,
  r0_.as_number AS as_number_3,
  r0_.as_country AS as_country_4,
  r0_.as_description AS as_description_5,
  r0_.vpn AS vpn_6,
  r0_.consumer AS consumer_7,
  r0_.caller_id AS caller_id_8,
  r0_.config_id AS config_id_9
FROM
  request r0_
WHERE
  r0_.ip_address = ?
  AND r0_.config_id IS NOT NULL
ORDER BY
  r0_.created_stamp DESC
LIMIT
  1

SELECT r0_.id AS id_0, r0_.created_stamp AS created_stamp_1, r0_.ip_address AS ip_address_2, r0_.as_number AS as_number_3, r0_.as_country AS as_country_4, r0_.as_description AS as_description_5, r0_.vpn AS vpn_6, r0_.consumer AS consumer_7, r0_.caller_id AS caller_id_8, r0_.config_id AS config_id_9 FROM request r0_ WHERE r0_.ip_address = '2607:fb90:cb2e:4376:9166:7641:bddb:3927' AND r0_.config_id IS NOT NULL ORDER BY r0_.created_stamp DESC LIMIT 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\Service\IpAddress->getInfo (line 41)
7	App\Controller\ApiController->ipGetInfo (line 62)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.79 ms
(16.76%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Security\LoginSuccessEventSubscriber->updateUserLoginData (line 51)
4	App\Security\LoginSuccessEventSubscriber->onLoginSuccess (line 39)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 241)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 221)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
13	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
14	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
16	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 83)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.33 ms
(6.90%)

SELECT c0_.id AS id_0, c0_.as_number AS as_number_1, c0_.as_desc_regexp AS as_desc_regexp_2, c0_.ip_range AS ip_range_3, c0_.vpn AS vpn_4, c0_.consumer AS consumer_5, c0_.note AS note_6, c0_.created_stamp AS created_stamp_7, c0_.created_by_id AS created_by_id_8 FROM config c0_ WHERE c0_.as_number = ? ORDER BY c0_.created_stamp DESC LIMIT 1

Parameters:

[
  21928
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.as_number AS as_number_1,
  c0_.as_desc_regexp AS as_desc_regexp_2,
  c0_.ip_range AS ip_range_3,
  c0_.vpn AS vpn_4,
  c0_.consumer AS consumer_5,
  c0_.note AS note_6,
  c0_.created_stamp AS created_stamp_7,
  c0_.created_by_id AS created_by_id_8
FROM
  config c0_
WHERE
  c0_.as_number = ?
ORDER BY
  c0_.created_stamp DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.as_number AS as_number_1, c0_.as_desc_regexp AS as_desc_regexp_2, c0_.ip_range AS ip_range_3, c0_.vpn AS vpn_4, c0_.consumer AS consumer_5, c0_.note AS note_6, c0_.created_stamp AS created_stamp_7, c0_.created_by_id AS created_by_id_8 FROM config c0_ WHERE c0_.as_number = 21928 ORDER BY c0_.created_stamp DESC LIMIT 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\Service\IpAddress->matchConfig (line 126)
7	App\Service\IpAddress->getInfo (line 75)
8	App\Controller\ApiController->ipGetInfo (line 62)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.31 ms
(6.60%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Security\LoginSuccessEventSubscriber->updateUserLoginData (line 51)
4	App\Security\LoginSuccessEventSubscriber->onLoginSuccess (line 39)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 241)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 221)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
13	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
14	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
16	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 83)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 197)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.29 ms
(6.05%)

SELECT t0.id AS id_1, t0.uname AS uname_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_stamp AS created_stamp_6, t0.deleted_stamp AS deleted_stamp_7, t0.lastlogin_stamp AS lastlogin_stamp_8, t0.lastlogin_agent AS lastlogin_agent_9 FROM `user` t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "as@iplocator.yeebill.net"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uname AS uname_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.created_stamp AS created_stamp_6,
  t0.deleted_stamp AS deleted_stamp_7,
  t0.lastlogin_stamp AS lastlogin_stamp_8,
  t0.lastlogin_agent AS lastlogin_agent_9
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uname AS uname_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_stamp AS created_stamp_6, t0.deleted_stamp AS deleted_stamp_7, t0.lastlogin_stamp AS lastlogin_stamp_8, t0.lastlogin_agent AS lastlogin_agent_9 FROM `user` t0 WHERE t0.email = 'as@iplocator.yeebill.net' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 87)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 42)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 180)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
18	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 83)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 197)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.26 ms
(5.52%)

UPDATE `user` SET lastlogin_stamp = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `user`
SET
  lastlogin_stamp = ?
WHERE
  id = ?

UPDATE `user` SET lastlogin_stamp = 1780004011 WHERE id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Security\LoginSuccessEventSubscriber->updateUserLoginData (line 51)
7	App\Security\LoginSuccessEventSubscriber->onLoginSuccess (line 39)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 241)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 221)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
19	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 83)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 197)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

0.25 ms
(5.33%)

INSERT INTO request (created_stamp, ip_address, as_number, as_country, as_description, vpn, consumer, caller_id, config_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  1780004011
  "2607:fb90:cb2e:4376:9166:7641:bddb:3927"
  21928
  "US"
  "T-MOBILE-AS21928"
  0
  1
  2
  96
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO request (
  created_stamp, ip_address, as_number,
  as_country, as_description, vpn,
  consumer, caller_id, config_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO request (created_stamp, ip_address, as_number, as_country, as_description, vpn, consumer, caller_id, config_id) VALUES (1780004011, '2607:fb90:cb2e:4376:9166:7641:bddb:3927', 21928, 'US', 'T-MOBILE-AS21928', 0, 1, 2, 96);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\IpAddress->getInfo (line 79)
7	App\Controller\ApiController->ipGetInfo (line 62)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
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\User	2
App\Entity\Config	1
App\Entity\Request	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Request	No errors.
App\Entity\Config	No errors.

Symfony Profiler

POST https://iplocator.yeebill.net/api/ip/get-info

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping