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 (3296, 2664, 3886, 3166, 17, 3836, 3848, 3088, 2632, 2773, 3722, 3121, 3911, 3124, 3747, 3850, 3802, 3806, 3429, 3777, 3884, 3826, 3728, 3835, 3843, 3915, 3845, 3819, 3842, 3904, 3902, 2701, 3914, 3912, 3879, 3137, 3780, 2337, 2657, 3786, 2638, 3905, 3626, 14, 18, 3913, 3789, 3908, 3878, 3749, 3824, 3822, 3573, 3241, 3910, 3909, 2294, 3907, 3906, 3896, 3238, 2770, 3611, 3903, 3901, 967, 2400, 2117, 27, 3629, 2658, 3242, 3239, 3880, 3614, 15, 2118, 966, 3888, 3882, 3900, 3613, 968, 3853, 2193, 3243, 3854, 3244, 3839, 3240, 3245, 3898, 3251, 3893, 3894, 3899, 3891, 3889, 3897, 3859, 3686, 3779, 3895, 3630, 3855, 3892, 3841, 3890, 3840, 3883, 1023, 3876, 3887, 3877, 3715, 3743, 3652, 3804, 3769, 3844, 3861, 3823, 3864, 3708, 3881, 3811, 3810, 3869, 3875, 3815)
Run Time: 0.000429
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 130 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | Main_DBase.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | Main_DBase.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,Main_DBase.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",3296],["thread",2664],["thread",3886],["thread",3166],["thread",17],["thread",3836],["thread",3848],["thread",3088],["thread",2632],["thread",2773],["thread",3722],["thread",3121],["thread",3911],["thread",3124],["thread",3747],["thread",3850],["thread",3802],["thread",3806],["thread",3429],["thread",3777],["thread",3884],["thread",3826],["thread",3728],["thread",3835],["thread",3843],["thread",3915],["thread",3845],["thread",3819],["thread",3842],["thread",3904],["thread",3902],["thread",2701],["thread",3914],["thread",3912],["thread",3879],["thread",3137],["thread",3780],["thread",2337],["thread",2657],["thread",3786],["thread",2638],["thread",3905],["thread",3626],["thread",14],["thread",18],["thread",3913],["thread",3789],["thread",3908],["thread",3878],["thread",3749],["thread",3824],["thread",3822],["thread",3573],["thread",3241],["thread",3910],["thread",3909],["thread",2294],["thread",3907],["thread",3906],["thread",3896],["thread",3238],["thread",2770],["thread",3611],["thread",3903],["thread",3901],["thread",967],["thread",2400],["thread",2117],["thread",27],["thread",3629],["thread",2658],["thread",3242],["thread",3239],["thread",3880],["thread",3614],["thread",15],["thread",2118],["thread",966],["thread",3888],["thread",3882],["thread",3900],["thread",3613],["thread",968],["thread",3853],["thread",2193],["thread",3243],["thread",3854],["thread",3244],["thread",3839],["thread",3240],["thread",3245],["thread",3898],["thread",3251],["thread",3893],["thread",3894],["thread",3899],["thread",3891],["thread",3889],["thread",3897],["thread",3859],["thread",3686],["thread",3779],["thread",3895],["thread",3630],["thread",3855],["thread",3892],["thread",3841],["thread",3890],["thread",3840],["thread",3883],["thread",1023],["thread",3876],["thread",3887],["thread",3877],["thread",3715],["thread",3743],["thread",3652],["thread",3804],["thread",3769],["thread",3844],["thread",3861],["thread",3823],["thread",3864],["thread",3708],["thread",3881],["thread",3811],["thread",3810],["thread",3869],["thread",3875],["thread",3815]], 130, recent-posts, , [], date, 0, , [], 0, 1713546069, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.002749