SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423564 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423564 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9355,860988,823272,848708,922138,858704,1000924,855062,912557,807608,727339,717843,200895,211639,652177,143021,1028170,1042817,188393,752034,196281,28101,183778,869972,107166,69457,814441,500588,370299,636227,635341,380900,188304,538556,648823,38711,647953,136427,394112,265293,80481,392973,462007,798151,872948,431891,683389,866350,21397,857438,566690,740783,355691,315280,392381,648137,430516,750960,892126,769953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001408s ]