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 (9405778, 8724660, 8721496, 8716452, 8709544, 8708894, 8700106, 8697490, 8696129, 8695582, 8692258, 8688450, 8686075, 8660659, 8657017, 8655711, 8648835, 8645808, 8628142, 8627276, 8619127, 8612874, 8603687, 8599006, 8596257, 8585105, 8577962, 8568439, 8563799, 8545056, 8542193, 8535059, 8530415, 8515151, 8512384, 8508833, 8508033, 8507539, 8499102, 8498440, 8494059, 8493670, 8488425, 8476762, 8476069, 8469468, 8469391, 8466705, 8461455, 8458991, 8455026, 8452195, 8451227, 8448561, 8436767, 8433456, 8430044, 8427186, 8425496, 8420465, 8417807, 8407604, 8406811, 8406795, 8400091, 8384453, 8372670, 8372127, 8371692, 8370795, 8368525, 8361896, 8360184, 8359316, 8354502, 8354160, 8351473, 8350957, 8345464, 8344545, 8343525, 8343007, 8338516, 8334287, 8334217, 8334084, 8321030, 8320612, 8314994, 8313274, 8310117, 8309531, 8307096, 8304275, 8303880, 8301289, 8300671, 8299549, 8296937, 8296920, 8296758, 8295389, 8291543, 8289809, 8287262, 8283953, 8281465, 8281348, 8278560, 8276790, 8276787, 8273640, 8269903, 8265506, 8264701, 8264619, 8263880, 8260029, 8259343, 8259153, 8258184, 8240489, 8218296, 8207189, 8204948, 8183252, 8162984, 8158973, 8141530, 8112536, 8111634, 8073704, 8064137, 8054520, 8052090, 8041911, 8018520, 8007162, 8007155, 7940161, 7890222, 7843707, 7819032, 7797798, 7768920, 7764876, 7729669, 7722320, 7719205, 7645855, 7628057, 7618643, 7562557, 7556926, 7552958, 7532110, 7529749, 7500939, 7487649, 7487256, 7473133, 7469912, 7463432, 7426610, 7411241, 7408487, 7401534, 7398288, 7376000, 7360836, 7350035, 7320831, 7309895, 5525583, 6774717, 6751234, 5848751, 5579669, 3255256)
Run Time: 0.005897
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 179 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,5s_db1.thread.node_id | 1 | Using where |
INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: [["tinhte_xentag_forum",43],["thread",9405778],["thread",8721496],["thread",8708894],["thread",8697490],["thread",8696129],["thread",8692258],["thread",8688450],["thread",8660659],["thread",8657017],["thread",8655711],["thread",8648835],["thread",8645808],["thread",8628142],["thread",8627276],["thread",8619127],["thread",8612874],["thread",8599006],["thread",8596257],["thread",8585105],["thread",8577962],["thread",8568439],["thread",8545056],["thread",8542193],["thread",8535059],["thread",8530415],["thread",8515151],["thread",8512384],["thread",8508833],["thread",8508033],["thread",8507539],["thread",8499102],["thread",8498440],["thread",8494059],["thread",8493670],["thread",8488425],["thread",8476762],["thread",8476069],["thread",8469468],["thread",8469391],["thread",8466705],["thread",8461455],["thread",8458991],["thread",8455026],["thread",8451227],["thread",8448561],["thread",8436767],["thread",8433456],["thread",8430044],["thread",8427186],["thread",8425496],["thread",8420465],["thread",8406811],["thread",8406795],["thread",8400091],["thread",8384453],["thread",8372670],["thread",8372127],["thread",8371692],["thread",8370795],["thread",8368525],["thread",8361896],["thread",8360184],["thread",8359316],["thread",8354502],["thread",8354160],["thread",8351473],["thread",8350957],["thread",8345464],["thread",8344545],["thread",8343525],["thread",8338516],["thread",8334287],["thread",8334217],["thread",8334084],["thread",8320612],["thread",8314994],["thread",8313274],["thread",8310117],["thread",8307096],["thread",8304275],["thread",8303880],["thread",8301289],["thread",8299549],["thread",8296937],["thread",8296920],["thread",8296758],["thread",8295389],["thread",8291543],["thread",8289809],["thread",8287262],["thread",8283953],["thread",8281465],["thread",8281348],["thread",8278560],["thread",8276790],["thread",8276787],["thread",8273640],["thread",8269903],["thread",8265506],["thread",8264701],["thread",8264619],["thread",8263880],["thread",8260029],["thread",8259343],["thread",8259153],["thread",8258184],["thread",8218296],["thread",8204948],["thread",8162984],["thread",8158973],["thread",8141530],["thread",8112536],["thread",8111634],["thread",8073704],["thread",8064137],["thread",8054520],["thread",8041911],["thread",8018520],["thread",8007162],["thread",8007155],["thread",7940161],["thread",7890222],["thread",7843707],["thread",7819032],["thread",7797798],["thread",7768920],["thread",7729669],["thread",7722320],["thread",7719205],["thread",7618643],["thread",7552958],["thread",7532110],["thread",7529749],["thread",7500939],["thread",7487649],["thread",7487256],["thread",7473133],["thread",7469912],["thread",7463432],["thread",7426610],["thread",7411241],["thread",7408487],["thread",7401534],["thread",7398288],["thread",7376000],["thread",7360836],["thread",7350035],["thread",5848751]], 149, tinhte_xentag_tag, , {"tags":["xe m\u00e1y sym"]}, date, 0, , [], 0, 1653054416, da7bbc7458b14d445906e5153d527da3
Run Time: 0.000510