SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201463 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201463 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23572,402535,133366,471215,507053,600127,21731,159512,608062,1007512,675388,630263,471916,134504,104739,690083,4317,344327,756865,664554,486311,100976,535410,933768,554224,68334,316351,716730,566195,953684,628862,308134,306002,1013264,110195,417259,1014128,526460,457068,707914,199189,828377,128331,1028965,231690,456755,14128,711441,575510,140227,800488,77883,662092,997837,469209,673134,886094,862046,577647,751911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000790s ]