SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104105 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104105 [ RunTime:0.002475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680103,867018,979048,398124,283497,817875,109092,713881,463434,395935,341284,13992,235866,1048055,592593,634292,340388,346431,801803,544141,499469,129881,442099,98144,174792,133828,855479,741315,321427,321832,639306,848761,969274,903217,108644,520497,925966,378435,427958,519526,867043,799310,527631,566426,906927,456316,946980,314314,433096,199130,202623,335907,857842,877482,314541,1016343,705358,642336,184946,971198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]