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 (20702, 13019, 12780, 12778, 11871, 11660, 11164, 11087, 11032, 10988, 10986, 10972, 10939, 10908, 10878, 10875, 10859, 10857, 10839, 10834, 10636, 10634, 10631, 10624, 10359, 10356, 10299, 10297, 10281, 10279, 10209, 10133, 10129, 10127, 10110, 10109, 10107, 10104, 10102, 9936, 9934, 9907, 9881, 9879, 9841, 9839, 9820, 9753, 9749, 9718, 9716, 9635, 9633, 9631, 9589, 9588, 9587, 9586, 9584, 9430, 9424, 9277, 9275, 9274, 9114, 9111, 9089, 9087, 8994, 8976, 8963, 8890, 8889, 8835, 8833, 8832, 8756, 8754, 8742, 8687, 8685, 8684, 8675, 8674, 8673, 8672, 8671, 8630, 8629, 8626, 8600, 8599, 8598, 8526, 8524, 8515, 8514, 8513, 8399, 8397, 8396, 8393, 8391, 8389, 8377, 8223, 8222, 8221, 8220, 8219, 8216, 8215, 8214, 8213, 8206, 8205, 8204, 8203, 8202, 8198, 8196, 8195, 8186, 8185, 8152, 8151, 8150, 8122, 8121, 8120, 8076, 8075, 8074, 8073, 8072, 8050, 8049, 8047, 8040, 8039, 8038, 8037, 8036, 8035, 8034, 8032, 8031, 8030, 8029, 8022, 8021, 8020, 8019, 8002, 7999, 7975, 7974, 7973, 7972, 7971, 7970, 7969, 7963, 7941, 7920, 7919, 7918, 7917, 7916, 7907, 7906, 7905, 7904, 7903, 7876, 7875, 7826, 7823, 7822, 7821, 7817, 7811, 7810, 7809, 7807, 7806, 7797, 7796, 7795, 7793, 7791, 7789, 7786, 7785, 7780, 7778, 7777, 7776, 7763, 7762)
Run Time: 0.012244
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: 451, 0, 1653231886, 1653235486, [["thread",20702],["thread",13019],["thread",12780],["thread",12778],["thread",11871],["thread",11660],["thread",11164],["thread",11087],["thread",11032],["thread",10988],["thread",10986],["thread",10972],["thread",10939],["thread",10908],["thread",10878],["thread",10875],["thread",10859],["thread",10857],["thread",10839],["thread",10834],["thread",10636],["thread",10634],["thread",10631],["thread",10624],["thread",10359],["thread",10356],["thread",10299],["thread",10297],["thread",10281],["thread",10279],["thread",10209],["thread",10133],["thread",10129],["thread",10127],["thread",10110],["thread",10109],["thread",10107],["thread",10104],["thread",10102],["thread",9936],["thread",9934],["thread",9907],["thread",9881],["thread",9879],["thread",9841],["thread",9839],["thread",9820],["thread",9753],["thread",9749],["thread",9718],["thread",9716],["thread",9635],["thread",9633],["thread",9631],["thread",9589],["thread",9588],["thread",9587],["thread",9586],["thread",9584],["thread",9430],["thread",9424],["thread",9277],["thread",9275],["thread",9274],["thread",9114],["thread",9111],["thread",9089],["thread",9087],["thread",8994],["thread",8976],["thread",8963],["thread",8890],["thread",8889],["thread",8835],["thread",8833],["thread",8832],["thread",8756],["thread",8754],["thread",8742],["thread",8687],["thread",8685],["thread",8684],["thread",8675],["thread",8674],["thread",8673],["thread",8672],["thread",8671],["thread",8630],["thread",8629],["thread",8626],["thread",8600],["thread",8599],["thread",8598],["thread",8526],["thread",8524],["thread",8515],["thread",8514],["thread",8513],["thread",8399],["thread",8397],["thread",8396],["thread",8393],["thread",8391],["thread",8389],["thread",8377],["thread",8223],["thread",8222],["thread",8221],["thread",8220],["thread",8219],["thread",8216],["thread",8215],["thread",8214],["thread",8213],["thread",8206],["thread",8205],["thread",8204],["thread",8203],["thread",8202],["thread",8198],["thread",8196],["thread",8195],["thread",8186],["thread",8185],["thread",8152],["thread",8151],["thread",8150],["thread",8122],["thread",8121],["thread",8120],["thread",8076],["thread",8075],["thread",8074],["thread",8073],["thread",8072],["thread",8050],["thread",8049],["thread",8047],["thread",8040],["thread",8039],["thread",8038],["thread",8037],["thread",8036],["thread",8035],["thread",8034],["thread",8032],["thread",8031],["thread",8030],["thread",8029],["thread",8022],["thread",8021],["thread",8020],["thread",8019],["thread",8002],["thread",7999],["thread",7975],["thread",7974],["thread",7973],["thread",7972],["thread",7971],["thread",7970],["thread",7969],["thread",7963],["thread",7941],["thread",7920],["thread",7919],["thread",7918],["thread",7917],["thread",7916],["thread",7907],["thread",7906],["thread",7905],["thread",7904],["thread",7903],["thread",7876],["thread",7875],["thread",7826],["thread",7823],["thread",7822],["thread",7821],["thread",7817],["thread",7811],["thread",7810],["thread",7809],["thread",7807],["thread",7806],["thread",7797],["thread",7796],["thread",7795],["thread",7793],["thread",7791],["thread",7789],["thread",7786],["thread",7785],["thread",7780],["thread",7778],["thread",7777],["thread",7776],["thread",7763],["thread",7762]]
Run Time: 0.000483