SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501580 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501580 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958053,459041,333897,358942,928203,276005,23901,812951,729343,147355,1044500,613209,447136,565224,953395,416905,18183,223217,572978,82521,924716,364518,165487,118133,705864,654852,183924,683192,242913,1006973,156629,468195,537203,725245,533857,315496,629911,977640,419352,985237,473998,272283,141142,627870,94601,321525,1022550,807248,756457,929095,314949,630888,825551,295224,336416,455934,745082,757711,687553,169036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]