Symfony Profiler

SELECT
  idgenretext,
  genretext
FROM
  genretexts
WHERE
  visibility IN (1)
ORDER BY
  ordergenre

SELECT idgenretext,genretext FROM genretexts  WHERE visibility IN (1)  ORDER BY ordergenre;

SELECT
  COUNT(
    DISTINCT(T1.`idtext`)
  ) as total
FROM
  texts T1,
  contacts T2,
  object_file of,
  files f,
  file_classification fc
WHERE
  1
  AND of.idfile = f.idfile
  AND of.idobject = T1.idtext
  AND fc.idfile = f.idfile
  AND fc.idclassification = 20
  AND of.object = 'texts'
  AND T2.idcontact = T1.idcontact_publisher
  AND CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) BETWEEN '2024-01-00'
  AND '2024-03-00'
ORDER BY
  T1.publication_year DESC,
  T1.publication_month DESC

SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1,contacts T2 ,object_file of, files f, file_classification fc  WHERE 1  AND of.idfile=f.idfile
                            AND of.idobject=T1.idtext
                            AND fc.idfile=f.idfile
                            AND fc.idclassification=20
                            AND of.object='texts'  AND T2.idcontact=T1.idcontact_publisher AND CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) BETWEEN '2024-01-00' AND '2024-03-00'  ORDER BY T1.publication_year DESC, T1.publication_month DESC  ;

SELECT
  DISTINCT(T1.`idtext`),
  T1.`title`,
  T1.`url_clean`,
  T1.`publication_year`,
  T1.`publication_month`,
  T1.`isbn`,
  T1.`textfictif`,
  T1.`dateinsert`,
  T1.`textorder`,
  T1.`type`,
  T1.`publish`,
  T1.`statut`,
  T1.`valid`,
  T2.`idcontact`,
  T2.`url_clean` as `url_clean_publisher`,
  T2.`organisation`,
  CONCAT(
    T1.`publication_year`, T1.`publication_month`
  ) AS publication_date,
  CAST(
    CONCAT(
      T1.`publication_year`, T1.`publication_month`
    ) AS DATE
  ) AS publication_date_full
FROM
  texts T1,
  contacts T2,
  object_file of,
  files f,
  file_classification fc
WHERE
  1
  AND of.idfile = f.idfile
  AND of.idobject = T1.idtext
  AND fc.idfile = f.idfile
  AND fc.idclassification = 20
  AND of.object = 'texts'
  AND T2.idcontact = T1.idcontact_publisher
  AND CAST(
    CONCAT(
      T1.`publication_year`, '-', T1.`publication_month`,
      '-00'
    ) AS DATE
  ) BETWEEN '2024-01-00'
  AND '2024-03-00'
GROUP BY
  T1.idtext
ORDER BY
  T1.publication_year DESC,
  T1.publication_month DESC
LIMIT
  0, 20

SELECT DISTINCT(T1.`idtext`), T1.`title`,T1.`url_clean`,T1.`publication_year`,T1.`publication_month`,T1.`isbn`,T1.`textfictif`,T1.`dateinsert`,T1.`textorder`,T1.`type`,T1.`publish`,T1.`statut`,T1.`valid`,T2.`idcontact`,T2.`url_clean` as `url_clean_publisher`,T2.`organisation`,
                        CONCAT(T1.`publication_year`, T1.`publication_month`) AS publication_date,
                        CAST(CONCAT(T1.`publication_year`, T1.`publication_month`) AS DATE) AS publication_date_full  FROM texts T1,contacts T2 ,object_file of, files f, file_classification fc  WHERE 1  AND of.idfile=f.idfile
                            AND of.idobject=T1.idtext
                            AND fc.idfile=f.idfile
                            AND fc.idclassification=20
                            AND of.object='texts'  AND T2.idcontact=T1.idcontact_publisher AND CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) BETWEEN '2024-01-00' AND '2024-03-00'  GROUP BY T1.idtext  ORDER BY T1.publication_year DESC, T1.publication_month DESC  LIMIT 0,20;

SELECT
  t0_.type AS type_0
FROM
  texts t0_
WHERE
  t0_.idtext = ?

SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = '41371';

SELECT
  j1.idperson,
  j1.lastname,
  j1.firstname,
  j1.url_clean,
  j1.valid,
  j3.idtext
FROM
  theatreok_dev.persons j1,
  theatreok_dev.text_author j2,
  theatreok_dev.texts j3
WHERE
  j3.idtext = j2.idtext
  AND j1.idperson = j2.idperson
  AND j3.idtext = 41371
ORDER BY
  j2.classement ASC

SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=41371  ORDER BY j2.classement ASC;

SELECT
  t0_.type AS type_0
FROM
  texts t0_
WHERE
  t0_.idtext = ?

SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = '44141';

SELECT
  j1.idperson,
  j1.lastname,
  j1.firstname,
  j1.url_clean,
  j1.valid,
  j3.idtext
FROM
  theatreok_dev.persons j1,
  theatreok_dev.text_author j2,
  theatreok_dev.texts j3
WHERE
  j3.idtext = j2.idtext
  AND j1.idperson = j2.idperson
  AND j3.idtext = 44141
ORDER BY
  j2.classement ASC

SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=44141  ORDER BY j2.classement ASC;

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;