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 (20705, 20702, 20701, 13461, 13019, 12901, 12780, 12778, 12517, 12350, 12211, 11871, 11824, 11823, 11822, 11821, 11820, 11660, 11579, 11576, 11164, 11152, 11151, 11132, 11130, 11116, 11115, 11087, 11086, 11032, 11031, 11029, 11028, 10994, 10987, 10975, 10974, 10973, 10940, 10939, 10937, 10911, 10910, 10909, 10908, 10907, 10875, 10874, 10839, 10834, 10782, 10761, 10759, 10685, 10684, 10682, 10658, 10656, 10654, 10636, 10634, 10623, 10542, 10540, 10454, 10451, 10448, 10380, 10359, 10356, 10337, 10333, 10315, 10299, 10297, 10281, 10279, 10265, 10262, 10208, 10206, 10133, 10130, 10129, 10127, 10110, 10109, 10107, 10104, 10102, 10090, 10089, 10087, 10086, 10037, 10035, 10023, 10002, 9980, 9935, 9934, 9909, 9906, 9879, 9878, 9861, 9859, 9841, 9839, 9820, 9792, 9791, 9789, 9788, 9752, 9748, 9719, 9718, 9717, 9716, 9715, 9695, 9694, 9693, 9691, 9675, 9674, 9673, 9672, 9671, 9661, 9660, 9659, 9635, 9634, 9633, 9632, 9631, 9589, 9588, 9587, 9586, 9584, 9556, 9555, 9554, 9553, 9552, 9544, 9543, 9542, 9541, 9540, 9518, 9515, 9494, 9492, 9490, 9455, 9430, 9424, 9366, 9363, 9361, 9275, 9237, 9234, 9179, 9174, 9146, 9145, 9142, 9114, 9111, 9090, 9088, 9086, 9063, 9061, 9030, 9028, 8997, 8994, 8993, 8977, 8975, 8962, 8890, 8889, 8833, 8685, 8675, 8674, 8673, 8672, 8671, 8651, 8630, 8626, 8600)
Run Time: 0.028914
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: 365, 0, 1653225268, 1653228868, [["thread",20705],["thread",20702],["thread",20701],["thread",13461],["thread",13019],["thread",12901],["thread",12780],["thread",12778],["thread",12517],["thread",12350],["thread",12211],["thread",11871],["thread",11824],["thread",11823],["thread",11822],["thread",11821],["thread",11820],["thread",11660],["thread",11579],["thread",11576],["thread",11164],["thread",11152],["thread",11151],["thread",11132],["thread",11130],["thread",11116],["thread",11115],["thread",11087],["thread",11086],["thread",11032],["thread",11031],["thread",11029],["thread",11028],["thread",10994],["thread",10987],["thread",10975],["thread",10974],["thread",10973],["thread",10940],["thread",10939],["thread",10937],["thread",10911],["thread",10910],["thread",10909],["thread",10908],["thread",10907],["thread",10875],["thread",10874],["thread",10839],["thread",10834],["thread",10782],["thread",10761],["thread",10759],["thread",10685],["thread",10684],["thread",10682],["thread",10658],["thread",10656],["thread",10654],["thread",10636],["thread",10634],["thread",10623],["thread",10542],["thread",10540],["thread",10454],["thread",10451],["thread",10448],["thread",10380],["thread",10359],["thread",10356],["thread",10337],["thread",10333],["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",10023],["thread",10002],["thread",9980],["thread",9935],["thread",9934],["thread",9909],["thread",9906],["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",9695],["thread",9694],["thread",9693],["thread",9691],["thread",9675],["thread",9674],["thread",9673],["thread",9672],["thread",9671],["thread",9661],["thread",9660],["thread",9659],["thread",9635],["thread",9634],["thread",9633],["thread",9632],["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",9543],["thread",9542],["thread",9541],["thread",9540],["thread",9518],["thread",9515],["thread",9494],["thread",9492],["thread",9490],["thread",9455],["thread",9430],["thread",9424],["thread",9366],["thread",9363],["thread",9361],["thread",9275],["thread",9237],["thread",9234],["thread",9179],["thread",9174],["thread",9146],["thread",9145],["thread",9142],["thread",9114],["thread",9111],["thread",9090],["thread",9088],["thread",9086],["thread",9063],["thread",9061],["thread",9030],["thread",9028],["thread",8997],["thread",8994],["thread",8993],["thread",8977],["thread",8975],["thread",8962],["thread",8890],["thread",8889],["thread",8833],["thread",8685],["thread",8675],["thread",8674],["thread",8673],["thread",8672],["thread",8671],["thread",8651],["thread",8630],["thread",8626],["thread",8600]]
Run Time: 0.001057