SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580393 LIMIT 1 [ RunTime:0.002306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580393 [ RunTime:0.002583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383297,449247,252902,490315,198460,268050,1020151,878598,364734,998056,950013,567546,425014,1042221,864282,766421,861750,1044344,281426,121841,764876,159236,839339,55256,415591,326625,874900,244789,885760,295095,175479,1030639,729751,617527,671197,245622,847488,552778,706862,287601,952675,814832,155624,611210,660156,205357,416546,536938,756635,650806,664046,129067,69797,348527,189797,425723,699352,793125,877387,730204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]