SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440786 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440786 [ RunTime:0.002176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425514,131758,366076,605391,294978,27688,617273,219052,1013393,175344,625200,303265,571340,986744,919267,522066,714038,1033634,30626,205671,520956,764607,542946,516209,658257,689628,312114,87234,39203,258199,4847,562542,694805,455163,465704,51657,506993,484454,675146,394824,514171,388910,908536,177020,105950,73564,472144,140811,775705,67080,253369,331616,879139,139770,1039033,806747,134482,962880,73877,954014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440786 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440786 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]