Symfony Profiler

SELECT
  DISTINCT idtypestructure,
  typestructure,
  typestructure_pluriel
FROM
  typesstructures
WHERE
  1
  AND public_view = 1
  AND idtypestructure IN ('SN', 'TN', 'CDN', 'EC')
ORDER BY
  order_view,
  typestructure

SELECT DISTINCT idtypestructure, typestructure,typestructure_pluriel FROM typesstructures WHERE 1  AND public_view=1  AND idtypestructure IN ('SN','TN','CDN','EC')  ORDER BY order_view, typestructure;

SELECT
  COUNT(
    DISTINCT(T1.idnew)
  ) as total
FROM
  news T1
  INNER JOIN newschedules T3 ON T3.idnew = T1.idnew
  INNER JOIN extranetusers T2 ON T2.idextranetuser = T1.idextranetuser
  LEFT JOIN contacts T4 ON T4.idcontact = T3.idcontact
WHERE
  1
  AND T1.publish = 1
  AND T1.publish = 1
  AND T1.valid = 1
  AND T1.type_news = 0
  AND (
    (T3.date >= '2024-04-17')
  )

SELECT COUNT(DISTINCT(T1.idnew)) as total  FROM news T1 INNER JOIN newschedules T3
                            ON T3.idnew=T1.idnew
                            INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser
                            LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact  WHERE 1  AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND T1.type_news=0 AND (( T3.date>='2024-04-17' ))    ;

SELECT
  DISTINCT(T1.idnew),
  T1.*,
  T2.idextranetuser,
  T2.lastname,
  T2.firstname,
  T2.signature,
  T2.city as city_extranetuser,
  T2.enseignant_etablissement,
  T2.enseignant_active,
  T3.idnewschedule,
  T3.date,
  T3.hour,
  T3.idcontact,
  T3.note
FROM
  news T1
  INNER JOIN newschedules T3 ON T3.idnew = T1.idnew
  INNER JOIN extranetusers T2 ON T2.idextranetuser = T1.idextranetuser
  LEFT JOIN contacts T4 ON T4.idcontact = T3.idcontact
WHERE
  1
  AND T1.publish = 1
  AND T1.publish = 1
  AND T1.valid = 1
  AND T1.type_news = 0
  AND (
    (T3.date >= '2024-04-17')
  )
GROUP BY
  T1.idnew
ORDER BY
  T3.date ASC
LIMIT
  0, 10

SELECT DISTINCT(T1.idnew), T1.*,T2.idextranetuser,T2.lastname,T2.firstname,T2.signature,T2.city as city_extranetuser,T2.enseignant_etablissement,T2.enseignant_active,T3.idnewschedule,T3.date,T3.hour,T3.idcontact,T3.note  FROM news T1 INNER JOIN newschedules T3
                            ON T3.idnew=T1.idnew
                            INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser
                            LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact  WHERE 1  AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND T1.type_news=0 AND (( T3.date>='2024-04-17' ))  GROUP BY T1.idnew  ORDER BY T3.date ASC LIMIT 0,10;

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 = '13574';

SELECT
  url_file
FROM
  news
WHERE
  idnew = 13574

SELECT url_file FROM news WHERE idnew=13574;

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 = 13574
  AND sc.date >= '2024-04-17'
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=13574 AND sc.date>='2024-04-17'  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 = 13574
  AND sc.date >= '2024-04-17'
  AND sc.idcontact = 35780
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=13574 AND sc.date>='2024-04-17'  AND sc.idcontact=35780 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 = 13574

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=13574;

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 = 13574

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=13574;

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 = 13574

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=13574;

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 = 13574

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=13574;

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 = '13418';

SELECT
  url_file
FROM
  news
WHERE
  idnew = 13418

SELECT url_file FROM news WHERE idnew=13418;

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 = 13418
  AND sc.date >= '2024-04-17'
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=13418 AND sc.date>='2024-04-17'  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 = 13418
  AND sc.date >= '2024-04-17'
  AND sc.idcontact = 9887
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=13418 AND sc.date>='2024-04-17'  AND sc.idcontact=9887 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 = 13418

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=13418;

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 = 13418

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=13418;

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 = 13418

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=13418;

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 = 13418

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=13418;

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 = '13639';

SELECT
  url_file
FROM
  news
WHERE
  idnew = 13639

SELECT url_file FROM news WHERE idnew=13639;

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 = 13639
  AND sc.date >= '2024-04-17'
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=13639 AND sc.date>='2024-04-17'  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 = 13639
  AND sc.date >= '2024-04-17'
  AND sc.idcontact = 1496
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=13639 AND sc.date>='2024-04-17'  AND sc.idcontact=1496 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 = 13639

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=13639;

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 = 13639

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=13639;

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 = 13639

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=13639;