SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 942601 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 942601 [ RunTime:0.002517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738389,449556,987598,1013342,691336,689163,250541,27007,697147,285598,101703,262946,540405,765268,1043568,18472,778513,359474,188588,1002060,661031,397848,668798,10403,916295,406785,613318,609711,977350,761884,63317,494906,894126,710726,842903,125848,961762,440520,246636,585985,1032586,775836,872311,760754,956838,85550,441675,281860,620088,790207,489869,801194,600224,231630,800299,435457,617206,139138,306567,517333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 942601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 942601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002392s ]