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 (454098, 454095, 454042, 454028, 453978, 453943, 453914, 453244, 453216, 453215, 453214, 453209, 453208, 453207, 453166, 453163, 453139, 453138, 453118, 453108, 453106, 453105, 453103, 452864, 452754, 452705, 452701, 452700, 452403, 452378, 452319, 451897, 451517, 451504, 451413, 451411, 451398, 451362, 451326, 451296, 451294, 451290, 451247, 451227, 451215, 450828, 450556, 450549, 450508, 450261, 450040, 450038, 450037, 449497, 449478, 449471, 449449, 449448, 449325, 449239, 449200, 449194, 449179, 449018, 449017, 449016, 449013, 449010, 448552, 448521, 448392, 448353, 448301, 448229, 448055, 448002, 447980, 447686, 447678, 447674, 447671, 447662, 447656, 447655, 447641, 447627, 447612, 447606, 447597, 447589, 447402, 447372, 447366, 447365, 447362, 447331, 447293, 447182, 447173, 447072, 447065, 446982, 446893, 446889, 446817, 446698, 446688, 446684, 446564, 446563, 446428, 446378, 446177, 446172, 446151, 445892, 445884, 445879, 445877, 445480, 445403, 445393, 445382, 445379, 445207, 445160, 444872, 444828, 444814, 444594, 444567, 444529, 444377, 443843, 443837, 443715, 443666, 443551, 443536, 443453, 443444, 443404, 443280, 443079, 443059, 443051, 442734, 442258, 442248, 442228, 442227, 442223, 442032, 441363, 441328, 441253, 441156, 441137, 441065, 441004, 440999, 440998, 440954, 440925, 440921, 440904, 440789, 440738, 440736, 439645, 439637, 439595, 439591, 438555, 438541, 438534, 438356, 438232, 438142, 438045, 438021, 437991, 437772, 437771, 437670, 437244, 437117, 437115, 437032, 437005, 436684, 436632, 436470, 436306, 436209, 436206, 436182, 436179, 436090, 436059)
Run Time: 0.025115
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | hunsa.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | hunsa.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | hunsa.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,hunsa.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: 153, 0, 1660094572, 1660098172, [["thread",454098],["thread",454095],["thread",454042],["thread",454028],["thread",453978],["thread",453943],["thread",453914],["thread",453244],["thread",453216],["thread",453215],["thread",453214],["thread",453209],["thread",453208],["thread",453207],["thread",453166],["thread",453163],["thread",453139],["thread",453138],["thread",453118],["thread",453108],["thread",453106],["thread",453105],["thread",453103],["thread",452864],["thread",452754],["thread",452705],["thread",452701],["thread",452700],["thread",452403],["thread",452378],["thread",452319],["thread",451897],["thread",451517],["thread",451504],["thread",451413],["thread",451411],["thread",451398],["thread",451362],["thread",451326],["thread",451296],["thread",451294],["thread",451290],["thread",451247],["thread",451227],["thread",451215],["thread",450828],["thread",450556],["thread",450549],["thread",450508],["thread",450261],["thread",450040],["thread",450038],["thread",450037],["thread",449497],["thread",449478],["thread",449471],["thread",449449],["thread",449448],["thread",449325],["thread",449239],["thread",449200],["thread",449194],["thread",449179],["thread",449018],["thread",449017],["thread",449016],["thread",449013],["thread",449010],["thread",448552],["thread",448521],["thread",448392],["thread",448353],["thread",448301],["thread",448229],["thread",448055],["thread",448002],["thread",447980],["thread",447686],["thread",447678],["thread",447674],["thread",447671],["thread",447662],["thread",447656],["thread",447655],["thread",447641],["thread",447627],["thread",447612],["thread",447606],["thread",447597],["thread",447589],["thread",447402],["thread",447372],["thread",447366],["thread",447365],["thread",447362],["thread",447331],["thread",447293],["thread",447182],["thread",447173],["thread",447072],["thread",447065],["thread",446982],["thread",446893],["thread",446889],["thread",446817],["thread",446698],["thread",446688],["thread",446684],["thread",446564],["thread",446563],["thread",446428],["thread",446378],["thread",446177],["thread",446172],["thread",446151],["thread",445892],["thread",445884],["thread",445879],["thread",445877],["thread",445480],["thread",445403],["thread",445393],["thread",445382],["thread",445379],["thread",445207],["thread",445160],["thread",444872],["thread",444828],["thread",444814],["thread",444594],["thread",444567],["thread",444529],["thread",444377],["thread",443843],["thread",443837],["thread",443715],["thread",443666],["thread",443551],["thread",443536],["thread",443453],["thread",443444],["thread",443404],["thread",443280],["thread",443079],["thread",443059],["thread",443051],["thread",442734],["thread",442258],["thread",442248],["thread",442228],["thread",442227],["thread",442223],["thread",442032],["thread",441363],["thread",441328],["thread",441253],["thread",441156],["thread",441137],["thread",441065],["thread",441004],["thread",440999],["thread",440998],["thread",440954],["thread",440925],["thread",440921],["thread",440904],["thread",440789],["thread",440738],["thread",440736],["thread",439645],["thread",439637],["thread",439595],["thread",439591],["thread",438555],["thread",438541],["thread",438534],["thread",438356],["thread",438232],["thread",438142],["thread",438045],["thread",438021],["thread",437991],["thread",437772],["thread",437771],["thread",437670],["thread",437244],["thread",437117],["thread",437115],["thread",437032],["thread",437005],["thread",436684],["thread",436632],["thread",436470],["thread",436306],["thread",436209],["thread",436206],["thread",436182],["thread",436179],["thread",436090],["thread",436059]]
Run Time: 0.002674