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 (18515, 18514, 18513, 18512, 18509, 18508, 18507, 18506, 18505, 18504, 18503, 18502, 18501, 18500, 18499, 18487, 18486, 18483, 18471, 18470, 18469, 18468, 18467, 18466, 18465, 18464, 18463, 18462, 18461, 18460, 18459, 18452, 18451, 18450, 18449, 18448, 18447, 18446, 18445, 18444, 18443, 18442, 18441, 18440, 18439, 18438, 18437, 18436, 18434, 18433, 18432, 18431, 18430, 18429, 18428, 18427, 18426, 18425, 18424, 18422, 18421, 18420, 18419, 18418, 18417, 18416, 18415, 18414, 18413, 18412, 18411, 18410, 18409, 18408, 18407, 18406, 18405, 18404, 18403, 18402, 18401, 18400, 18399, 18398, 18397, 18396, 18395, 18394, 18380, 18379, 18378, 18377, 18376, 18375, 18374, 18373, 18372, 18371, 18370, 18369, 18368, 18367, 18366, 18365, 18364, 18363, 18362, 18361, 18360, 18359, 18358, 18357, 18356, 18355, 18354, 18353, 18352, 18351, 18350, 18349, 18346, 18345, 18344, 18343, 18341, 18340, 18339, 18337, 18336, 18335, 18334, 18333, 18332, 18331, 18330, 18329, 18328, 18327, 18326, 18325, 18324, 18323, 18322, 18321, 18320, 18319, 18318, 18317, 18316, 18315, 18314, 18313, 18312, 18304, 18303, 18302, 18301, 18300, 18299, 18298, 18297, 18296, 18295, 18294, 18293, 18292, 18291, 18290, 18289, 18288, 18287, 18286, 18285, 18284, 18283, 18282, 18281, 18280, 18279, 18276, 18275, 18274, 18273, 18260, 18258, 18257, 18256, 18255, 18254, 18253, 18252, 18251, 18250, 18249, 18248, 18247, 18246, 18244, 18243, 18240)
Run Time: 0.047618
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: 1909, 0, 1714712550, 1714716150, [["thread",18515],["thread",18514],["thread",18513],["thread",18512],["thread",18509],["thread",18508],["thread",18507],["thread",18506],["thread",18505],["thread",18504],["thread",18503],["thread",18502],["thread",18501],["thread",18500],["thread",18499],["thread",18487],["thread",18486],["thread",18483],["thread",18471],["thread",18470],["thread",18469],["thread",18468],["thread",18467],["thread",18466],["thread",18465],["thread",18464],["thread",18463],["thread",18462],["thread",18461],["thread",18460],["thread",18459],["thread",18452],["thread",18451],["thread",18450],["thread",18449],["thread",18448],["thread",18447],["thread",18446],["thread",18445],["thread",18444],["thread",18443],["thread",18442],["thread",18441],["thread",18440],["thread",18439],["thread",18438],["thread",18437],["thread",18436],["thread",18434],["thread",18433],["thread",18432],["thread",18431],["thread",18430],["thread",18429],["thread",18428],["thread",18427],["thread",18426],["thread",18425],["thread",18424],["thread",18422],["thread",18421],["thread",18420],["thread",18419],["thread",18418],["thread",18417],["thread",18416],["thread",18415],["thread",18414],["thread",18413],["thread",18412],["thread",18411],["thread",18410],["thread",18409],["thread",18408],["thread",18407],["thread",18406],["thread",18405],["thread",18404],["thread",18403],["thread",18402],["thread",18401],["thread",18400],["thread",18399],["thread",18398],["thread",18397],["thread",18396],["thread",18395],["thread",18394],["thread",18380],["thread",18379],["thread",18378],["thread",18377],["thread",18376],["thread",18375],["thread",18374],["thread",18373],["thread",18372],["thread",18371],["thread",18370],["thread",18369],["thread",18368],["thread",18367],["thread",18366],["thread",18365],["thread",18364],["thread",18363],["thread",18362],["thread",18361],["thread",18360],["thread",18359],["thread",18358],["thread",18357],["thread",18356],["thread",18355],["thread",18354],["thread",18353],["thread",18352],["thread",18351],["thread",18350],["thread",18349],["thread",18346],["thread",18345],["thread",18344],["thread",18343],["thread",18341],["thread",18340],["thread",18339],["thread",18337],["thread",18336],["thread",18335],["thread",18334],["thread",18333],["thread",18332],["thread",18331],["thread",18330],["thread",18329],["thread",18328],["thread",18327],["thread",18326],["thread",18325],["thread",18324],["thread",18323],["thread",18322],["thread",18321],["thread",18320],["thread",18319],["thread",18318],["thread",18317],["thread",18316],["thread",18315],["thread",18314],["thread",18313],["thread",18312],["thread",18304],["thread",18303],["thread",18302],["thread",18301],["thread",18300],["thread",18299],["thread",18298],["thread",18297],["thread",18296],["thread",18295],["thread",18294],["thread",18293],["thread",18292],["thread",18291],["thread",18290],["thread",18289],["thread",18288],["thread",18287],["thread",18286],["thread",18285],["thread",18284],["thread",18283],["thread",18282],["thread",18281],["thread",18280],["thread",18279],["thread",18276],["thread",18275],["thread",18274],["thread",18273],["thread",18260],["thread",18258],["thread",18257],["thread",18256],["thread",18255],["thread",18254],["thread",18253],["thread",18252],["thread",18251],["thread",18250],["thread",18249],["thread",18248],["thread",18247],["thread",18246],["thread",18244],["thread",18243],["thread",18240]]
Run Time: 0.002199