SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30213 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30213 [ RunTime:0.002673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780648,500080,54230,738704,384022,744926,563565,533913,697968,855988,367562,500819,289517,920387,105234,1027860,331041,888279,303639,1040782,596629,677386,713949,878755,648171,845505,652376,104312,598778,78012,220472,47222,105121,515373,322572,988327,788936,103597,46331,268174,686807,866479,370846,885866,533049,365323,452190,716617,418143,378878,908317,45158,279136,479383,92786,361604,584153,133697,745754,429691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001973s ]