Symfony Profiler

SELECT
  idspectacle
FROM
  spectacles
WHERE
  url_clean = 'L-Ile-d-Or-Kanemu-jima'

SELECT idspectacle FROM spectacles WHERE url_clean='L-Ile-d-Or-Kanemu-jima' ;

SELECT
  s0_.idspectacle AS idspectacle_0,
  s0_.title AS title_1,
  s0_.language AS language_2,
  s0_.creation_date AS creation_date_3,
  s0_.url_page AS url_page_4,
  s0_.infos AS infos_5,
  s0_.tag AS tag_6,
  s0_.id_rubrique AS id_rubrique_7,
  s0_.duration AS duration_8,
  s0_.interlude AS interlude_9,
  s0_.textfictif AS textfictif_10,
  s0_.url_redirect AS url_redirect_11,
  s0_.url_clean AS url_clean_12,
  s0_.dateupdate AS dateupdate_13,
  s0_.dateinsert AS dateinsert_14,
  s0_.publish AS publish_15,
  s0_.statut AS statut_16,
  s0_.valid AS valid_17,
  t1_.idtypespectacle AS idtypespectacle_18,
  c2_.idcontact AS idcontact_19,
  c2_.type AS type_20,
  c2_.organisation AS organisation_21,
  c2_.nom_suite AS nom_suite_22,
  c2_.lastname AS lastname_23,
  c2_.firstname AS firstname_24,
  c2_.idtypestructure AS idtypestructure_25,
  c2_.license AS license_26,
  c2_.comment AS comment_27,
  c2_.private_comment AS private_comment_28,
  c2_.address1 AS address1_29,
  c2_.address2 AS address2_30,
  c2_.zip AS zip_31,
  c2_.city AS city_32,
  c2_.phone1 AS phone1_33,
  c2_.phone2 AS phone2_34,
  c2_.fax AS fax_35,
  c2_.email1 AS email1_36,
  c2_.email1_online AS email1_online_37,
  c2_.email2_online AS email2_online_38,
  c2_.email2 AS email2_39,
  c2_.url AS url_40,
  c2_.url_ticket AS url_ticket_41,
  c2_.facebook AS facebook_42,
  c2_.twitter AS twitter_43,
  c2_.instagram AS instagram_44,
  c2_.mobile AS mobile_45,
  c2_.geocodable AS geocodable_46,
  c2_.x AS x_47,
  c2_.y AS y_48,
  c2_.idmultimedia AS idmultimedia_49,
  c2_.type_view AS type_view_50,
  c2_.stats_access AS stats_access_51,
  c2_.ga_tracking_id AS ga_tracking_id_52,
  c2_.is_festival AS is_festival_53,
  c2_.link_on_video AS link_on_video_54,
  c2_.is_partenaire AS is_partenaire_55,
  c2_.valid_version AS valid_version_56,
  c2_.other_versions AS other_versions_57,
  c2_.url_redirect AS url_redirect_58,
  c2_.url_clean AS url_clean_59,
  c2_.dateupdate AS dateupdate_60,
  c2_.dateinsert AS dateinsert_61,
  c2_.publish AS publish_62,
  c2_.valid AS valid_63,
  c3_.idcontact AS idcontact_64,
  c3_.type AS type_65,
  c3_.organisation AS organisation_66,
  c3_.nom_suite AS nom_suite_67,
  c3_.lastname AS lastname_68,
  c3_.firstname AS firstname_69,
  c3_.idtypestructure AS idtypestructure_70,
  c3_.license AS license_71,
  c3_.comment AS comment_72,
  c3_.private_comment AS private_comment_73,
  c3_.address1 AS address1_74,
  c3_.address2 AS address2_75,
  c3_.zip AS zip_76,
  c3_.city AS city_77,
  c3_.phone1 AS phone1_78,
  c3_.phone2 AS phone2_79,
  c3_.fax AS fax_80,
  c3_.email1 AS email1_81,
  c3_.email1_online AS email1_online_82,
  c3_.email2_online AS email2_online_83,
  c3_.email2 AS email2_84,
  c3_.url AS url_85,
  c3_.url_ticket AS url_ticket_86,
  c3_.facebook AS facebook_87,
  c3_.twitter AS twitter_88,
  c3_.instagram AS instagram_89,
  c3_.mobile AS mobile_90,
  c3_.geocodable AS geocodable_91,
  c3_.x AS x_92,
  c3_.y AS y_93,
  c3_.idmultimedia AS idmultimedia_94,
  c3_.type_view AS type_view_95,
  c3_.stats_access AS stats_access_96,
  c3_.ga_tracking_id AS ga_tracking_id_97,
  c3_.is_festival AS is_festival_98,
  c3_.link_on_video AS link_on_video_99,
  c3_.is_partenaire AS is_partenaire_100,
  c3_.valid_version AS valid_version_101,
  c3_.other_versions AS other_versions_102,
  c3_.url_redirect AS url_redirect_103,
  c3_.url_clean AS url_clean_104,
  c3_.dateupdate AS dateupdate_105,
  c3_.dateinsert AS dateinsert_106,
  c3_.publish AS publish_107,
  c3_.valid AS valid_108,
  e4_.idextranetuser AS idextranetuser_109
