Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

48 Database Queries

48 Different statements

160.19 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

125.75 ms
(78.50%)

SELECT `files`.date_start as `date`, CONCAT_WS('-', YEAR(files.`date_start`), YEAR(files.`date_end`)) as saison, YEAR(files.`date_start`) as annee
            FROM files
            WHERE CONCAT_WS('-', YEAR(files.`date_start`), YEAR(files.`date_end`))!='0-0'  AND files.`date_start`>='2013-09-01' 
            GROUP BY saison
            ORDER BY saison

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `files`.date_start as `date`,
  CONCAT_WS(
    '-',
    YEAR(files.`date_start`),
    YEAR(files.`date_end`)
  ) as saison,
  YEAR(files.`date_start`) as annee
FROM
  files
WHERE
  CONCAT_WS(
    '-',
    YEAR(files.`date_start`),
    YEAR(files.`date_end`)
  )!= '0-0'
  AND files.`date_start` >= '2013-09-01'
GROUP BY
  saison
ORDER BY
  saison

SELECT `files`.date_start as `date`, CONCAT_WS('-', YEAR(files.`date_start`), YEAR(files.`date_end`)) as saison, YEAR(files.`date_start`) as annee
            FROM files
            WHERE CONCAT_WS('-', YEAR(files.`date_start`), YEAR(files.`date_end`))!='0-0'  AND files.`date_start`>='2013-09-01' 
            GROUP BY saison
            ORDER BY saison;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 133)
2	TheatreCore\Repository\FilesRepository->queryAll (line 1828)
3	TheatreCore\Repository\FilesRepository->getSaisons (line 210)
4	App\Controller\BookletsController->action_programmes (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)

20.79 ms
(12.98%)

SELECT  DISTINCT(files.idfile), files.*,file_classification.*,typesfiles.*,object_file.*,contacts.`url_clean`,contacts.`organisation`,contacts.`nom_suite`,contacts.`city` 
FROM  `files` ,
 `file_classification` ,
 `typesfiles` ,
 `object_file` ,
 `contacts`  
 WHERE 1  AND files.`publish`=1  AND object_file.`object`='contacts'  AND file_classification.`idclassification` IN (112)  AND ( (files.`date_start`='2023-09-01' AND files.`date_end`='2024-08-31')  OR  (files.`date_start`='2024-09-01' AND files.`date_end`='2025-08-31') )  AND files.`idfile`=object_file.`idfile` AND typesfiles.`idtype`=files.`idtype` AND file_classification.`idfile`=files.`idfile` AND object_file.`idobject`=contacts.`idcontact` 
GROUP BY files.idfile 
ORDER BY contacts.`organisation` 
ASC 
LIMIT 0,200

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT(files.idfile),
  files.*,
  file_classification.*,
  typesfiles.*,
  object_file.*,
  contacts.`url_clean`,
  contacts.`organisation`,
  contacts.`nom_suite`,
  contacts.`city`
FROM
  `files`,
  `file_classification`,
  `typesfiles`,
  `object_file`,
  `contacts`
WHERE
  1
  AND files.`publish` = 1
  AND object_file.`object` = 'contacts'
  AND file_classification.`idclassification` IN (112)
  AND (
    (
      files.`date_start` = '2023-09-01'
      AND files.`date_end` = '2024-08-31'
    )
    OR (
      files.`date_start` = '2024-09-01'
      AND files.`date_end` = '2025-08-31'
    )
  )
  AND files.`idfile` = object_file.`idfile`
  AND typesfiles.`idtype` = files.`idtype`
  AND file_classification.`idfile` = files.`idfile`
  AND object_file.`idobject` = contacts.`idcontact`
GROUP BY
  files.idfile
ORDER BY
  contacts.`organisation` ASC
LIMIT
  0, 200

SELECT  DISTINCT(files.idfile), files.*,file_classification.*,typesfiles.*,object_file.*,contacts.`url_clean`,contacts.`organisation`,contacts.`nom_suite`,contacts.`city` 
FROM  `files` ,
 `file_classification` ,
 `typesfiles` ,
 `object_file` ,
 `contacts`  
 WHERE 1  AND files.`publish`=1  AND object_file.`object`='contacts'  AND file_classification.`idclassification` IN (112)  AND ( (files.`date_start`='2023-09-01' AND files.`date_end`='2024-08-31')  OR  (files.`date_start`='2024-09-01' AND files.`date_end`='2025-08-31') )  AND files.`idfile`=object_file.`idfile` AND typesfiles.`idtype`=files.`idtype` AND file_classification.`idfile`=files.`idfile` AND object_file.`idobject`=contacts.`idcontact` 
