SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001700s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261716 LIMIT 1 [ RunTime:0.001421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261716 [ RunTime:0.002282s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623155,284555,668478,530910,449432,610705,983089,502762,97514,416454,54402,689388,666655,38586,629138,26213,793021,911250,86357,273479,772415,326986,504934,684687,591055,244797,244183,246138,73925,752105,465139,63926,41154,536865,91445,772739,1037722,357522,852924,930251,696979,13058,49172,689853,75522,816848,538969,821910,714066,167807,127681,373491,968060,682092,359153,351554,498293,372025,108779,956763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]