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 (2023543, 2015218, 2013657, 2008698, 2003861, 2002544, 1949504, 1949503, 1949502, 1949085, 1949084, 1949083, 1947253, 1947252, 1947251, 1944344, 1944343, 1944340, 1944309, 1943003, 1943002, 1943001, 1942900, 1942898, 1942897, 1942881, 1942880, 1942879, 1942749, 1942748, 1942747, 1942728, 1942727, 1942726, 1942516, 1942515, 1942514, 1940755, 1940753, 1940752, 1940691, 1940689, 1940687, 1940358, 1940357, 1940356, 1940336, 1940335, 1940334, 1940307, 1940304, 1940113, 1940112, 1940111, 1940056, 1940055, 1940054, 1940026, 1940023, 1940021, 1939975, 1939972, 1939971, 1939929, 1939927, 1939897, 1939896, 1939895, 1939858, 1939857, 1939855, 1939789, 1939788, 1939787, 1939772, 1939770, 1939769, 1939720, 1939717, 1939716, 1939681, 1939680, 1939679, 1939630, 1939629, 1939628, 1939604, 1939603, 1939602, 1939577, 1939575, 1939574, 1939514, 1939513, 1939512, 1939456, 1939455, 1939454, 1939412, 1939411, 1939410, 1939382, 1939381, 1939380, 1939356, 1939355, 1939354, 1939310, 1939307, 1939305, 1939276, 1939275, 1939274, 1939252, 1939250, 1939249, 1939185, 1939184, 1939183, 1939031, 1939030, 1939028, 1938950, 1938949, 1938832, 1938831, 1938829, 1938747, 1938745, 1938744, 1938606, 1938604, 1938602, 1938546, 1938545, 1938330, 1938329, 1938328, 1938326, 1938231, 1938229, 1938228, 1938165, 1938164, 1938163, 1938044, 1938042, 1938041, 1938003, 1938000, 1937997, 1937931, 1937930, 1937929, 1937913, 1937912, 1937911, 1937867, 1937866, 1937865, 1937845, 1937844, 1937843, 1937828, 1937827, 1937826, 1937812, 1937810, 1937809, 1937716, 1937715, 1937714, 1937685, 1937684, 1937682, 1937655, 1937654, 1937653, 1937623, 1937622, 1937621, 1937578, 1937577, 1937576, 1937507, 1937506, 1937505, 1937441, 1937440, 1937439, 1937417, 1937416, 1937414, 1937383, 1937382, 1937381, 1937355, 1937354, 1937353, 1937281)
Run Time: 0.054277
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 | dirty.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,dirty.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: 3865, 0, 1713955821, 1713959421, [["thread",2023543],["thread",2015218],["thread",2013657],["thread",2008698],["thread",2003861],["thread",2002544],["thread",1949504],["thread",1949503],["thread",1949502],["thread",1949085],["thread",1949084],["thread",1949083],["thread",1947253],["thread",1947252],["thread",1947251],["thread",1944344],["thread",1944343],["thread",1944340],["thread",1944309],["thread",1943003],["thread",1943002],["thread",1943001],["thread",1942900],["thread",1942898],["thread",1942897],["thread",1942881],["thread",1942880],["thread",1942879],["thread",1942749],["thread",1942748],["thread",1942747],["thread",1942728],["thread",1942727],["thread",1942726],["thread",1942516],["thread",1942515],["thread",1942514],["thread",1940755],["thread",1940753],["thread",1940752],["thread",1940691],["thread",1940689],["thread",1940687],["thread",1940358],["thread",1940357],["thread",1940356],["thread",1940336],["thread",1940335],["thread",1940334],["thread",1940307],["thread",1940304],["thread",1940113],["thread",1940112],["thread",1940111],["thread",1940056],["thread",1940055],["thread",1940054],["thread",1940026],["thread",1940023],["thread",1940021],["thread",1939975],["thread",1939972],["thread",1939971],["thread",1939929],["thread",1939927],["thread",1939897],["thread",1939896],["thread",1939895],["thread",1939858],["thread",1939857],["thread",1939855],["thread",1939789],["thread",1939788],["thread",1939787],["thread",1939772],["thread",1939770],["thread",1939769],["thread",1939720],["thread",1939717],["thread",1939716],["thread",1939681],["thread",1939680],["thread",1939679],["thread",1939630],["thread",1939629],["thread",1939628],["thread",1939604],["thread",1939603],["thread",1939602],["thread",1939577],["thread",1939575],["thread",1939574],["thread",1939514],["thread",1939513],["thread",1939512],["thread",1939456],["thread",1939455],["thread",1939454],["thread",1939412],["thread",1939411],["thread",1939410],["thread",1939382],["thread",1939381],["thread",1939380],["thread",1939356],["thread",1939355],["thread",1939354],["thread",1939310],["thread",1939307],["thread",1939305],["thread",1939276],["thread",1939275],["thread",1939274],["thread",1939252],["thread",1939250],["thread",1939249],["thread",1939185],["thread",1939184],["thread",1939183],["thread",1939031],["thread",1939030],["thread",1939028],["thread",1938950],["thread",1938949],["thread",1938832],["thread",1938831],["thread",1938829],["thread",1938747],["thread",1938745],["thread",1938744],["thread",1938606],["thread",1938604],["thread",1938602],["thread",1938546],["thread",1938545],["thread",1938330],["thread",1938329],["thread",1938328],["thread",1938326],["thread",1938231],["thread",1938229],["thread",1938228],["thread",1938165],["thread",1938164],["thread",1938163],["thread",1938044],["thread",1938042],["thread",1938041],["thread",1938003],["thread",1938000],["thread",1937997],["thread",1937931],["thread",1937930],["thread",1937929],["thread",1937913],["thread",1937912],["thread",1937911],["thread",1937867],["thread",1937866],["thread",1937865],["thread",1937845],["thread",1937844],["thread",1937843],["thread",1937828],["thread",1937827],["thread",1937826],["thread",1937812],["thread",1937810],["thread",1937809],["thread",1937716],["thread",1937715],["thread",1937714],["thread",1937685],["thread",1937684],["thread",1937682],["thread",1937655],["thread",1937654],["thread",1937653],["thread",1937623],["thread",1937622],["thread",1937621],["thread",1937578],["thread",1937577],["thread",1937576],["thread",1937507],["thread",1937506],["thread",1937505],["thread",1937441],["thread",1937440],["thread",1937439],["thread",1937417],["thread",1937416],["thread",1937414],["thread",1937383],["thread",1937382],["thread",1937381],["thread",1937355],["thread",1937354],["thread",1937353],["thread",1937281]]
Run Time: 0.003404