Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

8.45 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.22 ms
(85.47%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.texte AS texte_2, a0_.visuel AS visuel_3, a0_.date_crea AS date_crea_4, a0_.date_publi AS date_publi_5, a0_.actif AS actif_6 FROM articles a0_ WHERE a0_.actif = ? ORDER BY a0_.date_crea DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.texte AS texte_2,
  a0_.visuel AS visuel_3,
  a0_.date_crea AS date_crea_4,
  a0_.date_publi AS date_publi_5,
  a0_.actif AS actif_6
FROM
  articles a0_
WHERE
  a0_.actif = ?
ORDER BY
  a0_.date_crea DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.texte AS texte_2, a0_.visuel AS visuel_3, a0_.date_crea AS date_crea_4, a0_.date_publi AS date_publi_5, a0_.actif AS actif_6 FROM articles a0_ WHERE a0_.actif = 1 ORDER BY a0_.date_crea DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 38)
7	App\Repository\ArticlesRepository->findAllActifByDateCrea (line 602)
8	App\Controller\ZfrontController->front_actualites (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)

1.23 ms
(14.53%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.texte AS texte_2, a0_.visuel AS visuel_3, a0_.date_crea AS date_crea_4, a0_.date_publi AS date_publi_5, a0_.actif AS actif_6 FROM articles a0_ WHERE a0_.actif = ? ORDER BY a0_.date_crea DESC LIMIT 12 OFFSET 120

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.texte AS texte_2,
  a0_.visuel AS visuel_3,
  a0_.date_crea AS date_crea_4,
  a0_.date_publi AS date_publi_5,
  a0_.actif AS actif_6
FROM
  articles a0_
WHERE
  a0_.actif = ?
ORDER BY
  a0_.date_crea DESC
LIMIT
  12 OFFSET 120

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.texte AS texte_2, a0_.visuel AS visuel_3, a0_.date_crea AS date_crea_4, a0_.date_publi AS date_publi_5, a0_.actif AS actif_6 FROM articles a0_ WHERE a0_.actif = 1 ORDER BY a0_.date_crea DESC LIMIT 12 OFFSET 120;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 79)
7	App\Repository\ArticlesRepository->findPageAllActifByDateCrea (line 607)
8	App\Controller\ZfrontController->front_actualites (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\Articles	No errors.

Symfony Profiler

GET https://sel.asso.fr/actualites/11

Configuration Settings

Theme