SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
post.message, post.attach_count,
NULL AS thread_read_date,
0 AS user_post_count,
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_post AS post ON
(post.post_id = thread.first_post_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 (15730, 15729, 15728, 15706, 15701, 15677, 15643, 15642, 15641, 15634, 15632, 15626, 15623, 15622, 15620, 15616, 15610, 15609, 15607, 15606, 15605, 15603, 15602, 15601, 15600, 15599, 15598, 15596, 15591, 15586, 15583, 15582, 15579, 15578, 15577, 15576, 15575, 15570, 15569, 15560, 15552, 15551, 15550, 15540, 15539, 15536, 15535, 15534, 15533, 15524, 15523, 15522, 15513, 15512, 15511, 15510, 15505, 15504, 15503, 15500, 15499, 15498, 15488, 15487, 15486, 15485, 15484, 15481, 15480, 15479, 15478, 15472, 15470, 15469, 15468, 15467, 15464, 15460, 15457, 15456, 15455, 15454, 15453, 15452, 15449, 15447, 15446, 15445, 15440, 15438, 15437, 15431, 15430, 15428, 15427, 15424, 15423, 15422, 15416, 15415, 15407, 15405, 15404, 15403, 15401, 15395, 15392, 15391, 15390, 15387, 15385, 15384, 15383, 15378, 15377, 15376, 15370, 15368, 15366, 15365, 15363, 15359, 15357, 15356, 15355, 15354, 15353, 15352, 15347, 15346, 15345, 15343, 15342, 15341, 15338, 15337, 15336, 15335, 15334, 15333, 15327, 15326, 15325, 15324, 15323, 15317, 15311, 15310, 15309, 15308, 15306, 15305, 15304, 15303, 15302, 15301, 15299, 15296, 15293, 15292, 15290, 15289, 15288, 15287, 15286, 15285, 15284, 15281, 15280, 15279, 15278, 15277, 15276, 15272, 15270, 15269, 15268, 15267, 15266, 15265, 15260, 15258, 15257, 15256, 15253, 15252, 15251, 15238, 15237, 15236, 15230, 15228, 15227, 15226, 15225, 15224, 15222, 15220, 15219, 15218)
Run Time: 0.022579
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 | chanpro.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | chanpro.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | chanpro.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chanpro.thread.node_id | 1 | Using where |
INSERT INTO xf_tag_result_cache
(tag_id, user_id, cache_date, expiry_date, results)
VALUES
(?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
cache_date = VALUES(cache_date),
expiry_date = VALUES(expiry_date),
results = VALUES(results)
Params: 1770, 0, 1714626790, 1714630390, [["thread",15730],["thread",15729],["thread",15728],["thread",15706],["thread",15701],["thread",15677],["thread",15643],["thread",15642],["thread",15641],["thread",15634],["thread",15632],["thread",15626],["thread",15623],["thread",15622],["thread",15620],["thread",15616],["thread",15610],["thread",15609],["thread",15607],["thread",15606],["thread",15605],["thread",15603],["thread",15602],["thread",15601],["thread",15600],["thread",15599],["thread",15598],["thread",15596],["thread",15591],["thread",15586],["thread",15583],["thread",15582],["thread",15579],["thread",15578],["thread",15577],["thread",15576],["thread",15575],["thread",15570],["thread",15569],["thread",15560],["thread",15552],["thread",15551],["thread",15550],["thread",15540],["thread",15539],["thread",15536],["thread",15535],["thread",15534],["thread",15533],["thread",15524],["thread",15523],["thread",15522],["thread",15513],["thread",15512],["thread",15511],["thread",15510],["thread",15505],["thread",15504],["thread",15503],["thread",15500],["thread",15499],["thread",15498],["thread",15488],["thread",15487],["thread",15486],["thread",15485],["thread",15484],["thread",15481],["thread",15480],["thread",15479],["thread",15478],["thread",15472],["thread",15470],["thread",15469],["thread",15468],["thread",15467],["thread",15464],["thread",15460],["thread",15457],["thread",15456],["thread",15455],["thread",15454],["thread",15453],["thread",15452],["thread",15449],["thread",15447],["thread",15446],["thread",15445],["thread",15440],["thread",15438],["thread",15437],["thread",15431],["thread",15430],["thread",15428],["thread",15427],["thread",15424],["thread",15423],["thread",15422],["thread",15416],["thread",15415],["thread",15407],["thread",15405],["thread",15404],["thread",15403],["thread",15401],["thread",15395],["thread",15392],["thread",15391],["thread",15390],["thread",15387],["thread",15385],["thread",15384],["thread",15383],["thread",15378],["thread",15377],["thread",15376],["thread",15370],["thread",15368],["thread",15366],["thread",15365],["thread",15363],["thread",15359],["thread",15357],["thread",15356],["thread",15355],["thread",15354],["thread",15353],["thread",15352],["thread",15347],["thread",15346],["thread",15345],["thread",15343],["thread",15342],["thread",15341],["thread",15338],["thread",15337],["thread",15336],["thread",15335],["thread",15334],["thread",15333],["thread",15327],["thread",15326],["thread",15325],["thread",15324],["thread",15323],["thread",15317],["thread",15311],["thread",15310],["thread",15309],["thread",15308],["thread",15306],["thread",15305],["thread",15304],["thread",15303],["thread",15302],["thread",15301],["thread",15299],["thread",15296],["thread",15293],["thread",15292],["thread",15290],["thread",15289],["thread",15288],["thread",15287],["thread",15286],["thread",15285],["thread",15284],["thread",15281],["thread",15280],["thread",15279],["thread",15278],["thread",15277],["thread",15276],["thread",15272],["thread",15270],["thread",15269],["thread",15268],["thread",15267],["thread",15266],["thread",15265],["thread",15260],["thread",15258],["thread",15257],["thread",15256],["thread",15253],["thread",15252],["thread",15251],["thread",15238],["thread",15237],["thread",15236],["thread",15230],["thread",15228],["thread",15227],["thread",15226],["thread",15225],["thread",15224],["thread",15222],["thread",15220],["thread",15219],["thread",15218]]
Run Time: 0.001401