深圳智汇创想科技有限公司

修改了 指派给 ，旧值为 "chengwei"，新值为 "yaojieyuan"。
修改了 任务描述，区别为：

006-
006+
007- 索引优化建议：
007+ 索引优化建议：
008- 建议在数据表irobotbox_marketpublish.M_Mercadolibre_Notiftransfer_Site的UserId,Status,SiteId列上添加如下索引，以提高查询性能：
008+ 建议在数据表irobotbox_marketpublish.M_Mercadolibre_Notiftransfer_Site的UserId,Status,SiteId列上添加如下索引，以提高查询性能：
010-
010+
011- 注意：在业务高峰期，变更表结构存在风险，请谨慎操作！
011+ 注意：在业务高峰期，变更表结构存在风险，请谨慎操作！
012-
012+
013-
013+ 3.慢sql
014- 3.慢sql
014+
015-
015+ SELECT `Id` AS `Id`, `UserId` AS `UserId`, `ApplicationId` AS `ApplicationId`, 2 AS `Type`, `SiteId` AS `Resource`
016- SELECT `Id` AS `Id`, `UserId` AS `UserId`, `ApplicationId` AS `ApplicationId`, 2 AS `Type`, `SiteId` AS `Resource`
016+ , `Status` AS `Status`, `SentTime` AS `Sent`, `SentTime` AS `Received`
017- , `Status` AS `Status`, `SentTime` AS `Sent`, `SentTime` AS `Received`
017+ FROM `M_Mercadolibre_Notiftransfer_Site`
018- FROM `M_Mercadolibre_Notiftransfer_Site`
018+ WHERE `UserId` = '1165164882'
019- WHERE `UserId` = '1165164882'
019+ AND `Status` = 0
020- AND `Status` = 0
020+ AND NOT (`SiteId` IS NULL
021- AND NOT (`SiteId` IS NULL
021+ OR `SiteId` = '')
022- OR `SiteId` = '')
022+ GROUP BY `SiteId`, `UserId`
023- GROUP BY `SiteId`, `UserId`
023+ ORDER BY Id DESC
024- ORDER BY Id DESC
024+ LIMIT 400, 200
025- LIMIT 400, 200
025+
026-
027-

006- <p>
006+ <p><br /></p>
007- </p><div class="sql_tuning_advice_title-3b3aBp" style="margin:10px 0px 5px;padding:0px;color:#FF8833;font-family:HuaweiFont, Helvetica, Arial, 'PingFangSC-Regular';">索引优化建议：</div>
007+ <div class="sql_tuning_advice_title-3b3aBp" style="margin:10px 0px 5px;padding:0px;color:#FF8833;font-family:HuaweiFont, Helvetica, Arial, 'PingFangSC-Regular';">索引优化建议：</div>
008- <ol class="ng-scope" style="margin-left:0px;color:#252B3A;font-family:HuaweiFont, Helvetica, Arial, 'PingFangSC-Regular';"><li class="ng-binding ng-scope">建议在数据表<span class="warning_color-PMRVtN" style="color:#FF8833;">irobotbox_marketpublish.M_Mercadolibre_Notiftransfer_Site</span>的<span class="warning_color-PMRVtN" style="color:#FF8833;">UserId,Status,SiteId</span>列上添加如下索引，以提高查询性能：
008+ <ol class="ng-scope" style="margin-left:0px;color:#252B3A;font-family:HuaweiFont, Helvetica, Arial, 'PingFangSC-Regular';"><li class="ng-binding ng-scope">建议在数据表<span class="warning_color-PMRVtN" style="color:#FF8833;">irobotbox_marketpublish.M_Mercadolibre_Notiftransfer_Site</span>的<span class="warning_color-PMRVtN" style="color:#FF8833;">UserId,Status,SiteId</span>列上添加如下索引，以提高查询性能：
010- </li>
010+ </li>
011- </ol><p class="mt5 ng-binding ng-scope" style="color:#252B3A;font-family:HuaweiFont, Helvetica, Arial, 'PingFangSC-Regular';">注意：在业务高峰期，变更表结构存在风险，请谨慎操作！</p>
011+ </ol><p class="mt5 ng-binding ng-scope" style="color:#252B3A;font-family:HuaweiFont, Helvetica, Arial, 'PingFangSC-Regular';">注意：在业务高峰期，变更表结构存在风险，请谨慎操作！</p>
012- <p><br /></p>
012+ <p><br /></p>
013-
013+ <p>3.慢sql</p>
014- <p>3.慢sql</p>
014+ <p><br /></p>
015- <p>
015+ <pre class="ng-binding">SELECT `Id` AS `Id`, `UserId` AS `UserId`, `ApplicationId` AS `ApplicationId`, 2 AS `Type`, `SiteId` AS `Resource`
016- </p><pre class="ng-binding">SELECT `Id` AS `Id`, `UserId` AS `UserId`, `ApplicationId` AS `ApplicationId`, 2 AS `Type`, `SiteId` AS `Resource`
016+ , `Status` AS `Status`, `SentTime` AS `Sent`, `SentTime` AS `Received`
017- , `Status` AS `Status`, `SentTime` AS `Sent`, `SentTime` AS `Received`
017+ FROM `M_Mercadolibre_Notiftransfer_Site`
018- FROM `M_Mercadolibre_Notiftransfer_Site`
018+ WHERE `UserId` = '1165164882'
019- WHERE `UserId` = '1165164882'
019+ AND `Status` = 0
020- AND `Status` = 0
020+ AND NOT (`SiteId` IS NULL
021- AND NOT (`SiteId` IS NULL
021+ OR `SiteId` = '')
022- OR `SiteId` = '')
022+ GROUP BY `SiteId`, `UserId`
023- GROUP BY `SiteId`, `UserId`
023+ ORDER BY Id DESC
024- ORDER BY Id DESC
024+ LIMIT 400, 200</pre>
025- LIMIT 400, 200</pre>
025+ <p><br /></p>
026-
027- <p><br /></p>

修改了 总计消耗，旧值为 "0"，新值为 "0.5"。
修改了 指派给 ，旧值为 "yaojieyuan"，新值为 "chenshaojun"。
修改了 实际完成，旧值为 ""，新值为 "2023-04-19 10:58:36"。
修改了 任务状态，旧值为 "wait"，新值为 "done"。
修改了 实际开始，旧值为 "0000-00-00 00:00:00"，新值为 "2023-04-19 10:58:47"。
修改了 由谁完成，旧值为 ""，新值为 "yaojieyuan"。

修改了 任务状态，旧值为 "done"，新值为 "closed"。
修改了 指派给 ，旧值为 "chenshaojun"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "zhoujie"。
修改了 关闭时间，旧值为 "0000-00-00 00:00:00"，新值为 "2023-10-31 14:53:16"。
修改了 关闭原因，旧值为 ""，新值为 "done"。