RateMyButt.com

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

2 SELECT * FROM content WHERE display = 'meta keywords' AND site_id = '14'
Took 6.50882720947E-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.00287914276123 seconds

4 INSERT INTO online VALUES ('1283925139', '38.107.191.117', '/index.php')
Took 0.0001540184021 seconds

5 DELETE FROM online WHERE timestamp<1283924839
Took 0.000274896621704 seconds

6 SELECT COUNT(DISTINCT ip) AS 'num' FROM online WHERE file='/index.php'
Took 0.000365972518921 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 = 'M' 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 0.0104310512543 seconds

8 SELECT * FROM banner_ads WHERE location = 'right_366_top' AND published = 1 AND gender = 'M' AND (NOW() BETWEEN start AND expires OR start = expires) AND site_id = '14' ORDER BY RAND() LIMIT 1
Took 0.00193691253662 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.00171208381653 seconds

All queries took 0.0179352760315 seconds