Query Metrics
112
Database Queries
74
Different statements
2340.36 ms
Query time
1
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.47 ms |
SELECT idcontact FROM contacts WHERE url_clean='Theatre-National-Populaire'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
2 | 0.58 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:
[
702
]
|
||||||||||||||||||||||||||||||||||
3 | 0.05 ms |
SELECT fr FROM countries WHERE id='FR'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
4 | 0.05 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.34 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=702 AND j2.idoffice=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
6 | 0.49 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (100))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
7 | 2.36 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='702' 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.04 ms |
SELECT classification FROM classifications WHERE idclassification=100
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
9 | 14.14 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM schedules, spectacles WHERE schedules.idspectacle=spectacles.idspectacle AND spectacles.publish=1 AND (schedules.idcontact=702 OR schedules.idcontact_festival=702)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
10 | 89.15 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`=702 OR spectacles.`idcontact_production`=702) AND spectacle_contact.`idrole` IN (17,18,19)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
11 | 2.24 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`=702 OR spectacles.`idcontact_production`=702) AND spectacle_contact.`idrole` = 77
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
12 | 0.27 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`=702
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
13 | 0.18 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`=702 AND aides.type_aide IN (2,3)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
14 | 0.16 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`=702 AND aides.type_aide IN (1)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
15 | 0.75 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`=702 AND aides.type_aide IN (4)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
16 | 23.93 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 (4,501,670,917,921,992,1140,1172,1180,894,1334,1445,505,1969,2451,2449,2505,1612,1684,2790,2899,2822,1970,3307,1527,1476,2111,1815,1816,1738,3781,3912,4074,3482,3377,3981,4488,4279,3667,1901,4560,2948,4266,4932,4011,5073,5123,4485,4823,5246,5303,5572,5655,5657,5658,5669,5857,5885,5907,6149,6148,6155,6327,5031,5891,5140,6842,6934,6998,7069,7445,6195,7538,7545,7782,8542,8363,5119,5735,6181,9034,9207,5112,7673,9291,9477,6797,9185,10126,10419,9494,6714,4112,10745,1379,6306,7931,7552,7063,10150,6124,8250,8536,8498,6579,12011,12030,8358,8737,12032,11911,12038,11465,10101,10530,12064,12045,8586,12899,13829,14549,13707,14900,12334,8245,8084,14010,15106,13858,14397,15348,15351,15156,15559,15456,15308,17949,17952,11562,18302,18306,14663,17582,17549,15189,18226,3308,11578,16635,17576,18368,18371,18215,18508,18654,1980,20667,14400,20198,15327,15320,15323,15325,18264,20151,16670,20078,17950,4764,20829,21497,21842,22025,18839,21351,22619,23132,23183,19719,23422,23464,18731,16487,7418,24254,22318,22636,17992,12073,15322,21424,10751,23137,25011,25012,25038,25045,25152,25234,25026,25399,26224,26379,6174,25223,22560,26667,25783,24044,24314,23874,27329,27330,27331,25782,28506,28785,28786,28789,28799,29142,29143,29297,29331,24720,25851,16070,14986,29423,29488,29835,29208,30289,30299,30498,30628,28625,30199,30225,30724,21057,29233,25732,29244,27480,29246,29364,28616,29369,31100,30696,29160,31151,31512,14727,31577,19117,29833,31996,31326,30981,32567,21929,32853,32928,31106,33293,33317,33343,33472,33540,33569,33977,33946,1243,34461,33507,33697,33959,21049,31154,35091,27857,6368,34941,5712,31843,34982,33168,35280,33119,33588,32056,26979,27548,27508,32933,31325,35978,35979,35980,35983,35984,35986,35995,35996,35997,35998,36000,36011,36027,670,1139,1140,1527,2822,2899,3912,4015,4074,4279,4485,4764,4932,5073,5572,5655,5657,5658,5660,5669,5885,5907,6124,6148,6149,6155,6174,6181,6327,6893,6934,6998,7063,7445,7545,7782,8363,8498,9185,9477,9494,10126,10150,10530,10751,11911,12011,12030,12032,12038,12045,14397,14549,14727,14900,14982,15106,15308,15320,15322,15323,15325,15327,15348,15456,17949,17950,18306,18368,18371,20198,20667,20829,22025,22619,23132,23874,25011,25012,25026,25038,25045,25152,25234,25399,27329,27330,27331,28506,28785,28789,28799,29141,29142,29143,29244,29246,29423,29488,29833,30199,30299,30724,31100,31106,31326,31512,31577,31996,32928,33119,33472,33540,33569,33588,33697,33959,34036,34626,34941,35091,35983,35984,35995,35996,36000,36011,36027,36206) ) 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=702 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
17 | 1038.00 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 ('670','1139','1140','1527','2822','2899','3912','4015','4074','4279','4485','4764','4932','5073','5572','5655','5657','5658','5660','5669','5885','5907','6124','6148','6149','6155','6174','6181','6327','6893','6934','6998','7063','7445','7545','7782','8363','8498','9185','9477','9494','10126','10150','10530','10751','11911','12011','12030','12032','12038','12045','14397','14549','14727','14900','14982','15106','15308','15320','15322','15323','15325','15327','15348','15456','17949','17950','18306','18368','18371','20198','20667','20829','22025','22619','23132','23874','25011','25012','25026','25038','25045','25152','25234','25399','27329','27330','27331','28506','28785','28789','28799','29141','29142','29143','29244','29246','29423','29488','29833','30199','30299','30724','31100','31106','31326','31512','31577','31996','32928','33119','33472','33540','33569','33588','33697','33959','34036','34626','34941','35091','35983','35984','35995','35996','36000','36011','36027','36206','4','501','917','921','992','1172','1180','894','1334','1445','505','1969','2451','2449','2505','1612','1684','2790','1970','3307','1476','2111','1815','1816','1738','3781','3482','3377','3981','4488','3667','1901','4560','2948','4266','4011','5123','4823','5246','5303','5857','5031','5891','5140','6842','7069','6195','7538','8542','5119','5735','9034','9207','5112','7673','9291','6797','10419','6714','4112','10745','1379','6306','7931','7552','8250','8536','6579','8358','8737','11465','10101','12064','8586','12899','13829','13707','12334','8245','8084','14010','13858','15351','15156','15559','17952','11562','18302','14663','17582','17549','15189','18226','3308','11578','16635','17576','18215','18508','18654','1980','14400','18264','20151','16670','20078','21497','21842','18839','21351','23183','19719','23422','23464','18731','16487','7418','24254','22318','22636','17992','12073','21424','23137','26224','26379','25223','22560','26667','25783','24044','24314','25782','28786','29297','29331','24720','25851','16070','14986','29835','29208','30289','30498','30628','28625','30225','21057','29233','25732','27480','29364','28616','29369','30696','29160','31151','19117','30981','32567','21929','32853','33293','33317','33343','33977','33946','1243','34461','33507','21049','31154','27857','6368','5712','31843','34982','33168','35280','32056','26979','27548','27508','32933','31325','35978','35979','35980','35986','35997','35998') OR ( sc.`idcontact`=702 OR sc.`idcontact_festival`=702 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
18 | 1.61 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 (702) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND ((s1_.date BETWEEN '2024-04-24' AND '2026-04-14')) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
19 | 0.73 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 (702) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date < '2024-04-24' ORDER BY s1_.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
20 | 5.52 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-24' AND (s0_.publish = 1 AND s1_.idcontact = 702) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
21 | 33.58 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 = 702) ORDER BY s1_.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
22 | 2.95 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 = 702)) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
23 | 189.00 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 = 702 OR s0_.idcontact_production = 702)) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
24 | 18.25 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-24' AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 702 OR s0_.idcontact_production = 702)) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
25 | 3.72 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-24' AND (s0_.publish = 1 AND s1_.idcontact = 702) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
26 | 24.13 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 = 702) ORDER BY s1_.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
27 | 0.74 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 = 702)) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
28 | 106.27 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 = 702 OR s0_.idcontact_production = 702)) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
29 | 16.17 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-24' AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 702 OR s0_.idcontact_production = 702)) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
30 | 4.67 ms |
SELECT DISTINCT(s.idschedule),hour,date,s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,s.idspectacle, c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean, 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 1 AND s.idspectacle IN (4,501,670,917,921,992,1140,1172,1180,894,1334,1445,505,1969,2451,2449,2505,1612,1684,2790,2899,2822,1970,3307,1527,1476,2111,1815,1816,1738,3781,3912,4074,3482,3377,3981,4488,4279,3667,1901,4560,2948,4266,4932,4011,5073,5123,4485,4823,5246,5303,5572,5655,5657,5658,5669,5857,5885,5907,6149,6148,6155,6327,5031,5891,5140,6842,6934,6998,7069,7445,6195,7538,7545,7782,8542,8363,5119,5735,6181,9034,9207,5112,7673,9291,9477,6797,9185,10126,10419,9494,6714,4112,10745,1379,6306,7931,7552,7063,10150,6124,8250,8536,8498,6579,12011,12030,8358,8737,12032,11911,12038,11465,10101,10530,12064,12045,8586,12899,13829,14549,13707,14900,12334,8245,8084,14010,15106,13858,14397,15348,15351,15156,15559,15456,15308,17949,17952,11562,18302,18306,14663,17582,17549,15189,18226,3308,11578,16635,17576,18368,18371,18215,18508,18654,1980,20667,14400,20198,15327,15320,15323,15325,18264,20151,16670,20078,17950,4764,20829,21497,21842,22025,18839,21351,22619,23132,23183,19719,23422,23464,18731,16487,7418,24254,22318,22636,17992,12073,15322,21424,10751,23137,25011,25012,25038,25045,25152,25234,25026,25399,26224,26379,6174,25223,22560,26667,25783,24044,24314,23874,27329,27330,27331,25782,28506,28785,28786,28789,28799,29142,29143,29297,29331,24720,25851,16070,14986,29423,29488,29835,29208,30289,30299,30498,30628,28625,30199,30225,30724,21057,29233,25732,29244,27480,29246,29364,28616,29369,31100,30696,29160,31151,31512,14727,31577,19117,29833,31996,31326,30981,32567,21929,32853,32928,31106,33293,33317,33343,33472,33540,33569,33977,33946,1243,34461,33507,33697,33959,21049,31154,35091,27857,6368,34941,5712,31843,34982,33168,35280,33119,33588,32056,26979,27548,27508,32933,31325,35978,35979,35980,35983,35984,35986,35995,35996,35997,35998,36000,36011,36027,35980) AND s.date>='2024-04-24' AND c.idcontact = 702 ORDER BY s.date ASC LIMIT 0,1000
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
31 | 0.53 ms |
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, s0_.idtypespectacle AS idtypespectacle_18, s0_.idcontact_creation AS idcontact_creation_19, s0_.idcontact_production AS idcontact_production_20, s0_.idspectaclegenre AS idspectaclegenre_21, s0_.idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_.idspectacle = ?
Parameters:
[
"36011"
]
|
||||||||||||||||||||||||||||||||||
32 | 0.12 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
33 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
34 | 1.11 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=36011 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
35 | 0.50 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44823"
]
|
||||||||||||||||||||||||||||||||||
36 | 0.47 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3 WHERE j3.idtext=j2.idtext AND j1.idperson=j2.idperson AND j3.idtext=44823 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
37 | 0.76 ms |
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=36011 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
38 | 0.07 ms |
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, s0_.idtypespectacle AS idtypespectacle_18, s0_.idcontact_creation AS idcontact_creation_19, s0_.idcontact_production AS idcontact_production_20, s0_.idspectaclegenre AS idspectaclegenre_21, s0_.idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_.idspectacle = ?
Parameters:
[
"36011"
]
|
||||||||||||||||||||||||||||||||||
39 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
40 | 0.04 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
41 | 0.04 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=36011 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
42 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44823"
]
|
||||||||||||||||||||||||||||||||||
43 | 0.04 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3 WHERE j3.idtext=j2.idtext AND j1.idperson=j2.idperson AND j3.idtext=44823 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
44 | 0.05 ms |
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=36011 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
45 | 0.06 ms |
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, s0_.idtypespectacle AS idtypespectacle_18, s0_.idcontact_creation AS idcontact_creation_19, s0_.idcontact_production AS idcontact_production_20, s0_.idspectaclegenre AS idspectaclegenre_21, s0_.idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_.idspectacle = ?
Parameters:
[
"36011"
]
|
||||||||||||||||||||||||||||||||||
46 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
47 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
48 | 0.04 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=36011 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
49 | 0.05 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44823"
]
|
||||||||||||||||||||||||||||||||||
50 | 0.04 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3 WHERE j3.idtext=j2.idtext AND j1.idperson=j2.idperson AND j3.idtext=44823 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
51 | 0.05 ms |
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=36011 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
52 | 0.06 ms |
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, s0_.idtypespectacle AS idtypespectacle_18, s0_.idcontact_creation AS idcontact_creation_19, s0_.idcontact_production AS idcontact_production_20, s0_.idspectaclegenre AS idspectaclegenre_21, s0_.idextranetuser AS idextranetuser_22 FROM spectacles s0_ WHERE s0_.idspectacle = ?
Parameters:
[
"36011"
]
|
||||||||||||||||||||||||||||||||||
53 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
54 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
55 | 0.04 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=36011 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
56 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44823"
]
|
||||||||||||||||||||||||||||||||||
57 | 0.04 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3 WHERE j3.idtext=j2.idtext AND j1.idperson=j2.idperson AND j3.idtext=44823 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
58 | 0.05 ms |
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=36011 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
59 | 0.06 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`=702 OR spectacles.`idcontact_production`=702) AND spectacle_contact.`idrole` IN (17,18,19)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
60 | 0.04 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`=702 OR spectacles.`idcontact_production`=702) AND spectacle_contact.`idrole` = 77
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
61 | 4.53 ms |
SELECT DISTINCT(s.idschedule),hour,date,s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,s.idspectacle, c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean, 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 1 AND s.idspectacle IN (670,1139,1140,1527,2822,2899,3912,4015,4074,4279,4485,4764,4932,5073,5572,5655,5657,5658,5660,5669,5885,5907,6124,6148,6149,6155,6174,6181,6327,6893,6934,6998,7063,7445,7545,7782,8363,8498,9185,9477,9494,10126,10150,10530,10751,11911,12011,12030,12032,12038,12045,14397,14549,14727,14900,14982,15106,15308,15320,15322,15323,15325,15327,15348,15456,17949,17950,18306,18368,18371,20198,20667,20829,22025,22619,23132,23874,25011,25012,25026,25038,25045,25152,25234,25399,27329,27330,27331,28506,28785,28789,28799,29141,29142,29143,29244,29246,29423,29488,29833,30199,30299,30724,31100,31106,31326,31512,31577,31996,32928,33119,33472,33540,33569,33588,33697,33959,34036,34626,34941,35091,35983,35984,35995,35996,36000,36011,36027,36206,35980) AND s.date>='2024-04-24' AND c.idcontact = 702 ORDER BY s.date ASC LIMIT 0,1000
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
62 | 0.07 ms |
SELECT DISTINCT(s.idschedule),hour,date,s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,s.idspectacle, c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean, 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 1 AND s.idspectacle IN (670,1139,1140,1527,2822,2899,3912,4015,4074,4279,4485,4764,4932,5073,5572,5655,5657,5658,5660,5669,5885,5907,6124,6148,6149,6155,6174,6181,6327,6893,6934,6998,7063,7445,7545,7782,8363,8498,9185,9477,9494,10126,10150,10530,10751,11911,12011,12030,12032,12038,12045,14397,14549,14727,14900,14982,15106,15308,15320,15322,15323,15325,15327,15348,15456,17949,17950,18306,18368,18371,20198,20667,20829,22025,22619,23132,23874,25011,25012,25026,25038,25045,25152,25234,25399,27329,27330,27331,28506,28785,28789,28799,29141,29142,29143,29244,29246,29423,29488,29833,30199,30299,30724,31100,31106,31326,31512,31577,31996,32928,33119,33472,33540,33569,33588,33697,33959,34036,34626,34941,35091,35983,35984,35995,35996,36000,36011,36027,36206,35980) AND s.date>='2024-04-24' AND c.idcontact = 702 ORDER BY s.date ASC LIMIT 0,1000
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
63 | 5.57 ms |
SELECT DISTINCT(s.idschedule),hour,date,s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,s.idspectacle, c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean, 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 1 AND s.idspectacle IN (670,1139,1140,1527,2822,2899,3912,4015,4074,4279,4485,4764,4932,5073,5572,5655,5657,5658,5660,5669,5885,5907,6124,6148,6149,6155,6174,6181,6327,6893,6934,6998,7063,7445,7545,7782,8363,8498,9185,9477,9494,10126,10150,10530,10751,11911,12011,12030,12032,12038,12045,14397,14549,14727,14900,14982,15106,15308,15320,15322,15323,15325,15327,15348,15456,17949,17950,18306,18368,18371,20198,20667,20829,22025,22619,23132,23874,25011,25012,25026,25038,25045,25152,25234,25399,27329,27330,27331,28506,28785,28789,28799,29141,29142,29143,29244,29246,29423,29488,29833,30199,30299,30724,31100,31106,31326,31512,31577,31996,32928,33119,33472,33540,33569,33588,33697,33959,34036,34626,34941,35091,35983,35984,35995,35996,36000,36011,36027,36206,35980) AND s.date>='2024-04-24' ORDER BY s.date ASC LIMIT 0,1000
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
64 | 1.19 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
65 | 0.21 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
66 | 0.14 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
67 | 0.13 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
68 | 0.19 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
69 | 0.19 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
70 | 0.34 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
71 | 0.25 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
72 | 0.20 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
73 | 0.12 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
74 | 0.11 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
75 | 0.33 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
76 | 0.24 ms |
SELECT COUNT(DISTINCT(idperson)) FROM person_ecole WHERE 1 AND idcontact=702
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
77 | 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 (4,501,670,917,921,992,1140,1172,1180,894,1334,1445,505,1969,2451,2449,2505,1612,1684,2790,2899,2822,1970,3307,1527,1476,2111,1815,1816,1738,3781,3912,4074,3482,3377,3981,4488,4279,3667,1901,4560,2948,4266,4932,4011,5073,5123,4485,4823,5246,5303,5572,5655,5657,5658,5669,5857,5885,5907,6149,6148,6155,6327,5031,5891,5140,6842,6934,6998,7069,7445,6195,7538,7545,7782,8542,8363,5119,5735,6181,9034,9207,5112,7673,9291,9477,6797,9185,10126,10419,9494,6714,4112,10745,1379,6306,7931,7552,7063,10150,6124,8250,8536,8498,6579,12011,12030,8358,8737,12032,11911,12038,11465,10101,10530,12064,12045,8586,12899,13829,14549,13707,14900,12334,8245,8084,14010,15106,13858,14397,15348,15351,15156,15559,15456,15308,17949,17952,11562,18302,18306,14663,17582,17549,15189,18226,3308,11578,16635,17576,18368,18371,18215,18508,18654,1980,20667,14400,20198,15327,15320,15323,15325,18264,20151,16670,20078,17950,4764,20829,21497,21842,22025,18839,21351,22619,23132,23183,19719,23422,23464,18731,16487,7418,24254,22318,22636,17992,12073,15322,21424,10751,23137,25011,25012,25038,25045,25152,25234,25026,25399,26224,26379,6174,25223,22560,26667,25783,24044,24314,23874,27329,27330,27331,25782,28506,28785,28786,28789,28799,29142,29143,29297,29331,24720,25851,16070,14986,29423,29488,29835,29208,30289,30299,30498,30628,28625,30199,30225,30724,21057,29233,25732,29244,27480,29246,29364,28616,29369,31100,30696,29160,31151,31512,14727,31577,19117,29833,31996,31326,30981,32567,21929,32853,32928,31106,33293,33317,33343,33472,33540,33569,33977,33946,1243,34461,33507,33697,33959,21049,31154,35091,27857,6368,34941,5712,31843,34982,33168,35280,33119,33588,32056,26979,27548,27508,32933,31325,35978,35979,35980,35983,35984,35986,35995,35996,35997,35998,36000,36011,36027,670,1139,1140,1527,2822,2899,3912,4015,4074,4279,4485,4764,4932,5073,5572,5655,5657,5658,5660,5669,5885,5907,6124,6148,6149,6155,6174,6181,6327,6893,6934,6998,7063,7445,7545,7782,8363,8498,9185,9477,9494,10126,10150,10530,10751,11911,12011,12030,12032,12038,12045,14397,14549,14727,14900,14982,15106,15308,15320,15322,15323,15325,15327,15348,15456,17949,17950,18306,18368,18371,20198,20667,20829,22025,22619,23132,23874,25011,25012,25026,25038,25045,25152,25234,25399,27329,27330,27331,28506,28785,28789,28799,29141,29142,29143,29244,29246,29423,29488,29833,30199,30299,30724,31100,31106,31326,31512,31577,31996,32928,33119,33472,33540,33569,33588,33697,33959,34036,34626,34941,35091,35983,35984,35995,35996,36000,36011,36027,36206) ) 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=702 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
78 | 0.03 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_presentation_structure'))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
79 | 1.04 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='702' 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:
[]
|
||||||||||||||||||||||||||||||||||
80 | 0.22 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=127733
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
81 | 0.05 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_article'))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
82 | 1.03 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='702' 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:
[]
|
||||||||||||||||||||||||||||||||||
83 | 0.04 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
84 | 0.03 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
85 | 0.03 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
86 | 0.03 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
87 | 0.60 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
88 | 0.21 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
89 | 0.36 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
90 | 0.15 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
91 | 0.26 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=702 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:
[]
|
||||||||||||||||||||||||||||||||||
92 | 0.03 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
93 | 0.03 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
94 | 0.03 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
95 | 0.03 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
96 | 0.03 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
97 | 0.03 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
98 | 0.03 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
99 | 0.03 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=702 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
100 | 0.64 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 (702) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||||
101 | 0.83 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=702 ) AND T1.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
102 | 2.96 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(670,1139,1140,1527,2822,2899,3912,4015,4074,4279,4485,4764,4932,5073,5572,5655,5657,5658,5660,5669,5885,5907,6124,6148,6149,6155,6174,6181,6327,6893,6934,6998,7063,7445,7545,7782,8363,8498,9185,9477,9494,10126,10150,10530,10751,11911,12011,12030,12032,12038,12045,14397,14549,14727,14900,14982,15106,15308,15320,15322,15323,15325,15327,15348,15456,17949,17950,18306,18368,18371,20198,20667,20829,22025,22619,23132,23874,25011,25012,25026,25038,25045,25152,25234,25399,27329,27330,27331,28506,28785,28789,28799,29141,29142,29143,29244,29246,29423,29488,29833,30199,30299,30724,31100,31106,31326,31512,31577,31996,32928,33119,33472,33540,33569,33588,33697,33959,34036,34626,34941,35091,35983,35984,35995,35996,36000,36011,36027,36206,4,501,917,921,992,1172,1180,894,1334,1445,505,1969,2451,2449,2505,1612,1684,2790,1970,3307,1476,2111,1815,1816,1738,3781,3482,3377,3981,4488,3667,1901,4560,2948,4266,4011,5123,4823,5246,5303,5857,5031,5891,5140,6842,7069,6195,7538,8542,5119,5735,9034,9207,5112,7673,9291,6797,10419,6714,4112,10745,1379,6306,7931,7552,8250,8536,6579,8358,8737,11465,10101,12064,8586,12899,13829,13707,12334,8245,8084,14010,13858,15351,15156,15559,17952,11562,18302,14663,17582,17549,15189,18226,3308,11578,16635,17576,18215,18508,18654,1980,14400,18264,20151,16670,20078,21497,21842,18839,21351,23183,19719,23422,23464,18731,16487,7418,24254,22318,22636,17992,12073,21424,23137,26224,26379,25223,22560,26667,25783,24044,24314,25782,28786,29297,29331,24720,25851,16070,14986,29835,29208,30289,30498,30628,28625,30225,21057,29233,25732,27480,29364,28616,29369,30696,29160,31151,19117,30981,32567,21929,32853,33293,33317,33343,33977,33946,1243,34461,33507,21049,31154,27857,6368,5712,31843,34982,33168,35280,32056,26979,27548,27508,32933,31325,35978,35979,35980,35986,35997,35998) AND d.code_franceinter IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
103 | 0.33 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:
[
702
]
|
||||||||||||||||||||||||||||||||||
104 | 712.80 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=702 OR schedules.idcontact_festival=702) AND contents.`publish`=1 AND contents.`valid`=1 AND object_content.`object`='spectacles' AND content_classification.`idclassification` IN (125)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
105 | 13.31 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`=702 OR spectacles.`idcontact_production`=702) 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:
[]
|
||||||||||||||||||||||||||||||||||
106 | 0.10 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:
[]
|
||||||||||||||||||||||||||||||||||
107 | 0.06 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:
[]
|
||||||||||||||||||||||||||||||||||
108 | 1.62 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='702' 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:
[]
|
||||||||||||||||||||||||||||||||||
109 | 0.07 ms |
SELECT COUNT(DISTINCT(idperson)) FROM person_ecole WHERE 1 AND idcontact=702
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
110 | 1.33 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:
[ "212ce765f4382742eacac6f5b220a351-8a98" 0 "533e69997d28911e114999deba570f7f" ]
|
||||||||||||||||||||||||||||||||||
111 | 2.35 ms |
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "article" "thnet" "/contacts/Theatre-National-Populaire/calendrier/type/structure" "533e69997d28911e114999deba570f7f" 0 "contacts" 702 0 "fr" "212ce765f4382742eacac6f5b220a351-8a98" "/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829" ]
|
||||||||||||||||||||||||||||||||||
112 | 0.69 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