SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
permission.cache_value AS node_permission_cache,
uix_last_post_user.avatar_date AS uix_last_post_user_avatar_date,
uix_last_post_user.username AS uix_last_post_user_username,
uix_last_post_user.avatar_width AS uix_last_post_user_avatar_width,
uix_last_post_user.avatar_height AS uix_last_post_user_avatar_height,
uix_last_post_user.gravatar AS uix_last_post_user_gravatar,
uix_last_post_user.gender AS uix_last_post_user_gender,
uix_last_post_user.is_banned AS uix_last_post_user_is_banned
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)LEFT JOIN xf_user AS uix_last_post_user ON (uix_last_post_user.user_id = thread.last_post_user_id)
WHERE thread.thread_id IN (62939, 62928, 62937, 62935, 62938, 62828, 42566, 62924, 62498, 62933, 62915, 62873, 62875, 62541, 62925, 62931, 62934, 62806, 62881, 60117, 59900, 62906, 62929, 62932, 62930, 62923, 62927, 62902, 62920, 62879, 57014, 62339, 62918, 62917, 62922, 62805, 27928, 62921, 57481, 26602, 34808, 59109, 62913, 61415, 20705, 62919, 57053, 29003, 62914, 60804, 62912, 62916, 51422, 62905, 62910, 57313, 62911, 62909, 62908, 62812, 62889, 62907, 62864, 62492, 62903, 62900, 62888, 62904, 62894, 62899, 62897, 62901, 62898, 62887, 61748, 62857, 62895, 62896, 61826, 62893, 62160, 62892, 62808, 60638, 62874, 62891, 62890, 62596, 62885, 62515, 62886, 62883, 62880, 61490, 62807, 62882, 10357, 62878, 62876, 62865, 62863)
Run Time: 0.003452
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 101 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,degreeinfo_xenforo.thread.node_id | 1 | Using where |
SIMPLE | uix_last_post_user | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.thread.last_post_user_id | 1 | |
INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: [["thread",62939],["thread",62928],["thread",62937],["thread",62935],["thread",62938],["thread",62828],["thread",42566],["thread",62924],["thread",62498],["thread",62933],["thread",62915],["thread",62873],["thread",62875],["thread",62541],["thread",62925],["thread",62931],["thread",62934],["thread",62806],["thread",62881],["thread",60117],["thread",59900],["thread",62906],["thread",62929],["thread",62932],["thread",62930],["thread",62923],["thread",62927],["thread",62902],["thread",62920],["thread",62879],["thread",57014],["thread",62339],["thread",62918],["thread",62917],["thread",62922],["thread",62805],["thread",27928],["thread",62921],["thread",57481],["thread",26602],["thread",34808],["thread",59109],["thread",62913],["thread",61415],["thread",20705],["thread",62919],["thread",57053],["thread",29003],["thread",62914],["thread",60804],["thread",62912],["thread",62916],["thread",51422],["thread",62905],["thread",62910],["thread",57313],["thread",62911],["thread",62909],["thread",62908],["thread",62812],["thread",62889],["thread",62907],["thread",62864],["thread",62492],["thread",62903],["thread",62900],["thread",62888],["thread",62904],["thread",62894],["thread",62899],["thread",62897],["thread",62901],["thread",62898],["thread",62887],["thread",61748],["thread",62857],["thread",62895],["thread",62896],["thread",61826],["thread",62893],["thread",62160],["thread",62892],["thread",62808],["thread",60638],["thread",62874],["thread",62891],["thread",62890],["thread",62596],["thread",62885],["thread",62515],["thread",62886],["thread",62883],["thread",62880],["thread",61490],["thread",62807],["thread",62882],["thread",10357],["thread",62878],["thread",62876],["thread",62865],["thread",62863]], 101, recent-posts, , [], date, 0, , [], 0, 1716131302, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000895