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 (175993, 184916, 168074, 180437, 176198, 182870, 183215, 183427, 179047, 185144, 18500, 120380, 42106, 181393, 179453, 180399, 185241, 165097, 183245, 158682, 162049, 42889, 149713, 184840, 175441, 72104, 185013, 121278, 182358, 174730, 120883, 180965, 185061, 185100, 120653, 56103, 60560, 120534, 185085, 120233, 101821, 185149, 184468, 185245, 183275, 184965, 185189, 185269, 164674, 185174, 162057, 120499, 167483, 120287, 179265, 184542, 59956, 164156, 178120, 48839, 119763, 119078, 121307, 182974, 120317, 120769, 184135, 180329, 157460, 121208, 120242, 120519, 184936, 183476, 150653, 170088, 162552, 184389, 183213, 163352, 174391, 185032, 179368, 182079, 182368, 185049, 148227, 184957, 185065, 185164, 183337, 185239, 120672, 184321, 62550, 185273, 185158, 183833, 182910, 178012, 179308, 174404, 46648, 105104, 183454, 184373, 184315, 183088, 184479, 181465, 54091, 185172, 1656, 162619, 181807, 183481, 120661, 105201, 120357, 174525, 171756, 185274, 118339, 185233, 185262, 182303, 179147, 179911, 145066, 120593, 162541, 84639, 182168, 180316, 113234, 86397, 110910, 178961, 183150, 120999, 120542, 120332, 120458, 100130, 179181, 179359, 174116, 180198, 181040, 60954, 183445, 184516, 120710, 45919, 120680, 182411, 120423, 115709, 121050, 65159, 120349, 121087, 177608, 180771, 143391, 169463, 183194, 169868, 164675, 120772, 160547, 116239, 177478, 183113, 104937, 182985, 173939, 118599, 180797, 162104, 177292, 120238, 120550, 159319, 185264, 119737, 179418, 120296, 120789, 162101, 120506, 184961, 183195, 181603, 184562, 120497, 159929, 75830, 162023, 94015)
Run Time: 0.001541
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",175993],["thread",168074],["thread",180437],["thread",176198],["thread",183427],["thread",179047],["thread",18500],["thread",120380],["thread",42106],["thread",181393],["thread",179453],["thread",180399],["thread",165097],["thread",183245],["thread",158682],["thread",42889],["thread",149713],["thread",184840],["thread",175441],["thread",72104],["thread",185013],["thread",121278],["thread",182358],["thread",174730],["thread",120883],["thread",180965],["thread",185100],["thread",120653],["thread",56103],["thread",120534],["thread",185085],["thread",184468],["thread",185245],["thread",183275],["thread",185189],["thread",185269],["thread",164674],["thread",185174],["thread",162057],["thread",120499],["thread",167483],["thread",120287],["thread",184542],["thread",59956],["thread",164156],["thread",178120],["thread",48839],["thread",119078],["thread",121307],["thread",182974],["thread",120317],["thread",120769],["thread",184135],["thread",180329],["thread",157460],["thread",121208],["thread",120242],["thread",120519],["thread",183476],["thread",150653],["thread",170088],["thread",162552],["thread",184389],["thread",183213],["thread",163352],["thread",174391],["thread",179368],["thread",182079],["thread",182368],["thread",148227],["thread",184957],["thread",185065],["thread",185164],["thread",183337],["thread",185239],["thread",120672],["thread",184321],["thread",62550],["thread",185273],["thread",185158],["thread",182910],["thread",179308],["thread",174404],["thread",46648],["thread",183454],["thread",184315],["thread",183088],["thread",184479],["thread",54091],["thread",185172],["thread",1656],["thread",162619],["thread",181807],["thread",120661],["thread",174525],["thread",171756],["thread",185274],["thread",118339],["thread",185233],["thread",185262],["thread",182303],["thread",179147],["thread",179911],["thread",145066],["thread",162541],["thread",84639],["thread",182168],["thread",180316],["thread",86397],["thread",110910],["thread",178961],["thread",183150],["thread",120999],["thread",120542],["thread",120332],["thread",120458],["thread",179181],["thread",174116],["thread",180198],["thread",181040],["thread",60954],["thread",183445],["thread",184516],["thread",120710],["thread",45919],["thread",120680],["thread",182411],["thread",120423],["thread",121050],["thread",65159],["thread",120349],["thread",177608],["thread",180771],["thread",143391],["thread",183194],["thread",169868],["thread",160547],["thread",177478],["thread",183113],["thread",104937],["thread",173939],["thread",118599],["thread",180797],["thread",162104],["thread",177292],["thread",120238],["thread",120550],["thread",159319],["thread",185264],["thread",179418],["thread",120296],["thread",120789],["thread",162101],["thread",120506],["thread",183195],["thread",120497],["thread",75830],["thread",162023],["thread",94015]], 159, recent-posts, , [], date, 0, , [], 0, 1713560419, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000557