XF 1.5 Слишком много запросов к базе

[phost]

Я понимаю что давно надо переходить и т.д. И обязательно это скоро сделаем но пожалуйста помогите выжать последние...
Не знаю даже после чего и как давно это но вот что наблюдается.
Скорее всего это изза модуля multisite но раньше такого небыло и работало быстрее...

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

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000201
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000170
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000163
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000150
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000169
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000163
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000151
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000166
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000165
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000169
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000152
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000174
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000163
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000169
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000165
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000184
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000170
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000163
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000151
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000167
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000151
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000188
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000180
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000166
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000165
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000162
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000162
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000177
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000152
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000166
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000162
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000166
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000167
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000169
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000166
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000170
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000170
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000165
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000167
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000167
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000166
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000170
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000279
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000227
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000215
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000230
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000228
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000266
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000230
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000226
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000237
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000221
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000221
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000262
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000230
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000230
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000228
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000231
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000329
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000226
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000239
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000225
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000237
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000175
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000165
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000171
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000234
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000246
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000259
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000258
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000199
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000186
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000181
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000182
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000170
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000172
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000170
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000163
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000214
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000163
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000166
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000181
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000172
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000162
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000173
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000169
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000171
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000169
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000166
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000173
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000169
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000179
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000177
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000174
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000174
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000170
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000169
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000167
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000169
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000170
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000170
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000166
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000169
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000173
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000170
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000176
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000172
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000187
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000169
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000166
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000169
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000166
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000175
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000152
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000165
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000150
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000152
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000151
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000149
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000149
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000165
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000163
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000151
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000150
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000152
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000162
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000152
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000151
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000152
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000150
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000150
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000151
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000151
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000148
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000149
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000150
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000200
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000162
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000163
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000147
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000150
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000147
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000150
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000163
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000152
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000152
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000150
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000153
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000149
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000165
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000150
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT *
FROM xf_siropu_chat_sessions
WHERE user_id = ?

Params: 54
Run Time: 0.000103
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_siropu_chat_sessions const PRIMARY PRIMARY 4 const 1

SELECT entry.*, user.username, user.avatar_date, user.avatar_width, user.avatar_height, user.gravatar
FROM lnblog_entry AS entry
LEFT JOIN xf_user AS user
ON (user.user_id = entry.user_id)
WHERE (entry.message_state IN ('visible','deleted','moderated'))
ORDER BY entry.entry_date DESC
LIMIT 5

Run Time: 0.003905
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE entry ALL 8534 Using where; Using filesort
SIMPLE user eq_ref PRIMARY PRIMARY 4 test2test2test2.entry.user_id 1

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000226
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000175
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT *
FROM xf_node

ORDER BY lft ASC

Run Time: 0.002695
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_node ALL 1246 Using filesort

SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'

Params: 3655
Run Time: 0.001551
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 thread.thread_id
FROM xf_thread AS thread

WHERE (thread.node_id IN (526, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 546, 548, 549, 550, 551, 552, 553, 554, 555, 556, 558, 559, 561, 564, 614, 615, 625, 626, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 670, 671, 672, 673, 674, 675, 676, 729, 731, 789, 796, 801, 802, 850, 853, 855, 856, 857, 858, 859, 860, 861, 862, 863, 878, 880, 882, 883, 885, 886, 887, 888, 903, 964, 966, 967, 976, 1011, 1013, 1074, 1075, 1076, 1077, 1091, 1092, 1103, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1233, 1239, 1241, 1246, 1247, 1248, 1249, 1250, 1251, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1264, 1266, 1267, 1268, 1269, 1271, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1283, 1285, 1335, 1336, 1337, 1338, 1339, 1340, 1343, 1348, 1364, 1366, 1387, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1410, 1411, 1412, 1413, 1414, 1415, 1427, 1442, 1512, 1530, 1531, 1533, 1545, 1549, 1555, 1691, 1692, 1755, 1765, 1766, 1767, 1768, 1769, 1770, 1771, 1772, 1773, 1781, 1786, 1823, 1824, 1837, 1861, 1862, 1872, 1877, 1888, 1889, 1890, 1902, 1907, 1917, 1922, 1931, 1934, 1935, 1936, 1937, 1938, 1939, 1940, 1941, 1944, 1951, 1954, 1955, 1956, 1957, 1958, 1959, 1960, 1970, 1972, 1973, 2027, 2039, 2048, 2050, 2051, 2052, 2053, 2067, 2082, 2085, 2093, 2094, 2113, 2114, 2120, 2122, 2127, 2129, 2138, 2143, 2144, 2146, 2151, 2152, 2156, 2158, 2160, 2162, 2164, 2167, 2180, 2181, 2182, 2189, 2190, 2196, 2203, 2212, 2215, 2217, 2219, 2220, 2221, 2223, 2224, 2225, 2226, 2228, 2229, 2230, 2237, 2241, 2242, 2243, 2244, 2246, 2247, 2248, 2253, 2254, 2256, 2257, 2258, 2259, 2260, 2261, 2264, 2266, 2267, 2268, 2269, 2270, 2274, 2276, 2281, 2285, 2286, 2287, 2289, 2291, 2294, 2295, 2296, 2300, 2302, 2309, 2327, 2332, 2333, 2334, 2335, 2336, 2343, 2344, 2350, 2351, 2352, 2353, 2354, 2355, 2361, 2365, 2367, 2369, 2370, 2375, 2379, 2382, 2384, 2388, 2389, 2400, 2401, 2402, 2403, 2404, 2405, 2406, 2407, 2408, 2409, 2410, 2411, 2413, 2422, 2423, 2424, 2425, 2426, 2455, 2456, 2457, 2458, 2459, 2460, 2461, 2462, 2463, 2464, 2465, 2466, 2467, 2468, 2469, 2470, 2471, 2472, 2473, 2474, 2475, 2476, 2477, 2478, 2479, 2480, 2481, 2482, 2483, 2484, 2485, 2486, 2487, 2488, 2489, 2490, 2491, 2492, 2493, 2494, 2495, 2496, 2497, 2498, 2499, 2500, 2501, 2502, 2503, 2504, 2505, 2511, 2512, 2513, 2514, 2515, 2521, 2522, 2523, 2524, 2525, 2526, 2538, 2539, 2540, 2541, 2542, 2543, 2544, 2545, 2546, 2547, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2556, 2557, 2558, 2559, 2560, 2561, 2562, 2563, 2564, 2565, 2566, 2567, 2568, 2569)) AND (thread.discussion_type = 'poll') AND (thread.discussion_state IN ('visible')) AND (thread.post_date > 744804047) AND 1=1
ORDER BY thread.post_date DESC
LIMIT 9

Run Time: 0.009491
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE thread range node_id_last_post_date,post_date,node_id_sticky_state_last_post post_date 4 158597 Using where

