Symfony Profiler

Query Metrics

2 Database Queries

1 Different statements

2.09 ms Query time

2 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.84 ms

SELECT b0_.id AS id_0, b0_.token AS token_1, b0_.expires_at AS expires_at_2, b0_.created_at AS created_at_3 FROM blacklisted_jwt b0_ WHERE b0_.expires_at <= 1778687047

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.token AS token_1,
  b0_.expires_at AS expires_at_2,
  b0_.created_at AS created_at_3
FROM
  blacklisted_jwt b0_
WHERE
  b0_.expires_at <= 1778687047

SELECT b0_.id AS id_0, b0_.token AS token_1, b0_.expires_at AS expires_at_2, b0_.created_at AS created_at_3 FROM blacklisted_jwt b0_ WHERE b0_.expires_at <= 1778687047;

#	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->getResult (line 688)
6	Dimobile\Core\Repository\BlacklistedJwtRepository->purge (line 75)
7	Dimobile\Core\EventSubscriber\JwtBlacklistPurger->purge (line 26)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
20	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

1.25 ms

SELECT b0_.id AS id_0, b0_.token AS token_1, b0_.expires_at AS expires_at_2, b0_.created_at AS created_at_3 FROM blacklisted_jwt b0_ WHERE b0_.expires_at <= 1778687047

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.token AS token_1,
  b0_.expires_at AS expires_at_2,
  b0_.created_at AS created_at_3
FROM
  blacklisted_jwt b0_
WHERE
  b0_.expires_at <= 1778687047

SELECT b0_.id AS id_0, b0_.token AS token_1, b0_.expires_at AS expires_at_2, b0_.created_at AS created_at_3 FROM blacklisted_jwt b0_ WHERE b0_.expires_at <= 1778687047;

#	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->getResult (line 688)
6	Dimobile\Core\Repository\BlacklistedJwtRepository->purge (line 75)
7	Dimobile\Core\EventSubscriber\JwtBlacklistPurger->purge (line 26)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
13	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 267)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
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\Proposal	The field App\Entity\Proposal#interests is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AppUserProposalInterest#proposal does not contain the required 'inversedBy: "interests"' attribute.
App\Entity\AppUser	The field App\Entity\AppUser#proposals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Proposal#createdBy does not contain the required 'inversedBy: "proposals"' attribute.
App\Entity\AppUserRecommandation	No errors.
App\Entity\AppUserContact	No errors.
Dimobile\Core\Entity\CompanyModule	No errors.
Dimobile\Core\Entity\Company	No errors.
Dimobile\Core\Entity\BlacklistedJwt	No errors.
App\Entity\Day	No errors.
App\Entity\AppUserProposalInterest	No errors.
App\Entity\ServiceCategory	No errors.
App\Entity\Service	No errors.
App\Entity\Address	No errors.
App\Entity\Premium	No errors.
Dimobile\Core\Entity\UserStatus	No errors.
Dimobile\Core\Entity\Module	No errors.
Dimobile\Core\Entity\User	No errors.

Symfony Profiler

GET https://www.ricochet-services.fr/robots.txt

Configuration Settings

Theme

Page Width