SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204230 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204230 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489333,392790,653579,39262,993900,349204,188018,971104,552466,36580,841196,314541,317126,313419,709776,65074,802264,288461,443524,347601,76771,286124,502934,654890,963686,714419,639904,825894,554026,633740,375523,420099,367723,955851,780081,679657,168481,26521,952109,882117,772846,868327,749523,313634,885883,281427,394047,861566,974586,434160,731131,174527,18505,561227,670572,428430,981329,311494,193417,185728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]