SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029647 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029647 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219443,579034,552753,921281,171180,679212,255351,250625,925048,780725,977703,269848,795573,480171,269408,682364,377642,805681,222219,834328,205344,378560,323381,593005,90872,463315,275366,545812,707128,914945,478056,151298,1006771,260048,641387,1027585,499021,864464,332089,175578,778948,312249,962594,826567,394377,621605,297508,481220,467033,141436,111262,315225,194212,987402,981230,742770,916749,246154,728626,824763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029647 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029647 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]