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 (2686, 2675, 2674, 2673, 2427, 2426, 2423, 2422, 2421, 2420, 2394, 2393, 2338, 2337, 2333, 2315, 2314, 2313, 2312, 2311, 2309, 2298, 2214, 2194, 2185, 2184, 2183, 2182, 2181, 2180, 2179, 2178, 2177, 2176, 2175, 2173, 2172, 2163, 2162, 2161, 2160, 2159, 2158, 2157, 2153, 2151, 2150, 2149, 2148, 2147, 2134, 2133, 2132, 2131, 2130, 2129, 2126, 2103, 2102, 2100, 2099, 2098, 2097, 2096, 2095, 2094, 2093, 2092, 2081, 1997, 1996, 1983, 1982, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1888, 1826, 1678, 1677, 1676, 1675, 1674, 1673, 1672, 1662, 1660, 1659, 1658, 1657, 1656, 1655, 1643, 1619, 1618, 1616, 1615, 1614, 1613, 1612, 1611, 1610, 1577, 1566, 1564, 1563, 1535, 1534, 1533, 1532, 1531, 1530, 1506, 1486, 1485, 1484, 1482, 1481, 1480, 1426, 1204, 1066, 1065, 1064, 1063, 1062, 1061, 948, 584, 583, 582, 581, 580, 579, 380, 379, 378, 377, 376, 375, 265, 264, 263, 262, 261, 260, 259, 258, 257, 256, 255, 254, 253, 252, 251, 250, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 145, 143, 142, 141, 140, 139, 138, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 112, 111, 110, 109, 108, 107, 106)
Run Time: 0.007116
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 | diendan_sach.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | diendan_sach.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | diendan_sach.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,diendan_sach.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: 155, 0, 1713999957, 1714003557, [["thread",2686],["thread",2675],["thread",2674],["thread",2673],["thread",2427],["thread",2426],["thread",2423],["thread",2422],["thread",2421],["thread",2420],["thread",2394],["thread",2393],["thread",2338],["thread",2337],["thread",2333],["thread",2315],["thread",2314],["thread",2313],["thread",2312],["thread",2311],["thread",2309],["thread",2298],["thread",2214],["thread",2194],["thread",2185],["thread",2184],["thread",2183],["thread",2182],["thread",2181],["thread",2180],["thread",2179],["thread",2178],["thread",2177],["thread",2176],["thread",2175],["thread",2173],["thread",2172],["thread",2163],["thread",2162],["thread",2161],["thread",2160],["thread",2159],["thread",2158],["thread",2157],["thread",2153],["thread",2151],["thread",2150],["thread",2149],["thread",2148],["thread",2147],["thread",2134],["thread",2133],["thread",2132],["thread",2131],["thread",2130],["thread",2129],["thread",2126],["thread",2103],["thread",2102],["thread",2100],["thread",2099],["thread",2098],["thread",2097],["thread",2096],["thread",2095],["thread",2094],["thread",2093],["thread",2092],["thread",2081],["thread",1997],["thread",1996],["thread",1983],["thread",1982],["thread",1973],["thread",1972],["thread",1971],["thread",1970],["thread",1969],["thread",1968],["thread",1967],["thread",1966],["thread",1888],["thread",1826],["thread",1678],["thread",1677],["thread",1676],["thread",1675],["thread",1674],["thread",1673],["thread",1672],["thread",1662],["thread",1660],["thread",1659],["thread",1658],["thread",1657],["thread",1656],["thread",1655],["thread",1643],["thread",1619],["thread",1618],["thread",1616],["thread",1615],["thread",1614],["thread",1613],["thread",1612],["thread",1611],["thread",1610],["thread",1577],["thread",1566],["thread",1564],["thread",1563],["thread",1535],["thread",1534],["thread",1533],["thread",1532],["thread",1531],["thread",1530],["thread",1506],["thread",1486],["thread",1485],["thread",1484],["thread",1482],["thread",1481],["thread",1480],["thread",1426],["thread",1204],["thread",1066],["thread",1065],["thread",1064],["thread",1063],["thread",1062],["thread",1061],["thread",948],["thread",584],["thread",583],["thread",582],["thread",581],["thread",580],["thread",579],["thread",380],["thread",379],["thread",378],["thread",377],["thread",376],["thread",375],["thread",265],["thread",264],["thread",263],["thread",262],["thread",261],["thread",260],["thread",259],["thread",258],["thread",257],["thread",256],["thread",255],["thread",254],["thread",253],["thread",252],["thread",251],["thread",250],["thread",159],["thread",158],["thread",157],["thread",156],["thread",155],["thread",154],["thread",153],["thread",152],["thread",151],["thread",150],["thread",149],["thread",148],["thread",147],["thread",145],["thread",143],["thread",142],["thread",141],["thread",140],["thread",139],["thread",138],["thread",137],["thread",136],["thread",135],["thread",134],["thread",133],["thread",132],["thread",131],["thread",130],["thread",129],["thread",128],["thread",127],["thread",126],["thread",112],["thread",111],["thread",110],["thread",109],["thread",108],["thread",107],["thread",106]]
Run Time: 0.001500