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 (21100, 20705, 20702, 20701, 13461, 13019, 12901, 12780, 12778, 12517, 11871, 11824, 11822, 11821, 11820, 11660, 11579, 11576, 11170, 11164, 11130, 11129, 11117, 11115, 11114, 11032, 11031, 11029, 11028, 10994, 10987, 10975, 10974, 10973, 10940, 10937, 10936, 10911, 10910, 10909, 10908, 10907, 10878, 10874, 10859, 10857, 10839, 10838, 10835, 10834, 10782, 10761, 10759, 10685, 10684, 10682, 10658, 10657, 10656, 10655, 10654, 10636, 10634, 10542, 10540, 10454, 10451, 10448, 10382, 10380, 10359, 10356, 10315, 10299, 10297, 10281, 10279, 10265, 10262, 10208, 10206, 10133, 10130, 10129, 10127, 10110, 10109, 10107, 10104, 10102, 10090, 10089, 10087, 10086, 10037, 10035, 10003, 10002, 10001, 9980, 9936, 9935, 9934, 9933, 9909, 9907, 9906, 9882, 9880, 9879, 9878, 9861, 9859, 9841, 9839, 9820, 9792, 9791, 9789, 9788, 9752, 9748, 9719, 9718, 9717, 9716, 9715, 9675, 9674, 9673, 9672, 9671, 9661, 9660, 9659, 9635, 9633, 9631, 9589, 9588, 9587, 9586, 9584, 9556, 9555, 9554, 9553, 9552, 9544, 9541, 9518, 9517, 9515, 9494, 9492, 9490, 9455, 9430, 9424, 9410, 9409, 9408, 9407, 9406, 9386, 9385, 9380, 9366, 9363, 9361, 9353, 9276, 9275, 9273, 9237, 9234, 9179, 9174, 9146, 9145, 9142, 9114, 9111, 9063, 9061, 9030, 9028, 8997, 8995, 8977, 8976, 8975, 8963, 8889, 8834, 8833, 8831, 8685, 8675, 8674)
Run Time: 0.028462
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using index condition |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | tugrghshosting_diendanduoc.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | tugrghshosting_diendanduoc.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | tugrghshosting_diendanduoc.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,tugrghshosting_diendanduoc.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: 351, 0, 1653726045, 1653729645, [["thread",21100],["thread",20705],["thread",20702],["thread",20701],["thread",13461],["thread",13019],["thread",12901],["thread",12780],["thread",12778],["thread",12517],["thread",11871],["thread",11824],["thread",11822],["thread",11821],["thread",11820],["thread",11660],["thread",11579],["thread",11576],["thread",11170],["thread",11164],["thread",11130],["thread",11129],["thread",11117],["thread",11115],["thread",11114],["thread",11032],["thread",11031],["thread",11029],["thread",11028],["thread",10994],["thread",10987],["thread",10975],["thread",10974],["thread",10973],["thread",10940],["thread",10937],["thread",10936],["thread",10911],["thread",10910],["thread",10909],["thread",10908],["thread",10907],["thread",10878],["thread",10874],["thread",10859],["thread",10857],["thread",10839],["thread",10838],["thread",10835],["thread",10834],["thread",10782],["thread",10761],["thread",10759],["thread",10685],["thread",10684],["thread",10682],["thread",10658],["thread",10657],["thread",10656],["thread",10655],["thread",10654],["thread",10636],["thread",10634],["thread",10542],["thread",10540],["thread",10454],["thread",10451],["thread",10448],["thread",10382],["thread",10380],["thread",10359],["thread",10356],["thread",10315],["thread",10299],["thread",10297],["thread",10281],["thread",10279],["thread",10265],["thread",10262],["thread",10208],["thread",10206],["thread",10133],["thread",10130],["thread",10129],["thread",10127],["thread",10110],["thread",10109],["thread",10107],["thread",10104],["thread",10102],["thread",10090],["thread",10089],["thread",10087],["thread",10086],["thread",10037],["thread",10035],["thread",10003],["thread",10002],["thread",10001],["thread",9980],["thread",9936],["thread",9935],["thread",9934],["thread",9933],["thread",9909],["thread",9907],["thread",9906],["thread",9882],["thread",9880],["thread",9879],["thread",9878],["thread",9861],["thread",9859],["thread",9841],["thread",9839],["thread",9820],["thread",9792],["thread",9791],["thread",9789],["thread",9788],["thread",9752],["thread",9748],["thread",9719],["thread",9718],["thread",9717],["thread",9716],["thread",9715],["thread",9675],["thread",9674],["thread",9673],["thread",9672],["thread",9671],["thread",9661],["thread",9660],["thread",9659],["thread",9635],["thread",9633],["thread",9631],["thread",9589],["thread",9588],["thread",9587],["thread",9586],["thread",9584],["thread",9556],["thread",9555],["thread",9554],["thread",9553],["thread",9552],["thread",9544],["thread",9541],["thread",9518],["thread",9517],["thread",9515],["thread",9494],["thread",9492],["thread",9490],["thread",9455],["thread",9430],["thread",9424],["thread",9410],["thread",9409],["thread",9408],["thread",9407],["thread",9406],["thread",9386],["thread",9385],["thread",9380],["thread",9366],["thread",9363],["thread",9361],["thread",9353],["thread",9276],["thread",9275],["thread",9273],["thread",9237],["thread",9234],["thread",9179],["thread",9174],["thread",9146],["thread",9145],["thread",9142],["thread",9114],["thread",9111],["thread",9063],["thread",9061],["thread",9030],["thread",9028],["thread",8997],["thread",8995],["thread",8977],["thread",8976],["thread",8975],["thread",8963],["thread",8889],["thread",8834],["thread",8833],["thread",8831],["thread",8685],["thread",8675],["thread",8674]]
Run Time: 0.000346