SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145221 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145221 [ RunTime:0.002309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757372,884608,878513,489116,116533,253013,655078,993538,436526,48019,226550,130632,881772,1041631,805349,904274,221289,873406,441163,882718,702003,141592,1020282,261628,375328,976554,334700,137782,281281,858032,714075,759974,20794,969585,117305,905340,592107,595753,627006,453060,288853,1012335,28921,236250,739777,879088,212527,644060,861238,238234,1045669,381292,491150,933411,252108,88669,721249,769269,816170,134292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]