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 (176198, 183476, 183245, 120380, 178012, 179265, 162541, 168074, 62550, 182870, 170088, 184840, 184516, 164156, 180316, 164674, 179047, 179359, 185061, 120772, 185049, 185241, 185065, 182811, 184542, 120464, 118339, 120550, 45919, 183427, 120789, 182910, 162580, 185174, 134745, 178918, 179732, 120317, 175993, 171115, 42106, 184916, 162049, 158682, 185010, 110889, 184135, 42889, 184961, 120680, 185085, 163219, 143391, 182974, 176582, 181465, 184447, 120593, 182180, 100130, 179652, 115709, 185013, 183685, 183833, 181393, 183150, 120349, 185269, 166440, 181603, 177292, 65950, 120300, 162101, 185262, 180965, 175441, 168293, 120542, 120332, 184936, 183481, 120653, 155733, 182434, 185245, 176839, 183275, 184389, 101821, 121278, 183195, 179368, 118907, 182079, 169868, 119737, 120672, 181879, 179418, 184771, 182985, 184479, 185164, 120659, 18500, 120506, 113234, 181691, 179181, 161897, 54091, 169799, 120999, 120519, 184373, 120357, 158662, 157460, 185172, 181608, 162535, 185131, 182827, 183454, 180399, 185267, 70592, 120710, 121229, 120769, 59997, 181525, 56753, 121307, 183113, 158332, 185086, 184897, 170281, 177278, 120242, 120668, 178961, 158420, 162057, 113149, 21969, 184811, 53394, 162264, 120928, 159000, 163791, 164640, 180280, 47507, 120533, 149713, 105201, 96293, 182020, 46973, 182303, 168052, 137194, 174551, 184798, 120250, 183952, 118929, 184490, 177478, 114291, 182706, 46648, 184524, 164108, 185089, 185271, 120589, 163352, 158493, 185060, 118082, 37311, 161114, 172419, 161169, 163422, 160703, 185264, 60114, 120497, 182575, 159296, 120223, 183043, 171743)
Run Time: 0.001115
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",176198],["thread",183476],["thread",183245],["thread",120380],["thread",162541],["thread",168074],["thread",62550],["thread",170088],["thread",184840],["thread",184516],["thread",164156],["thread",180316],["thread",164674],["thread",179047],["thread",185065],["thread",182811],["thread",184542],["thread",120464],["thread",118339],["thread",120550],["thread",45919],["thread",183427],["thread",120789],["thread",182910],["thread",162580],["thread",185174],["thread",178918],["thread",179732],["thread",120317],["thread",175993],["thread",42106],["thread",158682],["thread",110889],["thread",184135],["thread",42889],["thread",120680],["thread",185085],["thread",163219],["thread",143391],["thread",182974],["thread",176582],["thread",184447],["thread",182180],["thread",179652],["thread",185013],["thread",183685],["thread",181393],["thread",183150],["thread",120349],["thread",185269],["thread",177292],["thread",120300],["thread",162101],["thread",185262],["thread",180965],["thread",175441],["thread",168293],["thread",120542],["thread",120332],["thread",120653],["thread",155733],["thread",182434],["thread",185245],["thread",176839],["thread",183275],["thread",184389],["thread",121278],["thread",183195],["thread",179368],["thread",118907],["thread",182079],["thread",169868],["thread",120672],["thread",181879],["thread",179418],["thread",184771],["thread",184479],["thread",185164],["thread",120659],["thread",18500],["thread",120506],["thread",181691],["thread",179181],["thread",161897],["thread",54091],["thread",169799],["thread",120999],["thread",120519],["thread",158662],["thread",157460],["thread",185172],["thread",181608],["thread",162535],["thread",182827],["thread",183454],["thread",180399],["thread",185267],["thread",70592],["thread",120710],["thread",121229],["thread",120769],["thread",181525],["thread",56753],["thread",121307],["thread",183113],["thread",158332],["thread",170281],["thread",177278],["thread",120242],["thread",120668],["thread",178961],["thread",158420],["thread",162057],["thread",113149],["thread",21969],["thread",53394],["thread",162264],["thread",120928],["thread",163791],["thread",180280],["thread",47507],["thread",120533],["thread",149713],["thread",182020],["thread",46973],["thread",182303],["thread",168052],["thread",137194],["thread",174551],["thread",184798],["thread",183952],["thread",184490],["thread",177478],["thread",114291],["thread",182706],["thread",46648],["thread",184524],["thread",164108],["thread",120589],["thread",163352],["thread",158493],["thread",37311],["thread",161114],["thread",172419],["thread",161169],["thread",163422],["thread",160703],["thread",185264],["thread",120497],["thread",182575],["thread",159296],["thread",120223],["thread",183043],["thread",171743]], 154, recent-posts, , [], date, 0, , [], 0, 1713384268, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000897