SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 627083 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 627083 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39686,1013278,126592,258555,583414,293242,575059,725511,13879,321521,116975,311882,787795,332919,70485,916993,1041273,422494,840353,865607,236508,295498,282620,479541,272866,369499,879576,58298,744091,355741,551418,348425,835996,368476,143152,959670,390441,58240,205760,358046,865084,740453,1045375,624244,231563,182887,906393,646897,611389,175661,653458,471360,543399,260529,609015,645104,959128,765992,85835,94977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 627083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 627083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000812s ]