Query Metrics
135
Database Queries
79
Different statements
1465.57 ms
Query time
1
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.37 ms |
SELECT idcontact FROM contacts WHERE url_clean='Theatre-Garonne'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
2 | 0.92 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:
[
717
]
|
||||||||||||||||||||||||||||||||||
3 | 0.09 ms |
SELECT fr FROM countries WHERE id='FR'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
4 | 0.33 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:
[
"THIN"
]
|
||||||||||||||||||||||||||||||||||
5 | 0.63 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=717 AND j2.idoffice=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
6 | 0.09 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (100))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
7 | 2.95 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='717' 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.23 ms |
SELECT classification FROM classifications WHERE idclassification=100
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
9 | 6.98 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM schedules, spectacles WHERE schedules.idspectacle=spectacles.idspectacle AND spectacles.publish=1 AND (schedules.idcontact=717 OR schedules.idcontact_festival=717)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
10 | 74.36 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`=717 OR spectacles.`idcontact_production`=717) AND spectacle_contact.`idrole` IN (17,18,19)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
11 | 1.66 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`=717 OR spectacles.`idcontact_production`=717) AND spectacle_contact.`idrole` = 77
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
12 | 0.24 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`=717
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
13 | 0.24 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`=717 AND aides.type_aide IN (2,3)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
14 | 0.19 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`=717 AND aides.type_aide IN (1)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
15 | 0.18 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_aide ON spectacle_aide.`idspectacle`=spectacles.`idspectacle` INNER JOIN aides ON aides.`idaide`=spectacle_aide.`idaide` WHERE spectacles.`publish`=1 AND aides.`idcontact`=717 AND aides.type_aide IN (4)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
16 | 18.86 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 (174,724,734,900,1463,1525,1613,1295,2159,2181,2269,2185,2380,1881,2098,1929,2950,3051,1851,2816,3086,3100,3101,3129,3212,3302,3329,2962,2111,1815,1816,2238,2855,3481,3558,3663,2822,3705,3906,3948,4012,4040,1611,4125,4188,4254,4311,4122,4553,4430,2254,4620,4621,4106,3732,4677,4714,4744,3667,4782,4813,4201,4871,5137,5148,4462,4812,5193,5202,5212,4241,5264,4700,5294,4619,5320,5370,5394,5465,4885,4850,6327,6342,6905,6923,4943,5463,5300,2374,7301,2994,13253,12337,14023,14324,14399,15355,14753,16219,16229,16231,16554,11727,8426,13864,15803,18137,17574,18720,18311,18335,18182,10458,14408,15708,18121,18263,13551,17662,18197,19299,19452,19758,20754,21400,14018,20653,20987,19454,17621,19342,21023,20147,13841,18284,14722,3988,11684,21281,20729,22378,21743,23372,22560,23727,24590,17253,21390,23291,14986,24193,3739,25130,20709,26814,26864,27002,27058,27259,27346,27670,28201,28391,28606,28690,29072,28148,29855,29593,29079,30605,20782,26838,31343,31692,25928,30996,31336,30999,32305,31840,29512,18287,32549,32706,29868,33252,33127,5945,33652,17133,34198,34556,34626,34675,33705,28135,29782,14024,35588,14676,36381,4372,35607,36328,36304,31241,36557,36201,34478,32528,37079,36519,7105,31710,724,1295,1463,1929,2180,2181,3062,3129,3302,3329,3481,3558,3663,3667,3705,3906,4012,4040,4066,4202,4241,4311,4372,4620,4677,4714,4812,4813,4885,4943,5193,5202,5212,5294,5320,5351,5394,5465,6675,6905,6923,7105,8544,9101,9463,9464,9847,11550,11577,11715,11922,12253,13636,13707,13841,13858,14023,14324,14399,14587,14753,15526,15803,16554,17021,17703,18121,18137,18182,18237,18263,18266,18287,18578,18720,19299,19452,19685,20147,20709,20729,21203,21400,21743,22889,23919,23981,24254,24539,24956,25928,26055,26700,26814,26864,27002,27058,27180,27259,27346,27443,28201,28391,28435,28690,29024,29512,29593,29868,30787,30996,30999,31217,31238,31336,31343,31498,31840,32303,32549,32686,32706,33127,33252,33652,33705,34626,34675,35573,35588,35607,35931,36181,36201,36304,36342,36402,36557,37257) ) 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=717 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
17 | 667.14 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 ('724','1295','1463','1929','2180','2181','3062','3129','3302','3329','3481','3558','3663','3667','3705','3906','4012','4040','4066','4202','4241','4311','4372','4620','4677','4714','4812','4813','4885','4943','5193','5202','5212','5294','5320','5351','5394','5465','6675','6905','6923','7105','8544','9101','9463','9464','9847','11550','11577','11715','11922','12253','13636','13707','13841','13858','14023','14324','14399','14587','14753','15526','15803','16554','17021','17703','18121','18137','18182','18237','18263','18266','18287','18578','18720','19299','19452','19685','20147','20709','20729','21203','21400','21743','22889','23919','23981','24254','24539','24956','25928','26055','26700','26814','26864','27002','27058','27180','27259','27346','27443','28201','28391','28435','28690','29024','29512','29593','29868','30787','30996','30999','31217','31238','31336','31343','31498','31840','32303','32549','32686','32706','33127','33252','33652','33705','34626','34675','35573','35588','35607','35931','36181','36201','36304','36342','36402','36557','37257','174','734','900','1525','1613','2159','2269','2185','2380','1881','2098','2950','3051','1851','2816','3086','3100','3101','3212','2962','2111','1815','1816','2238','2855','2822','3948','1611','4125','4188','4254','4122','4553','4430','2254','4621','4106','3732','4744','4782','4201','4871','5137','5148','4462','5264','4700','4619','5370','4850','6327','6342','5463','5300','2374','7301','2994','13253','12337','15355','16219','16229','16231','11727','8426','13864','17574','18311','18335','10458','14408','15708','13551','17662','18197','19758','20754','14018','20653','20987','19454','17621','19342','21023','18284','14722','3988','11684','21281','22378','23372','22560','23727','24590','17253','21390','23291','14986','24193','3739','25130','27670','28606','29072','28148','29855','29079','30605','20782','26838','31692','32305','5945','17133','34198','34556','28135','29782','14024','14676','36381','36328','31241','34478','32528','37079','36519','31710') OR ( sc.`idcontact`=717 OR sc.`idcontact_festival`=717 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
18 | 0.83 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 (717) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND ((s1_.date BETWEEN '2024-04-30' AND '2026-04-20')) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
19 | 0.87 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 (717) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date < '2024-04-30' ORDER BY s1_.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
20 | 2.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 WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND s1_.date >= '2024-04-30' AND (s0_.publish = 1 AND s1_.idcontact = 717) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
21 | 12.32 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 = 717) ORDER BY s1_.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
22 | 0.75 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 = 717)) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
23 | 182.86 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 = 717 OR s0_.idcontact_production = 717)) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
24 | 19.88 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact 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-30' AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 717 OR s0_.idcontact_production = 717)) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
25 | 2.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 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-30' AND (s0_.publish = 1 AND s1_.idcontact = 717) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
26 | 8.39 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 = 717) ORDER BY s1_.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
27 | 0.69 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 = 717)) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
28 | 62.37 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 = 717 OR s0_.idcontact_production = 717)) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
29 | 14.42 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-30' AND (s0_.publish = 1 AND s8_.idspectacle = s0_.idspectacle AND s8_.idrole IN (17, 18, 19) AND (s8_.idcontact = 717 OR s0_.idcontact_production = 717)) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
30 | 3.61 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 (174,724,734,900,1463,1525,1613,1295,2159,2181,2269,2185,2380,1881,2098,1929,2950,3051,1851,2816,3086,3100,3101,3129,3212,3302,3329,2962,2111,1815,1816,2238,2855,3481,3558,3663,2822,3705,3906,3948,4012,4040,1611,4125,4188,4254,4311,4122,4553,4430,2254,4620,4621,4106,3732,4677,4714,4744,3667,4782,4813,4201,4871,5137,5148,4462,4812,5193,5202,5212,4241,5264,4700,5294,4619,5320,5370,5394,5465,4885,4850,6327,6342,6905,6923,4943,5463,5300,2374,7301,2994,13253,12337,14023,14324,14399,15355,14753,16219,16229,16231,16554,11727,8426,13864,15803,18137,17574,18720,18311,18335,18182,10458,14408,15708,18121,18263,13551,17662,18197,19299,19452,19758,20754,21400,14018,20653,20987,19454,17621,19342,21023,20147,13841,18284,14722,3988,11684,21281,20729,22378,21743,23372,22560,23727,24590,17253,21390,23291,14986,24193,3739,25130,20709,26814,26864,27002,27058,27259,27346,27670,28201,28391,28606,28690,29072,28148,29855,29593,29079,30605,20782,26838,31343,31692,25928,30996,31336,30999,32305,31840,29512,18287,32549,32706,29868,33252,33127,5945,33652,17133,34198,34556,34626,34675,33705,28135,29782,14024,35588,14676,36381,4372,35607,36328,36304,31241,36557,36201,34478,32528,37079,36519,7105,31710) AND s.date>='2024-04-30' AND c.idcontact = 717 ORDER BY s.date ASC LIMIT 0,1000
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
31 | 0.36 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:
[
"14676"
]
|
||||||||||||||||||||||||||||||||||
32 | 0.44 ms |
SELECT t0.idcontact AS idcontact_1, t0.type AS type_2, t0.organisation AS organisation_3, t0.nom_suite AS nom_suite_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.idtypestructure AS idtypestructure_7, t0.license AS license_8, t0.comment AS comment_9, t0.private_comment AS private_comment_10, t0.address1 AS address1_11, t0.address2 AS address2_12, t0.zip AS zip_13, t0.city AS city_14, t0.phone1 AS phone1_15, t0.phone2 AS phone2_16, t0.fax AS fax_17, t0.email1 AS email1_18, t0.email1_online AS email1_online_19, t0.email2_online AS email2_online_20, t0.email2 AS email2_21, t0.url AS url_22, t0.url_ticket AS url_ticket_23, t0.facebook AS facebook_24, t0.twitter AS twitter_25, t0.instagram AS instagram_26, t0.mobile AS mobile_27, t0.geocodable AS geocodable_28, t0.x AS x_29, t0.y AS y_30, t0.idmultimedia AS idmultimedia_31, t0.type_view AS type_view_32, t0.stats_access AS stats_access_33, t0.ga_tracking_id AS ga_tracking_id_34, t0.is_festival AS is_festival_35, t0.link_on_video AS link_on_video_36, t0.is_partenaire AS is_partenaire_37, t0.valid_version AS valid_version_38, t0.other_versions AS other_versions_39, t0.url_redirect AS url_redirect_40, t0.url_clean AS url_clean_41, t0.dateupdate AS dateupdate_42, t0.dateinsert AS dateinsert_43, t0.publish AS publish_44, t0.valid AS valid_45, t0.country AS country_46, t0.idextranetuser AS idextranetuser_47 FROM contacts t0 WHERE t0.idcontact = ?
Parameters:
[
233
]
|
||||||||||||||||||||||||||||||||||
33 | 0.10 ms |
SELECT fr FROM countries WHERE id='FR'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
34 | 0.05 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
35 | 0.16 ms |
SELECT fr FROM languages WHERE id='pt'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
36 | 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=14676 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
37 | 0.13 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"21688"
]
|
||||||||||||||||||||||||||||||||||
38 | 0.12 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=21688 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
39 | 0.43 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=14676 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
40 | 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:
[
"14676"
]
|
||||||||||||||||||||||||||||||||||
41 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
42 | 0.03 ms |
SELECT fr FROM languages WHERE id='pt'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
43 | 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=14676 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
44 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"21688"
]
|
||||||||||||||||||||||||||||||||||
45 | 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=21688 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
46 | 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=14676 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
47 | 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:
[
"14676"
]
|
||||||||||||||||||||||||||||||||||
48 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
49 | 0.03 ms |
SELECT fr FROM languages WHERE id='pt'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
50 | 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=14676 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
51 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"21688"
]
|
||||||||||||||||||||||||||||||||||
52 | 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=21688 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
53 | 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=14676 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
54 | 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:
[
"14676"
]
|
||||||||||||||||||||||||||||||||||
55 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
56 | 0.03 ms |
SELECT fr FROM languages WHERE id='pt'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
57 | 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=14676 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
58 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"21688"
]
|
||||||||||||||||||||||||||||||||||
59 | 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=21688 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
60 | 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=14676 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
61 | 0.26 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:
[
"35607"
]
|
||||||||||||||||||||||||||||||||||
62 | 0.06 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
63 | 0.04 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
64 | 0.27 ms |
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts WHERE 1 AND ts.idspectacle=35607 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
65 | 0.15 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"43908"
]
|
||||||||||||||||||||||||||||||||||
66 | 0.34 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=43908 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
67 | 0.58 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=35607 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
68 | 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:
[
"35607"
]
|
||||||||||||||||||||||||||||||||||
69 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
70 | 0.04 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
71 | 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=35607 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
72 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"43908"
]
|
||||||||||||||||||||||||||||||||||
73 | 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=43908 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
74 | 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=35607 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
75 | 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:
[
"35607"
]
|
||||||||||||||||||||||||||||||||||
76 | 0.04 ms |
SELECT lt.fr FROM typesspectacles e, langterms lt WHERE typespectacle=lt.id AND idtypespectacle=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
77 | 0.04 ms |
SELECT fr FROM languages WHERE id='fr'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
78 | 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=35607 AND t.idtext=ts.idtext
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
79 | 0.04 ms |
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters:
[
"43908"
]
|
||||||||||||||||||||||||||||||||||
80 | 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=43908 ORDER BY j2.classement ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
81 | 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=35607 AND r.type_creator=1 ORDER BY sp.`classement`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
82 | 0.06 ms |
SELECT DISTINCT(spectacles.`idspectacle`) FROM spectacles INNER JOIN spectacle_contact ON spectacle_contact.`idspectacle`=spectacles.`idspectacle` WHERE spectacles.`publish`=1 AND (spectacle_contact.`idcontact`=717 OR spectacles.`idcontact_production`=717) AND spectacle_contact.`idrole` IN (17,18,19)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
83 | 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`=717 OR spectacles.`idcontact_production`=717) AND spectacle_contact.`idrole` = 77
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
84 | 3.97 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 (724,1295,1463,1929,2180,2181,3062,3129,3302,3329,3481,3558,3663,3667,3705,3906,4012,4040,4066,4202,4241,4311,4372,4620,4677,4714,4812,4813,4885,4943,5193,5202,5212,5294,5320,5351,5394,5465,6675,6905,6923,7105,8544,9101,9463,9464,9847,11550,11577,11715,11922,12253,13636,13707,13841,13858,14023,14324,14399,14587,14753,15526,15803,16554,17021,17703,18121,18137,18182,18237,18263,18266,18287,18578,18720,19299,19452,19685,20147,20709,20729,21203,21400,21743,22889,23919,23981,24254,24539,24956,25928,26055,26700,26814,26864,27002,27058,27180,27259,27346,27443,28201,28391,28435,28690,29024,29512,29593,29868,30787,30996,30999,31217,31238,31336,31343,31498,31840,32303,32549,32686,32706,33127,33252,33652,33705,34626,34675,35573,35588,35607,35931,36181,36201,36304,36342,36402,36557,37257) AND s.date>='2024-04-30' AND c.idcontact = 717 ORDER BY s.date ASC LIMIT 0,1000
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
85 | 0.09 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 (724,1295,1463,1929,2180,2181,3062,3129,3302,3329,3481,3558,3663,3667,3705,3906,4012,4040,4066,4202,4241,4311,4372,4620,4677,4714,4812,4813,4885,4943,5193,5202,5212,5294,5320,5351,5394,5465,6675,6905,6923,7105,8544,9101,9463,9464,9847,11550,11577,11715,11922,12253,13636,13707,13841,13858,14023,14324,14399,14587,14753,15526,15803,16554,17021,17703,18121,18137,18182,18237,18263,18266,18287,18578,18720,19299,19452,19685,20147,20709,20729,21203,21400,21743,22889,23919,23981,24254,24539,24956,25928,26055,26700,26814,26864,27002,27058,27180,27259,27346,27443,28201,28391,28435,28690,29024,29512,29593,29868,30787,30996,30999,31217,31238,31336,31343,31498,31840,32303,32549,32686,32706,33127,33252,33652,33705,34626,34675,35573,35588,35607,35931,36181,36201,36304,36342,36402,36557,37257) AND s.date>='2024-04-30' AND c.idcontact = 717 ORDER BY s.date ASC LIMIT 0,1000
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
86 | 4.20 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 (724,1295,1463,1929,2180,2181,3062,3129,3302,3329,3481,3558,3663,3667,3705,3906,4012,4040,4066,4202,4241,4311,4372,4620,4677,4714,4812,4813,4885,4943,5193,5202,5212,5294,5320,5351,5394,5465,6675,6905,6923,7105,8544,9101,9463,9464,9847,11550,11577,11715,11922,12253,13636,13707,13841,13858,14023,14324,14399,14587,14753,15526,15803,16554,17021,17703,18121,18137,18182,18237,18263,18266,18287,18578,18720,19299,19452,19685,20147,20709,20729,21203,21400,21743,22889,23919,23981,24254,24539,24956,25928,26055,26700,26814,26864,27002,27058,27180,27259,27346,27443,28201,28391,28435,28690,29024,29512,29593,29868,30787,30996,30999,31217,31238,31336,31343,31498,31840,32303,32549,32686,32706,33127,33252,33652,33705,34626,34675,35573,35588,35607,35931,36181,36201,36304,36342,36402,36557,37257) AND s.date>='2024-04-30' ORDER BY s.date ASC LIMIT 0,1000
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
87 | 0.24 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
88 | 0.18 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
89 | 0.16 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
90 | 0.21 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
91 | 0.68 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
92 | 0.15 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
93 | 0.15 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
94 | 0.18 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
95 | 0.28 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
96 | 0.15 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
97 | 0.14 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
98 | 0.18 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
99 | 0.20 ms |
SELECT COUNT(DISTINCT(idperson)) FROM person_ecole WHERE 1 AND idcontact=717
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
100 | 0.05 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 (174,724,734,900,1463,1525,1613,1295,2159,2181,2269,2185,2380,1881,2098,1929,2950,3051,1851,2816,3086,3100,3101,3129,3212,3302,3329,2962,2111,1815,1816,2238,2855,3481,3558,3663,2822,3705,3906,3948,4012,4040,1611,4125,4188,4254,4311,4122,4553,4430,2254,4620,4621,4106,3732,4677,4714,4744,3667,4782,4813,4201,4871,5137,5148,4462,4812,5193,5202,5212,4241,5264,4700,5294,4619,5320,5370,5394,5465,4885,4850,6327,6342,6905,6923,4943,5463,5300,2374,7301,2994,13253,12337,14023,14324,14399,15355,14753,16219,16229,16231,16554,11727,8426,13864,15803,18137,17574,18720,18311,18335,18182,10458,14408,15708,18121,18263,13551,17662,18197,19299,19452,19758,20754,21400,14018,20653,20987,19454,17621,19342,21023,20147,13841,18284,14722,3988,11684,21281,20729,22378,21743,23372,22560,23727,24590,17253,21390,23291,14986,24193,3739,25130,20709,26814,26864,27002,27058,27259,27346,27670,28201,28391,28606,28690,29072,28148,29855,29593,29079,30605,20782,26838,31343,31692,25928,30996,31336,30999,32305,31840,29512,18287,32549,32706,29868,33252,33127,5945,33652,17133,34198,34556,34626,34675,33705,28135,29782,14024,35588,14676,36381,4372,35607,36328,36304,31241,36557,36201,34478,32528,37079,36519,7105,31710,724,1295,1463,1929,2180,2181,3062,3129,3302,3329,3481,3558,3663,3667,3705,3906,4012,4040,4066,4202,4241,4311,4372,4620,4677,4714,4812,4813,4885,4943,5193,5202,5212,5294,5320,5351,5394,5465,6675,6905,6923,7105,8544,9101,9463,9464,9847,11550,11577,11715,11922,12253,13636,13707,13841,13858,14023,14324,14399,14587,14753,15526,15803,16554,17021,17703,18121,18137,18182,18237,18263,18266,18287,18578,18720,19299,19452,19685,20147,20709,20729,21203,21400,21743,22889,23919,23981,24254,24539,24956,25928,26055,26700,26814,26864,27002,27058,27180,27259,27346,27443,28201,28391,28435,28690,29024,29512,29593,29868,30787,30996,30999,31217,31238,31336,31343,31498,31840,32303,32549,32686,32706,33127,33252,33652,33705,34626,34675,35573,35588,35607,35931,36181,36201,36304,36342,36402,36557,37257) ) 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=717 ) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
101 | 0.03 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_presentation_structure'))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
102 | 1.13 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='717' 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:
[]
|
||||||||||||||||||||||||||||||||||
103 | 0.21 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=70875
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
104 | 0.04 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_article'))) AND contacts=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
105 | 0.79 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='717' 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:
[]
|
||||||||||||||||||||||||||||||||||
106 | 0.04 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
107 | 0.03 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
108 | 0.03 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
109 | 0.03 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=2
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
110 | 0.16 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
111 | 0.17 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
112 | 0.16 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
113 | 0.20 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=3
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
114 | 0.35 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=717 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:
[]
|
||||||||||||||||||||||||||||||||||
115 | 0.03 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
116 | 0.03 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
117 | 0.03 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
118 | 0.03 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
119 | 0.03 ms |
SELECT COUNT(spectacle_aide.`idaide`) FROM aides JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
120 | 0.03 ms |
SELECT COUNT(text_aide.`idaide`) FROM aides JOIN text_aide ON text_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
121 | 0.03 ms |
SELECT COUNT(person_aide.`idaide`) FROM aides JOIN person_aide ON person_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
122 | 0.03 ms |
SELECT COUNT(contact_aide.`idaide`) FROM aides JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide` WHERE aides.`idcontact`=717 AND aides.`type_aide`=4
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
123 | 0.72 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact 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 (717) AND s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) ORDER BY s1_.date ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||||
124 | 0.44 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=717 ) AND T1.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
125 | 2.44 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(724,1295,1463,1929,2180,2181,3062,3129,3302,3329,3481,3558,3663,3667,3705,3906,4012,4040,4066,4202,4241,4311,4372,4620,4677,4714,4812,4813,4885,4943,5193,5202,5212,5294,5320,5351,5394,5465,6675,6905,6923,7105,8544,9101,9463,9464,9847,11550,11577,11715,11922,12253,13636,13707,13841,13858,14023,14324,14399,14587,14753,15526,15803,16554,17021,17703,18121,18137,18182,18237,18263,18266,18287,18578,18720,19299,19452,19685,20147,20709,20729,21203,21400,21743,22889,23919,23981,24254,24539,24956,25928,26055,26700,26814,26864,27002,27058,27180,27259,27346,27443,28201,28391,28435,28690,29024,29512,29593,29868,30787,30996,30999,31217,31238,31336,31343,31498,31840,32303,32549,32686,32706,33127,33252,33652,33705,34626,34675,35573,35588,35607,35931,36181,36201,36304,36342,36402,36557,37257,174,734,900,1525,1613,2159,2269,2185,2380,1881,2098,2950,3051,1851,2816,3086,3100,3101,3212,2962,2111,1815,1816,2238,2855,2822,3948,1611,4125,4188,4254,4122,4553,4430,2254,4621,4106,3732,4744,4782,4201,4871,5137,5148,4462,5264,4700,4619,5370,4850,6327,6342,5463,5300,2374,7301,2994,13253,12337,15355,16219,16229,16231,11727,8426,13864,17574,18311,18335,10458,14408,15708,13551,17662,18197,19758,20754,14018,20653,20987,19454,17621,19342,21023,18284,14722,3988,11684,21281,22378,23372,22560,23727,24590,17253,21390,23291,14986,24193,3739,25130,27670,28606,29072,28148,29855,29079,30605,20782,26838,31692,32305,5945,17133,34198,34556,28135,29782,14024,14676,36381,36328,31241,34478,32528,37079,36519,31710) AND d.code_franceinter IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
126 | 0.23 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:
[
717
]
|
||||||||||||||||||||||||||||||||||
127 | 335.84 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=717 OR schedules.idcontact_festival=717) AND contents.`publish`=1 AND contents.`valid`=1 AND object_content.`object`='spectacles' AND content_classification.`idclassification` IN (125)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
128 | 13.87 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`=717 OR spectacles.`idcontact_production`=717) 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:
[]
|
||||||||||||||||||||||||||||||||||
129 | 0.09 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:
[]
|
||||||||||||||||||||||||||||||||||
130 | 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:
[]
|
||||||||||||||||||||||||||||||||||
131 | 0.52 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='717' 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:
[]
|
||||||||||||||||||||||||||||||||||
132 | 0.04 ms |
SELECT COUNT(DISTINCT(idperson)) FROM person_ecole WHERE 1 AND idcontact=717
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
133 | 0.66 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:
[ "08a73cc0383748a23b98037fdd518b06-a7b9" 0 "ff9054ac2b2297fd389dbe3587657da1" ]
|
||||||||||||||||||||||||||||||||||
134 | 2.30 ms |
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "article" "thnet" "/contacts/Theatre-Garonne/calendrier/type/structure" "ff9054ac2b2297fd389dbe3587657da1" 0 "contacts" 717 0 "fr" "08a73cc0383748a23b98037fdd518b06-a7b9" "/home/web/theatre-contemporain.net/dev/src/Controller/ContactController.php:829" ]
|
||||||||||||||||||||||||||||||||||
135 | 0.71 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