Query Metrics
286
Database Queries
250
Different statements
1230.91 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.66 ms |
SELECT idperson FROM persons WHERE url_clean='William-Shakespeare'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
2 | 0.86 ms |
SELECT p0_.idperson AS idperson_0, p0_.lastname AS lastname_1, p0_.firstname AS firstname_2, p0_.sexe AS sexe_3, p0_.datestart AS datestart_4, p0_.dateend AS dateend_5, p0_.language AS language_6, p0_.language2 AS language2_7, p0_.email AS email_8, p0_.comment AS comment_9, p0_.cname AS cname_10, p0_.caddress AS caddress_11, p0_.czip AS czip_12, p0_.ccity AS ccity_13, p0_.ccountry AS ccountry_14, p0_.cphone AS cphone_15, p0_.cfax AS cfax_16, p0_.cemail AS cemail_17, p0_.cmobile AS cmobile_18, p0_.url_redirect AS url_redirect_19, p0_.url_clean AS url_clean_20, p0_.url_mav AS url_mav_21, p0_.dateupdate AS dateupdate_22, p0_.dateinsert AS dateinsert_23, p0_.publish AS publish_24, p0_.valid AS valid_25, p0_.idcorvin AS idcorvin_26, p0_.country AS country_27, p0_.idrole AS idrole_28, p0_.idextranetuser AS idextranetuser_29 FROM persons p0_ WHERE p0_.idperson = ?
Parameters:
[
468
]
|
||||||||||||||||||||||||||||||||||
3 | 1.34 ms |
SELECT COUNT(DISTINCT(t.idtext)) FROM text_author ta, texts t WHERE t.idtext=ta.idtext AND t.textfictif=0 AND ta.idperson=468 AND t.publish=1 AND t.type IN (0,2)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
4 | 0.74 ms |
SELECT COUNT(DISTINCT(tt.idtext)) as total FROM text_translator tt, texts t WHERE 1 AND t.idtext=tt.idtext AND t.textfictif=0 AND tt.idperson=468 AND t.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
5 | 0.63 ms |
SELECT COUNT(DISTINCT(sp.idspectacle)) as total FROM spectacle_person sp, spectacles s WHERE 1 AND sp.idspectacle=s.idspectacle AND sp.idperson=468 AND sp.idrole=1 AND s.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
6 | 0.34 ms |
SELECT fr FROM countries WHERE id='GB'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
7 | 0.09 ms |
SELECT fr FROM languages WHERE id='en'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
8 | 0.54 ms |
SELECT j1.idcontact,j1.organisation,j1.url_clean,j2.idoffice,j2.date_start,j2.date_end ,j3.idperson FROM theatreok_dev.contacts j1, theatreok_dev.contact_person j2, theatreok_dev.persons j3 WHERE j3.idperson=j2.idperson AND j1.idcontact=j2.idcontact AND j3.idperson=468 AND j2.idoffice=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
9 | 0.07 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_biotxt'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
10 | 2.61 ms |
SELECT * FROM object_content oc, contents c, content_classification cc, classifications cl WHERE oc.idcontent=c.idcontent AND c.idcontent=cc.idcontent AND oc.idobject='468' AND oc.object='persons' AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.classification IN ('class_biotxt'))) ORDER BY c.`range`,c.idcontent
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
11 | 0.63 ms |
SELECT j1.idclassification,j1.classification,j1.type,j1.idgroupclassification ,j3.idcontent FROM theatreok_dev.classifications j1, theatreok_dev.content_classification j2, theatreok_dev.contents j3 WHERE j3.idcontent=j2.idcontent AND j1.idclassification=j2.idclassification AND j3.idcontent=44217
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
12 | 0.06 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
13 | 1.44 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='468' AND of.object='persons' AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.classification IN ('class_photo_person'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
14 | 0.68 ms |
SELECT t.`idtext` FROM text_author ta JOIN texts t ON ta.`idtext`=t.`idtext` WHERE ta.`idperson` IN (468)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
15 | 1.03 ms |
SELECT tad.`idtextadaptation` FROM text_adaptation tad JOIN texts t ON t.`idtext`=tad.`idtext` JOIN text_author ta ON t.`idtext`=ta.`idtext` WHERE ta.`idperson` IN (468)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
16 | 0.21 ms |
SELECT t.`idtext` FROM text_translator tt JOIN texts t ON tt.`idtext`=t.`idtext` WHERE tt.`idperson` IN (468)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
17 | 0.52 ms |
SELECT tt.`idtexttraduction` FROM text_traduction tt JOIN text_author ta ON tt.`idtext`=ta.`idtext` JOIN texts t ON tt.`idtext`=t.`idtext` WHERE ta.`idperson` IN (468)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
18 | 629.50 ms |
SELECT s.`idspectacle` FROM spectacles s LEFT JOIN spectacle_person sp ON sp.`idspectacle`=s.`idspectacle` LEFT JOIN text_spectacle ts ON ts.`idspectacle`=s.`idspectacle` WHERE s.`publish`=1 AND s.`valid`=1 AND (sp.`idperson`=468 OR ts.`idtext` IN (4777,5120,7509,7510,7953,7959,8146,8167,8823,9174,9489,9490,9872,10231,10270,10365,10695,11173,11384,11859,14186,14707,15294,15496,17898,18775,19246,19250,19524,22149,26398,32324,33114,45583,4778,10354,11549,12524,15253,17276,18214,20589,20910,28846,30558,31341,35085,36217,36856,36857,9946,14751,21503,35512,9641,15579,19385,29089,30059,32720,33627,36454,36455,36856,16445,26270,32189,33439,33627,9746,10273,10703,13295,13769,15884,16117,16123,16860,18120,19251,19525,20256,25463,44367,9918,10923,11279,12336,12477,14684,16890,18015,19026,19801,21146,22304,22871,24709,25009,25298,25318,29690,32333,32565,32793,32903,34642,35832,37487,39916,41627,43022,43439,8168,9510,11631,11845,12182,12719,14688,15209,15346,17658,20746,22924,23126,24597,26886,28292,31740,32546,32631,32973,33076,33925,34403,35537,36856,39631,40567,9175,17491,40511,9491,18453,9491,10845,18453,20589,22467,29042,10271,27890,14695,21548,21911,24535,29786,34201,35195,37520,41250,44177,19525,11385,12683,17159,19378,19506,21303,21698,22117,26301,28126,29588,30586,35184,39694,44117,44177,11989,19251,19525,14194,16971,27890,27934,33407,14716,15296,23036,15503,21599,35264,35993,23074,26174,27890,35324,19251,19525,19525,8134,9627,12001,23056,24599,26039,26139,26343,28757,29652,30131,31263,31739,32051,33620,34052,35335,36856,36858,36887,38769,39986,43962,44638,7513,9424,12805,14348,18674,36927,41838,42572,5121,11661,17277,7511,13797,18694,19704,23316,29694,43783,7512,7954,12053,20861,39330,43578,7960,9749,9932,11230,13763,19860,20609,32564,40055,8147,17366,37034,38033,8827,9647,13074,22475,23315,26302,26675,34611,39848,45127,13869,13986,17086,20831,25494,26206,29698,36085,45563,11728,12525,36351,38814,40512,9873,10232,37205,43538,43539,17772,27217,28205,36878,10698,11174,13952,19000,41267,11836,13621,13893,14349,20274,22433,43460,45144,11865,38712,18183,45561,17899,26674,37405,42186,12518,12520,18006,21188,28630,28758,36403,36457,37350,39236,41609,45064,45562,26402,32325,33115) )
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
19 | 0.60 ms |
SELECT DISTINCT(multimedias.idmultimedia) FROM `object_multimedia` , `multimedias` WHERE 1 AND object_multimedia.`idrole`=25 AND multimedias.`publish`=1 AND object_multimedia.`object`='persons' AND object_multimedia.`idobject`=468 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` GROUP BY multimedias.idmultimedia ORDER BY multimedias.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
20 | 9.34 ms |
SELECT COUNT(DISTINCT(ct.`idcontent`)) FROM spectacles s JOIN object_content oc ON s.`idspectacle`=oc.`idobject` JOIN contents ct ON oc.`idcontent`=ct.`idcontent` JOIN content_classification cc ON ct.`idcontent`=cc.`idcontent` WHERE s.`publish`=1 AND s.`valid`=1 AND ct.`publish`=1 AND ct.`valid`=1 AND cc.`idclassification`=101 AND s.`idspectacle` IN (5132,5302,5303,5409,5412,5430,6203,6225,6283,6430,6583,6633,6639,6722,6731,6930,6940,6966,7084,7199,7278,7295,7582,7722,7795,8054,8111,8119,8191,8254,8326,8336,8394,8417,8499,8531,8573,8575,8623,8732,8737,8790,8899,9027,9073,9161,9202,9340,9366,9403,9477,9596,9733,9913,10158,10347,10353,10375,10393,10548,10580,10710,10778,10929,10930,11152,11158,11167,11179,11213,11598,11620,11695,11738,11751,11887,11928,12174,12412,12417,12429,12735,13100,13186,13301,13463,13487,13662,13697,13752,13826,13968,14004,14047,14134,14186,14188,14398,14485,14609,14621,14648,14717,14794,14901,14924,15140,15146,15163,15167,15272,15290,15351,15419,15535,15640,16008,16029,16315,16452,16563,16623,16636,16694,16802,16832,16982,17168,17212,17246,17304,17422,17448,17561,17743,17744,17775,17823,17856,17866,17933,18046,18215,18350,18367,18386,18441,19080,19493,19544,19545,19577,19688,19725,19735,20178,20203,20327,20347,20380,20758,20830,20855,20889,20946,20978,20979,21005,21070,21073,21150,21166,21353,21359,21440,21544,21907,22062,22368,22384,22535,22570,22613,22631,22671,22717,23132,23134,23142,23213,23389,23431,23703,23899,23967,23991,23993,23999,24029,24048,24268,24330,24483,24694,25282,25341,25583,25584,25763,25871,25954,25960,25973,26086,26104,26158,26306,26384,26439,26533,26575,26849,26878,26969,27034,27105,27119,27593,27759,27912,27979,28265,28369,28463,28473,28542,28600,28605,28762,29010,29157,29199,29218,29223,29224,29297,29408,29759,29762,29788,30079,30231,30269,30299,30539,30659,30668,30964,31136,31188,31222,31591,31688,31858,31881,31943,32076,32128,32164,32500,32501,33144,33168,33334,33352,33908,33959,34181,34713,34925,35089,35114,35164,35254,35549,35636,35814,35882,35969,36234,36838,36878,37140,37208,37212)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
21 | 0.13 ms |
SELECT DISTINCT(multimedias.idmultimedia) FROM `object_multimedia` , `multimedias` WHERE 1 AND object_multimedia.`idrole`=25 AND multimedias.`publish`=1 AND object_multimedia.`object`='persons' AND object_multimedia.`idobject`=468 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` GROUP BY multimedias.idmultimedia ORDER BY multimedias.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
22 | 7.80 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_.idspectacle IN (5132, 5302, 5303, 5409, 5412, 5430, 6203, 6225, 6283, 6430, 6583, 6633, 6639, 6722, 6731, 6930, 6940, 6966, 7084, 7199, 7278, 7295, 7582, 7722, 7795, 8054, 8111, 8119, 8191, 8254, 8326, 8336, 8394, 8417, 8499, 8531, 8573, 8575, 8623, 8732, 8737, 8790, 8899, 9027, 9073, 9161, 9202, 9340, 9366, 9403, 9477, 9596, 9733, 9913, 10158, 10347, 10353, 10375, 10393, 10548, 10580, 10710, 10778, 10929, 10930, 11152, 11158, 11167, 11179, 11213, 11598, 11620, 11695, 11738, 11751, 11887, 11928, 12174, 12412, 12417, 12429, 12735, 13100, 13186, 13301, 13463, 13487, 13662, 13697, 13752, 13826, 13968, 14004, 14047, 14134, 14186, 14188, 14398, 14485, 14609, 14621, 14648, 14717, 14794, 14901, 14924, 15140, 15146, 15163, 15167, 15272, 15290, 15351, 15419, 15535, 15640, 16008, 16029, 16315, 16452, 16563, 16623, 16636, 16694, 16802, 16832, 16982, 17168, 17212, 17246, 17304, 17422, 17448, 17561, 17743, 17744, 17775, 17823, 17856, 17866, 17933, 18046, 18215, 18350, 18367, 18386, 18441, 19080, 19493, 19544, 19545, 19577, 19688, 19725, 19735, 20178, 20203, 20327, 20347, 20380, 20758, 20830, 20855, 20889, 20946, 20978, 20979, 21005, 21070, 21073, 21150, 21166, 21353, 21359, 21440, 21544, 21907, 22062, 22368, 22384, 22535, 22570, 22613, 22631, 22671, 22717, 23132, 23134, 23142, 23213, 23389, 23431, 23703, 23899, 23967, 23991, 23993, 23999, 24029, 24048, 24268, 24330, 24483, 24694, 25282, 25341, 25583, 25584, 25763, 25871, 25954, 25960, 25973, 26086, 26104, 26158, 26306, 26384, 26439, 26533, 26575, 26849, 26878, 26969, 27034, 27105, 27119, 27593, 27759, 27912, 27979, 28265, 28369, 28463, 28473, 28542, 28600, 28605, 28762, 29010, 29157, 29199, 29218, 29223, 29224, 29297, 29408, 29759, 29762, 29788, 30079, 30231, 30269, 30299, 30539, 30659, 30668, 30964, 31136, 31188, 31222, 31591, 31688, 31858, 31881, 31943, 32076, 32128, 32164, 32500, 32501, 33144, 33168, 33334, 33352, 33908, 33959, 34181, 34713, 34925, 35089, 35114, 35164, 35254, 35549, 35636, 35814, 35882, 35969, 36234, 36838, 36878, 37140, 37208, 37212) AND ((s1_.date BETWEEN '2024-04-28' AND '2026-04-18')) ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
23 | 143.87 ms |
SELECT COUNT(DISTINCT (s0_.idspectacle)) AS sclr_0, MIN(s1_.date) AS sclr_1 FROM spectacles s0_ LEFT JOIN text_spectacle t3_ ON s0_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s0_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s1_ ON s0_.idspectacle = s1_.idspectacle LEFT JOIN spectacle_person s6_ ON s0_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s1_.idcontact = c7_.idcontact LEFT JOIN 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_.idspectacle IN (5132, 5302, 5303, 5409, 5412, 5430, 6203, 6225, 6283, 6430, 6583, 6633, 6639, 6722, 6731, 6930, 6940, 6966, 7084, 7199, 7278, 7295, 7582, 7722, 7795, 8054, 8111, 8119, 8191, 8254, 8326, 8336, 8394, 8417, 8499, 8531, 8573, 8575, 8623, 8732, 8737, 8790, 8899, 9027, 9073, 9161, 9202, 9340, 9366, 9403, 9477, 9596, 9733, 9913, 10158, 10347, 10353, 10375, 10393, 10548, 10580, 10710, 10778, 10929, 10930, 11152, 11158, 11167, 11179, 11213, 11598, 11620, 11695, 11738, 11751, 11887, 11928, 12174, 12412, 12417, 12429, 12735, 13100, 13186, 13301, 13463, 13487, 13662, 13697, 13752, 13826, 13968, 14004, 14047, 14134, 14186, 14188, 14398, 14485, 14609, 14621, 14648, 14717, 14794, 14901, 14924, 15140, 15146, 15163, 15167, 15272, 15290, 15351, 15419, 15535, 15640, 16008, 16029, 16315, 16452, 16563, 16623, 16636, 16694, 16802, 16832, 16982, 17168, 17212, 17246, 17304, 17422, 17448, 17561, 17743, 17744, 17775, 17823, 17856, 17866, 17933, 18046, 18215, 18350, 18367, 18386, 18441, 19080, 19493, 19544, 19545, 19577, 19688, 19725, 19735, 20178, 20203, 20327, 20347, 20380, 20758, 20830, 20855, 20889, 20946, 20978, 20979, 21005, 21070, 21073, 21150, 21166, 21353, 21359, 21440, 21544, 21907, 22062, 22368, 22384, 22535, 22570, 22613, 22631, 22671, 22717, 23132, 23134, 23142, 23213, 23389, 23431, 23703, 23899, 23967, 23991, 23993, 23999, 24029, 24048, 24268, 24330, 24483, 24694, 25282, 25341, 25583, 25584, 25763, 25871, 25954, 25960, 25973, 26086, 26104, 26158, 26306, 26384, 26439, 26533, 26575, 26849, 26878, 26969, 27034, 27105, 27119, 27593, 27759, 27912, 27979, 28265, 28369, 28463, 28473, 28542, 28600, 28605, 28762, 29010, 29157, 29199, 29218, 29223, 29224, 29297, 29408, 29759, 29762, 29788, 30079, 30231, 30269, 30299, 30539, 30659, 30668, 30964, 31136, 31188, 31222, 31591, 31688, 31858, 31881, 31943, 32076, 32128, 32164, 32500, 32501, 33144, 33168, 33334, 33352, 33908, 33959, 34181, 34713, 34925, 35089, 35114, 35164, 35254, 35549, 35636, 35814, 35882, 35969, 36234, 36838, 36878, 37140, 37208, 37212) AND s1_.date < '2024-04-28' ORDER BY sclr_1 DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
24 | 1.42 ms |
SELECT COUNT(DISTINCT(m.idmultimedia)) FROM object_multimedia om, multimedias m WHERE om.idmultimedia=m.idmultimedia AND om.idobject=468 AND om.object='persons' AND m.publish=1 ORDER BY m.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
25 | 4.91 ms |
SELECT DISTINCT(m.idmultimedia),m.* FROM object_multimedia om, multimedias m WHERE om.idmultimedia=m.idmultimedia AND om.idobject=468 AND om.object='persons' AND m.publish=1 ORDER BY m.date DESC LIMIT 0, 20
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
26 | 0.55 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:
[
"17479"
]
|
||||||||||||||||||||||||||||||||||
27 | 0.60 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=17479 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
28 | 0.37 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=17479 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
29 | 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=17479 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
30 | 4.14 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=17479 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
31 | 0.81 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=17479 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
32 | 0.36 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=17479 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
33 | 5.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=17479 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
34 | 0.13 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=33959
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
35 | 0.16 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=33959
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
36 | 0.28 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=17479 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
37 | 0.31 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=17479 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
38 | 0.42 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:
[
"16992"
]
|
||||||||||||||||||||||||||||||||||
39 | 0.33 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=16992 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
40 | 0.43 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=16992 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
41 | 0.53 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=16992 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
42 | 3.32 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=16992 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
43 | 0.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=16992 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
44 | 0.35 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=16992 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
45 | 4.71 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=16992 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
46 | 0.21 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=33168
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
47 | 0.18 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=33168
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
48 | 0.30 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=16992 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
49 | 0.45 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=16992 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
50 | 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:
[
"17134"
]
|
||||||||||||||||||||||||||||||||||
51 | 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=17134 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
52 | 0.26 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=17134 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
53 | 0.27 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=17134 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
54 | 3.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=17134 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
55 | 0.68 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=17134 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
56 | 0.30 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=17134 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
57 | 4.65 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=17134 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
58 | 0.22 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=30079
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
59 | 0.24 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=30079
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
60 | 0.24 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=17134 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
61 | 0.29 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=17134 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
62 | 0.44 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:
[
"16649"
]
|
||||||||||||||||||||||||||||||||||
63 | 0.47 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=16649 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
64 | 0.33 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=16649 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
65 | 0.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=16649 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
66 | 3.10 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=16649 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
67 | 0.67 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=16649 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
68 | 0.32 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=16649 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
69 | 4.54 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=16649 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
70 | 0.06 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=33168
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
71 | 0.04 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=33168
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
72 | 0.25 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=16649 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
73 | 0.22 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=16649 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
74 | 0.35 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:
[
"16797"
]
|
||||||||||||||||||||||||||||||||||
75 | 0.32 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=16797 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
76 | 0.25 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=16797 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
77 | 0.31 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=16797 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
78 | 3.43 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=16797 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
79 | 0.65 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=16797 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
80 | 0.36 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=16797 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
81 | 5.12 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=16797 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
82 | 0.08 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=33168
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
83 | 0.06 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=33168
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
84 | 0.36 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=16797 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
85 | 0.30 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=16797 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
86 | 0.51 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:
[
"16505"
]
|
||||||||||||||||||||||||||||||||||
87 | 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=16505 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
88 | 0.32 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=16505 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
89 | 0.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=16505 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
90 | 2.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=16505 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
91 | 0.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=16505 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
92 | 0.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=16505 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
93 | 4.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=16505 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
94 | 0.17 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=29408
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
95 | 0.18 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=29408
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
96 | 0.24 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=16505 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
97 | 0.21 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=16505 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
98 | 0.49 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:
[
"17348"
]
|
||||||||||||||||||||||||||||||||||
99 | 0.43 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=17348 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
100 | 0.31 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=17348 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
101 | 0.27 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=17348 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
102 | 3.16 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=17348 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
103 | 0.67 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=17348 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
104 | 0.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=17348 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
105 | 4.74 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=17348 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
106 | 0.17 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=34181
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
107 | 0.17 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=34181
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
108 | 0.24 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=17348 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
109 | 0.28 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=17348 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
110 | 0.40 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:
[
"16510"
]
|
||||||||||||||||||||||||||||||||||
111 | 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=16510 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
112 | 0.33 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=16510 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
113 | 0.37 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=16510 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
114 | 2.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=16510 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
115 | 0.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=16510 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
116 | 0.30 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=16510 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
117 | 4.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=16510 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
118 | 0.21 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=31688
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
119 | 0.24 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=31688
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
120 | 5.01 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=16510 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
121 | 0.25 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=16510 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
122 | 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:
[
"15669"
]
|
||||||||||||||||||||||||||||||||||
123 | 0.40 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=15669 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
124 | 0.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=15669 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
125 | 0.29 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=15669 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
126 | 2.68 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=15669 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
127 | 0.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=15669 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
128 | 0.24 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=15669 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
129 | 0.24 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=15669 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
130 | 0.13 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=31881
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
131 | 0.20 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=31881
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
132 | 0.23 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=15669 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
133 | 0.26 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=15669 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
134 | 0.39 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:
[
"15583"
]
|
||||||||||||||||||||||||||||||||||
135 | 0.37 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=15583 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
136 | 0.31 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=15583 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
137 | 0.34 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=15583 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
138 | 2.70 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=15583 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
139 | 0.62 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=15583 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
140 | 0.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=15583 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
141 | 4.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=15583 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
142 | 0.07 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=31688
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
143 | 0.04 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=31688
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
144 | 4.60 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=15583 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
145 | 0.23 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=15583 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
146 | 0.48 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:
[
"17844"
]
|
||||||||||||||||||||||||||||||||||
147 | 0.32 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=17844 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
148 | 0.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=17844 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
149 | 0.28 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=17844 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
150 | 3.21 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=17844 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
151 | 0.61 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=17844 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
152 | 0.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=17844 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
153 | 4.72 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=17844 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
154 | 0.14 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=14794
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
155 | 0.23 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=14794
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
156 | 0.36 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=17844 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
157 | 0.79 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=17844 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
158 | 1.07 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:
[
"15280"
]
|
||||||||||||||||||||||||||||||||||
159 | 0.93 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=15280 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
160 | 0.73 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=15280 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
161 | 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=15280 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
162 | 5.60 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=15280 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
163 | 1.01 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=15280 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
164 | 0.43 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=15280 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
165 | 6.62 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=15280 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
166 | 0.16 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=30231
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
167 | 0.20 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=30231
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
168 | 0.29 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=15280 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
169 | 0.24 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=15280 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
170 | 0.57 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:
[
"14953"
]
|
||||||||||||||||||||||||||||||||||
171 | 0.47 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=14953 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
172 | 0.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=14953 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
173 | 0.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=14953 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
174 | 0.22 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=14953 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
175 | 0.59 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=14953 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
176 | 0.25 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=14953 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
177 | 0.26 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=14953 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
178 | 0.27 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=14953 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
179 | 0.25 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=14953 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
180 | 0.37 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:
[
"16845"
]
|
||||||||||||||||||||||||||||||||||
181 | 0.27 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=16845 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
182 | 0.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=16845 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
183 | 0.32 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=16845 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
184 | 3.05 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=16845 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
185 | 0.68 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=16845 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
186 | 0.30 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=16845 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
187 | 4.52 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=16845 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
188 | 0.07 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=30079
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
189 | 0.05 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=30079
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
190 | 0.27 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=16845 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
191 | 0.22 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=16845 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
192 | 0.46 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:
[
"15706"
]
|
||||||||||||||||||||||||||||||||||
193 | 0.54 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=15706 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
194 | 0.28 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=15706 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
195 | 0.31 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=15706 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
196 | 2.79 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=15706 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
197 | 0.67 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=15706 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
198 | 0.33 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=15706 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
199 | 4.12 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=15706 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
200 | 0.15 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=31222
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
201 | 0.21 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=31222
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
202 | 0.33 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=15706 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
203 | 0.26 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=15706 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
204 | 0.39 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:
[
"14702"
]
|
||||||||||||||||||||||||||||||||||
205 | 0.42 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=14702 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
206 | 0.26 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=14702 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
207 | 0.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=14702 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
208 | 2.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=14702 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
209 | 0.60 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=14702 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
210 | 0.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=14702 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
211 | 4.00 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=14702 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
212 | 0.09 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=30231
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
213 | 0.05 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=30231
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
214 | 0.43 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=14702 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
215 | 0.39 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=14702 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
216 | 0.63 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:
[
"16044"
]
|
||||||||||||||||||||||||||||||||||
217 | 0.54 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=16044 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
218 | 0.53 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=16044 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
219 | 0.46 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=16044 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
220 | 2.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=16044 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
221 | 0.70 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=16044 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
222 | 0.29 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=16044 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
223 | 4.25 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=16044 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
224 | 0.08 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=30231
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
225 | 0.06 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=30231
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
226 | 0.27 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=16044 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
227 | 0.26 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=16044 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
228 | 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:
[
"14107"
]
|
||||||||||||||||||||||||||||||||||
229 | 0.43 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=14107 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
230 | 0.31 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=14107 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
231 | 0.26 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=14107 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
232 | 0.22 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=14107 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
233 | 1.03 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=14107 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
234 | 0.28 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=14107 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
235 | 0.27 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=14107 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
236 | 0.24 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=14107 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
237 | 0.25 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=14107 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
238 | 0.45 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:
[
"13488"
]
|
||||||||||||||||||||||||||||||||||
239 | 0.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=13488 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
240 | 0.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=13488 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
241 | 0.27 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=13488 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
242 | 1.91 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=13488 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
243 | 0.68 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=13488 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
244 | 0.25 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=13488 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
245 | 3.56 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=13488 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
246 | 0.14 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=27119
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
247 | 0.24 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=13488 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
248 | 0.21 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=13488 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
249 | 0.40 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:
[
"13831"
]
|
||||||||||||||||||||||||||||||||||
250 | 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=13831 AND object_multimedia.object='persons' AND object_multimedia.idrole=21 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
251 | 0.26 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=13831 AND object_multimedia.object='persons' AND object_multimedia.idrole=1 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
252 | 0.32 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=13831 AND object_multimedia.object='persons' AND object_multimedia.idrole=5 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
253 | 1.99 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=13831 AND object_multimedia.object='persons' AND object_multimedia.idrole=25 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
254 | 0.62 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=13831 AND object_multimedia.object='contacts' AND object_multimedia.idrole=22 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
255 | 0.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=13831 AND object_multimedia.object='contacts' AND object_multimedia.idrole=23 ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
256 | 3.96 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=13831 AND object_multimedia.object='spectacles' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
257 | 0.16 ms |
SELECT idspectacle,title,url_clean,valid FROM spectacles WHERE idspectacle=23999
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
258 | 0.43 ms |
SELECT t.title FROM texts t, text_spectacle ts WHERE t.idtext=ts.idtext AND ts.idspectacle=23999
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
259 | 0.30 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=13831 AND object_multimedia.object='texts' ORDER BY object_multimedia.ordermultimedia
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
260 | 0.48 ms |
SELECT DISTINCT(keywords.idkeyword), keywords.* FROM `multimedia_keyword` , `keywords` WHERE 1 AND keywords.`publish`=1 AND multimedia_keyword.`idmultimedia`=13831 AND keywords.`idkeyword`=multimedia_keyword.`idkeyword` GROUP BY keywords.idkeyword ORDER BY keywords.dateinsert DESC LIMIT 0,10
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
261 | 0.08 ms |
SELECT COUNT(DISTINCT(m.idmultimedia)) FROM object_multimedia om, multimedias m WHERE om.idmultimedia=m.idmultimedia AND om.idobject=468 AND om.object='persons' AND m.publish=1 ORDER BY m.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
262 | 5.03 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 ('persons') AND object_multimedia.`idobject`=468 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` GROUP BY multimedias.idmultimedia ORDER BY multimedias.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
263 | 0.76 ms |
SELECT r.idrole, r.role, r.role_male, r.role_female, lg.fr FROM spectacle_person sp JOIN roles r ON sp.idrole=r.idrole JOIN langterms lg ON lg.id=r.role WHERE sp.idperson=468 GROUP BY r.idrole
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
264 | 78.01 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 t2_.idtext IN (4777, 5120, 7509, 7510, 7953, 7959, 8146, 8167, 8823, 9174, 9489, 9490, 9872, 10231, 10270, 10365, 10695, 11173, 11384, 11859, 14186, 14707, 15294, 15496, 17898, 18775, 19246, 19250, 19524, 22149, 26398, 32324, 33114, 45583, 4778, 10354, 11549, 12524, 15253, 17276, 18214, 20589, 20910, 28846, 30558, 31341, 35085, 36217, 36856, 36857, 9946, 14751, 21503, 35512, 9641, 15579, 19385, 29089, 30059, 32720, 33627, 36454, 36455, 36856, 16445, 26270, 32189, 33439, 33627, 9746, 10273, 10703, 13295, 13769, 15884, 16117, 16123, 16860, 18120, 19251, 19525, 20256, 25463, 44367, 9918, 10923, 11279, 12336, 12477, 14684, 16890, 18015, 19026, 19801, 21146, 22304, 22871, 24709, 25009, 25298, 25318, 29690, 32333, 32565, 32793, 32903, 34642, 35832, 37487, 39916, 41627, 43022, 43439, 8168, 9510, 11631, 11845, 12182, 12719, 14688, 15209, 15346, 17658, 20746, 22924, 23126, 24597, 26886, 28292, 31740, 32546, 32631, 32973, 33076, 33925, 34403, 35537, 36856, 39631, 40567, 9175, 17491, 40511, 9491, 18453, 9491, 10845, 18453, 20589, 22467, 29042, 10271, 27890, 14695, 21548, 21911, 24535, 29786, 34201, 35195, 37520, 41250, 44177, 19525, 11385, 12683, 17159, 19378, 19506, 21303, 21698, 22117, 26301, 28126, 29588, 30586, 35184, 39694, 44117, 44177, 11989, 19251, 19525, 14194, 16971, 27890, 27934, 33407, 14716, 15296, 23036, 15503, 21599, 35264, 35993, 23074, 26174, 27890, 35324, 19251, 19525, 19525, 8134, 9627, 12001, 23056, 24599, 26039, 26139, 26343, 28757, 29652, 30131, 31263, 31739, 32051, 33620, 34052, 35335, 36856, 36858, 36887, 38769, 39986, 43962, 44638, 7513, 9424, 12805, 14348, 18674, 36927, 41838, 42572, 5121, 11661, 17277, 7511, 13797, 18694, 19704, 23316, 29694, 43783, 7512, 7954, 12053, 20861, 39330, 43578, 7960, 9749, 9932, 11230, 13763, 19860, 20609, 32564, 40055, 8147, 17366, 37034, 38033, 8827, 9647, 13074, 22475, 23315, 26302, 26675, 34611, 39848, 45127, 13869, 13986, 17086, 20831, 25494, 26206, 29698, 36085, 45563, 11728, 12525, 36351, 38814, 40512, 9873, 10232, 37205, 43538, 43539, 17772, 27217, 28205, 36878, 10698, 11174, 13952, 19000, 41267, 11836, 13621, 13893, 14349, 20274, 22433, 43460, 45144, 11865, 38712, 18183, 45561, 17899, 26674, 37405, 42186, 12518, 12520, 18006, 21188, 28630, 28758, 36403, 36457, 37350, 39236, 41609, 45064, 45562, 26402, 32325, 33115) ORDER BY s1_.date ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
265 | 1.52 ms |
SELECT COUNT(DISTINCT(dvds.iddvd)) as total FROM `dvds` , `dvd_spectacle` WHERE 1 AND dvds.`publish`=1 AND dvd_spectacle.`idspectacle` IN (5132,5302,5303,5409,5412,5430,6203,6225,6283,6430,6583,6633,6639,6722,6731,6930,6940,6966,7084,7199,7278,7295,7582,7722,7795,8054,8111,8119,8191,8254,8326,8336,8394,8417,8499,8531,8573,8575,8623,8732,8737,8790,8899,9027,9073,9161,9202,9340,9366,9403,9477,9596,9733,9913,10158,10347,10353,10375,10393,10548,10580,10710,10778,10929,10930,11152,11158,11167,11179,11213,11598,11620,11695,11738,11751,11887,11928,12174,12412,12417,12429,12735,13100,13186,13301,13463,13487,13662,13697,13752,13826,13968,14004,14047,14134,14186,14188,14398,14485,14609,14621,14648,14717,14794,14901,14924,15140,15146,15163,15167,15272,15290,15351,15419,15535,15640,16008,16029,16315,16452,16563,16623,16636,16694,16802,16832,16982,17168,17212,17246,17304,17422,17448,17561,17743,17744,17775,17823,17856,17866,17933,18046,18215,18350,18367,18386,18441,19080,19493,19544,19545,19577,19688,19725,19735,20178,20203,20327,20347,20380,20758,20830,20855,20889,20946,20978,20979,21005,21070,21073,21150,21166,21353,21359,21440,21544,21907,22062,22368,22384,22535,22570,22613,22631,22671,22717,23132,23134,23142,23213,23389,23431,23703,23899,23967,23991,23993,23999,24029,24048,24268,24330,24483,24694,25282,25341,25583,25584,25763,25871,25954,25960,25973,26086,26104,26158,26306,26384,26439,26533,26575,26849,26878,26969,27034,27105,27119,27593,27759,27912,27979,28265,28369,28463,28473,28542,28600,28605,28762,29010,29157,29199,29218,29223,29224,29297,29408,29759,29762,29788,30079,30231,30269,30299,30539,30659,30668,30964,31136,31188,31222,31591,31688,31858,31881,31943,32076,32128,32164,32500,32501,33144,33168,33334,33352,33908,33959,34181,34713,34925,35089,35114,35164,35254,35549,35636,35814,35882,35969,36234,36838,36878,37140,37208,37212) AND dvds.`iddvd`=dvd_spectacle.`iddvd`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
266 | 0.05 ms |
SELECT COUNT(DISTINCT(dvds.iddvd)) as total FROM `dvds` , `dvd_spectacle` WHERE 1 AND dvds.`publish`=1 AND dvd_spectacle.`idspectacle` IN (5132,5302,5303,5409,5412,5430,6203,6225,6283,6430,6583,6633,6639,6722,6731,6930,6940,6966,7084,7199,7278,7295,7582,7722,7795,8054,8111,8119,8191,8254,8326,8336,8394,8417,8499,8531,8573,8575,8623,8732,8737,8790,8899,9027,9073,9161,9202,9340,9366,9403,9477,9596,9733,9913,10158,10347,10353,10375,10393,10548,10580,10710,10778,10929,10930,11152,11158,11167,11179,11213,11598,11620,11695,11738,11751,11887,11928,12174,12412,12417,12429,12735,13100,13186,13301,13463,13487,13662,13697,13752,13826,13968,14004,14047,14134,14186,14188,14398,14485,14609,14621,14648,14717,14794,14901,14924,15140,15146,15163,15167,15272,15290,15351,15419,15535,15640,16008,16029,16315,16452,16563,16623,16636,16694,16802,16832,16982,17168,17212,17246,17304,17422,17448,17561,17743,17744,17775,17823,17856,17866,17933,18046,18215,18350,18367,18386,18441,19080,19493,19544,19545,19577,19688,19725,19735,20178,20203,20327,20347,20380,20758,20830,20855,20889,20946,20978,20979,21005,21070,21073,21150,21166,21353,21359,21440,21544,21907,22062,22368,22384,22535,22570,22613,22631,22671,22717,23132,23134,23142,23213,23389,23431,23703,23899,23967,23991,23993,23999,24029,24048,24268,24330,24483,24694,25282,25341,25583,25584,25763,25871,25954,25960,25973,26086,26104,26158,26306,26384,26439,26533,26575,26849,26878,26969,27034,27105,27119,27593,27759,27912,27979,28265,28369,28463,28473,28542,28600,28605,28762,29010,29157,29199,29218,29223,29224,29297,29408,29759,29762,29788,30079,30231,30269,30299,30539,30659,30668,30964,31136,31188,31222,31591,31688,31858,31881,31943,32076,32128,32164,32500,32501,33144,33168,33334,33352,33908,33959,34181,34713,34925,35089,35114,35164,35254,35549,35636,35814,35882,35969,36234,36838,36878,37140,37208,37212) AND dvds.`iddvd`=dvd_spectacle.`iddvd`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
267 | 0.60 ms |
SELECT COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* FROM `podcast_person` , `podcasts` WHERE 1 AND podcasts.`publish`=1 AND podcast_person.`idperson`=468 AND podcasts.`code_ft` IS NOT NULL AND podcasts.`debut_visionnage_ft`<='2024-04-28' AND podcasts.`fin_visionnage_ft`>'2024-04-28' AND (`podcasts`.`type_diffusion` IS NULL OR `podcasts`.`type_diffusion` = 0) AND podcasts.`is_integrale`=1 AND podcasts.`idpodcast`=podcast_person.`idpodcast`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
268 | 0.79 ms |
SELECT COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* FROM `podcast_person` , `podcasts` WHERE 1 AND podcasts.`publish`=1 AND podcast_person.`idperson`=468 AND podcasts.`code_ft` IS NOT NULL AND podcasts.`type_diffusion`=1 AND podcasts.`idpodcast`=podcast_person.`idpodcast`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
269 | 0.45 ms |
SELECT COUNT(DISTINCT(podcasts.idpodcast)) as total , podcasts.* FROM `podcast_person` , `podcasts` WHERE 1 AND podcasts.`publish`=1 AND podcast_person.`idperson`=468 AND podcasts.`code_ft` IS NOT NULL AND podcasts.`type_diffusion`=2 AND podcasts.`idpodcast`=podcast_person.`idpodcast`
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
270 | 0.12 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.classification IN ('class_photo_person'))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
271 | 0.09 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='468' AND of.object='persons' AND cl.idclassification=fc.idclassification AND f.publish=1 AND ((cl.classification IN ('class_photo_person'))) AND f.idtype=tf.idtype ORDER BY f.`range`,f.idfile
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
272 | 0.04 ms |
SELECT DISTINCT(cl.type) FROM classifications cl WHERE ((cl.idclassification IN (6))) AND persons=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
273 | 0.46 ms |
SELECT COUNT(DISTINCT(oc.idcontent)) as total FROM object_content oc, contents c, content_classification cc, classifications cl WHERE oc.idcontent=c.idcontent AND c.idcontent=cc.idcontent AND oc.idobject='468' AND oc.object='persons' AND cl.idclassification=cc.idclassification AND c.publish=1 AND ((cl.idclassification IN (6)))
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
274 | 0.27 ms |
SELECT COUNT(DISTINCT(p.`idplaylist`)) as total FROM playlists p LEFT JOIN playlist_classification pc ON pc.`idplaylist`=p.`idplaylist` LEFT JOIN classifications c ON pc.`idclassification`=c.`idclassification` WHERE p.`publish`=1 AND p.`idperson` IN (468) AND c.`classification`='class_auteur_meme'
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
275 | 6.65 ms |
SELECT DISTINCT(s.idschedule),hour,date,s.note,s.url_spectacle,s.url_booking,s.idcontact_festival,s.hour,s.idspectacle, c.idcontact,c.organisation,c.phone1,c.phone2,c.city,c.url_clean, ft.idcontact as festival_idcontact,ft.organisation as festival_organisation,ft.city as festival_city,ft.url_clean as festival_url_clean FROM schedules s JOIN contacts c ON s.idcontact=c.idcontact LEFT JOIN contacts ft ON s.idcontact_festival=ft.idcontact WHERE 1 AND s.idspectacle IN (5132,5302,5303,5409,5412,5430,6203,6225,6283,6430,6583,6633,6639,6722,6731,6930,6940,6966,7084,7199,7278,7295,7582,7722,7795,8054,8111,8119,8191,8254,8326,8336,8394,8417,8499,8531,8573,8575,8623,8732,8737,8790,8899,9027,9073,9161,9202,9340,9366,9403,9477,9596,9733,9913,10158,10347,10353,10375,10393,10548,10580,10710,10778,10929,10930,11152,11158,11167,11179,11213,11598,11620,11695,11738,11751,11887,11928,12174,12412,12417,12429,12735,13100,13186,13301,13463,13487,13662,13697,13752,13826,13968,14004,14047,14134,14186,14188,14398,14485,14609,14621,14648,14717,14794,14901,14924,15140,15146,15163,15167,15272,15290,15351,15419,15535,15640,16008,16029,16315,16452,16563,16623,16636,16694,16802,16832,16982,17168,17212,17246,17304,17422,17448,17561,17743,17744,17775,17823,17856,17866,17933,18046,18215,18350,18367,18386,18441,19080,19493,19544,19545,19577,19688,19725,19735,20178,20203,20327,20347,20380,20758,20830,20855,20889,20946,20978,20979,21005,21070,21073,21150,21166,21353,21359,21440,21544,21907,22062,22368,22384,22535,22570,22613,22631,22671,22717,23132,23134,23142,23213,23389,23431,23703,23899,23967,23991,23993,23999,24029,24048,24268,24330,24483,24694,25282,25341,25583,25584,25763,25871,25954,25960,25973,26086,26104,26158,26306,26384,26439,26533,26575,26849,26878,26969,27034,27105,27119,27593,27759,27912,27979,28265,28369,28463,28473,28542,28600,28605,28762,29010,29157,29199,29218,29223,29224,29297,29408,29759,29762,29788,30079,30231,30269,30299,30539,30659,30668,30964,31136,31188,31222,31591,31688,31858,31881,31943,32076,32128,32164,32500,32501,33144,33168,33334,33352,33908,33959,34181,34713,34925,35089,35114,35164,35254,35549,35636,35814,35882,35969,36234,36838,36878,37140,37208,37212) AND s.date>='2024-04-28' ORDER BY s.date ASC LIMIT 0,1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
276 | 0.80 ms |
SELECT COUNT(DISTINCT(T1.idnew)) as total FROM news T1 INNER JOIN newschedules T3 ON T3.idnew=T1.idnew INNER JOIN extranetusers T2 ON T2.idextranetuser=T1.idextranetuser LEFT JOIN contacts T4 ON T4.idcontact=T3.idcontact LEFT JOIN new_person T5 ON T5.idnew=T1.idnew WHERE 1 AND (T5.idperson=468 ) AND T1.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
277 | 0.79 ms |
SELECT COUNT(DISTINCT(m.idmultimedia)) FROM object_multimedia om, multimedias m WHERE om.idmultimedia=m.idmultimedia AND om.idobject=468 AND om.object='persons' AND m.publish=1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
278 | 0.55 ms |
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total FROM podcasts d, podcast_person do WHERE d.`publish`=1 AND do.`idpodcast`= d.`idpodcast` AND do.`idperson`=468 AND d.code_franceinter IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
279 | 0.34 ms |
SELECT COUNT(DISTINCT(d.`idpodcast`)) as total FROM podcasts d, podcast_person do WHERE d.`publish`=1 AND do.`idpodcast`= d.`idpodcast` AND do.`idperson`=468 AND d.code_soundcloud IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
280 | 2.88 ms |
SELECT COUNT(DISTINCT(T1.`idtext`)) as total FROM texts T1 LEFT JOIN contacts T2 ON T2.`idcontact`=T1.`idcontact_publisher` ,object_content oc2, contents c2, content_classification cc2 WHERE 1 AND oc2.idcontent=c2.idcontent AND cc2.idcontent=c2.idcontent AND oc2.idobject=T1.idtext AND cc2.idclassification IN (125) AND oc2.object='texts' AND T1.`idtext` IN (4777,5120,7509,7510,7953,7959,8146,8167,8823,9174,9489,9490,9872,10231,10270,10365,10695,11173,11384,11859,14186,14707,15294,15496,17898,18775,19246,19250,19524,22149,26398,32324,33114,45583,4778,10354,11549,12524,15253,17276,18214,20589,20910,28846,30558,31341,35085,36217,36856,36857,9946,14751,21503,35512,9641,15579,19385,29089,30059,32720,33627,36454,36455,36856,16445,26270,32189,33439,33627,9746,10273,10703,13295,13769,15884,16117,16123,16860,18120,19251,19525,20256,25463,44367,9918,10923,11279,12336,12477,14684,16890,18015,19026,19801,21146,22304,22871,24709,25009,25298,25318,29690,32333,32565,32793,32903,34642,35832,37487,39916,41627,43022,43439,8168,9510,11631,11845,12182,12719,14688,15209,15346,17658,20746,22924,23126,24597,26886,28292,31740,32546,32631,32973,33076,33925,34403,35537,36856,39631,40567,9175,17491,40511,9491,18453,9491,10845,18453,20589,22467,29042,10271,27890,14695,21548,21911,24535,29786,34201,35195,37520,41250,44177,19525,11385,12683,17159,19378,19506,21303,21698,22117,26301,28126,29588,30586,35184,39694,44117,44177,11989,19251,19525,14194,16971,27890,27934,33407,14716,15296,23036,15503,21599,35264,35993,23074,26174,27890,35324,19251,19525,19525,8134,9627,12001,23056,24599,26039,26139,26343,28757,29652,30131,31263,31739,32051,33620,34052,35335,36856,36858,36887,38769,39986,43962,44638,7513,9424,12805,14348,18674,36927,41838,42572,5121,11661,17277,7511,13797,18694,19704,23316,29694,43783,7512,7954,12053,20861,39330,43578,7960,9749,9932,11230,13763,19860,20609,32564,40055,8147,17366,37034,38033,8827,9647,13074,22475,23315,26302,26675,34611,39848,45127,13869,13986,17086,20831,25494,26206,29698,36085,45563,11728,12525,36351,38814,40512,9873,10232,37205,43538,43539,17772,27217,28205,36878,10698,11174,13952,19000,41267,11836,13621,13893,14349,20274,22433,43460,45144,11865,38712,18183,45561,17899,26674,37405,42186,12518,12520,18006,21188,28630,28758,36403,36457,37350,39236,41609,45064,45562,26402,32325,33115) ORDER BY publication_year DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
281 | 66.88 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 (125) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND s0_.idspectacle IN (5132, 5302, 5303, 5409, 5412, 5430, 6203, 6225, 6283, 6430, 6583, 6633, 6639, 6722, 6731, 6930, 6940, 6966, 7084, 7199, 7278, 7295, 7582, 7722, 7795, 8054, 8111, 8119, 8191, 8254, 8326, 8336, 8394, 8417, 8499, 8531, 8573, 8575, 8623, 8732, 8737, 8790, 8899, 9027, 9073, 9161, 9202, 9340, 9366, 9403, 9477, 9596, 9733, 9913, 10158, 10347, 10353, 10375, 10393, 10548, 10580, 10710, 10778, 10929, 10930, 11152, 11158, 11167, 11179, 11213, 11598, 11620, 11695, 11738, 11751, 11887, 11928, 12174, 12412, 12417, 12429, 12735, 13100, 13186, 13301, 13463, 13487, 13662, 13697, 13752, 13826, 13968, 14004, 14047, 14134, 14186, 14188, 14398, 14485, 14609, 14621, 14648, 14717, 14794, 14901, 14924, 15140, 15146, 15163, 15167, 15272, 15290, 15351, 15419, 15535, 15640, 16008, 16029, 16315, 16452, 16563, 16623, 16636, 16694, 16802, 16832, 16982, 17168, 17212, 17246, 17304, 17422, 17448, 17561, 17743, 17744, 17775, 17823, 17856, 17866, 17933, 18046, 18215, 18350, 18367, 18386, 18441, 19080, 19493, 19544, 19545, 19577, 19688, 19725, 19735, 20178, 20203, 20327, 20347, 20380, 20758, 20830, 20855, 20889, 20946, 20978, 20979, 21005, 21070, 21073, 21150, 21166, 21353, 21359, 21440, 21544, 21907, 22062, 22368, 22384, 22535, 22570, 22613, 22631, 22671, 22717, 23132, 23134, 23142, 23213, 23389, 23431, 23703, 23899, 23967, 23991, 23993, 23999, 24029, 24048, 24268, 24330, 24483, 24694, 25282, 25341, 25583, 25584, 25763, 25871, 25954, 25960, 25973, 26086, 26104, 26158, 26306, 26384, 26439, 26533, 26575, 26849, 26878, 26969, 27034, 27105, 27119, 27593, 27759, 27912, 27979, 28265, 28369, 28463, 28473, 28542, 28600, 28605, 28762, 29010, 29157, 29199, 29218, 29223, 29224, 29297, 29408, 29759, 29762, 29788, 30079, 30231, 30269, 30299, 30539, 30659, 30668, 30964, 31136, 31188, 31222, 31591, 31688, 31858, 31881, 31943, 32076, 32128, 32164, 32500, 32501, 33144, 33168, 33334, 33352, 33908, 33959, 34181, 34713, 34925, 35089, 35114, 35164, 35254, 35549, 35636, 35814, 35882, 35969, 36234, 36838, 36878, 37140, 37208, 37212) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||||
282 | 33.02 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 (82) AND s0_.idspectacle = o2_.idobject AND c9_.idcontent = o2_.idcontent AND s0_.idspectacle IN (5132, 5302, 5303, 5409, 5412, 5430, 6203, 6225, 6283, 6430, 6583, 6633, 6639, 6722, 6731, 6930, 6940, 6966, 7084, 7199, 7278, 7295, 7582, 7722, 7795, 8054, 8111, 8119, 8191, 8254, 8326, 8336, 8394, 8417, 8499, 8531, 8573, 8575, 8623, 8732, 8737, 8790, 8899, 9027, 9073, 9161, 9202, 9340, 9366, 9403, 9477, 9596, 9733, 9913, 10158, 10347, 10353, 10375, 10393, 10548, 10580, 10710, 10778, 10929, 10930, 11152, 11158, 11167, 11179, 11213, 11598, 11620, 11695, 11738, 11751, 11887, 11928, 12174, 12412, 12417, 12429, 12735, 13100, 13186, 13301, 13463, 13487, 13662, 13697, 13752, 13826, 13968, 14004, 14047, 14134, 14186, 14188, 14398, 14485, 14609, 14621, 14648, 14717, 14794, 14901, 14924, 15140, 15146, 15163, 15167, 15272, 15290, 15351, 15419, 15535, 15640, 16008, 16029, 16315, 16452, 16563, 16623, 16636, 16694, 16802, 16832, 16982, 17168, 17212, 17246, 17304, 17422, 17448, 17561, 17743, 17744, 17775, 17823, 17856, 17866, 17933, 18046, 18215, 18350, 18367, 18386, 18441, 19080, 19493, 19544, 19545, 19577, 19688, 19725, 19735, 20178, 20203, 20327, 20347, 20380, 20758, 20830, 20855, 20889, 20946, 20978, 20979, 21005, 21070, 21073, 21150, 21166, 21353, 21359, 21440, 21544, 21907, 22062, 22368, 22384, 22535, 22570, 22613, 22631, 22671, 22717, 23132, 23134, 23142, 23213, 23389, 23431, 23703, 23899, 23967, 23991, 23993, 23999, 24029, 24048, 24268, 24330, 24483, 24694, 25282, 25341, 25583, 25584, 25763, 25871, 25954, 25960, 25973, 26086, 26104, 26158, 26306, 26384, 26439, 26533, 26575, 26849, 26878, 26969, 27034, 27105, 27119, 27593, 27759, 27912, 27979, 28265, 28369, 28463, 28473, 28542, 28600, 28605, 28762, 29010, 29157, 29199, 29218, 29223, 29224, 29297, 29408, 29759, 29762, 29788, 30079, 30231, 30269, 30299, 30539, 30659, 30668, 30964, 31136, 31188, 31222, 31591, 31688, 31858, 31881, 31943, 32076, 32128, 32164, 32500, 32501, 33144, 33168, 33334, 33352, 33908, 33959, 34181, 34713, 34925, 35089, 35114, 35164, 35254, 35549, 35636, 35814, 35882, 35969, 36234, 36838, 36878, 37140, 37208, 37212) ORDER BY sclr_1 DESC
Parameters:
[] |
||||||||||||||||||||||||||||||||||
283 | 4.91 ms |
SELECT DISTINCT(multimedias.idmultimedia), multimedias.*,spectacles.`idspectacle`,schedules.`idcontact` FROM `object_multimedia` , `schedules` , `spectacles` , `contacts` , `multimedias` , `multimedia_classification` WHERE 1 AND multimedias.`publish`=1 AND object_multimedia.`object`='spectacles' AND object_multimedia.`idrole` IS NULL AND schedules.`date` BETWEEN '1999-01-01' AND '2030-01-01' AND object_multimedia.`object`='spectacles' AND object_multimedia.`idobject` IN (5132,5302,5303,5409,5412,5430,6203,6225,6283,6430,6583,6633,6639,6722,6731,6930,6940,6966,7084,7199,7278,7295,7582,7722,7795,8054,8111,8119,8191,8254,8326,8336,8394,8417,8499,8531,8573,8575,8623,8732,8737,8790,8899,9027,9073,9161,9202,9340,9366,9403,9477,9596,9733,9913,10158,10347,10353,10375,10393,10548,10580,10710,10778,10929,10930,11152,11158,11167,11179,11213,11598,11620,11695,11738,11751,11887,11928,12174,12412,12417,12429,12735,13100,13186,13301,13463,13487,13662,13697,13752,13826,13968,14004,14047,14134,14186,14188,14398,14485,14609,14621,14648,14717,14794,14901,14924,15140,15146,15163,15167,15272,15290,15351,15419,15535,15640,16008,16029,16315,16452,16563,16623,16636,16694,16802,16832,16982,17168,17212,17246,17304,17422,17448,17561,17743,17744,17775,17823,17856,17866,17933,18046,18215,18350,18367,18386,18441,19080,19493,19544,19545,19577,19688,19725,19735,20178,20203,20327,20347,20380,20758,20830,20855,20889,20946,20978,20979,21005,21070,21073,21150,21166,21353,21359,21440,21544,21907,22062,22368,22384,22535,22570,22613,22631,22671,22717,23132,23134,23142,23213,23389,23431,23703,23899,23967,23991,23993,23999,24029,24048,24268,24330,24483,24694,25282,25341,25583,25584,25763,25871,25954,25960,25973,26086,26104,26158,26306,26384,26439,26533,26575,26849,26878,26969,27034,27105,27119,27593,27759,27912,27979,28265,28369,28463,28473,28542,28600,28605,28762,29010,29157,29199,29218,29223,29224,29297,29408,29759,29762,29788,30079,30231,30269,30299,30539,30659,30668,30964,31136,31188,31222,31591,31688,31858,31881,31943,32076,32128,32164,32500,32501,33144,33168,33334,33352,33908,33959,34181,34713,34925,35089,35114,35164,35254,35549,35636,35814,35882,35969,36234,36838,36878,37140,37208,37212) AND multimedia_classification.`idclassification`=145 AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` AND schedules.`idspectacle`=spectacles.`idspectacle` AND spectacles.`idspectacle`=object_multimedia.`idobject` AND contacts.`idcontact`=schedules.`idcontact` AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` AND multimedias.`idmultimedia`=multimedia_classification.`idmultimedia` GROUP BY object_multimedia.`idobject` ORDER BY schedules.`date` ASC LIMIT 0,100
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
284 | 0.57 ms |
SELECT t0.idstat AS idstat_1, t0.type AS type_2, t0.module AS module_3, t0.url AS url_4, t0.idcontent AS idcontent_5, t0.object AS object_6, t0.idobject AS idobject_7, t0.video AS video_8, t0.remote_addr AS remote_addr_9, t0.lng AS lng_10, t0.source AS source_11, t0.md5url AS md5url_12, t0.dateinsert AS dateinsert_13 FROM stats t0 WHERE t0.remote_addr = ? AND t0.idcontent = ? AND t0.md5url = ?
Parameters:
[ "1fe86105e80a4cde937aadf5bd8d1183-5777" 0 "002f099ca2aa28c81d12811f22ac0ffb" ]
|
||||||||||||||||||||||||||||||||||
285 | 1.13 ms |
INSERT INTO stats (type, module, url, md5url, idcontent, object, idobject, video, lng, remote_addr, source) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "article" "thnet" "/biographies/William-Shakespeare/videos/type/all" "002f099ca2aa28c81d12811f22ac0ffb" 0 "persons" 468 0 "fr" "1fe86105e80a4cde937aadf5bd8d1183-5777" "/home/web/theatre-contemporain.net/dev/src/Controller/BiographieController.php:553" ]
|
||||||||||||||||||||||||||||||||||
286 | 1.09 ms |
SELECT * FROM bannieres WHERE publish=1 AND valid=1 AND is_bottom=1 AND date_start<=NOW() AND date_end>=NOW() ORDER BY bannieres.order ASC LIMIT 0,10
Parameters:
[]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts