SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107891 LIMIT 1 [ RunTime:0.001002s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107891 [ RunTime:0.005455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986010,149984,542125,593899,559677,400210,990137,962477,749652,504554,184980,941429,777888,333328,419444,520674,198237,253712,591371,761641,450876,1006894,542461,954118,67514,981934,328663,988448,381898,898894,953360,543,210440,751534,664351,60484,848504,489775,79706,745119,575062,797032,806477,810518,236729,583579,145832,1016584,918234,592209,208945,663985,170003,400738,406736,1017920,642546,466215,702446,832115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]