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 (2715, 16, 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, 2648, 2646, 2645, 2644, 2643, 2642, 2641, 2640, 2639, 2638, 2637, 2636, 2635, 2634, 2633, 2632, 2631, 2630, 2629, 2628, 2627, 2626, 2625, 2624, 2623, 2622, 2621, 2620, 2619, 2618, 2617, 2616, 2615, 2614, 2610, 2609, 2608, 2607, 2606, 2596, 2595, 2594, 2593, 2592, 2591, 2590, 2589, 2588, 2587, 2586, 2585, 2584, 2583, 2582, 2581, 2580, 2579, 2578, 2577, 2576, 2575, 2574, 2573, 2572, 2571, 2570, 2569, 2568, 2567, 2566, 2565, 2564, 2563, 2562, 2561, 2560, 2559, 2558, 2557, 2556, 2555, 2554, 2553, 2552, 2551, 2550, 2549, 2548, 2547, 2546, 2545, 2544, 2543, 2542, 2541, 2540, 2539, 2538, 2537, 2536)
Run Time: 0.001216
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 152 | 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",2715],["thread",16],["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],["thread",2648],["thread",2646],["thread",2645],["thread",2644],["thread",2643],["thread",2642],["thread",2641],["thread",2640],["thread",2639],["thread",2638],["thread",2637],["thread",2636],["thread",2635],["thread",2634],["thread",2633],["thread",2632],["thread",2631],["thread",2630],["thread",2629],["thread",2628],["thread",2627],["thread",2626],["thread",2625],["thread",2624],["thread",2623],["thread",2622],["thread",2621],["thread",2620],["thread",2619],["thread",2618],["thread",2617],["thread",2616],["thread",2615],["thread",2614],["thread",2610],["thread",2609],["thread",2608],["thread",2607],["thread",2606],["thread",2596],["thread",2595],["thread",2594],["thread",2593],["thread",2592],["thread",2591],["thread",2590],["thread",2589],["thread",2588],["thread",2587],["thread",2586],["thread",2585],["thread",2584],["thread",2583],["thread",2582],["thread",2581],["thread",2580],["thread",2579],["thread",2578],["thread",2577],["thread",2576],["thread",2575],["thread",2574],["thread",2573],["thread",2572],["thread",2571],["thread",2570],["thread",2569],["thread",2568],["thread",2567],["thread",2566],["thread",2565],["thread",2564],["thread",2563],["thread",2562],["thread",2561],["thread",2560],["thread",2559],["thread",2558],["thread",2557],["thread",2556],["thread",2555],["thread",2554],["thread",2553],["thread",2552],["thread",2551],["thread",2550],["thread",2549],["thread",2548],["thread",2547],["thread",2546],["thread",2545],["thread",2544],["thread",2543],["thread",2542],["thread",2541],["thread",2540],["thread",2539],["thread",2538],["thread",2537],["thread",2536]], 152, recent-posts, , [], date, 0, , [], 0, 1713397680, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000826