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 (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, 16, 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, 2735, 2734, 2733, 2732, 2730, 2729, 2728, 2727, 2726, 2725, 2724, 2723, 2722, 2721, 2720, 2719, 2718, 2717, 749, 2713, 2712, 2711, 2710, 2709, 2708, 2707, 2706, 2705, 2704, 2703, 2702, 2701, 2700, 2699, 2698, 2697, 2696, 2695, 2238, 2686, 1836, 2685, 2684, 2683, 2682, 2679, 2678, 2677, 2676, 2675, 2674, 2673, 2672, 2671, 2670, 2669, 2668, 2667, 2666, 2665, 2664, 2663, 2662, 2661, 2206, 1158, 1344, 1907, 2647)
Run Time: 0.005067
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",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",16],["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],["thread",2735],["thread",2734],["thread",2733],["thread",2732],["thread",2730],["thread",2729],["thread",2728],["thread",2727],["thread",2726],["thread",2725],["thread",2724],["thread",2723],["thread",2722],["thread",2721],["thread",2720],["thread",2719],["thread",2718],["thread",2717],["thread",749],["thread",2713],["thread",2712],["thread",2711],["thread",2710],["thread",2709],["thread",2708],["thread",2707],["thread",2706],["thread",2705],["thread",2704],["thread",2703],["thread",2702],["thread",2701],["thread",2700],["thread",2699],["thread",2698],["thread",2697],["thread",2696],["thread",2695],["thread",2238],["thread",2686],["thread",1836],["thread",2685],["thread",2684],["thread",2683],["thread",2682],["thread",2679],["thread",2678],["thread",2677],["thread",2676],["thread",2675],["thread",2674],["thread",2673],["thread",2672],["thread",2671],["thread",2670],["thread",2669],["thread",2668],["thread",2667],["thread",2666],["thread",2665],["thread",2664],["thread",2663],["thread",2662],["thread",2661],["thread",2206],["thread",1158],["thread",1344],["thread",1907],["thread",2647]], 200, recent-posts, , [], date, 0, , [], 0, 1714135109, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.001208