SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541330 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541330 [ RunTime:0.002599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225596,340186,383693,297922,1041476,82460,221603,458615,184320,620620,1035485,222579,393840,870820,656121,1029401,718227,10973,344075,366700,681985,191855,618211,1019456,13351,672338,812848,157115,538348,981100,53652,356846,795582,114306,603198,583271,782994,251519,885368,260503,510805,780764,398482,45111,510987,1003933,284007,927092,475458,483346,556882,291063,200077,123848,365736,342353,489060,22058,295761,89423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]