Page Time: 2.0521s
Memory: 47.0960 MB (Peak: 51.1280 MB)
Queries (515, time: 1.6881s, 82.3%)
SELECT addon_id
FROM xf_route_prefix
WHERE original_prefix = ? AND route_type = ?
Params: ?_debug=1, public
Run Time: 0.000102
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE Impossible WHERE noticed after reading const tables
SELECT find_route
FROM xf_route_filter
WHERE replace_route LIKE '?\\_debug=1%'
Run Time: 0.000083
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_route_filter ALL 15 Using where
SELECT addon_id
FROM xf_addon
WHERE addon_id = ?
Params:
Run Time: 0.000076
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE Impossible WHERE noticed after reading const tables
SELECT user.*
,
user_profile.*,
user_option.*,
user_privacy.*,
permission_combination.cache_value AS global_permission_cache
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,20,2,4,5,6,7,8,10)) as positive_rating_count
, (user.like_count + coalesce((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,20,2,4,5,6,7,8,10)), 0)) as positive_rating_count_incl_likes
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (14,16,11,12,13,19,3)) as negative_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (17,18,9)) as neutral_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
FROM xf_user AS user
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = user.user_id)
LEFT JOIN xf_permission_combination AS permission_combination ON
(permission_combination.permission_combination_id = user.permission_combination_id)
WHERE user.user_id = ?
Params: 54
Run Time: 0.000574
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
PRIMARY user const PRIMARY PRIMARY 4 const 1
PRIMARY user_profile const PRIMARY PRIMARY 4 const 1
PRIMARY user_option const PRIMARY PRIMARY 4 const 1
PRIMARY user_privacy const PRIMARY PRIMARY 4 const 1
PRIMARY permission_combination const PRIMARY PRIMARY 4 const 1
SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 const 19
SUBQUERY dark_postrating_count range user_id_rating user_id_rating 8 3 Using index condition
SUBQUERY dark_postrating_count range user_id_rating user_id_rating 8 7 Using index condition
SUBQUERY dark_postrating_count range user_id_rating user_id_rating 8 9 Using index condition
SUBQUERY dark_postrating_count range user_id_rating user_id_rating 8 9 Using index condition
SELECT thread.*
,
last_post_user.gender AS last_post_gender,
last_post_user.avatar_date AS last_post_avatar_date,
last_post_user.gravatar AS last_post_gravatar,
IF(last_post_user.username IS NULL, thread.last_post_username, last_post_user.username) AS last_post_username,
node.title AS node_title, node.node_name,
forum.*,
forum.last_post_id AS forum_last_post_id,
forum.last_post_date AS forum_last_post_date,
forum.last_post_user_id AS forum_last_post_user_id,
forum.last_post_username AS forum_last_post_username,
forum.last_thread_title AS forum_last_thread_title,
thread.last_post_id,
thread.last_post_date,
thread.last_post_user_id,
thread.last_post_username,
GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1606125647) AS thread_read_date,
permission.cache_value AS node_permission_cache,team.title as team_title,team.team_id as team_team_id,
team.user_id as team_user_id, team.team_state as team_team_state, team.privacy_state as team_privacy_state
FROM xf_thread AS thread FORCE INDEX (last_post_date)
LEFT JOIN xf_user AS last_post_user ON
(last_post_user.user_id = thread.last_post_user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_forum AS forum ON
(forum.node_id = thread.node_id)
LEFT JOIN xf_thread_read AS thread_read ON
(thread_read.thread_id = thread.thread_id
AND thread_read.user_id = 54)
LEFT JOIN xf_forum_read AS forum_read ON
(forum_read.node_id = thread.node_id
AND forum_read.user_id = 54)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 3655
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
LEFT JOIN xf_team AS team ON (team.team_id = thread.team_id)
WHERE (thread.discussion_type <> 'redirect') AND (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1606125647) AND (forum.find_new = 1) AND 1=1
ORDER BY thread.last_post_date DESC
LIMIT 38
Run Time: 0.001036
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE thread range last_post_date last_post_date 4 20178 Using where
SIMPLE forum eq_ref PRIMARY PRIMARY 4 test2test2test2.thread.node_id 1 Using where
SIMPLE thread_read eq_ref user_id_thread_id,thread_id user_id_thread_id 8 const,test2test2test2.thread.thread_id 1
SIMPLE forum_read eq_ref user_id_node_id,node_id user_id_node_id 8 const,test2test2test2.thread.node_id 1
SIMPLE last_post_user eq_ref PRIMARY PRIMARY 4 test2test2test2.thread.last_post_user_id 1
SIMPLE node eq_ref PRIMARY PRIMARY 4 test2test2test2.thread.node_id 1
SIMPLE permission eq_ref PRIMARY PRIMARY 35 const,const,test2test2test2.thread.node_id 1 Using where
SIMPLE team eq_ref PRIMARY PRIMARY 4 test2test2test2.thread.team_id 1
SELECT *
FROM xf_node
WHERE display_in_list = 1
ORDER BY lft ASC
Run Time: 0.002407
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_node ref display_in_list display_in_list 1 const 1090 Using where
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 3655
Run Time: 0.001593
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_permission_cache_content ref PRIMARY PRIMARY 31 const,const 2862 Using where
SELECT forum.*
,
IF(forum_read.forum_read_date > 1606125647, forum_read.forum_read_date, 1606125647) AS forum_read_date, prefixess_thread.prefix_id as prefix_id
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 = 54)
LEFT JOIN xf_post as prefixess_post
ON (prefixess_post.post_id = forum.last_post_id)
LEFT JOIN xf_thread AS prefixess_thread
ON (prefixess_thread.thread_id = prefixess_post.thread_id)
WHERE forum.node_id IN (1011, 1545, 1364, 2048, 1103, 1691, 1692, 672, 2569, 549, 2120, 2549, 2229, 2343, 1772, 2407, 2219, 2406, 2285, 2223, 2296, 2455, 2524, 2253, 2545, 2289, 2550, 2370, 1939, 2052, 2461, 1888, 2230, 1075, 1944, 2351, 2146, 1755, 2410, 2483, 2466, 2561, 2565, 2503, 2568, 2492, 2162, 967, 2248, 2559, 2546, 2367, 526, 2514, 2496, 1937, 2551, 1771, 2547, 2217, 1074, 1931, 2167, 1824, 2353, 1766, 2281, 2160, 2242, 1889, 2405, 1823, 2495, 2505, 2127, 2274, 2212, 1922, 2093, 2053, 2051, 2261, 2502, 964, 2501, 2258, 1769, 2286, 2379, 2477, 2485, 2113, 2180, 2181, 2182, 2389, 2384, 1773, 1768, 2039, 2375, 2456, 2151, 2260, 2522, 636, 2264, 2484, 2276, 2504, 2400, 2493, 1958, 1877, 2355, 2354, 1940, 2512, 1077, 2050, 1890, 1973, 2557, 2554, 2237, 2408, 2499, 2269, 2332, 2402, 2350, 2300, 2082, 2521, 2388, 2266, 2488, 2472, 2476, 2473, 676, 2465, 637, 2085, 2515, 2270, 2490, 2475, 2479, 1972, 2469, 2413, 2425, 2228, 2334, 2352, 2404, 2548, 1872, 2471, 2243, 1076, 2215, 2523, 2267, 2513, 2287, 2259, 1767, 2309, 2457, 2221, 2494, 2409, 2497, 2158, 2553, 2459, 2401, 2563, 2152, 2560, 2478, 2500, 2467, 2226, 1770, 2335, 2411, 2464, 2094, 2481, 2067, 635, 2203, 2156, 2268, 2487, 2525, 2460, 2498, 2254, 2462, 2426, 2470, 2143, 1941, 2403, 2480, 2552, 2463, 2220, 2468, 2489, 2344, 2562, 2564, 2566, 2567, 2555, 2556, 2558, 626, 640, 641, 642, 638, 639, 643, 644, 802, 1387, 1013, 646, 647, 648, 1907, 966, 2333, 1233, 2122, 1955, 2295, 2539, 2511, 1781, 2196, 1951, 2164, 2114, 2224, 1765, 548, 1406, 2294, 1954, 1401, 1402, 1403, 1404, 1405, 535, 536, 537, 538, 539, 1861, 903, 541, 546, 542, 543, 544, 2027, 1549, 1555, 1970, 1283, 2190, 2247, 855, 856, 857, 858, 859, 860, 861, 862, 1285, 863, 882, 883, 551, 552, 1239, 553, 554, 673, 1934, 1936, 671, 674, 1956, 1249, 1250, 1531, 675, 1092, 1348, 1206, 1207, 1208, 1209, 1210, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1248, 1211, 1255, 1256, 1257, 1259, 1260, 1261, 1262, 1264, 1266, 1267, 1268, 1269, 1271, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1258, 1279, 1280, 1281, 1336, 1337, 1338, 1339, 1340, 801, 556, 558, 559, 1246, 1247, 1091, 2256, 886, 2244, 2129, 731, 2246, 887, 888, 1411, 1412, 1413, 1414, 1415, 1959, 2291, 880)
Run Time: 0.003822
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE forum ALL PRIMARY 1073 Using where
SIMPLE forum_read eq_ref user_id_node_id,node_id user_id_node_id 8 const,test2test2test2.forum.node_id 1
SIMPLE node eq_ref PRIMARY PRIMARY 4 test2test2test2.forum.node_id 1 Using index
SIMPLE prefixess_post eq_ref PRIMARY PRIMARY 4 test2test2test2.forum.last_post_id 1
SIMPLE prefixess_thread eq_ref PRIMARY PRIMARY 4 test2test2test2.prefixess_post.thread_id 1 Using where
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1608714947)
ORDER BY session_activity.view_date DESC
Run Time: 0.004315
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE session_activity range view_date view_date 4 837 Using where
SIMPLE user eq_ref PRIMARY PRIMARY 4 test2test2test2.session_activity.user_id 1
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 54, 54, , XenForo_ControllerPublic_Forum, Index, valid, node_name=, 1608717647,
Run Time: 0.000085
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('BRC_action_login', 'BRC_action_login_description', 'BRC_action_exchange', 'BRC_action_exchange_description', 'BRC_action_transfer', 'BRC_action_transfer_description', 'BRC_action_withdraw', 'BRC_action_withdraw_description', 'BRC_action_steal', 'BRC_action_steal_description', 'BRC_action_paypalPayment', 'BRC_action_paypalPayment_description', 'BRC_action_paypalPaymentRe', 'BRC_action_paypalPaymentRe_description', 'BRC_action_registration', 'BRC_action_registration_description', 'BRC_action_facebookAssociate', 'BRC_action_facebookAssociate_description', 'BRC_action_facebookDisassociate', 'BRC_action_facebookDisassociate_description', 'BRC_action_twitterAssociate', 'BRC_action_twitterAssociate_description', 'BRC_action_twitterDisassociate', 'BRC_action_twitterDisassociate_description', 'BRC_action_googleAssociate', 'BRC_action_googleAssociate_description', 'BRC_action_googleDisassociate', 'BRC_action_googleDisassociate_description', 'BRC_action_birthday', 'BRC_action_birthday_description', 'BRC_action_importVbb', 'BRC_action_importVbb_description', 'BRC_action_interest', 'BRC_action_interest_description', 'BRC_action_updateFullProfile', 'BRC_action_updateFullProfile_description', 'BRC_action_updateFullProfileRe', 'BRC_action_updateFullProfileRe_description', 'BRC_action_uploadAvatar', 'BRC_action_uploadAvatar_description', 'BRC_action_uploadAvatarRe', 'BRC_action_uploadAvatarRe_description', 'BRC_action_updateStatus', 'BRC_action_updateStatus_description', 'BRC_action_follow', 'BRC_action_follow_description', 'BRC_action_followRe', 'BRC_action_followRe_description', 'BRC_action_getFollower', 'BRC_action_getFollower_description', 'BRC_action_getFollowerRe', 'BRC_action_getFollowerRe_description', 'BRC_action_profilePost', 'BRC_action_profilePost_description', 'BRC_action_getProfilePost', 'BRC_action_getProfilePost_description', 'BRC_action_likeProfilePost', 'BRC_action_likeProfilePost_description', 'BRC_action_receiveProfilePostLike', 'BRC_action_receiveProfilePostLike_description', 'BRC_action_receiveProfilePostLikeRe', 'BRC_action_receiveProfilePostLikeRe_description', 'BRC_action_createConversation', 'BRC_action_createConversation_description', 'BRC_action_createConversationRe', 'BRC_action_createConversationRe_description', 'BRC_action_receiveConversation', 'BRC_action_receiveConversation_description', 'BRC_action_replyConversation', 'BRC_action_replyConversation_description', 'BRC_action_conversationGetReply', 'BRC_action_conversationGetReply_description', 'BRC_action_trophyReward', 'BRC_action_trophyReward_description', 'BRC_action_dailyReward', 'BRC_action_dailyReward_description', 'BRC_action_salary', 'BRC_action_salary_description', 'BRC_action_createNewThread', 'BRC_action_createNewThread_description', 'BRC_action_threadDeleted', 'BRC_action_threadDeleted_description', 'BRC_action_threadGetReply', 'BRC_action_threadGetReply_description', 'BRC_action_readThread', 'BRC_action_readThread_description', 'BRC_action_watchThread', 'BRC_action_watchThread_description', 'BRC_action_watchThreadRe', 'BRC_action_watchThreadRe_description', 'BRC_action_threadGetWatched', 'BRC_action_threadGetWatched_description', 'BRC_action_threadGetWatchedRe', 'BRC_action_threadGetWatchedRe_description', 'BRC_action_createNewPoll', 'BRC_action_createNewPoll_description', 'BRC_action_votePoll', 'BRC_action_votePoll_description', 'BRC_action_pollGetVote', 'BRC_action_pollGetVote_description', 'BRC_action_threadSticky', 'BRC_action_threadSticky_description', 'BRC_action_threadStickyRe', 'BRC_action_threadStickyRe_description', 'BRC_action_newPost', 'BRC_action_newPost_description', 'BRC_action_postDeleted', 'BRC_action_postDeleted_description', 'BRC_action_uploadAttachment', 'BRC_action_uploadAttachment_description', 'BRC_action_uploadAttachmentRe', 'BRC_action_uploadAttachmentRe_description', 'BRC_action_downloadAttachment', 'BRC_action_downloadAttachment_description', 'BRC_action_attachmentDownloaded', 'BRC_action_attachmentDownloaded_description', 'BRC_action_likePost', 'BRC_action_likePost_description', 'BRC_action_receivePostLike', 'BRC_action_receivePostLike_description', 'BRC_action_receivePostLikeRe', 'BRC_action_receivePostLikeRe_description', 'BRC_action_reportPost', 'BRC_action_reportPost_description', 'BRC_action_postReported', 'BRC_action_postReported_description', 'BRC_action_BRRS_referral', 'BRC_action_BRRS_referral_explain', 'BRC_action_BRRSBuyReferralTimes', 'BRC_action_BRRS_referralCredit', 'BRC_action_BRRS_referralCredit_explain', 'tc_confessional', 'game')
Params: 2
Run Time: 0.000416
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_phrase_compiled range PRIMARY PRIMARY 106 133 Using where