Query Metrics
482
Database Queries
93
Different statements
5812.61 ms
Query time
1
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.99 ms |
SELECT idcontact FROM contacts WHERE url_clean='Theatre-Les-Celestins'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
2 | 0.80 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:
[
484
]
|
||||||||||||||||||||||||||||||||||
3 | 0.06 ms |
SELECT fr FROM countries WHERE id='FR'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
4 | 0.18 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:
[
"TM"
]
|
||||||||||||||||||||||||||||||||||
5 | 0.31 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=484 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 | 1.93 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='484' 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.06 ms |
SELECT classification FROM classifications WHERE idclassification=100
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
9 | 15.32 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM schedules, spectacles WHERE schedules.idspectacle=spectacles.idspectacle AND spectacles.publish=1 AND (schedules.idcontact=484 OR schedules.idcontact_festival=484)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
10 | 122.71 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`=484 OR spectacles.`idcontact_production`=484) AND spectacle_contact.`idrole` IN (17,18,19)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
11 | 3.28 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`=484 OR spectacles.`idcontact_production`=484) AND spectacle_contact.`idrole` = 77
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
12 | 0.76 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`=484
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
13 | 0.47 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`=484 AND aides.type_aide IN (2,3)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
14 | 0.50 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`=484 AND aides.type_aide IN (1)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
15 | 0.42 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`=484 AND aides.type_aide IN (4)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
16 | 38.01 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 (743,46,1783,1802,1898,1984,2338,787,2175,2336,2622,1794,2691,1522,2726,2168,2956,2967,2996,2344,2839,3284,3306,1931,3393,1577,3452,3588,3595,3601,3706,3034,2402,3790,3917,3951,1985,4036,4054,1073,4055,4106,4025,4013,3211,4208,4214,4223,4224,3582,4272,4286,3577,4042,4322,2254,4307,4280,4602,4626,4689,3899,4758,3308,4870,4909,4954,5022,5181,5082,5200,5222,4457,4699,5240,5266,5308,5335,5393,5419,5446,4291,5557,5566,3930,5838,5745,5092,5141,6560,6703,6763,6865,7021,7094,7038,5144,7173,7298,7394,1788,730,7683,6512,8120,8323,8324,8351,8354,8492,8635,7450,6307,8224,7979,5510,8355,7296,6736,7460,6561,8587,8873,8874,8876,8878,9252,8168,5149,10479,10639,10931,11862,11961,8372,11571,11410,8388,11194,11692,10537,12073,12132,12135,5156,9512,12044,12136,12137,12138,12176,12195,12027,12597,4926,14035,14804,14322,14609,14587,4554,6755,13629,11275,5010,5828,14702,14648,15226,15228,15229,15230,15233,14977,15235,15236,14900,15239,17465,16119,15608,15045,17231,17380,13732,17271,8041,17656,17785,17802,17803,17804,17810,17812,17814,17822,17587,17826,17850,17854,14586,14886,17566,17393,19675,19941,17749,12127,18012,18246,19193,19638,20710,20821,17237,20919,20914,21031,21071,21269,21304,20745,21056,19794,21715,21721,20780,22038,22049,22054,21147,22594,23501,23502,23131,23606,22040,21720,23410,20696,21207,17366,23359,23676,23807,23809,23810,23815,23813,23818,23819,23686,23699,23827,23828,23830,23831,23833,23834,23835,23843,23838,23973,24427,26181,25837,24268,24010,26253,25310,24111,25475,23697,19195,26399,23529,25895,26524,26352,26593,26594,26603,26606,26612,26614,26617,26545,26628,13030,26476,25549,26142,26845,25188,27533,3219,10738,28554,25756,26616,26135,14024,26790,27924,22485,29238,25760,29904,30016,30113,30604,8439,27891,19214,24046,30753,26531,27057,29355,29368,21398,28521,30701,26595,29395,26619,30032,30703,30354,21978,28732,26629,30996,28536,31000,31004,31005,31013,31015,31017,31018,31019,26350,31020,31021,31039,31041,31055,31058,31059,31060,31097,31102,31103,31110,31090,31056,31100,30226,31549,31994,29760,31150,32940,32445,29182,26597,30224,5580,31212,20986,30592,33117,33112,30527,30437,30808,29234,29412,33429,29099,29985,29270,33484,33495,33498,33503,33127,29830,28607,33502,25189,33662,34218,34517,33618,25928,35412,35541,14399,24080,32416,31921,33751,35870,18562,27860,33637,35608,31278,35801,30965,33580,33530,32426,15279,28010,34030,24598,35928,35929,35930,35931,35932,35933,35236,35940,35941,33301,35418,36069,36106,36115,36207,5119,26155,36211,36208,533,743,1577,1595,1822,1898,1917,1984,1985,2622,2956,2967,3284,3393,3588,3595,3601,3917,4054,4055,4106,4208,4224,4286,4626,4954,5082,5181,5200,5266,5279,5446,6735,6763,7298,7394,8120,8324,8351,8355,8587,8635,8874,9252,10479,10639,10931,11410,11571,11692,11862,11961,12027,12073,12127,12132,12135,12138,12176,14035,14587,14609,14727,14804,14900,14977,15209,15226,15229,15236,15239,16119,17380,17393,17465,17566,17587,17785,17802,17810,17812,17822,17854,19638,19794,19941,20710,20780,20821,21031,21071,21269,21304,21715,22040,22594,23606,23676,23686,23699,23809,23810,23813,23815,23828,23831,23838,24268,26181,26352,26476,26595,26603,26606,26614,26616,26617,26619,26628,26629,27057,29099,29355,29368,29395,29834,29985,30032,30113,30226,30337,30437,30701,30703,30707,31000,31005,31013,31015,31018,31021,31039,31041,31058,31059,31090,31100,31102,31103,31150,31212,32115,32445,32637,33117,33127,33301,33429,33484,33495,33498,33502,33503,33751,34030,34218,34517,35418,35541,35870,35928,35929,35930,35932,35940,36069,36106,36115,36208) ) 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=484 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
17 | 2683.82 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 ('533','743','1577','1595','1822','1898','1917','1984','1985','2622','2956','2967','3284','3393','3588','3595','3601','3917','4054','4055','4106','4208','4224','4286','4626','4954','5082','5181','5200','5266','5279','5446','6735','6763','7298','7394','8120','8324','8351','8355','8587','8635','8874','9252','10479','10639','10931','11410','11571','11692','11862','11961','12027','12073','12127','12132','12135','12138','12176','14035','14587','14609','14727','14804','14900','14977','15209','15226','15229','15236','15239','16119','17380','17393','17465','17566','17587','17785','17802','17810','17812','17822','17854','19638','19794','19941','20710','20780','20821','21031','21071','21269','21304','21715','22040','22594','23606','23676','23686','23699','23809','23810','23813','23815','23828','23831','23838','24268','26181','26352','26476','26595','26603','26606','26614','26616','26617','26619','26628','26629','27057','29099','29355','29368','29395','29834','29985','30032','30113','30226','30337','30437','30701','30703','30707','31000','31005','31013','31015','31018','31021','31039','31041','31058','31059','31090','31100','31102','31103','31150','31212','32115','32445','32637','33117','33127','33301','33429','33484','33495','33498','33502','33503','33751','34030','34218','34517','35418','35541','35870','35928','35929','35930','35932','35940','36069','36106','36115','36208','46','1783','1802','2338','787','2175','2336','1794','2691','1522','2726','2168','2996','2344','2839','3306','1931','3452','3706','3034','2402','3790','3951','4036','1073','4025','4013','3211','4214','4223','3582','4272','3577','4042','4322','2254','4307','4280','4602','4689','3899','4758','3308','4870','4909','5022','5222','4457','4699','5240','5308','5335','5393','5419','4291','5557','5566','3930','5838','5745','5092','5141','6560','6703','6865','7021','7094','7038','5144','7173','1788','730','7683','6512','8323','8354','8492','7450','6307','8224','7979','5510','7296','6736','7460','6561','8873','8876','8878','8168','5149','8372','8388','11194','10537','5156','9512','12044','12136','12137','12195','12597','4926','14322','4554','6755','13629','11275','5010','5828','14702','14648','15228','15230','15233','15235','15608','15045','17231','13732','17271','8041','17656','17803','17804','17814','17826','17850','14586','14886','19675','17749','18012','18246','19193','17237','20919','20914','20745','21056','21721','22038','22049','22054','21147','23501','23502','23131','21720','23410','20696','21207','17366','23359','23807','23818','23819','23827','23830','23833','23834','23835','23843','23973','24427','25837','24010','26253','25310','24111','25475','23697','19195','26399','23529','25895','26524','26593','26594','26612','26545','13030','25549','26142','26845','25188','27533','3219','10738','28554','25756','26135','14024','26790','27924','22485','29238','25760','29904','30016','30604','8439','27891','19214','24046','30753','26531','21398','28521','30354','21978','28732','30996','28536','31004','31017','31019','26350','31020','31055','31060','31097','31110','31056','31549','31994','29760','32940','29182','26597','30224','5580','20986','30592','33112','30527','30808','29234','29412','29270','29830','28607','25189','33662','33618','25928','35412','14399','24080','32416','31921','18562','27860','33637','35608','31278','35801','30965','33580','33530','32426','15279','28010','24598','35931','35933','35236','35941','36207','5119','26155','36211') OR ( sc.`idcontact`=484 OR sc.`idcontact_festival`=484 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
18 | 1.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 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 (484) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND ((s1_.date BETWEEN '2024-04-26' AND '2026-04-16')) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
19 | 0.84 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 (484) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date < '2024-04-26' ORDER BY s1_.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
20 | 7.04 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-26' AND (s0_.publish = 1 AND (s1_.idcontact = 484 OR s1_.idcontact_festival = 484)) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
21 | 91.81 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 = 484 OR s1_.idcontact_festival = 484)) ORDER BY s1_.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
22 | 1.14 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 = 484)) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
23 | 422.30 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 = 484 OR s0_.idcontact_production = 484)) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
24 | 31.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 s1_.date >= '2024-04-26' AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 484 OR s0_.idcontact_production = 484)) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
25 | 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 WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s0_.idspectacle IN (13030, 23529, 25760, 25895, 26350, 29238, 19214, 22485) AND s1_.date >= '2024-04-26' ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
26 | 7.02 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-26' AND (s0_.publish = 1 AND (s1_.idcontact = 484 OR s1_.idcontact_festival = 484)) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
27 | 68.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 = 484 OR s1_.idcontact_festival = 484)) ORDER BY s1_.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
28 | 0.92 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 = 484)) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
29 | 223.53 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 = 484 OR s0_.idcontact_production = 484)) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
30 | 23.59 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-26' AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 484 OR s0_.idcontact_production = 484)) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
31 | 1.13 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 s0_.idspectacle IN (13030, 23529, 25760, 25895, 26350, 29238, 19214, 22485) AND s1_.date >= '2024-04-26' ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
32 | 6.24 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 (533,743,1577,1595,1822,1898,1917,1984,1985,2622,2956,2967,3284,3393,3588,3595,3601,3917,4054,4055,4106,4208,4224,4286,4626,4954,5082,5181,5200,5266,5279,5446,6735,6763,7298,7394,8120,8324,8351,8355,8587,8635,8874,9252,10479,10639,10931,11410,11571,11692,11862,11961,12027,12073,12127,12132,12135,12138,12176,14035,14587,14609,14727,14804,14900,14977,15209,15226,15229,15236,15239,16119,17380,17393,17465,17566,17587,17785,17802,17810,17812,17822,17854,19638,19794,19941,20710,20780,20821,21031,21071,21269,21304,21715,22040,22594,23606,23676,23686,23699,23809,23810,23813,23815,23828,23831,23838,24268,26181,26352,26476,26595,26603,26606,26614,26616,26617,26619,26628,26629,27057,29099,29355,29368,29395,29834,29985,30032,30113,30226,30337,30437,30701,30703,30707,31000,31005,31013,31015,31018,31021,31039,31041,31058,31059,31090,31100,31102,31103,31150,31212,32115,32445,32637,33117,33127,33301,33429,33484,33495,33498,33502,33503,33751,34030,34218,34517,35418,35541,35870,35928,35929,35930,35932,35940,36069,36106,36115,36208) AND s.date>='2024-04-26' ORDER BY s.date ASC LIMIT 0,1000
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
33 | 0.34 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:
[
"35870"
]
|
||||||||||||||||||||||||||||||||||
34 | 0.08 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
35 | 0.04 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
36 | 0.46 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=35870 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
37 | 0.15 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44232"
]
|
||||||||||||||||||||||||||||||||||
38 | 0.32 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean FROM texts t, text_traduction tt WHERE t.idtext=tt.idtext AND tt.idtexttraduction=44232 ORDER BY t.title
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
39 | 0.67 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=10904 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
40 | 0.79 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=35870 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
41 | 0.09 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:
[
"35870"
]
|
||||||||||||||||||||||||||||||||||
42 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
43 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
44 | 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=35870 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
45 | 0.05 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44232"
]
|
||||||||||||||||||||||||||||||||||
46 | 0.04 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean FROM texts t, text_traduction tt WHERE t.idtext=tt.idtext AND tt.idtexttraduction=44232 ORDER BY t.title
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
47 | 0.05 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=10904 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
48 | 0.06 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=35870 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
49 | 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:
[
"35870"
]
|
||||||||||||||||||||||||||||||||||
50 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
51 | 0.04 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
52 | 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=35870 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
53 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44232"
]
|
||||||||||||||||||||||||||||||||||
54 | 0.04 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean FROM texts t, text_traduction tt WHERE t.idtext=tt.idtext AND tt.idtexttraduction=44232 ORDER BY t.title
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
55 | 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=10904 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
56 | 0.04 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=35870 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
57 | 0.27 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
58 | 0.05 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
59 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
60 | 0.24 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
61 | 0.15 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
62 | 0.28 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
63 | 0.64 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
64 | 0.08 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
65 | 0.05 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
66 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
67 | 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=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
68 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
69 | 0.08 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
70 | 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
71 | 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:
[
"35870"
]
|
||||||||||||||||||||||||||||||||||
72 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
73 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
74 | 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=35870 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
75 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44232"
]
|
||||||||||||||||||||||||||||||||||
76 | 0.04 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean FROM texts t, text_traduction tt WHERE t.idtext=tt.idtext AND tt.idtexttraduction=44232 ORDER BY t.title
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
77 | 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=10904 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
78 | 0.06 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=35870 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
79 | 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:
[
"35870"
]
|
||||||||||||||||||||||||||||||||||
80 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
81 | 0.20 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
82 | 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=35870 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
83 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44232"
]
|
||||||||||||||||||||||||||||||||||
84 | 0.04 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean FROM texts t, text_traduction tt WHERE t.idtext=tt.idtext AND tt.idtexttraduction=44232 ORDER BY t.title
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
85 | 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=10904 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
86 | 0.07 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=35870 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
87 | 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:
[
"35870"
]
|
||||||||||||||||||||||||||||||||||
88 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
89 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
90 | 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=35870 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
91 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44232"
]
|
||||||||||||||||||||||||||||||||||
92 | 0.04 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean FROM texts t, text_traduction tt WHERE t.idtext=tt.idtext AND tt.idtexttraduction=44232 ORDER BY t.title
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
93 | 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=10904 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
94 | 0.04 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=35870 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
95 | 0.31 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:
[
"35541"
]
|
||||||||||||||||||||||||||||||||||
96 | 0.05 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
97 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
98 | 0.25 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=35541 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
99 | 0.13 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"43842"
]
|
||||||||||||||||||||||||||||||||||
100 | 0.35 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=43842 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
101 | 0.63 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=35541 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
102 | 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:
[
"35870"
]
|
||||||||||||||||||||||||||||||||||
103 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
104 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
105 | 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=35870 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
106 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44232"
]
|
||||||||||||||||||||||||||||||||||
107 | 0.04 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean FROM texts t, text_traduction tt WHERE t.idtext=tt.idtext AND tt.idtexttraduction=44232 ORDER BY t.title
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
108 | 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=10904 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
109 | 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=35870 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
110 | 0.09 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:
[
"35541"
]
|
||||||||||||||||||||||||||||||||||
111 | 0.05 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
112 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
113 | 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=35541 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
114 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"43842"
]
|
||||||||||||||||||||||||||||||||||
115 | 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=43842 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
116 | 0.04 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=35541 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
117 | 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:
[
"35870"
]
|
||||||||||||||||||||||||||||||||||
118 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
119 | 0.06 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
120 | 0.09 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=35870 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
121 | 0.07 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44232"
]
|
||||||||||||||||||||||||||||||||||
122 | 0.13 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean FROM texts t, text_traduction tt WHERE t.idtext=tt.idtext AND tt.idtexttraduction=44232 ORDER BY t.title
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
123 | 0.06 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=10904 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
124 | 0.07 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=35870 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
125 | 0.09 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:
[
"35541"
]
|
||||||||||||||||||||||||||||||||||
126 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
127 | 0.06 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
128 | 0.06 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=35541 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
129 | 0.07 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"43842"
]
|
||||||||||||||||||||||||||||||||||
130 | 0.10 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=43842 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
131 | 0.07 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=35541 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
132 | 0.08 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:
[
"35870"
]
|
||||||||||||||||||||||||||||||||||
133 | 0.15 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
134 | 0.06 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
135 | 0.06 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=35870 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
136 | 0.07 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44232"
]
|
||||||||||||||||||||||||||||||||||
137 | 0.06 ms |
SELECT t.idtext, t.title, t.type, t.language, t.date, t.url_clean FROM texts t, text_traduction tt WHERE t.idtext=tt.idtext AND tt.idtexttraduction=44232 ORDER BY t.title
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
138 | 0.10 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=10904 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
139 | 0.07 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=35870 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
140 | 0.32 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
141 | 0.07 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
142 | 0.05 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
143 | 0.30 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
144 | 0.25 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
145 | 0.35 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
146 | 0.48 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
147 | 0.09 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
148 | 0.07 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
149 | 0.10 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
150 | 0.06 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
151 | 0.11 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
152 | 0.06 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
153 | 0.07 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
154 | 0.09 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
155 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
156 | 0.05 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
157 | 0.07 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
158 | 0.06 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
159 | 0.07 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
160 | 0.07 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
161 | 0.34 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:
[
"33751"
]
|
||||||||||||||||||||||||||||||||||
162 | 0.07 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
163 | 0.06 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
164 | 0.31 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=33751 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
165 | 0.26 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"42027"
]
|
||||||||||||||||||||||||||||||||||
166 | 0.35 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=42027 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
167 | 0.60 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=33751 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
168 | 0.09 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
169 | 0.07 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
170 | 0.06 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
171 | 0.06 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
172 | 0.06 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
173 | 0.06 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
174 | 0.07 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
175 | 0.08 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
176 | 0.08 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
177 | 0.05 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
178 | 0.05 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
179 | 0.06 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
180 | 0.06 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
181 | 0.06 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
182 | 0.09 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:
[
"33751"
]
|
||||||||||||||||||||||||||||||||||
183 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
184 | 0.06 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
185 | 0.08 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=33751 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
186 | 0.06 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"42027"
]
|
||||||||||||||||||||||||||||||||||
187 | 0.07 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=42027 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
188 | 0.06 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=33751 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
189 | 0.08 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
190 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
191 | 0.14 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
192 | 0.09 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
193 | 0.07 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
194 | 0.06 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
195 | 0.10 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
196 | 0.09 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
197 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
198 | 0.05 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
199 | 0.05 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
200 | 0.06 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
201 | 0.06 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
202 | 0.06 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
203 | 0.08 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
204 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
205 | 0.05 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
206 | 0.06 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
207 | 0.06 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
208 | 0.06 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
209 | 0.06 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
210 | 0.08 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
211 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
212 | 0.05 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
213 | 0.05 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
214 | 0.06 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
215 | 0.06 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
216 | 0.06 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
217 | 0.08 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
218 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
219 | 0.05 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
220 | 0.06 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
221 | 0.12 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
222 | 0.07 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
223 | 0.07 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
224 | 0.08 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
225 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
226 | 0.05 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
227 | 0.06 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
228 | 0.06 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
229 | 0.06 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
230 | 0.06 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
231 | 0.09 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
232 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
233 | 0.05 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
234 | 0.08 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
235 | 0.06 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
236 | 0.07 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
237 | 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
238 | 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
239 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
240 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
241 | 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=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
242 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
243 | 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
244 | 0.04 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
245 | 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
246 | 0.27 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
247 | 0.13 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
248 | 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=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
249 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
250 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
251 | 0.04 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
252 | 0.10 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
253 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
254 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
255 | 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=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
256 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
257 | 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
258 | 0.04 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
259 | 0.08 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
260 | 0.05 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
261 | 0.04 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
262 | 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=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
263 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
264 | 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
265 | 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
266 | 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
267 | 0.05 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
268 | 0.04 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
269 | 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=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
270 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
271 | 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
272 | 0.04 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
273 | 0.29 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:
[
"34030"
]
|
||||||||||||||||||||||||||||||||||
274 | 0.05 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
275 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
276 | 0.25 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=34030 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
277 | 0.14 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"42301"
]
|
||||||||||||||||||||||||||||||||||
278 | 0.41 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=42301 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
279 | 0.65 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=34030 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
280 | 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
281 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
282 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
283 | 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=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
284 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
285 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
286 | 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
287 | 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:
[
"34030"
]
|
||||||||||||||||||||||||||||||||||
288 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
289 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
290 | 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=34030 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
291 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"42301"
]
|
||||||||||||||||||||||||||||||||||
292 | 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=42301 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
293 | 0.16 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=34030 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
294 | 0.09 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
295 | 0.05 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
296 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
297 | 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=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
298 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
299 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
300 | 0.04 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
301 | 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:
[
"34030"
]
|
||||||||||||||||||||||||||||||||||
302 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
303 | 0.04 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
304 | 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=34030 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
305 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"42301"
]
|
||||||||||||||||||||||||||||||||||
306 | 0.05 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=42301 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
307 | 0.09 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=34030 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
308 | 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:
[
"34030"
]
|
||||||||||||||||||||||||||||||||||
309 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
310 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
311 | 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=34030 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
312 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"42301"
]
|
||||||||||||||||||||||||||||||||||
313 | 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=42301 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
314 | 0.06 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=34030 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
315 | 0.10 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:
[
"34030"
]
|
||||||||||||||||||||||||||||||||||
316 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
317 | 0.05 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
318 | 0.06 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=34030 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
319 | 0.06 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"42301"
]
|
||||||||||||||||||||||||||||||||||
320 | 0.06 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=42301 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
321 | 0.07 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=34030 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
322 | 0.08 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
323 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
324 | 0.05 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
325 | 0.06 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
326 | 0.06 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
327 | 0.06 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
328 | 0.06 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
329 | 0.09 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
330 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
331 | 0.06 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
332 | 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=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
333 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
334 | 0.05 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
335 | 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
336 | 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
337 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
338 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
339 | 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=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
340 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
341 | 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
342 | 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
343 | 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:
[
"33117"
]
|
||||||||||||||||||||||||||||||||||
344 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
345 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
346 | 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=33117 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
347 | 0.05 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"41245"
]
|
||||||||||||||||||||||||||||||||||
348 | 0.05 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=41245 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
349 | 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=33117 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
350 | 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
351 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
352 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
353 | 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=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
354 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
355 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
356 | 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
357 | 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
358 | 0.05 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
359 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
360 | 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=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
361 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
362 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
363 | 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
364 | 0.05 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
365 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
366 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
367 | 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=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
368 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
369 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
370 | 0.04 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
371 | 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
372 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
373 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
374 | 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=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
375 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
376 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
377 | 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
378 | 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
379 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
380 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
381 | 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=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
382 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
383 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
384 | 0.04 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
385 | 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
386 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
387 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
388 | 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=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
389 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
390 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
391 | 0.04 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
392 | 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
393 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
394 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
395 | 0.03 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
396 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
397 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
398 | 0.04 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
399 | 0.05 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
400 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
401 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
402 | 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=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
403 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
404 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
405 | 0.04 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
406 | 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
407 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
408 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
409 | 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=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
410 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
411 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
412 | 0.04 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
413 | 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
414 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
415 | 0.03 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
416 | 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=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
417 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
418 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
419 | 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
420 | 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:
[
"36115"
]
|
||||||||||||||||||||||||||||||||||
421 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
422 | 0.04 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
423 | 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=36115 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
424 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"44406"
]
|
||||||||||||||||||||||||||||||||||
425 | 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=44406 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
426 | 0.04 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=36115 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
427 | 0.09 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`=484 OR spectacles.`idcontact_production`=484) AND spectacle_contact.`idrole` IN (17,18,19)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
428 | 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`=484 OR spectacles.`idcontact_production`=484) AND spectacle_contact.`idrole` = 77
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
429 | 4.98 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 (533,743,1577,1595,1822,1898,1917,1984,1985,2622,2956,2967,3284,3393,3588,3595,3601,3917,4054,4055,4106,4208,4224,4286,4626,4954,5082,5181,5200,5266,5279,5446,6735,6763,7298,7394,8120,8324,8351,8355,8587,8635,8874,9252,10479,10639,10931,11410,11571,11692,11862,11961,12027,12073,12127,12132,12135,12138,12176,14035,14587,14609,14727,14804,14900,14977,15209,15226,15229,15236,15239,16119,17380,17393,17465,17566,17587,17785,17802,17810,17812,17822,17854,19638,19794,19941,20710,20780,20821,21031,21071,21269,21304,21715,22040,22594,23606,23676,23686,23699,23809,23810,23813,23815,23828,23831,23838,24268,26181,26352,26476,26595,26603,26606,26614,26616,26617,26619,26628,26629,27057,29099,29355,29368,29395,29834,29985,30032,30113,30226,30337,30437,30701,30703,30707,31000,31005,31013,31015,31018,31021,31039,31041,31058,31059,31090,31100,31102,31103,31150,31212,32115,32445,32637,33117,33127,33301,33429,33484,33495,33498,33502,33503,33751,34030,34218,34517,35418,35541,35870,35928,35929,35930,35932,35940,36069,36106,36115,36208) AND s.date>='2024-04-26' AND c.idcontact = 484 ORDER BY s.date ASC LIMIT 0,1000
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
430 | 0.08 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 (533,743,1577,1595,1822,1898,1917,1984,1985,2622,2956,2967,3284,3393,3588,3595,3601,3917,4054,4055,4106,4208,4224,4286,4626,4954,5082,5181,5200,5266,5279,5446,6735,6763,7298,7394,8120,8324,8351,8355,8587,8635,8874,9252,10479,10639,10931,11410,11571,11692,11862,11961,12027,12073,12127,12132,12135,12138,12176,14035,14587,14609,14727,14804,14900,14977,15209,15226,15229,15236,15239,16119,17380,17393,17465,17566,17587,17785,17802,17810,17812,17822,17854,19638,19794,19941,20710,20780,20821,21031,21071,21269,21304,21715,22040,22594,23606,23676,23686,23699,23809,23810,23813,23815,23828,23831,23838,24268,26181,26352,26476,26595,26603,26606,26614,26616,26617,26619,26628,26629,27057,29099,29355,29368,29395,29834,29985,30032,30113,30226,30337,30437,30701,30703,30707,31000,31005,31013,31015,31018,31021,31039,31041,31058,31059,31090,31100,31102,31103,31150,31212,32115,32445,32637,33117,33127,33301,33429,33484,33495,33498,33502,33503,33751,34030,34218,34517,35418,35541,35870,35928,35929,35930,35932,35940,36069,36106,36115,36208) AND s.date>='2024-04-26' AND c.idcontact = 484 ORDER BY s.date ASC LIMIT 0,1000
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
431 | 0.13 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 (533,743,1577,1595,1822,1898,1917,1984,1985,2622,2956,2967,3284,3393,3588,3595,3601,3917,4054,4055,4106,4208,4224,4286,4626,4954,5082,5181,5200,5266,5279,5446,6735,6763,7298,7394,8120,8324,8351,8355,8587,8635,8874,9252,10479,10639,10931,11410,11571,11692,11862,11961,12027,12073,12127,12132,12135,12138,12176,14035,14587,14609,14727,14804,14900,14977,15209,15226,15229,15236,15239,16119,17380,17393,17465,17566,17587,17785,17802,17810,17812,17822,17854,19638,19794,19941,20710,20780,20821,21031,21071,21269,21304,21715,22040,22594,23606,23676,23686,23699,23809,23810,23813,23815,23828,23831,23838,24268,26181,26352,26476,26595,26603,26606,26614,26616,26617,26619,26628,26629,27057,29099,29355,29368,29395,29834,29985,30032,30113,30226,30337,30437,30701,30703,30707,31000,31005,31013,31015,31018,31021,31039,31041,31058,31059,31090,31100,31102,31103,31150,31212,32115,32445,32637,33117,33127,33301,33429,33484,33495,33498,33502,33503,33751,34030,34218,34517,35418,35541,35870,35928,35929,35930,35932,35940,36069,36106,36115,36208) AND s.date>='2024-04-26' ORDER BY s.date ASC LIMIT 0,1000
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
432 | 1.10 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
433 | 0.46 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
434 | 0.35 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
435 | 0.33 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
436 | 0.57 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
437 | 0.54 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
438 | 0.24 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
439 | 0.38 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
440 | 0.31 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
441 | 0.23 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
442 | 0.26 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
443 | 0.26 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
444 | 1.08 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 (484) AND a9_.type_aide IN (4) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND ((s1_.date BETWEEN '2024-04-26' AND '2026-04-16')) AND s0_.idtypespectacle <> 1 ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
445 | 0.79 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 (484) AND a9_.type_aide IN (4) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date < '2024-04-26' ORDER BY s1_.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
446 | 0.23 ms |
SELECT COUNT(DISTINCT(idperson)) FROM person_ecole WHERE 1 AND idcontact=484
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
447 | 0.09 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 (743,46,1783,1802,1898,1984,2338,787,2175,2336,2622,1794,2691,1522,2726,2168,2956,2967,2996,2344,2839,3284,3306,1931,3393,1577,3452,3588,3595,3601,3706,3034,2402,3790,3917,3951,1985,4036,4054,1073,4055,4106,4025,4013,3211,4208,4214,4223,4224,3582,4272,4286,3577,4042,4322,2254,4307,4280,4602,4626,4689,3899,4758,3308,4870,4909,4954,5022,5181,5082,5200,5222,4457,4699,5240,5266,5308,5335,5393,5419,5446,4291,5557,5566,3930,5838,5745,5092,5141,6560,6703,6763,6865,7021,7094,7038,5144,7173,7298,7394,1788,730,7683,6512,8120,8323,8324,8351,8354,8492,8635,7450,6307,8224,7979,5510,8355,7296,6736,7460,6561,8587,8873,8874,8876,8878,9252,8168,5149,10479,10639,10931,11862,11961,8372,11571,11410,8388,11194,11692,10537,12073,12132,12135,5156,9512,12044,12136,12137,12138,12176,12195,12027,12597,4926,14035,14804,14322,14609,14587,4554,6755,13629,11275,5010,5828,14702,14648,15226,15228,15229,15230,15233,14977,15235,15236,14900,15239,17465,16119,15608,15045,17231,17380,13732,17271,8041,17656,17785,17802,17803,17804,17810,17812,17814,17822,17587,17826,17850,17854,14586,14886,17566,17393,19675,19941,17749,12127,18012,18246,19193,19638,20710,20821,17237,20919,20914,21031,21071,21269,21304,20745,21056,19794,21715,21721,20780,22038,22049,22054,21147,22594,23501,23502,23131,23606,22040,21720,23410,20696,21207,17366,23359,23676,23807,23809,23810,23815,23813,23818,23819,23686,23699,23827,23828,23830,23831,23833,23834,23835,23843,23838,23973,24427,26181,25837,24268,24010,26253,25310,24111,25475,23697,19195,26399,23529,25895,26524,26352,26593,26594,26603,26606,26612,26614,26617,26545,26628,13030,26476,25549,26142,26845,25188,27533,3219,10738,28554,25756,26616,26135,14024,26790,27924,22485,29238,25760,29904,30016,30113,30604,8439,27891,19214,24046,30753,26531,27057,29355,29368,21398,28521,30701,26595,29395,26619,30032,30703,30354,21978,28732,26629,30996,28536,31000,31004,31005,31013,31015,31017,31018,31019,26350,31020,31021,31039,31041,31055,31058,31059,31060,31097,31102,31103,31110,31090,31056,31100,30226,31549,31994,29760,31150,32940,32445,29182,26597,30224,5580,31212,20986,30592,33117,33112,30527,30437,30808,29234,29412,33429,29099,29985,29270,33484,33495,33498,33503,33127,29830,28607,33502,25189,33662,34218,34517,33618,25928,35412,35541,14399,24080,32416,31921,33751,35870,18562,27860,33637,35608,31278,35801,30965,33580,33530,32426,15279,28010,34030,24598,35928,35929,35930,35931,35932,35933,35236,35940,35941,33301,35418,36069,36106,36115,36207,5119,26155,36211,36208,533,743,1577,1595,1822,1898,1917,1984,1985,2622,2956,2967,3284,3393,3588,3595,3601,3917,4054,4055,4106,4208,4224,4286,4626,4954,5082,5181,5200,5266,5279,5446,6735,6763,7298,7394,8120,8324,8351,8355,8587,8635,8874,9252,10479,10639,10931,11410,11571,11692,11862,11961,12027,12073,12127,12132,12135,12138,12176,14035,14587,14609,14727,14804,14900,14977,15209,15226,15229,15236,15239,16119,17380,17393,17465,17566,17587,17785,17802,17810,17812,17822,17854,19638,19794,19941,20710,20780,20821,21031,21071,21269,21304,21715,22040,22594,23606,23676,23686,23699,23809,23810,23813,23815,23828,23831,23838,24268,26181,26352,26476,26595,26603,26606,26614,26616,26617,26619,26628,26629,27057,29099,29355,29368,29395,29834,29985,30032,30113,30226,30337,30437,30701,30703,30707,31000,31005,31013,31015,31018,31021,31039,31041,31058,31059,31090,31100,31102,31103,31150,31212,32115,32445,32637,33117,33127,33301,33429,33484,33495,33498,33502,33503,33751,34030,34218,34517,35418,35541,35870,35928,35929,35930,35932,35940,36069,36106,36115,36208) ) 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=484 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
448 | 0.05 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_presentation_structure'))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
449 | 1.53 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='484' 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:
[]
|
||||||||||||||||||||||||||||||||||
450 | 0.42 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=67651
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
451 | 0.04 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_article'))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
452 | 1.11 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='484' 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:
[]
|
||||||||||||||||||||||||||||||||||
453 | 0.04 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
454 | 0.04 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
455 | 0.03 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
456 | 0.04 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
457 | 0.27 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
458 | 0.26 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
459 | 0.18 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
460 | 0.17 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
461 | 0.34 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=484 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:
[]
|
||||||||||||||||||||||||||||||||||
462 | 0.04 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
463 | 0.04 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
464 | 0.03 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
465 | 0.03 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
466 | 0.04 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
467 | 0.03 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
468 | 0.04 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
469 | 0.03 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=484 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
470 | 0.70 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 (484) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||||
471 | 0.80 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=484 ) AND T1.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
472 | 6.08 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(533,743,1577,1595,1822,1898,1917,1984,1985,2622,2956,2967,3284,3393,3588,3595,3601,3917,4054,4055,4106,4208,4224,4286,4626,4954,5082,5181,5200,5266,5279,5446,6735,6763,7298,7394,8120,8324,8351,8355,8587,8635,8874,9252,10479,10639,10931,11410,11571,11692,11862,11961,12027,12073,12127,12132,12135,12138,12176,14035,14587,14609,14727,14804,14900,14977,15209,15226,15229,15236,15239,16119,17380,17393,17465,17566,17587,17785,17802,17810,17812,17822,17854,19638,19794,19941,20710,20780,20821,21031,21071,21269,21304,21715,22040,22594,23606,23676,23686,23699,23809,23810,23813,23815,23828,23831,23838,24268,26181,26352,26476,26595,26603,26606,26614,26616,26617,26619,26628,26629,27057,29099,29355,29368,29395,29834,29985,30032,30113,30226,30337,30437,30701,30703,30707,31000,31005,31013,31015,31018,31021,31039,31041,31058,31059,31090,31100,31102,31103,31150,31212,32115,32445,32637,33117,33127,33301,33429,33484,33495,33498,33502,33503,33751,34030,34218,34517,35418,35541,35870,35928,35929,35930,35932,35940,36069,36106,36115,36208,46,1783,1802,2338,787,2175,2336,1794,2691,1522,2726,2168,2996,2344,2839,3306,1931,3452,3706,3034,2402,3790,3951,4036,1073,4025,4013,3211,4214,4223,3582,4272,3577,4042,4322,2254,4307,4280,4602,4689,3899,4758,3308,4870,4909,5022,5222,4457,4699,5240,5308,5335,5393,5419,4291,5557,5566,3930,5838,5745,5092,5141,6560,6703,6865,7021,7094,7038,5144,7173,1788,730,7683,6512,8323,8354,8492,7450,6307,8224,7979,5510,7296,6736,7460,6561,8873,8876,8878,8168,5149,8372,8388,11194,10537,5156,9512,12044,12136,12137,12195,12597,4926,14322,4554,6755,13629,11275,5010,5828,14702,14648,15228,15230,15233,15235,15608,15045,17231,13732,17271,8041,17656,17803,17804,17814,17826,17850,14586,14886,19675,17749,18012,18246,19193,17237,20919,20914,20745,21056,21721,22038,22049,22054,21147,23501,23502,23131,21720,23410,20696,21207,17366,23359,23807,23818,23819,23827,23830,23833,23834,23835,23843,23973,24427,25837,24010,26253,25310,24111,25475,23697,19195,26399,23529,25895,26524,26593,26594,26612,26545,13030,25549,26142,26845,25188,27533,3219,10738,28554,25756,26135,14024,26790,27924,22485,29238,25760,29904,30016,30604,8439,27891,19214,24046,30753,26531,21398,28521,30354,21978,28732,30996,28536,31004,31017,31019,26350,31020,31055,31060,31097,31110,31056,31549,31994,29760,32940,29182,26597,30224,5580,20986,30592,33112,30527,30808,29234,29412,29270,29830,28607,25189,33662,33618,25928,35412,14399,24080,32416,31921,18562,27860,33637,35608,31278,35801,30965,33580,33530,32426,15279,28010,24598,35931,35933,35236,35941,36207,5119,26155,36211) AND d.code_franceinter IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
473 | 0.39 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:
[
484
]
|
||||||||||||||||||||||||||||||||||
474 | 1972.56 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=484 OR schedules.idcontact_festival=484) AND contents.`publish`=1 AND contents.`valid`=1 AND object_content.`object`='spectacles' AND content_classification.`idclassification` IN (125)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
475 | 20.88 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`=484 OR spectacles.`idcontact_production`=484) 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:
[]
|
||||||||||||||||||||||||||||||||||
476 | 0.08 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:
[]
|
||||||||||||||||||||||||||||||||||
477 | 0.05 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:
[]
|
||||||||||||||||||||||||||||||||||
478 | 1.48 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='484' 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:
[]
|
||||||||||||||||||||||||||||||||||
479 | 0.04 ms |
SELECT COUNT(DISTINCT(idperson)) FROM person_ecole WHERE 1 AND idcontact=484
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
480 | 0.87 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:
[ "b6a8340dd32a0b6736df92221ba7d316-a122" 0 "6d0a570276c43eb20c2af6ef540331a9" ]
|
||||||||||||||||||||||||||||||||||
481 | 2.25 ms |
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "article" "thnet" "/contacts/Theatre-Les-Celestins/calendrier/" "6d0a570276c43eb20c2af6ef540331a9" 0 "contacts" 484 0 "fr" "b6a8340dd32a0b6736df92221ba7d316-a122" "/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829" ]
|
||||||||||||||||||||||||||||||||||
482 | 0.91 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