MovieLib - Your movie database on web

Code:
SELECT id, title, date_added, hide FROM movies WHERE hide=0 ORDER BY date_added DESC LIMIT 10 - 0.00031805038452148

SELECT id, title, hide FROM movies WHERE hide=0 ORDER BY play_count DESC LIMIT 10 - 0.00022482872009277

SELECT id, title, last_played, hide FROM movies WHERE hide=0 ORDER BY last_played DESC LIMIT 10 - 0.00024819374084473

SELECT id, title, rating, hide FROM movies WHERE hide=0 ORDER BY rating DESC LIMIT 10 - 0.00025081634521484

SELECT DISTINCT actor.id, actor.actor FROM `actor`, `movies_actor` WHERE actor.id=movies_actor.actorid ORDER BY actor.actor - 0.085211992263794

SELECT DISTINCT genre.id, genre.genre FROM `genre`, `movies_genre` WHERE genre.id=movies_genre.genreid ORDER BY genre.genre - 0.00066089630126953

SELECT DISTINCT country.id, country.country FROM `country`, `movies_country` WHERE country.id=movies_country.countryid ORDER BY country.country - 0.00053119659423828

SELECT DISTINCT `year` FROM `movies` WHERE `hide` = 0 ORDER BY `year` - 0.0020380020141602

SELECT DISTINCT director.id, director.director FROM `director`, `movies_director` WHERE director.id=movies_director.directorid ORDER BY director.director - 0.0038180351257324

SELECT DISTINCT `set` FROM `movies` WHERE `hide` = 0 ORDER BY `set` - 0.0026721954345703

SELECT DISTINCT studio.id, studio.studio FROM `studio`, `movies_studio` WHERE studio.id=movies_studio.studioid ORDER BY studio.studio - 0.0020570755004883

SELECT play_count, hide FROM movies WHERE hide=0 - 0.0011999607086182

SELECT movies.id FROM movies WHERE movies.title LIKE "%%%" AND movies.id LIKE "%" AND movies.play_count >= 0 AND movies.hide=0 ORDER BY title ASC - 0.010112047195435

SELECT movies.* FROM movies WHERE movies.title LIKE "%%%" AND movies.id LIKE "%" AND movies.play_count >= 0 AND movies.hide=0 ORDER BY title ASC LIMIT 0, 50 - 0.00072193145751953

SELECT movies.date_added FROM movies ORDER BY movies.date_added DESC LIMIT 0, 1 - 0.00021696090698242

SELECT genre.id, genre.genre FROM genre, movies_genre WHERE movies_genre.id = "912" AND genre.id = movies_genre.genreid - 0.00041508674621582

SELECT actor.id, actor.actor FROM actor, movies_actor WHERE movies_actor.id = "912" AND actor.id = movies_actor.actorid ORDER BY movies_actor.order - 0.00039005279541016

SELECT country.id, country.country FROM country, movies_country WHERE movies_country.id = "912" AND country.id = movies_country.countryid - 0.00019311904907227

SELECT director.id, director.director FROM director, movies_director WHERE movies_director.id = "912" AND director.id = movies_director.directorid - 0.00018310546875

SELECT studio.id, studio.studio FROM studio, movies_studio WHERE movies_studio.id = "912" AND studio.id = movies_studio.studioid - 0.00024890899658203

SELECT * FROM `movies_stream` WHERE id = "912" - 0.00026202201843262