SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008228 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008228 [ RunTime:0.002112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882916,495916,376678,306913,290120,933048,635382,606240,563235,207640,977239,267975,239161,263418,440908,428084,614495,397589,898018,821439,242774,1027214,111386,332757,829344,2416,718981,546102,465160,247021,28177,710071,725081,468031,533956,1033146,556770,616727,418203,750606,221148,949343,376027,610748,767457,646225,651326,638935,683250,554848,136555,181889,689750,484954,554771,194683,27311,578428,464001,993090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]