GROUP BY files.idfile 
ORDER BY contacts.`organisation` 
ASC 
LIMIT 0,200;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 95)
2	TheatreCore\Repository\FilesRepository->query (line 1762)
3	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
4	App\Controller\BookletsController->action_programmes (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.08 ms
(0.67%)

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 379)
6	App\Controller\BookletsController->action_programmes (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.83 ms
(0.52%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=114123

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 114123

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=114123;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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
(0.34%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110934

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 110934

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110934;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.43 ms
(0.27%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112189

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112189

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112189;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.37 ms
(0.23%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112078

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112078

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112078;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.37 ms
(0.23%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111159

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 111159

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111159;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.36 ms
(0.22%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112188

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112188

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112188;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.35 ms
(0.22%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112182

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112182

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112182;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.34 ms
(0.22%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=113227

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 113227

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=113227;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.34 ms
(0.21%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=113002

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 113002

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=113002;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.33 ms
(0.21%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112681

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112681

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112681;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.32 ms
(0.20%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112074

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112074

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112074;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.30 ms
(0.19%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110523

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 110523

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110523;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.29 ms
(0.18%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112184

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112184

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112184;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.26 ms
(0.16%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=113269

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 113269

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=113269;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.26 ms
(0.16%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112030

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112030

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112030;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.26 ms
(0.16%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=114396

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 114396

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=114396;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.26 ms
(0.16%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112073

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112073

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112073;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.25 ms
(0.16%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112380

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112380

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112380;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.25 ms
(0.15%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110353

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 110353

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110353;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.25 ms
(0.15%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111207

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 111207

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111207;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.24 ms
(0.15%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112185

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112185

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112185;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.24 ms
(0.15%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=113657

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 113657

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=113657;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.24 ms
(0.15%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112153

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112153

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112153;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.24 ms
(0.15%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112178

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112178

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112178;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.24 ms
(0.15%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112187

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112187

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112187;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.23 ms
(0.15%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110833

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 110833

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110833;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.23 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111886

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 111886

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111886;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.23 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110471

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 110471

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110471;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.23 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112054

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112054

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112054;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.23 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=113721

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 113721

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=113721;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.22 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111088

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 111088

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111088;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.22 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112186

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112186

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112186;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.22 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110469

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 110469

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110469;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.22 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=113523

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 113523

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=113523;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.22 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111226

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 111226

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111226;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.22 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112183

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112183

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112183;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.22 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112181

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112181

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112181;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.22 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111042

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 111042

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111042;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.22 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111155

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 111155

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111155;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.22 ms
(0.14%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112029

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112029

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112029;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.21 ms
(0.13%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112179

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112179

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112179;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.21 ms
(0.13%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110988

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 110988

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=110988;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.21 ms
(0.13%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=104021

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 104021

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=104021;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.21 ms
(0.13%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111917

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 111917

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=111917;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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.21 ms
(0.13%)

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112180

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j1.idclassification,
  j1.classification,
  j1.type,
  j3.idfile
FROM
  theatreok_dev.classifications j1,
  theatreok_dev.file_classification j2,
  theatreok_dev.files j3
WHERE
  j3.idfile = j2.idfile
  AND j1.idclassification = j2.idclassification
  AND j3.idfile = 112180

SELECT j1.idclassification,j1.classification,j1.type ,j3.idfile FROM theatreok_dev.classifications j1, theatreok_dev.file_classification j2, theatreok_dev.files j3
                        WHERE j3.idfile=j2.idfile
                        AND j1.idclassification=j2.idclassification
                        AND j3.idfile=112180;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 1066)
3	TheatreCore\Repository\ClassificationsRepository->getLinkedObject (line 974)
4	TheatreCore\Repository\ClassificationsRepository->getObjectClassification (line 1332)
5	TheatreCore\Repository\FilesRepository->getClassifications (line 287)
6	TheatreCore\Repository\FilesRepository->getInfosFile (line 1776)
7	TheatreCore\Repository\FilesRepository->getListFiles (line 195)
8	App\Controller\BookletsController->action_programmes (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)

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

Symfony Profiler

https://preprod.theatre-contemporain.net/contacts/archives/programmes/idtypestructure/all?path=contacts%2Farchives%2Fprogrammes%2Fidtypestructure%2Fall%2F

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping