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 (1972337, 1970013, 1969811, 36133, 36132, 36129, 36127, 36125, 36122, 36119, 36117, 36116, 36114, 36113, 36111, 3379, 3375, 3374, 3373, 3371, 2955, 2516, 2486, 2484, 2405, 2389, 2124, 1989, 1897, 1896, 1895, 1893, 1892, 1865, 1864, 1791, 1790, 1789, 1788, 1787, 1786, 1775, 1773, 1772, 1721, 1720, 1719, 1718, 1712, 1711, 1710, 1709, 1708, 1659, 1638, 1637, 1635, 1634, 1633, 1602, 1601, 1600, 1595, 1594, 1578, 1577, 1574, 1572, 1571, 1570, 1549, 1507, 1506, 1505, 1504, 1503, 1502, 1495, 1488, 1487, 1486, 1485, 1484, 1482, 1481, 1480, 1479, 1478, 1426, 1423, 1422, 1421, 1419, 1418, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1300, 1298, 1297, 1296, 1295, 1293, 1292, 1291, 1289, 1288, 1286, 1075, 1074, 1073, 1062, 1061, 1059, 1057, 1054, 1038, 1036, 1035, 1016, 1015, 1014, 976, 974, 973, 972, 971, 969, 968, 738, 732, 721, 720, 719, 718, 717, 715, 714, 713, 712, 711, 710, 706, 705, 274, 273, 261, 260, 218)
Run Time: 0.010823
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 156 | 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: 26, 0, 1714120341, 1714123941, {"0":["thread",1972337],"1":["thread",1970013],"2":["thread",1969811],"15":["thread",3379],"16":["thread",3375],"17":["thread",3374],"18":["thread",3373],"19":["thread",3371],"20":["thread",2955],"21":["thread",2516],"22":["thread",2486],"23":["thread",2484],"24":["thread",2405],"25":["thread",2389],"26":["thread",2124],"27":["thread",1989],"28":["thread",1897],"29":["thread",1896],"30":["thread",1895],"31":["thread",1893],"32":["thread",1892],"33":["thread",1865],"34":["thread",1864],"35":["thread",1791],"36":["thread",1790],"37":["thread",1789],"38":["thread",1788],"39":["thread",1787],"40":["thread",1786],"41":["thread",1775],"42":["thread",1773],"43":["thread",1772],"44":["thread",1721],"45":["thread",1720],"46":["thread",1719],"47":["thread",1718],"48":["thread",1712],"49":["thread",1711],"50":["thread",1710],"51":["thread",1709],"52":["thread",1708],"53":["thread",1659],"54":["thread",1638],"55":["thread",1637],"56":["thread",1635],"57":["thread",1634],"58":["thread",1633],"59":["thread",1602],"60":["thread",1601],"61":["thread",1600],"62":["thread",1595],"63":["thread",1594],"64":["thread",1578],"65":["thread",1577],"66":["thread",1574],"67":["thread",1572],"68":["thread",1571],"69":["thread",1570],"70":["thread",1549],"71":["thread",1507],"72":["thread",1506],"73":["thread",1505],"74":["thread",1504],"75":["thread",1503],"76":["thread",1502],"77":["thread",1495],"78":["thread",1488],"79":["thread",1487],"80":["thread",1486],"81":["thread",1485],"82":["thread",1484],"83":["thread",1482],"84":["thread",1481],"85":["thread",1480],"86":["thread",1479],"87":["thread",1478],"88":["thread",1426],"89":["thread",1423],"90":["thread",1422],"91":["thread",1421],"92":["thread",1419],"93":["thread",1418],"94":["thread",1339],"95":["thread",1338],"96":["thread",1337],"97":["thread",1336],"98":["thread",1335],"99":["thread",1334],"100":["thread",1333],"101":["thread",1332],"102":["thread",1331],"103":["thread",1330],"104":["thread",1300],"105":["thread",1298],"106":["thread",1297],"107":["thread",1296],"108":["thread",1295],"109":["thread",1293],"110":["thread",1292],"111":["thread",1291],"112":["thread",1289],"113":["thread",1288],"114":["thread",1286],"115":["thread",1075],"116":["thread",1074],"117":["thread",1073],"118":["thread",1062],"119":["thread",1061],"120":["thread",1059],"121":["thread",1057],"122":["thread",1054],"123":["thread",1038],"124":["thread",1036],"125":["thread",1035],"126":["thread",1016],"127":["thread",1015],"128":["thread",1014],"129":["thread",976],"130":["thread",974],"131":["thread",973],"132":["thread",972],"133":["thread",971],"134":["thread",969],"135":["thread",968],"136":["thread",738],"137":["thread",732],"138":["thread",721],"139":["thread",720],"140":["thread",719],"141":["thread",718],"142":["thread",717],"143":["thread",715],"144":["thread",714],"145":["thread",713],"146":["thread",712],"147":["thread",711],"148":["thread",710],"149":["thread",706],"150":["thread",705],"151":["thread",274],"152":["thread",273],"153":["thread",261],"154":["thread",260],"155":["thread",218]}
Run Time: 0.008351