SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201613 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201613 [ RunTime:0.002138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673089,279084,815634,930662,296054,276353,394417,10829,232479,437777,781095,892862,722394,278142,143980,331264,742398,287076,45090,75690,634921,723561,423691,500969,373175,64246,173408,876673,576762,381823,1044914,135621,16619,1025162,543823,58437,718314,480717,292299,723935,181530,595284,69517,434839,474262,43756,328552,180970,95241,439301,344831,741569,542111,587912,390071,613824,753580,899898,811818,859618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]