SELECT thread.*
,
NULL AS thread_read_date
FROM xf_thread AS thread
WHERE thread.thread_id IN (335883, 335575, 335256, 334202, 334008, 333626, 333083, 332540, 332103)

Run Time: 0.000176
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE thread range PRIMARY PRIMARY 4 9 Using where

SELECT node.*, forum.*

FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)

WHERE node.node_id IN (539, 1691, 548, 2246, 672, 2291)

Run Time: 0.000220
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE node range PRIMARY PRIMARY 4 6 Using where
SIMPLE forum eq_ref PRIMARY PRIMARY 4 test2test2test2.node.node_id 1

SELECT user.*

,(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

WHERE user.user_id IN (91018, 103128, 125352, 124500, 62035, 84803, 102731)
ORDER BY user.username

Run Time: 0.000652
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
PRIMARY user range PRIMARY PRIMARY 4 7 Using where; Using filesort
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000209
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

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_54
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 = 54)
WHERE (profile_post.message_state IN ('visible'))
ORDER BY profile_post.post_date DESC
LIMIT 9

Run Time: 0.000426
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE profile_post index post_date 4 9 Using where
SIMPLE posting_user eq_ref PRIMARY PRIMARY 4 test2test2test2.profile_post.user_id 1
SIMPLE receiving_user eq_ref PRIMARY PRIMARY 4 test2test2test2.profile_post.profile_user_id 1
SIMPLE receiving_user_privacy eq_ref PRIMARY PRIMARY 4 test2test2test2.profile_post.profile_user_id 1
SIMPLE receiving_user_follow eq_ref PRIMARY,follow_user_id PRIMARY 8 test2test2test2.profile_post.profile_user_id,const 1 Using index

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000207
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT thread.thread_id
FROM xf_thread AS thread

WHERE (thread.node_id IN ('1934')) AND (thread.discussion_state IN ('visible')) AND (thread.post_date > 1608285647) AND 1=1
ORDER BY thread.post_date DESC
LIMIT 15

Run Time: 0.000386
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE thread range node_id_last_post_date,post_date,node_id_sticky_state_last_post post_date 4 1239 Using where

SELECT thread.*
,
NULL AS thread_read_date
FROM xf_thread AS thread
WHERE thread.thread_id IN (336047, 336046, 336045, 336044, 336043, 335936, 335935, 335934, 335933, 335932, 335870, 335869, 335868, 335867, 335866)

Run Time: 0.000184
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE thread range PRIMARY PRIMARY 4 15 Using where

SELECT node.*, forum.*

FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)

WHERE node.node_id IN (1934)

Run Time: 0.000195
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE forum const PRIMARY PRIMARY 4 const 1
SIMPLE node const PRIMARY PRIMARY 4 const 1

SELECT user.*

,(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

WHERE user.user_id IN (37063)
ORDER BY user.username

Run Time: 0.000436
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
PRIMARY user const PRIMARY PRIMARY 4 const 1
SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 const 17
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 domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000189
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT thread.thread_id
FROM xf_thread AS thread

WHERE (thread.node_id IN ('1936')) AND (thread.discussion_state IN ('visible')) AND 1=1
ORDER BY thread.post_date DESC
LIMIT 15

Run Time: 0.000204
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE thread index node_id_last_post_date,node_id_sticky_state_last_post post_date 4 85 Using where

SELECT thread.*
,
NULL AS thread_read_date
FROM xf_thread AS thread
WHERE thread.thread_id IN (336108, 336107, 336083, 336082, 336081, 336080, 336071, 336070, 336069, 336068, 336053, 336052, 336033, 336027, 336019)

Run Time: 0.000152
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE thread range PRIMARY PRIMARY 4 15 Using where

SELECT node.*, forum.*

FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)

WHERE node.node_id IN (1936)

Run Time: 0.000149
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE forum const PRIMARY PRIMARY 4 const 1
SIMPLE node const PRIMARY PRIMARY 4 const 1

SELECT user.*

,(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

WHERE user.user_id IN (37063, 86890)
ORDER BY user.username

Run Time: 0.000406
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
PRIMARY user range PRIMARY PRIMARY 4 2 Using where; Using filesort
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000178
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT thread.thread_id
FROM xf_thread AS thread

WHERE (thread.node_id IN (526, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 546, 548, 549, 550, 551, 552, 553, 554, 555, 556, 558, 559, 561, 564, 614, 615, 625, 626, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 670, 671, 672, 673, 674, 675, 676, 729, 731, 789, 796, 801, 802, 850, 853, 855, 856, 857, 858, 859, 860, 861, 862, 863, 878, 880, 882, 883, 885, 886, 887, 888, 903, 964, 966, 967, 976, 1011, 1013, 1074, 1075, 1076, 1077, 1091, 1092, 1103, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1233, 1239, 1241, 1246, 1247, 1248, 1249, 1250, 1251, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1264, 1266, 1267, 1268, 1269, 1271, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1283, 1285, 1335, 1336, 1337, 1338, 1339, 1340, 1343, 1348, 1364, 1366, 1387, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1410, 1411, 1412, 1413, 1414, 1415, 1427, 1442, 1512, 1530, 1531, 1533, 1545, 1549, 1555, 1691, 1692, 1755, 1765, 1766, 1767, 1768, 1769, 1770, 1771, 1772, 1773, 1781, 1786, 1823, 1824, 1837, 1861, 1862, 1872, 1877, 1888, 1889, 1890, 1902, 1907, 1917, 1922, 1931, 1934, 1935, 1936, 1937, 1938, 1939, 1940, 1941, 1944, 1951, 1954, 1955, 1956, 1957, 1958, 1959, 1960, 1970, 1972, 1973, 2027, 2039, 2048, 2050, 2051, 2052, 2053, 2067, 2082, 2085, 2093, 2094, 2113, 2114, 2120, 2122, 2127, 2129, 2138, 2143, 2144, 2146, 2151, 2152, 2156, 2158, 2160, 2162, 2164, 2167, 2180, 2181, 2182, 2189, 2190, 2196, 2203, 2212, 2215, 2217, 2219, 2220, 2221, 2223, 2224, 2225, 2226, 2228, 2229, 2230, 2237, 2241, 2242, 2243, 2244, 2246, 2247, 2248, 2253, 2254, 2256, 2257, 2258, 2259, 2260, 2261, 2264, 2266, 2267, 2268, 2269, 2270, 2274, 2276, 2281, 2285, 2286, 2287, 2289, 2291, 2294, 2295, 2296, 2300, 2302, 2309, 2327, 2332, 2333, 2334, 2335, 2336, 2343, 2344, 2350, 2351, 2352, 2353, 2354, 2355, 2361, 2365, 2367, 2369, 2370, 2375, 2379, 2382, 2384, 2388, 2389, 2400, 2401, 2402, 2403, 2404, 2405, 2406, 2407, 2408, 2409, 2410, 2411, 2413, 2422, 2423, 2424, 2425, 2426, 2455, 2456, 2457, 2458, 2459, 2460, 2461, 2462, 2463, 2464, 2465, 2466, 2467, 2468, 2469, 2470, 2471, 2472, 2473, 2474, 2475, 2476, 2477, 2478, 2479, 2480, 2481, 2482, 2483, 2484, 2485, 2486, 2487, 2488, 2489, 2490, 2491, 2492, 2493, 2494, 2495, 2496, 2497, 2498, 2499, 2500, 2501, 2502, 2503, 2504, 2505, 2511, 2512, 2513, 2514, 2515, 2521, 2522, 2523, 2524, 2525, 2526, 2538, 2539, 2540, 2541, 2542, 2543, 2544, 2545, 2546, 2547, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2556, 2557, 2558, 2559, 2560, 2561, 2562, 2563, 2564, 2565, 2566, 2567, 2568, 2569)) AND (thread.discussion_state IN ('visible')) AND (thread.post_date > 1606125647) AND 1=1
ORDER BY thread.post_date DESC
LIMIT 21

Run Time: 0.005276
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE thread range node_id_last_post_date,post_date,node_id_sticky_state_last_post post_date 4 14116 Using where

SELECT thread.*
,
NULL AS thread_read_date
FROM xf_thread AS thread
WHERE thread.thread_id IN (336115, 336108, 336107, 336103, 336099, 336098, 336092, 336091, 336090, 336088, 336085, 336084, 336083, 336082, 336081, 336080, 336078, 336077, 336076, 336075, 336074)

Run Time: 0.000193
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE thread range PRIMARY PRIMARY 4 21 Using where

SELECT node.*, forum.*

FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)

