Symfony Profiler

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;

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;