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 (2670, 3020, 3019, 3018, 3017, 3016, 3015, 3014, 3013, 3012, 3011, 3010, 3009, 3008, 3007, 3006, 3005, 3004, 3003, 3002, 3001, 3000, 2999, 2998, 16, 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, 2873, 2872, 2871, 2870, 2869, 2868, 2867, 2866, 2865, 2864, 2863, 2862, 2861, 2860, 2859, 2858, 2857, 2856, 2855, 2854, 2853, 2852, 2851, 2850, 2849, 2848, 2847, 2846, 2845, 2844, 2843, 2842, 2841, 2840, 2839, 2838, 2837, 2836, 2835, 2834, 2833, 2832, 2831, 2830, 2829, 2828, 2827, 2826, 2825, 2823, 800, 2821, 2820, 2819, 2818, 2817, 2816, 2815)
Run Time: 0.004626
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",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",16],["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],["thread",2873],["thread",2872],["thread",2871],["thread",2870],["thread",2869],["thread",2868],["thread",2867],["thread",2866],["thread",2865],["thread",2864],["thread",2863],["thread",2862],["thread",2861],["thread",2860],["thread",2859],["thread",2858],["thread",2857],["thread",2856],["thread",2855],["thread",2854],["thread",2853],["thread",2852],["thread",2851],["thread",2850],["thread",2849],["thread",2848],["thread",2847],["thread",2846],["thread",2845],["thread",2844],["thread",2843],["thread",2842],["thread",2841],["thread",2840],["thread",2839],["thread",2838],["thread",2837],["thread",2836],["thread",2835],["thread",2834],["thread",2833],["thread",2832],["thread",2831],["thread",2830],["thread",2829],["thread",2828],["thread",2827],["thread",2826],["thread",2825],["thread",2823],["thread",800],["thread",2821],["thread",2820],["thread",2819],["thread",2818],["thread",2817],["thread",2816],["thread",2815]], 200, recent-posts, , [], date, 0, , [], 0, 1715293245, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.002494