Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

15.17 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.16 ms

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 381)
2	Doctrine\ORM\UnitOfWork->commit (line 268)
3	Doctrine\ORM\EntityManager->flush (line 111)
4	App\EventSubscriber\AuthenticationSubscriber->saveLogin (line 42)
5	App\EventSubscriber\AuthenticationSubscriber->onLoginFailure (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 262)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationFailure (line 210)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
17	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

13.58 ms

INSERT INTO user_login_history (user_id, network, identity, ip, user_agent, os, browser, device, date, error_msg, error_file, error_trace, status, viewed) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  null
  "unknown"
  null
  "83.111.71.238"
  "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.47 Safari/537.36"
  "MacOS"
  "Chrome 35"
  "desktop"
  "2026-07-05 21:47:13"
  "Invalid state"
  "/home/eclectis.eu/vendor/knpuniversity/oauth2-client-bundle/src/Security/Authenticator/OAuth2Authenticator.php::40"
  """
    #0 /home/eclectis.eu/src/Security/OAuth/YandexAuthenticator.php(80): KnpU\OAuth2ClientBundle\Security\Authenticator\OAuth2Authenticator->fetchAccessToken()\n
    #1 /home/eclectis.eu/vendor/symfony/security-http/Authenticator/Debug/TraceableAuthenticator.php(74): App\Security\OAuth\YandexAuthenticator->authenticate()\n
    #2 /home/eclectis.eu/vendor/symfony/security-http/Authentication/AuthenticatorManager.php(174): Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate()\n
    #3 /home/eclectis.eu/vendor/symfony/security-http/Authentication/AuthenticatorManager.php(156): Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator()\n
    #4 /home/eclectis.eu/vendor/symfony/security-http/Authentication/AuthenticatorManager.php(138): Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators()\n
    #5 /home/eclectis.eu/vendor/symfony/security-http/Firewall/AuthenticatorManagerListener.php(38): Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest()\n
    #6 /home/eclectis.eu/vendor/symfony/security-http/Authenticator/Debug/TraceableAuthenticatorManagerListener.php(58): Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate()\n
    #7 /home/eclectis.eu/vendor/symfony/security-bundle/Debug/WrappedLazyListener.php(46): Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate()\n
    #8 /home/eclectis.eu/vendor/symfony/security-bundle/Security/LazyFirewallContext.php(61): Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate()\n
    #9 /home/eclectis.eu/vendor/symfony/security-bundle/Debug/TraceableFirewallListener.php(91): Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke()\n
    #10 /home/eclectis.eu/vendor/symfony/security-http/Firewall.php(92): Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners()\n
    #11 /home/eclectis.eu/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(115): Symfony\Component\Security\Http\Firewall->onKernelRequest()\n
    #12 /home/eclectis.eu/vendor/symfony/event-dispatcher/EventDispatcher.php(206): Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()\n
    #13 /home/eclectis.eu/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()\n
    #14 /home/eclectis.eu/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(122): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()\n
    #15 /home/eclectis.eu/vendor/symfony/http-kernel/HttpKernel.php(159): Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()\n
    #16 /home/eclectis.eu/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()\n
    #17 /home/eclectis.eu/vendor/symfony/http-kernel/Kernel.php(182): Symfony\Component\HttpKernel\HttpKernel->handle()\n
    #18 /home/eclectis.eu/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()\n
    #19 /home/eclectis.eu/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()\n
    #20 /home/eclectis.eu/public/index.php(5): require_once('...')\n
    #21 {main}
    """
  0
  0
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO user_login_history (
  user_id, network, identity, ip, user_agent,
  os, browser, device, date, error_msg,
  error_file, error_trace, status,
  viewed
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO user_login_history (user_id, network, identity, ip, user_agent, os, browser, device, date, error_msg, error_file, error_trace, status, viewed) VALUES (NULL, 'unknown', NULL, '83.111.71.238', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.47 Safari/537.36', 'MacOS', 'Chrome 35', 'desktop', '2026-07-05 21:47:13', 'Invalid state', '/home/eclectis.eu/vendor/knpuniversity/oauth2-client-bundle/src/Security/Authenticator/OAuth2Authenticator.php::40', '#0 /home/eclectis.eu/src/Security/OAuth/YandexAuthenticator.php(80): KnpU\\OAuth2ClientBundle\\Security\\Authenticator\\OAuth2Authenticator->fetchAccessToken()
#1 /home/eclectis.eu/vendor/symfony/security-http/Authenticator/Debug/TraceableAuthenticator.php(74): App\\Security\\OAuth\\YandexAuthenticator->authenticate()
#2 /home/eclectis.eu/vendor/symfony/security-http/Authentication/AuthenticatorManager.php(174): Symfony\\Component\\Security\\Http\\Authenticator\\Debug\\TraceableAuthenticator->authenticate()
#3 /home/eclectis.eu/vendor/symfony/security-http/Authentication/AuthenticatorManager.php(156): Symfony\\Component\\Security\\Http\\Authentication\\AuthenticatorManager->executeAuthenticator()
#4 /home/eclectis.eu/vendor/symfony/security-http/Authentication/AuthenticatorManager.php(138): Symfony\\Component\\Security\\Http\\Authentication\\AuthenticatorManager->executeAuthenticators()
#5 /home/eclectis.eu/vendor/symfony/security-http/Firewall/AuthenticatorManagerListener.php(38): Symfony\\Component\\Security\\Http\\Authentication\\AuthenticatorManager->authenticateRequest()
#6 /home/eclectis.eu/vendor/symfony/security-http/Authenticator/Debug/TraceableAuthenticatorManagerListener.php(58): Symfony\\Component\\Security\\Http\\Firewall\\AuthenticatorManagerListener->authenticate()
#7 /home/eclectis.eu/vendor/symfony/security-bundle/Debug/WrappedLazyListener.php(46): Symfony\\Component\\Security\\Http\\Authenticator\\Debug\\TraceableAuthenticatorManagerListener->authenticate()
#8 /home/eclectis.eu/vendor/symfony/security-bundle/Security/LazyFirewallContext.php(61): Symfony\\Bundle\\SecurityBundle\\Debug\\WrappedLazyListener->authenticate()
#9 /home/eclectis.eu/vendor/symfony/security-bundle/Debug/TraceableFirewallListener.php(91): Symfony\\Bundle\\SecurityBundle\\Security\\LazyFirewallContext->__invoke()
#10 /home/eclectis.eu/vendor/symfony/security-http/Firewall.php(92): Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener->callListeners()
#11 /home/eclectis.eu/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(115): Symfony\\Component\\Security\\Http\\Firewall->onKernelRequest()
#12 /home/eclectis.eu/vendor/symfony/event-dispatcher/EventDispatcher.php(206): Symfony\\Component\\EventDispatcher\\Debug\\WrappedListener->__invoke()
#13 /home/eclectis.eu/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\\Component\\EventDispatcher\\EventDispatcher->callListeners()
#14 /home/eclectis.eu/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(122): Symfony\\Component\\EventDispatcher\\EventDispatcher->dispatch()
#15 /home/eclectis.eu/vendor/symfony/http-kernel/HttpKernel.php(159): Symfony\\Component\\EventDispatcher\\Debug\\TraceableEventDispatcher->dispatch()
#16 /home/eclectis.eu/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#17 /home/eclectis.eu/vendor/symfony/http-kernel/Kernel.php(182): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#18 /home/eclectis.eu/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle()
#19 /home/eclectis.eu/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#20 /home/eclectis.eu/public/index.php(5): require_once(\'...\')
#21 {main}', 0, 0);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 261)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1057)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 402)
5	Doctrine\ORM\UnitOfWork->commit (line 268)
6	Doctrine\ORM\EntityManager->flush (line 111)
7	App\EventSubscriber\AuthenticationSubscriber->saveLogin (line 42)
8	App\EventSubscriber\AuthenticationSubscriber->onLoginFailure (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 262)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationFailure (line 210)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
20	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.42 ms

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 432)
3	Doctrine\ORM\UnitOfWork->commit (line 268)
4	Doctrine\ORM\EntityManager->flush (line 111)
5	App\EventSubscriber\AuthenticationSubscriber->saveLogin (line 42)
6	App\EventSubscriber\AuthenticationSubscriber->onLoginFailure (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 262)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationFailure (line 210)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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\Model\User\Entity\User\LoginHistory	1

Entities Mapping

Class	Mapping errors
App\Model\Blog\Entity\Post\Post	No errors.
App\Model\Blog\Entity\Comment\Comment	No errors.
App\Model\Site\Entity\Testimonial\Testimonial	No errors.
App\Model\User\Entity\User\Name	No errors.
App\Model\User\Entity\User\Location	No errors.
App\Model\User\Entity\User\User	No errors.
App\Model\User\Entity\User\LoginHistory	No errors.

Symfony Profiler

GET https://eclectis.eu/oauth/yandex/check?code=nles74y6rvcsk4yb&state=f5a98b0fa83ab2a032ccefc7f8e3c164%3D

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping