Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

18.71 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

18.00 ms
(96.20%)

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, a0_.rubrique_id AS rubrique_id_7 FROM actions a0_ WHERE a0_.rubrique_id = ? AND a0_.actif = ? ORDER BY a0_.date_publi DESC LIMIT 12 OFFSET 24

Parameters:

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,
  a0_.rubrique_id AS rubrique_id_7
FROM
  actions a0_
WHERE
  a0_.rubrique_id = ?
  AND a0_.actif = ?
ORDER BY
  a0_.date_publi DESC
LIMIT
  12
OFFSET
  24

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, a0_.rubrique_id AS rubrique_id_7 FROM actions a0_ WHERE a0_.rubrique_id = 1 AND a0_.actif = 1 ORDER BY a0_.date_publi DESC LIMIT 12 OFFSET 24;

#	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 150)
7	App\Repository\ActionsRepository->findPageAllActifByDateCrea (line 1313)
8	App\Controller\ZfrontController->front_actions (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.45 ms
(2.41%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.ordre AS ordre_2, a0_.actif AS actif_3 FROM action_rubrique a0_ WHERE a0_.actif = ? ORDER BY a0_.ordre ASC

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_.ordre AS ordre_2,
  a0_.actif AS actif_3
FROM
  action_rubrique a0_
WHERE
  a0_.actif = ?
ORDER BY
  a0_.ordre ASC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.ordre AS ordre_2, a0_.actif AS actif_3 FROM action_rubrique a0_ WHERE a0_.actif = 1 ORDER BY a0_.ordre ASC;

#	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 36)
7	App\Repository\ActionRubriqueRepository->findAllActifByOrdre (line 1306)
8	App\Controller\ZfrontController->front_actions (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.26 ms
(1.40%)

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, a0_.rubrique_id AS rubrique_id_7 FROM actions a0_ WHERE a0_.rubrique_id = ? 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,
  a0_.rubrique_id AS rubrique_id_7
FROM
  actions a0_
WHERE
  a0_.rubrique_id = ?
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, a0_.rubrique_id AS rubrique_id_7 FROM actions a0_ WHERE a0_.rubrique_id = 1 ORDER BY a0_.date_crea DESC;

#	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 61)
7	App\Repository\ActionsRepository->findAllRubByDateCrea (line 1309)
8	App\Controller\ZfrontController->front_actions (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\ActionRubrique	No errors.
App\Entity\Actions	No errors.

Symfony Profiler

GET https://culture.webgiciel.com/actions/3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping