SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472843 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472843 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62906,195893,444997,350163,767718,162987,4987,290279,350297,598559,398863,979973,545741,619126,20197,239979,384480,556898,174616,631077,269135,1025100,387330,477541,728739,991003,550405,277527,429229,910702,70148,666972,154186,916493,592080,276559,338482,985997,137065,201745,318654,1045296,580617,198733,471624,34344,255083,116971,841051,890281,397112,983769,908856,744212,501952,324936,476356,674621,837795,160892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]