SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457980 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457980 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976581,464125,619464,14801,694745,526547,487655,438735,672708,117775,124160,634099,698920,662897,262211,172684,866133,688117,15490,922212,567550,580225,21881,243847,153597,505413,246284,109027,567192,802633,388767,857383,697275,425401,59918,450994,532264,738516,558957,961563,658764,287813,158558,905727,740679,530939,941085,136881,759498,228267,674313,418981,218472,256421,578598,598339,369013,1021505,14427,26289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]