SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 91968 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 91968 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319506,943028,1036477,441054,180964,551258,183146,949660,848789,313,334914,92200,17742,946785,328314,351367,963018,443808,191933,175498,788277,632265,719664,462179,150962,269613,931854,968591,269011,88431,21302,79794,651009,289085,619530,937599,401307,270466,518571,729732,421401,680957,391722,276710,196453,977027,930596,436461,1004574,693384,299033,228744,787900,12678,300207,160760,1038282,1008320,116454,43998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 91968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 91968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000972s ]