SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002949s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413860 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413860 [ RunTime:0.002274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710777,653688,483118,69517,509676,822011,330117,326346,409909,358028,333082,4572,396535,94502,36226,326905,353588,584441,1010305,950891,224945,139965,226286,96785,204935,641275,691961,174198,1040041,247609,895081,862509,61275,651587,1006382,688533,285749,135388,870444,193456,352657,69550,412386,70176,748561,419650,496477,71127,459887,405981,17998,559674,716234,748218,156667,1046772,462705,954291,936283,572043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]