SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 91083 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 91083 [ RunTime:0.003218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199604,386366,309778,722838,801617,816802,678776,27583,845547,563383,912114,201070,292601,37833,165610,388759,798837,452187,318523,48996,412048,639453,374625,105448,929506,606514,126748,237437,186656,872053,231558,1031706,942179,291359,38450,399631,927982,389433,1020039,103951,235882,922316,998400,638088,491469,261252,419740,120986,973031,1042503,794567,609077,794742,983634,1032930,679141,611688,972462,932347,966853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 91083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 91083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]