SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282884 LIMIT 1 [ RunTime:0.002068s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282884 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455116,817996,209360,468801,329130,28534,813080,1020151,248508,384538,304043,153812,933372,818510,585421,1032056,278027,243925,318990,270649,828071,597270,935961,494932,731672,781236,991767,590229,648495,551065,691912,506483,911935,143041,815562,514074,880092,824082,899577,570538,83598,711741,69150,838898,938823,1044289,776651,375625,303036,444332,266358,136347,146113,317473,592215,522647,114872,869582,204850,111535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003938s ]