SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486581 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486581 [ RunTime:0.002544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601362,678135,642361,241238,904341,554455,538152,806374,948982,787760,118251,24398,726798,435811,171651,669293,129992,622350,859690,493761,228929,204379,665275,95200,482210,153364,357557,1014491,389575,239543,20126,660129,403504,448664,806797,177193,613203,499207,1043408,339495,688285,1003705,230450,290464,86399,73020,561663,350042,212125,709248,887601,857461,832610,256004,793919,924791,337127,688562,771640,394690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]