Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

15 Database Queries

15 Different statements

529.85 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

176.05 ms
(33.23%)

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(dateinsert) as lastdate
FROM
  ann_annonces
WHERE
  idcategorie = 1

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\AnnAnnoncesRepository->queryOne (line 125)
4	App\Controller\AnnoncesController->index (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)

76.27 ms
(14.40%)

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=7

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(dateinsert) as lastdate
FROM
  ann_annonces
WHERE
  idcategorie = 7

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\AnnAnnoncesRepository->queryOne (line 125)
4	App\Controller\AnnoncesController->index (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)

72.82 ms
(13.74%)

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(dateinsert) as lastdate
FROM
  ann_annonces
WHERE
  idcategorie = 3

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\AnnAnnoncesRepository->queryOne (line 125)
4	App\Controller\AnnoncesController->index (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)

54.04 ms
(10.20%)

SELECT idcategorie, COUNT(*) AS count FROM ann_annonces WHERE online=1 AND valid=1 AND attente=0 GROUP BY idcategorie

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  idcategorie,
  COUNT(*) AS count
FROM
  ann_annonces
WHERE
  online = 1
  AND valid = 1
  AND attente = 0
GROUP BY
  idcategorie

SELECT idcategorie, COUNT(*) AS count FROM ann_annonces WHERE online=1 AND valid=1 AND attente=0 GROUP BY idcategorie;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 133)
2	TheatreCore\Repository\AnnAnnoncesRepository->queryAll (line 109)
3	App\Controller\AnnoncesController->index (line 163)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
6	Symfony\Component\HttpKernel\Kernel->handle (line 20)

45.90 ms
(8.66%)

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(dateinsert) as lastdate
FROM
  ann_annonces
WHERE
  idcategorie = 6

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\AnnAnnoncesRepository->queryOne (line 125)
4	App\Controller\AnnoncesController->index (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)

35.29 ms
(6.66%)

SELECT a.*,e.login FROM ann_annonces a, extranetusers e
             WHERE e.idextranetuser=a.idextranetuser
             AND a.online=1 AND a.valid=1 AND a.attente=0 ORDER BY a.dateinsert DESC LIMIT 0,1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a.*,
  e.login
FROM
  ann_annonces a,
  extranetusers e
WHERE
  e.idextranetuser = a.idextranetuser
  AND a.online = 1
  AND a.valid = 1
  AND a.attente = 0
ORDER BY
  a.dateinsert DESC
LIMIT
  0, 1

SELECT a.*,e.login FROM ann_annonces a, extranetusers e
             WHERE e.idextranetuser=a.idextranetuser
             AND a.online=1 AND a.valid=1 AND a.attente=0 ORDER BY a.dateinsert DESC LIMIT 0,1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 74)
2	TheatreCore\Repository\AnnAnnoncesRepository->queryRow (line 139)
3	App\Controller\AnnoncesController->index (line 163)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
6	Symfony\Component\HttpKernel\Kernel->handle (line 20)

34.22 ms
(6.46%)

SELECT COUNT(idannonce) FROM ann_annonces WHERE online=1 AND valid=1 AND attente=0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(idannonce)
FROM
  ann_annonces
WHERE
  online = 1
  AND valid = 1
  AND attente = 0

SELECT COUNT(idannonce) FROM ann_annonces WHERE online=1 AND valid=1 AND attente=0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\AnnAnnoncesRepository->queryOne (line 160)
4	App\Controller\AnnoncesController->index (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)

17.52 ms
(3.31%)

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(dateinsert) as lastdate
FROM
  ann_annonces
WHERE
  idcategorie = 4

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\AnnAnnoncesRepository->queryOne (line 125)
4	App\Controller\AnnoncesController->index (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)

4.23 ms
(0.80%)

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=8

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(dateinsert) as lastdate
FROM
  ann_annonces
WHERE
  idcategorie = 8

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\AnnAnnoncesRepository->queryOne (line 125)
4	App\Controller\AnnoncesController->index (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)

3.97 ms
(0.75%)

SELECT *,`bigregions`.idbigregion as idbigregion
                    FROM `bigregions`
                        JOIN `regions` ON `regions`.`idbigregion`=`bigregions`.`idbigregion`
                        JOIN `departements` ON `regions`.`idregion`=`departements`.`idregion`
                    ORDER BY `bigregions`.`bigregion` ASC, `departements`.`departement` ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *,
  `bigregions`.idbigregion as idbigregion
FROM
  `bigregions`
  JOIN `regions` ON `regions`.`idbigregion` = `bigregions`.`idbigregion`
  JOIN `departements` ON `regions`.`idregion` = `departements`.`idregion`
ORDER BY
  `bigregions`.`bigregion` ASC,
  `departements`.`departement` ASC

SELECT *,`bigregions`.idbigregion as idbigregion
                    FROM `bigregions`
                        JOIN `regions` ON `regions`.`idbigregion`=`bigregions`.`idbigregion`
                        JOIN `departements` ON `regions`.`idregion`=`departements`.`idregion`
                    ORDER BY `bigregions`.`bigregion` ASC, `departements`.`departement` ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 133)
2	TheatreCore\Repository\BigregionsRepository->queryAll (line 62)
3	TheatreCore\Repository\BigregionsRepository->getBigregionsList (line 234)
4	TheatreCore\Repository\BigregionsRepository->getArea (line 2296)
5	App\Controller\AnnoncesController->getRechercheAnnonce (line 98)
6	App\Controller\AnnoncesController->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)

3.73 ms
(0.70%)

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=9

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(dateinsert) as lastdate
FROM
  ann_annonces
WHERE
  idcategorie = 9

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\AnnAnnoncesRepository->queryOne (line 125)
4	App\Controller\AnnoncesController->index (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)

2.10 ms
(0.40%)

SELECT idcategorie, name FROM ann_categories WHERE online=1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  idcategorie,
  name
FROM
  ann_categories
WHERE
  online = 1

SELECT idcategorie, name FROM ann_categories WHERE online=1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 918)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 37)
3	TheatreCore\Repository\AnnCategoriesRepository->getCategoriesList (line 92)
4	App\Controller\AnnoncesController->index (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)

2.09 ms
(0.39%)

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(dateinsert) as lastdate
FROM
  ann_annonces
WHERE
  idcategorie = 2

SELECT MAX(dateinsert) as lastdate FROM ann_annonces WHERE idcategorie=2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\AnnAnnoncesRepository->queryOne (line 125)
4	App\Controller\AnnoncesController->index (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)

0.84 ms
(0.16%)

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 191)
6	App\Controller\AnnoncesController->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.78 ms
(0.15%)

SELECT * FROM ann_categories WHERE online=1 ORDER BY class

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  ann_categories
WHERE
  online = 1
ORDER BY
  class

SELECT * FROM ann_categories WHERE online=1 ORDER BY class;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 133)
2	TheatreCore\Repository\AnnCategoriesRepository->queryAll (line 102)
3	App\Controller\AnnoncesController->index (line 163)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
6	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\AnnAnnonces	No errors.
TheatreCore\Entity\AnnCategories	No errors.
TheatreCore\Entity\Bigregions	No errors.
TheatreCore\Entity\Abonnements	No errors.
TheatreCore\Entity\Bannieres	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping