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 (12517, 12350, 11871, 11824, 11823, 11820, 11660, 11579, 11576, 11170, 11164, 11151, 11131, 11130, 11115, 11112, 11086, 11032, 11031, 11028, 10994, 10988, 10987, 10986, 10975, 10974, 10973, 10972, 10940, 10939, 10911, 10908, 10878, 10874, 10859, 10857, 10839, 10838, 10835, 10834, 10782, 10762, 10761, 10760, 10759, 10744, 10743, 10742, 10741, 10740, 10705, 10703, 10702, 10701, 10700, 10658, 10656, 10654, 10636, 10634, 10623, 10543, 10542, 10540, 10519, 10501, 10475, 10474, 10380, 10359, 10356, 10337, 10333, 10315, 10265, 10262, 10209, 10130, 10090, 10089, 10087, 10086, 10069, 10063, 10062, 10023, 9980, 9936, 9935, 9934, 9933, 9909, 9907, 9906, 9882, 9881, 9880, 9879, 9878, 9861, 9859, 9792, 9791, 9789, 9788, 9753, 9749, 9718, 9716, 9695, 9694, 9693, 9691, 9675, 9674, 9673, 9672, 9671, 9661, 9660, 9659, 9635, 9633, 9631, 9589, 9588, 9587, 9586, 9584, 9556, 9555, 9554, 9553, 9552, 9544, 9541, 9519, 9493, 9455, 9430, 9424, 9386, 9385, 9380, 9366, 9363, 9361, 9311, 9309, 9308, 9307, 9306, 9277, 9275, 9274, 9244, 9242, 9146, 9145, 9142, 9114, 9111, 9090, 9088, 9086, 9064, 9063, 9062, 9061, 9031, 9030, 9029, 9028, 8993, 8977, 8976, 8975, 8963, 8962, 8899, 8896, 8890, 8889, 8835, 8833, 8832, 8801, 8800, 8799, 8798, 8797, 8756, 8754, 8742, 8708, 8704, 8687, 8685, 8684, 8675)
Run Time: 0.013914
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: 364, 0, 1618881000, 1618884600, [["thread",12517],["thread",12350],["thread",11871],["thread",11824],["thread",11823],["thread",11820],["thread",11660],["thread",11579],["thread",11576],["thread",11170],["thread",11164],["thread",11151],["thread",11131],["thread",11130],["thread",11115],["thread",11112],["thread",11086],["thread",11032],["thread",11031],["thread",11028],["thread",10994],["thread",10988],["thread",10987],["thread",10986],["thread",10975],["thread",10974],["thread",10973],["thread",10972],["thread",10940],["thread",10939],["thread",10911],["thread",10908],["thread",10878],["thread",10874],["thread",10859],["thread",10857],["thread",10839],["thread",10838],["thread",10835],["thread",10834],["thread",10782],["thread",10762],["thread",10761],["thread",10760],["thread",10759],["thread",10744],["thread",10743],["thread",10742],["thread",10741],["thread",10740],["thread",10705],["thread",10703],["thread",10702],["thread",10701],["thread",10700],["thread",10658],["thread",10656],["thread",10654],["thread",10636],["thread",10634],["thread",10623],["thread",10543],["thread",10542],["thread",10540],["thread",10519],["thread",10501],["thread",10475],["thread",10474],["thread",10380],["thread",10359],["thread",10356],["thread",10337],["thread",10333],["thread",10315],["thread",10265],["thread",10262],["thread",10209],["thread",10130],["thread",10090],["thread",10089],["thread",10087],["thread",10086],["thread",10069],["thread",10063],["thread",10062],["thread",10023],["thread",9980],["thread",9936],["thread",9935],["thread",9934],["thread",9933],["thread",9909],["thread",9907],["thread",9906],["thread",9882],["thread",9881],["thread",9880],["thread",9879],["thread",9878],["thread",9861],["thread",9859],["thread",9792],["thread",9791],["thread",9789],["thread",9788],["thread",9753],["thread",9749],["thread",9718],["thread",9716],["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",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",9519],["thread",9493],["thread",9455],["thread",9430],["thread",9424],["thread",9386],["thread",9385],["thread",9380],["thread",9366],["thread",9363],["thread",9361],["thread",9311],["thread",9309],["thread",9308],["thread",9307],["thread",9306],["thread",9277],["thread",9275],["thread",9274],["thread",9244],["thread",9242],["thread",9146],["thread",9145],["thread",9142],["thread",9114],["thread",9111],["thread",9090],["thread",9088],["thread",9086],["thread",9064],["thread",9063],["thread",9062],["thread",9061],["thread",9031],["thread",9030],["thread",9029],["thread",9028],["thread",8993],["thread",8977],["thread",8976],["thread",8975],["thread",8963],["thread",8962],["thread",8899],["thread",8896],["thread",8890],["thread",8889],["thread",8835],["thread",8833],["thread",8832],["thread",8801],["thread",8800],["thread",8799],["thread",8798],["thread",8797],["thread",8756],["thread",8754],["thread",8742],["thread",8708],["thread",8704],["thread",8687],["thread",8685],["thread",8684],["thread",8675]]
Run Time: 0.000395