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
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)
WHERE thread.thread_id IN (168074, 103399, 182303, 184135, 185049, 170088, 184936, 176848, 164674, 185245, 185089, 185280, 120624, 184840, 115709, 183427, 184389, 179181, 174285, 183454, 164156, 185172, 163219, 120423, 162541, 118599, 120653, 179359, 180965, 182870, 177159, 179047, 182370, 175441, 183245, 181616, 120233, 184542, 179732, 177616, 174067, 183476, 164764, 183275, 118929, 173664, 123737, 180316, 113234, 183481, 18500, 176198, 121307, 100130, 134745, 185233, 101821, 171756, 181393, 182910, 158420, 184490, 185086, 163791, 120242, 120550, 163352, 183195, 45919, 120380, 185010, 161897, 54091, 121208, 56103, 185174, 181080, 179494, 46648, 162057, 170281, 107704, 120593, 176869, 185059, 120497, 157453, 182974, 121278, 120692, 162551, 162288, 159061, 178012, 149713, 181041, 174404, 180198, 185241, 162535, 120318, 110910, 185269, 183150, 120542, 177292, 175993, 120672, 157460, 185113, 184916, 177558, 182241, 183833, 184933, 53712, 181465, 184468, 58462, 179265, 183064, 184957, 1656, 174525, 184105, 47507, 120634, 162101, 169868, 185175, 185158, 163275, 185013, 162580, 183255, 185281, 182079, 184299, 183134, 167640, 114291, 174542, 158682, 120287, 116239, 179368, 60560, 162049, 178961, 120264, 120506, 180436, 185065, 183386, 96293, 120668, 59956, 182368, 185274, 94015, 185282, 120633, 161347, 137194, 183334, 46078, 120464, 164580, 184676, 184479, 181453, 120317, 185061, 119763, 120458, 185149, 184373, 158919, 120784, 167830, 182561, 120710, 162104, 89972, 160703, 118907, 183043, 121076, 164675, 120745, 179493, 185164, 176582, 120636, 167326, 120772, 120223, 21969, 183434, 58838)
Run Time: 0.000428
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | themainb_tmb_new.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | themainb_tmb_new.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,themainb_tmb_new.thread.node_id | 1 | Using where |
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",168074],["thread",182303],["thread",184135],["thread",170088],["thread",176848],["thread",164674],["thread",185245],["thread",185280],["thread",120624],["thread",184840],["thread",183427],["thread",184389],["thread",179181],["thread",174285],["thread",183454],["thread",164156],["thread",185172],["thread",163219],["thread",120423],["thread",162541],["thread",118599],["thread",120653],["thread",180965],["thread",177159],["thread",179047],["thread",182370],["thread",175441],["thread",183245],["thread",181616],["thread",184542],["thread",179732],["thread",177616],["thread",183476],["thread",183275],["thread",173664],["thread",123737],["thread",180316],["thread",18500],["thread",176198],["thread",121307],["thread",185233],["thread",171756],["thread",181393],["thread",182910],["thread",158420],["thread",184490],["thread",163791],["thread",120242],["thread",120550],["thread",163352],["thread",183195],["thread",45919],["thread",120380],["thread",161897],["thread",54091],["thread",121208],["thread",56103],["thread",185174],["thread",181080],["thread",179494],["thread",46648],["thread",162057],["thread",170281],["thread",107704],["thread",176869],["thread",120497],["thread",157453],["thread",182974],["thread",121278],["thread",120692],["thread",162551],["thread",162288],["thread",149713],["thread",174404],["thread",180198],["thread",162535],["thread",120318],["thread",110910],["thread",185269],["thread",183150],["thread",120542],["thread",177292],["thread",175993],["thread",120672],["thread",157460],["thread",185113],["thread",177558],["thread",182241],["thread",184933],["thread",53712],["thread",184468],["thread",58462],["thread",183064],["thread",184957],["thread",1656],["thread",174525],["thread",184105],["thread",47507],["thread",120634],["thread",162101],["thread",169868],["thread",185175],["thread",185158],["thread",163275],["thread",185013],["thread",162580],["thread",183255],["thread",185281],["thread",182079],["thread",183134],["thread",114291],["thread",174542],["thread",158682],["thread",120287],["thread",179368],["thread",178961],["thread",120264],["thread",120506],["thread",180436],["thread",185065],["thread",183386],["thread",120668],["thread",59956],["thread",182368],["thread",185274],["thread",94015],["thread",185282],["thread",161347],["thread",137194],["thread",183334],["thread",46078],["thread",120464],["thread",184676],["thread",184479],["thread",181453],["thread",120317],["thread",120458],["thread",158919],["thread",120784],["thread",182561],["thread",120710],["thread",162104],["thread",89972],["thread",160703],["thread",118907],["thread",183043],["thread",121076],["thread",185164],["thread",176582],["thread",120636],["thread",167326],["thread",120223],["thread",21969],["thread",183434],["thread",58838]], 155, recent-posts, , [], date, 0, , [], 0, 1714024183, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000698