SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804478 LIMIT 1 [ RunTime:0.002416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804478 [ RunTime:0.002791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198125,790303,181937,937990,129840,209304,113553,727921,629470,313855,196221,871234,314954,880746,1043375,278958,354678,832246,174942,52379,983155,455171,943995,557732,37674,131639,238455,266409,25937,759262,239960,727963,1040497,884239,406617,263487,847324,1042764,34344,123795,50750,443428,826830,505337,272148,147476,118991,957821,950644,468130,979312,170956,361461,557503,212286,455779,27140,286303,627015,284770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]