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 (2939, 2938, 2937, 2936, 241, 16, 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, 2814, 2813, 2812, 2811, 2810, 2809, 2808, 2807, 2806, 2805, 2804, 2803, 2802, 2801, 2800, 2799, 2798, 2797, 2796, 2795, 2794, 2793, 2792, 2791, 2790, 2789, 2788, 2787, 2786, 2785, 2784, 2783, 2782, 2781, 2780, 2779, 2778, 2777, 2776, 2775, 2774, 2773, 2772, 2771, 2770, 2769, 2768, 2767, 2766, 2765, 2764, 2763, 2762, 2761, 2760, 2759, 2758, 2757, 2756, 2755, 2754, 2753, 2752, 2751, 2750, 2749, 2748, 2747, 2746, 2745, 2744, 2743, 2742, 2741, 2740, 2739, 2738, 2737, 2736)
Run Time: 0.005514
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",2939],["thread",2938],["thread",2937],["thread",2936],["thread",241],["thread",16],["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],["thread",2814],["thread",2813],["thread",2812],["thread",2811],["thread",2810],["thread",2809],["thread",2808],["thread",2807],["thread",2806],["thread",2805],["thread",2804],["thread",2803],["thread",2802],["thread",2801],["thread",2800],["thread",2799],["thread",2798],["thread",2797],["thread",2796],["thread",2795],["thread",2794],["thread",2793],["thread",2792],["thread",2791],["thread",2790],["thread",2789],["thread",2788],["thread",2787],["thread",2786],["thread",2785],["thread",2784],["thread",2783],["thread",2782],["thread",2781],["thread",2780],["thread",2779],["thread",2778],["thread",2777],["thread",2776],["thread",2775],["thread",2774],["thread",2773],["thread",2772],["thread",2771],["thread",2770],["thread",2769],["thread",2768],["thread",2767],["thread",2766],["thread",2765],["thread",2764],["thread",2763],["thread",2762],["thread",2761],["thread",2760],["thread",2759],["thread",2758],["thread",2757],["thread",2756],["thread",2755],["thread",2754],["thread",2753],["thread",2752],["thread",2751],["thread",2750],["thread",2749],["thread",2748],["thread",2747],["thread",2746],["thread",2745],["thread",2744],["thread",2743],["thread",2742],["thread",2741],["thread",2740],["thread",2739],["thread",2738],["thread",2737],["thread",2736]], 200, recent-posts, , [], date, 0, , [], 0, 1714965907, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.001498