SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 811158 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 811158 [ RunTime:0.002836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322305,1035085,666553,530823,832241,143847,390129,303102,247399,461324,914724,732600,222705,769194,197475,928613,101023,876302,561728,656864,1003416,1026265,650160,209561,162697,713661,580002,482094,798155,963799,859334,372935,452928,936223,940381,261502,380303,226194,878247,760939,897307,949515,616157,599374,461338,901003,982507,509765,545376,615968,612212,767100,951591,137575,233018,328944,157718,614231,630898,132614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 811158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 811158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001598s ]