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 (3711, 3709, 3698, 3691, 3610, 3488, 3473, 3467, 3449, 3442, 3438, 3433, 3421, 3388, 3374, 3355, 3345, 3336, 3320, 3312, 3306, 3288, 3277, 3264, 3258, 3249, 3216, 3207, 3194, 3187, 3175, 3167, 3162, 3154, 3148, 3142, 3127, 3119, 3103, 3093, 3088, 3075, 3058, 3039, 3029, 3026, 3018, 3002, 2997, 2983, 2975, 2968, 2948, 2947, 2938, 2933, 2921, 2912, 2904, 2897, 2895, 2886, 2864, 2855, 2845, 2840, 2832, 2827, 2819, 2803, 2795, 2788, 2782, 2776, 2768, 2759, 2751, 2746, 2736, 2722, 2716, 2710, 2705, 2696, 2684, 2677, 2658, 2645, 2628, 2619, 2613, 2606, 2591, 2585, 2576, 2566, 2562, 2552, 2543, 2537, 2528, 2517, 2513, 2504, 2494, 2489, 2480, 2469, 2461, 2452, 2443, 2434, 2419, 2415, 2408, 2399, 2391, 2362, 2356, 2341, 2338, 2330, 2318, 2310, 2306, 2300, 2291, 2275, 2265, 2256, 2243, 2239, 2231, 2217, 2208, 2199, 2194, 2185, 2178, 2171, 2163, 2159, 2150, 2140, 2132, 2123, 2114, 2106, 2094, 2081, 2075, 2069, 2058, 2044, 2038, 2026, 2021, 2011, 2003, 1986, 1973, 1962, 1954, 1945, 1936, 1924, 1916, 1903, 1873, 1855, 1848, 1842, 1834, 1825, 1815, 1805, 1797, 1787, 1782, 1773, 1265, 1261, 1253, 1245, 1225, 1218, 1210, 1203, 1079, 802, 700, 566, 518, 460, 308, 302, 295, 287, 281, 261)
Run Time: 0.077673
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 | kakatavn_db.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | kakatavn_db.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | kakatavn_db.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kakatavn_db.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: 159, 0, 1738935186, 1738938786, [["thread",3711],["thread",3709],["thread",3698],["thread",3691],["thread",3610],["thread",3488],["thread",3473],["thread",3467],["thread",3449],["thread",3442],["thread",3438],["thread",3433],["thread",3421],["thread",3388],["thread",3374],["thread",3355],["thread",3345],["thread",3336],["thread",3320],["thread",3312],["thread",3306],["thread",3288],["thread",3277],["thread",3264],["thread",3258],["thread",3249],["thread",3216],["thread",3207],["thread",3194],["thread",3187],["thread",3175],["thread",3167],["thread",3162],["thread",3154],["thread",3148],["thread",3142],["thread",3127],["thread",3119],["thread",3103],["thread",3093],["thread",3088],["thread",3075],["thread",3058],["thread",3039],["thread",3029],["thread",3026],["thread",3018],["thread",3002],["thread",2997],["thread",2983],["thread",2975],["thread",2968],["thread",2948],["thread",2947],["thread",2938],["thread",2933],["thread",2921],["thread",2912],["thread",2904],["thread",2897],["thread",2895],["thread",2886],["thread",2864],["thread",2855],["thread",2845],["thread",2840],["thread",2832],["thread",2827],["thread",2819],["thread",2803],["thread",2795],["thread",2788],["thread",2782],["thread",2776],["thread",2768],["thread",2759],["thread",2751],["thread",2746],["thread",2736],["thread",2722],["thread",2716],["thread",2710],["thread",2705],["thread",2696],["thread",2684],["thread",2677],["thread",2658],["thread",2645],["thread",2628],["thread",2619],["thread",2613],["thread",2606],["thread",2591],["thread",2585],["thread",2576],["thread",2566],["thread",2562],["thread",2552],["thread",2543],["thread",2537],["thread",2528],["thread",2517],["thread",2513],["thread",2504],["thread",2494],["thread",2489],["thread",2480],["thread",2469],["thread",2461],["thread",2452],["thread",2443],["thread",2434],["thread",2419],["thread",2415],["thread",2408],["thread",2399],["thread",2391],["thread",2362],["thread",2356],["thread",2341],["thread",2338],["thread",2330],["thread",2318],["thread",2310],["thread",2306],["thread",2300],["thread",2291],["thread",2275],["thread",2265],["thread",2256],["thread",2243],["thread",2239],["thread",2231],["thread",2217],["thread",2208],["thread",2199],["thread",2194],["thread",2185],["thread",2178],["thread",2171],["thread",2163],["thread",2159],["thread",2150],["thread",2140],["thread",2132],["thread",2123],["thread",2114],["thread",2106],["thread",2094],["thread",2081],["thread",2075],["thread",2069],["thread",2058],["thread",2044],["thread",2038],["thread",2026],["thread",2021],["thread",2011],["thread",2003],["thread",1986],["thread",1973],["thread",1962],["thread",1954],["thread",1945],["thread",1936],["thread",1924],["thread",1916],["thread",1903],["thread",1873],["thread",1855],["thread",1848],["thread",1842],["thread",1834],["thread",1825],["thread",1815],["thread",1805],["thread",1797],["thread",1787],["thread",1782],["thread",1773],["thread",1265],["thread",1261],["thread",1253],["thread",1245],["thread",1225],["thread",1218],["thread",1210],["thread",1203],["thread",1079],["thread",802],["thread",700],["thread",566],["thread",518],["thread",460],["thread",308],["thread",302],["thread",295],["thread",287],["thread",281],["thread",261]]
Run Time: 0.001910