SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 890580 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 890580 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931225,134891,402613,278276,498068,885011,266908,735957,92630,502844,1001944,119408,946378,166321,1012511,490462,769083,1006786,304850,339469,790312,994821,1032336,841250,407415,231156,726628,181193,659088,1018296,623743,45335,549432,676785,596499,85297,235365,819391,582914,24665,164406,356924,111318,725120,351397,202220,167154,960127,660781,520435,110734,1019267,998363,368271,147486,275542,887333,782790,785226,245027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 890580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 890580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]