RateMyButt.com

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

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

4 INSERT INTO online VALUES ('1280524943', '38.107.191.115', '/index.php')
Took 0.000156879425049 seconds

5 DELETE FROM online WHERE timestamp<1280524643
Took 0.000272035598755 seconds

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

7 SELECT users.user_id, username, SUM(numRatings) AS 'num', ROUND(AVG(average), 2) AS 'average' 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.published = 1 AND images.allowRate = 1 AND images.image_type = 'MAIN' GROUP BY users.user_id HAVING num >= 10 ORDER BY average DESC LIMIT 10
Took 7.00950622559E-5 seconds

8 SELECT users.user_id, username, SUM(numRatings) AS 'num', ROUND(AVG(average), 2) AS 'average' 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.published = 1 AND images.allowRate = 1 AND images.image_type = 'MAIN' GROUP BY users.user_id HAVING num >= 10 ORDER BY average DESC LIMIT 10
Took 6.48498535156E-5 seconds

9 SELECT *, DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(CONCAT(dob_year, '-', dob_month, '-', dob_day))), '%Y')+0 AS 'age' FROM users INNER JOIN user_details ON users.user_id = user_details.user_id INNER JOIN images ON users.user_id = images.user_id WHERE (gender = 'F' ) AND images.site_id = 14 AND (published = 1 AND public = 1 AND allowRate = 1) GROUP BY users.user_id ORDER BY RAND() LIMIT 20
Took 0.0143268108368 seconds

10 SELECT *, DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(CONCAT(dob_year, '-', dob_month, '-', dob_day))), '%Y')+0 AS 'age' FROM users INNER JOIN user_details ON users.user_id = user_details.user_id INNER JOIN images ON users.user_id = images.user_id WHERE (gender = 'M' ) AND images.site_id = 14 AND (published = 1 AND public = 1 AND allowRate = 1) GROUP BY users.user_id ORDER BY RAND() LIMIT 20
Took 0.0130040645599 seconds

11 SELECT * FROM news ORDER BY news_id DESC;
Took 7.79628753662E-5 seconds

12 SELECT * FROM banner_ads WHERE location = 'footer' 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.00226402282715 seconds

13 SELECT * FROM videos WHERE location = 'homepage' AND published = 1 AND site_id = '14' ORDER BY RAND() LIMIT 1
Took 0.00168800354004 seconds

14 SELECT * FROM banner_ads WHERE location = 'right' 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.00177383422852 seconds

All queries took 0.037609577179 seconds