SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404947 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404947 [ RunTime:0.002825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002345,326251,529762,160063,762834,830489,236282,431499,403306,194287,798918,441498,116583,1044622,298757,744552,534671,439611,161669,880953,135048,121393,874450,1038855,103698,569,502834,684790,170021,725093,861464,270857,363252,601408,728588,753523,909492,806757,328992,926151,351213,412929,660855,233079,17457,555591,173535,452966,581415,556321,941371,938270,419885,555352,974468,281922,605013,446183,856109,456722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]