Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

2 Different statements

1.28 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

0.96 ms
(75.04%)

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 426)
6	App\Controller\MontheatreInscriptionController->action_inscription (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.32 ms
(24.96%)

SELECT fr, id FROM countries ORDER BY orderby,fr

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr,
  id
FROM
  countries
ORDER BY
  orderby,
  fr

SELECT fr, id FROM countries ORDER BY orderby,fr;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 133)
2	TheatreCore\Repository\ExtranetusersRepository->queryAll (line 1760)
3	TheatreCore\Repository\ExtranetusersRepository->getCachedListForCountries (line 1792)
4	TheatreCore\Repository\ExtranetusersRepository->getCountryList (line 638)
5	App\Controller\MontheatreInscriptionController->form (line 404)
6	App\Controller\MontheatreInscriptionController->action_inscription (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)

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\Bannieres	No errors.

Symfony Profiler

https://preprod.theatre-contemporain.net/montheatre/inscription?path=montheatre%2Finscription&urifrom=%2Fspectacles%2FJuste-la-fin-du-monde-8145%2Fajoutdates%2F

Configuration Settings

Theme