SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34568 LIMIT 1 [ RunTime:0.000876s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34568 [ RunTime:0.008512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676825,935815,426054,138714,733465,979797,606409,592161,741061,217920,314069,179236,377691,930375,101574,941550,698650,893348,180786,126001,612247,93153,780924,526994,974214,50946,912421,748518,964344,790205,673095,252507,861175,778072,380701,727092,175707,473867,503170,928985,209703,8966,822085,851800,671344,160246,343750,353081,58601,345789,46820,627144,505563,470506,539440,635904,947557,517856,478746,640378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]