SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029384 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029384 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829079,147759,381368,460571,797662,114667,739433,118274,731213,417506,417124,103873,232350,295783,316554,1011002,469314,528064,606849,780214,416326,409158,142924,941204,627864,536922,346749,99180,696676,388243,445058,514641,204961,840957,3186,478262,30179,946213,474995,962324,596490,958559,217832,810123,36238,269739,666314,286449,851125,869900,596104,222518,594951,894447,662890,189431,776387,215446,663409,397674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]