Symfony Profiler

Last 10 Latest Search
Settings
Query Metrics

176 Database Queries
131 Different statements
274.73 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts
Queries

Group similar statements

SELECT idspectacle FROM spectacles WHERE url_clean='Fugue'
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 t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=11727
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=11727  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=11727  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=11727
                AND t.idtext=ts.idtext
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='11727'
                   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(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_spip_accueil'))) AND spectacles=1
SELECT *
                FROM object_content oc,
                     contents c,
                     content_classification cc,
                     classifications cl
                   WHERE oc.idcontent=c.idcontent
                   AND c.idcontent=cc.idcontent
                   AND oc.idobject='11727'
                   AND oc.object='spectacles'
                   AND cl.idclassification=cc.idclassification AND ((cl.classification IN ('class_spip_accueil'))) ORDER BY c.`range`,c.idcontent
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_production'))) AND spectacles=1
SELECT *
                FROM object_content oc,
                     contents c,
                     content_classification cc,
                     classifications cl
                   WHERE oc.idcontent=c.idcontent
                   AND c.idcontent=cc.idcontent
                   AND oc.idobject='11727'
                   AND oc.object='spectacles'
                   AND cl.idclassification=cc.idclassification AND ((cl.classification IN ('class_production'))) ORDER BY c.`range`,c.idcontent
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=56278
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=11727  AND sp.idrole=5 ORDER BY p.`lastname`
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=11727 AND s.date>='2024-03-29' GROUP BY c.idcontact ORDER BY s.date ASC LIMIT 0,3
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=11727 AND s.date<='2024-03-29' GROUP BY c.idcontact ORDER BY s.date DESC LIMIT 0,1
SELECT DISTINCT(date), note, is_cancelled, url_spectacle, url_booking, idextranetuser, publish, valid
                  FROM schedules 
                  WHERE idspectacle=11727
                  AND idcontact=6322  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2017-05-18" AND idspectacle=11727 AND idcontact=6322
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2017-05-19" AND idspectacle=11727 AND idcontact=6322
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2017-05-20" AND idspectacle=11727 AND idcontact=6322
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=11727 GROUP BY c.idcontact ORDER BY s.date  LIMIT 0,1
SELECT DISTINCT(date), note, is_cancelled, url_spectacle, url_booking, idextranetuser, publish, valid
                  FROM schedules 
                  WHERE idspectacle=11727
                  AND idcontact=547  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2015-05-29" AND idspectacle=11727 AND idcontact=547
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2015-05-30" AND idspectacle=11727 AND idcontact=547
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2015-06-01" AND idspectacle=11727 AND idcontact=547
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2016-03-14" AND idspectacle=11727 AND idcontact=547
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2016-03-15" AND idspectacle=11727 AND idcontact=547
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2016-03-16" AND idspectacle=11727 AND idcontact=547
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_presentation_spectacle'))) AND spectacles=1
SELECT *
                FROM object_content oc,
                     contents c,
                     content_classification cc,
                     classifications cl
                   WHERE oc.idcontent=c.idcontent
                   AND c.idcontent=cc.idcontent
                   AND oc.idobject='11727'
                   AND oc.object='spectacles'
                   AND cl.idclassification=cc.idclassification AND ((cl.classification IN ('class_presentation_spectacle'))) ORDER BY c.`range`,c.idcontent
SELECT c.title,c.idcontent,c.language,c.deck,c.text,c.display_media, c.markdown
                    FROM object_content oc, contents c, content_classification cc
                       WHERE oc.idcontent=c.idcontent
                       AND cc.idcontent=c.idcontent
                       AND cc.idclassification=6
                       AND oc.idobject='11727'
                       AND oc.object='spectacles'
                       ORDER BY c.`range`,c.dateinsert ASC LIMIT 0,1
SELECT c.`idcontact`, c.`organisation`, c.`lastname`, c.`firstname`, c.`url`, c.`url_clean`, c.`valid`
                    FROM contacts c
                    JOIN spectacle_contact sc ON sc.`idcontact`=c.`idcontact`
                    WHERE sc.`idspectacle`=11727
                    AND sc.`idrole` IN (17)
                    ORDER BY c.`organisation`
SELECT c.`idcontact`, c.`organisation`, c.`lastname`, c.`firstname`, c.`url`, c.`url_clean`, c.`valid`
                    FROM contacts c
                    JOIN spectacle_contact sc ON sc.`idcontact`=c.`idcontact`
                    WHERE sc.`idspectacle`=11727
                    AND sc.`idrole` IN (18)
                    ORDER BY c.`organisation`
SELECT c.`idcontact`, c.`organisation`, c.`lastname`, c.`firstname`, c.`url`, c.`url_clean`, c.`valid`
                    FROM contacts c
                    JOIN spectacle_contact sc ON sc.`idcontact`=c.`idcontact`
                    WHERE sc.`idspectacle`=11727
                    AND sc.`idrole` IN (19)
                    ORDER BY c.`organisation`
SELECT c.`idcontact`, c.`organisation`, c.`lastname`, c.`firstname`, c.`url`, c.`url_clean`, c.`valid`
                    FROM contacts c
                    JOIN spectacle_contact sc ON sc.`idcontact`=c.`idcontact`
                    WHERE sc.`idspectacle`=11727
                    AND sc.`idrole` IN (77)
                    ORDER BY c.`organisation`
SELECT c.`idcontact`, c.`organisation`, c.`lastname`, c.`firstname`, c.`url`, c.`url_clean`, c.`valid`
                    FROM contacts c
                    JOIN spectacle_contact sc ON sc.`idcontact`=c.`idcontact`
                    WHERE sc.`idspectacle`=11727
                    AND sc.`idrole` IN (77)
                    ORDER BY c.`organisation`
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=11727  AND r.type=1 ORDER BY p.`lastname`
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_distribution'))) AND spectacles=1
SELECT *
                FROM object_content oc,
                     contents c,
                     content_classification cc,
                     classifications cl
                   WHERE oc.idcontent=c.idcontent
                   AND c.idcontent=cc.idcontent
                   AND oc.idobject='11727'
                   AND oc.object='spectacles'
                   AND cl.idclassification=cc.idclassification AND ((cl.classification IN ('class_distribution'))) ORDER BY c.`range`,c.idcontent
SELECT c.title,c.idcontent,c.link,c.writer_group,c.writer,c.date_article,c.writer_group_url,c.dateinsert,
            oc.idclassification as group_idclassification, cloc.classification as group_classification,
            c.is_link,c.deck,c.idextranetuser,c.display_media,c.language,cl.classification,cl.idclassification,e.login FROM contents c
                    LEFT JOIN extranetusers e ON c.idextranetuser=e.idextranetuser
                    , content_classification cc, classifications cl, object_content oc
                    LEFT JOIN classifications cloc ON oc.idclassification=cloc.idclassification  WHERE oc.idcontent=c.idcontent
                   AND cc.idcontent=c.idcontent
                   AND cc.idclassification=cl.idclassification
                   AND oc.object='spectacles'  AND c.publish=1 AND oc.idobject=11727 AND cl.classification='class_extrait_spec'  ORDER BY c.`range`,c.dateinsert ASC LIMIT 0,10
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=63202
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='63202'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT fr FROM languages WHERE id='fr'
SELECT c.*, cl.classification, c.`range` as `range`, e.idextranetuser, e.login
                FROM contents c
                    LEFT JOIN extranetusers e ON c.idextranetuser=e.idextranetuser, classifications cl, content_classification cc
                WHERE cc.idcontent=c.idcontent AND cc.idclassification=cl.idclassification
                AND c.idcontent=63202
SELECT j1.idcontact,j1.organisation,j1.url,j1.type,j1.city ,j3.idcontent FROM theatreok_dev.contacts j1, theatreok_dev.content_contact j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idcontact=j2.idcontact
                        AND j3.idcontent=63202
SELECT j1.idperson,j1.lastname,j1.firstname ,j3.idcontent FROM theatreok_dev.persons j1, theatreok_dev.content_person j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idperson=j2.idperson
                        AND j3.idcontent=63202
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=63202
SELECT fr FROM languages WHERE id='fr'
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='63202'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT *
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=63202
                AND om.object='contents'
                AND m.publish=1
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=7213
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
SELECT fichier FROM content_template dbo_tpl, templates tpl
                WHERE dbo_tpl.idtemplate=tpl.idtemplate
                AND dbo_tpl.idcontent=63202
SELECT c.title,c.idcontent,c.link,c.writer_group,c.writer,c.date_article,c.writer_group_url,c.dateinsert,
            oc.idclassification as group_idclassification, cloc.classification as group_classification,
            c.is_link,c.deck,c.idextranetuser,c.display_media,c.language,cl.classification,cl.idclassification,e.login FROM contents c
                    LEFT JOIN extranetusers e ON c.idextranetuser=e.idextranetuser
                    , content_classification cc, classifications cl, object_content oc
                    LEFT JOIN classifications cloc ON oc.idclassification=cloc.idclassification  WHERE oc.idcontent=c.idcontent
                   AND cc.idcontent=c.idcontent
                   AND cc.idclassification=cl.idclassification
                   AND oc.object='spectacles'  AND c.publish=1 AND oc.idobject=11727 AND cl.classification='class_critique'  ORDER BY c.`date_article` DESC LIMIT 0,10
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=65276
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='65276'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=64847
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='64847'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=65086
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='65086'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=64681
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='64681'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=64678
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='64678'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=64679
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='64679'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=65084
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='65084'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=65087
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='65087'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=64392
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='64392'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=63696
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='63696'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
SELECT fr FROM languages WHERE id='fr'
SELECT fr FROM languages WHERE id='fr'
SELECT fr FROM languages WHERE id='fr'
SELECT fr FROM languages WHERE id='fr'
SELECT fr FROM languages WHERE id='fr'
SELECT fr FROM languages WHERE id='fr'
SELECT fr FROM languages WHERE id='fr'
SELECT fr FROM languages WHERE id='fr'
SELECT fr FROM languages WHERE id='fr'
SELECT fr FROM languages WHERE id='fr'
SELECT c.*, cl.classification, c.`range` as `range`, e.idextranetuser, e.login
                FROM contents c
                    LEFT JOIN extranetusers e ON c.idextranetuser=e.idextranetuser, classifications cl, content_classification cc
                WHERE cc.idcontent=c.idcontent AND cc.idclassification=cl.idclassification
                AND c.idcontent=65276
SELECT j1.idcontact,j1.organisation,j1.url,j1.type,j1.city ,j3.idcontent FROM theatreok_dev.contacts j1, theatreok_dev.content_contact j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idcontact=j2.idcontact
                        AND j3.idcontent=65276
SELECT j1.idperson,j1.lastname,j1.firstname ,j3.idcontent FROM theatreok_dev.persons j1, theatreok_dev.content_person j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idperson=j2.idperson
                        AND j3.idcontent=65276
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=65276
SELECT fr FROM languages WHERE id='fr'
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='65276'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT classification
                            FROM classifications
                            WHERE idclassification=22
SELECT fichier FROM content_template dbo_tpl, templates tpl
                WHERE dbo_tpl.idtemplate=tpl.idtemplate
                AND dbo_tpl.idcontent=65276
SELECT  DISTINCT(aides.idaide), aides.* 
FROM  `contacts` ,
 `spectacle_aide` ,
 `aides`  
 WHERE 1  AND aides.`publish`=1  AND spectacle_aide.`idspectacle`=11727 AND aides.`idcontact`=contacts.`idcontact` AND aides.`idaide`=spectacle_aide.`idaide` 
GROUP BY aides.idaide 
ORDER BY aides.dateinsert 
DESC 
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
                            INNER JOIN contacts T4 ON T4.idcontact=T3.idcontact  LEFT JOIN new_spectacle T5 ON T5.idnew=T1.idnew  WHERE 1  AND (T5.idspectacle=11727 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND (( T3.date>='2024-03-29' ))  GROUP BY T1.idnew  ORDER BY T3.date ASC LIMIT 0,5
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
                            INNER JOIN contacts T4 ON T4.idcontact=T3.idcontact  LEFT JOIN new_spectacle T5 ON T5.idnew=T1.idnew  WHERE 1  AND (T5.idspectacle=11727 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND (( T3.date<'2024-03-29' ))  GROUP BY T1.idnew  ORDER BY T3.date DESC LIMIT 0,5
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 url_file FROM news WHERE idnew=6195
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=6195 AND sc.date<'2024-03-29'  ORDER BY sc.date DESC 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=6195 AND sc.date<'2024-03-29'  AND sc.idcontact=14298 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=6195
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=6195
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=6195
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=7228
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=9862
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=11701
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=11707
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=11727
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=11736
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=14257
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=14258
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=14262
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=6195
SELECT  DISTINCT(podcasts.idpodcast), podcasts.* 
FROM  `podcast_spectacle` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_spectacle.`idspectacle` IN (11727)  AND podcasts.`code_ft` IS NOT NULL AND podcasts.`debut_visionnage_ft`<='2024-03-29' AND podcasts.`fin_visionnage_ft`>'2024-03-29' AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`idpodcast`=podcast_spectacle.`idpodcast` 
GROUP BY podcasts.idpodcast 
ORDER BY podcasts.`date_podcast` 
DESC 
LIMIT 0,1
SELECT  DISTINCT(podcasts.idpodcast), podcasts.* 
FROM  `podcast_spectacle` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_spectacle.`idspectacle` IN (11727)  AND podcasts.`code_ft` IS NOT NULL AND podcasts.`debut_visionnage_ft`<='2024-03-29' AND podcasts.`fin_visionnage_ft`>'2024-03-29'  AND podcasts.`type_diffusion`=1 AND podcasts.`idpodcast`=podcast_spectacle.`idpodcast` 
GROUP BY podcasts.idpodcast 
ORDER BY podcasts.`date_podcast` 
DESC 
LIMIT 0,1
SELECT  DISTINCT(podcasts.idpodcast), podcasts.* 
FROM  `podcast_spectacle` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_spectacle.`idspectacle`=11727  AND ( `podcasts`.`code_franceinter` IS NOT NULL  OR `podcasts`.`code_soundcloud` IS NOT NULL ) AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`idpodcast`=podcast_spectacle.`idpodcast` 
GROUP BY podcasts.idpodcast 
ORDER BY podcasts.`date_podcast` 
DESC 
LIMIT 0,1
SELECT  COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* 
FROM  `podcast_spectacle` ,
 `podcasts`  
 WHERE 1  AND podcasts.`publish`=1  AND podcast_spectacle.`idspectacle`=11727  AND ( `podcasts`.`code_franceinter` IS NOT NULL  OR `podcasts`.`code_soundcloud` IS NOT NULL ) AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`idpodcast`=podcast_spectacle.`idpodcast` 
LIMIT 0,1
SELECT  DISTINCT(dvds.iddvd), dvds.* 
FROM  `dvd_spectacle` ,
 `dvds`  
 WHERE 1  AND dvds.`publish`=1  AND dvd_spectacle.`idspectacle` IN (11727) AND dvds.`iddvd`=dvd_spectacle.`iddvd` 
GROUP BY dvds.iddvd 
ORDER BY dvds.dateinsert 
DESC 
LIMIT 0,1
SELECT  DISTINCT(dvds.iddvd), dvds.* 
FROM  `dvd_spectacle` ,
 `dvds`  
 WHERE 1  AND dvds.`publish`=1  AND dvd_spectacle.`idspectacle` IN (11727) AND dvds.`iddvd`=dvd_spectacle.`iddvd` 
GROUP BY dvds.iddvd 
ORDER BY dvds.dateinsert 
DESC 
LIMIT 0,1
SELECT  spectacle_aide.*,aides.*,`spectacle_aide`.`publish` as spectacle_aide_publish 
FROM  `aides` ,
 `spectacle_aide`  
 WHERE 1  AND spectacle_aide.`publish`=1  AND aides.`publish`=1  AND aides.`type_aide` IN (2,3)  AND spectacle_aide.`idspectacle`=11727 AND aides.`idaide`=spectacle_aide.`idaide` 
  
ORDER BY spectacle_aide.`date_start` 
DESC 
LIMIT 0,10
SELECT  spectacle_aide.*,aides.*,`spectacle_aide`.`publish` as spectacle_aide_publish 
FROM  `aides` ,
 `spectacle_aide`  
 WHERE 1  AND spectacle_aide.`publish`=1  AND aides.`publish`=1  AND aides.`type_aide` IN (4)  AND spectacle_aide.`idspectacle`=11727 AND aides.`idaide`=spectacle_aide.`idaide` 
  
ORDER BY spectacle_aide.`date_start` 
DESC 
LIMIT 0,10
SELECT t.`idtext`,t.`title`,t.`date`,t.`type`,t.`language`,t.`country`,t.`idcontact_publisher`,t.`isbn`,t.`ean`,t.`publication_year`,t.`nbpages`,t.`idgenretext`,t.`textorder`,t.`url_clean`,contacts.`organisation`, contacts.`url_clean` as url_clean_publisher 
                        FROM text_traduction tt, texts t
                            LEFT JOIN contacts ON contacts.idcontact=t.idcontact_publisher
                        WHERE 1
                        AND t.idtext=tt.idtexttraduction
                        AND tt.idtext=15326
                        AND t.type=1 AND t.publish=1 AND t.textfictif=0 GROUP BY t.idtext ORDER BY date DESC
SELECT DISTINCT t0_.idtext AS idtext_0 FROM texts t1_ INNER JOIN text_adaptation t2_ ON t1_.idtext = t2_.idtextadaptation INNER JOIN texts t0_ ON t0_.idtext = t2_.idtext WHERE t1_.idtext = 15326
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, s2_.idspectacle AS idspectacle_2, s2_.title AS title_3, s2_.language AS language_4, s2_.creation_date AS creation_date_5, s2_.url_page AS url_page_6, s2_.infos AS infos_7, s2_.tag AS tag_8, s2_.id_rubrique AS id_rubrique_9, s2_.duration AS duration_10, s2_.interlude AS interlude_11, s2_.textfictif AS textfictif_12, s2_.url_redirect AS url_redirect_13, s2_.url_clean AS url_clean_14, s2_.dateupdate AS dateupdate_15, s2_.dateinsert AS dateinsert_16, s2_.publish AS publish_17, s2_.statut AS statut_18, s2_.valid AS valid_19, t1_.idtext AS idtext_20, t1_.type AS type_21, t1_.idtypetext AS idtypetext_22, t1_.special_text AS special_text_23, t1_.title AS title_24, t1_.subtitle AS subtitle_25, t1_.date AS date_26, t1_.language AS language_27, t1_.markdown AS markdown_28, t1_.abstract AS abstract_29, t1_.abstract_author AS abstract_author_30, t1_.abstract_date AS abstract_date_31, t1_.abstract_url AS abstract_url_32, t1_.publisher_url_text AS publisher_url_text_33, t1_.publication_year AS publication_year_34, t1_.publication_month AS publication_month_35, t1_.isbn AS isbn_36, t1_.ean AS ean_37, t1_.publishinfos AS publishinfos_38, t1_.urltextaccess AS urltextaccess_39, t1_.emailtextaccess AS emailtextaccess_40, t1_.idfiletextaccess AS idfiletextaccess_41, t1_.filetextaccesssave AS filetextaccesssave_42, t1_.textaccessmore AS textaccessmore_43, t1_.request_translation_text AS request_translation_text_44, t1_.request_performing_text AS request_performing_text_45, t1_.help_translation AS help_translation_46, t1_.help_publishing AS help_publishing_47, t1_.help_other AS help_other_48, t1_.moreinfo AS moreinfo_49, t1_.nmale AS nmale_50, t1_.nfemale AS nfemale_51, t1_.npeople AS npeople_52, t1_.textorder AS textorder_53, t1_.nbpages AS nbpages_54, t1_.price AS price_55, t1_.selection_aneth AS selection_aneth_56, t1_.idtext_aneth AS idtext_aneth_57, t1_.aide_creation AS aide_creation_58, t1_.comments AS comments_59, t1_.url_clean AS url_clean_60, t1_.textfictif AS textfictif_61, t1_.valid_opendata AS valid_opendata_62, t1_.dateupdate AS dateupdate_63, t1_.dateinsert AS dateinsert_64, t1_.publish AS publish_65, t1_.statut AS statut_66, t1_.valid AS valid_67, t3_.idtypespectacle AS idtypespectacle_68 FROM spectacles s2_ LEFT JOIN text_spectacle t4_ ON s2_.idspectacle = t4_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t4_.idtext LEFT JOIN typesspectacles t3_ ON s2_.idtypespectacle = t3_.idtypespectacle LEFT JOIN schedules s0_ ON s2_.idspectacle = s0_.idspectacle LEFT JOIN text_spectacle t6_ ON s2_.idspectacle = t6_.idspectacle LEFT JOIN texts t5_ ON t5_.idtext = t6_.idtext LEFT JOIN spectacle_person s8_ ON s2_.idspectacle = s8_.idspectacle LEFT JOIN persons p7_ ON p7_.idperson = s8_.idperson INNER JOIN contacts c9_ ON s0_.idcontact = c9_.idcontact WHERE s2_.idspectacle NOT IN (11727) AND s0_.date >= '2024-03-29' AND (s2_.publish = 1 AND t1_.idtext = 15326) GROUP BY s2_.idspectacle ORDER BY s0_.date ASC LIMIT 4
SELECT t.`idtext`,t.`title`,t.`date`,t.`type`,t.`language`,t.`country`,t.`idcontact_publisher`,t.`isbn`,t.`ean`,t.`publication_year`,t.`nbpages`,t.`idgenretext`,t.`textorder`,t.`url_clean`,contacts.`organisation`, contacts.`url_clean` as url_clean_publisher 
                        FROM text_traduction tt, texts t
                            LEFT JOIN contacts ON contacts.idcontact=t.idcontact_publisher
                        WHERE 1
                        AND t.idtext=tt.idtexttraduction
                        AND tt.idtext=15326
                        AND t.type=1 AND t.publish=1 AND t.textfictif=0 GROUP BY t.idtext ORDER BY date DESC
SELECT DISTINCT t0_.idtext AS idtext_0 FROM texts t1_ INNER JOIN text_adaptation t2_ ON t1_.idtext = t2_.idtextadaptation INNER JOIN texts t0_ ON t0_.idtext = t2_.idtext WHERE t1_.idtext = 15326
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, s2_.idspectacle AS idspectacle_2, s2_.title AS title_3, s2_.language AS language_4, s2_.creation_date AS creation_date_5, s2_.url_page AS url_page_6, s2_.infos AS infos_7, s2_.tag AS tag_8, s2_.id_rubrique AS id_rubrique_9, s2_.duration AS duration_10, s2_.interlude AS interlude_11, s2_.textfictif AS textfictif_12, s2_.url_redirect AS url_redirect_13, s2_.url_clean AS url_clean_14, s2_.dateupdate AS dateupdate_15, s2_.dateinsert AS dateinsert_16, s2_.publish AS publish_17, s2_.statut AS statut_18, s2_.valid AS valid_19, t1_.idtext AS idtext_20, t1_.type AS type_21, t1_.idtypetext AS idtypetext_22, t1_.special_text AS special_text_23, t1_.title AS title_24, t1_.subtitle AS subtitle_25, t1_.date AS date_26, t1_.language AS language_27, t1_.markdown AS markdown_28, t1_.abstract AS abstract_29, t1_.abstract_author AS abstract_author_30, t1_.abstract_date AS abstract_date_31, t1_.abstract_url AS abstract_url_32, t1_.publisher_url_text AS publisher_url_text_33, t1_.publication_year AS publication_year_34, t1_.publication_month AS publication_month_35, t1_.isbn AS isbn_36, t1_.ean AS ean_37, t1_.publishinfos AS publishinfos_38, t1_.urltextaccess AS urltextaccess_39, t1_.emailtextaccess AS emailtextaccess_40, t1_.idfiletextaccess AS idfiletextaccess_41, t1_.filetextaccesssave AS filetextaccesssave_42, t1_.textaccessmore AS textaccessmore_43, t1_.request_translation_text AS request_translation_text_44, t1_.request_performing_text AS request_performing_text_45, t1_.help_translation AS help_translation_46, t1_.help_publishing AS help_publishing_47, t1_.help_other AS help_other_48, t1_.moreinfo AS moreinfo_49, t1_.nmale AS nmale_50, t1_.nfemale AS nfemale_51, t1_.npeople AS npeople_52, t1_.textorder AS textorder_53, t1_.nbpages AS nbpages_54, t1_.price AS price_55, t1_.selection_aneth AS selection_aneth_56, t1_.idtext_aneth AS idtext_aneth_57, t1_.aide_creation AS aide_creation_58, t1_.comments AS comments_59, t1_.url_clean AS url_clean_60, t1_.textfictif AS textfictif_61, t1_.valid_opendata AS valid_opendata_62, t1_.dateupdate AS dateupdate_63, t1_.dateinsert AS dateinsert_64, t1_.publish AS publish_65, t1_.statut AS statut_66, t1_.valid AS valid_67, t3_.idtypespectacle AS idtypespectacle_68 FROM spectacles s2_ LEFT JOIN text_spectacle t4_ ON s2_.idspectacle = t4_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t4_.idtext LEFT JOIN typesspectacles t3_ ON s2_.idtypespectacle = t3_.idtypespectacle LEFT JOIN schedules s0_ ON s2_.idspectacle = s0_.idspectacle LEFT JOIN text_spectacle t6_ ON s2_.idspectacle = t6_.idspectacle LEFT JOIN texts t5_ ON t5_.idtext = t6_.idtext LEFT JOIN spectacle_person s8_ ON s2_.idspectacle = s8_.idspectacle LEFT JOIN persons p7_ ON p7_.idperson = s8_.idperson INNER JOIN contacts c9_ ON s0_.idcontact = c9_.idcontact WHERE s2_.idspectacle NOT IN (11727) AND (s2_.publish = 1 AND t1_.idtext = 15326) GROUP BY s2_.idspectacle ORDER BY sclr_0 DESC LIMIT 6
SELECT COUNT(DISTINCT(p.`idplaylist`)) as total
                FROM playlists p
                    LEFT JOIN playlist_classification pc ON pc.`idplaylist`=p.`idplaylist`
                    LEFT JOIN classifications c ON pc.`idclassification`=c.`idclassification`
                WHERE p.`publish`=1
                AND p.`idtext` IN ('15326')  AND c.`classification`='class_texte_parauteur'
SELECT t.`idtext`,t.`title`,t.`date`,t.`type`,t.`language`,t.`country`,t.`idcontact_publisher`,t.`isbn`,t.`ean`,t.`publication_year`,t.`nbpages`,t.`idgenretext`,t.`textorder`,t.`url_clean`,contacts.`organisation`, contacts.`url_clean` as url_clean_publisher 
                        FROM text_traduction tt, texts t
                            LEFT JOIN contacts ON contacts.idcontact=t.idcontact_publisher
                        WHERE 1
                        AND t.idtext=tt.idtexttraduction
                        AND tt.idtext=15326
                        AND t.type=1 AND t.publish=1 AND t.textfictif=0 GROUP BY t.idtext ORDER BY date DESC
SELECT DISTINCT t0_.idtext AS idtext_0 FROM texts t1_ INNER JOIN text_adaptation t2_ ON t1_.idtext = t2_.idtextadaptation INNER JOIN texts t0_ ON t0_.idtext = t2_.idtext WHERE t1_.idtext = 15326
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, s2_.idspectacle AS idspectacle_2, s2_.title AS title_3, s2_.language AS language_4, s2_.creation_date AS creation_date_5, s2_.url_page AS url_page_6, s2_.infos AS infos_7, s2_.tag AS tag_8, s2_.id_rubrique AS id_rubrique_9, s2_.duration AS duration_10, s2_.interlude AS interlude_11, s2_.textfictif AS textfictif_12, s2_.url_redirect AS url_redirect_13, s2_.url_clean AS url_clean_14, s2_.dateupdate AS dateupdate_15, s2_.dateinsert AS dateinsert_16, s2_.publish AS publish_17, s2_.statut AS statut_18, s2_.valid AS valid_19, t1_.idtext AS idtext_20, t1_.type AS type_21, t1_.idtypetext AS idtypetext_22, t1_.special_text AS special_text_23, t1_.title AS title_24, t1_.subtitle AS subtitle_25, t1_.date AS date_26, t1_.language AS language_27, t1_.markdown AS markdown_28, t1_.abstract AS abstract_29, t1_.abstract_author AS abstract_author_30, t1_.abstract_date AS abstract_date_31, t1_.abstract_url AS abstract_url_32, t1_.publisher_url_text AS publisher_url_text_33, t1_.publication_year AS publication_year_34, t1_.publication_month AS publication_month_35, t1_.isbn AS isbn_36, t1_.ean AS ean_37, t1_.publishinfos AS publishinfos_38, t1_.urltextaccess AS urltextaccess_39, t1_.emailtextaccess AS emailtextaccess_40, t1_.idfiletextaccess AS idfiletextaccess_41, t1_.filetextaccesssave AS filetextaccesssave_42, t1_.textaccessmore AS textaccessmore_43, t1_.request_translation_text AS request_translation_text_44, t1_.request_performing_text AS request_performing_text_45, t1_.help_translation AS help_translation_46, t1_.help_publishing AS help_publishing_47, t1_.help_other AS help_other_48, t1_.moreinfo AS moreinfo_49, t1_.nmale AS nmale_50, t1_.nfemale AS nfemale_51, t1_.npeople AS npeople_52, t1_.textorder AS textorder_53, t1_.nbpages AS nbpages_54, t1_.price AS price_55, t1_.selection_aneth AS selection_aneth_56, t1_.idtext_aneth AS idtext_aneth_57, t1_.aide_creation AS aide_creation_58, t1_.comments AS comments_59, t1_.url_clean AS url_clean_60, t1_.textfictif AS textfictif_61, t1_.valid_opendata AS valid_opendata_62, t1_.dateupdate AS dateupdate_63, t1_.dateinsert AS dateinsert_64, t1_.publish AS publish_65, t1_.statut AS statut_66, t1_.valid AS valid_67, t3_.idtypespectacle AS idtypespectacle_68 FROM spectacles s2_ LEFT JOIN text_spectacle t4_ ON s2_.idspectacle = t4_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t4_.idtext LEFT JOIN typesspectacles t3_ ON s2_.idtypespectacle = t3_.idtypespectacle LEFT JOIN schedules s0_ ON s2_.idspectacle = s0_.idspectacle LEFT JOIN text_spectacle t6_ ON s2_.idspectacle = t6_.idspectacle LEFT JOIN texts t5_ ON t5_.idtext = t6_.idtext LEFT JOIN spectacle_person s8_ ON s2_.idspectacle = s8_.idspectacle LEFT JOIN persons p7_ ON p7_.idperson = s8_.idperson INNER JOIN contacts c9_ ON s0_.idcontact = c9_.idcontact LEFT JOIN spectacle_aide s10_ ON s2_.idspectacle = s10_.idspectacle AND (s10_.idspectacle = s2_.idspectacle) INNER JOIN aides a11_ ON s10_.idaide = a11_.idaide WHERE s10_.idaide = a11_.idaide AND a11_.idcontact IN (28366) AND (s2_.publish = 1 AND t1_.idtext = 15326) GROUP BY s2_.idspectacle ORDER BY sclr_0 DESC LIMIT 4
SELECT c.title,c.idcontent,c.link,c.writer_group,c.writer,c.date_article,c.writer_group_url,c.dateinsert,
            oc.idclassification as group_idclassification, cloc.classification as group_classification,
            c.is_link,c.deck,c.idextranetuser,c.display_media,c.language,cl.classification,cl.idclassification,e.login FROM contents c
                    LEFT JOIN extranetusers e ON c.idextranetuser=e.idextranetuser
                    , content_classification cc, classifications cl, object_content oc
                    LEFT JOIN classifications cloc ON oc.idclassification=cloc.idclassification  WHERE oc.idcontent=c.idcontent
                   AND cc.idcontent=c.idcontent
                   AND cc.idclassification=cl.idclassification
                   AND oc.object='spectacles'  AND c.publish=1 AND oc.idobject=11727 AND cl.classification='class_article'  ORDER BY c.`range`,c.dateinsert ASC LIMIT 3
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=56279
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='56279'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT fr FROM languages WHERE id='fr'
SELECT c.*, cl.classification, c.`range` as `range`, e.idextranetuser, e.login
                FROM contents c
                    LEFT JOIN extranetusers e ON c.idextranetuser=e.idextranetuser, classifications cl, content_classification cc
                WHERE cc.idcontent=c.idcontent AND cc.idclassification=cl.idclassification
                AND c.idcontent=56279
SELECT j1.idcontact,j1.organisation,j1.url,j1.type,j1.city ,j3.idcontent FROM theatreok_dev.contacts j1, theatreok_dev.content_contact j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idcontact=j2.idcontact
                        AND j3.idcontent=56279
SELECT j1.idperson,j1.lastname,j1.firstname ,j3.idcontent FROM theatreok_dev.persons j1, theatreok_dev.content_person j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idperson=j2.idperson
                        AND j3.idcontent=56279
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3
                        WHERE j3.idcontent=j2.idcontent
                        AND j1.idclassification=j2.idclassification
                        AND j3.idcontent=56279
SELECT fr FROM languages WHERE id='fr'
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='56279'
                   AND of.object='contents'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND 1 AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT fichier FROM content_template dbo_tpl, templates tpl
                WHERE dbo_tpl.idtemplate=tpl.idtemplate
                AND dbo_tpl.idcontent=56279
SELECT COUNT(DISTINCT(c.idcontent))  FROM contents c
                    LEFT JOIN extranetusers e ON c.idextranetuser=e.idextranetuser
                    , content_classification cc, classifications cl, object_content oc
                    LEFT JOIN classifications cloc ON oc.idclassification=cloc.idclassification  WHERE oc.idcontent=c.idcontent
                   AND cc.idcontent=c.idcontent
                   AND cc.idclassification=cl.idclassification
                   AND oc.object='spectacles'  AND c.publish=1 AND oc.idobject=11727 AND cl.classification='class_article'  ORDER BY c.`range`,c.dateinsert ASC LIMIT 0,10
SELECT  spectacle_aide.*,aides.*,`spectacle_aide`.`publish` as spectacle_aide_publish 
FROM  `aides` ,
 `spectacle_aide`  
 WHERE 1  AND spectacle_aide.`publish`=1  AND aides.`publish`=1  AND aides.`type_aide` IN (2,3)  AND spectacle_aide.`idspectacle`=11727 AND aides.`idaide`=spectacle_aide.`idaide` 
  
ORDER BY spectacle_aide.`date_start` 
DESC 
LIMIT 0,10
SELECT  spectacle_aide.*,aides.*,`spectacle_aide`.`publish` as spectacle_aide_publish 
FROM  `aides` ,
 `spectacle_aide`  
 WHERE 1  AND spectacle_aide.`publish`=1  AND aides.`publish`=1  AND aides.`type_aide` IN (4)  AND spectacle_aide.`idspectacle`=11727 AND aides.`idaide`=spectacle_aide.`idaide` 
  
ORDER BY spectacle_aide.`date_start` 
DESC 
LIMIT 0,10
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_critique'))) AND spectacles=1
SELECT COUNT(DISTINCT(oc.idcontent)) as total
                FROM object_content oc,
                     contents c,
                     content_classification cc,
                     classifications cl
                   WHERE oc.idcontent=c.idcontent
                   AND c.idcontent=cc.idcontent
                   AND oc.idobject='11727'
                   AND oc.object='spectacles'
                   AND cl.idclassification=cc.idclassification AND c.publish=1 AND c.publish=1 AND c.valid=1  AND ((cl.classification IN ('class_critique')))
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
                            INNER JOIN contacts T4 ON T4.idcontact=T3.idcontact  LEFT JOIN new_spectacle T5 ON T5.idnew=T1.idnew  WHERE 1  AND (T5.idspectacle=11727 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=11727
                AND om.object='spectacles'
                AND m.publish=1
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total
                FROM podcasts d, podcast_spectacle do
                WHERE d.`publish`=1
                AND do.`idpodcast`= d.`idpodcast` AND do.`idspectacle`=11727 AND d.code_franceinter IS NOT NULL
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
SELECT COUNT(DISTINCT(of.idfile)) as total
                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='11727'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.idclassification IN (33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
SELECT oc.idcontent
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=11727 AND cc.idclassification=6 LIMIT 1
SELECT oc.idcontent
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=11727 AND cc.idclassification=6 LIMIT 1
SELECT oc.idcontent
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=11727 AND cc.idclassification=1 LIMIT 1
SELECT oc.idcontent
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=11727 AND cc.idclassification=1 LIMIT 1
SELECT COUNT(sc.idspectacle)
                                FROM schedules sc
                                WHERE sc.idspectacle=11727
SELECT COUNT(sc.idspectacle)
                                FROM schedules sc
                                WHERE sc.idspectacle=11727
SELECT oc.idcontent
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=11727 AND cc.idclassification=101 LIMIT 1
SELECT oc.idcontent
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=11727 AND cc.idclassification=101 LIMIT 1
SELECT oc.idcontent
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=11727 AND cc.idclassification=125 LIMIT 1
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (125))) AND texts=1
SELECT COUNT(DISTINCT(oc.idcontent)) as total
                FROM object_content oc,
                     contents c,
                     content_classification cc,
                     classifications cl
                   WHERE oc.idcontent=c.idcontent
                   AND c.idcontent=cc.idcontent
                   AND oc.idobject='15326'
                   AND oc.object='texts'
                   AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.idclassification IN (125)))
SELECT oc.idcontent
                            FROM object_content oc, contents c, content_classification cc
                            WHERE oc.idcontent=c.idcontent
                            AND cc.idcontent=c.idcontent
                            AND c.publish=1
                            AND oc.object='spectacles'
                            AND oc.idobject=11727 AND cc.idclassification=125 LIMIT 1
SELECT t0.idstat AS idstat_1, t0.type AS type_2, t0.module AS module_3, t0.url AS url_4, t0.idcontent AS idcontent_5, t0.object AS object_6, t0.idobject AS idobject_7, t0.video AS video_8, t0.remote_addr AS remote_addr_9, t0.lng AS lng_10, t0.source AS source_11, t0.md5url AS md5url_12, t0.dateinsert AS dateinsert_13 FROM stats t0 WHERE t0.remote_addr = ? AND t0.idcontent = ? AND t0.md5url = ?
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
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
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

0 Hits
0 Misses
0 Puts
Entities Mapping

Class	Mapping errors
TheatreCore\Entity\Extranetusers	No errors.
TheatreCore\Entity\Spectacles	No errors.
TheatreCore\Entity\Typesspectacles	No errors.
TheatreCore\Entity\Contacts	No errors.
TheatreCore\Entity\Texts	No errors.
TheatreCore\Entity\Contents	No errors.
TheatreCore\Entity\Files	No errors.
TheatreCore\Entity\Classifications	No errors.
TheatreCore\Entity\Schedules	No errors.
TheatreCore\Entity\Persons	No errors.
TheatreCore\Entity\Multimedias	No errors.
TheatreCore\Entity\ObjectMultimedia	No errors.
TheatreCore\Entity\Templates	No errors.
TheatreCore\Entity\Aides	No errors.
TheatreCore\Entity\News	No errors.
TheatreCore\Entity\Regions	No errors.
TheatreCore\Entity\Countries	No errors.
TheatreCore\Entity\Newschedules	No errors.
TheatreCore\Entity\Podcasts	No errors.
TheatreCore\Entity\Dvds	No errors.
TheatreCore\Entity\SpectacleAide	No errors.
TheatreCore\Entity\Playlists	No errors.
TheatreCore\Entity\Abonnements	No errors.
TheatreCore\Entity\BookmarkExtranetuser	No errors.
TheatreCore\Entity\Stats	No errors.
TheatreCore\Entity\Bannieres	No errors.
Symfony Profiler

https://preprod.theatre-contemporain.net/spectacles/Fugue/?path=spectacles%2FFugue

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
