Query Metrics
148
Database Queries
141
Different statements
2320.40 ms
Query time
1
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.45 ms |
SELECT idcontact FROM contacts WHERE url_clean='La-Comedie-de-Reims'
Parameters:
[]
|
||||||||||||||||||||||||||||||||
2 | 0.65 ms |
SELECT c0_.idcontact AS idcontact_0, c0_.type AS type_1, c0_.organisation AS organisation_2, c0_.nom_suite AS nom_suite_3, c0_.lastname AS lastname_4, c0_.firstname AS firstname_5, c0_.idtypestructure AS idtypestructure_6, c0_.license AS license_7, c0_.comment AS comment_8, c0_.private_comment AS private_comment_9, c0_.address1 AS address1_10, c0_.address2 AS address2_11, c0_.zip AS zip_12, c0_.city AS city_13, c0_.phone1 AS phone1_14, c0_.phone2 AS phone2_15, c0_.fax AS fax_16, c0_.email1 AS email1_17, c0_.email1_online AS email1_online_18, c0_.email2_online AS email2_online_19, c0_.email2 AS email2_20, c0_.url AS url_21, c0_.url_ticket AS url_ticket_22, c0_.facebook AS facebook_23, c0_.twitter AS twitter_24, c0_.instagram AS instagram_25, c0_.mobile AS mobile_26, c0_.geocodable AS geocodable_27, c0_.x AS x_28, c0_.y AS y_29, c0_.idmultimedia AS idmultimedia_30, c0_.type_view AS type_view_31, c0_.stats_access AS stats_access_32, c0_.ga_tracking_id AS ga_tracking_id_33, c0_.is_festival AS is_festival_34, c0_.link_on_video AS link_on_video_35, c0_.is_partenaire AS is_partenaire_36, c0_.valid_version AS valid_version_37, c0_.other_versions AS other_versions_38, c0_.url_redirect AS url_redirect_39, c0_.url_clean AS url_clean_40, c0_.dateupdate AS dateupdate_41, c0_.dateinsert AS dateinsert_42, c0_.publish AS publish_43, c0_.valid AS valid_44, c1_.id AS id_45, c1_.fr AS fr_46, c1_.en AS en_47, c1_.es AS es_48, c1_.pt AS pt_49, c1_.de AS de_50, c1_.ru AS ru_51, c1_.orderby AS orderby_52 FROM contacts c0_ LEFT JOIN countries c1_ ON c0_.country = c1_.id WHERE c0_.idcontact = ?
Parameters:
[
655
]
|
||||||||||||||||||||||||||||||||
3 | 0.07 ms |
SELECT fr FROM countries WHERE id='FR'
Parameters:
[]
|
||||||||||||||||||||||||||||||||
4 | 0.40 ms |
SELECT t0_.idtypestructure AS idtypestructure_0, t0_.typestructure_pluriel AS typestructure_pluriel_1, t0_.typestructure AS typestructure_2, t0_.public_view AS public_view_3, t0_.order_view AS order_view_4 FROM typesstructures t0_ WHERE t0_.idtypestructure = ?
Parameters:
[
"CDN"
]
|
||||||||||||||||||||||||||||||||
5 | 0.41 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j2.idoffice,j2.date_start,j2.date_end ,j3.idcontact FROM theatreok_dev.persons j1, theatreok_dev.contact_person j2, theatreok_dev.contacts j3 WHERE j3.idcontact=j2.idcontact AND j1.idperson=j2.idperson AND j3.idcontact=655 AND j2.idoffice=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
6 | 0.06 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (100))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
7 | 2.11 ms |
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='655' AND of.object='contacts' AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.idclassification IN (100))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters:
[]
|
||||||||||||||||||||||||||||||||
8 | 0.16 ms |
SELECT classification FROM classifications WHERE idclassification=100
Parameters:
[]
|
||||||||||||||||||||||||||||||||
9 | 10.32 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM schedules, spectacles WHERE schedules.idspectacle=spectacles.idspectacle AND spectacles.publish=1 AND (schedules.idcontact=655 OR schedules.idcontact_festival=655)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
10 | 90.90 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle` WHERE spectacles.`publish`=1 AND (spectacle_contact.`idcontact`=655 OR spectacles.`idcontact_production`=655) AND spectacle_contact.`idrole` IN (17,18,19)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
11 | 2.50 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle` WHERE spectacles.`publish`=1 AND (spectacle_contact.`idcontact`=655 OR spectacles.`idcontact_production`=655) AND spectacle_contact.`idrole` = 77
Parameters:
[]
|
||||||||||||||||||||||||||||||||
12 | 0.58 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide.`idspectacle`=spectacles.`idspectacle` INNER JOIN aides ON aides.`idaide`=spectacle_aide.`idaide` WHERE spectacles.`publish`=1 AND aides.`idcontact`=655
Parameters:
[]
|
||||||||||||||||||||||||||||||||
13 | 0.80 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide.`idspectacle`=spectacles.`idspectacle` INNER JOIN aides ON aides.`idaide`=spectacle_aide.`idaide` WHERE spectacles.`publish`=1 AND aides.`idcontact`=655 AND aides.type_aide IN (2,3)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
14 | 0.48 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide.`idspectacle`=spectacles.`idspectacle` INNER JOIN aides ON aides.`idaide`=spectacle_aide.`idaide` WHERE spectacles.`publish`=1 AND aides.`idcontact`=655 AND aides.type_aide IN (1)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
15 | 0.22 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide.`idspectacle`=spectacles.`idspectacle` INNER JOIN aides ON aides.`idaide`=spectacle_aide.`idaide` WHERE spectacles.`publish`=1 AND aides.`idcontact`=655 AND aides.type_aide IN (4)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
16 | 29.71 ms |
SELECT COUNT(DISTINCT(multimedias.idmultimedia)) FROM multimedias WHERE multimedias.`publish`=1 AND (multimedias.`idmultimedia` IN ( SELECT multimedias.`idmultimedia` FROM object_multimedia JOIN multimedias ON object_multimedia.`idmultimedia`=multimedias.`idmultimedia` AND object_multimedia.`object` IN ('contacts', 'spectacles') AND object_multimedia.idobject IN (98,202,206,219,277,108,509,601,672,691,591,782,915,773,1057,484,1135,1214,506,1076,1382,868,1564,1798,883,1971,2249,1970,2355,2469,2504,2526,2676,2766,2825,2975,1216,2648,3038,2626,3077,3153,3155,3182,3280,3360,2113,2507,2570,2888,1136,1457,2074,3441,3510,2186,3578,3377,3601,3636,3653,2826,3671,2831,3720,2440,3725,2283,3748,3781,3811,3816,2710,3859,3908,3963,4010,4025,4137,4058,3114,4235,4083,4505,4332,3993,4488,4307,4621,4705,4461,4532,4266,4773,4539,4779,4939,4955,4323,5137,4122,5193,5099,4372,5262,5220,5097,5303,4704,4966,5273,5359,4786,5121,5421,4943,4823,5530,1243,5774,5803,3232,6074,6183,5335,6482,6520,4305,6251,6076,6069,6688,6564,6704,6896,6915,6180,7091,6095,7164,7162,6675,7254,7262,6905,5140,226,5523,4295,6746,7633,7702,7704,7824,7990,8009,8229,8336,6547,8828,8831,8832,8833,8834,8100,7673,5704,8193,8572,6962,8412,6736,8251,8110,6593,6195,8840,8842,8843,8844,8846,8848,8849,8850,8851,8852,8853,8036,10574,10982,8238,5119,12249,12495,12816,12507,8423,9806,9607,12954,11549,11862,10596,11574,12706,8769,9406,13530,13531,13629,13795,13873,13897,13610,14388,14871,15125,15056,13495,8041,15138,16025,15973,14985,13549,16060,13202,14370,16061,13888,14397,14401,7635,14958,16075,16139,16259,16741,14727,17670,18508,17587,17305,18200,14861,17823,13942,13058,16480,17995,17717,15983,14950,18304,18383,19924,18137,20088,18266,4079,20276,20309,3773,20754,21071,21276,20215,14399,19198,20946,21968,14400,21743,21304,12334,21353,19546,22278,22344,22403,22550,22551,22552,22555,22565,23142,23350,23676,23681,19712,19196,21719,507,4523,18148,24300,23818,23969,7134,24939,24940,22998,24938,25125,16460,23912,24073,24144,24424,23819,23845,23931,25475,24985,25536,25717,25720,25723,23689,25079,26498,26352,16323,9793,25838,6755,26238,23761,26428,26142,23997,26577,23699,15706,26822,27091,27644,27714,28545,28554,28562,8939,19674,27710,29140,28012,26981,29270,26531,14389,26583,23746,24044,26534,29797,29049,27086,20528,22560,27924,28596,27255,21401,30437,6432,30258,29894,29421,31011,31021,30701,30715,30720,31097,29224,31190,31201,30226,31226,29647,31325,31688,31488,31692,28768,28607,32006,32042,32204,18720,26875,32598,30415,32960,31020,32969,32970,27939,33015,33016,33020,33138,33530,30354,29763,33689,33695,33678,33693,29079,24537,29760,29908,28093,30180,28732,8296,34596,30915,31193,34476,31154,33676,33587,31059,35280,35541,35477,35814,35931,36442,35572,36443,36444,36447,36345,26537,36878,32195,36911,36921,26682,37041,34613,37164,34938,202,206,219,509,911,1136,1214,1382,1457,1564,1864,1992,2113,2249,2469,2570,2766,2825,2975,3182,3280,3441,3510,3578,3636,3653,3671,3811,3963,3993,4010,4079,4137,4217,4322,4323,4332,4461,4505,4523,4532,4705,4943,5033,5099,5137,5262,5359,5406,5530,5774,5803,6023,6069,6076,6095,6180,6482,6520,6675,6704,6915,7164,7180,7254,7262,7333,7633,7704,8100,8110,8251,8336,8572,8828,8831,8832,8833,8834,8840,8842,8843,8844,8849,8851,9607,9806,10574,10596,10982,11400,11862,12249,12334,12507,12652,12816,12954,13058,13128,13495,13530,13531,13610,13795,13873,13897,13942,14370,14388,14985,15138,15973,15983,16025,16061,16259,16480,17254,17390,17717,17792,17823,18148,18266,18364,19196,19198,19675,19924,20088,20215,20276,20309,20754,21071,21304,21400,21968,22278,22403,22550,22551,22552,22555,22565,23350,23494,23676,23818,23819,23931,24073,24424,24468,24938,24939,24940,24965,24985,25536,25717,26352,26822,26875,27710,27714,27939,28012,28545,28554,28562,28607,29421,29598,29763,29894,29908,30226,30258,30437,30701,30715,30720,30889,31011,31020,31059,31097,31190,31201,31226,31325,31488,31692,32006,32042,32598,32960,32974,33020,33138,33530,33587,33676,33678,33689,33693,33879,34476,34613,34938,35541,35572,35931,36442,36443,36444,36445,36447,36463,36464,36465,36468,36878,36921,36925,37298) ) OR multimedias.`idmultimedia` IN ( SELECT multimedias.idmultimedia FROM object_multimedia JOIN multimedias ON object_multimedia.`idmultimedia`=multimedias.`idmultimedia` AND object_multimedia.object IN ('contacts') AND object_multimedia.idobject=655 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||
17 | 1227.71 ms |
SELECT COUNT(DISTINCT(ct.`idcontent`)) FROM schedules sc JOIN spectacles s ON s.`idspectacle`=sc.`idspectacle` JOIN object_content oc ON s.`idspectacle`=oc.`idobject` JOIN contents ct ON oc.`idcontent`=ct.`idcontent` JOIN content_classification cc ON ct.`idcontent`=cc.`idcontent` WHERE s.`publish`=1 AND s.`valid`=1 AND ct.`publish`=1 AND ct.`valid`=1 AND cc.`idclassification`=101 AND ( sc.`idspectacle` IN ('202','206','219','509','911','1136','1214','1382','1457','1564','1864','1992','2113','2249','2469','2570','2766','2825','2975','3182','3280','3441','3510','3578','3636','3653','3671','3811','3963','3993','4010','4079','4137','4217','4322','4323','4332','4461','4505','4523','4532','4705','4943','5033','5099','5137','5262','5359','5406','5530','5774','5803','6023','6069','6076','6095','6180','6482','6520','6675','6704','6915','7164','7180','7254','7262','7333','7633','7704','8100','8110','8251','8336','8572','8828','8831','8832','8833','8834','8840','8842','8843','8844','8849','8851','9607','9806','10574','10596','10982','11400','11862','12249','12334','12507','12652','12816','12954','13058','13128','13495','13530','13531','13610','13795','13873','13897','13942','14370','14388','14985','15138','15973','15983','16025','16061','16259','16480','17254','17390','17717','17792','17823','18148','18266','18364','19196','19198','19675','19924','20088','20215','20276','20309','20754','21071','21304','21400','21968','22278','22403','22550','22551','22552','22555','22565','23350','23494','23676','23818','23819','23931','24073','24424','24468','24938','24939','24940','24965','24985','25536','25717','26352','26822','26875','27710','27714','27939','28012','28545','28554','28562','28607','29421','29598','29763','29894','29908','30226','30258','30437','30701','30715','30720','30889','31011','31020','31059','31097','31190','31201','31226','31325','31488','31692','32006','32042','32598','32960','32974','33020','33138','33530','33587','33676','33678','33689','33693','33879','34476','34613','34938','35541','35572','35931','36442','36443','36444','36445','36447','36463','36464','36465','36468','36878','36921','36925','37298','98','277','108','601','672','691','591','782','915','773','1057','484','1135','506','1076','868','1798','883','1971','1970','2355','2504','2526','2676','1216','2648','3038','2626','3077','3153','3155','3360','2507','2888','2074','2186','3377','3601','2826','2831','3720','2440','3725','2283','3748','3781','3816','2710','3859','3908','4025','4058','3114','4235','4083','4488','4307','4621','4266','4773','4539','4779','4939','4955','4122','5193','4372','5220','5097','5303','4704','4966','5273','4786','5121','5421','4823','1243','3232','6074','6183','5335','4305','6251','6688','6564','6896','7091','7162','6905','5140','226','5523','4295','6746','7702','7824','7990','8009','8229','6547','7673','5704','8193','6962','8412','6736','6593','6195','8846','8848','8850','8852','8853','8036','8238','5119','12495','8423','11549','11574','12706','8769','9406','13629','14871','15125','15056','8041','13549','16060','13202','13888','14397','14401','7635','14958','16075','16139','16741','14727','17670','18508','17587','17305','18200','14861','17995','14950','18304','18383','18137','3773','21276','14399','20946','14400','21743','21353','19546','22344','23142','23681','19712','21719','507','24300','23969','7134','22998','25125','16460','23912','24144','23845','25475','25720','25723','23689','25079','26498','16323','9793','25838','6755','26238','23761','26428','26142','23997','26577','23699','15706','27091','27644','8939','19674','29140','26981','29270','26531','14389','26583','23746','24044','26534','29797','29049','27086','20528','22560','27924','28596','27255','21401','6432','31021','29224','29647','31688','28768','32204','18720','30415','32969','32970','33015','33016','30354','33695','29079','24537','29760','28093','30180','28732','8296','34596','30915','31193','31154','35280','35477','35814','36345','26537','32195','36911','26682','37041','37164') OR ( sc.`idcontact`=655 OR sc.`idcontact_festival`=655 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||
18 | 1.76 ms |
SELECT DISTINCT(T1.idnew), T1.*,T2.idextranetuser,T2.lastname,T2.firstname,T2.signature,T2.city as city_extranetuser,T2.enseignant_etablissement,T2.enseignant_active,T3.idnewschedule,T3.date,T3.hour,T3.idcontact,T3.note FROM news T1 INNER JOIN newschedules T3 ON T3.idnew=T1.idnew INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=655 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND T1.type_news=0 AND (( T3.date>='2024-04-17' )) GROUP BY T1.idnew ORDER BY T3.date ASC LIMIT 0,200
Parameters:
[]
|
||||||||||||||||||||||||||||||||
19 | 1.78 ms |
SELECT DISTINCT(T1.idnew), T1.*,T2.idextranetuser,T2.lastname,T2.firstname,T2.signature,T2.city as city_extranetuser,T2.enseignant_etablissement,T2.enseignant_active,T3.idnewschedule,T3.date,T3.hour,T3.idcontact,T3.note FROM news T1 INNER JOIN newschedules T3 ON T3.idnew=T1.idnew INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=655 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND T1.type_news=0 AND (( T3.date<'2024-04-17' )) GROUP BY T1.idnew ORDER BY T3.date DESC LIMIT 0,200
Parameters:
[]
|
||||||||||||||||||||||||||||||||
20 | 0.48 ms |
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 = ?
Parameters:
[
"13455"
]
|
||||||||||||||||||||||||||||||||
21 | 0.23 ms |
SELECT url_file FROM news WHERE idnew=13455
Parameters:
[]
|
||||||||||||||||||||||||||||||||
22 | 1.21 ms |
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=13455 AND sc.date<'2024-04-17' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
23 | 0.39 ms |
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=13455 AND sc.date<'2024-04-17' AND sc.idcontact=14639 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||||
24 | 0.34 ms |
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=13455
Parameters:
[]
|
||||||||||||||||||||||||||||||||
25 | 0.47 ms |
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=13455
Parameters:
[]
|
||||||||||||||||||||||||||||||||
26 | 0.39 ms |
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=13455
Parameters:
[]
|
||||||||||||||||||||||||||||||||
27 | 0.21 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36453
Parameters:
[]
|
||||||||||||||||||||||||||||||||
28 | 0.36 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36456
Parameters:
[]
|
||||||||||||||||||||||||||||||||
29 | 0.30 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36458
Parameters:
[]
|
||||||||||||||||||||||||||||||||
30 | 0.29 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36459
Parameters:
[]
|
||||||||||||||||||||||||||||||||
31 | 0.26 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36462
Parameters:
[]
|
||||||||||||||||||||||||||||||||
32 | 0.24 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36463
Parameters:
[]
|
||||||||||||||||||||||||||||||||
33 | 0.22 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=33702
Parameters:
[]
|
||||||||||||||||||||||||||||||||
34 | 0.20 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36471
Parameters:
[]
|
||||||||||||||||||||||||||||||||
35 | 0.22 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36467
Parameters:
[]
|
||||||||||||||||||||||||||||||||
36 | 0.22 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36464
Parameters:
[]
|
||||||||||||||||||||||||||||||||
37 | 0.21 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36465
Parameters:
[]
|
||||||||||||||||||||||||||||||||
38 | 0.22 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36466
Parameters:
[]
|
||||||||||||||||||||||||||||||||
39 | 0.20 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36479
Parameters:
[]
|
||||||||||||||||||||||||||||||||
40 | 0.20 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36468
Parameters:
[]
|
||||||||||||||||||||||||||||||||
41 | 0.20 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36469
Parameters:
[]
|
||||||||||||||||||||||||||||||||
42 | 0.18 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=36470
Parameters:
[]
|
||||||||||||||||||||||||||||||||
43 | 0.19 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=3078
Parameters:
[]
|
||||||||||||||||||||||||||||||||
44 | 0.45 ms |
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=13455
Parameters:
[]
|
||||||||||||||||||||||||||||||||
45 | 0.32 ms |
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 = ?
Parameters:
[
"12147"
]
|
||||||||||||||||||||||||||||||||
46 | 0.13 ms |
SELECT url_file FROM news WHERE idnew=12147
Parameters:
[]
|
||||||||||||||||||||||||||||||||
47 | 0.28 ms |
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=12147 AND sc.date<'2024-04-17' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
48 | 0.26 ms |
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=12147 AND sc.date<'2024-04-17' AND sc.idcontact=31448 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||||
49 | 0.29 ms |
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=12147
Parameters:
[]
|
||||||||||||||||||||||||||||||||
50 | 0.28 ms |
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=12147
Parameters:
[]
|
||||||||||||||||||||||||||||||||
51 | 0.22 ms |
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=12147
Parameters:
[]
|
||||||||||||||||||||||||||||||||
52 | 0.31 ms |
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=12147
Parameters:
[]
|
||||||||||||||||||||||||||||||||
53 | 0.28 ms |
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 = ?
Parameters:
[
"11308"
]
|
||||||||||||||||||||||||||||||||
54 | 0.11 ms |
SELECT url_file FROM news WHERE idnew=11308
Parameters:
[]
|
||||||||||||||||||||||||||||||||
55 | 0.26 ms |
SELECT sc.date, c.city, c.country, c.zip, c.organisation, c.url_clean, c.idcontact FROM newschedules sc, contacts c WHERE sc.idcontact=c.idcontact AND sc.idnew=11308 AND sc.date<'2024-04-17' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
56 | 0.31 ms |
SELECT MIN(sc.date) as datestart, MAX(sc.date) as dateend, c.city, c.country FROM newschedules sc, contacts c WHERE sc.idcontact=c.idcontact AND sc.idnew=11308 AND sc.date<'2024-04-17' AND sc.idcontact=655 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||||
57 | 0.31 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idnew FROM theatreok_dev.persons j1, theatreok_dev.new_person j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idperson=j2.idperson AND j3.idnew=11308
Parameters:
[]
|
||||||||||||||||||||||||||||||||
58 | 0.24 ms |
SELECT j1.idcontact,j1.lastname,j1.firstname,j1.organisation,j1.type,j1.url_clean ,j3.idnew FROM theatreok_dev.contacts j1, theatreok_dev.new_contact j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idcontact=j2.idcontact AND j3.idnew=11308
Parameters:
[]
|
||||||||||||||||||||||||||||||||
59 | 0.23 ms |
SELECT j1.idspectacle,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.spectacles j1, theatreok_dev.new_spectacle j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idspectacle=j2.idspectacle AND j3.idnew=11308
Parameters:
[]
|
||||||||||||||||||||||||||||||||
60 | 0.25 ms |
SELECT j1.idtext,j1.title,j1.valid,j1.publish,j1.url_clean ,j3.idnew FROM theatreok_dev.texts j1, theatreok_dev.new_text j2, theatreok_dev.news j3 WHERE j3.idnew=j2.idnew AND j1.idtext=j2.idtext AND j3.idnew=11308
Parameters:
[]
|
||||||||||||||||||||||||||||||||
61 | 0.35 ms |
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 = ?
Parameters:
[
"9996"
]
|
||||||||||||||||||||||||||||||||
62 | 0.12 ms |
SELECT url_file FROM news WHERE idnew=9996
Parameters:
[]
|
||||||||||||||||||||||||||||||||
63 | 0.25 ms |
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=9996 AND sc.date<'2024-04-17' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
64 | 0.23 ms |
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=9996 AND sc.date<'2024-04-17' AND sc.idcontact=13436 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||||
65 | 0.28 ms |
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=9996
Parameters:
[]
|
||||||||||||||||||||||||||||||||
66 | 0.26 ms |
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=9996
Parameters:
[]
|
||||||||||||||||||||||||||||||||
67 | 0.21 ms |
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=9996
Parameters:
[]
|
||||||||||||||||||||||||||||||||
68 | 0.24 ms |
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=9996
Parameters:
[]
|
||||||||||||||||||||||||||||||||
69 | 0.27 ms |
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 = ?
Parameters:
[
"9109"
]
|
||||||||||||||||||||||||||||||||
70 | 0.11 ms |
SELECT url_file FROM news WHERE idnew=9109
Parameters:
[]
|
||||||||||||||||||||||||||||||||
71 | 0.26 ms |
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=9109 AND sc.date<'2024-04-17' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
72 | 0.59 ms |
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=9109 AND sc.date<'2024-04-17' AND sc.idcontact=4947 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||||
73 | 0.34 ms |
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=9109
Parameters:
[]
|
||||||||||||||||||||||||||||||||
74 | 0.38 ms |
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=9109
Parameters:
[]
|
||||||||||||||||||||||||||||||||
75 | 0.39 ms |
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=9109
Parameters:
[]
|
||||||||||||||||||||||||||||||||
76 | 0.59 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=11539
Parameters:
[]
|
||||||||||||||||||||||||||||||||
77 | 0.25 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=17545
Parameters:
[]
|
||||||||||||||||||||||||||||||||
78 | 0.32 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=19198
Parameters:
[]
|
||||||||||||||||||||||||||||||||
79 | 0.24 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=21231
Parameters:
[]
|
||||||||||||||||||||||||||||||||
80 | 0.31 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=21233
Parameters:
[]
|
||||||||||||||||||||||||||||||||
81 | 0.23 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=21246
Parameters:
[]
|
||||||||||||||||||||||||||||||||
82 | 0.37 ms |
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=9109
Parameters:
[]
|
||||||||||||||||||||||||||||||||
83 | 0.26 ms |
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 = ?
Parameters:
[
"6411"
]
|
||||||||||||||||||||||||||||||||
84 | 0.22 ms |
SELECT url_file FROM news WHERE idnew=6411
Parameters:
[]
|
||||||||||||||||||||||||||||||||
85 | 0.26 ms |
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=6411 AND sc.date<'2024-04-17' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
86 | 0.35 ms |
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=6411 AND sc.date<'2024-04-17' AND sc.idcontact=655 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||||
87 | 0.29 ms |
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=6411
Parameters:
[]
|
||||||||||||||||||||||||||||||||
88 | 0.23 ms |
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=6411
Parameters:
[]
|
||||||||||||||||||||||||||||||||
89 | 0.26 ms |
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=6411
Parameters:
[]
|
||||||||||||||||||||||||||||||||
90 | 0.23 ms |
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=6411
Parameters:
[]
|
||||||||||||||||||||||||||||||||
91 | 0.26 ms |
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 = ?
Parameters:
[
"6092"
]
|
||||||||||||||||||||||||||||||||
92 | 0.11 ms |
SELECT url_file FROM news WHERE idnew=6092
Parameters:
[]
|
||||||||||||||||||||||||||||||||
93 | 0.24 ms |
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=6092 AND sc.date<'2024-04-17' ORDER BY sc.date DESC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
94 | 0.31 ms |
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=6092 AND sc.date<'2024-04-17' AND sc.idcontact=655 GROUP BY sc.idcontact
Parameters:
[]
|
||||||||||||||||||||||||||||||||
95 | 0.25 ms |
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=6092
Parameters:
[]
|
||||||||||||||||||||||||||||||||
96 | 0.37 ms |
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=6092
Parameters:
[]
|
||||||||||||||||||||||||||||||||
97 | 0.20 ms |
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=6092
Parameters:
[]
|
||||||||||||||||||||||||||||||||
98 | 0.25 ms |
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=6092
Parameters:
[]
|
||||||||||||||||||||||||||||||||
99 | 0.96 ms |
SELECT DISTINCT(T1.idnew), T1.*,T2.idextranetuser,T2.lastname,T2.firstname,T2.signature,T2.city as city_extranetuser,T2.enseignant_etablissement,T2.enseignant_active,T3.idnewschedule,T3.date,T3.hour,T3.idcontact,T3.note FROM news T1 INNER JOIN newschedules T3 ON T3.idnew=T1.idnew INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=655 ) AND T1.idnew NOT IN (13455,12147,11308,9996,9109,6411,6092) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND T1.type_news=1 AND (( T3.date>='2024-04-17' )) GROUP BY T1.idnew ORDER BY T3.date ASC LIMIT 0,200
Parameters:
[]
|
||||||||||||||||||||||||||||||||
100 | 0.83 ms |
SELECT DISTINCT(T1.idnew), T1.*,T2.idextranetuser,T2.lastname,T2.firstname,T2.signature,T2.city as city_extranetuser,T2.enseignant_etablissement,T2.enseignant_active,T3.idnewschedule,T3.date,T3.hour,T3.idcontact,T3.note FROM news T1 INNER JOIN newschedules T3 ON T3.idnew=T1.idnew INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=655 ) AND T1.idnew NOT IN (13455,12147,11308,9996,9109,6411,6092) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1 AND T1.type_news=1 AND (( T3.date<'2024-04-17' )) GROUP BY T1.idnew ORDER BY T3.date DESC LIMIT 0,200
Parameters:
[]
|
||||||||||||||||||||||||||||||||
101 | 0.06 ms |
SELECT COUNT(DISTINCT(multimedias.idmultimedia)) FROM multimedias WHERE multimedias.`publish`=1 AND (multimedias.`idmultimedia` IN ( SELECT multimedias.`idmultimedia` FROM object_multimedia JOIN multimedias ON object_multimedia.`idmultimedia`=multimedias.`idmultimedia` AND object_multimedia.`object` IN ('contacts', 'spectacles') AND object_multimedia.idobject IN (98,202,206,219,277,108,509,601,672,691,591,782,915,773,1057,484,1135,1214,506,1076,1382,868,1564,1798,883,1971,2249,1970,2355,2469,2504,2526,2676,2766,2825,2975,1216,2648,3038,2626,3077,3153,3155,3182,3280,3360,2113,2507,2570,2888,1136,1457,2074,3441,3510,2186,3578,3377,3601,3636,3653,2826,3671,2831,3720,2440,3725,2283,3748,3781,3811,3816,2710,3859,3908,3963,4010,4025,4137,4058,3114,4235,4083,4505,4332,3993,4488,4307,4621,4705,4461,4532,4266,4773,4539,4779,4939,4955,4323,5137,4122,5193,5099,4372,5262,5220,5097,5303,4704,4966,5273,5359,4786,5121,5421,4943,4823,5530,1243,5774,5803,3232,6074,6183,5335,6482,6520,4305,6251,6076,6069,6688,6564,6704,6896,6915,6180,7091,6095,7164,7162,6675,7254,7262,6905,5140,226,5523,4295,6746,7633,7702,7704,7824,7990,8009,8229,8336,6547,8828,8831,8832,8833,8834,8100,7673,5704,8193,8572,6962,8412,6736,8251,8110,6593,6195,8840,8842,8843,8844,8846,8848,8849,8850,8851,8852,8853,8036,10574,10982,8238,5119,12249,12495,12816,12507,8423,9806,9607,12954,11549,11862,10596,11574,12706,8769,9406,13530,13531,13629,13795,13873,13897,13610,14388,14871,15125,15056,13495,8041,15138,16025,15973,14985,13549,16060,13202,14370,16061,13888,14397,14401,7635,14958,16075,16139,16259,16741,14727,17670,18508,17587,17305,18200,14861,17823,13942,13058,16480,17995,17717,15983,14950,18304,18383,19924,18137,20088,18266,4079,20276,20309,3773,20754,21071,21276,20215,14399,19198,20946,21968,14400,21743,21304,12334,21353,19546,22278,22344,22403,22550,22551,22552,22555,22565,23142,23350,23676,23681,19712,19196,21719,507,4523,18148,24300,23818,23969,7134,24939,24940,22998,24938,25125,16460,23912,24073,24144,24424,23819,23845,23931,25475,24985,25536,25717,25720,25723,23689,25079,26498,26352,16323,9793,25838,6755,26238,23761,26428,26142,23997,26577,23699,15706,26822,27091,27644,27714,28545,28554,28562,8939,19674,27710,29140,28012,26981,29270,26531,14389,26583,23746,24044,26534,29797,29049,27086,20528,22560,27924,28596,27255,21401,30437,6432,30258,29894,29421,31011,31021,30701,30715,30720,31097,29224,31190,31201,30226,31226,29647,31325,31688,31488,31692,28768,28607,32006,32042,32204,18720,26875,32598,30415,32960,31020,32969,32970,27939,33015,33016,33020,33138,33530,30354,29763,33689,33695,33678,33693,29079,24537,29760,29908,28093,30180,28732,8296,34596,30915,31193,34476,31154,33676,33587,31059,35280,35541,35477,35814,35931,36442,35572,36443,36444,36447,36345,26537,36878,32195,36911,36921,26682,37041,34613,37164,34938,202,206,219,509,911,1136,1214,1382,1457,1564,1864,1992,2113,2249,2469,2570,2766,2825,2975,3182,3280,3441,3510,3578,3636,3653,3671,3811,3963,3993,4010,4079,4137,4217,4322,4323,4332,4461,4505,4523,4532,4705,4943,5033,5099,5137,5262,5359,5406,5530,5774,5803,6023,6069,6076,6095,6180,6482,6520,6675,6704,6915,7164,7180,7254,7262,7333,7633,7704,8100,8110,8251,8336,8572,8828,8831,8832,8833,8834,8840,8842,8843,8844,8849,8851,9607,9806,10574,10596,10982,11400,11862,12249,12334,12507,12652,12816,12954,13058,13128,13495,13530,13531,13610,13795,13873,13897,13942,14370,14388,14985,15138,15973,15983,16025,16061,16259,16480,17254,17390,17717,17792,17823,18148,18266,18364,19196,19198,19675,19924,20088,20215,20276,20309,20754,21071,21304,21400,21968,22278,22403,22550,22551,22552,22555,22565,23350,23494,23676,23818,23819,23931,24073,24424,24468,24938,24939,24940,24965,24985,25536,25717,26352,26822,26875,27710,27714,27939,28012,28545,28554,28562,28607,29421,29598,29763,29894,29908,30226,30258,30437,30701,30715,30720,30889,31011,31020,31059,31097,31190,31201,31226,31325,31488,31692,32006,32042,32598,32960,32974,33020,33138,33530,33587,33676,33678,33689,33693,33879,34476,34613,34938,35541,35572,35931,36442,36443,36444,36445,36447,36463,36464,36465,36468,36878,36921,36925,37298) ) OR multimedias.`idmultimedia` IN ( SELECT multimedias.idmultimedia FROM object_multimedia JOIN multimedias ON object_multimedia.`idmultimedia`=multimedias.`idmultimedia` AND object_multimedia.object IN ('contacts') AND object_multimedia.idobject=655 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||
102 | 0.04 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_presentation_structure'))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
103 | 0.94 ms |
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='655' AND oc.object='contacts' AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.classification IN ('class_presentation_structure'))) ORDER BY c.`range`,c.idcontent
Parameters:
[]
|
||||||||||||||||||||||||||||||||
104 | 0.20 ms |
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=97226
Parameters:
[]
|
||||||||||||||||||||||||||||||||
105 | 0.06 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_article'))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
106 | 0.80 ms |
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='655' AND oc.object='contacts' AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.classification IN ('class_article'))) ORDER BY c.`range`,c.idcontent
Parameters:
[]
|
||||||||||||||||||||||||||||||||
107 | 0.19 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||
108 | 0.34 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||
109 | 0.47 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||
110 | 0.57 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||
111 | 0.19 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||
112 | 0.12 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||
113 | 0.18 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||
114 | 0.13 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||
115 | 0.28 ms |
SELECT COUNT(p.idplaylist) FROM playlists p LEFT JOIN playlist_classification pc ON p.idplaylist = pc.idplaylist LEFT JOIN aides a ON a.idcontact=655 LEFT JOIN text_aide ta ON a.`idaide`=ta.`idaide` WHERE 1 AND a.`publish`=1 AND a.`type_aide` IN (2,3) AND pc.idclassification = 144 AND p.idtext = ta.idtext GROUP BY p.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||
116 | 0.14 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
117 | 0.19 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
118 | 0.14 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
119 | 0.12 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
120 | 0.17 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||
121 | 0.22 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||
122 | 0.20 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||
123 | 0.18 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=655 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||
124 | 0.63 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN text_aide t8_ ON t2_.idtext = t8_.idtext INNER JOIN aides a9_ ON t8_.idaide = a9_.idaide WHERE s0_.textfictif = 0 AND a9_.idcontact IN (655) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND ((s1_.date BETWEEN '2024-04-17' AND '2026-04-07')) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
125 | 0.47 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN text_aide t8_ ON t2_.idtext = t8_.idtext INNER JOIN aides a9_ ON t8_.idaide = a9_.idaide WHERE s0_.textfictif = 0 AND a9_.idcontact IN (655) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date < '2024-04-17' ORDER BY s1_.date DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
126 | 4.24 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date >= '2024-04-17' AND (s0_.publish = 1 AND (s1_.idcontact = 655 OR s1_.idcontact_festival = 655)) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
127 | 26.93 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, c2_.idcontact AS idcontact_2 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_.idspectacle = t4_.idspectacle LEFT JOIN texts t3_ ON t3_.idtext = t4_.idtext LEFT JOIN typesspectacles t5_ ON s0_.idtypespectacle = t5_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s7_ ON s0_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c2_ ON s1_.idcontact = c2_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c2_.idcontact OR s1_.idcontact_festival = c2_.idcontact) AND (s0_.publish = 1 AND (s1_.idcontact = 655 OR s1_.idcontact_festival = 655)) ORDER BY s1_.date DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
128 | 0.67 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN spectacle_contact s8_ WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND (s8_.idrole IN (77) AND s8_.idcontact = 655)) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
129 | 248.55 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN spectacle_contact s8_ WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 655 OR s0_.idcontact_production = 655)) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
130 | 23.63 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN spectacle_contact s8_ WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date >= '2024-04-17' AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 655 OR s0_.idcontact_production = 655)) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
131 | 4.48 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN podcast_spectacle p9_ ON s0_.idspectacle = p9_.idspectacle INNER JOIN podcasts p8_ ON p8_.idpodcast = p9_.idpodcast WHERE p8_.code_franceinter IS NOT NULL AND p8_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date >= '2024-04-17' AND (s0_.publish = 1 AND (s1_.idcontact = 655 OR s1_.idcontact_festival = 655)) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
132 | 23.33 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, c2_.idcontact AS idcontact_2 FROM spectacles s0_ LEFT JOIN text_spectacle t4_ ON s0_.idspectacle = t4_.idspectacle LEFT JOIN texts t3_ ON t3_.idtext = t4_.idtext LEFT JOIN typesspectacles t5_ ON s0_.idtypespectacle = t5_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s7_ ON s0_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c2_ ON s1_.idcontact = c2_.idcontact INNER JOIN podcast_spectacle p9_ ON s0_.idspectacle = p9_.idspectacle INNER JOIN podcasts p8_ ON p8_.idpodcast = p9_.idpodcast WHERE p8_.code_franceinter IS NOT NULL AND p8_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c2_.idcontact OR s1_.idcontact_festival = c2_.idcontact) AND (s0_.publish = 1 AND (s1_.idcontact = 655 OR s1_.idcontact_festival = 655)) ORDER BY s1_.date DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
133 | 0.89 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_.idspectacle = p10_.idspectacle INNER JOIN podcasts p9_ ON p9_.idpodcast = p10_.idpodcast WHERE p9_.code_franceinter IS NOT NULL AND p9_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND (s8_.idrole IN (77) AND s8_.idcontact = 655)) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
134 | 127.56 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_.idspectacle = p10_.idspectacle INNER JOIN podcasts p9_ ON p9_.idpodcast = p10_.idpodcast WHERE p9_.code_franceinter IS NOT NULL AND p9_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 655 OR s0_.idcontact_production = 655)) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||
135 | 22.31 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact INNER JOIN spectacle_contact s8_ INNER JOIN podcast_spectacle p10_ ON s0_.idspectacle = p10_.idspectacle INNER JOIN podcasts p9_ ON p9_.idpodcast = p10_.idpodcast WHERE p9_.code_franceinter IS NOT NULL AND p9_.publish = 1 AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date >= '2024-04-17' AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 655 OR s0_.idcontact_production = 655)) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
136 | 0.88 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN text_aide t8_ ON t2_.idtext = t8_.idtext INNER JOIN aides a9_ ON t8_.idaide = a9_.idaide WHERE s0_.textfictif = 0 AND a9_.idcontact IN (655) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
137 | 0.62 ms |
SELECT COUNT(DISTINCT(T1.idnew)) as total FROM news T1 INNER JOIN newschedules T3 ON T3.idnew=T1.idnew INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_contact T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idcontact=655 ) AND T1.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
138 | 7.35 ms |
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` IN(202,206,219,509,911,1136,1214,1382,1457,1564,1864,1992,2113,2249,2469,2570,2766,2825,2975,3182,3280,3441,3510,3578,3636,3653,3671,3811,3963,3993,4010,4079,4137,4217,4322,4323,4332,4461,4505,4523,4532,4705,4943,5033,5099,5137,5262,5359,5406,5530,5774,5803,6023,6069,6076,6095,6180,6482,6520,6675,6704,6915,7164,7180,7254,7262,7333,7633,7704,8100,8110,8251,8336,8572,8828,8831,8832,8833,8834,8840,8842,8843,8844,8849,8851,9607,9806,10574,10596,10982,11400,11862,12249,12334,12507,12652,12816,12954,13058,13128,13495,13530,13531,13610,13795,13873,13897,13942,14370,14388,14985,15138,15973,15983,16025,16061,16259,16480,17254,17390,17717,17792,17823,18148,18266,18364,19196,19198,19675,19924,20088,20215,20276,20309,20754,21071,21304,21400,21968,22278,22403,22550,22551,22552,22555,22565,23350,23494,23676,23818,23819,23931,24073,24424,24468,24938,24939,24940,24965,24985,25536,25717,26352,26822,26875,27710,27714,27939,28012,28545,28554,28562,28607,29421,29598,29763,29894,29908,30226,30258,30437,30701,30715,30720,30889,31011,31020,31059,31097,31190,31201,31226,31325,31488,31692,32006,32042,32598,32960,32974,33020,33138,33530,33587,33676,33678,33689,33693,33879,34476,34613,34938,35541,35572,35931,36442,36443,36444,36445,36447,36463,36464,36465,36468,36878,36921,36925,37298,98,277,108,601,672,691,591,782,915,773,1057,484,1135,506,1076,868,1798,883,1971,1970,2355,2504,2526,2676,1216,2648,3038,2626,3077,3153,3155,3360,2507,2888,2074,2186,3377,3601,2826,2831,3720,2440,3725,2283,3748,3781,3816,2710,3859,3908,4025,4058,3114,4235,4083,4488,4307,4621,4266,4773,4539,4779,4939,4955,4122,5193,4372,5220,5097,5303,4704,4966,5273,4786,5121,5421,4823,1243,3232,6074,6183,5335,4305,6251,6688,6564,6896,7091,7162,6905,5140,226,5523,4295,6746,7702,7824,7990,8009,8229,6547,7673,5704,8193,6962,8412,6736,6593,6195,8846,8848,8850,8852,8853,8036,8238,5119,12495,8423,11549,11574,12706,8769,9406,13629,14871,15125,15056,8041,13549,16060,13202,13888,14397,14401,7635,14958,16075,16139,16741,14727,17670,18508,17587,17305,18200,14861,17995,14950,18304,18383,18137,3773,21276,14399,20946,14400,21743,21353,19546,22344,23142,23681,19712,21719,507,24300,23969,7134,22998,25125,16460,23912,24144,23845,25475,25720,25723,23689,25079,26498,16323,9793,25838,6755,26238,23761,26428,26142,23997,26577,23699,15706,27091,27644,8939,19674,29140,26981,29270,26531,14389,26583,23746,24044,26534,29797,29049,27086,20528,22560,27924,28596,27255,21401,6432,31021,29224,29647,31688,28768,32204,18720,30415,32969,32970,33015,33016,30354,33695,29079,24537,29760,28093,30180,28732,8296,34596,30915,31193,31154,35280,35477,35814,36345,26537,32195,36911,26682,37041,37164) AND d.code_franceinter IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||||
139 | 0.86 ms |
SELECT count(p0_.idpodcast) AS sclr_0 FROM podcasts p0_ INNER JOIN podcast_contact p2_ ON p0_.idpodcast = p2_.idpodcast INNER JOIN contacts c1_ ON c1_.idcontact = p2_.idcontact WHERE c1_.idcontact = ?
Parameters:
[
655
]
|
||||||||||||||||||||||||||||||||
140 | 407.72 ms |
SELECT COUNT(DISTINCT(spectacles.`idspectacle`)) as total FROM schedules, spectacles JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle` JOIN object_content ON spectacle_contact.`idspectacle`=object_content.`idobject` JOIN contents ON contents.`idcontent`=object_content.`idcontent` JOIN content_classification ON contents.`idcontent`=content_classification.`idcontent` WHERE schedules.idspectacle=spectacles.idspectacle AND spectacles.publish=1 AND (schedules.idcontact=655 OR schedules.idcontact_festival=655) AND contents.`publish`=1 AND contents.`valid`=1 AND object_content.`object`='spectacles' AND content_classification.`idclassification` IN (125)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
141 | 11.34 ms |
SELECT COUNT(DISTINCT(spectacles.`idspectacle`)) as total FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle` JOIN object_content ON spectacle_contact.`idspectacle`=object_content.`idobject` JOIN contents ON contents.`idcontent`=object_content.`idcontent` JOIN content_classification ON contents.`idcontent`=content_classification.`idcontent` WHERE spectacles.`publish`=1 AND (spectacle_contact.`idcontact`=655 OR spectacles.`idcontact_production`=655) AND spectacle_contact.`idrole` IN (17,18,19) AND contents.`publish`=1 AND contents.`valid`=1 AND object_content.`object`='spectacles' AND content_classification.`idclassification` IN (125)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
142 | 0.58 ms |
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND contacts=1 AND lagarce!=1 AND is_public IN (1)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
143 | 0.04 ms |
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND spectacles=1 AND lagarce!=1 AND is_public IN (1)
Parameters:
[]
|
||||||||||||||||||||||||||||||||
144 | 1.08 ms |
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='655' AND of.object='contacts' AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.idclassification IN (112,168,33,126,163,164,166,171,172,175))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
Parameters:
[]
|
||||||||||||||||||||||||||||||||
145 | 0.43 ms |
SELECT COUNT(DISTINCT(idperson)) FROM person_ecole WHERE 1 AND idcontact=655
Parameters:
[]
|
||||||||||||||||||||||||||||||||
146 | 1.54 ms |
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 = ?
Parameters:
[ "ba57af50b3d6d1a298fd7ecbde8819d1-8577" 0 "d3e06cea3a6a8f48749e0b95e7fccd36" ]
|
||||||||||||||||||||||||||||||||
147 | 1.73 ms |
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "article" "thnet" "/contacts/La-Comedie-de-Reims/evenements" "d3e06cea3a6a8f48749e0b95e7fccd36" 0 "contacts" 655 0 "fr" "ba57af50b3d6d1a298fd7ecbde8819d1-8577" "/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829" ]
|
||||||||||||||||||||||||||||||||
148 | 1.08 ms |
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
Parameters:
[]
|
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