SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 704313 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 704313 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813343,514223,296404,819451,741662,801756,784145,101447,1035265,800460,1014965,381840,904404,161126,622487,622663,922286,652560,502342,1046497,387153,234757,161037,616962,363704,286409,290358,641226,438265,413817,588603,740660,851056,341859,135493,65460,1006845,881435,789356,1043136,175811,943516,668907,699063,169463,582897,90264,248186,649770,144130,882853,271176,617538,232276,165434,399259,514707,1043939,335090,324333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 704313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 704313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]