SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31118 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31118 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861340,43404,1045860,1037241,538803,167774,69144,253024,984392,756233,388310,720656,88341,437935,410050,441588,172921,113012,53390,265985,460313,159066,917809,821608,689671,862987,937471,902061,1015803,626602,490391,773602,397445,23193,446956,291115,529678,68295,809413,561153,780104,736249,191421,392881,331820,838271,271470,148474,1006113,579798,478687,252137,491028,990141,912226,898573,878686,26541,990097,681269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]