SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021039 LIMIT 1 [ RunTime:0.001352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021039 [ RunTime:0.002868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512008,790538,701969,930691,17645,1041466,608895,518293,231572,912053,1024955,864817,277487,2872,338052,656351,222191,481037,866076,379242,533541,631206,377897,225615,240021,306653,564271,689410,964109,704139,642760,99795,605704,175172,111217,14704,643842,600326,371831,148818,956070,88269,611901,884344,496072,556945,88086,433454,146466,1040055,442352,321650,702772,229888,871457,997287,588554,754863,318504,973968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]