SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338916 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338916 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400076,378660,908329,213470,634126,257923,966206,183110,121328,441432,749419,634146,773787,926629,599484,710403,584842,338691,670892,547490,1041515,982709,284202,715568,464378,917748,81977,606626,32551,859066,1019710,825941,866933,459626,970232,881261,157982,934541,526353,887802,455498,949327,916745,789787,430341,239325,16248,1047282,314719,825084,16434,568856,814946,364416,853239,948527,587360,284694,86237,558843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000802s ]