Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

3.14 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.39 ms

SELECT o0_.id AS id_0, o0_.libelle AS libelle_1, o0_.actif AS actif_2, o0_.code_ogr AS code_ogr_3 FROM offre_emploi_profil o0_ INNER JOIN offre_emploi o1_ ON o0_.id = o1_.profil_id GROUP BY o0_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.libelle AS libelle_1,
  o0_.actif AS actif_2,
  o0_.code_ogr AS code_ogr_3
FROM
  offre_emploi_profil o0_
  INNER JOIN offre_emploi o1_ ON o0_.id = o1_.profil_id
GROUP BY
  o0_.id

SELECT o0_.id AS id_0, o0_.libelle AS libelle_1, o0_.actif AS actif_2, o0_.code_ogr AS code_ogr_3 FROM offre_emploi_profil o0_ INNER JOIN offre_emploi o1_ ON o0_.id = o1_.profil_id GROUP BY o0_.id;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 32)
8	App\Repository\OffreEmploiProfilRepository->findAllHavingJobs (line 112)
9	App\Controller\OffreEmploiController->list (line 163)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
12	Symfony\Component\HttpKernel\Kernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
15	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
19	Symfony\Component\HttpKernel\Kernel->handle (line 22)

1.58 ms

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM offre_emploi o0_ INNER JOIN etablissement e1_ ON o0_.etablissement_id = e1_.id INNER JOIN ville v2_ ON e1_.ville_id = v2_.id WHERE (o0_.date_validite IS NULL AND o0_.date_actualisation >= ?) OR o0_.date_validite >= ?

Parameters:

[
  "2026-06-10 02:51:39"
  "2026-09-10 02:51:39"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  offre_emploi o0_
  INNER JOIN etablissement e1_ ON o0_.etablissement_id = e1_.id
  INNER JOIN ville v2_ ON e1_.ville_id = v2_.id
WHERE
  (
    o0_.date_validite IS NULL
    AND o0_.date_actualisation >= ?
  )
  OR o0_.date_validite >= ?

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM offre_emploi o0_ INNER JOIN etablissement e1_ ON o0_.etablissement_id = e1_.id INNER JOIN ville v2_ ON e1_.ville_id = v2_.id WHERE (o0_.date_validite IS NULL AND o0_.date_actualisation >= '2026-06-10 02:51:39') OR o0_.date_validite >= '2026-09-10 02:51:39';

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 937)
7	Doctrine\ORM\AbstractQuery->getScalarResult (line 117)
8	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
9	count (line 46)
10	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 117)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 93)
15	Knp\Component\Pager\Paginator->paginate (line 31)
16	Container2u3tDSD\PaginatorInterface_82dac15->paginate (line 191)
17	App\Controller\OffreEmploiController->list (line 163)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
20	Symfony\Component\HttpKernel\Kernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
23	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
27	Symfony\Component\HttpKernel\Kernel->handle (line 22)

1.18 ms

SELECT DISTINCT o0_.id AS id_0, o0_.date_actualisation AS date_actualisation_1 FROM offre_emploi o0_ INNER JOIN etablissement e1_ ON o0_.etablissement_id = e1_.id INNER JOIN ville v2_ ON e1_.ville_id = v2_.id WHERE (o0_.date_validite IS NULL AND o0_.date_actualisation >= ?) OR o0_.date_validite >= ? ORDER BY o0_.date_actualisation DESC LIMIT 30

Parameters:

[
  "2026-06-10 02:51:39"
  "2026-09-10 02:51:39"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.date_actualisation AS date_actualisation_1
FROM
  offre_emploi o0_
  INNER JOIN etablissement e1_ ON o0_.etablissement_id = e1_.id
  INNER JOIN ville v2_ ON e1_.ville_id = v2_.id
WHERE
  (
    o0_.date_validite IS NULL
    AND o0_.date_actualisation >= ?
  )
  OR o0_.date_validite >= ?
ORDER BY
  o0_.date_actualisation DESC
LIMIT
  30

SELECT DISTINCT o0_.id AS id_0, o0_.date_actualisation AS date_actualisation_1 FROM offre_emploi o0_ INNER JOIN etablissement e1_ ON o0_.etablissement_id = e1_.id INNER JOIN ville v2_ ON e1_.ville_id = v2_.id WHERE (o0_.date_validite IS NULL AND o0_.date_actualisation >= '2026-06-10 02:51:39') OR o0_.date_validite >= '2026-09-10 02:51:39' ORDER BY o0_.date_actualisation DESC LIMIT 30;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 937)
7	Doctrine\ORM\AbstractQuery->getScalarResult (line 150)
8	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
9	iterator_to_array (line 48)
10	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 117)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 93)
15	Knp\Component\Pager\Paginator->paginate (line 31)
16	Container2u3tDSD\PaginatorInterface_82dac15->paginate (line 191)
17	App\Controller\OffreEmploiController->list (line 163)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
20	Symfony\Component\HttpKernel\Kernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
23	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
27	Symfony\Component\HttpKernel\Kernel->handle (line 22)

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.

Entities Mapping

Class	Mapping errors
App\Entity\Etablissement	No errors.
App\Entity\OffreEmploiProfil	No errors.
App\Entity\OffreEmploi	No errors.
App\Entity\Ville	No errors.

Symfony Profiler

http://aep-beta.onpc.fr/emplois

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping