https://preprod.theatre-contemporain.net/editions/Lansman-Editeur/videos/type/partenariat/?path=editions%2FLansman-Editeur%2Fvideos%2Ftype%2Fpartenariat%2F

Method
GET
HTTP Status
200
IP
54.221.110.87
Profiled on
Token
a3f453

Query Metrics

315 Database Queries
235 Different statements
3016.85 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

#▲ Time Info
1 1.21 ms 
SELECT idcontact FROM contacts WHERE url_clean='Lansman-Editeur'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 1.19 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: 
[
  "56"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.31 ms 
SELECT fr FROM countries WHERE id='BE'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.42 ms 
SELECT fr FROM countries WHERE id='Belgique'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.08 ms 
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (100))) AND contacts=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
6 1.66 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='56'
                   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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.21 ms 
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_pp'))) AND contacts=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
8 2.82 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='56'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.classification IN ('class_pp'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
9 1.18 ms 
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=56
                AND om.object='contacts'
                AND m.publish=1  AND m.audio_video=2
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
10 13.45 ms 
SELECT COUNT(DISTINCT(T1.idperson)) as total  FROM persons T1 
                    JOIN text_author T2 ON T2.`idperson` = T1.`idperson`
                    JOIN texts t ON t.`idtext`=T2.`idtext` 
                 WHERE 1  AND t.`idcontact_publisher` IN  ('56')  AND T1.`publish`=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
11 21.36 ms 
SELECT idtext, idgenretext FROM texts WHERE type=0 AND idcontact_publisher=56
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
12 3.65 ms 
SELECT idtext FROM texts WHERE type=1 AND idcontact_publisher=56
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
13 1.67 ms 
SELECT tt.idtext FROM text_traduction tt, texts t
                                        WHERE t.idtext=tt.idtext
                                        AND (t.idgenretext=1 OR t.idgenretext IS NULL)
                                        AND tt.idtexttraduction IN (853,1125,1657,3658,5498,6496,8435,10516,10734,11260,11310,12391,16142,17275,18715,19194,29265,30103,31968,34071)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
14 7.52 ms 
SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (220,653,654,655,656,657,659,661,662,663,664,665,666,798,927,929,930,931,932,1220,1222,1254,1365,1442,1528,1577,1713,1775,1873,1891,2001,2040,2116,2227,2257,2309,2377,2391,2436,2443,2451,2479,2492,2521,2531,2593,2704,2741,2835,2866,2893,2916,2984,2989,3050,3070,3082,3093,3133,3151,3191,3205,3236,3375,3382,3579,3801,3802,3890,4107,4654,4667,4668,4670,4671,4672,4683,4684,4685,4688,4690,4757,4758,4759,4760,4761,4766,4774,4830,4831,4832,4833,4834,4835,4841,4842,4844,4847,4850,4854,4856,4858,4859,4860,4861,4862,4863,4867,4871,4872,4874,4885,4905,4906,4908,4909,4910,4912,5097,5104,5161,5174,5295,5368,5370,5511,5512,5514,5515,5516,5517,5518,5519,5520,5521,5522,5523,5524,5525,5527,5528,5540,5541,5565,5566,5567,5578,5583,5591,5602,5671,5687,5721,5722,5723,5724,5725,5727,5729,5741,5744,5751,5753,5756,5757,5758,5759,5760,5761,5763,5764,5765,5766,5767,5768,5769,5795,5847,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5865,5914,6003,6004,6005,6063,6105,6123,6126,6164,6166,6167,6168,6169,6170,6171,6172,6211,6240,6241,6242,6243,6244,6246,6270,6275,6276,6277,6280,6321,6373,6398,6415,6416,6457,6458,6490,6492,6498,6500,6501,6533,6623,6624,6655,6656,6807,6808,6809,6810,6853,6854,6859,6933,6946,7051,7056,7057,7058,7059,7060,7096,7143,7265,7266,7267,7278,7315,7319,7524,7543,7587,7622,7623,7624,7626,7675,7869,7916,7923,7924,7940,7997,8026,8027,8069,8208,8269,8284,8331,8351,8356,8361,8374,8375,8391,8392,8398,8433,8464,8466,8467,8468,8589,8632,8696,8697,8698,8699,8700,8701,8703,8704,8705,8759,8815,8816,8919,8984,8994,8996,8997,8998,8999,9014,9195,9196,9322,9342,9545,9575,9663,9664,9727,9728,9729,9730,9731,9732,9926,10053,10059,10065,10067,10068,10421,10422,10423,10431,10491,10492,10670,10674,10679,10789,10973,11081,11284,11285,11288,11289,11290,11291,11292,11293,11294,11295,11296,11297,11298,11299,11300,11301,11302,11303,11304,11305,11306,11307,11308,11309,11429,11529,11938,11939,11941,11997,12255,12257,12258,12259,12260,12564,12773,13100,13112,13149,13394,13396,13804,13882,13884,13973,13974,14011,14084,14135,14235,14350,14459,14797,14805,14807,14808,14809,14987,14988,14993,15126,15127,15128,15129,15166,15235,15239,15277,15376,15602,15604,15681,15686,15687,15688,15888,15889,15890,15891,15892,15893,15894,15895,15897,15898,15899,15900,15947,16000,16143,16321,16395,16725,16752,16806,16807,16808,16809,16810,16871,16873,16875,16876,16877,16878,16879,16880,16932,17084,17085,17273,17323,17367,17368,17673,17875,18060,18064,18065,18066,18104,18270,18344,18414,18458,18550,18716,18717,18718,18798,18893,18898,18901,18961,18962,19149,19191,19192,19261,19568,19569,19602,19608,19627,19634,19780,19928,19929,19930,19931,19932,20275,20529,20530,20722,20723,20724,20725,20867,20868,21009,21010,21126,21189,21239,21349,21595,21748,21798,21896,22057,22099,22132,22249,22250,22340,22394,22764,22886,22887,23131,23216,23278,23280,23282,23283,23284,23285,23286,23287,23288,23289,23290,23534,23593,23733,23900,23980,23981,23982,24059,24291,24296,24694,24695,24696,24697,24742,24768,24894,24895,24896,25071,25115,25172,25173,25174,25269,25317,25404,25417,25418,25728,25769,25983,25995,26307,26546,26547,26548,26898,27054,27242,27462,27572,27801,27885,27899,28010,28290,28348,28349,28350,28353,28503,28504,28540,28542,28547,28967,29177,29204,29266,29336,29455,29543,29644,29682,29802,29803,29853,29854,30257,30316,30317,30318,30337,30749,30767,30864,30880,30933,31096,31219,31241,31259,31265,31319,31377,31378,31380,31384,31386,31387,31388,31389,31444,31511,31746,31792,32008,32127,32232,32276,32291,32328,32512,32513,32514,32515,32620,32666,32667,32668,32669,32670,32671,32672,32673,32674,32719,32727,32867,32868,32869,32870,32871,32872,32873,32874,32895,32981,33229,34077,34140,34337,34356,34505,34571,34872,35162,35273,35387,35536,35578,35591,35592,35631,35637,35673,35740,36213,36234,36236,36325,36326,36473,36494,36770,37056,37206,37280,37461,37477,37478,37659,37660,37661,37662,37663,37664,37665,37666,38032,38056,38140,38333,38427,38428,38603,39110,39111,39403,39669,39689,40113,40265,40266,40268,40269,40270,40271,40308,40457,40513,40601,40865,41679,41729,42736,42738,42797,42912,42914,42977,42979,43089,43266,44189,44192,44196,44203,44222,44260,44363,44587,44634,44635,44637,44639,44640,44641,44642,44758,44766,44767,44768,45247,45248,45368)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.98 ms 
SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (220,653,654,655,656,657,659,661,662,663,664,665,666,798,927,929,930,931,932,1220,1222,1254,1365,1442,1528,1577,1713,1775,1873,1891,2001,2040,2116,2227,2257,2309,2377,2391,2436,2443,2451,2479,2492,2521,2531,2593,2704,2741,2835,2866,2893,2916,2984,2989,3050,3070,3082,3093,3133,3151,3191,3205,3236,3375,3382,3579,3801,3802,3890,4107,4654,4667,4668,4670,4671,4672,4683,4684,4685,4688,4690,4757,4758,4759,4760,4761,4766,4774,4830,4831,4832,4833,4834,4835,4841,4842,4844,4847,4850,4854,4856,4858,4859,4860,4861,4862,4863,4867,4871,4872,4874,4885,4905,4906,4908,4909,4910,4912,5097,5104,5161,5174,5295,5368,5370,5511,5512,5514,5515,5516,5517,5518,5519,5520,5521,5522,5523,5524,5525,5527,5528,5540,5541,5565,5566,5567,5578,5583,5591,5602,5671,5687,5721,5722,5723,5724,5725,5727,5729,5741,5744,5751,5753,5756,5757,5758,5759,5760,5761,5763,5764,5765,5766,5767,5768,5769,5795,5847,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5865,5914,6003,6004,6005,6063,6105,6123,6126,6164,6166,6167,6168,6169,6170,6171,6172,6211,6240,6241,6242,6243,6244,6246,6270,6275,6276,6277,6280,6321,6373,6398,6415,6416,6457,6458,6490,6492,6498,6500,6501,6533,6623,6624,6655,6656,6807,6808,6809,6810,6853,6854,6859,6933,6946,7051,7056,7057,7058,7059,7060,7096,7143,7265,7266,7267,7278,7315,7319,7524,7543,7587,7622,7623,7624,7626,7675,7869,7916,7923,7924,7940,7997,8026,8027,8069,8208,8269,8284,8331,8351,8356,8361,8374,8375,8391,8392,8398,8433,8464,8466,8467,8468,8589,8632,8696,8697,8698,8699,8700,8701,8703,8704,8705,8759,8815,8816,8919,8984,8994,8996,8997,8998,8999,9014,9195,9196,9322,9342,9545,9575,9663,9664,9727,9728,9729,9730,9731,9732,9926,10053,10059,10065,10067,10068,10421,10422,10423,10431,10491,10492,10670,10674,10679,10789,10973,11081,11284,11285,11288,11289,11290,11291,11292,11293,11294,11295,11296,11297,11298,11299,11300,11301,11302,11303,11304,11305,11306,11307,11308,11309,11429,11529,11938,11939,11941,11997,12255,12257,12258,12259,12260,12564,12773,13100,13112,13149,13394,13396,13804,13882,13884,13973,13974,14011,14084,14135,14235,14350,14459,14797,14805,14807,14808,14809,14987,14988,14993,15126,15127,15128,15129,15166,15235,15239,15277,15376,15602,15604,15681,15686,15687,15688,15888,15889,15890,15891,15892,15893,15894,15895,15897,15898,15899,15900,15947,16000,16143,16321,16395,16725,16752,16806,16807,16808,16809,16810,16871,16873,16875,16876,16877,16878,16879,16880,16932,17084,17085,17273,17323,17367,17368,17673,17875,18060,18064,18065,18066,18104,18270,18344,18414,18458,18550,18716,18717,18718,18798,18893,18898,18901,18961,18962,19149,19191,19192,19261,19568,19569,19602,19608,19627,19634,19780,19928,19929,19930,19931,19932,20275,20529,20530,20722,20723,20724,20725,20867,20868,21009,21010,21126,21189,21239,21349,21595,21748,21798,21896,22057,22099,22132,22249,22250,22340,22394,22764,22886,22887,23131,23216,23278,23280,23282,23283,23284,23285,23286,23287,23288,23289,23290,23534,23593,23733,23900,23980,23981,23982,24059,24291,24296,24694,24695,24696,24697,24742,24768,24894,24895,24896,25071,25115,25172,25173,25174,25269,25317,25404,25417,25418,25728,25769,25983,25995,26307,26546,26547,26548,26898,27054,27242,27462,27572,27801,27885,27899,28010,28290,28348,28349,28350,28353,28503,28504,28540,28542,28547,28967,29177,29204,29266,29336,29455,29543,29644,29682,29802,29803,29853,29854,30257,30316,30317,30318,30337,30749,30767,30864,30880,30933,31096,31219,31241,31259,31265,31319,31377,31378,31380,31384,31386,31387,31388,31389,31444,31511,31746,31792,32008,32127,32232,32276,32291,32328,32512,32513,32514,32515,32620,32666,32667,32668,32669,32670,32671,32672,32673,32674,32719,32727,32867,32868,32869,32870,32871,32872,32873,32874,32895,32981,33229,34077,34140,34337,34356,34505,34571,34872,35162,35273,35387,35536,35578,35591,35592,35631,35637,35673,35740,36213,36234,36236,36325,36326,36473,36494,36770,37056,37206,37280,37461,37477,37478,37659,37660,37661,37662,37663,37664,37665,37666,38032,38056,38140,38333,38427,38428,38603,39110,39111,39403,39669,39689,40113,40265,40266,40268,40269,40270,40271,40308,40457,40513,40601,40865,41679,41729,42736,42738,42797,42912,42914,42977,42979,43089,43266,44189,44192,44196,44203,44222,44260,44363,44587,44634,44635,44637,44639,44640,44641,44642,44758,44766,44767,44768,45247,45248,45368)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
16 1.51 ms 
SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (853,1125,1657,3658,5498,6496,8435,10516,10734,11260,11310,12391,16142,17275,18715,19194,29265,30103,31968,34071)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.94 ms 
SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1
                                LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher`  WHERE 1  AND T1.`idtext` IN (853,1125,1657,3658,5498,6496,8435,10516,10734,11260,11310,12391,16142,17275,18715,19194,29265,30103,31968,34071)  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
18 6.84 ms 
SELECT COUNT(DISTINCT(T1.`idtext`)) as total  FROM texts T1,contacts T2 WHERE 1  AND T2.idcontact=T1.idcontact_publisher AND T1.idcontact_publisher=56  ORDER BY CAST(CONCAT(T1.`publication_year`,'-',T1.`publication_month`,'-00') AS DATE) ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
19 5.14 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=56 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND (( T3.date>='2024-03-28' ))
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
20 1.56 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=56 ) AND T1.publish=1 AND T1.publish=1 AND T1.valid=1  AND (( T3.date<'2024-03-28' ))
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
21 91.65 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 BETWEEN '2024-03-28' AND '2025-03-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 56 ORDER BY s1_.date ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
22 225.31 ms 
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 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 c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 56 ORDER BY s1_.date ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
23 147.95 ms 
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 56 ORDER BY s1_.date ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
24 94.95 ms 
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 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 c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c9_ ON (c9_.idcontent = o2_.idcontent) LEFT JOIN content_classification c11_ ON c9_.idcontent = c11_.idcontent LEFT JOIN classifications c10_ ON c10_.idclassification = c11_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND (c9_.valid = 1 AND c9_.publish = 1) AND c10_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND ((s1_.date BETWEEN '2024-03-28' AND '2025-03-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 56 ORDER BY s1_.date ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
25 98.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 LEFT JOIN object_multimedia o8_ ON (s0_.idspectacle = o8_.idobject) LEFT JOIN multimedias m9_ ON (m9_.idmultimedia = o8_.idmultimedia) WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND o8_.object = 'spectacles' AND m9_.publish = 1 AND ((s1_.date BETWEEN '2024-03-28' AND '2025-03-28')) AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 56 ORDER BY s1_.date ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
26 209.96 ms 
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1, o2_.idobject AS idobject_2, o2_.object AS object_3, o2_.`range` AS range_4, o2_.idcontent AS idcontent_5 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 c8_ ON s1_.idcontact = c8_.idcontact LEFT JOIN object_multimedia o9_ ON (s0_.idspectacle = o9_.idobject) LEFT JOIN multimedias m10_ ON (m10_.idmultimedia = o9_.idmultimedia) LEFT JOIN object_content o2_ ON (o2_.object = 'spectacles') LEFT JOIN contents c11_ ON (c11_.idcontent = o2_.idcontent) LEFT JOIN content_classification c13_ ON c11_.idcontent = c13_.idcontent LEFT JOIN classifications c12_ ON c12_.idclassification = c13_.idclassification WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c8_.idcontact OR s1_.idcontact_festival = c8_.idcontact) AND o9_.object = 'spectacles' AND m10_.publish = 1 AND (c11_.valid = 1 AND c11_.publish = 1) AND c12_.idclassification IN (101) AND s0_.idspectacle = o2_.idobject AND c11_.idcontent = o2_.idcontent AND (s0_.publish = 1 AND s0_.valid = 1) AND t3_.idcontact_publisher = 56 ORDER BY s1_.date ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
27 161.68 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 object_multimedia o8_ ON (s0_.idspectacle = o8_.idobject) LEFT JOIN multimedias m9_ ON (m9_.idmultimedia = o8_.idmultimedia) WHERE s1_.idspectacle = s0_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND o8_.object = 'spectacles' AND m9_.publish = 1 AND (s0_.publish = 1 AND s0_.valid = 1) AND t2_.idcontact_publisher = 56 ORDER BY s1_.date ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
28 7.24 ms 
SELECT COUNT(spectacle_aide.`idaide`)
                    FROM aides
                    JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=2
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
29 1.53 ms 
SELECT COUNT(text_aide.`idaide`)
                    FROM aides
                    JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=2
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.57 ms 
SELECT COUNT(person_aide.`idaide`)
                    FROM aides
                    JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=2
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
31 5.03 ms 
SELECT COUNT(contact_aide.`idaide`)
                    FROM aides
                    JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=2
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.38 ms 
SELECT COUNT(spectacle_aide.`idaide`)
                    FROM aides
                    JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=3
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.43 ms 
SELECT COUNT(text_aide.`idaide`)
                    FROM aides
                    JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=3
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.53 ms 
SELECT COUNT(person_aide.`idaide`)
                    FROM aides
                    JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=3
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.39 ms 
SELECT COUNT(contact_aide.`idaide`)
                    FROM aides
                    JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=3
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.33 ms 
SELECT COUNT(spectacle_aide.`idaide`)
                    FROM aides
                    JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.48 ms 
SELECT COUNT(text_aide.`idaide`)
                    FROM aides
                    JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.55 ms 
SELECT COUNT(person_aide.`idaide`)
                    FROM aides
                    JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.35 ms 
SELECT COUNT(contact_aide.`idaide`)
                    FROM aides
                    JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.31 ms 
SELECT COUNT(spectacle_aide.`idaide`)
                    FROM aides
                    JOIN spectacle_aide ON spectacle_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=4
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.38 ms 
SELECT COUNT(text_aide.`idaide`)
                    FROM aides
                    JOIN text_aide ON text_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=4
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.34 ms 
SELECT COUNT(person_aide.`idaide`)
                    FROM aides
                    JOIN person_aide ON person_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=4
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.37 ms 
SELECT COUNT(contact_aide.`idaide`)
                    FROM aides
                    JOIN contact_aide ON contact_aide.`idaide`=aides.`idaide`
                    WHERE aides.`idcontact`=56
                    AND aides.`type_aide`=4
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.07 ms 
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=56
                AND om.object='contacts'
                AND m.publish=1  AND m.audio_video=2
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
45 23.11 ms 
SELECT schedules.`date`, YEAR(schedules.`date`) as annee
            FROM schedules, spectacles
                JOIN text_spectacle ON spectacles.`idspectacle`=text_spectacle.`idtext`
                JOIN texts ON texts.idtext = text_spectacle.idtext
            WHERE schedules.`idspectacle`=spectacles.`idspectacle`
            AND spectacles.`publish`=1
            AND texts.`idcontact_publisher`=56
            ORDER BY schedules.`date`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
46 797.04 ms 
SELECT DISTINCT MIN(s0_.date) AS sclr_0, t1_.url_clean AS url_clean_1, m2_.idmultimedia AS idmultimedia_2, s3_.idspectacle AS idspectacle_3, s3_.title AS title_4, s3_.language AS language_5, s3_.creation_date AS creation_date_6, s3_.url_page AS url_page_7, s3_.infos AS infos_8, s3_.tag AS tag_9, s3_.id_rubrique AS id_rubrique_10, s3_.duration AS duration_11, s3_.interlude AS interlude_12, s3_.textfictif AS textfictif_13, s3_.url_redirect AS url_redirect_14, s3_.url_clean AS url_clean_15, s3_.dateupdate AS dateupdate_16, s3_.dateinsert AS dateinsert_17, s3_.publish AS publish_18, s3_.statut AS statut_19, s3_.valid AS valid_20, t1_.idtext AS idtext_21, t1_.type AS type_22, t1_.idtypetext AS idtypetext_23, t1_.special_text AS special_text_24, t1_.title AS title_25, t1_.subtitle AS subtitle_26, t1_.date AS date_27, t1_.language AS language_28, t1_.markdown AS markdown_29, t1_.abstract AS abstract_30, t1_.abstract_author AS abstract_author_31, t1_.abstract_date AS abstract_date_32, t1_.abstract_url AS abstract_url_33, t1_.publisher_url_text AS publisher_url_text_34, t1_.publication_year AS publication_year_35, t1_.publication_month AS publication_month_36, t1_.isbn AS isbn_37, t1_.ean AS ean_38, t1_.publishinfos AS publishinfos_39, t1_.urltextaccess AS urltextaccess_40, t1_.emailtextaccess AS emailtextaccess_41, t1_.idfiletextaccess AS idfiletextaccess_42, t1_.filetextaccesssave AS filetextaccesssave_43, t1_.textaccessmore AS textaccessmore_44, t1_.request_translation_text AS request_translation_text_45, t1_.request_performing_text AS request_performing_text_46, t1_.help_translation AS help_translation_47, t1_.help_publishing AS help_publishing_48, t1_.help_other AS help_other_49, t1_.moreinfo AS moreinfo_50, t1_.nmale AS nmale_51, t1_.nfemale AS nfemale_52, t1_.npeople AS npeople_53, t1_.textorder AS textorder_54, t1_.nbpages AS nbpages_55, t1_.price AS price_56, t1_.selection_aneth AS selection_aneth_57, t1_.idtext_aneth AS idtext_aneth_58, t1_.aide_creation AS aide_creation_59, t1_.comments AS comments_60, t1_.url_clean AS url_clean_61, t1_.textfictif AS textfictif_62, t1_.valid_opendata AS valid_opendata_63, t1_.dateupdate AS dateupdate_64, t1_.dateinsert AS dateinsert_65, t1_.publish AS publish_66, t1_.statut AS statut_67, t1_.valid AS valid_68, t4_.idtypespectacle AS idtypespectacle_69 FROM spectacles s3_ LEFT JOIN text_spectacle t5_ ON s3_.idspectacle = t5_.idspectacle LEFT JOIN texts t1_ ON t1_.idtext = t5_.idtext LEFT JOIN typesspectacles t4_ ON s3_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s0_ ON s3_.idspectacle = s0_.idspectacle LEFT JOIN spectacle_person s7_ ON s3_.idspectacle = s7_.idspectacle LEFT JOIN persons p6_ ON p6_.idperson = s7_.idperson INNER JOIN contacts c8_ ON s0_.idcontact = c8_.idcontact LEFT JOIN object_multimedia o9_ ON (s3_.idspectacle = o9_.idobject) LEFT JOIN multimedias m2_ ON (m2_.idmultimedia = o9_.idmultimedia) WHERE s0_.idspectacle = s3_.idspectacle AND (s0_.idcontact = c8_.idcontact OR s0_.idcontact_festival = c8_.idcontact) AND o9_.object = 'spectacles' AND m2_.publish = 1 AND (s3_.publish = 1 AND s3_.valid = 1) AND t1_.idcontact_publisher = 56 GROUP BY s3_.idspectacle ORDER BY sclr_0 DESC LIMIT 20
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
47 3.45 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
48 1.00 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  45248
]
View formatted query    View runnable query    Explain query    View query backtrace
49 1.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=45248  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
50 4.08 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=37149  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
51 4.44 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  37149
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.11 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
53 13.47 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  42596
]
View formatted query    View runnable query    Explain query    View query backtrace
54 6.57 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=42596  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
55 12.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=34451  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
56 8.42 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  34451
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
57 7.03 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.75 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  40423
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.64 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=40423  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
60 27.33 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=34461  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
61 3.01 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  34461
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.10 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.86 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  39403
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.55 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=39403  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
65 1.40 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=33602  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
66 2.38 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  33602
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.15 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
68 2.17 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  15129
]
View formatted query    View runnable query    Explain query    View query backtrace
69 1.38 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=15129  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
70 1.83 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=34454  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
71 2.48 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  34454
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
72 0.25 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
73 2.76 ms 
SELECT DISTINCT(p.`idperson`),p.`lastname`,p.`firstname`,p.`url_clean`
                FROM persons p
                    JOIN text_author ta ON ta.`idperson`=p.`idperson`
                    JOIN text_spectacle ts ON ts.`idtext`=ta.`idtext`
                WHERE ts.`idspectacle`=33330
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
74 4.29 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=33330  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
75 2.94 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=33330  AND r.type_creator=1 ORDER BY sp.`classement`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
76 4.11 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  33330
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
77 3.32 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
78 2.58 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  32276
]
View formatted query    View runnable query    Explain query    View query backtrace
79 1.83 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=32276  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
80 4.92 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=31664  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
81 2.13 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  31664
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
82 0.11 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
83 0.43 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  21349
]
View formatted query    View runnable query    Explain query    View query backtrace
84 0.55 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=21349  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
85 1.82 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=31898  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
86 2.36 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  31898
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
87 0.38 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
88 3.31 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  8704
]
View formatted query    View runnable query    Explain query    View query backtrace
89 3.88 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=8704  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
90 8.49 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=31888  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
91 2.48 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  31888
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
92 0.16 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
93 0.74 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  38056
]
View formatted query    View runnable query    Explain query    View query backtrace
94 0.43 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=38056  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
95 2.41 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=30609  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
96 2.55 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  30609
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
97 0.13 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
98 1.12 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  37206
]
View formatted query    View runnable query    Explain query    View query backtrace
99 1.00 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=37206  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
100 1.97 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=30080  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
101 3.47 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  30080
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
102 0.16 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
103 0.97 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  15376
]
View formatted query    View runnable query    Explain query    View query backtrace
104 8.33 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=15376  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
105 23.49 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=30983  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
106 5.88 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  30983
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
107 2.14 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
108 2.04 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  36213
]
View formatted query    View runnable query    Explain query    View query backtrace
109 1.54 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=36213  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
110 24.62 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=29295  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
111 3.52 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  29295
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
112 0.34 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
113 6.10 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  24694
]
View formatted query    View runnable query    Explain query    View query backtrace
114 5.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=24694  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
115 15.92 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=33009  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
116 3.30 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  33009
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
117 0.11 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
118 0.35 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  18962
]
View formatted query    View runnable query    Explain query    View query backtrace
119 1.17 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=18962  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
120 2.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=29459  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
121 1.82 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  29459
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
122 0.11 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
123 0.88 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  36473
]
View formatted query    View runnable query    Explain query    View query backtrace
124 2.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=36473  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
125 2.55 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=29443  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
126 2.67 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  29443
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
127 0.11 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
128 0.59 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  34070
]
View formatted query    View runnable query    Explain query    View query backtrace
129 0.40 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=34070  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
130 1.49 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=29805  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
131 1.71 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  29805
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
132 0.09 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
133 0.48 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  36494
]
View formatted query    View runnable query    Explain query    View query backtrace
134 0.72 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=36494  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
135 1.80 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=29449  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
136 2.66 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  29449
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
137 0.21 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
138 1.34 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  35673
]
View formatted query    View runnable query    Explain query    View query backtrace
139 1.96 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=35673  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
140 2.27 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=28892  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
141 2.87 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  28892
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
142 0.23 ms 
SELECT t0.idtypespectacle AS idtypespectacle_1, t0.typespectacle AS typespectacle_2 FROM typesspectacles t0 WHERE t0.idtypespectacle IN (?) LIMIT 1
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
143 2.34 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  35387
]
View formatted query    View runnable query    Explain query    View query backtrace
144 1.16 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=35387  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
145 2.27 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=28646  ORDER BY p.`lastname`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
146 3.40 ms 
SELECT MIN(s0_.date) AS sclr_0, MAX(s0_.date) AS sclr_1, s0_.idschedule AS idschedule_2, s0_.date AS date_3, s0_.hour AS hour_4, s0_.is_creation AS is_creation_5, s0_.is_cancelled AS is_cancelled_6, s0_.idcontact_festival AS idcontact_festival_7, s0_.url_spectacle AS url_spectacle_8, s0_.url_booking AS url_booking_9, s0_.note AS note_10, s0_.dateupdate AS dateupdate_11, s0_.dateinsert AS dateinsert_12, s0_.publish AS publish_13, s0_.valid AS valid_14, c1_.idcontact AS idcontact_15, c1_.type AS type_16, c1_.organisation AS organisation_17, c1_.nom_suite AS nom_suite_18, c1_.lastname AS lastname_19, c1_.firstname AS firstname_20, c1_.idtypestructure AS idtypestructure_21, c1_.license AS license_22, c1_.comment AS comment_23, c1_.private_comment AS private_comment_24, c1_.address1 AS address1_25, c1_.address2 AS address2_26, c1_.zip AS zip_27, c1_.city AS city_28, c1_.phone1 AS phone1_29, c1_.phone2 AS phone2_30, c1_.fax AS fax_31, c1_.email1 AS email1_32, c1_.email1_online AS email1_online_33, c1_.email2_online AS email2_online_34, c1_.email2 AS email2_35, c1_.url AS url_36, c1_.url_ticket AS url_ticket_37, c1_.facebook AS facebook_38, c1_.twitter AS twitter_39, c1_.instagram AS instagram_40, c1_.mobile AS mobile_41, c1_.geocodable AS geocodable_42, c1_.x AS x_43, c1_.y AS y_44, c1_.idmultimedia AS idmultimedia_45, c1_.type_view AS type_view_46, c1_.stats_access AS stats_access_47, c1_.ga_tracking_id AS ga_tracking_id_48, c1_.is_festival AS is_festival_49, c1_.link_on_video AS link_on_video_50, c1_.is_partenaire AS is_partenaire_51, c1_.valid_version AS valid_version_52, c1_.other_versions AS other_versions_53, c1_.url_redirect AS url_redirect_54, c1_.url_clean AS url_clean_55, c1_.dateupdate AS dateupdate_56, c1_.dateinsert AS dateinsert_57, c1_.publish AS publish_58, c1_.valid AS valid_59, s0_.idspectacle AS idspectacle_60, s0_.idcontact AS idcontact_61, s0_.idextranetuser AS idextranetuser_62, c1_.country AS country_63, c1_.idextranetuser AS idextranetuser_64 FROM schedules s0_ LEFT JOIN contacts c1_ ON s0_.idcontact = c1_.idcontact WHERE s0_.idspectacle = ? AND s0_.date >= ? GROUP BY s0_.idcontact ORDER BY s0_.date ASC LIMIT 1
Parameters: 
[
  28646
  "2024-03-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
147 7.29 ms 
SELECT  DISTINCT(multimedias.idmultimedia), multimedias.`date`,YEAR(multimedias.`date`) as annee 
FROM  `object_multimedia` ,
 `multimedias`  
 WHERE 1  AND multimedias.`audio_video`=2  AND multimedias.`publish`=1  AND object_multimedia.`object` IN ('contacts')  AND object_multimedia.`idobject`=56 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` 
GROUP BY multimedias.idmultimedia 
ORDER BY multimedias.date 
DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
148 9.67 ms 
SELECT  DISTINCT(multimedias.idmultimedia), multimedias.* 
FROM  `object_multimedia` ,
 `multimedias`  
 WHERE 1  AND multimedias.`audio_video`=2  AND multimedias.`publish`=1  AND object_multimedia.`object` IN ('contacts')  AND object_multimedia.`idobject`=56 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` 
GROUP BY multimedias.idmultimedia 
ORDER BY multimedias.date 
DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
149 7.53 ms 
SELECT  DISTINCT(multimedias.idmultimedia), multimedias.* 
FROM  `object_multimedia` ,
 `multimedias`  
 WHERE 1  AND multimedias.`audio_video`=2  AND multimedias.`publish`=1  AND object_multimedia.`object` IN ('contacts')  AND object_multimedia.`idobject`=56 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` 
GROUP BY multimedias.idmultimedia 
ORDER BY multimedias.date 
DESC 
LIMIT 0,20
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
150 1.69 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  "18047"
]
View formatted query    View runnable query    Explain query    View query backtrace
151 16.03 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
152 4.88 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
153 1.76 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
154 7.36 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
155 14.27 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
156 5.22 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
157 14.46 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
158 1.72 ms 
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
                    FROM object_multimedia, texts
                    WHERE object_multimedia.idobject=texts.idtext
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
159 1.18 ms 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=18047 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
160 1.71 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  "18066"
]
View formatted query    View runnable query    Explain query    View query backtrace
161 1.85 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
162 0.87 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
163 0.64 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
164 0.44 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
165 1.26 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
166 1.00 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
167 1.60 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
168 1.40 ms 
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
                    FROM object_multimedia, texts
                    WHERE object_multimedia.idobject=texts.idtext
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
169 1.63 ms 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=18066 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
170 0.92 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  "18073"
]
View formatted query    View runnable query    Explain query    View query backtrace
171 1.09 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
172 0.87 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
173 0.89 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
174 0.62 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
175 1.72 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
176 1.06 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
177 0.89 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
178 0.71 ms 
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
                    FROM object_multimedia, texts
                    WHERE object_multimedia.idobject=texts.idtext
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
179 1.00 ms 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=18073 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
180 1.61 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  "18100"
]
View formatted query    View runnable query    Explain query    View query backtrace
181 0.74 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
182 0.48 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
183 0.38 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
184 0.38 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
185 1.17 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
186 1.21 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
187 0.82 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
188 0.75 ms 
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
                    FROM object_multimedia, texts
                    WHERE object_multimedia.idobject=texts.idtext
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
189 0.90 ms 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=18100 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
190 0.64 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  "18101"
]
View formatted query    View runnable query    Explain query    View query backtrace
191 1.13 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
192 1.03 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
193 0.81 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
194 0.83 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
195 1.71 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
196 1.87 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
197 1.55 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
198 0.54 ms 
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
                    FROM object_multimedia, texts
                    WHERE object_multimedia.idobject=texts.idtext
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
199 0.50 ms 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=18101 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
200 1.33 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  "18102"
]
View formatted query    View runnable query    Explain query    View query backtrace
201 4.23 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
202 0.67 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
203 0.86 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
204 0.35 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
205 16.63 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
206 2.64 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
207 0.41 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
208 0.39 ms 
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
                    FROM object_multimedia, texts
                    WHERE object_multimedia.idobject=texts.idtext
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
209 0.47 ms 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=18102 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
210 1.43 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  "15712"
]
View formatted query    View runnable query    Explain query    View query backtrace
211 0.74 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
212 0.41 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
213 1.15 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
214 0.39 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
215 1.08 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
216 5.44 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
217 1.59 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
218 0.45 ms 
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
                    FROM object_multimedia, texts
                    WHERE object_multimedia.idobject=texts.idtext
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
219 0.51 ms 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=15712 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
220 4.43 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  "3914"
]
View formatted query    View runnable query    Explain query    View query backtrace
221 8.19 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
222 9.24 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
223 1.35 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
224 8.49 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname, persons.url_clean
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
225 30.56 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
226 1.71 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.url_clean, contacts.link_on_video
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
227 11.09 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title, spectacles.url_clean, spectacles.idtypespectacle
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
228 37.78 ms 
SELECT idspectacle,title,url_clean,valid
                        FROM spectacles
                        WHERE idspectacle=6377
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
229 4.37 ms 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=6377
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
230 2.07 ms 
SELECT object_multimedia.object, object_multimedia.idobject, texts.idtext, texts.title, texts.url_clean, texts.textfictif, texts.valid
                    FROM object_multimedia, texts
                    WHERE object_multimedia.idobject=texts.idtext
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
231 1.49 ms 
SELECT  DISTINCT(keywords.idkeyword), keywords.* 
FROM  `multimedia_keyword` ,
 `keywords`  
 WHERE 1  AND keywords.`publish`=1  AND multimedia_keyword.`idmultimedia`=3914 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` 
GROUP BY keywords.idkeyword 
ORDER BY keywords.dateinsert 
DESC 
LIMIT 0,10
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
232 0.58 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  18047
]
View formatted query    View runnable query    Explain query    View query backtrace
233 1.08 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
234 0.56 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
235 0.56 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
236 13.66 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
237 3.29 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
238 14.36 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
239 2.17 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=18047
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
240 1.08 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  18066
]
View formatted query    View runnable query    Explain query    View query backtrace
241 1.22 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
242 0.99 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
243 1.04 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
244 0.94 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
245 1.57 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
246 1.28 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
247 1.84 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=18066
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
248 1.60 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  18073
]
View formatted query    View runnable query    Explain query    View query backtrace
249 1.98 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
250 0.84 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
251 1.50 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
252 0.67 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
253 8.79 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
254 2.61 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
255 0.83 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=18073
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
256 29.99 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  18100
]
View formatted query    View runnable query    Explain query    View query backtrace
257 18.21 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
258 1.08 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
259 1.97 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
260 0.50 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
261 1.02 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
262 0.60 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
263 0.53 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=18100
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
264 8.72 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  18101
]
View formatted query    View runnable query    Explain query    View query backtrace
265 0.66 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
266 6.14 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
267 7.49 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
268 0.84 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
269 1.24 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
270 1.53 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
271 0.98 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=18101
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
272 0.88 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  18102
]
View formatted query    View runnable query    Explain query    View query backtrace
273 0.52 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
274 0.42 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
275 0.84 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
276 0.46 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
277 1.45 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
278 0.77 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
279 2.74 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=18102
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
280 1.36 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  15712
]
View formatted query    View runnable query    Explain query    View query backtrace
281 2.19 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
282 0.61 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
283 0.66 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
284 0.63 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
285 1.33 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
286 0.69 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
287 0.88 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=15712
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
288 0.61 ms 
SELECT m0_.idmultimedia AS idmultimedia_0, m0_.idsupport AS idsupport_1, m0_.publish AS publish_2, m0_.status AS status_3, m0_.policy_access AS policy_access_4, m0_.support AS support_5, m0_.evenement AS evenement_6, m0_.sujet_titre AS sujet_titre_7, m0_.language AS language_8, m0_.markdown AS markdown_9, m0_.duree AS duree_10, m0_.date AS date_11, m0_.lieu AS lieu_12, m0_.particip_comed AS particip_comed_13, m0_.description AS description_14, m0_.use_cloud AS use_cloud_15, m0_.type_streaming AS type_streaming_16, m0_.mp3 AS mp3_17, m0_.hd2160 AS hd2160_18, m0_.hd1080 AS hd1080_19, m0_.upload AS upload_20, m0_.hd720 AS hd720_21, m0_.h264m AS h264m_22, m0_.h264 AS h264_23, m0_.flv AS flv_24, m0_.flv_width AS flv_width_25, m0_.flv_height AS flv_height_26, m0_.duree_site AS duree_site_27, m0_.duree_site_sec AS duree_site_sec_28, m0_.audio_video AS audio_video_29, m0_.filmeur AS filmeur_30, m0_.copyright AS copyright_31, m0_.etalab AS etalab_32, m0_.mots AS mots_33, m0_.tags AS tags_34, m0_.quality AS quality_35, m0_.url_clean AS url_clean_36, m0_.code AS code_37, m0_.fichier_local AS fichier_local_38, m0_.note_extranet AS note_extranet_39, m0_.note_extranetuser AS note_extranetuser_40, m0_.video_tete AS video_tete_41, m0_.avignondate AS avignondate_42, m0_.heywatch AS heywatch_43, m0_.is_coconut AS is_coconut_44, m0_.price AS price_45, m0_.count_view AS count_view_46, m0_.dateupdate AS dateupdate_47, m0_.dateinsert AS dateinsert_48, m0_.traite_comed AS traite_comed_49, m0_.traite_format AS traite_format_50, m0_.conversion_local AS conversion_local_51, m0_.idextranetuser_producteur AS idextranetuser_producteur_52, m0_.type AS type_53, m0_.idextranetuser AS idextranetuser_54, m0_.idcontact_producteur AS idcontact_producteur_55 FROM multimedias m0_ WHERE m0_.idmultimedia = ?
Parameters: 
[
  3914
]
View formatted query    View runnable query    Explain query    View query backtrace
289 0.44 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
290 1.02 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
291 0.94 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
292 1.46 ms 
SELECT object_multimedia.object, object_multimedia.idobject, persons.idperson, persons.lastname, persons.firstname
                    FROM object_multimedia, persons
                    WHERE object_multimedia.idobject=persons.idperson
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
293 1.54 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
294 0.84 ms 
SELECT object_multimedia.object, object_multimedia.idobject, contacts.idcontact, contacts.type, contacts.organisation, contacts.lastname, contacts.firstname
                    FROM object_multimedia, contacts
                    WHERE object_multimedia.idobject=contacts.idcontact
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
295 2.50 ms 
SELECT object_multimedia.object, object_multimedia.idobject, spectacles.idspectacle, spectacles.title
                    FROM object_multimedia, spectacles
                    WHERE object_multimedia.idobject=spectacles.idspectacle
                    AND object_multimedia.idmultimedia=3914
                    AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
296 0.07 ms 
SELECT t.title FROM texts t, text_spectacle ts
                      WHERE t.idtext=ts.idtext AND ts.idspectacle=6377
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
297 0.62 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: 
[
  6377
]
View formatted query    View runnable query    Explain query    View query backtrace
298 0.79 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: 
[
  1770
]
View formatted query    View runnable query    Explain query    View query backtrace
299 0.08 ms 
SELECT fr FROM countries WHERE id='FR'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
300 0.06 ms 
SELECT lt.fr 
                    FROM typesspectacles e, langterms lt 
                    WHERE typespectacle=lt.id
                    AND idtypespectacle=4
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
301 0.06 ms 
SELECT fr FROM languages WHERE id='fr'
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
302 0.60 ms 
SELECT t.idtext,t.title,t.type,t.url_clean, t.textfictif FROM texts t, text_spectacle ts
                WHERE 1
                AND ts.idspectacle=6377
                AND t.idtext=ts.idtext
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
303 0.48 ms 
SELECT t0_.type AS type_0 FROM texts t0_ WHERE t0_.idtext = ?
Parameters: 
[
  "9342"
]
View formatted query    View runnable query    Explain query    View query backtrace
304 12.47 ms 
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.idtext FROM theatreok_dev.persons j1, theatreok_dev.text_author j2, theatreok_dev.texts j3
                        WHERE j3.idtext=j2.idtext
                        AND j1.idperson=j2.idperson
                        AND j3.idtext=9342  ORDER BY j2.classement ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
305 1.39 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=6377  AND r.type_creator=1 ORDER BY sp.`classement`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
306 118.54 ms 
SELECT sc.`date`, YEAR(sc.`date`) as annee
                        FROM `schedules` sc
                        JOIN `spectacles` s ON sc.`idspectacle`=s.`idspectacle`
                        JOIN `text_spectacle` ts ON ts.`idspectacle`=s.`idspectacle`
                        JOIN `playlists` p ON p.`idtext`=ts.`idtext`
                        JOIN `playlist_classification` pc ON pc.`idplaylist`=p.`idplaylist`
                        WHERE 1
                        AND s.`textfictif`=0 AND s.`publish`=1 AND s.`valid`=1
                        AND p.`publish`=1
                        AND pc.`idclassification` IN (144)
                        AND sc.`date` > '1999-12-31'
                        ORDER BY sc.`date`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
307 33.71 ms 
SELECT COUNT(DISTINCT t0_.idtext) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s2_ LEFT JOIN text_spectacle t3_ ON s2_.idspectacle = t3_.idspectacle LEFT JOIN texts t0_ ON t0_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s2_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s2_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s2_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN playlists p8_ ON (p8_.idtext = t0_.idtext) INNER JOIN playlist_classification p10_ ON p8_.idplaylist = p10_.idplaylist INNER JOIN classifications c9_ ON c9_.idclassification = p10_.idclassification WHERE s2_.textfictif = 0 AND c9_.idclassification IN (144) AND p8_.publish = 1 AND s1_.idspectacle = s2_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND t0_.idcontact_publisher = 56 ORDER BY s1_.date ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
308 97.19 ms 
SELECT COUNT(DISTINCT t0_.idtext) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s2_ LEFT JOIN text_spectacle t3_ ON s2_.idspectacle = t3_.idspectacle LEFT JOIN texts t0_ ON t0_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s2_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s2_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s2_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN playlists p8_ ON (p8_.idtext = t0_.idtext) INNER JOIN playlist_classification p10_ ON p8_.idplaylist = p10_.idplaylist INNER JOIN classifications c9_ ON c9_.idclassification = p10_.idclassification WHERE s2_.textfictif = 0 AND c9_.idclassification IN (144) AND p8_.publish = 1 AND s1_.idspectacle = s2_.idspectacle AND (s1_.idcontact = c7_.idcontact OR s1_.idcontact_festival = c7_.idcontact) AND ((s1_.date BETWEEN '2024-03-28' AND '2025-03-28')) AND t0_.idcontact_publisher = 56 ORDER BY s1_.date ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
309 0.10 ms 
SELECT idclassification,classification,public_name FROM classifications WHERE 1 AND type="files" AND contacts=1 AND lagarce!=1 AND is_public IN (1)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
310 16.42 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='56'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (112,168))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
311 1.68 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
312 0.18 ms 
SELECT  COUNT(DISTINCT(m.idmultimedia)) 
                FROM object_multimedia om, multimedias m
                WHERE om.idmultimedia=m.idmultimedia
                AND om.idobject=56
                AND om.object='contacts'
                AND m.publish=1  AND m.audio_video=2
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
313 0.07 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
314 0.07 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='56'
                   AND of.object='contacts'
                   AND cl.idclassification=fc.idclassification AND ((cl.idclassification IN (112,168))) AND f.valid=1 AND f.publish=1 AND f.idtype=tf.idtype
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
315 1.16 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Entities Mapping

Class Mapping errors
TheatreCore\Entity\Extranetusers No errors.
TheatreCore\Entity\Spectacles No errors.
TheatreCore\Entity\Contacts No errors.
TheatreCore\Entity\Countries No errors.
TheatreCore\Entity\Files No errors.
TheatreCore\Entity\Classifications No errors.
TheatreCore\Entity\Contents No errors.
TheatreCore\Entity\Multimedias No errors.
TheatreCore\Entity\Persons No errors.
TheatreCore\Entity\Texts No errors.
TheatreCore\Entity\News No errors.
TheatreCore\Entity\Typesspectacles No errors.
TheatreCore\Entity\Schedules No errors.
TheatreCore\Entity\ObjectContent No errors.
TheatreCore\Entity\ObjectMultimedia No errors.
TheatreCore\Entity\Aides No errors.
TheatreCore\Entity\Podcasts No errors.
TheatreCore\Entity\ContactAide No errors.
TheatreCore\Entity\Contactsaisons No errors.
TheatreCore\Entity\Typesmultimedias No errors.
TheatreCore\Entity\Dvds No errors.
TheatreCore\Entity\Keywords No errors.
TheatreCore\Entity\Playlists No errors.
TheatreCore\Entity\Spectaclegenres No errors.
TheatreCore\Entity\SpectacleAide No errors.
TheatreCore\Entity\Bannieres No errors.