SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403923 LIMIT 1 [ RunTime:0.000691s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403923 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343177,949583,821055,113282,367200,621143,524251,907604,884039,483451,696471,183065,676365,394838,961133,701982,73637,468011,373941,1037850,460136,548119,217298,363244,138007,580624,956003,219004,95798,613355,152900,829466,1010941,555749,207700,503389,709811,526901,96523,704491,173406,802431,350907,941525,282256,998355,899918,611089,660815,797003,834030,406273,618345,430765,910341,438233,121403,719289,701736,393857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]