SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004687s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506470 LIMIT 1 [ RunTime:0.002696s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506470 [ RunTime:0.003657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899081,718813,672691,315453,944297,871406,171482,989228,295002,136231,630638,614837,710257,860341,975227,939750,77583,228476,957114,112374,752977,807713,256875,916289,296294,160603,74269,90846,116315,810765,292360,431647,348800,320464,892146,374803,397388,367312,646943,107542,898244,419298,883386,735440,251530,119930,429800,573193,184658,1034533,11255,303576,38773,75508,16546,194794,986415,557464,503284,416481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]