SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027642 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027642 [ RunTime:0.002373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149326,765179,186228,51378,608393,646171,1038551,293093,780402,402541,317608,122521,153251,573551,825430,773048,732772,964917,261588,59305,631352,1011469,588239,791320,77025,544064,845118,1012241,188530,877202,431369,626952,559348,788086,984743,561625,384765,76058,290476,638055,895223,975561,721439,478230,842066,228426,614020,725858,250767,863684,1006014,799018,44493,671537,151230,139821,874784,511368,546843,444218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]