Symfony Profiler

Last 10 Latest Search
Settings
Query Metrics

150 Database Queries
133 Different statements
322.75 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='Bros'
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=29024
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=29024  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=29024  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=29024
                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='29024'
                   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=29024 AND s.date>='2024-03-29' 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=29024 AND s.date<='2024-03-29' GROUP BY c.idcontact ORDER BY s.date DESC
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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='20565'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=20565  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2023-11-24" AND idspectacle=29024 AND idcontact=20565
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2023-11-25" AND idspectacle=29024 AND idcontact=20565
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2023-11-26" AND idspectacle=29024 AND idcontact=20565
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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='4582'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=4582  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2023-05-23" AND idspectacle=29024 AND idcontact=4582
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2023-05-24" AND idspectacle=29024 AND idcontact=4582
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=495  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2023-05-10" AND idspectacle=29024 AND idcontact=495
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2023-05-11" AND idspectacle=29024 AND idcontact=495
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2023-05-12" AND idspectacle=29024 AND idcontact=495
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2023-05-13" AND idspectacle=29024 AND idcontact=495
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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='3234'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=3234  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2023-04-19" AND idspectacle=29024 AND idcontact=3234
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2023-04-20" AND idspectacle=29024 AND idcontact=3234
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2023-04-21" AND idspectacle=29024 AND idcontact=3234
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=522  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-17" AND idspectacle=29024 AND idcontact=522
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-11-18" AND idspectacle=29024 AND idcontact=522
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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='1199'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=1199  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-05-17" AND idspectacle=29024 AND idcontact=1199
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-05-18" AND idspectacle=29024 AND idcontact=1199
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-05-19" AND idspectacle=29024 AND idcontact=1199
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-05-20" AND idspectacle=29024 AND idcontact=1199
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-05-21" AND idspectacle=29024 AND idcontact=1199
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-05-22" AND idspectacle=29024 AND idcontact=1199
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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='2226'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=2226  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-05-04" AND idspectacle=29024 AND idcontact=2226
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-05-05" AND idspectacle=29024 AND idcontact=2226
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-05-06" AND idspectacle=29024 AND idcontact=2226
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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='4521'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=4521  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-04-22" AND idspectacle=29024 AND idcontact=4521
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-04-23" AND idspectacle=29024 AND idcontact=4521
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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='1204'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=1204  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-03-11" AND idspectacle=29024 AND idcontact=1204
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-03-12" AND idspectacle=29024 AND idcontact=1204
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=476  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-02-11" AND idspectacle=29024 AND idcontact=476
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-02-12" AND idspectacle=29024 AND idcontact=476
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-02-13" AND idspectacle=29024 AND idcontact=476
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-02-15" AND idspectacle=29024 AND idcontact=476
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-02-16" AND idspectacle=29024 AND idcontact=476
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-02-17" AND idspectacle=29024 AND idcontact=476
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-02-18" AND idspectacle=29024 AND idcontact=476
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2022-02-19" AND idspectacle=29024 AND idcontact=476
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=246  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2021-10-26" AND idspectacle=29024 AND idcontact=246
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2021-10-27" AND idspectacle=29024 AND idcontact=246
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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='5493'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=5493  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-11-20" AND idspectacle=29024 AND idcontact=5493
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-11-21" AND idspectacle=29024 AND idcontact=5493
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-11-22" AND idspectacle=29024 AND idcontact=5493
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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='26679'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=26679  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-10-15" AND idspectacle=29024 AND idcontact=26679
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-10-16" AND idspectacle=29024 AND idcontact=26679
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-10-17" AND idspectacle=29024 AND idcontact=26679
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-10-18" AND idspectacle=29024 AND idcontact=26679
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=305  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-10-07" AND idspectacle=29024 AND idcontact=305
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-10-08" AND idspectacle=29024 AND idcontact=305
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-10-09" AND idspectacle=29024 AND idcontact=305
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-10-10" AND idspectacle=29024 AND idcontact=305
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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='18786'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=18786  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-10-03" AND idspectacle=29024 AND idcontact=18786
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-10-04" AND idspectacle=29024 AND idcontact=18786
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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='22935'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=22935  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-06-27" AND idspectacle=29024 AND idcontact=22935
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-06-28" AND idspectacle=29024 AND idcontact=22935
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-06-30" AND idspectacle=29024 AND idcontact=22935
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-07-01" AND idspectacle=29024 AND idcontact=22935
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-07-02" AND idspectacle=29024 AND idcontact=22935
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-07-03" AND idspectacle=29024 AND idcontact=22935
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-07-04" AND idspectacle=29024 AND idcontact=22935
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-07-05" AND idspectacle=29024 AND idcontact=22935
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-07-07" AND idspectacle=29024 AND idcontact=22935
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-07-08" AND idspectacle=29024 AND idcontact=22935
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-07-09" AND idspectacle=29024 AND idcontact=22935
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-07-10" AND idspectacle=29024 AND idcontact=22935
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-07-11" AND idspectacle=29024 AND idcontact=22935
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-07-12" AND idspectacle=29024 AND idcontact=22935
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=230  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-05-30" AND idspectacle=29024 AND idcontact=230
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-05-31" AND idspectacle=29024 AND idcontact=230
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-06-01" AND idspectacle=29024 AND idcontact=230
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=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='1115'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
SELECT DISTINCT(date), note, url_spectacle, url_booking, idextranetuser, publish, valid, is_cancelled
                  FROM schedules 
                  WHERE idspectacle=29024
                  AND idcontact=1115  AND date<='2024-03-29'  ORDER BY date
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-05-14" AND idspectacle=29024 AND idcontact=1115
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-05-15" AND idspectacle=29024 AND idcontact=1115
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-05-16" AND idspectacle=29024 AND idcontact=1115
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-05-17" AND idspectacle=29024 AND idcontact=1115
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-05-19" AND idspectacle=29024 AND idcontact=1115
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-05-20" AND idspectacle=29024 AND idcontact=1115
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-05-21" AND idspectacle=29024 AND idcontact=1115
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-05-22" AND idspectacle=29024 AND idcontact=1115
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-05-23" AND idspectacle=29024 AND idcontact=1115
SELECT hour,note,url_spectacle,url_booking 
                  FROM schedules 
                  WHERE date="2020-05-24" AND idspectacle=29024 AND idcontact=1115
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='29024'
                   AND oc.object='spectacles'
                   AND cl.idclassification=cc.idclassification 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=29024 ) 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=29024
                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`=29024 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='29024'
                   AND of.object='spectacles'
                   AND cl.idclassification=fc.idclassification 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=29024 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=29024 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=29024 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=29024 AND cc.idclassification=1 LIMIT 1
SELECT COUNT(sc.idspectacle)
                                FROM schedules sc
                                WHERE sc.idspectacle=29024
SELECT COUNT(sc.idspectacle)
                                FROM schedules sc
                                WHERE sc.idspectacle=29024
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=29024 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=29024 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=29024 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='35810'
                   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=29024 AND cc.idclassification=125 LIMIT 1
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\Abonnements	No errors.
TheatreCore\Entity\News	No errors.
TheatreCore\Entity\Multimedias	No errors.
TheatreCore\Entity\Podcasts	No errors.
TheatreCore\Entity\BookmarkExtranetuser	No errors.
TheatreCore\Entity\Bannieres	No errors.
Symfony Profiler

https://preprod.theatre-contemporain.net/spectacles/Bros/lesdates/?path=spectacles%2FBros%2Flesdates%2F

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
