Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

2.25 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲

Time

Info

0.85 ms

SELECT DISTINCT(`idmultimedia`)  as id, url_clean
                           FROM multimedias
                           WHERE url_clean='1b7WXt3P'
                           OR code='1b7WXt3P'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT(`idmultimedia`) as id,
  url_clean
FROM
  multimedias
WHERE
  url_clean = '1b7WXt3P'
  OR code = '1b7WXt3P'

SELECT DISTINCT(`idmultimedia`)  as id, url_clean
                           FROM multimedias
                           WHERE url_clean='1b7WXt3P'
                           OR code='1b7WXt3P' ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\MultimediasRepository->queryOne (line 2160)
4	TheatreCore\Repository\MultimediasRepository->getIdByUrl (line 300)
5	TheatreCore\Repository\MultimediasRepository->getInfosMultimedia (line 153)
6	App\Controller\EmbedController->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)

1.39 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 267)
6	App\Controller\EmbedController->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)

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

Symfony Profiler

https://preprod.theatre-contemporain.net/embed/1b7WXt3P?autostart=&no_title=&path=embed%2F1b7WXt3P

Configuration Settings

Theme