0.01: SELECT opt,value
FROM videodb_config
0.04: 1,616,704 (1mb max)
0.04: 1,617,648 (1mb max)
0.04: 1,618,608 (1mb max)
0.04: 1,619,552 (1mb max)
0.04: 1,620,488 (1mb max)
0.04: 1,621,432 (1mb max)
0.04: 1,622,376 (1mb max)
0.04: 1,623,336 (1mb max)
0.04: 1,624,344 (1mb max)
0.04: 1,625,288 (1mb max)
0.04: 1,626,232 (1mb max)
0.04: 1,627,176 (1mb max)
0.04: 1,628,120 (1mb max)
0.04: 1,629,072 (1mb max)
0.04: 1,630,016 (1mb max)
0.04: 1,630,960 (1mb max)
0.04: 1,632,032 (1mb max)
0.04: 1,632,968 (1mb max)
0.04: 1,633,912 (1mb max)
0.04: 1,634,856 (1mb max)
0.04: 1,635,792 (1mb max)
0.04: 1,636,728 (1mb max)
0.04: 1,637,672 (1mb max)
0.04: 1,638,616 (1mb max)
0.04: 1,639,560 (1mb max)
0.04: 1,640,512 (1mb max)
0.04: 1,641,464 (1mb max)
0.04: 1,642,416 (1mb max)
0.04: 1,643,368 (1mb max)
0.04: 1,644,312 (1mb max)
0.04: 1,645,256 (1mb max)
0.04: 1,646,200 (1mb max)
0.04: 1,647,400 (1mb max)
0.04: 1,648,344 (1mb max)
0.04: 1,649,288 (1mb max)
0.04: 1,650,232 (1mb max)
0.04: 1,651,184 (1mb max)
0.04: 1,652,120 (1mb max)
0.04: 1,653,064 (1mb max)
0.04: 1,654,000 (1mb max)
0.04: 1,654,944 (1mb max)
0.04: 1,655,888 (1mb max)
0.04: 1,656,832 (1mb max)
0.04: 1,657,776 (1mb max)
0.04: 1,658,720 (1mb max)
0.04: 1,659,664 (1mb max)
0.04: 1,660,608 (1mb max)
0.04: 1,661,552 (1mb max)
0.04: 1,662,496 (1mb max)
0.04: 1,663,440 (1mb max)
0.04: 1,664,392 (1mb max)
0.04: 1,665,336 (1mb max)
0.04: 1,666,280 (1mb max)
0.04: 1,667,224 (1mb max)
0.04: 1,668,160 (1mb max)
0.04: 1,669,112 (1mb max)
0.04: 1,670,056 (1mb max)
0.04: 1,671,000 (1mb max)
0.04: 1,671,944 (1mb max)
0.04: 1,672,888 (1mb max)
0.04: 1,673,832 (1mb max)
0.04: 1,674,776 (1mb max)
0.04: 1,675,728 (1mb max)
0.04: 1,676,688 (1mb max)
0.04: 1,678,168 (1mb max)
0.05: SELECT name
FROM videodb_users
WHERE id=10000
0.05: 2,797,984 (2mb max)
0.05: SELECT name
FROM videodb_users
WHERE id=10000
0.05: 2,819,848 (2mb max)
0.05: SELECT permissions FROM videodb_users WHERE id=10000
0.05: 2,821,568 (2mb max)
0.05: SELECT * FROM videodb_permissions WHERE from_uid=10000
0.05: 2,823,736 (2mb max)
0.05: SELECT videodb_videodata.id, videodb_videodata.diskid,
title, subtitle, language, year,
director, LEFT(plot, 200) AS plot, imgurl,
owner_id, videodb_users.name AS owner, videodb_lent.who,
md5, disklabel, imdbID, runtime,
country, filename, filesize, filedate, audio_codec,
video_codec, video_width, video_height, istv,
lastupdate, mediatype,
custom1, custom2, custom3, custom4,
created, !ISNULL(videodb_userseen.video_id) AS seen
FROM videodb_videodata
LEFT JOIN videodb_users ON videodb_videodata.owner_id = videodb_users.id
LEFT JOIN videodb_userseen ON videodb_videodata.id = videodb_userseen.video_id AND videodb_userseen.user_id = 10000
LEFT JOIN videodb_lent ON videodb_videodata.diskid = videodb_lent.diskid
LEFT JOIN videodb_permissions ON videodb_videodata.owner_id = videodb_permissions.to_uid
WHERE mediatype != 50 AND videodb_permissions.from_uid = 10000 AND videodb_permissions.permissions & 2 != 0 AND videodb_users.name = 'Guest'
ORDER BY title, subtitle
LIMIT 100
9.39: 2,831,568 (2mb max)
9.39: 2,840,640 (2mb max)
9.39: 2,849,712 (2mb max)
9.39: 2,858,824 (2mb max)
9.39: 2,867,896 (2mb max)
9.39: 2,877,552 (2mb max)
9.39: 2,886,624 (2mb max)
9.39: 2,896,056 (2mb max)
9.39: 2,905,696 (2mb max)
9.39: 2,914,768 (2mb max)
9.39: 2,923,840 (2mb max)
9.39: 2,933,136 (2mb max)
9.39: 2,942,376 (2mb max)
9.39: 2,951,448 (2mb max)
9.39: 2,960,520 (2mb max)
9.39: 2,970,080 (2mb max)
9.39: 2,979,560 (2mb max)
9.39: 2,988,976 (2mb max)
9.39: 2,998,440 (2mb max)
9.39: 3,007,688 (2mb max)
9.39: 3,017,136 (2mb max)
9.39: 3,026,552 (2mb max)
9.39: 3,035,768 (2mb max)
9.39: 3,044,992 (2mb max)
9.39: 3,054,544 (2mb max)
9.39: 3,063,904 (2mb max)
9.39: 3,072,976 (2mb max)
9.39: 3,082,048 (2mb max)
9.39: 3,091,464 (2mb max)
9.39: 3,100,928 (3mb max)
9.39: 3,110,336 (3mb max)
9.39: 3,119,568 (3mb max)
9.39: 3,129,080 (3mb max)
9.39: 3,138,320 (3mb max)
9.39: 3,147,544 (3mb max)
9.39: 3,156,904 (3mb max)
9.39: 3,165,976 (3mb max)
9.39: 3,175,048 (3mb max)
9.39: 3,184,296 (3mb max)
9.39: 3,193,544 (3mb max)
9.39: 3,202,936 (3mb max)
9.39: 3,212,552 (3mb max)
9.39: 3,221,800 (3mb max)
9.39: 3,231,248 (3mb max)
9.39: 3,240,664 (3mb max)
9.39: 3,250,088 (3mb max)
9.39: 3,259,512 (3mb max)
9.39: 3,268,936 (3mb max)
9.39: 3,278,328 (3mb max)
9.39: 3,287,744 (3mb max)
9.39: 3,297,168 (3mb max)
9.39: 3,306,592 (3mb max)
9.39: 3,316,008 (3mb max)
9.39: 3,325,440 (3mb max)
9.39: 3,334,792 (3mb max)
9.39: 3,344,216 (3mb max)
9.39: 3,353,640 (3mb max)
9.39: 3,363,040 (3mb max)
9.39: 3,372,432 (3mb max)
9.39: 3,381,816 (3mb max)
9.39: 3,391,224 (3mb max)
9.39: 3,400,656 (3mb max)
9.39: 3,410,056 (3mb max)
9.39: 3,419,464 (3mb max)
9.39: 3,429,392 (3mb max)
9.39: 3,438,824 (3mb max)
9.39: 3,448,264 (3mb max)
9.39: 3,457,672 (3mb max)
9.39: 3,467,032 (3mb max)
9.39: 3,476,440 (3mb max)
9.39: 3,485,888 (3mb max)
9.39: 3,495,296 (3mb max)
9.39: 3,504,704 (3mb max)
9.39: 3,514,112 (3mb max)
9.39: 3,523,536 (3mb max)
9.39: 3,532,944 (3mb max)
9.39: 3,542,360 (3mb max)
9.39: 3,551,768 (3mb max)
9.39: 3,561,192 (3mb max)
9.39: 3,570,608 (3mb max)
9.39: 3,580,040 (3mb max)
9.39: 3,589,432 (3mb max)
9.39: 3,598,848 (3mb max)
9.39: 3,608,272 (3mb max)
9.39: 3,617,680 (3mb max)
9.39: 3,627,136 (3mb max)
9.39: 3,636,536 (3mb max)
9.39: 3,645,976 (3mb max)
9.39: 3,655,376 (3mb max)
9.39: 3,664,792 (3mb max)
9.39: 3,674,200 (3mb max)
9.39: 3,683,624 (3mb max)
9.39: 3,693,040 (3mb max)
9.39: 3,702,448 (3mb max)
9.39: 3,711,840 (3mb max)
9.39: 3,721,256 (3mb max)
9.39: 3,730,672 (3mb max)
9.39: 3,740,088 (3mb max)
9.39: 3,749,512 (3mb max)
9.39: 3,758,904 (3mb max)
9.40: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1942427
AND (genre_id=20)
9.44: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1942428
AND (genre_id=20)
9.49: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1942429
AND (genre_id=20)
9.50: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1942430
AND (genre_id=20)
9.55: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1945046
AND (genre_id=20)
9.61: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1945047
AND (genre_id=20)
9.66: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1942432
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1935894
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1719481
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1945073
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1945074
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944862
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944847
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944886
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944887
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1935765
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1718408
AND (genre_id=20)
9.72: 4,459,184 (4mb max)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1717247
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1717193
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944848
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1716589
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1943330
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944849
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944846
AND (genre_id=20)
9.72: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1716054
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1716028
AND (genre_id=20)
9.73: 4,460,272 (4mb max)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1945059
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1945061
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1945062
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1945063
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944828
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944867
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944870
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944869
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944868
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1715597
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944930
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1945058
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944864
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944865
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944866
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1715228
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1944850
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1715189
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1715186
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1715164
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1715153
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1715124
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1715070
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1715063
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1715064
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1715065
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1715032
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1715017
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714994
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714991
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714941
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714897
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714883
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714882
AND (genre_id=20)
9.73: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714860
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714811
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714768
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714747
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714744
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714743
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714742
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714727
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714701
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714670
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714657
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714639
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714622
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714597
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714596
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714595
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714585
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714583
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714582
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714580
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714546
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714507
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714501
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714482
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714462
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714455
AND (genre_id=20)
9.74: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714438
AND (genre_id=20)
9.75: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714435
AND (genre_id=20)
9.75: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714434
AND (genre_id=20)
9.75: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714421
AND (genre_id=20)
9.75: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714378
AND (genre_id=20)
9.75: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714363
AND (genre_id=20)
9.75: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714334
AND (genre_id=20)
9.75: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714293
AND (genre_id=20)
9.75: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714272
AND (genre_id=20)
9.75: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714253
AND (genre_id=20)
9.75: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714230
AND (genre_id=20)
9.75: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714211
AND (genre_id=20)
9.75: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714167
AND (genre_id=20)
9.76: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1714145
AND (genre_id=20)
9.76: SELECT DISTINCT(B.name) AS name, B.id
FROM videodb_permissions A, videodb_users B
WHERE A.to_uid = B.id
AND A.from_uid = 10000
AND (A.permissions & 2) = 2
ORDER BY name
9.76: 4,454,592 (4mb max)
9.76: SELECT id, name
FROM videodb_mediatypes
ORDER BY name
9.76: 4,456,664 (4mb max)
9.76: 4,457,600 (4mb max)
9.76: 4,458,536 (4mb max)
9.76: 4,459,472 (4mb max)
9.76: 4,460,408 (4mb max)
9.76: 4,461,344 (4mb max)
9.76: 4,462,280 (4mb max)
9.76: 4,463,216 (4mb max)
9.76: 4,464,216 (4mb max)
9.76: 4,465,152 (4mb max)
9.76: 4,466,088 (4mb max)
9.76: 4,467,024 (4mb max)
9.76: 4,467,960 (4mb max)
9.76: 4,468,904 (4mb max)
9.76: 4,469,840 (4mb max)
9.76: 4,470,776 (4mb max)
9.76: 4,471,840 (4mb max)
9.76: 4,472,776 (4mb max)
VideoDB