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 (16462, 11090, 11086, 10744, 10743, 10742, 10741, 10740, 10705, 10703, 10702, 10701, 10700, 10685, 10684, 10682, 10680, 10678, 10677, 10658, 10656, 10654, 10501, 10475, 10474, 10454, 10451, 10448, 10436, 10431, 10429, 10380, 9934, 9882, 9880, 9879, 9410, 9409, 9408, 9407, 9406, 9386, 9385, 9380, 9362, 9356, 9355, 9354, 9244, 9242, 9237, 9234, 9208, 9206, 9205, 9204, 9146, 9145, 9142, 8998, 8993, 8574, 8573, 8571, 8569, 8554, 8550, 8549, 8431, 8428, 8425, 8419, 8417, 8409, 8408, 8407, 8406, 8405, 8341, 8325, 8324, 8323, 8322, 8321, 8320, 8303, 8302, 8301, 8300, 8299, 8298, 8297, 8270, 8268, 8266, 8231, 8230, 8229, 8228, 8227, 8099, 8096, 7888, 7886, 7884, 7883, 7882, 7881, 7880, 7866, 7865, 7864, 7863, 7862, 7861, 7860, 7859, 7834, 7831, 7830, 7829, 7827, 7758, 7757, 7756, 7755, 7697, 7696, 7695, 7694, 7693, 7617, 7595, 7532, 7469, 7468, 7467, 7466, 7464, 7425, 7082, 7079, 7054, 7048, 7047, 7033, 7032, 7029, 7028, 7027, 7026, 7024, 6976, 6952, 6951, 6946, 6921, 6920, 6891, 6888, 6489, 6468, 6421, 6391, 6377, 4374, 4372, 3840, 3836, 3728, 1873, 1869, 1868, 1866, 1817, 1815, 1814, 1813, 1811, 1782)
Run Time: 0.009594
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 180 | 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: 921, 0, 1652877329, 1652880929, [["thread",16462],["thread",11090],["thread",11086],["thread",10744],["thread",10743],["thread",10742],["thread",10741],["thread",10740],["thread",10705],["thread",10703],["thread",10702],["thread",10701],["thread",10700],["thread",10685],["thread",10684],["thread",10682],["thread",10680],["thread",10678],["thread",10677],["thread",10658],["thread",10656],["thread",10654],["thread",10501],["thread",10475],["thread",10474],["thread",10454],["thread",10451],["thread",10448],["thread",10436],["thread",10431],["thread",10429],["thread",10380],["thread",9934],["thread",9882],["thread",9880],["thread",9879],["thread",9410],["thread",9409],["thread",9408],["thread",9407],["thread",9406],["thread",9386],["thread",9385],["thread",9380],["thread",9362],["thread",9356],["thread",9355],["thread",9354],["thread",9244],["thread",9242],["thread",9237],["thread",9234],["thread",9208],["thread",9206],["thread",9205],["thread",9204],["thread",9146],["thread",9145],["thread",9142],["thread",8998],["thread",8993],["thread",8574],["thread",8573],["thread",8571],["thread",8569],["thread",8554],["thread",8550],["thread",8549],["thread",8431],["thread",8428],["thread",8425],["thread",8419],["thread",8417],["thread",8409],["thread",8408],["thread",8407],["thread",8406],["thread",8405],["thread",8341],["thread",8325],["thread",8324],["thread",8323],["thread",8322],["thread",8321],["thread",8320],["thread",8303],["thread",8302],["thread",8301],["thread",8300],["thread",8299],["thread",8298],["thread",8297],["thread",8270],["thread",8268],["thread",8266],["thread",8231],["thread",8230],["thread",8229],["thread",8228],["thread",8227],["thread",8099],["thread",8096],["thread",7888],["thread",7886],["thread",7884],["thread",7883],["thread",7882],["thread",7881],["thread",7880],["thread",7866],["thread",7865],["thread",7864],["thread",7863],["thread",7862],["thread",7861],["thread",7860],["thread",7859],["thread",7834],["thread",7831],["thread",7830],["thread",7829],["thread",7827],["thread",7758],["thread",7757],["thread",7756],["thread",7755],["thread",7697],["thread",7696],["thread",7695],["thread",7694],["thread",7693],["thread",7617],["thread",7595],["thread",7532],["thread",7469],["thread",7468],["thread",7467],["thread",7466],["thread",7464],["thread",7425],["thread",7082],["thread",7079],["thread",7054],["thread",7048],["thread",7047],["thread",7033],["thread",7032],["thread",7029],["thread",7028],["thread",7027],["thread",7026],["thread",7024],["thread",6976],["thread",6952],["thread",6951],["thread",6946],["thread",6921],["thread",6920],["thread",6891],["thread",6888],["thread",6489],["thread",6468],["thread",6421],["thread",6391],["thread",6377]]
Run Time: 0.000445