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 (179047, 181603, 184373, 162552, 184542, 184562, 183476, 120506, 174404, 120772, 184389, 185245, 170088, 184516, 184965, 182303, 121208, 162541, 164674, 164156, 185061, 178012, 185262, 176198, 120296, 120550, 179359, 179147, 60560, 185269, 120349, 168074, 120242, 182910, 121307, 162101, 182368, 183195, 121278, 149713, 120380, 184479, 42889, 116239, 120497, 159929, 120423, 177292, 18500, 75830, 162023, 175441, 181393, 185149, 94015, 184916, 158682, 181807, 184840, 182130, 174391, 185264, 164580, 185174, 120542, 185241, 120458, 119737, 185049, 183481, 178134, 183833, 120317, 183427, 118599, 184490, 173939, 120789, 185172, 86397, 181040, 120672, 164640, 171756, 59997, 59956, 182827, 184936, 170171, 160069, 89972, 44033, 177886, 120464, 103399, 120653, 120357, 118929, 174525, 97277, 183194, 184135, 180965, 183275, 184957, 185085, 118907, 180316, 120633, 101821, 182974, 184961, 177159, 181041, 175993, 175909, 120659, 178082, 181368, 185065, 177608, 162057, 120499, 185273, 184299, 180483, 185272, 120769, 120238, 166452, 111730, 164806, 134745, 157460, 162535, 179911, 120661, 158493, 185055, 185010, 180329, 74, 182870, 160703, 179732, 183113, 161897, 120318, 179265, 183995, 178918, 62550, 177478, 183267, 54091, 179181, 185270, 183053, 163219, 105201, 120321, 185233, 120860, 129282, 182811, 169799, 45919, 183245, 120233, 185013, 56414, 118339, 143391, 56103, 181879, 120300, 105482, 115709, 123737, 113766, 159000, 42106, 185266, 182575, 96293, 120680, 181465, 184169, 183150, 46648, 120250, 169868, 162580, 171115, 162049, 110889, 176582, 184447, 120593, 182180)
Run Time: 0.001537
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",179047],["thread",162552],["thread",184542],["thread",183476],["thread",120506],["thread",174404],["thread",184389],["thread",185245],["thread",170088],["thread",184516],["thread",182303],["thread",121208],["thread",162541],["thread",164674],["thread",164156],["thread",185262],["thread",176198],["thread",120296],["thread",120550],["thread",179147],["thread",185269],["thread",120349],["thread",168074],["thread",120242],["thread",182910],["thread",121307],["thread",162101],["thread",182368],["thread",183195],["thread",121278],["thread",149713],["thread",120380],["thread",184479],["thread",42889],["thread",120497],["thread",120423],["thread",177292],["thread",18500],["thread",75830],["thread",162023],["thread",175441],["thread",181393],["thread",94015],["thread",158682],["thread",181807],["thread",184840],["thread",174391],["thread",185264],["thread",185174],["thread",120542],["thread",120458],["thread",178134],["thread",120317],["thread",183427],["thread",118599],["thread",184490],["thread",173939],["thread",120789],["thread",185172],["thread",86397],["thread",181040],["thread",120672],["thread",171756],["thread",59956],["thread",182827],["thread",170171],["thread",160069],["thread",89972],["thread",44033],["thread",177886],["thread",120464],["thread",120653],["thread",174525],["thread",97277],["thread",183194],["thread",184135],["thread",180965],["thread",183275],["thread",184957],["thread",185085],["thread",118907],["thread",180316],["thread",182974],["thread",177159],["thread",175993],["thread",175909],["thread",120659],["thread",178082],["thread",185065],["thread",177608],["thread",162057],["thread",120499],["thread",185273],["thread",180483],["thread",185272],["thread",120769],["thread",120238],["thread",111730],["thread",164806],["thread",157460],["thread",162535],["thread",179911],["thread",120661],["thread",158493],["thread",185055],["thread",180329],["thread",160703],["thread",179732],["thread",183113],["thread",161897],["thread",120318],["thread",183995],["thread",178918],["thread",62550],["thread",177478],["thread",183267],["thread",54091],["thread",179181],["thread",185270],["thread",183053],["thread",163219],["thread",120321],["thread",185233],["thread",120860],["thread",129282],["thread",182811],["thread",169799],["thread",45919],["thread",183245],["thread",185013],["thread",56414],["thread",118339],["thread",143391],["thread",56103],["thread",181879],["thread",120300],["thread",105482],["thread",123737],["thread",113766],["thread",42106],["thread",185266],["thread",182575],["thread",120680],["thread",183150],["thread",46648],["thread",169868],["thread",162580],["thread",110889],["thread",176582],["thread",184447],["thread",182180]], 151, recent-posts, , [], date, 0, , [], 0, 1713472701, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000744