Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

27.30 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

25.31 ms
(92.69%)

SELECT COUNT(*) as total FROM persons

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) as total
FROM
  persons

SELECT COUNT(*) as total FROM persons;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\PersonsRepository->queryOne (line 2079)
4	TheatreCore\Repository\PersonsRepository->countPersons (line 241)
5	App\Controller\BiographiesController->action_index (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

1.19 ms
(4.36%)

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_bottom=1
                AND date_start<=NOW()
                AND date_end>=NOW()
                ORDER BY bannieres.order ASC
                LIMIT 0,10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  bannieres
WHERE
  publish = 1
  AND valid = 1
  AND is_bottom = 1
  AND date_start <= NOW()
  AND date_end >= NOW()
ORDER BY
  bannieres.order ASC
LIMIT
  0, 10

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_bottom=1
                AND date_start<=NOW()
                AND date_end>=NOW()
                ORDER BY bannieres.order ASC
                LIMIT 0,10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 74)
2	TheatreCore\Repository\BannieresRepository->queryRow (line 597)
3	TheatreCore\Repository\BannieresRepository->getBottomBanniere (line 520)
4	App\ClassTheatre\TheatreController->common (line 166)
5	App\ClassTheatre\TheatreController->view (line 364)
6	App\Controller\BiographiesController->action_index (line 163)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
9	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.80 ms
(2.95%)

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_national=1
                AND date_start<='2024-06-19'
                AND date_end>='2024-06-19'
                ORDER BY bannieres.order ASC
                LIMIT 0,10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  bannieres
WHERE
  publish = 1
  AND valid = 1
  AND is_national = 1
  AND date_start <= '2024-06-19'
  AND date_end >= '2024-06-19'
ORDER BY
  bannieres.order ASC
LIMIT
  0, 10

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_national=1
                AND date_start<='2024-06-19'
                AND date_end>='2024-06-19'
                ORDER BY bannieres.order ASC
                LIMIT 0,10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 133)
2	TheatreCore\Repository\BannieresRepository->queryAll (line 571)
3	TheatreCore\Repository\BannieresRepository->getNationalBanniere (line 61)
4	App\ClassTheatre\aside\asidePublicite->addWithNational (line 361)
5	App\Controller\BiographiesController->action_index (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Entities Mapping

Class	Mapping errors
TheatreCore\Entity\Extranetusers	No errors.
TheatreCore\Entity\Spectacles	No errors.
TheatreCore\Entity\Persons	No errors.
TheatreCore\Entity\Abonnements	No errors.
TheatreCore\Entity\Bannieres	No errors.

Symfony Profiler

https://preprod.theatre-contemporain.net/biographies/?path=biographies%2F

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping