SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542891 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542891 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25477,297391,961982,762234,400170,439802,522420,524965,161014,649175,24575,361677,477097,230780,172198,146107,690653,928848,331321,153146,727079,455541,327041,562626,788097,878032,965731,890043,497691,715406,96590,529607,543367,290385,904925,330383,267463,717703,990435,971530,443943,295097,604598,222714,701393,287985,318945,27465,99856,633676,89425,255038,243797,249694,73229,8511,852096,146790,775852,279627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]