SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80280 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80280 [ RunTime:0.002945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354643,283944,150611,945364,876575,40823,539424,702583,541126,589159,471706,902420,721779,680297,428428,201653,353678,730280,410784,664371,1017616,796918,1021077,46313,143603,145606,253910,465746,25953,258729,896761,355623,495474,741703,116030,54834,34539,1043937,535929,926373,763850,345522,765949,460862,83934,320195,195128,940245,451130,665685,707492,997541,141924,953837,697572,996659,619974,530699,982603,231880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]