SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006291 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006291 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228944,40074,702366,14223,613638,151257,358939,838607,531882,740903,540749,32634,841905,145964,965892,474185,207439,824859,993699,984879,997941,870403,621033,1004224,379885,1005549,143297,572976,793314,380001,11412,271615,828471,363739,1009186,288453,180002,867912,781007,903737,260974,154052,579857,934608,440030,170388,665760,378740,10644,790109,853996,194464,284460,175442,103945,1013743,153198,520451,355235,287551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]