SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201093 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201093 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161234,807801,212788,611297,885420,806234,61964,237866,579920,87646,930485,845988,531070,394816,1024086,910259,816783,409930,979654,702370,749004,217110,517274,635560,261530,1035673,18843,383471,28992,442882,542473,325986,873237,236258,947096,899786,1009000,968287,63666,465496,291617,873555,1039139,196433,138584,711130,611676,76342,616020,835262,61517,857333,606310,929541,436790,317378,733475,94606,79623,734835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]