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

修改了 任务描述，区别为：

010- 原始sql:
010+ 是否可以去掉ORDER BY ，同步每次取200条，同步完成后修改status=0 到status=1,下次取200条就可以了
012- SELECT `Id` AS `Id` , `UserId` AS `UserId` , `ApplicationId` AS `ApplicationId` , 2 AS `Type` , `SiteId` AS `Resource` , `Status` AS `Status` , `SentTime` AS `Sent` , `SentTime` AS `Received` FROM `M_Mercadolibre_Notiftransfer_Site` WHERE (((( `UserId` = '678105364' ) AND ( `CreateTime` > timestamp('2023-07-21 13:33:48.975197') )) AND ( `Status` = 0 )) AND NOT( `SiteId` IS NULL OR `SiteId`='')) ORDER BY Id DESC LIMIT 0,200
012+ 原始sql:
013+
014+ SELECT `Id` AS `Id` , `UserId` AS `UserId` , `ApplicationId` AS `ApplicationId` , 2 AS `Type` , `SiteId` AS `Resource` , `Status` AS `Status` , `SentTime` AS `Sent` , `SentTime` AS `Received` FROM `M_Mercadolibre_Notiftransfer_Site` WHERE (((( `UserId` = '678105364' ) AND ( `CreateTime` > timestamp('2023-07-21 13:33:48.975197') )) AND ( `Status` = 0 )) AND NOT( `SiteId` IS NULL OR `SiteId`='')) ORDER BY Id DESC LIMIT 0,200

010- <p>原始sql:</p>
010+ <p>是否可以去掉<span>ORDER BY ，同步每次取200条，同步完成后修改status=0 到status=1,下次取200条就可以了</span></p>
012- <p>SELECT `Id` AS `Id` , `UserId` AS `UserId` , `ApplicationId` AS `ApplicationId` , 2 AS `Type` , `SiteId` AS `Resource` , `Status` AS `Status` , `SentTime` AS `Sent` , `SentTime` AS `Received` FROM `M_Mercadolibre_Notiftransfer_Site` WHERE (((( `UserId` = '678105364' ) AND ( `CreateTime` &gt; timestamp('2023-07-21 13:33:48.975197') )) AND ( `Status` = 0 )) AND NOT( `SiteId` IS NULL OR `SiteId`='')) ORDER BY Id DESC LIMIT 0,200</p>
012+ <p>原始sql:</p>
013+ <p><br /></p>
014+ <p>SELECT `Id` AS `Id` , `UserId` AS `UserId` , `ApplicationId` AS `ApplicationId` , 2 AS `Type` , `SiteId` AS `Resource` , `Status` AS `Status` , `SentTime` AS `Sent` , `SentTime` AS `Received` FROM `M_Mercadolibre_Notiftransfer_Site` WHERE (((( `UserId` = '678105364' ) AND ( `CreateTime` &gt; timestamp('2023-07-21 13:33:48.975197') )) AND ( `Status` = 0 )) AND NOT( `SiteId` IS NULL OR `SiteId`='')) ORDER BY Id DESC LIMIT 0,200</p>

修改了 任务描述，区别为：

005- 2.解决方案
005+ select count(0) from `M_Mercadolibre_Notiftransfer_Site` where status=1 -- 5544213select count(0) from `M_Mercadolibre_Notiftransfer_Site` where status=0 -- 1125select count(0) from `M_Mercadolibre_Notiftransfer_Site` where status=3 -- 222select count(0) from `M_Mercadolibre_Notiftransfer_Site` where status=9 -- 323906
006- DBA 测试后给的方案是指定索引比较快，先添加一下
006+ select count(0) from `M_Mercadolibre_Notiftransfer_Site` -- 302093746 302216446
008- `M_Mercadolibre_Notiftransfer_Site` force index(idx_UserId_Status_CreateTime_id)
008+ 2.解决方案
009-
009+ DBA 测试后给的方案是指定索引比较快，先添加一下
010- 是否可以去掉ORDER BY ，同步每次取200条，同步完成后修改status=0 到status=1,下次取200条就可以了
010+
011-
011+ `M_Mercadolibre_Notiftransfer_Site` force index(idx_UserId_Status_CreateTime_id)
012- 原始sql:
012+
013-
013+ 是否可以去掉ORDER BY ，同步每次取200条，同步完成后修改status=0 到status=1,下次取200条就可以了
014- SELECT `Id` AS `Id` , `UserId` AS `UserId` , `ApplicationId` AS `ApplicationId` , 2 AS `Type` , `SiteId` AS `Resource` , `Status` AS `Status` , `SentTime` AS `Sent` , `SentTime` AS `Received` FROM `M_Mercadolibre_Notiftransfer_Site` WHERE (((( `UserId` = '678105364' ) AND ( `CreateTime` &gt; timestamp('2023-07-21 13:33:48.975197') )) AND ( `Status` = 0 )) AND NOT( `SiteId` IS NULL OR `SiteId`='')) ORDER BY Id DESC LIMIT 0,200
014+
015+ 原始sql:
016+
017+ SELECT `Id` AS `Id` , `UserId` AS `UserId` , `ApplicationId` AS `ApplicationId` , 2 AS `Type` , `SiteId` AS `Resource` , `Status` AS `Status` , `SentTime` AS `Sent` , `SentTime` AS `Received` FROM `M_Mercadolibre_Notiftransfer_Site` WHERE (((( `UserId` = '678105364' ) AND ( `CreateTime` &gt; timestamp('2023-07-21 13:33:48.975197') )) AND ( `Status` = 0 )) AND NOT( `SiteId` IS NULL OR `SiteId`='')) ORDER BY Id DESC LIMIT 0,200

005- <p>2.解决方案</p>
005+ <p>select count(0) from `M_Mercadolibre_Notiftransfer_Site` where status=1 -- 5544213<br />select count(0) from `M_Mercadolibre_Notiftransfer_Site` where status=0 -- 1125<br />select count(0) from `M_Mercadolibre_Notiftransfer_Site` where status=3 -- 222<br />select count(0) from `M_Mercadolibre_Notiftransfer_Site` where status=9 -- 323906</p>
006- <p>DBA 测试后给的方案是指定索引比较快，先添加一下</p>
006+ <p><br />select count(0) from `M_Mercadolibre_Notiftransfer_Site` -- 302093746 302216446<br /></p>
008- <p>`M_Mercadolibre_Notiftransfer_Site` force index(idx_UserId_Status_CreateTime_id)</p>
008+ <p>2.解决方案</p>
009- <p><br /></p>
009+ <p>DBA 测试后给的方案是指定索引比较快，先添加一下</p>
010- <p>是否可以去掉<span>ORDER BY ，同步每次取200条，同步完成后修改status=0 到status=1,下次取200条就可以了</span></p>
010+ <p><br /></p>
011- <p><br /></p>
011+ <p>`M_Mercadolibre_Notiftransfer_Site` force index(idx_UserId_Status_CreateTime_id)</p>
012- <p>原始sql:</p>
012+ <p><br /></p>
013- <p><br /></p>
013+ <p>是否可以去掉<span>ORDER BY ，同步每次取200条，同步完成后修改status=0 到status=1,下次取200条就可以了</span></p>
014- <p>SELECT `Id` AS `Id` , `UserId` AS `UserId` , `ApplicationId` AS `ApplicationId` , 2 AS `Type` , `SiteId` AS `Resource` , `Status` AS `Status` , `SentTime` AS `Sent` , `SentTime` AS `Received` FROM `M_Mercadolibre_Notiftransfer_Site` WHERE (((( `UserId` = '678105364' ) AND ( `CreateTime` &gt; timestamp('2023-07-21 13:33:48.975197') )) AND ( `Status` = 0 )) AND NOT( `SiteId` IS NULL OR `SiteId`='')) ORDER BY Id DESC LIMIT 0,200</p>
014+ <p><br /></p>
015+ <p>原始sql:</p>
016+ <p><br /></p>
017+ <p>SELECT `Id` AS `Id` , `UserId` AS `UserId` , `ApplicationId` AS `ApplicationId` , 2 AS `Type` , `SiteId` AS `Resource` , `Status` AS `Status` , `SentTime` AS `Sent` , `SentTime` AS `Received` FROM `M_Mercadolibre_Notiftransfer_Site` WHERE (((( `UserId` = '678105364' ) AND ( `CreateTime` &gt; timestamp('2023-07-21 13:33:48.975197') )) AND ( `Status` = 0 )) AND NOT( `SiteId` IS NULL OR `SiteId`='')) ORDER BY Id DESC LIMIT 0,200</p>

修改了 任务描述，区别为：

