SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002733s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555943 LIMIT 1 [ RunTime:0.000885s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555943 [ RunTime:0.008060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488303,542344,1043545,871335,701512,968311,161513,824187,716254,673477,182932,468251,333921,340569,500525,853918,767651,858529,628740,415478,889331,242429,119626,683019,183293,304720,440352,575004,596190,171817,605828,1004233,659362,376202,778198,966192,508798,848161,723866,747679,403965,882646,583796,708881,932969,632007,912507,803917,88512,937440,88907,197367,395923,163902,314903,288834,716975,59183,550057,713994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001878s ]