SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50371 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50371 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783535,330894,123462,322104,862783,129929,378042,862532,624884,284405,42152,225901,117333,21978,829839,56787,707517,83948,295058,5016,932963,469145,262353,818169,109225,175678,967073,266976,93999,865096,692411,222640,396614,770791,888916,241715,880522,890909,869254,859785,64273,844900,603591,807511,811711,150660,47318,128271,414103,245187,34326,621020,742471,926340,71375,152274,487808,895139,973578,959021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]