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 (23482, 23467, 23477, 23481, 23469, 23241, 23210, 23472, 22521, 23480, 23404, 23476, 23474, 23461, 23372, 21804, 13871, 23237, 23393, 23463, 22956, 23471, 23475, 23479, 8124, 21959, 23470, 23456, 14365, 23473, 23466, 2410, 23247, 15161, 23464, 23376, 23426, 23458, 23453, 23455, 23465, 23462, 23367, 23432, 23379, 23408, 23460, 18750, 23443, 23459, 22791, 23457, 23401, 23445, 23415, 23449, 23405, 23430, 23454, 23325, 23450, 23448, 22286, 23452, 23451, 22960, 23263, 19851, 20471, 23446, 23435, 20453, 23434, 23447, 15240, 23417, 22939, 23444, 23388, 22153, 23437, 23021, 16736, 14522, 20386, 15111, 15231, 23007, 20448, 20443, 23438, 23032, 23431, 23266, 23018, 23436, 23422, 23433, 23364, 22952, 23412, 23200, 23409, 23384, 23429, 23203, 23406, 23428, 23424, 23414, 23425, 23423, 23413, 23344, 23411, 23403, 23378, 23399, 23419, 23410, 23312, 23381, 23217, 23366, 23407, 23336, 23343, 22609, 23398, 23402, 23331, 23400, 21928, 23397, 23390, 23396, 23395, 23163, 23394, 23392, 23380, 23383, 23386, 21757, 20706, 22460, 23321, 23389, 23391, 23385, 23387, 23347, 23382, 23377, 23369, 23370, 23374, 23202, 23375, 23373, 23305, 23371, 23363, 23368, 23299, 23333, 22833, 23365, 23355, 23358, 23356, 21726, 23362, 23357, 23337, 23346, 23361, 23360, 23359, 23311, 23354, 16886, 23296, 23318, 23341, 23353, 23254, 23339, 23023, 23352, 23240, 23351, 23349, 23350, 23338, 23249, 23345, 20261, 23214, 22425)
Run Time: 0.003989
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 | bar_production.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | bar_production.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,bar_production.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",23482],["thread",23467],["thread",23477],["thread",23481],["thread",23469],["thread",23241],["thread",23472],["thread",22521],["thread",23404],["thread",23476],["thread",23474],["thread",23372],["thread",21804],["thread",13871],["thread",23237],["thread",23393],["thread",23463],["thread",22956],["thread",23471],["thread",23475],["thread",23479],["thread",8124],["thread",21959],["thread",23470],["thread",23456],["thread",14365],["thread",23466],["thread",2410],["thread",23247],["thread",15161],["thread",23464],["thread",23376],["thread",23426],["thread",23458],["thread",23453],["thread",23455],["thread",23465],["thread",23462],["thread",23367],["thread",23432],["thread",23379],["thread",23408],["thread",23460],["thread",18750],["thread",23443],["thread",23459],["thread",22791],["thread",23457],["thread",23445],["thread",23415],["thread",23449],["thread",23405],["thread",23430],["thread",23454],["thread",23325],["thread",23450],["thread",23448],["thread",22286],["thread",23452],["thread",23451],["thread",22960],["thread",19851],["thread",20471],["thread",23446],["thread",23435],["thread",20453],["thread",23434],["thread",23447],["thread",15240],["thread",23417],["thread",22939],["thread",23444],["thread",23388],["thread",22153],["thread",23437],["thread",23021],["thread",16736],["thread",14522],["thread",20386],["thread",15111],["thread",15231],["thread",23007],["thread",20448],["thread",20443],["thread",23438],["thread",23032],["thread",23431],["thread",23266],["thread",23018],["thread",23436],["thread",23422],["thread",23433],["thread",23364],["thread",22952],["thread",23200],["thread",23409],["thread",23384],["thread",23429],["thread",23203],["thread",23406],["thread",23428],["thread",23424],["thread",23414],["thread",23425],["thread",23423],["thread",23413],["thread",23344],["thread",23411],["thread",23403],["thread",23378],["thread",23399],["thread",23419],["thread",23410],["thread",23312],["thread",23366],["thread",23407],["thread",23336],["thread",23343],["thread",22609],["thread",23398],["thread",23402],["thread",23331],["thread",23400],["thread",21928],["thread",23397],["thread",23390],["thread",23396],["thread",23163],["thread",23394],["thread",23392],["thread",23380],["thread",21757],["thread",20706],["thread",22460],["thread",23321],["thread",23389],["thread",23391],["thread",23387],["thread",23347],["thread",23382],["thread",23377],["thread",23369],["thread",23370],["thread",23374],["thread",23202],["thread",23375],["thread",23373],["thread",23305],["thread",23371],["thread",23363],["thread",23368],["thread",23299],["thread",23333],["thread",22833],["thread",23365],["thread",23355],["thread",23358],["thread",23356],["thread",21726],["thread",23362],["thread",23357],["thread",23337],["thread",23346],["thread",23361],["thread",23360],["thread",23359],["thread",23311],["thread",23354],["thread",16886],["thread",23296],["thread",23318],["thread",23341],["thread",23353],["thread",23254],["thread",23339],["thread",23023],["thread",23352],["thread",23240],["thread",23351],["thread",23349],["thread",23350],["thread",23338],["thread",23249],["thread",23345],["thread",20261],["thread",23214],["thread",22425]], 187, recent-posts, , [], date, 0, , [], 0, 1550699558, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.001885