FROM
  spectacles s0_
  LEFT JOIN typesspectacles t1_ ON s0_.idtypespectacle = t1_.idtypespectacle
  LEFT JOIN contacts c2_ ON s0_.idcontact_creation = c2_.idcontact
  LEFT JOIN contacts c3_ ON s0_.idcontact_production = c3_.idcontact
  LEFT JOIN extranetusers e4_ ON s0_.idextranetuser = e4_.idextranetuser
WHERE
  s0_.idspectacle = ?

SELECT s0_.idspectacle AS idspectacle_0, s0_.title AS title_1, s0_.language AS language_2, s0_.creation_date AS creation_date_3, s0_.url_page AS url_page_4, s0_.infos AS infos_5, s0_.tag AS tag_6, s0_.id_rubrique AS id_rubrique_7, s0_.duration AS duration_8, s0_.interlude AS interlude_9, s0_.textfictif AS textfictif_10, s0_.url_redirect AS url_redirect_11, s0_.url_clean AS url_clean_12, s0_.dateupdate AS dateupdate_13, s0_.dateinsert AS dateinsert_14, s0_.publish AS publish_15, s0_.statut AS statut_16, s0_.valid AS valid_17, t1_.idtypespectacle AS idtypespectacle_18, c2_.idcontact AS idcontact_19, c2_.type AS type_20, c2_.organisation AS organisation_21, c2_.nom_suite AS nom_suite_22, c2_.lastname AS lastname_23, c2_.firstname AS firstname_24, c2_.idtypestructure AS idtypestructure_25, c2_.license AS license_26, c2_.comment AS comment_27, c2_.private_comment AS private_comment_28, c2_.address1 AS address1_29, c2_.address2 AS address2_30, c2_.zip AS zip_31, c2_.city AS city_32, c2_.phone1 AS phone1_33, c2_.phone2 AS phone2_34, c2_.fax AS fax_35, c2_.email1 AS email1_36, c2_.email1_online AS email1_online_37, c2_.email2_online AS email2_online_38, c2_.email2 AS email2_39, c2_.url AS url_40, c2_.url_ticket AS url_ticket_41, c2_.facebook AS facebook_42, c2_.twitter AS twitter_43, c2_.instagram AS instagram_44, c2_.mobile AS mobile_45, c2_.geocodable AS geocodable_46, c2_.x AS x_47, c2_.y AS y_48, c2_.idmultimedia AS idmultimedia_49, c2_.type_view AS type_view_50, c2_.stats_access AS stats_access_51, c2_.ga_tracking_id AS ga_tracking_id_52, c2_.is_festival AS is_festival_53, c2_.link_on_video AS link_on_video_54, c2_.is_partenaire AS is_partenaire_55, c2_.valid_version AS valid_version_56, c2_.other_versions AS other_versions_57, c2_.url_redirect AS url_redirect_58, c2_.url_clean AS url_clean_59, c2_.dateupdate AS dateupdate_60, c2_.dateinsert AS dateinsert_61, c2_.publish AS publish_62, c2_.valid AS valid_63, c3_.idcontact AS idcontact_64, c3_.type AS type_65, c3_.organisation AS organisation_66, c3_.nom_suite AS nom_suite_67, c3_.lastname AS lastname_68, c3_.firstname AS firstname_69, c3_.idtypestructure AS idtypestructure_70, c3_.license AS license_71, c3_.comment AS comment_72, c3_.private_comment AS private_comment_73, c3_.address1 AS address1_74, c3_.address2 AS address2_75, c3_.zip AS zip_76, c3_.city AS city_77, c3_.phone1 AS phone1_78, c3_.phone2 AS phone2_79, c3_.fax AS fax_80, c3_.email1 AS email1_81, c3_.email1_online AS email1_online_82, c3_.email2_online AS email2_online_83, c3_.email2 AS email2_84, c3_.url AS url_85, c3_.url_ticket AS url_ticket_86, c3_.facebook AS facebook_87, c3_.twitter AS twitter_88, c3_.instagram AS instagram_89, c3_.mobile AS mobile_90, c3_.geocodable AS geocodable_91, c3_.x AS x_92, c3_.y AS y_93, c3_.idmultimedia AS idmultimedia_94, c3_.type_view AS type_view_95, c3_.stats_access AS stats_access_96, c3_.ga_tracking_id AS ga_tracking_id_97, c3_.is_festival AS is_festival_98, c3_.link_on_video AS link_on_video_99, c3_.is_partenaire AS is_partenaire_100, c3_.valid_version AS valid_version_101, c3_.other_versions AS other_versions_102, c3_.url_redirect AS url_redirect_103, c3_.url_clean AS url_clean_104, c3_.dateupdate AS dateupdate_105, c3_.dateinsert AS dateinsert_106, c3_.publish AS publish_107, c3_.valid AS valid_108, e4_.idextranetuser AS idextranetuser_109 FROM spectacles s0_ LEFT JOIN typesspectacles t1_ ON s0_.idtypespectacle = t1_.idtypespectacle LEFT JOIN contacts c2_ ON s0_.idcontact_creation = c2_.idcontact LEFT JOIN contacts c3_ ON s0_.idcontact_production = c3_.idcontact LEFT JOIN extranetusers e4_ ON s0_.idextranetuser = e4_.idextranetuser WHERE s0_.idspectacle = '31106';

