SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
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_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 (18104, 18194, 17543, 17183, 18171, 18200, 17942, 17689, 17423, 37, 17035, 17597, 14007, 10864, 18199, 18198, 18177, 18197, 18196, 15639, 18195, 17626, 18190, 18159, 17515, 18193, 18192, 17916, 18191, 17828, 15530, 18189, 14860, 17944, 18141, 14413, 18188, 15889, 18187, 16619, 17685, 18185, 18186, 18182, 18117, 18184, 18183, 18178, 10980, 17736, 16562, 18181, 18082, 16654, 16179, 18180, 18106, 17271, 18179, 17858, 18000, 15630, 18176, 17732, 14431, 14391, 18175, 18172, 18174, 18173, 18169, 18168, 18170, 18164, 18134, 18167, 5749, 18166, 18165, 17739, 18158, 18049, 18163, 17480, 18161, 18162, 18160, 18157, 18156, 15022, 18155, 17654, 18043, 18150, 18154, 18153, 18151, 18152, 18149, 18044, 18041, 16984, 15974, 18148, 18139, 18147, 17816, 17758, 18064, 18146, 18145, 18142, 16486, 18144, 18047, 18143, 17313, 17266, 14705, 18140, 18137, 17973, 17360, 18038, 17806, 17437, 17878, 18100, 17500, 18109, 17466, 17735, 17833, 18056, 18042, 17937, 17787, 18091, 18138, 17511, 16936, 18115, 18126, 18136, 18135, 18133, 18132, 18129, 18131, 18130, 18128, 18127, 15596, 18093, 18069, 18123, 18125, 18124, 18081, 16073, 14859, 18122, 18121, 18045, 18107, 18120, 18119, 18118, 13694, 18116, 14541, 16395, 18114, 18113, 16267, 15648, 18112, 18111, 16114, 18110, 15205, 16029, 18090, 17482, 18108, 17854, 17771, 14651, 18105, 18101, 17093, 17997, 18103, 17947, 18102, 18096, 18099, 18098, 17888, 16344)
Run Time: 0.000621
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 |
u452961_infiniti.thread.user_id |
1 |
|
SIMPLE |
node |
eq_ref |
PRIMARY |
PRIMARY |
4 |
u452961_infiniti.thread.node_id |
1 |
|
SIMPLE |
permission |
eq_ref |
PRIMARY |
PRIMARY |
35 |
const,const,u452961_infiniti.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: [["thread",18104],["thread",18194],["thread",17543],["thread",17183],["thread",18171],["thread",18200],["thread",17942],["thread",17689],["thread",17423],["thread",37],["thread",17035],["thread",17597],["thread",14007],["thread",10864],["thread",18199],["thread",18198],["thread",18177],["thread",18197],["thread",18196],["thread",15639],["thread",18195],["thread",17626],["thread",18190],["thread",18159],["thread",17515],["thread",18193],["thread",18192],["thread",17916],["thread",18191],["thread",17828],["thread",15530],["thread",18189],["thread",14860],["thread",17944],["thread",18141],["thread",14413],["thread",18188],["thread",15889],["thread",18187],["thread",16619],["thread",17685],["thread",18185],["thread",18186],["thread",18182],["thread",18117],["thread",18184],["thread",18183],["thread",18178],["thread",10980],["thread",17736],["thread",16562],["thread",18181],["thread",18082],["thread",16654],["thread",16179],["thread",18180],["thread",18106],["thread",17271],["thread",18179],["thread",17858],["thread",18000],["thread",15630],["thread",18176],["thread",17732],["thread",14431],["thread",14391],["thread",18175],["thread",18172],["thread",18174],["thread",18173],["thread",18169],["thread",18168],["thread",18170],["thread",18164],["thread",18134],["thread",18167],["thread",5749],["thread",18166],["thread",18165],["thread",17739],["thread",18158],["thread",18049],["thread",18163],["thread",17480],["thread",18161],["thread",18162],["thread",18160],["thread",18157],["thread",18156],["thread",15022],["thread",18155],["thread",17654],["thread",18043],["thread",18150],["thread",18154],["thread",18153],["thread",18151],["thread",18152],["thread",18149],["thread",18044],["thread",18041],["thread",16984],["thread",15974],["thread",18148],["thread",18139],["thread",18147],["thread",17816],["thread",17758],["thread",18064],["thread",18146],["thread",18145],["thread",18142],["thread",16486],["thread",18144],["thread",18047],["thread",18143],["thread",17313],["thread",17266],["thread",14705],["thread",18140],["thread",18137],["thread",17973],["thread",17360],["thread",18038],["thread",17806],["thread",17437],["thread",17878],["thread",18100],["thread",17500],["thread",18109],["thread",17466],["thread",17735],["thread",17833],["thread",18056],["thread",18042],["thread",17937],["thread",17787],["thread",18091],["thread",18138],["thread",17511],["thread",16936],["thread",18115],["thread",18126],["thread",18136],["thread",18135],["thread",18133],["thread",18132],["thread",18129],["thread",18131],["thread",18130],["thread",18128],["thread",18127],["thread",15596],["thread",18093],["thread",18069],["thread",18123],["thread",18125],["thread",18124],["thread",18081],["thread",16073],["thread",14859],["thread",18122],["thread",18121],["thread",18045],["thread",18107],["thread",18120],["thread",18119],["thread",18118],["thread",13694],["thread",18116],["thread",14541],["thread",16395],["thread",18114],["thread",18113],["thread",16267],["thread",15648],["thread",18112],["thread",18111],["thread",16114],["thread",18110],["thread",15205],["thread",16029],["thread",18090],["thread",17482],["thread",18108],["thread",17854],["thread",17771],["thread",14651],["thread",18105],["thread",18101],["thread",17093],["thread",17997],["thread",18103],["thread",17947],["thread",18102],["thread",18096],["thread",18099],["thread",18098],["thread",17888],["thread",16344]], 200, recent-posts, , [], date, 0, , [], 0, 1638271630, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000429