SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511906 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511906 [ RunTime:0.002292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031062,401660,176800,443596,826138,957361,338695,1006850,297094,695880,149035,866391,342383,123499,294430,181296,40011,267741,261754,211419,67391,11407,216597,199773,427857,8200,613258,597036,915683,775662,662071,251491,243997,495982,74303,804301,880556,17418,688801,798547,848601,209626,340376,403478,864891,515322,192338,168962,303153,321375,248472,182008,1047447,738543,655977,986726,470177,851182,442035,172351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]