0.01: SELECT opt,value
FROM videodb_config
0.01: 1,597,168 (1mb max)
0.01: 1,598,112 (1mb max)
0.01: 1,599,072 (1mb max)
0.01: 1,600,016 (1mb max)
0.01: 1,600,952 (1mb max)
0.01: 1,601,896 (1mb max)
0.01: 1,602,840 (1mb max)
0.01: 1,603,800 (1mb max)
0.01: 1,604,808 (1mb max)
0.01: 1,605,752 (1mb max)
0.01: 1,606,696 (1mb max)
0.01: 1,607,640 (1mb max)
0.01: 1,608,584 (1mb max)
0.01: 1,609,536 (1mb max)
0.01: 1,610,480 (1mb max)
0.01: 1,611,424 (1mb max)
0.01: 1,612,496 (1mb max)
0.01: 1,613,432 (1mb max)
0.01: 1,614,376 (1mb max)
0.01: 1,615,320 (1mb max)
0.01: 1,616,256 (1mb max)
0.01: 1,617,200 (1mb max)
0.01: 1,618,144 (1mb max)
0.01: 1,619,088 (1mb max)
0.01: 1,620,032 (1mb max)
0.01: 1,620,984 (1mb max)
0.01: 1,621,936 (1mb max)
0.01: 1,622,888 (1mb max)
0.01: 1,623,840 (1mb max)
0.01: 1,624,784 (1mb max)
0.01: 1,625,728 (1mb max)
0.01: 1,626,672 (1mb max)
0.01: 1,627,872 (1mb max)
0.01: 1,628,816 (1mb max)
0.01: 1,629,760 (1mb max)
0.01: 1,630,704 (1mb max)
0.01: 1,631,656 (1mb max)
0.01: 1,632,592 (1mb max)
0.01: 1,633,536 (1mb max)
0.01: 1,634,472 (1mb max)
0.01: 1,635,416 (1mb max)
0.01: 1,636,360 (1mb max)
0.01: 1,637,304 (1mb max)
0.01: 1,638,248 (1mb max)
0.01: 1,639,192 (1mb max)
0.01: 1,640,136 (1mb max)
0.01: 1,641,080 (1mb max)
0.01: 1,642,024 (1mb max)
0.01: 1,642,968 (1mb max)
0.01: 1,643,912 (1mb max)
0.01: 1,644,864 (1mb max)
0.01: 1,645,808 (1mb max)
0.01: 1,646,752 (1mb max)
0.01: 1,647,696 (1mb max)
0.01: 1,648,632 (1mb max)
0.01: 1,649,584 (1mb max)
0.01: 1,650,528 (1mb max)
0.01: 1,651,472 (1mb max)
0.01: 1,652,416 (1mb max)
0.01: 1,653,360 (1mb max)
0.01: 1,654,304 (1mb max)
0.01: 1,655,248 (1mb max)
0.01: 1,656,200 (1mb max)
0.01: 1,657,160 (1mb max)
0.01: 1,658,640 (1mb max)
0.03: SELECT name
FROM videodb_users
WHERE id=10000
0.03: 2,778,448 (2mb max)
0.03: SELECT permissions FROM videodb_users WHERE id=10000
0.03: 2,867,040 (2mb max)
0.03: SELECT * FROM videodb_permissions WHERE from_uid=10000
0.03: 2,869,208 (2mb max)
0.03: SELECT name
FROM videodb_users
WHERE id=10000
0.03: 2,867,344 (2mb max)
0.03: SELECT id, REVERSE(RAND(NOW())) AS rnd
FROM videodb_videodata
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 owner_id = '10000'
ORDER BY rnd
LIMIT 1
4.83: 2,868,504 (2mb max)
4.83: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1757585
AND (genre_id=20)
4.83: SELECT video_id
FROM videodb_videogenre
WHERE video_id = 1757585
AND (genre_id=20)
4.83: SELECT owner_id
FROM videodb_videodata
WHERE id = 1757585
4.83: 2,870,808 (2mb max)
4.83: SELECT videodb_videodata.id, title, subtitle, language, diskid, comment,
disklabel, imdbID, year, imgurl, director, actors, runtime,
country, plot, filename, filesize, filedate, audio_codec,
video_codec, video_width, video_height, istv, lastupdate,
email, rating, custom1, custom2, custom3, custom4,
!ISNULL(videodb_userseen.video_id) AS seen,
videodb_users.name AS owner, videodb_mediatypes.name AS mediatype
FROM videodb_videodata
LEFT JOIN videodb_users ON 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_mediatypes ON mediatype = videodb_mediatypes.id
WHERE videodb_videodata.id = 1757585
4.83: 2,881,472 (2mb max)
4.83: SELECT id
FROM videodb_users
WHERE name='Guest'
4.83: 2,888,680 (2mb max)
4.83: SELECT who
FROM videodb_lent
WHERE diskid = '29020'
4.83: SELECT owner_id
FROM videodb_videodata
WHERE id = 1757585
4.83: 2,942,656 (2mb max)
4.83: SELECT owner_id
FROM videodb_videodata
WHERE id = 1757585
4.83: 2,942,928 (2mb max)
4.83: SELECT actorid, name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE actorid IN ('imdb:nm0062828','imdb:nm0498571','imdb:nm0054609','imdb:nm0335788','imdb:nm0928295','imdb:nm0666201','imdb:nm0382954','imdb:nm0747759','imdb:nm0938052','imdb:nm0789247','imdb:nm0221439','imdb:nm0003124','imdb:nm0096130','imdb:nm0179409','imdb:nm0215968','imdb:nm0249602','imdb:nm0279459','imdb:nm0294536','imdb:nm0396452','imdb:nm0488951','imdb:nm0550631','imdb:nm0562805','imdb:nm0571901','imdb:nm0604565','imdb:nm0605494','imdb:nm0733059','imdb:nm0747033','imdb:nm0794313','imdb:nm0914246','imdb:nm0926103')
4.84: 3,012,128 (2mb max)
4.84: 3,013,600 (2mb max)
4.84: 3,015,072 (2mb max)
4.84: 3,016,544 (2mb max)
4.84: 3,018,016 (2mb max)
4.84: 3,019,488 (2mb max)
4.84: 3,020,960 (2mb max)
4.84: 3,022,432 (2mb max)
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Warner Baxter'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Andrea Leeds'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Charley Grapewin'
4.84: 3,026,800 (2mb max)
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Henry Wilcoxon'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Elizabeth Patterson'
4.84: 3,027,384 (2mb max)
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Christian Rub'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Ian Wolfe'
4.84: 3,028,240 (2mb max)
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Reginald Sheffield'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Pedro de Cordoba'
4.84: 3,029,144 (2mb max)
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Eugene Borden'
4.84: 3,029,400 (2mb max)
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Jean Del Val'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Diane Fisher'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Arno Frey'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Jean Houghton'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Bobby Larson'
4.84: 3,031,488 (2mb max)
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Myra Marsh'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Eric Mayne'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Mira McKinney'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Clark Morgan'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Ruth Robinson'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Florence Shirley'
4.84: SELECT name, imgurl, UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(checked) AS cacheage
FROM videodb_actors WHERE name='Lloyd Whitlock'
4.85: SELECT genres.id, genres.name
FROM videodb_genres AS genres, videodb_videogenre AS videogenre
WHERE genres.id = videogenre.genre_id
AND videogenre.video_id = 1757585
4.85: 3,032,944 (2mb max)
4.85: 3,033,880 (2mb max)
VideoDB - Earthbound