SELECT
  t.title
FROM
  texts t,
  text_spectacle ts
WHERE
  t.idtext = ts.idtext
  AND ts.idspectacle = 31106

SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=31106;

SELECT
  lt.fr
FROM
  typesspectacles e,
  langterms lt
WHERE
  typespectacle = lt.id
  AND idtypespectacle = 4

SELECT lt.fr 
                    FROM typesspectacles e, langterms lt 
                    WHERE typespectacle=lt.id
                    AND idtypespectacle=4;

SELECT
  p.`idperson` as id,
  p.`idperson` as idperson,
  p.`lastname`,
  p.`firstname`,
  p.`url_clean`,
  p.`valid`,
  lt.`fr`,
  r.`idrole`,
  r.`role`,
  r.`type`,
  sp.`comment`,
  sp.`date_start`,
  sp.`date_end`
FROM
  persons p
  JOIN spectacle_person sp ON sp.`idperson` = p.`idperson`
  JOIN roles r ON r.`idrole` = sp.`idrole`
  JOIN langterms lt ON r.`role` = lt.`id`
WHERE
  sp.idspectacle = 31106
  AND r.type_creator = 1
ORDER BY
  sp.`classement`

SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`,
                        lt.`fr`,
                        r.`idrole`, r.`role`, r.`type`,
                        sp.`comment`,sp.`date_start`,sp.`date_end`
                        FROM persons p
                            JOIN spectacle_person sp ON sp.`idperson`=p.`idperson`
                            JOIN roles r ON r.`idrole`=sp.`idrole`
                            JOIN langterms lt ON r.`role`=lt.`id`
                        WHERE sp.idspectacle=31106  AND r.type_creator=1 ORDER BY sp.`classement` ;

SELECT
  p.`idperson` as id,
  p.`idperson` as idperson,
  p.`lastname`,
  p.`firstname`,
  p.`url_clean`,
  p.`valid`,
  lt.`fr`,
  r.`idrole`,
  r.`role`,
  r.`type`,
  sp.`comment`,
  sp.`date_start`,
  sp.`date_end`
FROM
  persons p
  JOIN spectacle_person sp ON sp.`idperson` = p.`idperson`
  JOIN roles r ON r.`idrole` = sp.`idrole`
  JOIN langterms lt ON r.`role` = lt.`id`
WHERE
  sp.idspectacle = 31106
  AND r.type_creator = 1
ORDER BY
  sp.`classement`

SELECT p.`idperson` as id, p.`idperson` as idperson, p.`lastname`, p.`firstname`, p.`url_clean`, p.`valid`,
                        lt.`fr`,
                        r.`idrole`, r.`role`, r.`type`,
                        sp.`comment`,sp.`date_start`,sp.`date_end`
                        FROM persons p
                            JOIN spectacle_person sp ON sp.`idperson`=p.`idperson`
                            JOIN roles r ON r.`idrole`=sp.`idrole`
                            JOIN langterms lt ON r.`role`=lt.`id`
                        WHERE sp.idspectacle=31106  AND r.type_creator=1 ORDER BY sp.`classement` ;

SELECT
  t.idtext,
  t.title,
  t.type,
  t.url_clean,
  t.textfictif
FROM
  texts t,
  text_spectacle ts
WHERE
  1
  AND ts.idspectacle = 31106
  AND t.idtext = ts.idtext

SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts
                WHERE 1
                AND ts.idspectacle=31106
                AND t.idtext=ts.idtext;

SELECT
  DISTINCT(cl.type)
FROM
  classifications cl
WHERE
  (
    (
      cl.classification IN ('class_affiche_spec')
    )
  )
  AND spectacles = 1

SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_affiche_spec'))) AND spectacles=1;

SELECT
  *
FROM
  object_file of,
  files f,
  file_classification fc,
  classifications cl,
  typesfiles tf
WHERE
  of.idfile = f.idfile
  AND f.idfile = fc.idfile
  AND of.idobject = '31106'
  AND of.object = 'spectacles'
  AND cl.idclassification = fc.idclassification
  AND (
    (
      cl.classification IN ('class_affiche_spec')
    )
  )
  AND f.idtype = tf.idtype
ORDER BY
  f.`range`,
  f.idfile

SELECT *
                FROM object_file of,
                     files f,
                     file_classification fc,
                     classifications cl,typesfiles tf
                   WHERE of.idfile=f.idfile
                   AND f.idfile=fc.idfile
                   AND of.idobject='31106'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_affiche_spec'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile;

SELECT
  DISTINCT(s.idschedule),
  s.note,
  s.url_spectacle,
  s.url_booking,
  s.idcontact_festival,
  s.hour,
  c.idcontact,
  c.organisation,
  c.phone1,
  c.phone2,
  c.city,
  c.url_clean,
  MIN(s.date) AS datedebut,
  ft.idcontact as festival_idcontact,
  ft.organisation as festival_organisation,
  ft.city as festival_city,
  ft.url_clean as festival_url_clean
FROM
  schedules s
  JOIN contacts c ON s.idcontact = c.idcontact
  LEFT JOIN contacts ft ON s.idcontact_festival = ft.idcontact
WHERE
  s.idspectacle = 31106
  AND s.date >= '2024-04-26'
GROUP BY
  c.idcontact
ORDER BY
  s.date ASC

SELECT DISTINCT(s.idschedule),s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,
                    c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean,MIN(s.date) AS datedebut,
                    ft.idcontact as festival_idcontact,ft.organisation as festival_organisation,ft.city as festival_city,ft.url_clean as festival_url_clean
                    FROM schedules s
                    JOIN contacts c ON s.idcontact=c.idcontact
                    LEFT JOIN contacts ft ON s.idcontact_festival=ft.idcontact
                    WHERE s.idspectacle=31106 AND s.date>='2024-04-26' GROUP BY c.idcontact ORDER BY s.date ASC;

SELECT
  DISTINCT(s.idschedule),
  s.note,
  s.url_spectacle,
  s.url_booking,
  s.idcontact_festival,
  s.hour,
  c.idcontact,
  c.organisation,
  c.phone1,
  c.phone2,
  c.city,
  c.url_clean,
  MIN(s.date) AS datedebut,
  ft.idcontact as festival_idcontact,
  ft.organisation as festival_organisation,
  ft.city as festival_city,
  ft.url_clean as festival_url_clean
FROM
  schedules s
  JOIN contacts c ON s.idcontact = c.idcontact
  LEFT JOIN contacts ft ON s.idcontact_festival = ft.idcontact
WHERE
  s.idspectacle = 31106
  AND s.date <= '2024-04-26'
GROUP BY
  c.idcontact
ORDER BY
  s.date DESC

SELECT DISTINCT(s.idschedule),s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,
                    c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean,MIN(s.date) AS datedebut,
                    ft.idcontact as festival_idcontact,ft.organisation as festival_organisation,ft.city as festival_city,ft.url_clean as festival_url_clean
                    FROM schedules s
                    JOIN contacts c ON s.idcontact=c.idcontact
                    LEFT JOIN contacts ft ON s.idcontact_festival=ft.idcontact
                    WHERE s.idspectacle=31106 AND s.date<='2024-04-26' GROUP BY c.idcontact ORDER BY s.date DESC;

SELECT
  DISTINCT(date),
  note,
  url_spectacle,
  url_booking,
  idextranetuser,
  publish,
  valid,
  is_cancelled
FROM
  schedules
WHERE
  idspectacle = 31106
  AND idcontact = 586
  AND date <= '2024-04-26'
ORDER BY
  date

SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=31106
                  AND idcontact=586  AND date<='2024-04-26'  ORDER BY date;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-09"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-09" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-10"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-10" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-11"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-11" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-12"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-12" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-13"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-13" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-16"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-16" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-17"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-17" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-18"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-18" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-19"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-19" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-20"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-20" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-23"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-23" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-24"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-24" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-25"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-25" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-26"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-26" AND idspectacle=31106 AND idcontact=586;

SELECT
  hour,
  note,
  url_spectacle,
  url_booking
FROM
  schedules
WHERE
  date = "2022-11-27"
  AND idspectacle = 31106
  AND idcontact = 586

SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-27" AND idspectacle=31106 AND idcontact=586;

SELECT
  DISTINCT(date),
  note,
  url_spectacle,
  url_booking,
  idextranetuser,
  publish,
  valid,
  is_cancelled
FROM
  schedules
WHERE
  idspectacle = 31106
  AND idcontact = 702
  AND date <= '2024-04-26'
ORDER BY
  date

SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=31106
                  AND idcontact=702  AND date<='2024-04-26'  ORDER BY date;