SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009684 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009684 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8434,561740,740499,666419,1027094,695628,705223,947133,844558,342372,466503,615792,631773,661872,42847,998034,431669,454352,862647,379143,618946,889923,468792,803626,443557,939984,301083,944249,776841,666309,227569,1021995,930345,549090,584733,612643,285963,471565,692409,1027421,476306,405104,408619,105873,188203,150535,24944,294731,479545,101360,166938,466371,1027931,334479,702179,702761,566244,405334,316589,19767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]