Slow Queries:
112 SELECT name, photo.user_id, photo_id, user_name FR
Full Query:SELECT name, photo.user_id, photo_id, user_name FROM photo_newest_1000_cam AS photo INNER JOIN user_registry_active USING (user_id) WHERE is_hidden IS NULL AND photo.approved_by IS NOT NULL GROUP BY user_id ORDER BY cam_images DESC, photo_id DESC LIMIT 13
took 4.0012 seconds.
±—±------------±--------------±-------±--------------------±--------±--------±--------------±-------±---------------------------------------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |±—±------------±--------------±-------±--------------------±--------±--------±--------------±-------±---------------------------------------------+| 1 | PRIMARY | | ALL | NULL | NULL | NULL | NULL | 1000 | Using where; Using temporary; Using filesort | | 1 | PRIMARY | user_registry | eq_ref | PRIMARY,last_online | PRIMARY | 3 | photo.user_id | 1 | Using where | | 2 | DERIVED | photo | ALL | NULL | NULL | NULL | NULL | 604631 | Using where | ±—±------------±--------------±-------±--------------------±--------±--------±--------------±-------±---------------------------------------------+
106 SELECT user_name, user_id, avatar, age, (IF(NULLIF
Full Query:SELECT user_name, user_id, avatar, age, (IF(NULLIF(postal_code,“”) IS NULL, country_name,CONCAT(city_name, ", ", state_name))) AS location, marital_status, sexuality, (avg_vote_received*hits_this_month) AS popularity FROM user_registry WHERE is_online IS NOT NULL AND avatar IS NOT NULL AND is_moderator IS NULL ORDER BY popularity DESC LIMIT 1
±—±------------±--------------±------±--------------±-------±--------±-----±-------±----------------------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |±—±------------±--------------±------±--------------±-------±--------±-----±-------±----------------------------+| 1 | SIMPLE | user_registry | range | avatar | avatar | 303 | NULL | 202501 | Using where; Using filesort | ±—±------------±--------------±------±--------------±-------±--------±-----±-------±----------------------------+
64 SELECT country_abbreviation, country_name, region,
Full Query:SELECT country_abbreviation, country_name, region, city, isp, latitude, longitude FROM ip2location_disk WHERE ip_first <= 1286851759 AND ip_last >= 1286851759
took 3.136 seconds.
±—±------------±-----------------±------±--------------±--------±--------±-----±--------±------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |±—±------------±-----------------±------±--------------±--------±--------±-----±--------±------------+| 1 | SIMPLE | ip2location_disk | range | PRIMARY | PRIMARY | 4 | NULL | 1445944 | Using where | ±—±------------±-----------------±------±--------------±--------±--------±-----±--------±------------+
23 SELECT latitude, longitude FROM ip2location_simple
Full Query:SELECT latitude, longitude FROM ip2location_simple WHERE ip_first <= 1286851759 AND ip_last >= 1286851759
took 3.3463 seconds.
±—±------------±-------------------±------±--------------±--------±--------±-----±-------±------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |±—±------------±-------------------±------±--------------±--------±--------±-----±-------±------------+| 1 | SIMPLE | ip2location_simple | range | PRIMARY | PRIMARY | 4 | NULL | 986330 | Using where | ±—±------------±-------------------±------±--------------±--------±--------±-----±-------±------------+
12 SELECT ur.user_id, user_name, IFNULL(is_online,0)
Full Query:SELECT ur.user_id, user_name, IFNULL(is_online,0) AS is_online, status_id, IFNULL(moderator_power.show_moderator_status,0) AS moderator_flag, blue_names FROM user_registry AS ur LEFT JOIN moderator_power ON ur.user_id = moderator_power.user_id WHERE is_moderator IS NOT NULL ORDER BY user_name ASC
±—±------------±----------------±-------±--------------±----------±--------±----------------------±-------±------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |±—±------------±----------------±-------±--------------±----------±--------±----------------------±-------±------------+| 1 | SIMPLE | ur | index | NULL | user_name | 62 | NULL | 405004 | Using where | | 1 | SIMPLE | moderator_power | eq_ref | PRIMARY | PRIMARY | 3 | production.ur.user_id | 1 | | ±—±------------±----------------±-------±--------------±----------±--------±----------------------±-------±------------+
8 SELECT user_name, avatar, user_id AS author_id FRO
Full Query:SELECT user_name, avatar, user_id AS author_id FROM forum_recently_posted LIMIT 15
took 3.0349 seconds.
±—±------------±-----------±-------±---------------------------±---------------±--------±------------------------±-----±---------------------------------------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |±—±------------±-----------±-------±---------------------------±---------------±--------±------------------------±-----±---------------------------------------------+| 1 | PRIMARY | | ALL | NULL | NULL | NULL | NULL | 15 | | | 2 | DERIVED | ft | range | PRIMARY,last_post_time | last_post_time | 9 | NULL | 638 | Using where; Using temporary; Using filesort | | 2 | DERIVED | fp | ref | thread_id,author_id | thread_id | 3 | production.ft.thread_id | 15 | Using where | | 2 | DERIVED | u | eq_ref | PRIMARY,last_online,avatar | PRIMARY | 3 | production.fp.author_id | 1 | Using where | ±—±------------±-----------±-------±---------------------------±---------------±--------±------------------------±-----±---------------------------------------------+
7 SELECT SQL_CALC_FOUND_ROWS *, (0.46947156278589 *
Full Query:SELECT SQL_CALC_FOUND_ROWS *, (0.46947156278589 * SIN(latitude * 0.017453292519943) + 0.88294759285893 * COS(latitude * 0.017453292519943) * COS((longitude * 0.017453292519943) - -1.4311699866354)) AS dist
FROM user_registry
ORDER BY dist DESC
LIMIT 0,48
took 28.3571 seconds.
±—±------------±--------------±-----±--------------±-----±--------±-----±-------±---------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |±—±------------±--------------±-----±--------------±-----±--------±-----±-------±---------------+| 1 | SIMPLE | user_registry | ALL | NULL | NULL | NULL | NULL | 405004 | Using filesort | ±—±------------±--------------±-----±--------------±-----±--------±-----±-------±---------------+
4 SELECT SQL_CALC_FOUND_ROWS m.message_id, m.sender_
Full Query:SELECT SQL_CALC_FOUND_ROWS m.message_id, m.sender_id, m.recipient_id, m.created_datetime, m.modified_datetime, m.is_private, m.is_read, m.is_system_message, m.is_moderator_note, m.is_mass_message, m.is_sender_hidden, m.is_receiver_hidden, m.body, m.location, m.section, m.content_id, IFNULL(u.user_name,“Spooky Ghost”) AS user_name, IFNULL(u.age,0) AS age, IFNULL(u.gender,0) AS gender, u.status_id, u.avatar, IFNULL(u.color_scheme,“grey”) AS color_scheme, u.is_online ,(SELECT sub.user_name FROM user_registry AS sub WHERE sub.user_id=m.sender_id) AS sender_name, (SELECT sub.avatar FROM user_registry AS sub WHERE sub.user_id=m.sender_id) AS sender_avatar, (SELECT sub.is_online FROM user_registry AS sub WHERE sub.user_id=m.sender_id) AS sender_is_online, (SELECT sub.color_scheme FROM user_registry AS sub WHERE sub.user_id=m.sender_id) AS sender_color_scheme FROM message AS m LEFT JOIN user_registry AS u ON recipient_id=u.user_id WHERE (m.recipient_id=226091 OR (m.sender_id=226091 AND is_system_message IS NULL AND is_mass_message IS NULL)) AND ((m.is_receiver_hidden IS NULL AND m.is_sender_hidden IS NULL AND m.is_private IS NULL) OR ((m.sender_id=226091 AND m.is_sender_hidden IS NULL) OR (m.recipient_id=226091 AND m.is_receiver_hidden IS NULL)))AND (u.user_name LIKE “%fcukiingFABULOUS%” OR m.body LIKE “%fcukiingFABULOUS%”) ORDER BY m.message_id DESC LIMIT 0, 30
took 3.8387 seconds.
±—±-------------------±------±------------±-----------------------±-----------------------±--------±--------------------------±------±-----------------------------------------------------------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |±—±-------------------±------±------------±-----------------------±-----------------------±--------±--------------------------±------±-----------------------------------------------------------------+| 1 | PRIMARY | m | index_merge | sender_id,recipient_id | recipient_id,sender_id | 3,3 | NULL | 25604 | Using union(recipient_id,sender_id); Using where; Using filesort | | 1 | PRIMARY | u | eq_ref | PRIMARY | PRIMARY | 3 | production.m.recipient_id | 1 | Using where | | 5 | DEPENDENT SUBQUERY | sub | eq_ref | PRIMARY | PRIMARY | 3 | production.m.sender_id | 1 | | | 4 | DEPENDENT SUBQUERY | sub | eq_ref | PRIMARY | PRIMARY | 3 | production.m.sender_id | 1 | | | 3 | DEPENDENT SUBQUERY | sub | eq_ref | PRIMARY | PRIMARY | 3 | production.m.sender_id | 1 | | | 2 | DEPENDENT SUBQUERY | sub | eq_ref | PRIMARY | PRIMARY | 3 | production.m.sender_id | 1 | | ±—±-------------------±------±------------±-----------------------±-----------------------±--------±--------------------------±------±-----------------------------------------------------------------+
3 SELECT SQL_CALC_FOUND_ROWS thread_id, created_date
Full Query:SELECT SQL_CALC_FOUND_ROWS thread_id, created_datetime, topic_id, forum, title, body_preview, IF((is_confession IS NOT NULL OR is_anonymous IS NOT NULL),0,author_id) AS author_id, IF((is_confession IS NOT NULL OR is_anonymous IS NOT NULL),“Anonymous”,author_name) AS author_name, is_sticky, forum_sticky, is_locked, is_hidden, is_author_moderated, is_nsfw, is_age_verified, is_18_and_over, is_18_and_under, is_21_and_under, is_21_and_over, is_moderator_only, is_registered_only, is_girls_only, is_boys_only, is_teens_only, is_premium_only, is_noobs_only, is_has_photo, is_saluted_only, is_unmoderated, is_seductive_only, is_working, is_ninjas_only, is_lovers_only, is_haters_only, is_article, is_feature, is_news, is_feed, is_popular, is_anonymous, is_confession, thread_type, IF(((is_confession IS NOT NULL AND posts=1) OR is_anonymous IS NOT NULL),0,last_author_id) AS last_author_id, IF(((is_confession IS NOT NULL AND posts=1) OR is_anonymous IS NOT NULL),“Anonymous”,last_author_name) AS last_author_name, last_post_time, posts, hits FROM forum_thread WHERE forum=2 AND topic_id <> 58 AND is_nsfw IS NULL AND is_hidden IS NULL AND is_age_verified IS NULL AND is_18_and_over IS NULL AND is_21_and_over IS NULL AND is_moderator_only IS NULL AND is_registered_only IS NULL AND is_girls_only IS NULL AND is_boys_only IS NULL AND is_teens_only IS NULL AND is_premium_only IS NULL AND is_unmoderated IS NULL AND is_has_photo IS NULL AND is_saluted_only IS NULL AND is_seductive_only IS NULL AND is_lovers_only IS NULL AND is_haters_only IS NULL ORDER BY last_post_time DESC LIMIT 0,10
took 5.9257 seconds.
±—±------------±-------------±------±--------------±---------------±--------±-----±------±------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |±—±------------±-------------±------±--------------±---------------±--------±-----±------±------------+| 1 | SIMPLE | forum_thread | index | NULL | last_post_time | 9 | NULL | 61431 | Using where | ±—±------------±-------------±------±--------------±---------------±--------±-----±------±------------+
2 SELECT p.user_id FROM photo AS p INNER JOIN user_r
Full Query:SELECT p.user_id FROM photo AS p INNER JOIN user_registry AS ur USING(user_id) WHERE p.approved_by IS NULL AND is_hidden IS NULL AND 1 AND in_sync=1 ORDER BY p.created_datetime ASC LIMIT 50
took 6.2772 seconds.
±—±------------±------±-------±--------------±-----------------±--------±---------------------±-------±------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |±—±------------±------±-------±--------------±-----------------±--------±---------------------±-------±------------+| 1 | SIMPLE | p | index | user_id | created_datetime | 8 | NULL | 604631 | Using where | | 1 | SIMPLE | ur | eq_ref | PRIMARY | PRIMARY | 3 | production.p.user_id | 1 | Using index | ±—±------------±------±-------±--------------±-----------------±--------±---------------------±-------±------------+
2 SELECT t.thread_id, t.forum, t.title, t.body_previ
Full Query:SELECT t.thread_id, t.forum, t.title, t.body_preview, t.posts FROM forum_thread t INNER JOIN forum_post p USING(thread_id) WHERE t.is_confession=1 AND t.is_locked IS NULL AND t.is_moderator_only IS NULL AND t.is_hidden IS NULL group by p.thread_id HAVING count(p.post_id) > 1 ORDER BY rand() LIMIT 10
took 9.6543 seconds.
±—±------------±------±-----±--------------±----------±--------±-----------------------±------±---------------------------------------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |±—±------------±------±-----±--------------±----------±--------±-----------------------±------±---------------------------------------------+| 1 | SIMPLE | t | ALL | PRIMARY | NULL | NULL | NULL | 61431 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | p | ref | thread_id | thread_id | 3 | production.t.thread_id | 15 | Using index | ±—±------------±------±-----±--------------±----------±--------±-----------------------±------±---------------------------------------------+
1 SELECT SQL_CALC_FOUND_ROWS *, (0.62844868715656 *
Full Query:SELECT SQL_CALC_FOUND_ROWS *, (0.62844868715656 * SIN(latitude * 0.017453292519943) + 0.77785104461664 * COS(latitude * 0.017453292519943) * COS((longitude * 0.017453292519943) - -1.3449407208502)) AS dist
FROM user_registry
ORDER BY dist DESC
LIMIT 0,48
took 23.515 seconds.
±—±------------±--------------±-----±--------------±-----±--------±-----±-------±---------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |±—±------------±--------------±-----±--------------±-----±--------±-----±-------±---------------+| 1 | SIMPLE | user_registry | ALL | NULL | NULL | NULL | NULL | 405004 | Using filesort | ±—±------------±--------------±-----±--------------±-----±--------±-----±-------±---------------+