Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

7 Database Queries

7 Different statements

6.48 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

2.57 ms
(39.69%)

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 1586)
6	App\Controller\AnnoncesController->annonce (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.22 ms
(18.89%)

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 1624)
6	App\Controller\AnnoncesController->annonce (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.92 ms
(14.25%)

SELECT a.*,e.login,e.email as email_extra
                FROM ann_annonces a
                    LEFT OUTER JOIN extranetusers e
                    ON a.idextranetuser=e.idextranetuser
                WHERE a.idannonce=91439

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a.*,
  e.login,
  e.email as email_extra
FROM
  ann_annonces a
  LEFT OUTER JOIN extranetusers e ON a.idextranetuser = e.idextranetuser
WHERE
  a.idannonce = 91439

SELECT a.*,e.login,e.email as email_extra
                FROM ann_annonces a
                    LEFT OUTER JOIN extranetusers e
                    ON a.idextranetuser=e.idextranetuser
                WHERE a.idannonce=91439;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 74)
2	TheatreCore\Repository\AnnAnnoncesRepository->queryRow (line 1314)
3	App\Controller\AnnoncesController->annonce (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)

0.62 ms
(9.53%)

SELECT a0_.idcategorie AS idcategorie_0, a0_.name AS name_1, a0_.description AS description_2, a0_.online AS online_3, a0_.class AS class_4, a0_.url_clean AS url_clean_5 FROM ann_categories a0_ WHERE a0_.idcategorie = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.idcategorie AS idcategorie_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.online AS online_3,
  a0_.class AS class_4,
  a0_.url_clean AS url_clean_5
FROM
  ann_categories a0_
WHERE
  a0_.idcategorie = ?

SELECT a0_.idcategorie AS idcategorie_0, a0_.name AS name_1, a0_.description AS description_2, a0_.online AS online_3, a0_.class AS class_4, a0_.url_clean AS url_clean_5 FROM ann_categories a0_ WHERE a0_.idcategorie = '1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 183)
7	TheatreCore\Repository\AnnCategoriesRepository->get (line 1448)
8	App\Controller\AnnoncesController->annonce (line 163)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
11	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.54 ms
(8.31%)

SELECT idcategorie FROM ann_categories WHERE url_clean='Offres-formations-stages'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  idcategorie
FROM
  ann_categories
WHERE
  url_clean = 'Offres-formations-stages'

SELECT idcategorie FROM ann_categories WHERE url_clean='Offres-formations-stages' ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\AnnCategoriesRepository->queryOne (line 2782)
4	App\ClassTheatre\TheatreController->RouterOptions (line 1265)
5	App\Controller\AnnoncesController->annonce (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)

0.52 ms
(7.95%)

SELECT url_clean, name FROM ann_categories WHERE online=1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  url_clean,
  name
FROM
  ann_categories
WHERE
  online = 1

SELECT url_clean, 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 1584)
4	App\Controller\AnnoncesController->annonce (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.09 ms
(1.38%)

SELECT fr FROM countries WHERE id='FR'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'FR'

SELECT fr FROM countries WHERE id='FR';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\AnnAnnoncesRepository->queryOne (line 1669)
4	TheatreCore\Repository\AnnAnnoncesRepository->getNameCountry (line 1456)
5	App\Controller\AnnoncesController->annonce (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\AnnCategories	No errors.
TheatreCore\Entity\AnnAnnonces	No errors.
TheatreCore\Entity\AnnReponses	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/Offres-formations-stages/Cours-d-impro-a-la-carte-adultes-debutants-Paris-10eme-annonce91439/?contact=&path=annonces%2FOffres-formations-stages%2FCours-d-impro-a-la-carte-adultes-debutants-Paris-10eme-annonce91439

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping