SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512713 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512713 [ RunTime:0.003196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875064,779122,734177,511994,115819,681336,252093,190472,75829,582537,485611,690007,470579,1038281,767345,354054,795559,376573,476561,681983,524289,732928,687337,1001310,460238,141217,956514,790946,1342,57705,106838,290659,123812,962703,876099,510032,247661,958876,320144,998924,704015,217542,884548,793214,197277,514311,1037133,711622,610459,80509,652624,460064,628436,316756,32333,1045436,473357,46993,719313,785815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002142s ]