SELECT
post.*
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.user_id, post.username, post.post_date,
node.title AS node_title, node.node_name,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
permission.cache_value AS node_permission_cache, session.view_date
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_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 OUTER JOIN xf_session_activity AS session ON post.user_id = session.user_id
WHERE post.post_id IN (144948, 144741, 144592, 144588, 144538, 144445, 144371, 144369, 141423, 141414, 140587, 140552, 140534, 140525, 140456, 140374, 140354, 140351, 139586, 139521, 139520, 139222, 139170, 139169, 139167, 138947, 138931, 138923, 138919, 138917, 138912, 138768, 138766, 138667, 138282, 138198, 137560, 137151, 137148, 137121, 136934, 136463, 136461, 134547, 134539, 133979, 133210, 133209, 133207, 133199, 133107, 132988, 132985, 132654, 132341, 132340, 132337, 132335, 132281, 132279, 132270, 132112, 132085, 131932, 131924, 131682, 131349, 131062, 131061, 131060, 131059, 131045, 130841, 130833, 130757, 130755, 130702, 130696, 130565, 130430, 130234, 130229, 130217, 130105, 130040, 129952, 129940, 129933, 129925, 129740, 129736, 129332, 129330, 129245, 129243, 129227, 129226, 129100, 129092, 129007, 129006, 128930, 128926, 128786, 128774, 128678, 128668, 128665, 128508, 128505, 128502, 128495, 128491, 128487, 128481, 128449, 127695, 127260, 127257, 127255, 127252, 127248, 127245, 127242, 127241, 127239, 127235, 127232, 127174, 127170, 126476, 126474, 126472, 126149, 126142, 126067, 125600, 125516, 125475, 125466, 125377, 125240, 125236, 124732, 124729, 124715, 124703, 124696, 124692, 124342, 124307, 124305, 123803, 123602, 123578, 123507, 123462, 123445, 123390, 123318, 123316, 123144, 122951, 122664, 122345)
Run Time: 0.008925
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY,thread_id_post_date,thread_id_position | PRIMARY | 4 | | 165 | Using where |
SIMPLE | thread | eq_ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | prav110_pravorg.post.thread_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.thread.node_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.post.user_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,prav110_pravorg.thread.node_id | 1 | Using where |
SIMPLE | session | ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.post.user_id | 11 | |
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: [["post",144948],["post",144741],["post",144592],["post",144588],["post",144538],["post",144445],["post",144371],["post",144369],["post",141423],["post",141414],["post",140587],["post",140552],["post",140534],["post",140525],["post",140456],["post",140374],["post",140354],["thread",7242],["post",139586],["post",139521],["post",139520],["post",139222],["post",139170],["post",139169],["post",139167],["post",138947],["post",138931],["post",138923],["post",138919],["thread",7165],["thread",7164],["post",138768],["post",138766],["post",138667],["post",138282],["post",138198],["post",137560],["post",137151],["post",137148],["post",137121],["post",136934],["post",136463],["post",136461],["post",134547],["post",134539],["post",133979],["post",133210],["post",133209],["post",133207],["post",133199],["post",133107],["post",132988],["post",132985],["post",132654],["post",132341],["post",132340],["post",132337],["post",132335],["post",132281],["post",132279],["post",132270],["post",132112],["post",132085],["post",131932],["post",131924],["post",131682],["post",131349],["post",131062],["post",131061],["post",131060],["post",131059],["post",131045],["post",130841],["post",130833],["post",130757],["post",130755],["post",130702],["post",130696],["post",130565],["post",130430],["post",130234],["post",130229],["post",130217],["post",130105],["post",130040],["post",129952],["post",129940],["post",129933],["post",129925],["post",129740],["post",129736],["post",129332],["post",129330],["post",129245],["post",129243],["post",129227],["post",129226],["post",129100],["post",129092],["post",129007],["post",129006],["post",128930],["post",128926],["post",128786],["post",128774],["post",128678],["post",128668],["post",128665],["post",128508],["post",128505],["post",128502],["post",128495],["post",128491],["post",128487],["post",128481],["post",128449],["post",127695],["post",127260],["post",127257],["post",127255],["post",127252],["post",127248],["post",127245],["post",127242],["post",127241],["post",127239],["thread",6608],["thread",6607],["post",127174],["post",127170],["post",126476],["post",126474],["post",126472],["post",126149],["post",126142],["post",126067],["post",125600],["post",125516],["post",125475],["post",125466],["post",125377],["post",125240],["post",125236],["post",124732],["post",124729],["post",124715],["post",124703],["post",124696],["post",124692],["post",124342],["post",124307],["post",124305],["post",123803],["post",123602],["post",123578],["post",123507],["post",123462],["post",123445],["post",123390],["post",123318],["post",123316],["thread",6416],["post",122951],["post",122664],["thread",6387]], 165, user, , {"user_id":6549,"content":false}, date, 0, , [], 0, 1711618951, eb217924b79fd20af03716a39977f529
Run Time: 0.001385