SELECT count(*) as c from user(0.0298230648041 seconds)
EXPLAIN
SELECT count(distinct(city_id)) as c from user(0.0139439105988 seconds)
EXPLAIN
SELECT count(*) as c from user WHERE has_couch > 0(0.000689029693604 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.0722000598907 seconds)
EXPLAIN
select count(*) as c FROM user WHERE signup_date > NOW()-INTERVAL 1 DAY(0.000314950942993 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.00215411186218 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.00113892555237 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.00105786323547 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.000443935394287 seconds)
EXPLAIN
SELECT IFNULL(fq_name, name) as name FROM city WHERE city.id=17(0.00726699829102 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.000514030456543 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.000432014465332 seconds)
EXPLAIN
SELECT IFNULL(fq_name, name) as name FROM city WHERE city.id=16(0.000253200531006 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.000483989715576 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.000425815582275 seconds)
EXPLAIN
SELECT IFNULL(fq_name, name) as name FROM city WHERE city.id=13(0.000253200531006 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.00052809715271 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.00045108795166 seconds)
EXPLAIN
SELECT IFNULL(fq_name, name) as name FROM city WHERE city.id=12(0.000251054763794 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.000476121902466 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.000510931015015 seconds)
EXPLAIN
Edit