| - |
28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64

74 »
Time: 0.138 sec
Memory: 4.51 Mb
Peak memory: 4.81 Mb
Total SQL queries: 38
Total SQL time: 0.031 sec
Slowest SQL query time: 0.007 sec
Slowest SQL query:
SELECT 
						v.ID,
						v.ObjectID,
						v.type,
						v.publishDate,
						v.timesPlayed,
						v.featured,
						vm.title,
						vm.description,
						CONCAT("videos/video/",v.ID) as address
					FROM bn_videos v
					LEFT JOIN bn_videos_meta vm
					ON vm.VideoID = v.ID
					WHERE v.enabled = 1
					AND v.publishDate <= NOW()
					AND vm.language_id = 1
					ORDER BY v.timesPlayed DESC, v.publishDate DESC
					LIMIT 270,6