SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195997 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195997 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510383,524481,270407,828785,445391,93202,342753,502655,85262,661275,496320,279517,239115,711825,348777,559162,130332,902657,157122,236272,404533,311338,53294,727353,216279,507088,602716,906393,465403,870878,995565,486493,71798,344579,815744,774072,955028,362822,554001,857523,154200,498566,52741,527155,85308,868153,963746,1003651,503565,609044,985389,117156,13122,1015279,975887,883946,924605,385767,891213,694354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]