SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407010 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407010 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601170,736158,145558,330453,287245,514681,417204,127317,298054,398837,317618,810479,699275,559141,125326,741198,348322,890219,178097,25013,283780,271981,768399,783410,898750,953423,377093,936853,652884,109106,144826,232329,490293,719091,457662,95659,904372,720922,21313,415570,304579,1008318,709051,158023,701144,11856,841614,764717,815507,778129,220587,330487,316645,214225,178430,796589,502896,39889,301270,180179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]