RateMyButt.com

1 SELECT * FROM content WHERE display = 'meta description' AND site_id = '14'
Took 0.000102996826172 seconds

2 SELECT * FROM content WHERE display = 'meta keywords' AND site_id = '14'
Took 4.50611114502E-5 seconds

3 SELECT * FROM banner_ads WHERE location = 'header' AND published = 1 AND gender = '' AND (NOW() BETWEEN start AND expires OR start = expires) AND site_id = '14' ORDER BY RAND() LIMIT 1
Took 0.00289392471313 seconds

4 INSERT INTO online VALUES ('1283926927', '38.107.191.118', '/index.php')
Took 0.000174999237061 seconds

5 DELETE FROM online WHERE timestamp<1283926627
Took 0.000186920166016 seconds

6 SELECT COUNT(DISTINCT ip) AS 'num' FROM online WHERE file='/index.php'
Took 0.000268936157227 seconds

7 SELECT *, SUM(numRatings) AS 'num', ROUND(AVG(average), 2) AS 'average', CONCAT('<a href=\'', 'http://www.ratemybutt.com/', username, '\'><img src=\'http://www.ratemybutt.com/new_images/thumbnails/', filename, '\' /></a>') as 'picture' FROM users LEFT JOIN averages ON users.user_id = averages.user_id LEFT JOIN images ON users.user_id = images.user_id WHERE gender = 'F' AND averages.site_id = 14 AND images.site_id = 14 AND images.image_type='MAIN' AND images.published = 1 AND images.allowRate = 1 GROUP BY users.user_id HAVING num >= 10 ORDER BY average DESC LIMIT 0, 20
Took 8.01086425781E-5 seconds

8 SELECT * FROM banner_ads WHERE location = 'right_366_top' AND published = 1 AND gender = 'F' AND (NOW() BETWEEN start AND expires OR start = expires) AND site_id = '14' ORDER BY RAND() LIMIT 1
Took 0.00185394287109 seconds

9 SELECT * FROM banner_ads WHERE location = 'right_366_bottom' AND published = 1 AND gender = '' AND (NOW() BETWEEN start AND expires OR start = expires) AND site_id = '14' ORDER BY RAND() LIMIT 1
Took 0.00165820121765 seconds

All queries took 0.00726509094238 seconds