SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801102 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801102 [ RunTime:0.005496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273902,12807,849714,1000782,585971,24283,850181,964994,1017812,39176,917714,198103,736406,357286,7676,866323,770077,901121,840201,475121,698955,728944,306261,952995,1038003,474583,528301,695704,503166,725149,200177,1018019,68570,108886,536227,340112,376368,257830,465511,73480,39151,522417,981586,1030142,382039,7000,424549,986466,72375,359786,656126,824377,487513,154621,785220,1043471,137276,975558,695124,825958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]