006- select count(0) from `M_Mercadolibre_Notiftransfer_Site` -- 302093746 302216446
006+ select count(0) from `M_Mercadolibre_Notiftransfer_Site` -- 302093746 302216446
013- 是否可以去掉ORDER BY ，同步每次取200条，同步完成后修改status=0 到status=1,下次取200条就可以了
013+ 1.是否可以去掉ORDER BY ，同步每次取200条，同步完成后修改status=0 到status=1,下次取200条就可以了;
014-
014+ 2.是否归档这些状态！=0的数据；
015- 原始sql:
015+
016-
016+ 原始sql:
017- SELECT `Id` AS `Id` , `UserId` AS `UserId` , `ApplicationId` AS `ApplicationId` , 2 AS `Type` , `SiteId` AS `Resource` , `Status` AS `Status` , `SentTime` AS `Sent` , `SentTime` AS `Received` FROM `M_Mercadolibre_Notiftransfer_Site` WHERE (((( `UserId` = '678105364' ) AND ( `CreateTime` &gt; timestamp('2023-07-21 13:33:48.975197') )) AND ( `Status` = 0 )) AND NOT( `SiteId` IS NULL OR `SiteId`='')) ORDER BY Id DESC LIMIT 0,200
017+
018+ SELECT `Id` AS `Id` , `UserId` AS `UserId` , `ApplicationId` AS `ApplicationId` , 2 AS `Type` , `SiteId` AS `Resource` , `Status` AS `Status` , `SentTime` AS `Sent` , `SentTime` AS `Received` FROM `M_Mercadolibre_Notiftransfer_Site` WHERE (((( `UserId` = '678105364' ) AND ( `CreateTime` &gt; timestamp('2023-07-21 13:33:48.975197') )) AND ( `Status` = 0 )) AND NOT( `SiteId` IS NULL OR `SiteId`='')) ORDER BY Id DESC LIMIT 0,200

006- <p><br />select count(0) from `M_Mercadolibre_Notiftransfer_Site` -- 302093746 302216446<br /></p>
006+ <p><br />select count(0) from `M_Mercadolibre_Notiftransfer_Site` -- 302093746 302216446</p>
013- <p>是否可以去掉<span>ORDER BY ，同步每次取200条，同步完成后修改status=0 到status=1,下次取200条就可以了</span></p>
013+ <p>1.是否可以去掉<span>ORDER BY ，同步每次取200条，同步完成后修改status=0 到status=1,下次取200条就可以了;</span></p>
014- <p><br /></p>
014+ <p><span>2.是否归档这些状态！=0的数据；</span></p>
015- <p>原始sql:</p>
015+ <p><br /></p>
016- <p><br /></p>
016+ <p>原始sql:</p>
017- <p>SELECT `Id` AS `Id` , `UserId` AS `UserId` , `ApplicationId` AS `ApplicationId` , 2 AS `Type` , `SiteId` AS `Resource` , `Status` AS `Status` , `SentTime` AS `Sent` , `SentTime` AS `Received` FROM `M_Mercadolibre_Notiftransfer_Site` WHERE (((( `UserId` = '678105364' ) AND ( `CreateTime` &gt; timestamp('2023-07-21 13:33:48.975197') )) AND ( `Status` = 0 )) AND NOT( `SiteId` IS NULL OR `SiteId`='')) ORDER BY Id DESC LIMIT 0,200</p>
017+ <p><br /></p>
018+ <p>SELECT `Id` AS `Id` , `UserId` AS `UserId` , `ApplicationId` AS `ApplicationId` , 2 AS `Type` , `SiteId` AS `Resource` , `Status` AS `Status` , `SentTime` AS `Sent` , `SentTime` AS `Received` FROM `M_Mercadolibre_Notiftransfer_Site` WHERE (((( `UserId` = '678105364' ) AND ( `CreateTime` &gt; timestamp('2023-07-21 13:33:48.975197') )) AND ( `Status` = 0 )) AND NOT( `SiteId` IS NULL OR `SiteId`='')) ORDER BY Id DESC LIMIT 0,200</p>

修改了 指派给，旧值为 "chengwei"，新值为 "yaojieyuan"。

修改了 总计消耗，旧值为 "0"，新值为 "1"。
修改了 指派给 ，旧值为 "yaojieyuan"，新值为 "chenshaojun"。
修改了 实际完成，旧值为 ""，新值为 "2023-08-29 11:51:54"。
修改了 任务状态，旧值为 "wait"，新值为 "done"。
修改了 实际开始，旧值为 "0000-00-00 00:00:00"，新值为 "2023-08-29 11:52:10"。
修改了 预计剩余，旧值为 "1"，新值为 "0"。
修改了 由谁完成，旧值为 ""，新值为 "chenshaojun"。

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