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 (18576, 12243, 12211, 11152, 11132, 11129, 11117, 10973, 10972, 10911, 10909, 10907, 10878, 10859, 10857, 10315, 10300, 10299, 10297, 10296, 10282, 10281, 10280, 10279, 10278, 10265, 10262, 10208, 10206, 10168, 10165, 10164, 10133, 10130, 10129, 10127, 10110, 10109, 10107, 10104, 10102, 10090, 10086, 10069, 10063, 10062, 10038, 10036, 10023, 10003, 10002, 10001, 9980, 9862, 9861, 9860, 9859, 9858, 9841, 9840, 9839, 9838, 9820, 9819, 9792, 9791, 9789, 9788, 9772, 9771, 9770, 9769, 9752, 9748, 9719, 9717, 9715, 9695, 9694, 9693, 9691, 9675, 9674, 9673, 9672, 9671, 9661, 9660, 9659, 9635, 9634, 9633, 9632, 9631, 9589, 9588, 9587, 9586, 9584, 9556, 9554, 9552, 9544, 9541, 8977, 8976, 8975, 8708, 8707, 8704, 8690, 8687, 8684, 8674, 8672, 8668, 8665, 8597, 8494, 8399, 8398, 8397, 8393, 8392, 8391, 8390, 8389, 8281, 8280, 8279, 8278, 8277, 8257, 8256, 8255, 8254, 8250, 8249, 8248, 8246, 8245, 8241, 8239, 8237, 8235, 8233, 8223, 8222, 8221, 8220, 8219, 8211, 8210, 8209, 8208, 8207, 8198, 8196, 8194, 8193, 8192, 8191, 8190, 8182, 8181, 8180, 8179, 8178, 8166, 8164, 8161, 8160, 8159, 8158, 8157, 8156, 8154, 8152, 8151, 8150, 8142, 8141, 8140, 8139, 8138, 8133, 8132, 8131, 8130, 8129, 8128, 8127, 8126, 8125, 8124, 8119, 8118, 8117, 8116, 8112)
Run Time: 0.012819
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: 363, 0, 1653230805, 1653234405, [["thread",18576],["thread",12243],["thread",12211],["thread",11152],["thread",11132],["thread",11129],["thread",11117],["thread",10973],["thread",10972],["thread",10911],["thread",10909],["thread",10907],["thread",10878],["thread",10859],["thread",10857],["thread",10315],["thread",10300],["thread",10299],["thread",10297],["thread",10296],["thread",10282],["thread",10281],["thread",10280],["thread",10279],["thread",10278],["thread",10265],["thread",10262],["thread",10208],["thread",10206],["thread",10168],["thread",10165],["thread",10164],["thread",10133],["thread",10130],["thread",10129],["thread",10127],["thread",10110],["thread",10109],["thread",10107],["thread",10104],["thread",10102],["thread",10090],["thread",10086],["thread",10069],["thread",10063],["thread",10062],["thread",10038],["thread",10036],["thread",10023],["thread",10003],["thread",10002],["thread",10001],["thread",9980],["thread",9862],["thread",9861],["thread",9860],["thread",9859],["thread",9858],["thread",9841],["thread",9840],["thread",9839],["thread",9838],["thread",9820],["thread",9819],["thread",9792],["thread",9791],["thread",9789],["thread",9788],["thread",9772],["thread",9771],["thread",9770],["thread",9769],["thread",9752],["thread",9748],["thread",9719],["thread",9717],["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",9554],["thread",9552],["thread",9544],["thread",9541],["thread",8977],["thread",8976],["thread",8975],["thread",8708],["thread",8707],["thread",8704],["thread",8690],["thread",8687],["thread",8684],["thread",8674],["thread",8672],["thread",8668],["thread",8665],["thread",8597],["thread",8494],["thread",8399],["thread",8398],["thread",8397],["thread",8393],["thread",8392],["thread",8391],["thread",8390],["thread",8389],["thread",8281],["thread",8280],["thread",8279],["thread",8278],["thread",8277],["thread",8257],["thread",8256],["thread",8255],["thread",8254],["thread",8250],["thread",8249],["thread",8248],["thread",8246],["thread",8245],["thread",8241],["thread",8239],["thread",8237],["thread",8235],["thread",8233],["thread",8223],["thread",8222],["thread",8221],["thread",8220],["thread",8219],["thread",8211],["thread",8210],["thread",8209],["thread",8208],["thread",8207],["thread",8198],["thread",8196],["thread",8194],["thread",8193],["thread",8192],["thread",8191],["thread",8190],["thread",8182],["thread",8181],["thread",8180],["thread",8179],["thread",8178],["thread",8166],["thread",8164],["thread",8161],["thread",8160],["thread",8159],["thread",8158],["thread",8157],["thread",8156],["thread",8154],["thread",8152],["thread",8151],["thread",8150],["thread",8142],["thread",8141],["thread",8140],["thread",8139],["thread",8138],["thread",8133],["thread",8132],["thread",8131],["thread",8130],["thread",8129],["thread",8128],["thread",8127],["thread",8126],["thread",8125],["thread",8124],["thread",8119],["thread",8118],["thread",8117],["thread",8116],["thread",8112]]
Run Time: 0.000241