SELECT count(*) as c from user(0.000246047973633 seconds)
EXPLAIN
SELECT count(distinct(city_id)) as c from user(0.000325918197632 seconds)
EXPLAIN
SELECT count(*) as c from user WHERE has_couch > 0(0.000236034393311 seconds)
EXPLAIN
SELECT count(*) as c from user_connection uc, user_connection_detail ucd
WHERE ucd.connection_id=uc.id
AND ucd.connection_date > NOW() - INTERVAL 1 DAY(0.000318050384521 seconds)
EXPLAIN
select count(*) as c FROM user WHERE signup_date > NOW()-INTERVAL 1 DAY(0.000258207321167 seconds)
EXPLAIN
select distinct user_login.user_id from user_login LEFT JOIN user_privacy ON
(user_privacy.user_id=user_login.user_id and privacy_group=3 and setting=1 and setting_value=0)
WHERE login+600 > NOW() AND user_privacy.user_id IS NULL(0.000338792800903 seconds)
EXPLAIN
SELECT user.id FROM user LEFT JOIN user_privacy
ON (user.id=user_privacy.user_id AND privacy_group=3
AND setting=1 AND setting_value=0)
WHERE user_privacy.id IS NULL
ORDER BY id DESC LIMIT 0,5(0.000894069671631 seconds)
EXPLAIN
select user.*, user_detail.* , user_login_summary.login as last_login
FROM user left join user_detail on user.id=user_detail.user_id LEFT JOIN user_login_summary on user.id=user_login_summary.id
WHERE user.id=50;(0.000446081161499 seconds)
EXPLAIN
select user.*, user_detail.* , user_login_summary.login as last_login
FROM user left join user_detail on user.id=user_detail.user_id LEFT JOIN user_login_summary on user.id=user_login_summary.id
WHERE user.id=50;(0.000360012054443 seconds)
EXPLAIN
SELECT IFNULL(fq_name, name) as name FROM city WHERE city.id=17(0.000243902206421 seconds)
EXPLAIN
select user.*, user_detail.* , user_login_summary.login as last_login
FROM user left join user_detail on user.id=user_detail.user_id LEFT JOIN user_login_summary on user.id=user_login_summary.id
WHERE user.id=47;(0.000751972198486 seconds)
EXPLAIN
select user.*, user_detail.* , user_login_summary.login as last_login
FROM user left join user_detail on user.id=user_detail.user_id LEFT JOIN user_login_summary on user.id=user_login_summary.id
WHERE user.id=47;(0.000660181045532 seconds)
EXPLAIN
SELECT IFNULL(fq_name, name) as name FROM city WHERE city.id=16(0.000231981277466 seconds)
EXPLAIN
select user.*, user_detail.* , user_login_summary.login as last_login
FROM user left join user_detail on user.id=user_detail.user_id LEFT JOIN user_login_summary on user.id=user_login_summary.id
WHERE user.id=34;(0.000439882278442 seconds)
EXPLAIN
select user.*, user_detail.* , user_login_summary.login as last_login
FROM user left join user_detail on user.id=user_detail.user_id LEFT JOIN user_login_summary on user.id=user_login_summary.id
WHERE user.id=34;(0.000357866287231 seconds)
EXPLAIN
SELECT IFNULL(fq_name, name) as name FROM city WHERE city.id=13(0.000221967697144 seconds)
EXPLAIN
select user.*, user_detail.* , user_login_summary.login as last_login
FROM user left join user_detail on user.id=user_detail.user_id LEFT JOIN user_login_summary on user.id=user_login_summary.id
WHERE user.id=32;(0.000442028045654 seconds)
EXPLAIN
select user.*, user_detail.* , user_login_summary.login as last_login
FROM user left join user_detail on user.id=user_detail.user_id LEFT JOIN user_login_summary on user.id=user_login_summary.id
WHERE user.id=32;(0.000369071960449 seconds)
EXPLAIN
SELECT IFNULL(fq_name, name) as name FROM city WHERE city.id=12(0.000225067138672 seconds)
EXPLAIN
select user.*, user_detail.* , user_login_summary.login as last_login
FROM user left join user_detail on user.id=user_detail.user_id LEFT JOIN user_login_summary on user.id=user_login_summary.id
WHERE user.id=31;(0.000404834747314 seconds)
EXPLAIN
select user.*, user_detail.* , user_login_summary.login as last_login
FROM user left join user_detail on user.id=user_detail.user_id LEFT JOIN user_login_summary on user.id=user_login_summary.id
WHERE user.id=31;(0.000365972518921 seconds)
EXPLAIN
Edit