SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476852 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476852 [ RunTime:0.002095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169208,851260,552306,881812,179053,1011525,1002735,145449,687198,1048302,631400,436909,939427,243608,875845,886500,501165,664755,860529,540788,333423,877336,1012287,623934,812419,285422,741640,262555,952114,27234,659503,655985,221130,657054,30261,420890,618282,423007,299103,872890,281825,257733,489734,876828,991163,975201,888193,416069,378454,904247,2649,801830,835865,249301,304854,550781,335122,795852,7676,739951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476852 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476852 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001287s ]