SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477404 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477404 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441291,501339,351658,802053,75147,789417,206484,76000,948810,123979,714034,982058,609321,627017,791463,1040248,977554,566023,712366,419415,338852,249767,615486,954016,418587,891531,718422,492799,773371,193428,445638,856419,318399,1015346,1015148,293886,789961,835879,668796,963412,602060,564356,441674,995229,264671,384449,857108,109532,96321,316308,1015479,537080,72771,212924,34136,930033,328699,120897,419445,130524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]