WHERE node.node_id IN (539, 1936, 552, 1531, 2557)

Run Time: 0.000222
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE node range PRIMARY PRIMARY 4 5 Using where
SIMPLE forum eq_ref PRIMARY PRIMARY 4 test2test2test2.node.node_id 1

SELECT user.*

,(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

WHERE user.user_id IN (106702, 37063, 96436, 43736, 114259, 74802, 126190)
ORDER BY user.username

Run Time: 0.000755
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
PRIMARY user range PRIMARY PRIMARY 4 7 Using where; Using filesort
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000185
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT thread.thread_id
FROM xf_thread AS thread

WHERE (thread.node_id IN (526, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 546, 548, 549, 550, 551, 552, 553, 554, 555, 556, 558, 559, 561, 564, 614, 615, 625, 626, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 648, 670, 671, 672, 673, 674, 675, 676, 729, 731, 789, 796, 801, 802, 850, 853, 855, 856, 857, 858, 859, 860, 861, 862, 863, 878, 880, 882, 883, 885, 886, 887, 888, 903, 964, 966, 967, 976, 1011, 1013, 1074, 1075, 1076, 1077, 1091, 1092, 1103, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1233, 1239, 1241, 1246, 1247, 1248, 1249, 1250, 1251, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1264, 1266, 1267, 1268, 1269, 1271, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1283, 1285, 1335, 1336, 1337, 1338, 1339, 1340, 1343, 1348, 1364, 1366, 1387, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1410, 1411, 1412, 1413, 1414, 1415, 1427, 1442, 1512, 1530, 1531, 1533, 1545, 1549, 1555, 1691, 1692, 1755, 1765, 1766, 1767, 1768, 1769, 1770, 1771, 1772, 1773, 1781, 1786, 1823, 1824, 1837, 1861, 1862, 1872, 1877, 1888, 1889, 1890, 1902, 1907, 1917, 1922, 1931, 1934, 1935, 1936, 1937, 1938, 1939, 1940, 1941, 1944, 1951, 1954, 1955, 1956, 1957, 1958, 1959, 1960, 1970, 1972, 1973, 2027, 2039, 2048, 2050, 2051, 2052, 2053, 2067, 2082, 2085, 2093, 2094, 2113, 2114, 2120, 2122, 2127, 2129, 2138, 2143, 2144, 2146, 2151, 2152, 2156, 2158, 2160, 2162, 2164, 2167, 2180, 2181, 2182, 2189, 2190, 2196, 2203, 2212, 2215, 2217, 2219, 2220, 2221, 2223, 2224, 2225, 2226, 2228, 2229, 2230, 2237, 2241, 2242, 2243, 2244, 2246, 2247, 2248, 2253, 2254, 2256, 2257, 2258, 2259, 2260, 2261, 2264, 2266, 2267, 2268, 2269, 2270, 2274, 2276, 2281, 2285, 2286, 2287, 2289, 2291, 2294, 2295, 2296, 2300, 2302, 2309, 2327, 2332, 2333, 2334, 2335, 2336, 2343, 2344, 2350, 2351, 2352, 2353, 2354, 2355, 2361, 2365, 2367, 2369, 2370, 2375, 2379, 2382, 2384, 2388, 2389, 2400, 2401, 2402, 2403, 2404, 2405, 2406, 2407, 2408, 2409, 2410, 2411, 2413, 2422, 2423, 2424, 2425, 2426, 2455, 2456, 2457, 2458, 2459, 2460, 2461, 2462, 2463, 2464, 2465, 2466, 2467, 2468, 2469, 2470, 2471, 2472, 2473, 2474, 2475, 2476, 2477, 2478, 2479, 2480, 2481, 2482, 2483, 2484, 2485, 2486, 2487, 2488, 2489, 2490, 2491, 2492, 2493, 2494, 2495, 2496, 2497, 2498, 2499, 2500, 2501, 2502, 2503, 2504, 2505, 2511, 2512, 2513, 2514, 2515, 2521, 2522, 2523, 2524, 2525, 2526, 2538, 2539, 2540, 2541, 2542, 2543, 2544, 2545, 2546, 2547, 2548, 2549, 2550, 2551, 2552, 2553, 2554, 2555, 2556, 2557, 2558, 2559, 2560, 2561, 2562, 2563, 2564, 2565, 2566, 2567, 2568, 2569)) AND (thread.discussion_state IN ('visible')) AND (thread.reply_count > 0) AND 1=1
ORDER BY thread.last_post_date DESC
LIMIT 45

Run Time: 0.005224
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE thread index node_id_last_post_date,node_id_sticky_state_last_post last_post_date 4 45 Using where

SELECT thread.*
,
NULL AS thread_read_date
FROM xf_thread AS thread
WHERE thread.thread_id IN (154068, 302515, 239266, 322411, 314295, 324509, 326515, 336115, 152002, 333761, 152962, 214972, 162820, 335980, 336103, 321912, 333652, 330010, 329999, 333689, 318499, 161757, 327181, 331602, 331600, 265769, 335523, 164068, 332540, 270566, 271403, 331315, 281457, 334026, 333658, 336098, 200424, 334707, 317758, 311016, 309769, 334200, 265675, 11718, 243734)

Run Time: 0.000260
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE thread range PRIMARY PRIMARY 4 45 Using where

SELECT node.*, forum.*

FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)

