Symfony Profiler

SELECT
  t0.idnew AS idnew_1,
  t0.title AS title_2,
  t0.type_news AS type_news_3,
  t0.description AS description_4,
  t0.markdown AS markdown_5,
  t0.date_start AS date_start_6,
  t0.date_end AS date_end_7,
  t0.hour AS hour_8,
  t0.location AS location_9,
  t0.city AS city_10,
  t0.zip AS zip_11,
  t0.contacts AS contacts_12,
  t0.url AS url_13,
  t0.url_more AS url_more_14,
  t0.infos_contacts AS infos_contacts_15,
  t0.url_file AS url_file_16,
  t0.copyright_file AS copyright_file_17,
  t0.is_homepage AS is_homepage_18,
  t0.publish AS publish_19,
  t0.valid AS valid_20,
  t0.statut AS statut_21,
  t0.dateinsert AS dateinsert_22,
  t0.dateupdate AS dateupdate_23,
  t0.idextranetuser_lock AS idextranetuser_lock_24,
  t0.idextranetuser AS idextranetuser_25,
  t0.idregion AS idregion_26,
  t0.country AS country_27
FROM
  news t0
WHERE
  t0.idnew = ?

SELECT t0.idnew AS idnew_1, t0.title AS title_2, t0.type_news AS type_news_3, t0.description AS description_4, t0.markdown AS markdown_5, t0.date_start AS date_start_6, t0.date_end AS date_end_7, t0.hour AS hour_8, t0.location AS location_9, t0.city AS city_10, t0.zip AS zip_11, t0.contacts AS contacts_12, t0.url AS url_13, t0.url_more AS url_more_14, t0.infos_contacts AS infos_contacts_15, t0.url_file AS url_file_16, t0.copyright_file AS copyright_file_17, t0.is_homepage AS is_homepage_18, t0.publish AS publish_19, t0.valid AS valid_20, t0.statut AS statut_21, t0.dateinsert AS dateinsert_22, t0.dateupdate AS dateupdate_23, t0.idextranetuser_lock AS idextranetuser_lock_24, t0.idextranetuser AS idextranetuser_25, t0.idregion AS idregion_26, t0.country AS country_27 FROM news t0 WHERE t0.idnew = '11308';

SELECT
  DISTINCT(s.idnewschedule),
  s.note,
  s.hour,
  c.idcontact,
  c.organisation,
  c.phone1,
  c.phone2,
  c.city,
  c.url_clean,
  MIN(s.date) AS datedebut
FROM
  newschedules s,
  contacts c
WHERE
  s.idcontact = c.idcontact
  AND s.idnew = 11308
GROUP BY
  s.idcontact
ORDER BY
  s.date ASC

SELECT DISTINCT(s.idnewschedule),s.note,s.hour,c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean,MIN(s.date) AS datedebut
                  FROM newschedules s,contacts c 
                  WHERE s.idcontact=c.idcontact
                  AND s.idnew=11308 GROUP BY s.idcontact ORDER BY s.date ASC;

SELECT
  DISTINCT(date),
  note
FROM
  newschedules
WHERE
  idnew = 11308
  AND idcontact = 655
ORDER BY
  date

SELECT DISTINCT(date), note 
                FROM newschedules 
                WHERE idnew=11308
                AND idcontact=655  ORDER BY date;

SELECT
  hour,
  note
FROM
  newschedules
WHERE
  date = "2019-10-04"
  AND idnew = 11308
  AND idcontact = 655

SELECT hour,note 
                  FROM newschedules 
                  WHERE date="2019-10-04" 
                  AND idnew=11308 
                  AND idcontact=655;

SELECT
  hour,
  note
FROM
  newschedules
WHERE
  date = "2019-10-05"
  AND idnew = 11308
  AND idcontact = 655

SELECT hour,note 
                  FROM newschedules 
                  WHERE date="2019-10-05" 
                  AND idnew=11308 
                  AND idcontact=655;

SELECT
  url_file
FROM
  news
WHERE
  idnew = 11308

SELECT url_file FROM news WHERE idnew=11308;

SELECT
  sc.date,
  c.city,
  c.country,
  c.zip,
  c.organisation,
  c.url_clean,
  c.idcontact
FROM
  newschedules sc,
  contacts c
WHERE
  sc.idcontact = c.idcontact
  AND sc.idnew = 11308
  AND sc.date >= '2024-03-28'
ORDER BY
  sc.date ASC
LIMIT
  0, 1

SELECT sc.date, c.city, c.country, c.zip, c.organisation, c.url_clean, c.idcontact FROM newschedules sc, contacts c
                         WHERE sc.idcontact=c.idcontact
                         AND sc.idnew=11308 AND sc.date>='2024-03-28'  ORDER BY sc.date ASC LIMIT 0,1;

SELECT
  sc.date,
  c.city,
  c.country,
  c.zip,
  c.organisation,
  c.url_clean,
  c.idcontact
FROM
  newschedules sc,
  contacts c
WHERE
  sc.idcontact = c.idcontact
  AND sc.idnew = 11308
  AND sc.date >= '2024-03-28'
ORDER BY
  sc.date ASC
LIMIT
  0, 1

SELECT sc.date, c.city, c.country, c.zip, c.organisation, c.url_clean, c.idcontact FROM newschedules sc, contacts c
                         WHERE sc.idcontact=c.idcontact
                         AND sc.idnew=11308 AND sc.date>='2024-03-28'  ORDER BY sc.date ASC LIMIT 0,1;

SELECT
  sc.date,
  c.city,
  c.country,
  c.zip,
  c.organisation,
  c.url_clean,
  c.idcontact
FROM
  newschedules sc,
  contacts c
WHERE
  sc.idcontact = c.idcontact
  AND sc.idnew = 11308
  AND sc.date <= '2024-03-28'
ORDER BY
  sc.date ASC
LIMIT
  0, 1

SELECT sc.date, c.city, c.country, c.zip, c.organisation, c.url_clean, c.idcontact FROM newschedules sc, contacts c
                         WHERE sc.idcontact=c.idcontact
                         AND sc.idnew=11308 AND sc.date<='2024-03-28'  ORDER BY sc.date ASC LIMIT 0,1;

SELECT
  MIN(sc.date) as datestart,
  MAX(sc.date) as dateend,
  c.city,
  c.country
FROM
  newschedules sc,
  contacts c
WHERE
  sc.idcontact = c.idcontact
  AND sc.idnew = 11308
  AND sc.date <= '2024-03-28'
  AND sc.idcontact = 655
GROUP BY
  sc.idcontact

SELECT MIN(sc.date) as datestart, MAX(sc.date) as dateend, c.city, c.country FROM newschedules sc, contacts c
                         WHERE sc.idcontact=c.idcontact
                         AND sc.idnew=11308 AND sc.date<='2024-03-28'  AND sc.idcontact=655 GROUP BY sc.idcontact;

SELECT
  j1.idperson,
  j1.lastname,
  j1.firstname,
  j1.url_clean,
  j1.valid,
  j3.idnew
FROM
  theatreok_dev.persons j1,
  theatreok_dev.new_person j2,
  theatreok_dev.news j3
WHERE
  j3.idnew = j2.idnew
  AND j1.idperson = j2.idperson
  AND j3.idnew = 11308

SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idnew FROM theatreok_dev.persons j1, theatreok_dev.new_person j2, theatreok_dev.news j3
                        WHERE j3.idnew=j2.idnew
                        AND j1.idperson=j2.idperson
                        AND j3.idnew=11308;

SELECT
  j1.idcontact,
  j1.lastname,
  j1.firstname,
  j1.organisation,
  j1.type,
  j1.url_clean,
  j3.idnew
FROM
  theatreok_dev.contacts j1,
  theatreok_dev.new_contact j2,
  theatreok_dev.news j3
WHERE
  j3.idnew = j2.idnew
  AND j1.idcontact = j2.idcontact
  AND j3.idnew = 11308

SELECT j1.idcontact,j1.lastname,j1.firstname,j1.organisation,j1.type,j1.url_clean ,j3.idnew FROM theatreok_dev.contacts j1, theatreok_dev.new_contact j2, theatreok_dev.news j3
                        WHERE j3.idnew=j2.idnew
                        AND j1.idcontact=j2.idcontact
                        AND j3.idnew=11308;

SELECT
  j1.idspectacle,
  j1.title,
  j1.valid,
  j1.publish,
  j1.url_clean,
  j3.idnew
FROM
  theatreok_dev.spectacles j1,
  theatreok_dev.new_spectacle j2,
  theatreok_dev.news j3
WHERE
  j3.idnew = j2.idnew
  AND j1.idspectacle = j2.idspectacle
  AND j3.idnew = 11308

SELECT j1.idspectacle,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.spectacles j1, theatreok_dev.new_spectacle j2, theatreok_dev.news j3
                        WHERE j3.idnew=j2.idnew
                        AND j1.idspectacle=j2.idspectacle
                        AND j3.idnew=11308;

SELECT
  j1.idtext,
  j1.title,
  j1.valid,
  j1.publish,
  j1.url_clean,
  j3.idnew
FROM
  theatreok_dev.texts j1,
  theatreok_dev.new_text j2,
  theatreok_dev.news j3
WHERE
  j3.idnew = j2.idnew
  AND j1.idtext = j2.idtext
  AND j3.idnew = 11308

SELECT j1.idtext,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.texts j1, theatreok_dev.new_text j2, theatreok_dev.news j3
                        WHERE j3.idnew=j2.idnew
                        AND j1.idtext=j2.idtext
                        AND j3.idnew=11308;

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;