hasvanbinsun
Проверенные
- Сообщения
- 407
- Реакции
- 75
- Баллы
- 5,530
Всё работает, но иногда тормозит сервер mysql. В чем проблема?
/usr/sbin/mysqld, Version: 5.5.41-0ubuntu0.14.04.1-log ((Ubuntu)). started with: Tcp port: 0 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument # Time: 150311 20:28:11 # User@Host: root[root] @ localhost [] # Query_time: 0.000484 Lock_time: 0.000044 Rows_sent: 0 Rows_examined: 0 use forumsbd; SET timestamp=1426094891; SELECT * FROM xf_brivium_addon ORDER BY addon_id; # User@Host: root[root] @ localhost [] # Query_time: 0.002598 Lock_time: 0.000031 Rows_sent: 45 Rows_examined: 90 SET timestamp=1426094891; SELECT * FROM xf_node ORDER BY lft ASC; # User@Host: root[root] @ localhost [] # Query_time: 0.397061 Lock_time: 0.000055 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426094891; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423502890' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # Time: 150311 20:28:13 # User@Host: root[root] @ localhost [] # Query_time: 0.030729 Lock_time: 0.000049 Rows_sent: 744 Rows_examined: 8321 SET timestamp=1426094893; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '2189') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '2189') WHERE post.post_date > '1423502893' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000150 Lock_time: 0.000017 Rows_sent: 1 Rows_examined: 4 SET timestamp=1426094893; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:28:18 # User@Host: root[root] @ localhost [] # Query_time: 0.028748 Lock_time: 0.000074 Rows_sent: 0 Rows_examined: 9321 SET timestamp=1426094898; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14, 33)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '1') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '1') WHERE post.post_date > '1423502898' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000174 Lock_time: 0.000022 Rows_sent: 1 Rows_examined: 6 SET timestamp=1426094898; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:28:19 # User@Host: root[root] @ localhost [] # Query_time: 0.039468 Lock_time: 0.000055 Rows_sent: 20 Rows_examined: 836 SET timestamp=1426094899; SELECT profile_post.* , posting_user.*, IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username, receiving_user.username AS profile_username, receiving_user.gender AS profile_gender, receiving_user.user_state AS profile_user_state, receiving_user.user_group_id AS profile_user_group_id, receiving_user.secondary_group_ids AS profile_secondary_group_ids, receiving_user.display_style_group_id AS profile_display_style_group_id, receiving_user.is_banned AS profile_is_banned, receiving_user.is_admin AS profile_is_admin, receiving_user.is_moderator AS profile_is_moderator, receiving_user.avatar_date AS profile_avatar_date, receiving_user.gravatar AS profile_gravatar, receiving_user.warning_points AS profile_warning_points, receiving_user.permission_combination_id AS profile_permission_combination_id, receiving_user_privacy.allow_view_profile AS profile_allow_view_profile, receiving_user_privacy.allow_post_profile AS profile_allow_post_profile, receiving_user_privacy.allow_send_personal_conversation AS profile_allow_send_personal_conversation, receiving_user_privacy.allow_view_identities AS profile_allow_view_identities, receiving_user_privacy.allow_receive_news_feed AS profile_allow_allow_receive_news_feed, IF (receiving_user_follow.follow_user_id, 1, 0) AS following_1 FROM xf_profile_post AS profile_post LEFT JOIN xf_user AS posting_user ON (posting_user.user_id = profile_post.user_id) LEFT JOIN xf_user AS receiving_user ON (receiving_user.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_privacy AS receiving_user_privacy ON (receiving_user_privacy.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_follow AS receiving_user_follow ON (receiving_user_follow.user_id = profile_post.profile_user_id AND follow_user_id = 1) WHERE (profile_post.message_state IN ('visible')) ORDER BY profile_post.post_date DESC LIMIT 20; # User@Host: root[root] @ localhost [] # Query_time: 0.000846 Lock_time: 0.000030 Rows_sent: 44 Rows_examined: 89 SET timestamp=1426094899; SELECT * FROM xf_node WHERE display_in_list = 1 ORDER BY lft ASC; # User@Host: root[root] @ localhost [] # Query_time: 0.001190 Lock_time: 0.000033 Rows_sent: 38 Rows_examined: 114 SET timestamp=1426094899; SELECT forum.* , IF(forum_read.forum_read_date > 1423502899, forum_read.forum_read_date, 1423502899) AS forum_read_date FROM xf_forum AS forum INNER JOIN xf_node AS node ON (node.node_id = forum.node_id) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = forum.node_id AND forum_read.user_id = 1) WHERE forum.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14, 33); # User@Host: root[root] @ localhost [] # Query_time: 0.003317 Lock_time: 0.000018 Rows_sent: 10 Rows_examined: 820 SET timestamp=1426094899; SELECT thread_id, title, user_id, username, post_date, discussion_state FROM xf_thread as thread WHERE NOT ISNULL(thread.thread_id) AND thread.discussion_state = 'visible' ORDER BY post_date DESC LIMIT 10; # User@Host: root[root] @ localhost [] # Query_time: 0.037219 Lock_time: 0.000050 Rows_sent: 10 Rows_examined: 4924 SET timestamp=1426094899; SELECT thread.* , GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1423502899) AS thread_read_date, node.node_id AS forum_id, node.title AS forum_title, user.*, user_rue.display_style_group_id AS last_post_display_style_group_id FROM xf_thread AS thread LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = 1) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = 1) INNER JOIN xf_node AS node ON (node.node_id = thread.node_id) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id) LEFT JOIN xf_user AS user ON (user.user_id = thread.last_post_user_id) LEFT JOIN xf_user AS user_rue ON (user_rue.user_id = thread.last_post_user_id) WHERE (1=1) AND (thread.node_id IN ('1', '2', '15', '16', '20', '38', '39', '40', '35', '43', '37', '41', '52', '53', '54', '3', '7', '9', '32', '28', '44', '23', '51', '30', '45', '17', '49', '18', '19', '25', '26', '27', '31', '50', '21', '29', '34', '46', '47', '48', '12', '24', '13', '14')) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated')) ORDER BY thread.last_post_date DESC LIMIT 10; # Time: 150311 20:28:20 # User@Host: root[root] @ localhost [] # Query_time: 0.000126 Lock_time: 0.000017 Rows_sent: 1 Rows_examined: 6 SET timestamp=1426094900; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:28:23 # User@Host: root[root] @ localhost [] # Query_time: 0.000298 Lock_time: 0.000028 Rows_sent: 1 Rows_examined: 6 SET timestamp=1426094903; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:28:27 # User@Host: root[root] @ localhost [] # Query_time: 0.060235 Lock_time: 0.000064 Rows_sent: 1056 Rows_examined: 8108 SET timestamp=1426094907; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4865') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4865') WHERE post.post_date > '1423502907' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # Time: 150311 20:28:31 # User@Host: root[root] @ localhost [] # Query_time: 0.000984 Lock_time: 0.000037 Rows_sent: 38 Rows_examined: 114 SET timestamp=1426094911; SELECT forum.* , IF(forum_read.forum_read_date > 1423502911, forum_read.forum_read_date, 1423502911) AS forum_read_date FROM xf_forum AS forum INNER JOIN xf_node AS node ON (node.node_id = forum.node_id) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = forum.node_id AND forum_read.user_id = 1) WHERE forum.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14, 33); # Time: 150311 20:28:32 # User@Host: root[root] @ localhost [] # Query_time: 0.029230 Lock_time: 0.000071 Rows_sent: 10 Rows_examined: 4924 SET timestamp=1426094912; SELECT thread.* , GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1423502911) AS thread_read_date, node.node_id AS forum_id, node.title AS forum_title, user.*, user_rue.display_style_group_id AS last_post_display_style_group_id FROM xf_thread AS thread LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = 1) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = 1) INNER JOIN xf_node AS node ON (node.node_id = thread.node_id) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id) LEFT JOIN xf_user AS user ON (user.user_id = thread.last_post_user_id) LEFT JOIN xf_user AS user_rue ON (user_rue.user_id = thread.last_post_user_id) WHERE (1=1) AND (thread.node_id IN ('1', '2', '15', '16', '20', '38', '39', '40', '35', '43', '37', '41', '52', '53', '54', '3', '7', '9', '32', '28', '44', '23', '51', '30', '45', '17', '49', '18', '19', '25', '26', '27', '31', '50', '21', '29', '34', '46', '47', '48', '12', '24', '13', '14')) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated')) ORDER BY thread.last_post_date DESC LIMIT 10; # Time: 150311 20:28:35 # User@Host: root[root] @ localhost [] # Query_time: 0.000331 Lock_time: 0.000027 Rows_sent: 1 Rows_examined: 6 SET timestamp=1426094915; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:28:44 # User@Host: root[root] @ localhost [] # Query_time: 0.028959 Lock_time: 0.000078 Rows_sent: 1018 Rows_examined: 8272 SET timestamp=1426094924; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4') WHERE post.post_date > '1423502924' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000232 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426094924; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:28:52 # User@Host: root[root] @ localhost [] # Query_time: 0.049192 Lock_time: 0.000064 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426094932; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423502932' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000143 Lock_time: 0.000019 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426094932; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:28:53 # User@Host: root[root] @ localhost [] # Query_time: 0.000240 Lock_time: 0.000027 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426094933; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:28:54 # User@Host: root[root] @ localhost [] # Query_time: 0.000157 Lock_time: 0.000026 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426094934; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:29:31 # User@Host: root[root] @ localhost [] # Query_time: 0.000181 Lock_time: 0.000027 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426094971; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:29:35 # User@Host: root[root] @ localhost [] # Query_time: 0.019779 Lock_time: 0.000061 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426094975; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423502975' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000144 Lock_time: 0.000017 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426094975; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:29:36 # User@Host: root[root] @ localhost [] # Query_time: 0.018639 Lock_time: 0.000049 Rows_sent: 744 Rows_examined: 8321 SET timestamp=1426094976; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '2189') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '2189') WHERE post.post_date > '1423502976' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000129 Lock_time: 0.000017 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426094976; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:29:48 # User@Host: root[root] @ localhost [] # Query_time: 0.021300 Lock_time: 0.000070 Rows_sent: 1056 Rows_examined: 8108 SET timestamp=1426094988; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4865') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4865') WHERE post.post_date > '1423502988' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # Time: 150311 20:30:00 # User@Host: root[root] @ localhost [] # Query_time: 0.021151 Lock_time: 0.000059 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095000; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503000' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000189 Lock_time: 0.000022 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095000; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:30:17 # User@Host: root[root] @ localhost [] # Query_time: 0.000165 Lock_time: 0.000026 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095017; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:30:19 # User@Host: root[root] @ localhost [] # Query_time: 0.034896 Lock_time: 0.000084 Rows_sent: 1018 Rows_examined: 8272 SET timestamp=1426095019; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4') WHERE post.post_date > '1423503019' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000261 Lock_time: 0.000029 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095019; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:30:32 # User@Host: root[root] @ localhost [] # Query_time: 0.018096 Lock_time: 0.000075 Rows_sent: 0 Rows_examined: 9321 SET timestamp=1426095032; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14, 33)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '1') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '1') WHERE post.post_date > '1423503032' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.001096 Lock_time: 0.000044 Rows_sent: 38 Rows_examined: 114 SET timestamp=1426095032; SELECT forum.* , IF(forum_read.forum_read_date > 1423503032, forum_read.forum_read_date, 1423503032) AS forum_read_date FROM xf_forum AS forum INNER JOIN xf_node AS node ON (node.node_id = forum.node_id) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = forum.node_id AND forum_read.user_id = 1) WHERE forum.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14, 33); # User@Host: root[root] @ localhost [] # Query_time: 0.020643 Lock_time: 0.000066 Rows_sent: 10 Rows_examined: 4924 SET timestamp=1426095032; SELECT thread.* , GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1423503032) AS thread_read_date, node.node_id AS forum_id, node.title AS forum_title, user.*, user_rue.display_style_group_id AS last_post_display_style_group_id FROM xf_thread AS thread LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = 1) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = 1) INNER JOIN xf_node AS node ON (node.node_id = thread.node_id) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id) LEFT JOIN xf_user AS user ON (user.user_id = thread.last_post_user_id) LEFT JOIN xf_user AS user_rue ON (user_rue.user_id = thread.last_post_user_id) WHERE (1=1) AND (thread.node_id IN ('1', '2', '15', '16', '20', '38', '39', '40', '35', '43', '37', '41', '52', '53', '54', '3', '7', '9', '32', '28', '44', '23', '51', '30', '45', '17', '49', '18', '19', '25', '26', '27', '31', '50', '21', '29', '34', '46', '47', '48', '12', '24', '13', '14')) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated')) ORDER BY thread.last_post_date DESC LIMIT 10; # Time: 150311 20:30:39 # User@Host: root[root] @ localhost [] # Query_time: 0.041454 Lock_time: 0.000086 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095039; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503039' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000201 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095039; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:30:44 # User@Host: root[root] @ localhost [] # Query_time: 0.000179 Lock_time: 0.000021 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095044; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:30:47 # User@Host: root[root] @ localhost [] # Query_time: 0.002600 Lock_time: 0.000088 Rows_sent: 0 Rows_examined: 12 SET timestamp=1426095047; UPDATE xf_thread INNER JOIN ( SELECT thread_id, COUNT(*) AS total FROM xf_thread_view GROUP BY thread_id ) AS xf_tv ON (xf_tv.thread_id = xf_thread.thread_id) SET xf_thread.view_count = xf_thread.view_count + xf_tv.total; # User@Host: root[root] @ localhost [] # Query_time: 0.000477 Lock_time: 0.000039 Rows_sent: 0 Rows_examined: 17 SET timestamp=1426095047; UPDATE xf_attachment INNER JOIN ( SELECT attachment_id, COUNT(*) AS total FROM xf_attachment_view GROUP BY attachment_id ) AS xf_av ON (xf_av.attachment_id = xf_attachment.attachment_id) SET xf_attachment.view_count = xf_attachment.view_count + xf_av.total; # User@Host: root[root] @ localhost [] # Query_time: 0.000140 Lock_time: 0.000016 Rows_sent: 0 Rows_examined: 5 SET timestamp=1426095047; delete from dark_taigachat_activity where date < UNIX_TIMESTAMP()-30*60; # User@Host: root[root] @ localhost [] # Query_time: 0.000605 Lock_time: 0.000024 Rows_sent: 1 Rows_examined: 20 SET timestamp=1426095047; SELECT MIN(entry.next_run) FROM xf_cron_entry AS entry LEFT JOIN xf_addon AS addon ON (entry.addon_id = addon.addon_id) WHERE entry.active = 1 AND (addon.addon_id IS NULL OR addon.active = 1); # Time: 150311 20:30:59 # User@Host: root[root] @ localhost [] # Query_time: 0.025159 Lock_time: 0.000062 Rows_sent: 744 Rows_examined: 8321 SET timestamp=1426095059; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '2189') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '2189') WHERE post.post_date > '1423503059' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000695 Lock_time: 0.000017 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095059; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:31:04 # User@Host: root[root] @ localhost [] # Query_time: 0.000195 Lock_time: 0.000018 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095064; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:31:32 # User@Host: root[root] @ localhost [] # Query_time: 0.019458 Lock_time: 0.000060 Rows_sent: 0 Rows_examined: 9321 SET timestamp=1426095092; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14, 33)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '1') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '1') WHERE post.post_date > '1423503092' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000172 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095092; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:31:40 # User@Host: root[root] @ localhost [] # Query_time: 0.026138 Lock_time: 0.000051 Rows_sent: 1056 Rows_examined: 8108 SET timestamp=1426095100; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4865') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4865') WHERE post.post_date > '1423503100' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.029342 Lock_time: 0.000066 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095100; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503100' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000112 Lock_time: 0.000016 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095100; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:31:41 # User@Host: root[root] @ localhost [] # Query_time: 0.000111 Lock_time: 0.000018 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095101; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:31:49 # User@Host: root[root] @ localhost [] # Query_time: 0.027744 Lock_time: 0.000068 Rows_sent: 1018 Rows_examined: 8272 SET timestamp=1426095109; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4') WHERE post.post_date > '1423503109' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000192 Lock_time: 0.000021 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095109; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:32:00 # User@Host: root[root] @ localhost [] # Query_time: 0.000204 Lock_time: 0.000022 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095120; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # User@Host: root[root] @ localhost [] # Query_time: 0.000235 Lock_time: 0.000031 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095120; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:32:02 # User@Host: root[root] @ localhost [] # Query_time: 0.001877 Lock_time: 0.000061 Rows_sent: 20 Rows_examined: 835 SET timestamp=1426095122; SELECT profile_post.* , posting_user.*, IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username, receiving_user.username AS profile_username, receiving_user.gender AS profile_gender, receiving_user.user_state AS profile_user_state, receiving_user.user_group_id AS profile_user_group_id, receiving_user.secondary_group_ids AS profile_secondary_group_ids, receiving_user.display_style_group_id AS profile_display_style_group_id, receiving_user.is_banned AS profile_is_banned, receiving_user.is_admin AS profile_is_admin, receiving_user.is_moderator AS profile_is_moderator, receiving_user.avatar_date AS profile_avatar_date, receiving_user.gravatar AS profile_gravatar, receiving_user.warning_points AS profile_warning_points, receiving_user.permission_combination_id AS profile_permission_combination_id, receiving_user_privacy.allow_view_profile AS profile_allow_view_profile, receiving_user_privacy.allow_post_profile AS profile_allow_post_profile, receiving_user_privacy.allow_send_personal_conversation AS profile_allow_send_personal_conversation, receiving_user_privacy.allow_view_identities AS profile_allow_view_identities, receiving_user_privacy.allow_receive_news_feed AS profile_allow_allow_receive_news_feed, IF (receiving_user_follow.follow_user_id, 1, 0) AS following_3735 FROM xf_profile_post AS profile_post LEFT JOIN xf_user AS posting_user ON (posting_user.user_id = profile_post.user_id) LEFT JOIN xf_user AS receiving_user ON (receiving_user.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_privacy AS receiving_user_privacy ON (receiving_user_privacy.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_follow AS receiving_user_follow ON (receiving_user_follow.user_id = profile_post.profile_user_id AND follow_user_id = 3735) WHERE (profile_post.message_state IN ('visible')) ORDER BY profile_post.post_date DESC LIMIT 20; # User@Host: root[root] @ localhost [] # Query_time: 0.000997 Lock_time: 0.000039 Rows_sent: 36 Rows_examined: 109 SET timestamp=1426095122; SELECT forum.* , IF(forum_read.forum_read_date > 1423503122, forum_read.forum_read_date, 1423503122) AS forum_read_date FROM xf_forum AS forum INNER JOIN xf_node AS node ON (node.node_id = forum.node_id) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = forum.node_id AND forum_read.user_id = 3735) WHERE forum.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14); # User@Host: root[root] @ localhost [] # Query_time: 0.001381 Lock_time: 0.000027 Rows_sent: 10 Rows_examined: 820 SET timestamp=1426095122; SELECT thread_id, title, user_id, username, post_date, discussion_state FROM xf_thread as thread WHERE NOT ISNULL(thread.thread_id) AND thread.discussion_state = 'visible' ORDER BY post_date DESC LIMIT 10; # User@Host: root[root] @ localhost [] # Query_time: 0.017635 Lock_time: 0.000053 Rows_sent: 10 Rows_examined: 4737 SET timestamp=1426095122; SELECT thread.* , GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1423503122) AS thread_read_date, node.node_id AS forum_id, node.title AS forum_title, user.*, user_rue.display_style_group_id AS last_post_display_style_group_id FROM xf_thread AS thread LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = 3735) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = 3735) INNER JOIN xf_node AS node ON (node.node_id = thread.node_id) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id) LEFT JOIN xf_user AS user ON (user.user_id = thread.last_post_user_id) LEFT JOIN xf_user AS user_rue ON (user_rue.user_id = thread.last_post_user_id) WHERE (1=1) AND (thread.node_id IN ('1', '2', '15', '16', '20', '38', '39', '40', '35', '43', '37', '41', '52', '53', '54', '3', '7', '9', '32', '28', '44', '23', '51', '45', '17', '49', '18', '19', '25', '26', '27', '31', '50', '21', '29', '34', '46', '47', '48', '12', '24', '13', '14')) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated')) ORDER BY thread.last_post_date DESC LIMIT 10; # Time: 150311 20:32:04 # User@Host: root[root] @ localhost [] # Query_time: 0.025787 Lock_time: 0.000084 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095124; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503124' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000155 Lock_time: 0.000023 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095124; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:32:10 # User@Host: root[root] @ localhost [] # Query_time: 0.000291 Lock_time: 0.000064 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095130; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:32:16 # User@Host: root[root] @ localhost [] # Query_time: 0.000237 Lock_time: 0.000028 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095136; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:32:22 # User@Host: root[root] @ localhost [] # Query_time: 0.020713 Lock_time: 0.000053 Rows_sent: 744 Rows_examined: 8321 SET timestamp=1426095142; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '2189') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '2189') WHERE post.post_date > '1423503142' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000198 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095142; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:32:28 # User@Host: root[root] @ localhost [] # Query_time: 0.000140 Lock_time: 0.000027 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095148; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:32:46 # User@Host: root[root] @ localhost [] # Query_time: 0.000219 Lock_time: 0.000021 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095166; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:33:00 # User@Host: root[root] @ localhost [] # Query_time: 0.018896 Lock_time: 0.000053 Rows_sent: 0 Rows_examined: 9321 SET timestamp=1426095180; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14, 33)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '1') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '1') WHERE post.post_date > '1423503180' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000601 Lock_time: 0.000026 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095180; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:33:03 # User@Host: root[root] @ localhost [] # Query_time: 0.000232 Lock_time: 0.000028 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095183; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:33:08 # User@Host: root[root] @ localhost [] # Query_time: 0.019039 Lock_time: 0.000052 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095188; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503188' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000147 Lock_time: 0.000025 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095188; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:33:11 # User@Host: root[root] @ localhost [] # Query_time: 0.028346 Lock_time: 0.000056 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095191; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503191' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000213 Lock_time: 0.000025 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095191; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:33:21 # User@Host: root[root] @ localhost [] # Query_time: 0.000864 Lock_time: 0.000037 Rows_sent: 38 Rows_examined: 76 SET timestamp=1426095201; SELECT forum.* , NULL AS forum_read_date FROM xf_forum AS forum INNER JOIN xf_node AS node ON (node.node_id = forum.node_id) WHERE forum.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14, 33); # User@Host: root[root] @ localhost [] # Query_time: 0.003834 Lock_time: 0.000060 Rows_sent: 1 Rows_examined: 5546 SET timestamp=1426095201; SELECT COUNT(*) FROM xf_user WHERE user_state = 'valid' AND is_banned = 0; # User@Host: root[root] @ localhost [] # Query_time: 0.000217 Lock_time: 0.000025 Rows_sent: 1 Rows_examined: 20 SET timestamp=1426095201; SELECT MIN(entry.next_run) FROM xf_cron_entry AS entry LEFT JOIN xf_addon AS addon ON (entry.addon_id = addon.addon_id) WHERE entry.active = 1 AND (addon.addon_id IS NULL OR addon.active = 1); # Time: 150311 20:33:44 # User@Host: root[root] @ localhost [] # Query_time: 0.000157 Lock_time: 0.000019 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095224; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:33:45 # User@Host: root[root] @ localhost [] # Query_time: 0.038686 Lock_time: 0.000074 Rows_sent: 744 Rows_examined: 8321 SET timestamp=1426095225; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '2189') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '2189') WHERE post.post_date > '1423503225' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000209 Lock_time: 0.000027 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095225; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:33:48 # User@Host: root[root] @ localhost [] # Query_time: 0.000240 Lock_time: 0.000028 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095228; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:33:51 # User@Host: root[root] @ localhost [] # Query_time: 0.039367 Lock_time: 0.000078 Rows_sent: 1018 Rows_examined: 8272 SET timestamp=1426095231; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4') WHERE post.post_date > '1423503231' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000157 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095231; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:33:53 # User@Host: root[root] @ localhost [] # Query_time: 0.025854 Lock_time: 0.000081 Rows_sent: 1056 Rows_examined: 8108 SET timestamp=1426095233; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4865') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4865') WHERE post.post_date > '1423503233' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # Time: 150311 20:34:08 # User@Host: root[root] @ localhost [] # Query_time: 0.000301 Lock_time: 0.000036 Rows_sent: 0 Rows_examined: 4 SET timestamp=1426095248; SELECT user_field.* FROM xf_user_field AS user_field WHERE (user_field.required = 1 OR user_field.show_registration = 1) ORDER BY user_field.display_group, user_field.display_order; # User@Host: root[root] @ localhost [] # Query_time: 0.001033 Lock_time: 0.000021 Rows_sent: 5 Rows_examined: 15 SET timestamp=1426095248; SELECT * FROM xf_captcha_question WHERE active = 1 ORDER BY RAND(); # Time: 150311 20:34:11 # User@Host: root[root] @ localhost [] # Query_time: 0.045704 Lock_time: 0.000084 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095251; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503251' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000231 Lock_time: 0.000028 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095251; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:34:26 # User@Host: root[root] @ localhost [] # Query_time: 0.023520 Lock_time: 0.000070 Rows_sent: 0 Rows_examined: 9321 SET timestamp=1426095266; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14, 33)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '1') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '1') WHERE post.post_date > '1423503266' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000533 Lock_time: 0.000015 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095266; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:34:27 # User@Host: root[root] @ localhost [] # Query_time: 0.000171 Lock_time: 0.000021 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095267; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:34:30 # User@Host: root[root] @ localhost [] # Query_time: 0.017420 Lock_time: 0.000061 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095270; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503270' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000137 Lock_time: 0.000016 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095270; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:34:56 # User@Host: root[root] @ localhost [] # Query_time: 0.017011 Lock_time: 0.000050 Rows_sent: 1056 Rows_examined: 8108 SET timestamp=1426095296; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4865') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4865') WHERE post.post_date > '1423503296' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # Time: 150311 20:34:57 # User@Host: root[root] @ localhost [] # Query_time: 0.034431 Lock_time: 0.000077 Rows_sent: 1018 Rows_examined: 8272 SET timestamp=1426095297; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4') WHERE post.post_date > '1423503297' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000243 Lock_time: 0.000027 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095297; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:35:15 # User@Host: root[root] @ localhost [] # Query_time: 0.000112 Lock_time: 0.000016 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095315; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:35:16 # User@Host: root[root] @ localhost [] # Query_time: 0.032805 Lock_time: 0.000090 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095316; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503316' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000227 Lock_time: 0.000026 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095316; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:35:32 # User@Host: root[root] @ localhost [] # Query_time: 0.037770 Lock_time: 0.000078 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095332; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503332' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000132 Lock_time: 0.000016 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095332; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:35:56 # User@Host: root[root] @ localhost [] # Query_time: 0.032379 Lock_time: 0.000054 Rows_sent: 1056 Rows_examined: 8108 SET timestamp=1426095356; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4865') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4865') WHERE post.post_date > '1423503356' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000456 Lock_time: 0.000058 Rows_sent: 4 Rows_examined: 8 SET timestamp=1426095356; SELECT user_field.* , field_value.field_value FROM xf_user_field AS user_field LEFT JOIN xf_user_field_value AS field_value ON (field_value.field_id = user_field.field_id AND field_value.user_id = 4363) WHERE (user_field.display_group <> 'preferences' AND user_field.viewable_profile = 1) ORDER BY user_field.display_group, user_field.display_order; # Time: 150311 20:36:02 # User@Host: root[root] @ localhost [] # Query_time: 0.024537 Lock_time: 0.000061 Rows_sent: 1018 Rows_examined: 8272 SET timestamp=1426095362; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4') WHERE post.post_date > '1423503362' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000161 Lock_time: 0.000019 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095362; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:36:15 # User@Host: root[root] @ localhost [] # Query_time: 0.000249 Lock_time: 0.000044 Rows_sent: 0 Rows_examined: 0 SET timestamp=1426095375; SELECT promotion.* FROM xf_user_group_promotion AS promotion WHERE (promotion.active = 1) ORDER BY promotion.title; # User@Host: root[root] @ localhost [] # Query_time: 0.022858 Lock_time: 0.000057 Rows_sent: 1246 Rows_examined: 8097 SET timestamp=1426095375; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4505') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4505') WHERE post.post_date > '1423503375' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # Time: 150311 20:36:18 # User@Host: root[root] @ localhost [] # Query_time: 0.000040 Lock_time: 0.000014 Rows_sent: 0 Rows_examined: 5 SET timestamp=1426095378; delete from dark_taigachat_activity where date < UNIX_TIMESTAMP()-30*60; # User@Host: root[root] @ localhost [] # Query_time: 0.000186 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 20 SET timestamp=1426095378; SELECT MIN(entry.next_run) FROM xf_cron_entry AS entry LEFT JOIN xf_addon AS addon ON (entry.addon_id = addon.addon_id) WHERE entry.active = 1 AND (addon.addon_id IS NULL OR addon.active = 1); # Time: 150311 20:36:20 # User@Host: root[root] @ localhost [] # Query_time: 0.024360 Lock_time: 0.000066 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095380; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503380' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000178 Lock_time: 0.000030 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095380; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:36:34 # User@Host: root[root] @ localhost [] # Query_time: 0.020858 Lock_time: 0.000050 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095394; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503394' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000132 Lock_time: 0.000016 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095394; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:37:08 # User@Host: root[root] @ localhost [] # Query_time: 0.032414 Lock_time: 0.000056 Rows_sent: 1018 Rows_examined: 8272 SET timestamp=1426095428; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4') WHERE post.post_date > '1423503428' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000186 Lock_time: 0.000023 Rows_sent: 1 Rows_examined: 9 SET timestamp=1426095428; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:37:23 # User@Host: root[root] @ localhost [] # Query_time: 0.020747 Lock_time: 0.000059 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095443; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503443' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000324 Lock_time: 0.000028 Rows_sent: 1 Rows_examined: 9 SET timestamp=1426095443; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:37:36 # User@Host: root[root] @ localhost [] # Query_time: 0.032101 Lock_time: 0.000062 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095456; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503456' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000210 Lock_time: 0.000026 Rows_sent: 1 Rows_examined: 9 SET timestamp=1426095456; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:38:20 # User@Host: root[root] @ localhost [] # Query_time: 0.022920 Lock_time: 0.000064 Rows_sent: 1018 Rows_examined: 8272 SET timestamp=1426095500; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4') WHERE post.post_date > '1423503500' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000192 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095500; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:38:23 # User@Host: root[root] @ localhost [] # Query_time: 0.000108 Lock_time: 0.000017 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095503; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:38:26 # User@Host: root[root] @ localhost [] # Query_time: 0.000917 Lock_time: 0.000038 Rows_sent: 36 Rows_examined: 109 SET timestamp=1426095506; SELECT forum.* , IF(forum_read.forum_read_date > 1423503506, forum_read.forum_read_date, 1423503506) AS forum_read_date FROM xf_forum AS forum INNER JOIN xf_node AS node ON (node.node_id = forum.node_id) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = forum.node_id AND forum_read.user_id = 3735) WHERE forum.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14); # User@Host: root[root] @ localhost [] # Query_time: 0.016448 Lock_time: 0.000052 Rows_sent: 10 Rows_examined: 4737 SET timestamp=1426095506; SELECT thread.* , GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1423503506) AS thread_read_date, node.node_id AS forum_id, node.title AS forum_title, user.*, user_rue.display_style_group_id AS last_post_display_style_group_id FROM xf_thread AS thread LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = 3735) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = 3735) INNER JOIN xf_node AS node ON (node.node_id = thread.node_id) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id) LEFT JOIN xf_user AS user ON (user.user_id = thread.last_post_user_id) LEFT JOIN xf_user AS user_rue ON (user_rue.user_id = thread.last_post_user_id) WHERE (1=1) AND (thread.node_id IN ('1', '2', '15', '16', '20', '38', '39', '40', '35', '43', '37', '41', '52', '53', '54', '3', '7', '9', '32', '28', '44', '23', '51', '45', '17', '49', '18', '19', '25', '26', '27', '31', '50', '21', '29', '34', '46', '47', '48', '12', '24', '13', '14')) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated')) ORDER BY thread.last_post_date DESC LIMIT 10; # User@Host: root[root] @ localhost [] # Query_time: 0.019823 Lock_time: 0.000065 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095506; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503506' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000196 Lock_time: 0.000018 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095506; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:38:33 # User@Host: root[root] @ localhost [] # Query_time: 0.000260 Lock_time: 0.000028 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095513; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:38:52 # User@Host: root[root] @ localhost [] # Query_time: 0.023509 Lock_time: 0.000074 Rows_sent: 1056 Rows_examined: 8108 SET timestamp=1426095532; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4865') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4865') WHERE post.post_date > '1423503532' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # Time: 150311 20:39:16 # User@Host: root[root] @ localhost [] # Query_time: 0.025120 Lock_time: 0.000061 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095556; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503556' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000166 Lock_time: 0.000022 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095556; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:39:26 # User@Host: root[root] @ localhost [] # Query_time: 0.029122 Lock_time: 0.000061 Rows_sent: 1018 Rows_examined: 8272 SET timestamp=1426095566; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4') WHERE post.post_date > '1423503566' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000521 Lock_time: 0.000140 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095566; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:39:30 # User@Host: root[root] @ localhost [] # Query_time: 0.025786 Lock_time: 0.000067 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095570; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503570' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000137 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095570; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:39:55 # User@Host: root[root] @ localhost [] # Query_time: 0.019304 Lock_time: 0.000053 Rows_sent: 14 Rows_examined: 8858 SET timestamp=1426095595; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '624') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '624') WHERE post.post_date > '1423503595' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # Time: 150311 20:40:14 # User@Host: root[root] @ localhost [] # Query_time: 0.022863 Lock_time: 0.000083 Rows_sent: 1246 Rows_examined: 8097 SET timestamp=1426095614; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4505') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4505') WHERE post.post_date > '1423503614' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # Time: 150311 20:40:19 # User@Host: root[root] @ localhost [] # Query_time: 0.021115 Lock_time: 0.000083 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095619; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503619' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000117 Lock_time: 0.000018 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095619; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:40:32 # User@Host: root[root] @ localhost [] # Query_time: 0.021088 Lock_time: 0.000063 Rows_sent: 1018 Rows_examined: 8272 SET timestamp=1426095632; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4') WHERE post.post_date > '1423503632' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000143 Lock_time: 0.000018 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095632; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:40:37 # User@Host: root[root] @ localhost [] # Query_time: 0.019134 Lock_time: 0.000061 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095637; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503637' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000118 Lock_time: 0.000018 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095637; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:40:40 # User@Host: root[root] @ localhost [] # Query_time: 0.000043 Lock_time: 0.000016 Rows_sent: 0 Rows_examined: 5 SET timestamp=1426095640; delete from dark_taigachat_activity where date < UNIX_TIMESTAMP()-30*60; # User@Host: root[root] @ localhost [] # Query_time: 0.000175 Lock_time: 0.000029 Rows_sent: 9 Rows_examined: 18 SET timestamp=1426095640; SELECT * FROM xf_trophy ORDER BY trophy_points; # User@Host: root[root] @ localhost [] # Query_time: 0.000244 Lock_time: 0.000026 Rows_sent: 1 Rows_examined: 20 SET timestamp=1426095640; SELECT MIN(entry.next_run) FROM xf_cron_entry AS entry LEFT JOIN xf_addon AS addon ON (entry.addon_id = addon.addon_id) WHERE entry.active = 1 AND (addon.addon_id IS NULL OR addon.active = 1); # Time: 150311 20:41:24 # User@Host: root[root] @ localhost [] # Query_time: 0.018915 Lock_time: 0.000060 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095684; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503684' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000171 Lock_time: 0.000021 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095684; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:41:40 # User@Host: root[root] @ localhost [] # Query_time: 0.021863 Lock_time: 0.000072 Rows_sent: 1018 Rows_examined: 8272 SET timestamp=1426095700; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4') WHERE post.post_date > '1423503700' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000147 Lock_time: 0.000016 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095700; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:41:41 # User@Host: root[root] @ localhost [] # Query_time: 0.019748 Lock_time: 0.000063 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095701; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503701' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000161 Lock_time: 0.000019 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095701; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:41:43 # User@Host: root[root] @ localhost [] # Query_time: 0.020182 Lock_time: 0.000046 Rows_sent: 1056 Rows_examined: 8108 SET timestamp=1426095703; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4865') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4865') WHERE post.post_date > '1423503703' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.001380 Lock_time: 0.000053 Rows_sent: 20 Rows_examined: 835 SET timestamp=1426095703; SELECT profile_post.* , posting_user.*, IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username, receiving_user.username AS profile_username, receiving_user.gender AS profile_gender, receiving_user.user_state AS profile_user_state, receiving_user.user_group_id AS profile_user_group_id, receiving_user.secondary_group_ids AS profile_secondary_group_ids, receiving_user.display_style_group_id AS profile_display_style_group_id, receiving_user.is_banned AS profile_is_banned, receiving_user.is_admin AS profile_is_admin, receiving_user.is_moderator AS profile_is_moderator, receiving_user.avatar_date AS profile_avatar_date, receiving_user.gravatar AS profile_gravatar, receiving_user.warning_points AS profile_warning_points, receiving_user.permission_combination_id AS profile_permission_combination_id, receiving_user_privacy.allow_view_profile AS profile_allow_view_profile, receiving_user_privacy.allow_post_profile AS profile_allow_post_profile, receiving_user_privacy.allow_send_personal_conversation AS profile_allow_send_personal_conversation, receiving_user_privacy.allow_view_identities AS profile_allow_view_identities, receiving_user_privacy.allow_receive_news_feed AS profile_allow_allow_receive_news_feed, IF (receiving_user_follow.follow_user_id, 1, 0) AS following_4865 FROM xf_profile_post AS profile_post LEFT JOIN xf_user AS posting_user ON (posting_user.user_id = profile_post.user_id) LEFT JOIN xf_user AS receiving_user ON (receiving_user.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_privacy AS receiving_user_privacy ON (receiving_user_privacy.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_follow AS receiving_user_follow ON (receiving_user_follow.user_id = profile_post.profile_user_id AND follow_user_id = 4865) WHERE (profile_post.message_state IN ('visible')) ORDER BY profile_post.post_date DESC LIMIT 20; # Time: 150311 20:41:44 # User@Host: root[root] @ localhost [] # Query_time: 0.000655 Lock_time: 0.000037 Rows_sent: 36 Rows_examined: 77 SET timestamp=1426095704; SELECT forum.* , IF(forum_read.forum_read_date > 1423503703, forum_read.forum_read_date, 1423503703) AS forum_read_date FROM xf_forum AS forum INNER JOIN xf_node AS node ON (node.node_id = forum.node_id) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = forum.node_id AND forum_read.user_id = 4865) WHERE forum.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14); # User@Host: root[root] @ localhost [] # Query_time: 0.024838 Lock_time: 0.000062 Rows_sent: 10 Rows_examined: 3968 SET timestamp=1426095704; SELECT thread.* , GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1423503703) AS thread_read_date, node.node_id AS forum_id, node.title AS forum_title, user.*, user_rue.display_style_group_id AS last_post_display_style_group_id FROM xf_thread AS thread LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = 4865) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = 4865) INNER JOIN xf_node AS node ON (node.node_id = thread.node_id) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id) LEFT JOIN xf_user AS user ON (user.user_id = thread.last_post_user_id) LEFT JOIN xf_user AS user_rue ON (user_rue.user_id = thread.last_post_user_id) WHERE (1=1) AND (thread.node_id IN ('1', '2', '15', '16', '20', '38', '39', '40', '35', '43', '37', '41', '52', '53', '54', '3', '7', '9', '32', '28', '44', '23', '51', '45', '17', '49', '18', '19', '25', '26', '27', '31', '50', '21', '29', '34', '46', '47', '48', '12', '24', '13', '14')) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated')) ORDER BY thread.last_post_date DESC LIMIT 10; # Time: 150311 20:42:05 # User@Host: root[root] @ localhost [] # Query_time: 0.026388 Lock_time: 0.000053 Rows_sent: 1220 Rows_examined: 8095 SET timestamp=1426095725; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '2081') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '2081') WHERE post.post_date > '1423503725' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.009539 Lock_time: 0.000037 Rows_sent: 185 Rows_examined: 1550 SET timestamp=1426095725; SELECT thread.* , user.*, IF(user.username IS NULL, thread.username, user.username) AS username, node.title AS node_title, node.node_name, permission.cache_value AS node_permission_cache, user_rue.display_style_group_id AS last_post_display_style_group_id FROM xf_thread AS thread LEFT JOIN xf_user AS user ON (user.user_id = thread.user_id) LEFT JOIN xf_node AS node ON (node.node_id = thread.node_id) LEFT JOIN xf_permission_cache_content AS permission ON (permission.permission_combination_id = 2 AND permission.content_type = 'node' AND permission.content_id = thread.node_id) LEFT JOIN xf_user AS user_rue ON (user_rue.user_id = thread.last_post_user_id) WHERE thread.thread_id IN (815, 217, 593, 853, 451, 854, 289, 756, 25, 821, 757, 829, 845, 244, 675, 728, 849, 852, 850, 834, 798, 66, 844, 26, 817, 841, 843, 435, 10, 825, 353, 830, 525, 839, 532, 152, 241, 819, 807, 56, 64, 9, 284, 838, 836, 599, 804, 534, 613, 619, 835, 833, 305, 437, 727, 831, 252, 108, 493, 450, 803, 348, 797, 670, 180, 215, 827, 646, 824, 225, 826, 19, 28, 820, 813, 764, 811, 822, 483, 738, 816, 507, 814, 404, 812, 583, 810, 170, 600, 596, 809, 808, 233, 806, 112, 14, 6, 805, 674, 422, 508, 802, 792, 801, 788, 765, 385, 785, 127, 794, 523, 93, 423, 255, 799, 60, 795, 72, 662, 782, 791, 551, 793, 37, 715, 787, 786, 48, 784, 778, 373, 783, 137, 605, 780, 582, 769, 724, 779, 299, 777, 774, 99, 775, 703, 130, 770, 773, 772, 497, 771, 768, 767, 565, 759, 690, 734, 185, 763, 762, 761, 760, 321, 758, 447, 683, 394, 665, 754, 501, 749, 752, 755, 753, 751, 747, 201, 644, 573, 704, 736, 651, 705, 552, 199); # Time: 150311 20:42:09 # User@Host: root[root] @ localhost [] # Query_time: 0.000385 Lock_time: 0.000033 Rows_sent: 4 Rows_examined: 12 SET timestamp=1426095729; SELECT user_field.* , field_value.field_value FROM xf_user_field AS user_field LEFT JOIN xf_user_field_value AS field_value ON (field_value.field_id = user_field.field_id AND field_value.user_id = 2189) WHERE (user_field.display_group <> 'preferences' AND user_field.viewable_profile = 1) ORDER BY user_field.display_group, user_field.display_order; # Time: 150311 20:42:11 # User@Host: root[root] @ localhost [] # Query_time: 0.000166 Lock_time: 0.000018 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095731; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:42:16 # User@Host: root[root] @ localhost [] # Query_time: 0.001252 Lock_time: 0.000040 Rows_sent: 20 Rows_examined: 835 SET timestamp=1426095736; SELECT profile_post.* , posting_user.*, IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username, receiving_user.username AS profile_username, receiving_user.gender AS profile_gender, receiving_user.user_state AS profile_user_state, receiving_user.user_group_id AS profile_user_group_id, receiving_user.secondary_group_ids AS profile_secondary_group_ids, receiving_user.display_style_group_id AS profile_display_style_group_id, receiving_user.is_banned AS profile_is_banned, receiving_user.is_admin AS profile_is_admin, receiving_user.is_moderator AS profile_is_moderator, receiving_user.avatar_date AS profile_avatar_date, receiving_user.gravatar AS profile_gravatar, receiving_user.warning_points AS profile_warning_points, receiving_user.permission_combination_id AS profile_permission_combination_id, receiving_user_privacy.allow_view_profile AS profile_allow_view_profile, receiving_user_privacy.allow_post_profile AS profile_allow_post_profile, receiving_user_privacy.allow_send_personal_conversation AS profile_allow_send_personal_conversation, receiving_user_privacy.allow_view_identities AS profile_allow_view_identities, receiving_user_privacy.allow_receive_news_feed AS profile_allow_allow_receive_news_feed, IF (receiving_user_follow.follow_user_id, 1, 0) AS following_4 FROM xf_profile_post AS profile_post LEFT JOIN xf_user AS posting_user ON (posting_user.user_id = profile_post.user_id) LEFT JOIN xf_user AS receiving_user ON (receiving_user.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_privacy AS receiving_user_privacy ON (receiving_user_privacy.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_follow AS receiving_user_follow ON (receiving_user_follow.user_id = profile_post.profile_user_id AND follow_user_id = 4) WHERE (profile_post.message_state IN ('visible')) ORDER BY profile_post.post_date DESC LIMIT 20; # User@Host: root[root] @ localhost [] # Query_time: 0.000842 Lock_time: 0.000030 Rows_sent: 37 Rows_examined: 82 SET timestamp=1426095736; SELECT forum.* , IF(forum_read.forum_read_date > 1423503736, forum_read.forum_read_date, 1423503736) AS forum_read_date FROM xf_forum AS forum INNER JOIN xf_node AS node ON (node.node_id = forum.node_id) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = forum.node_id AND forum_read.user_id = 4) WHERE forum.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14); # User@Host: root[root] @ localhost [] # Query_time: 0.018309 Lock_time: 0.000066 Rows_sent: 10 Rows_examined: 4052 SET timestamp=1426095736; SELECT thread.* , GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1423503736) AS thread_read_date, node.node_id AS forum_id, node.title AS forum_title, user.*, user_rue.display_style_group_id AS last_post_display_style_group_id FROM xf_thread AS thread LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = 4) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = 4) INNER JOIN xf_node AS node ON (node.node_id = thread.node_id) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id) LEFT JOIN xf_user AS user ON (user.user_id = thread.last_post_user_id) LEFT JOIN xf_user AS user_rue ON (user_rue.user_id = thread.last_post_user_id) WHERE (1=1) AND (thread.node_id IN ('1', '2', '15', '16', '20', '38', '39', '40', '35', '43', '37', '41', '52', '53', '54', '3', '7', '9', '32', '28', '44', '23', '51', '30', '45', '17', '49', '18', '19', '25', '26', '27', '31', '50', '21', '29', '34', '46', '47', '48', '12', '24', '13', '14')) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated')) ORDER BY thread.last_post_date DESC LIMIT 10; # Time: 150311 20:42:27 # User@Host: root[root] @ localhost [] # Query_time: 0.020073 Lock_time: 0.000061 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095747; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503747' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000167 Lock_time: 0.000017 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095747; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:42:28 # User@Host: root[root] @ localhost [] # Query_time: 0.000233 Lock_time: 0.000027 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095748; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:42:44 # User@Host: root[root] @ localhost [] # Query_time: 0.038597 Lock_time: 0.000073 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095764; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503764' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000219 Lock_time: 0.000023 Rows_sent: 1 Rows_examined: 8 SET timestamp=1426095764; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:42:54 # User@Host: root[root] @ localhost [] # Query_time: 0.046901 Lock_time: 0.000061 Rows_sent: 12 Rows_examined: 9171 SET timestamp=1426095774; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '144') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '144') WHERE post.post_date > '1423503774' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.004768 Lock_time: 0.000084 Rows_sent: 20 Rows_examined: 836 SET timestamp=1426095774; SELECT profile_post.* , posting_user.*, IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username, receiving_user.username AS profile_username, receiving_user.gender AS profile_gender, receiving_user.user_state AS profile_user_state, receiving_user.user_group_id AS profile_user_group_id, receiving_user.secondary_group_ids AS profile_secondary_group_ids, receiving_user.display_style_group_id AS profile_display_style_group_id, receiving_user.is_banned AS profile_is_banned, receiving_user.is_admin AS profile_is_admin, receiving_user.is_moderator AS profile_is_moderator, receiving_user.avatar_date AS profile_avatar_date, receiving_user.gravatar AS profile_gravatar, receiving_user.warning_points AS profile_warning_points, receiving_user.permission_combination_id AS profile_permission_combination_id, receiving_user_privacy.allow_view_profile AS profile_allow_view_profile, receiving_user_privacy.allow_post_profile AS profile_allow_post_profile, receiving_user_privacy.allow_send_personal_conversation AS profile_allow_send_personal_conversation, receiving_user_privacy.allow_view_identities AS profile_allow_view_identities, receiving_user_privacy.allow_receive_news_feed AS profile_allow_allow_receive_news_feed, IF (receiving_user_follow.follow_user_id, 1, 0) AS following_144 FROM xf_profile_post AS profile_post LEFT JOIN xf_user AS posting_user ON (posting_user.user_id = profile_post.user_id) LEFT JOIN xf_user AS receiving_user ON (receiving_user.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_privacy AS receiving_user_privacy ON (receiving_user_privacy.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_follow AS receiving_user_follow ON (receiving_user_follow.user_id = profile_post.profile_user_id AND follow_user_id = 144) WHERE (profile_post.message_state IN ('visible')) ORDER BY profile_post.post_date DESC LIMIT 20; # User@Host: root[root] @ localhost [] # Query_time: 0.000762 Lock_time: 0.000032 Rows_sent: 37 Rows_examined: 112 SET timestamp=1426095774; SELECT forum.* , IF(forum_read.forum_read_date > 1423503774, forum_read.forum_read_date, 1423503774) AS forum_read_date FROM xf_forum AS forum INNER JOIN xf_node AS node ON (node.node_id = forum.node_id) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = forum.node_id AND forum_read.user_id = 144) WHERE forum.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14); # User@Host: root[root] @ localhost [] # Query_time: 0.024499 Lock_time: 0.000067 Rows_sent: 10 Rows_examined: 4951 SET timestamp=1426095774; SELECT thread.* , GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1423503774) AS thread_read_date, node.node_id AS forum_id, node.title AS forum_title, user.*, user_rue.display_style_group_id AS last_post_display_style_group_id FROM xf_thread AS thread LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = 144) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = 144) INNER JOIN xf_node AS node ON (node.node_id = thread.node_id) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id) LEFT JOIN xf_user AS user ON (user.user_id = thread.last_post_user_id) LEFT JOIN xf_user AS user_rue ON (user_rue.user_id = thread.last_post_user_id) WHERE (1=1) AND (thread.node_id IN ('1', '2', '15', '16', '20', '38', '39', '40', '35', '43', '37', '41', '52', '53', '54', '3', '7', '9', '32', '28', '44', '23', '51', '30', '45', '17', '49', '18', '19', '25', '26', '27', '31', '50', '21', '29', '34', '46', '47', '48', '12', '24', '13', '14')) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated')) ORDER BY thread.last_post_date DESC LIMIT 10; # Time: 150311 20:42:59 # User@Host: root[root] @ localhost [] # Query_time: 0.023990 Lock_time: 0.000055 Rows_sent: 1055 Rows_examined: 8108 SET timestamp=1426095779; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4865') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4865') WHERE post.post_date > '1423503779' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000164 Lock_time: 0.000023 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095779; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:43:00 # User@Host: root[root] @ localhost [] # Query_time: 0.000363 Lock_time: 0.000031 Rows_sent: 1 Rows_examined: 20 SET timestamp=1426095780; SELECT MIN(entry.next_run) FROM xf_cron_entry AS entry LEFT JOIN xf_addon AS addon ON (entry.addon_id = addon.addon_id) WHERE entry.active = 1 AND (addon.addon_id IS NULL OR addon.active = 1); # Time: 150311 20:43:16 # User@Host: root[root] @ localhost [] # Query_time: 0.019642 Lock_time: 0.000049 Rows_sent: 1018 Rows_examined: 8272 SET timestamp=1426095796; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4') WHERE post.post_date > '1423503796' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000170 Lock_time: 0.000019 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095796; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:43:31 # User@Host: root[root] @ localhost [] # Query_time: 0.017677 Lock_time: 0.000044 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095811; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503811' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000867 Lock_time: 0.000016 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095811; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:43:41 # User@Host: root[root] @ localhost [] # Query_time: 0.000139 Lock_time: 0.000018 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095821; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:43:47 # User@Host: root[root] @ localhost [] # Query_time: 0.019613 Lock_time: 0.000050 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095827; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503827' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000750 Lock_time: 0.000017 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095827; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # User@Host: root[root] @ localhost [] # Query_time: 0.004364 Lock_time: 0.000031 Rows_sent: 1 Rows_examined: 5546 SET timestamp=1426095827; SELECT COUNT(*) FROM xf_user WHERE user_state = 'valid' AND is_banned = 0; # User@Host: root[root] @ localhost [] # Query_time: 0.000256 Lock_time: 0.000025 Rows_sent: 1 Rows_examined: 20 SET timestamp=1426095827; SELECT MIN(entry.next_run) FROM xf_cron_entry AS entry LEFT JOIN xf_addon AS addon ON (entry.addon_id = addon.addon_id) WHERE entry.active = 1 AND (addon.addon_id IS NULL OR addon.active = 1); # Time: 150311 20:43:52 # User@Host: root[root] @ localhost [] # Query_time: 0.021231 Lock_time: 0.000053 Rows_sent: 1343 Rows_examined: 8082 SET timestamp=1426095832; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '1564') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '1564') WHERE post.post_date > '1423503832' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.001492 Lock_time: 0.000057 Rows_sent: 20 Rows_examined: 835 SET timestamp=1426095832; SELECT profile_post.* , posting_user.*, IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username, receiving_user.username AS profile_username, receiving_user.gender AS profile_gender, receiving_user.user_state AS profile_user_state, receiving_user.user_group_id AS profile_user_group_id, receiving_user.secondary_group_ids AS profile_secondary_group_ids, receiving_user.display_style_group_id AS profile_display_style_group_id, receiving_user.is_banned AS profile_is_banned, receiving_user.is_admin AS profile_is_admin, receiving_user.is_moderator AS profile_is_moderator, receiving_user.avatar_date AS profile_avatar_date, receiving_user.gravatar AS profile_gravatar, receiving_user.warning_points AS profile_warning_points, receiving_user.permission_combination_id AS profile_permission_combination_id, receiving_user_privacy.allow_view_profile AS profile_allow_view_profile, receiving_user_privacy.allow_post_profile AS profile_allow_post_profile, receiving_user_privacy.allow_send_personal_conversation AS profile_allow_send_personal_conversation, receiving_user_privacy.allow_view_identities AS profile_allow_view_identities, receiving_user_privacy.allow_receive_news_feed AS profile_allow_allow_receive_news_feed, IF (receiving_user_follow.follow_user_id, 1, 0) AS following_1564 FROM xf_profile_post AS profile_post LEFT JOIN xf_user AS posting_user ON (posting_user.user_id = profile_post.user_id) LEFT JOIN xf_user AS receiving_user ON (receiving_user.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_privacy AS receiving_user_privacy ON (receiving_user_privacy.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_follow AS receiving_user_follow ON (receiving_user_follow.user_id = profile_post.profile_user_id AND follow_user_id = 1564) WHERE (profile_post.message_state IN ('visible')) ORDER BY profile_post.post_date DESC LIMIT 20; # User@Host: root[root] @ localhost [] # Query_time: 0.000980 Lock_time: 0.000035 Rows_sent: 36 Rows_examined: 75 SET timestamp=1426095832; SELECT forum.* , IF(forum_read.forum_read_date > 1423503832, forum_read.forum_read_date, 1423503832) AS forum_read_date FROM xf_forum AS forum INNER JOIN xf_node AS node ON (node.node_id = forum.node_id) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = forum.node_id AND forum_read.user_id = 1564) WHERE forum.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14); # User@Host: root[root] @ localhost [] # Query_time: 0.015713 Lock_time: 0.000049 Rows_sent: 10 Rows_examined: 3942 SET timestamp=1426095832; SELECT thread.* , GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1423503832) AS thread_read_date, node.node_id AS forum_id, node.title AS forum_title, user.*, user_rue.display_style_group_id AS last_post_display_style_group_id FROM xf_thread AS thread LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = 1564) LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = 1564) INNER JOIN xf_node AS node ON (node.node_id = thread.node_id) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id) LEFT JOIN xf_user AS user ON (user.user_id = thread.last_post_user_id) LEFT JOIN xf_user AS user_rue ON (user_rue.user_id = thread.last_post_user_id) WHERE (1=1) AND (thread.node_id IN ('1', '2', '15', '16', '20', '38', '39', '40', '35', '43', '37', '41', '52', '53', '54', '3', '7', '9', '32', '28', '44', '23', '51', '45', '17', '49', '18', '19', '25', '26', '27', '31', '50', '21', '29', '34', '46', '47', '48', '12', '24', '13', '14')) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated')) ORDER BY thread.last_post_date DESC LIMIT 10; # Time: 150311 20:44:01 # User@Host: root[root] @ localhost [] # Query_time: 0.000207 Lock_time: 0.000023 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095841; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:44:23 # User@Host: root[root] @ localhost [] # Query_time: 0.024400 Lock_time: 0.000067 Rows_sent: 12 Rows_examined: 9171 SET timestamp=1426095863; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '144') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '144') WHERE post.post_date > '1423503863' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000416 Lock_time: 0.000017 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095863; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:44:28 # User@Host: root[root] @ localhost [] # Query_time: 0.000129 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095868; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:44:44 # User@Host: root[root] @ localhost [] # Query_time: 0.026111 Lock_time: 0.000082 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095884; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503884' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000264 Lock_time: 0.000036 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095884; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:44:46 # User@Host: root[root] @ localhost [] # Query_time: 0.036770 Lock_time: 0.000084 Rows_sent: 1018 Rows_examined: 8272 SET timestamp=1426095886; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 30, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '4') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '4') WHERE post.post_date > '1423503886' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000198 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095886; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:44:52 # User@Host: root[root] @ localhost [] # Query_time: 0.025137 Lock_time: 0.000043 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095892; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503891' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000162 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095892; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:44:56 # User@Host: root[root] @ localhost [] # Query_time: 0.000192 Lock_time: 0.000021 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095896; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:45:08 # User@Host: root[root] @ localhost [] # Query_time: 0.000310 Lock_time: 0.000041 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095908; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:45:25 # User@Host: root[root] @ localhost [] # Query_time: 0.005468 Lock_time: 0.000037 Rows_sent: 220 Rows_examined: 794 SET timestamp=1426095925; SELECT smilie.*, category.* FROM xf_smilie AS smilie LEFT JOIN xf_smilie_category AS category ON (category.smilie_category_id = smilie.smilie_category_id) WHERE smilie.display_in_editor = 1 ORDER BY category.display_order, smilie.display_order, smilie.title; # Time: 150311 20:45:36 # User@Host: root[root] @ localhost [] # Query_time: 0.000299 Lock_time: 0.000037 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095936; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:45:42 # User@Host: root[root] @ localhost [] # Query_time: 0.000134 Lock_time: 0.000018 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095942; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:45:51 # User@Host: root[root] @ localhost [] # Query_time: 0.019938 Lock_time: 0.000050 Rows_sent: 857 Rows_examined: 8877 SET timestamp=1426095951; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '3735') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '3735') WHERE post.post_date > '1423503951' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000180 Lock_time: 0.000024 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095951; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:45:56 # User@Host: root[root] @ localhost [] # Query_time: 0.019913 Lock_time: 0.000049 Rows_sent: 652 Rows_examined: 8260 SET timestamp=1426095956; SELECT thread.thread_id, post.post_id FROM xf_post AS post INNER JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id AND thread.node_id IN (2, 15, 16, 20, 38, 39, 40, 43, 37, 52, 53, 54, 7, 9, 32, 28, 44, 23, 51, 45, 49, 18, 19, 25, 26, 27, 31, 50, 21, 29, 34, 47, 48, 24, 13, 14)) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id AND forum.find_new = 1) LEFT JOIN xf_thread_read AS thread_read ON (thread_read.thread_id = thread.thread_id AND thread_read.user_id = '517') LEFT JOIN xf_forum_read AS forum_read ON (forum_read.node_id = thread.node_id AND forum_read.user_id = '517') WHERE post.post_date > '1423503956' AND post.message_state = 'visible' AND thread.discussion_state = 'visible' AND post.post_date > GREATEST( IF (thread_read.thread_read_date IS NULL, 0, thread_read.thread_read_date), IF (forum_read.forum_read_date IS NULL, 0, forum_read.forum_read_date) ); # User@Host: root[root] @ localhost [] # Query_time: 0.000161 Lock_time: 0.000019 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095956; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:46:33 # User@Host: root[root] @ localhost [] # Query_time: 0.000224 Lock_time: 0.000025 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095993; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1; # Time: 150311 20:46:39 # User@Host: root[root] @ localhost [] # Query_time: 0.000236 Lock_time: 0.000034 Rows_sent: 1 Rows_examined: 10 SET timestamp=1426095999; SELECT count(*) FROM dark_taigachat_activity AS activity LEFT JOIN xf_user AS user ON (user.user_id = activity.user_id) WHERE activity.date > UNIX_TIMESTAMP()-150 AND user.visible=1;