WHERE node.node_id IN (2289, 2274, 966, 646, 2522, 636, 539, 2051, 626, 2146, 671, 1075, 2492, 1824, 2545, 967, 2039, 672, 2473, 2411, 2567, 552, 1772, 2426, 2514, 1691, 2410, 673)

Run Time: 0.000351
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE node range PRIMARY PRIMARY 4 28 Using where
SIMPLE forum eq_ref PRIMARY PRIMARY 4 test2test2test2.node.node_id 1

SELECT user.*

,(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

WHERE user.user_id IN (107800, 100442, 45149, 125994, 60273, 106702, 110752, 100050, 80555, 114973, 121148, 124182, 123601, 102731, 123599, 24064, 123588, 95981, 3616, 123075, 29234, 112026, 107475, 35191, 60059, 66580, 95046, 116696)
ORDER BY user.username

Run Time: 0.001706
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
PRIMARY user range PRIMARY PRIMARY 4 28 Using where; Using filesort
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition
DEPENDENT SUBQUERY dark_postrating_count ref user_id_rating user_id_rating 4 test2test2test2.user.user_id 2 Using index condition

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000236
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000226
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000203
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000201
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000184
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000192
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000187
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000185
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000192
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000300
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000186
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000162
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000178
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000173
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000197
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT permission_cache
FROM xf_admin
WHERE user_id = ?

Params: 54
Run Time: 0.000096
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_admin const PRIMARY PRIMARY 4 const 1

SELECT COUNT(*)
FROM xf_brivium_credits_transaction AS transaction

WHERE (transaction.moderate = 1)
LIMIT 0,1

Run Time: 0.295841
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE transaction index action_moderate 303 1669344 Using where; Using index

SELECT COUNT(*)
FROM xf_brivium_credits_transaction AS transaction

WHERE (transaction.moderate = 1) AND (transaction.action_id = 'withdraw')
LIMIT 0,1

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE transaction ref action_id,action_currency,action_moderate action_moderate 303 const,const 1 Using where; Using index

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000268
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT *
FROM xf_siropu_chat_sessions
WHERE user_id = ?

Params: 54
Run Time: 0.000124
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_siropu_chat_sessions const PRIMARY PRIMARY 4 const 1

SELECT *,
(SELECT
COUNT(*)
FROM xf_siropu_chat_sessions
WHERE user_room_id = room_id
AND user_last_activity >= 1608715848
) AS roomCount
FROM xf_siropu_chat_rooms
ORDER BY roomCount DESC

Run Time: 0.000629
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
PRIMARY xf_siropu_chat_rooms ALL 10 Using filesort
DEPENDENT SUBQUERY xf_siropu_chat_sessions range user_room_id,user_last_activity user_last_activity 4 29 Using index condition; Using where

SELECT COUNT(*) AS count
FROM xf_siropu_chat_reports
WHERE report_state = 'open'

Run Time: 0.000103
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_siropu_chat_reports ref report_state report_state 1 const 3 Using where; Using index

SELECT *
FROM xf_siropu_chat_bot_responses
WHERE response_enabled = 1
ORDER BY response_id DESC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_siropu_chat_bot_responses index PRIMARY 4 6 Using where

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000206
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000178
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000173
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000173
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000174
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT referral_code
FROM xf_user_brivium_referral
WHERE user_id = ?

Params: 54
Run Time: 0.006984
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_user_brivium_referral ALL 67393 Using where

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000173
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000163
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000158
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000168
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000155
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000161
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000157
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000203
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000166
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT *
FROM xf_node

ORDER BY lft ASC

Run Time: 0.002740
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_node ALL 1246 Using filesort

SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'

Params: 3655
Run Time: 0.001872
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 thread.*
,
GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1606125647) AS thread_read_date,
node.node_id AS forum_id, node.title AS forum_title,
user.*
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 = 54)
LEFT JOIN xf_forum_read AS forum_read ON
(forum_read.node_id = thread.node_id
AND forum_read.user_id = 54)
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)
WHERE (1=1 AND 1=1) AND (thread.node_id IN ('614', '1011', '1545', '1364', '2048', '1103', '1691', '1692', '672', '2569', '549', '2120', '1442', '564', '2549', '2229', '2343', '1772', '2407', '2219', '2406', '2285', '2223', '2296', '2455', '2524', '2253', '2545', '2289', '2550', '2370', '1939', '2052', '2461', '1888', '2230', '1075', '1944', '1343', '2351', '2146', '2225', '1755', '1427', '2410', '2483', '2466', '2561', '2565', '2365', '2503', '2568', '2492', '2162', '967', '2248', '2559', '2546', '2367', '526', '2514', '2496', '1937', '2551', '1771', '2547', '2217', '2336', '1074', '1931', '2167', '1935', '2241', '789', '1824', '2353', '1766', '2281', '2160', '2242', '1889', '2405', '1823', '2495', '2505', '2127', '2274', '2212', '1922', '2093', '1917', '2053', '2051', '2261', '2502', '964', '2501', '2258', '2302', '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', '2257', '1877', '2144', '2355', '2354', '1940', '2486', '2512', '1077', '2050', '1890', '2482', '1973', '2557', '2554', '2382', '1786', '2237', '2408', '2499', '2269', '2332', '2402', '2350', '2300', '2082', '2521', '2388', '2266', '2488', '2472', '2476', '2473', '676', '2465', '637', '2085', '2515', '796', '2270', '2490', '2475', '2479', '1972', '2469', '2413', '2425', '2228', '2334', '2352', '2404', '2548', '1872', '2471', '2474', '2243', '1076', '2215', '2523', '2267', '2513', '2287', '2259', '1767', '2309', '2457', '2221', '2494', '2409', '2497', '2158', '2553', '2491', '2459', '2401', '2563', '2152', '2560', '1938', '2526', '615', '2478', '2500', '2467', '2226', '1770', '2335', '2411', '2464', '2094', '2481', '2067', '635', '2189', '2203', '2156', '2369', '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', '625', '626', '640', '641', '642', '638', '639', '643', '644', '802', '2361', '1366', '1387', '1013', '645', '646', '647', '648', '1837', '2458', '2541', '2542', '2543', '2544', '2540', '1907', '966', '2333', '1233', '2122', '1955', '2538', '2295', '2539', '2511', '1781', '2196', '1951', '2164', '2114', '2224', '1902', '1765', '548', '1406', '2294', '1954', '2422', '2423', '2424', '1957', '1960', '1862', '1400', '1401', '1402', '1403', '1404', '1405', '534', '535', '536', '537', '538', '539', '1861', '903', '540', '541', '546', '542', '543', '544', '2027', '853', '1549', '1555', '1970', '1512', '1283', '2190', '2247', '855', '856', '857', '858', '859', '860', '861', '862', '1285', '863', '882', '883', '550', '551', '552', '1239', '553', '554', '670', '673', '1936', '671', '674', '1956', '1249', '1250', '1531', '1533', '1530', '675', '1092', '1348', '1205', '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', '1254', '1255', '1256', '1257', '1259', '1260', '1261', '1262', '1264', '1266', '1267', '1268', '1269', '1271', '1272', '1273', '1274', '1275', '1276', '1277', '1278', '1258', '1279', '1280', '1281', '729', '1241', '1251', '1335', '1336', '1337', '1338', '1339', '1340', '555', '801', '556', '558', '559', '1246', '1247', '1091', '561', '976', '878', '850', '2138', '2256', '2327', '885', '886', '2244', '2129', '731', '2246', '887', '888', '1410', '1411', '1412', '1413', '1414', '1415', '1959', '2291', '880')) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated'))
ORDER BY thread.last_post_date DESC
LIMIT 10

