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 (16, 3102, 3101, 3099, 3098, 3097, 3096, 3095, 3094, 3093, 3092, 3091, 3090, 3089, 3088, 3087, 3086, 3085, 3084, 3083, 3040, 2160, 3064, 3063, 3062, 3061, 3060, 3056, 3055, 3054, 3053, 3052, 3051, 3050, 3049, 3048, 3047, 3046, 3045, 3044, 3039, 3038, 3037, 3036, 3035, 3034, 3033, 3032, 3031, 3030, 3029, 3028, 3027, 3026, 3025, 3024, 3023, 3022, 3021, 2670, 3020, 3019, 3018, 3017, 3016, 3015, 3014, 3013, 3012, 3011, 3010, 3009, 3008, 3007, 3006, 3005, 3004, 3003, 3002, 3001, 3000, 2999, 2998, 2997, 2996, 2995, 2994, 2993, 2992, 2991, 2990, 2989, 2988, 2987, 2986, 2984, 2983, 2982, 2981, 2980, 2979, 2978, 2977, 2976, 2975, 2974, 2973, 2972, 2971, 2970, 2969, 2968, 2967, 2966, 2965, 2964, 2963, 2962, 2961, 2960, 2959, 2958, 2957, 2956, 2955, 2954, 2953, 2952, 2951, 2950, 2949, 2948, 2947, 2946, 2945, 2944, 2943, 2941, 2939, 2938, 2937, 2936, 241, 749, 2931, 2930, 2929, 2928, 2927, 2926, 2925, 2924, 2923, 2922, 2921, 2920, 2919, 2918, 2917, 2916, 2915, 2914, 2913, 2912, 2911, 2910, 2909, 2908, 2907, 2905, 2904, 2903, 2902, 2901, 2900, 2899, 2898, 2897, 2896, 2895, 2894, 2893, 2892, 2891, 2890, 2889, 2888, 2887, 2886, 2885, 2884, 2883, 2882, 2881, 2880, 2879, 2878, 2877, 2876, 2874)
Run Time: 0.009339
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 | diendan_sach.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | diendan_sach.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,diendan_sach.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",16],["thread",3102],["thread",3101],["thread",3099],["thread",3098],["thread",3097],["thread",3096],["thread",3095],["thread",3094],["thread",3093],["thread",3092],["thread",3091],["thread",3090],["thread",3089],["thread",3088],["thread",3087],["thread",3086],["thread",3085],["thread",3084],["thread",3083],["thread",3040],["thread",2160],["thread",3064],["thread",3063],["thread",3062],["thread",3061],["thread",3060],["thread",3056],["thread",3055],["thread",3054],["thread",3053],["thread",3052],["thread",3051],["thread",3050],["thread",3049],["thread",3048],["thread",3047],["thread",3046],["thread",3045],["thread",3044],["thread",3039],["thread",3038],["thread",3037],["thread",3036],["thread",3035],["thread",3034],["thread",3033],["thread",3032],["thread",3031],["thread",3030],["thread",3029],["thread",3028],["thread",3027],["thread",3026],["thread",3025],["thread",3024],["thread",3023],["thread",3022],["thread",3021],["thread",2670],["thread",3020],["thread",3019],["thread",3018],["thread",3017],["thread",3016],["thread",3015],["thread",3014],["thread",3013],["thread",3012],["thread",3011],["thread",3010],["thread",3009],["thread",3008],["thread",3007],["thread",3006],["thread",3005],["thread",3004],["thread",3003],["thread",3002],["thread",3001],["thread",3000],["thread",2999],["thread",2998],["thread",2997],["thread",2996],["thread",2995],["thread",2994],["thread",2993],["thread",2992],["thread",2991],["thread",2990],["thread",2989],["thread",2988],["thread",2987],["thread",2986],["thread",2984],["thread",2983],["thread",2982],["thread",2981],["thread",2980],["thread",2979],["thread",2978],["thread",2977],["thread",2976],["thread",2975],["thread",2974],["thread",2973],["thread",2972],["thread",2971],["thread",2970],["thread",2969],["thread",2968],["thread",2967],["thread",2966],["thread",2965],["thread",2964],["thread",2963],["thread",2962],["thread",2961],["thread",2960],["thread",2959],["thread",2958],["thread",2957],["thread",2956],["thread",2955],["thread",2954],["thread",2953],["thread",2952],["thread",2951],["thread",2950],["thread",2949],["thread",2948],["thread",2947],["thread",2946],["thread",2945],["thread",2944],["thread",2943],["thread",2941],["thread",2939],["thread",2938],["thread",2937],["thread",2936],["thread",241],["thread",749],["thread",2931],["thread",2930],["thread",2929],["thread",2928],["thread",2927],["thread",2926],["thread",2925],["thread",2924],["thread",2923],["thread",2922],["thread",2921],["thread",2920],["thread",2919],["thread",2918],["thread",2917],["thread",2916],["thread",2915],["thread",2914],["thread",2913],["thread",2912],["thread",2911],["thread",2910],["thread",2909],["thread",2908],["thread",2907],["thread",2905],["thread",2904],["thread",2903],["thread",2902],["thread",2901],["thread",2900],["thread",2899],["thread",2898],["thread",2897],["thread",2896],["thread",2895],["thread",2894],["thread",2893],["thread",2892],["thread",2891],["thread",2890],["thread",2889],["thread",2888],["thread",2887],["thread",2886],["thread",2885],["thread",2884],["thread",2883],["thread",2882],["thread",2881],["thread",2880],["thread",2879],["thread",2878],["thread",2877],["thread",2876],["thread",2874]], 200, recent-posts, , [], date, 0, , [], 0, 1716302524, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000963