Symfony Profiler

Query Metrics

2 Database Queries

1 Different statements

2.34 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.90 ms

SELECT p0_.id AS id_0, p0_.titre_ar AS titre_ar_1, p0_.titre_fr AS titre_fr_2, p0_.obligatoire AS obligatoire_3, p0_.supprime AS supprime_4, p0_.type AS type_5 FROM pieces_demandees p0_ WHERE p0_.type = ? AND p0_.supprime <> 1

Parameters:

[
  "attribution"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.titre_ar AS titre_ar_1,
  p0_.titre_fr AS titre_fr_2,
  p0_.obligatoire AS obligatoire_3,
  p0_.supprime AS supprime_4,
  p0_.type AS type_5
FROM
  pieces_demandees p0_
WHERE
  p0_.type = ?
  AND p0_.supprime <> 1

SELECT p0_.id AS id_0, p0_.titre_ar AS titre_ar_1, p0_.titre_fr AS titre_fr_2, p0_.obligatoire AS obligatoire_3, p0_.supprime AS supprime_4, p0_.type AS type_5 FROM pieces_demandees p0_ WHERE p0_.type = 'attribution' AND p0_.supprime <> 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 59)
7	App\Repository\PiecesDemandeesRepository->findPiecesByType (line 37)
8	App\Controller\Front\HomeController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.44 ms

SELECT p0_.id AS id_0, p0_.titre_ar AS titre_ar_1, p0_.titre_fr AS titre_fr_2, p0_.obligatoire AS obligatoire_3, p0_.supprime AS supprime_4, p0_.type AS type_5 FROM pieces_demandees p0_ WHERE p0_.type = ? AND p0_.supprime <> 1

Parameters:

[
  "renouvellement"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.titre_ar AS titre_ar_1,
  p0_.titre_fr AS titre_fr_2,
  p0_.obligatoire AS obligatoire_3,
  p0_.supprime AS supprime_4,
  p0_.type AS type_5
FROM
  pieces_demandees p0_
WHERE
  p0_.type = ?
  AND p0_.supprime <> 1

SELECT p0_.id AS id_0, p0_.titre_ar AS titre_ar_1, p0_.titre_fr AS titre_fr_2, p0_.obligatoire AS obligatoire_3, p0_.supprime AS supprime_4, p0_.type AS type_5 FROM pieces_demandees p0_ WHERE p0_.type = 'renouvellement' AND p0_.supprime <> 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 59)
7	App\Repository\PiecesDemandeesRepository->findPiecesByType (line 38)
8	App\Controller\Front\HomeController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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.

Entities Mapping

Class	Mapping errors
App\Entity\PiecesDemandees	No errors.
App\Entity\DemandePiecesJointes	No errors.

Symfony Profiler

GET https://154.70.207.24/fr/accueil

Configuration Settings

Theme