Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

4.30 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲

Time

Info

2.35 ms

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND (is_bottom=0 OR is_bottom IS NULL)
                AND (is_region=0 OR is_region IS NULL)
                AND (is_national=0 OR is_national IS NULL)
                AND date_start<=NOW()
                AND date_end>=NOW()
                LIMIT 0,1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  bannieres
WHERE
  publish = 1
  AND valid = 1
  AND (
    is_bottom = 0
    OR is_bottom IS NULL
  )
  AND (
    is_region = 0
    OR is_region IS NULL
  )
  AND (
    is_national = 0
    OR is_national IS NULL
  )
  AND date_start <= NOW()
  AND date_end >= NOW()
LIMIT
  0, 1

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND (is_bottom=0 OR is_bottom IS NULL)
                AND (is_region=0 OR is_region IS NULL)
                AND (is_national=0 OR is_national IS NULL)
                AND date_start<=NOW()
                AND date_end>=NOW()
                LIMIT 0,1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 74)
2	TheatreCore\Repository\BannieresRepository->queryRow (line 499)
3	TheatreCore\Repository\BannieresRepository->getCurrentBanniere (line 353)
4	App\Controller\UtilitairesController->banniere (line 163)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
7	Symfony\Component\HttpKernel\Kernel->handle (line 20)

1.95 ms

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 367)
6	App\Controller\UtilitairesController->banniere (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/utilitaires/banniere?path=utilitaires%2Fbanniere

Configuration Settings

Theme