SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506575 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506575 [ RunTime:0.005698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179418,264636,227497,850262,767911,417486,197412,217643,99647,357976,1028008,23175,492612,976108,575193,631077,190973,759648,558607,388503,845224,857032,684557,441276,749562,177212,189940,101994,504587,41043,507175,570301,979078,185291,880951,556835,457832,814579,192639,125042,317952,575986,318047,646179,31543,134788,795031,612196,654321,527092,401163,959245,65977,1004616,853911,66217,725772,670874,831433,909598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]