Run Time: 1.251236
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE forum index PRIMARY team_id 4 1073 Using index; Using temporary; Using filesort
SIMPLE node eq_ref PRIMARY PRIMARY 4 test2test2test2.forum.node_id 1
SIMPLE thread ref node_id_last_post_date,node_id_sticky_state_last_post node_id_last_post_date 4 test2test2test2.forum.node_id 202 Using index condition; 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.forum.node_id 1
SIMPLE user eq_ref PRIMARY PRIMARY 4 test2test2test2.thread.last_post_user_id 1

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000233
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000174
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000166
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000173
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000163
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000160
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000170
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000156
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000151
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000159
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

Run Time: 0.000162
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE domain ALL 18 Using filesort

Included Files (416, XenForo Classes: 79)

index.php
library/XenForo/Autoloader.php
library/XenForo/Application.php
library/Zend/Registry.php
library/Lgpl/utf8.php
library/Zend/Config.php
library/config.php
library/XenForo/FrontController.php
library/XenForo/Dependencies/Public.php
library/XenForo/Dependencies/Abstract.php
library/Zend/Controller/Request/Http.php
library/Zend/Controller/Request/Abstract.php
library/Zend/Uri.php
library/Zend/Controller/Response/Http.php
library/Zend/Controller/Response/Abstract.php
library/XenForo/Model/DataRegistry.php
library/XenForo/Model.php
library/Zend/Cache.php
library/Zend/Cache/Backend/Libmemcached.php
library/Zend/Cache/Backend/ExtendedInterface.php
library/Zend/Cache/Backend/Interface.php
library/Zend/Cache/Backend.php
library/Zend/Cache/Core.php
library/XenForo/Phrase.php
library/XenForo/CodeEvent.php
library/XenForo/Options.php
library/XenForo/Link.php
library/XenForo/Template/Helper/Core.php
library/XenCentral/MultiSite/Hooks.php
library/XenCentral/MultiSite/Model/Domain.php
library/XenCentral/MultiSite/Model/Abstract.php
library/Brivium/Credits/Listener/Listener.php
library/Brivium/BriviumHelper/EventListeners.php
library/Brivium/BriviumHelper/1020271/EventListeners.php
library/Nobita/Teams/Listener.php
library/Nobita/Teams/Option.php
library/Nobita/Teams/helpers.php
library/ExtendPostRating/Listener/CodeEvent.php
library/XenCentral/Framework/Hooks.php
library/ModernTank/FakeUserOnline/Listener.php
library/Asp/OnlineStatus/Plugin/Plugin.php
library/InfisJSC/TopicStarter/Listener.php
library/HideAddon/Listener/BBCode.php
library/Siropu/Chat/Listener.php
library/Nobita/SignatureImage/Listener.php
library/Dark/PostRating/EventListener.php
library/VietXfAdvStats/Listener.php
library/XenMoods/Listener/LoadClassModel.php
library/XenCentral/MultiSite/Model/Filters.php
library/XenForo/Model/Tag.php
library/XenGallery/Model/Category.php
library/WidgetFramework/Model/Widget.php
library/XenForo/Model/ThreadPrefix.php
library/XenCentral/MultiSite/Filters/Forum.php
library/XenCentral/MultiSite/Filters/Abstract.php
library/XenCentral/MultiSite/Filters/RootForum.php
library/XenCentral/MultiSite/Filters/RenameForum.php
library/XenCentral/MultiSite/Filters/PrimaryForum.php
library/XenCentral/MultiSite/Filters/Admins.php
library/XenCentral/MultiSite/Filters/Moderators.php
library/XenCentral/MultiSite/Filters/Style.php
library/XenCentral/MultiSite/Filters/Addons.php
library/XenCentral/MultiSite/Filters/Tags.php
library/XenCentral/MultiSite/Filters/AdZone.php
library/XenCentral/MultiSite/Filters/XenGallery/Category.php
library/XenCentral/MultiSite/Filters/AbstractCategory.php
library/XenCentral/MultiSite/Filters/XenGallery/RenameCategory.php
library/XenCentral/MultiSite/Filters/AbstractRenameCategory.php
library/XenCentral/MultiSite/Filters/Widget.php
library/XenCentral/MultiSite/Filters/Nobita/Teams/Category.php
library/XenCentral/MultiSite/Filters/Nobita/Teams/RenameCategory.php
library/XenCentral/MultiSite/Filters/ThreadPrefixGroups.php
library/XenForo/Model/User.php
library/Brivium/ReferralCreditSystem/EventListeners/Listener.php
library/XenCentral/MultiSite/Model/XenForo/DataRegistry.php
library/Brivium/Credits/Currency.php
library/Brivium/Credits/Action.php
library/Brivium/Credits/ActionHandler/Login/ActionHandler.php
library/Brivium/Credits/ActionHandler/Abstract.php
library/Brivium/Credits/ActionHandler/Exchange/ActionHandler.php
library/Brivium/Credits/ActionHandler/Transfer/ActionHandler.php
library/Brivium/Credits/ActionHandler/Withdraw/ActionHandler.php
library/Brivium/Credits/ActionHandler/Steal/ActionHandler.php
library/Brivium/Credits/ActionHandler/PaypalPayment/ActionHandler.php
library/Brivium/Credits/ActionHandler/PaypalPaymentRe/ActionHandler.php
library/Brivium/Credits/ActionHandler/Registration/ActionHandler.php
library/Brivium/Credits/ActionHandler/FacebookAssociate/ActionHandler.php
library/Brivium/Credits/ActionHandler/FacebookDisassociate/ActionHandler.php
library/Brivium/Credits/ActionHandler/TwitterAssociate/ActionHandler.php
library/Brivium/Credits/ActionHandler/TwitterDisassociate/ActionHandler.php
library/Brivium/Credits/ActionHandler/GoogleAssociate/ActionHandler.php
library/Brivium/Credits/ActionHandler/GoogleDisassociate/ActionHandler.php
library/Brivium/Credits/ActionHandler/Birthday/ActionHandler.php
library/Brivium/Credits/ActionHandler/ImportVbb/ActionHandler.php
library/Brivium/Credits/ActionHandler/Interest/ActionHandler.php
library/Brivium/Credits/ActionHandler/UpdateFullProfile/ActionHandler.php
library/Brivium/Credits/ActionHandler/UpdateFullProfileRe/ActionHandler.php
library/Brivium/Credits/ActionHandler/UploadAvatar/ActionHandler.php
library/Brivium/Credits/ActionHandler/UploadAvatarRe/ActionHandler.php
library/Brivium/Credits/ActionHandler/UpdateStatus/ActionHandler.php
library/Brivium/Credits/ActionHandler/Follow/ActionHandler.php
library/Brivium/Credits/ActionHandler/FollowRe/ActionHandler.php
library/Brivium/Credits/ActionHandler/GetFollower/ActionHandler.php
library/Brivium/Credits/ActionHandler/GetFollowerRe/ActionHandler.php
library/Brivium/Credits/ActionHandler/ProfilePost/ActionHandler.php
library/Brivium/Credits/ActionHandler/GetProfilePost/ActionHandler.php
library/Brivium/Credits/ActionHandler/LikeProfilePost/ActionHandler.php
library/Brivium/Credits/ActionHandler/ReceiveProfilePostLike/ActionHandler.php
library/Brivium/Credits/ActionHandler/ReceiveProfilePostLikeRe/ActionHandler.php
library/Brivium/Credits/ActionHandler/CreateConversation/ActionHandler.php
library/Brivium/Credits/ActionHandler/CreateConversationRe/ActionHandler.php
library/Brivium/Credits/ActionHandler/ReceiveConversation/ActionHandler.php
library/Brivium/Credits/ActionHandler/ReplyConversation/ActionHandler.php
library/Brivium/Credits/ActionHandler/ConversationGetReply/ActionHandler.php
library/Brivium/Credits/ActionHandler/TrophyReward/ActionHandler.php
library/Brivium/Credits/ActionHandler/DailyReward/ActionHandler.php
library/Brivium/Credits/ActionHandler/Salary/ActionHandler.php
library/Brivium/Credits/ActionHandler/CreateNewThread/ActionHandler.php
library/Brivium/Credits/ActionHandler/ThreadDeleted/ActionHandler.php
library/Brivium/Credits/ActionHandler/ThreadGetReply/ActionHandler.php
library/Brivium/Credits/ActionHandler/ReadThread/ActionHandler.php
library/Brivium/Credits/ActionHandler/WatchThread/ActionHandler.php
library/Brivium/Credits/ActionHandler/WatchThreadRe/ActionHandler.php
library/Brivium/Credits/ActionHandler/ThreadGetWatched/ActionHandler.php
library/Brivium/Credits/ActionHandler/ThreadGetWatchedRe/ActionHandler.php
library/Brivium/Credits/ActionHandler/CreateNewPoll/ActionHandler.php
library/Brivium/Credits/ActionHandler/VotePoll/ActionHandler.php
library/Brivium/Credits/ActionHandler/PollGetVote/ActionHandler.php
library/Brivium/Credits/ActionHandler/ThreadSticky/ActionHandler.php
library/Brivium/Credits/ActionHandler/ThreadStickyRe/ActionHandler.php
library/Brivium/Credits/ActionHandler/NewPost/ActionHandler.php
library/Brivium/Credits/ActionHandler/PostDeleted/ActionHandler.php
library/Brivium/Credits/ActionHandler/UploadAttachment/ActionHandler.php
library/Brivium/Credits/ActionHandler/UploadAttachmentRe/ActionHandler.php
library/Brivium/Credits/ActionHandler/DownloadAttachment/ActionHandler.php
library/Brivium/Credits/ActionHandler/AttachmentDownloaded/ActionHandler.php
library/Brivium/Credits/ActionHandler/LikePost/ActionHandler.php
library/Brivium/Credits/ActionHandler/ReceivePostLike/ActionHandler.php
library/Brivium/Credits/ActionHandler/ReceivePostLikeRe/ActionHandler.php
library/Brivium/Credits/ActionHandler/ReportPost/ActionHandler.php
library/Brivium/Credits/ActionHandler/PostReported/ActionHandler.php
library/Brivium/ReferralCreditSystem/ActionHandler/Referral/ActionHandler.php
library/Brivium/ReferralCreditSystem/ActionHandler/BuyReferralTimes/ActionHandler.php
library/Brivium/ReferralCreditSystem/ActionHandler/ReferralCredit/ActionHandler.php
library/Brivium/Credits/Events.php
library/HideAddon/Helper/hideaddon.php
library/game/Application/Core.php
library/game/Application.php
library/WidgetFramework/Listener.php
library/WidgetFramework/Option.php
library/XenGallery/Listener.php
library/Waindigo/Listener/InitDependencies.php
library/Waindigo/Listener/InitDependencies/20150212.php
library/Waindigo/Listener/ControllerPreDispatch/20150212.php
library/XenMoods/Listener/InitDependencies.php
library/SV/MultiPrefix/Listener.php
library/SolidMean/Cloudflare/Listener.php
library/SolidMean/Cloudflare/ip_in_range.php
library/XenForo/Router.php
library/XenForo/Route/Filter.php
library/XenForo/Route/Interface.php
library/XenForo/Route/ResponseSuffix.php
library/XenForo/Route/Prefix.php
library/XenForo/Route/Prefix/Index.php
library/XenForo/RouteMatch.php
library/Zend/Db.php
library/Zend/Db/Adapter/Mysqli.php
library/Zend/Db/Adapter/Abstract.php
library/Zend/Db/Select.php
library/Zend/Db/Expr.php
library/Zend/Db/Profiler.php
library/Zend/Db/Statement/Mysqli.php
library/Zend/Db/Statement.php
library/Zend/Db/Statement/Interface.php
library/Zend/Db/Profiler/Query.php
library/XenForo/Db.php
library/XenForo/ControllerPublic/Index.php
library/XenForo/ControllerPublic/Abstract.php
library/XenForo/Controller.php
library/ThemesCorp/Confessionals/Listener.php
library/HideAddon/Listener/Controler.php
library/Nobita/AvatarUrl/Listener.php
library/HideIpSadmin/EventListener/Post.php
library/XenForo/Input.php
library/XenForo/Session.php
library/XenForo/Helper/Ip.php
library/XenForo/Visitor.php
library/ThemeHouse/JoinUserGroup/Listener/LoadClass.php
library/ThemeHouse/Listener/LoadClass.php
library/ThemeHouse/Listener/LoadClass/20150518.php
library/Waindigo/Friends/Listener/LoadClass.php
library/Waindigo/Listener/LoadClass.php
library/Waindigo/Listener/LoadClass/20150106.php
library/SV/ConvEss/Listener.php
library/ThemeHouse/JoinUserGroup/Extend/XenForo/Model/User.php
library/Waindigo/Friends/Extend/XenForo/Model/User.php
library/ModernTank/FakeUserOnline/Model/User.php
library/Brivium/Credits/Model/User.php
library/Brivium/ReferralCreditSystem/Model/User.php
library/Nobita/Teams/XenForo/Model/User.php
library/Nobita/SignatureImage/XenForo/Model/User.php
library/Dark/PostRating/Model/User.php
library/VietXfAdvStats/XenForo/Model/User.php
library/XenCentral/MultiSite/Model/XenForo/User.php
library/XenMoods/XFCP/Model/User.php
library/XenGallery/Model/User.php
library/SV/ConvEss/XenForo/Model/User.php
library/Dark/PostRating/Model.php
library/ExtendPostRating/Model.php
library/XenForo/Helper/Php.php
library/XenForo/Permission.php
library/XenForo/Locale.php
library/ThemeHouse/JoinUserGroup/Listener/ControllerPreDispatch.php
library/ThemeHouse/Listener/ControllerPreDispatch.php
library/ThemeHouse/Listener/ControllerPreDispatch/20150911.php
library/XenForo/ControllerResponse/ReroutePath.php
library/XenForo/ControllerResponse/Abstract.php
library/XenForo/Route/Prefix/Forums.php
library/XenForo/ControllerPublic/Forum.php
library/PrefixEss/Listener.php
library/Andy/SimilarThreadsPlus/Listener.php
library/SV/StickyFirstPost/Listener.php
library/PrefixEss/XenForo/ControllerPublic/Forum.php
library/Nobita/Teams/XenForo/ControllerPublic/Forum.php
library/Andy/SimilarThreadsPlus/ControllerPublic/Forum.php
library/SV/MultiPrefix/XenForo/ControllerPublic/Forum.php
library/SV/StickyFirstPost/XenForo/ControllerPublic/Forum.php
library/XenForo/Model/Thread.php
library/PrefixEss/XenForo/Model/Thread.php
library/Brivium/Credits/ActionHandler/ReadThread/Model/Thread.php
library/Nobita/Teams/XenForo/Model/Thread.php
library/InfisJSC/TopicStarter/Model/Thread.php
library/Dark/PostRating/Model/Thread.php
library/VietXfAdvStats/XenForo/Model/Thread.php
library/XenCentral/MultiSite/Model/XenForo/Thread.php
library/SV/ConvEss/XenForo/Model/Thread.php
library/SV/MultiPrefix/XenForo/Model/Thread.php
library/SV/StickyFirstPost/XenForo/Model/Thread.php
library/PrefixEss/XenForo/Model/ThreadPrefix.php
library/XenCentral/MultiSite/Model/XenForo/ThreadPrefix.php
library/SV/MultiPrefix/XenForo/Model/ThreadPrefix.php
library/XenForo/Model/Forum.php
library/XFA/NodesIconTweak/Listener/Proxy.php
library/PrefixEss/XenForo/Model/Forum.php
library/Nobita/Teams/XenForo/Model/Forum.php
library/XenCentral/MultiSite/Model/XenForo/Forum.php
library/XFA/NodesIconTweak/Model/Forum.php
library/SV/StickyFirstPost/XenForo/Model/Forum.php
library/Nobita/Teams/Model/Team.php
library/Nobita/Teams/Model/Abstract.php
library/XenForo/Helper/String.php
library/Nobita/Teams/Model/MemberRole.php
library/XenForo/Helper/Discussion.php
library/XenForo/Model/Node.php
library/PrefixEss/XenForo/Model/Node.php
library/Nobita/Teams/XenForo/Model/Node.php
library/XenCentral/MultiSite/Model/XenForo/Node.php
library/XFA/NodesIconTweak/Model/Node.php
library/Nobita/Teams/NodeHandler/Forum.php
library/XenForo/NodeHandler/Forum.php
library/XenForo/NodeHandler/Abstract.php
library/XenForo/NodeHandler/Category.php
library/PrefixEss/XenForo/NodeHandler/Forum.php
library/XenForo/NodeHandler/LinkForum.php
library/XenForo/Model/Category.php
library/XenForo/Model/LinkForum.php
library/XenForo/Model/Session.php
library/ModernTank/FakeUserOnline/Model/Session.php
library/Dark/PostRating/Model/Session.php
library/XenCentral/MultiSite/Model/XenForo/Session.php
library/XenForo/ControllerResponse/View.php
library/XenForo/ViewRenderer/HtmlPublic.php
library/XenForo/ViewRenderer/Abstract.php
library/XenForo/Template/Public.php
library/XenForo/Template/Abstract.php
library/XenCentral/Framework/Navigation/Admin.php
library/WidgetFramework/Core.php
library/XenForo/Model/Moderator.php
library/ThemeHouse/JoinUserGroup/Extend/XenForo/Model/Moderator.php
library/Brivium/Credits/Model/Moderator.php
library/XenGallery/Model/Moderator.php
library/XenCentral/MultiSite/Model/WidgetFramework/Widget.php
library/WidgetFramework/Helper/Sort.php
library/XenMoods/Listener/FrontControllerPreView.php
library/XenMoods/Model/Mood.php
library/XenForo/ViewPublic/Forum/List.php
library/XenForo/ViewPublic/Base.php
library/XenForo/View.php
library/HideAddon/Listener/view.php
library/XenCentral/MultiSite/ViewPublic/XenForo/Forum/List.php
library/XenForo/ViewPublic/Helper/Node.php
library/XFA/NodesIconTweak/Listener/Template.php
library/LNBlog/Listener/TemplateHook.php
library/Brivium/Credits/Model/Credit.php
library/Brivium/TableBBCode/EventListeners/Listener.php
library/VietXfAdvStats/Model/GetUserGroup.php
library/WidgetFramework/WidgetRenderer.php
library/WidgetFramework/WidgetRenderer/Threads.php
library/WidgetFramework/WidgetRenderer/ProfilePosts.php
library/WidgetFramework/WidgetRenderer/Template.php
library/WidgetFramework/Model/WidgetRenderer/Template.php
library/WidgetFramework/WidgetRenderer/OnlineStaff.php
library/WidgetFramework/WidgetRenderer/OnlineUsers.php
library/WidgetFramework/WidgetRenderer/Stats.php
library/XenForo/Route/Prefix/Members.php
library/LNBlog/Listener/NavTab.php
library/ThemesCorp/Confessionals/Model/Confessionals.php
library/Siropu/Chat/Helper.php
library/game/Listener.php
library/WidgetFramework/WidgetGroup.php
library/WidgetFramework/WidgetRenderer/TemplateWithoutWrapper.php
library/WidgetFramework/Template/Extended.php
library/Sedo/ToggleME/Listener.php
library/XenForo/Template/FileHandler.php
library/XenForo/Helper/File.php
internal_data/templates/S.1,L.2,forum_list.php
internal_data/templates/S.1,L.2,node_category_level_1.php
library/XenForo/Route/Prefix/Categories.php
internal_data/templates/S.1,L.2,node_forum_level_2.php
library/LNBlog/Model/Entry.php
library/Brivium/ReferralCreditSystem/Model/UserReferral.php
library/HideAddon/Listener/Hook.php
library/Waindigo/Friends/Listener/TemplateHook.php
library/Waindigo/Listener/TemplateHook.php
library/Waindigo/Listener/TemplateHook/20150106.php
library/Waindigo/Listener/Template.php
library/Waindigo/Listener/Template/20150106.php
library/XenMoods/Listener/TemplateHook.php
library/SvgGoUpDown/Listener.php
library/SV/MultiPrefix/Template/Helper.php
library/XenForo/Route/Prefix/Posts.php
library/Waindigo/Friends/Listener/TemplatePostRender.php
library/Waindigo/Listener/TemplatePostRender.php
library/Waindigo/Listener/TemplatePostRender/20150106.php
internal_data/templates/S.1,L.2,node_forum_level_n.php
internal_data/templates/S.1,L.2,node_link_level_n.php
library/XenForo/Route/Prefix/LinkForums.php
internal_data/templates/S.1,L.2,node_category_level_2.php
internal_data/templates/S.1,L.2,node_category_level_n.php
internal_data/templates/S.1,L.2,node_link_level_2.php
library/Siropu/Chat/HelperDevice.php
library/Siropu/Chat/ThirdParty/Mobile_Detect.php
library/Siropu/Chat/Model.php
library/Sedo/ToggleME/Helper/CustomLanguage.php
library/VietXfAdvStats/Option.php
library/XenForo/Model/Avatar.php
internal_data/templates/S.1,L.2,lnblog_sidebar_recent_entries.php
library/LNBlog/Route/Prefix/Entries.php
library/WidgetFramework/Helper/String.php
library/WidgetFramework/Helper/Conditional.php
library/XenForo/Template/Compiler/Function/Helper.php
library/XenForo/Template/Compiler/Function/Interface.php
library/WidgetFramework/Model/Thread.php
library/XenForo/Model/Post.php
library/Nobita/Teams/XenForo/Model/Post.php
library/Asp/OnlineStatus/Model/AspPost.php
library/InfisJSC/TopicStarter/Model/Post.php
library/HideAddon/Model/Post.php
library/Dark/PostRating/Model/Post.php
library/SV/ConvEss/XenForo/Model/Post.php
library/SV/StickyFirstPost/XenForo/Model/Post.php
internal_data/templates/S.1,L.2,wf_widget_threads.php
library/XenForo/Route/Prefix/Threads.php
library/WidgetFramework/Model/ProfilePost.php
library/XenForo/Model/ProfilePost.php
library/XenForo/Model/UserProfile.php
internal_data/templates/S.1,L.2,wf_widget_profile_posts.php
library/XenForo/Route/Prefix/ProfilePosts.php
internal_data/templates/S.1,L.2,_widget_renderer_template_85.php
internal_data/templates/S.1,L.2,wf_widget_online_staff.php
internal_data/templates/S.1,L.2,wf_widget_online_users.php
internal_data/templates/S.1,L.2,wf_widget_stats.php
internal_data/templates/S.1,L.2,wf_widget_wrapper.php
library/WidgetFramework/DataWriter/Widget.php
library/XenForo/DataWriter.php
library/XenForo/Helper/Criteria.php
library/XenForo/Debug.php
internal_data/templates/S.1,L.2,PAGE_CONTAINER.php
library/XenForo/Model/Admin.php
library/Brivium/Credits/Model/Transaction.php
internal_data/templates/S.1,L.2,BRC_moderator_bar.php
internal_data/templates/S.1,L.2,_widget_renderer_template_101.php
library/Siropu/Chat/Callback.php
library/Siropu/Chat/HelperConversations.php
library/XenForo/Helper/Color.php
internal_data/templates/S.1,L.2,siropu_chat.php
library/Siropu/Chat/HelperTemplate.php
internal_data/templates/S.1,L.2,_widget_renderer_template_103.php
internal_data/templates/S.1,L.2,BRRS_sidebar_visitor_panel_stats.php
library/Brivium/ReferralCreditSystem/EventListeners/Helpers.php
internal_data/templates/S.1,L.2,BRC_sidebar_visitor_panel_stats.php
library/Brivium/Credits/Listener/Helpers.php
internal_data/templates/S.1,L.2,dark_postrating_visitor_panel.php
internal_data/templates/S.1,L.2,mood_display.php
internal_data/templates/S.1,L.2,lnblog_tab_links.php
library/LNBlog/Route/Prefix/Blog.php
internal_data/templates/S.1,L.2,tc_confessionals_links.php
internal_data/templates/S.1,L.2,siropu_chat_tab_links.php
internal_data/templates/S.1,L.2,game_navigation.php
internal_data/templates/S.1,L.2,epr_navigation_tab.php
internal_data/templates/S.1,L.2,xengallery_tab_links.php
library/XenGallery/Route/Prefix/Media.php
internal_data/templates/S.1,L.2,Team_navigation_tab_links.php
library/Nobita/Teams/Template/Helper/Core.php
internal_data/templates/S.1,L.2,lnblog_visitor_tab_link.php
internal_data/templates/S.1,L.2,BRRS_navigation_visitor_tab_links2.php
library/Brivium/ReferralCreditSystem/Route/Prefix/Referral.php
internal_data/templates/S.1,L.2,dark_postrating_navigation_visitor_tab.php
internal_data/templates/S.1,L.2,BRC_navigation_visitor_tabs_end.php
library/XenCentral/Framework/Model/Cache.php
internal_data/templates/S.1,L.2,go_up_down.php
library/XenForo/ViewRenderer/Json.php
library/VietXfAdvStats/Renderer.php
internal_data/templates/S.1,L.2,VietXfAdvStats_wrapper.php
internal_data/templates/S.1,L.2,VietXfAdvStats_threads.php
internal_data/templates/S.1,L.2,VietxfAdvStats_threads_recent.php

 

[Smalesh]

давно надо переходить

Нет, надо вот это запрос

SELECT domain.*
FROM xc_mss_domain AS domain
ORDER BY domain.active DESC, domain.title ASC

закешировать

Это в поиск исполнителя, дописать проблемный плагин.

Тогда будет 515 минус 467 запроса = 48 запросов. Дофига, но уже можно танцевать дальше. А в текущем состоянии смена железа - это просто отодвинуть проблему чуть подальше.