SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458243 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458243 [ RunTime:0.003825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465333,679528,121653,252306,683287,230318,987980,566628,646133,662017,781742,889316,606515,614945,447617,872052,517147,117899,598225,685000,728711,340974,115225,46402,313469,387460,796238,123786,508962,205230,595562,1013489,952722,793384,553616,659000,526211,121071,866550,802589,789745,951326,279002,912863,659579,251945,348137,844159,517588,505283,304770,932009,825129,607273,975372,465415,346194,981719,966173,821798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002586s ]