2025-06-27 12:11:34,183 [285] ERROR DotNetCore.CAP.Internal.SubscribeExecutor - Message (Name:MCMS.Warehouse.LogisticsInfoAddMoney,Group:cap.queue.mcms.warehouse.v1) can not be found subscriber.
 see: https://github.com/dotnetcore/CAP/issues/63
2025-06-27 14:54:48,095 [329] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT this_.Id as id1_20_4_, this_.ParentId as parentid2_20_4_, this_.`AssignDepartmentId` as AssignDepartmentId3_20_4_, this_.`AssignDepartmentName` as AssignDepartmentName4_20_4_, this_.`AssignUserId` as AssignUserId5_20_4_, this_.`AssignUserName` as AssignUserName6_20_4_, this_.`AssignTime` as AssignTime7_20_4_, this_.`ClueId` as ClueId8_20_4_, this_.`AddTime` as AddTime9_20_4_, this_.`RealName` as RealName10_20_4_, this_.`Phone` as Phone11_20_4_, this_.`PhoneZone` as PhoneZone12_20_4_, this_.`SubmitTime` as SubmitTime13_20_4_, this_.`Status` as Status14_20_4_, this_.`AddCount` as AddCount15_20_4_, this_.`CompleteNote` as CompleteNote16_20_4_, this_.`CompleteTime` as CompleteTime17_20_4_, this_.`OriData` as OriData18_20_4_, this_.`TimeOutNoticeSelf` as TimeOutNoticeSelf19_20_4_, this_.`TimeOutNoticeExecutive` as TimeOutNoticeExecutive20_20_4_, this_.`AdPlanId` as AdPlanId21_20_4_, this_.`AdPlanName` as AdPlanName22_20_4_, this_.`ModuleId` as ModuleId23_20_4_, this_.`ModuleName` as ModuleName24_20_4_, this_.`TTAppName` as TTAppName25_20_4_, this_.`SourcePage` as SourcePage26_20_4_, this_.`RepeatAddCountNote` as RepeatAddCountNote27_20_4_, this_.`Price` as Price28_20_4_, this_.`OPCount` as OPCount29_20_4_, this_.`ClueReuse` as ClueReuse30_20_4_, this_.`ClueRating` as ClueRating31_20_4_, this_.`Point` as Point32_20_4_, this_.`SourceType` as SourceType33_20_4_, this_.`PromotionTTAccountId` as PromotionTTAccountId34_20_4_, this_.`Note` as Note35_20_4_, promotiont3_.Id as id1_20_0_, promotiont3_.ParentId as parentid2_20_0_, promotiont3_.`AssignDepartmentId` as AssignDepartmentId3_20_0_, promotiont3_.`AssignDepartmentName` as AssignDepartmentName4_20_0_, promotiont3_.`AssignUserId` as AssignUserId5_20_0_, promotiont3_.`AssignUserName` as AssignUserName6_20_0_, promotiont3_.`AssignTime` as AssignTime7_20_0_, promotiont3_.`ClueId` as ClueId8_20_0_, promotiont3_.`AddTime` as AddTime9_20_0_, promotiont3_.`RealName` as RealName10_20_0_, promotiont3_.`Phone` as Phone11_20_0_, promotiont3_.`PhoneZone` as PhoneZone12_20_0_, promotiont3_.`SubmitTime` as SubmitTime13_20_0_, promotiont3_.`Status` as Status14_20_0_, promotiont3_.`AddCount` as AddCount15_20_0_, promotiont3_.`CompleteNote` as CompleteNote16_20_0_, promotiont3_.`CompleteTime` as CompleteTime17_20_0_, promotiont3_.`OriData` as OriData18_20_0_, promotiont3_.`TimeOutNoticeSelf` as TimeOutNoticeSelf19_20_0_, promotiont3_.`TimeOutNoticeExecutive` as TimeOutNoticeExecutive20_20_0_, promotiont3_.`AdPlanId` as AdPlanId21_20_0_, promotiont3_.`AdPlanName` as AdPlanName22_20_0_, promotiont3_.`ModuleId` as ModuleId23_20_0_, promotiont3_.`ModuleName` as ModuleName24_20_0_, promotiont3_.`TTAppName` as TTAppName25_20_0_, promotiont3_.`SourcePage` as SourcePage26_20_0_, promotiont3_.`RepeatAddCountNote` as RepeatAddCountNote27_20_0_, promotiont3_.`Price` as Price28_20_0_, promotiont3_.`OPCount` as OPCount29_20_0_, promotiont3_.`ClueReuse` as ClueReuse30_20_0_, promotiont3_.`ClueRating` as ClueRating31_20_0_, promotiont3_.`Point` as Point32_20_0_, promotiont3_.`SourceType` as SourceType33_20_0_, promotiont3_.`PromotionTTAccountId` as PromotionTTAccountId34_20_0_, promotiont3_.`Note` as Note35_20_0_, promotiont1_.Id as id1_9_1_, promotiont1_.`Version` as Version2_9_1_, promotiont1_.`DepartmentId` as DepartmentId3_9_1_, promotiont1_.`DepartmentName` as DepartmentName4_9_1_, promotiont1_.`OwnUserId` as OwnUserId5_9_1_, promotiont1_.`OwnUserName` as OwnUserName6_9_1_, promotiont1_.PromotionSupplierId as promotionsupplierid7_9_1_, promotiont1_.`AdName` as AdName8_9_1_, promotiont1_.`AdId` as AdId9_9_1_, promotiont1_.`EMail` as EMail10_9_1_, promotiont1_.`AppKey` as AppKey11_9_1_, promotiont1_.`AppToken` as AppToken12_9_1_, promotiont1_.`ChannelType` as ChannelType13_9_1_, promotiont1_.`ChannelMode` as ChannelMode14_9_1_, promotiont1_.`Status` as Status15_9_1_, promotiont1_.`AccountType` as AccountType16_9_1_, promotiont1_.`PrimaryAccountId` as PrimaryAccountId17_9_1_, promotiont1_.`PrimaryAccountName` as PrimaryAccountName18_9_1_, promotiont1_.`InitPoint` as InitPoint19_9_1_, promotiont1_.`Points` as Points20_9_1_, promotiont1_.`UsedPoints` as UsedPoints21_9_1_, promotiont1_.`ThisMonthUsedPoints` as ThisMonthUsedPoints22_9_1_, promotiont1_.`ClueCount` as ClueCount23_9_1_, promotiont1_.`CluePrice` as CluePrice24_9_1_, promotiont1_.`FanCount` as FanCount25_9_1_, promotiont1_.`FanPrice` as FanPrice26_9_1_, promotiont1_.`ClueFanRate` as ClueFanRate27_9_1_, promotiont1_.`OrderTotal` as OrderTotal28_9_1_, promotiont1_.`ClueConvertRate` as ClueConvertRate29_9_1_, promotiont1_.`FanConvertRate` as FanConvertRate30_9_1_, promotiont1_.`FirstOrderRate` as FirstOrderRate31_9_1_, promotiont1_.`AgainOrderRate` as AgainOrderRate32_9_1_, promotiont1_.`Balance` as Balance33_9_1_, promotiont1_.`LinkMPAccountId` as LinkMPAccountId34_9_1_, promotiont1_.`LinkMPAccountName` as LinkMPAccountName35_9_1_, promotiont1_.`FollowGiftCouponPlanId` as FollowGiftCouponPlanId36_9_1_, promotiont1_.`FollowGiftCouponPlanName` as FollowGiftCouponPlanName37_9_1_, promotiont1_.`FollowGiftCouponPlanText` as FollowGiftCouponPlanText38_9_1_, promotiont1_.`FollowGiftCouponMaterialId` as FollowGiftCouponMaterialId39_9_1_, promotiont1_.`MPAccountScene` as MPAccountScene40_9_1_, promotiont1_.`ClueKeep` as ClueKeep41_9_1_, promotiont1_.`IsTokenRefresh` as IsTokenRefresh42_9_1_, promotiont1_.`AssignRole` as AssignRole43_9_1_, promotiont1_.`CostCalculationRule` as CostCalculationRule44_9_1_, promotiont1_.`Note` as Note45_9_1_, promotiont1_.`UseCompanyId` as UseCompanyId46_9_1_, promotiont1_.`UseCompanyName` as UseCompanyName47_9_1_, promotiont5_.Id as id1_22_2_, promotiont5_.`Address` as Address2_22_2_, promotiont5_.`Total` as Total3_22_2_, promotiont5_.`ProductInfo` as ProductInfo4_22_2_, promotiont5_.`Note` as Note5_22_2_, promotiont5_.`PromotionTTClueId` as PromotionTTClueId6_22_2_, promotions6_.Id as id1_8_3_, promotions6_.`Name` as Name2_8_3_, promotions6_.`SignedCompany` as SignedCompany3_8_3_, promotions6_.`CompanyName` as CompanyName4_8_3_, promotions6_.`CompanyTaxNumber` as CompanyTaxNumber5_8_3_, promotions6_.`Contact` as Contact6_8_3_, promotions6_.`Phone` as Phone7_8_3_, promotions6_.`InvoiceType` as InvoiceType8_8_3_, promotions6_.`Total` as Total9_8_3_, promotions6_.`RebateRate` as RebateRate10_8_3_, promotions6_.`Status` as Status11_8_3_, promotions6_.`AddUserName` as AddUserName12_8_3_, promotions6_.`AddTime` as AddTime13_8_3_, promotions6_.`UpdateUserName` as UpdateUserName14_8_3_, promotions6_.`UpdateTime` as UpdateTime15_8_3_, promotions6_.`Note` as Note16_8_3_ FROM `PromotionTTClue` this_ left outer join `PromotionTTClue` promotiont3_ on this_.ParentId=promotiont3_.Id inner join `PromotionTTAccount` promotiont1_ on this_.`PromotionTTAccountId`=promotiont1_.Id left outer join `PromotionTTClueExtend` promotiont5_ on this_.Id=promotiont5_.`PromotionTTClueId` left outer join `PromotionSupplier` promotions6_ on promotiont1_.PromotionSupplierId=promotions6_.Id WHERE this_.`AssignDepartmentId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9, ?p10, ?p11, ?p12, ?p13, ?p14, ?p15, ?p16, ?p17, ?p18, ?p19, ?p20, ?p21, ?p22, ?p23, ?p24, ?p25, ?p26, ?p27, ?p28, ?p29, ?p30, ?p31, ?p32, ?p33, ?p34, ?p35, ?p36, ?p37, ?p38, ?p39, ?p40, ?p41, ?p42, ?p43, ?p44, ?p45, ?p46, ?p47, ?p48, ?p49, ?p50, ?p51, ?p52, ?p53, ?p54, ?p55, ?p56, ?p57, ?p58, ?p59, ?p60, ?p61, ?p62, ?p63, ?p64, ?p65, ?p66) and this_.`AssignDepartmentId` in (?p67, ?p68, ?p69, ?p70, ?p71, ?p72, ?p73, ?p74, ?p75, ?p76, ?p77, ?p78, ?p79, ?p80, ?p81, ?p82, ?p83, ?p84, ?p85, ?p86, ?p87, ?p88, ?p89, ?p90, ?p91, ?p92, ?p93, ?p94, ?p95, ?p96, ?p97, ?p98, ?p99, ?p100, ?p101, ?p102, ?p103, ?p104, ?p105, ?p106, ?p107, ?p108, ?p109, ?p110, ?p111, ?p112, ?p113, ?p114, ?p115, ?p116, ?p117, ?p118, ?p119, ?p120, ?p121, ?p122, ?p123, ?p124, ?p125, ?p126, ?p127, ?p128, ?p129, ?p130, ?p131, ?p132, ?p133) and this_.`AssignTime` >= ?p134 and this_.`AssignTime` < ?p135 ORDER BY this_.Id desc
MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution.
 ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attempting to read the resultset.
 ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed.
 ---> System.IO.IOException: Unable to read data from the transport connection: Connection timed out.
 ---> System.Net.Sockets.SocketException (110): Connection timed out
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.TimedStream.ReadAsync(Byte[] buffer, Int32 offset, Int32 count, Boolean execAsync)
   at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.ReadFullyAsync(Stream stream, Byte[] buffer, Int32 offset, Int32 count, Boolean execAsync)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacketAsync(Boolean execAsync)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacketAsync(Boolean execAsync)
   at MySql.Data.MySqlClient.MySqlStream.ReadPacketAsync(Boolean execAsync)
   at MySql.Data.MySqlClient.NativeDriver.GetColumnDataAsync(MySqlField field, Boolean execAsync)
   at MySql.Data.MySqlClient.NativeDriver.GetColumnsDataAsync(MySqlField[] columns, Boolean execAsync)
   at MySql.Data.MySqlClient.Driver.GetColumnsAsync(Int32 count, Boolean execAsync)
   at MySql.Data.MySqlClient.ResultSet.LoadColumnsAsync(Int32 numCols, Boolean execAsync)
   at MySql.Data.MySqlClient.ResultSet.InitializeAsync(Int32 numCols, Boolean execAsync)
   at MySql.Data.MySqlClient.ResultSet.CreateResultSetAsync(Driver d, Int32 statementId, Int32 numCols, Boolean execAsync)
   at MySql.Data.MySqlClient.Driver.NextResultAsync(Int32 statementId, Boolean force, Boolean execAsync)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResultAsync(Boolean execAsync, CancellationToken cancellationToken)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean execAsync, CancellationToken cancellationToken)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at NHibernate.AdoNet.AbstractBatcher.DoExecuteReader(DbCommand cmd)
2025-06-27 14:54:48,105 [329] ERROR NHibernate.Util.ADOExceptionReporter - Fatal error encountered during command execution.
2025-06-27 14:54:48,105 [329] ERROR NHibernate.Util.ADOExceptionReporter - Fatal error encountered attempting to read the resultset.
2025-06-27 14:54:48,105 [329] ERROR NHibernate.Util.ADOExceptionReporter - Reading from the stream has failed.
2025-06-27 14:54:48,105 [329] ERROR NHibernate.Util.ADOExceptionReporter - Unable to read data from the transport connection: Connection timed out.
2025-06-27 14:54:48,105 [329] ERROR NHibernate.Util.ADOExceptionReporter - Connection timed out
2025-06-27 14:54:48,113 [329] ERROR NHibernate.Util.ADOExceptionReporter - Fatal error encountered during command execution.
2025-06-27 14:54:48,113 [329] ERROR NHibernate.Util.ADOExceptionReporter - Fatal error encountered attempting to read the resultset.
2025-06-27 14:54:48,113 [329] ERROR NHibernate.Util.ADOExceptionReporter - Reading from the stream has failed.
2025-06-27 14:54:48,113 [329] ERROR NHibernate.Util.ADOExceptionReporter - Unable to read data from the transport connection: Connection timed out.
2025-06-27 14:54:48,113 [329] ERROR NHibernate.Util.ADOExceptionReporter - Connection timed out
2025-06-27 14:54:48,114 [329] ERROR NHibernate.Util.ADOExceptionReporter - Fatal error encountered during command execution.
2025-06-27 14:54:48,114 [329] ERROR NHibernate.Util.ADOExceptionReporter - Fatal error encountered attempting to read the resultset.
2025-06-27 14:54:48,114 [329] ERROR NHibernate.Util.ADOExceptionReporter - Reading from the stream has failed.
2025-06-27 14:54:48,114 [329] ERROR NHibernate.Util.ADOExceptionReporter - Unable to read data from the transport connection: Connection timed out.
2025-06-27 14:54:48,114 [329] ERROR NHibernate.Util.ADOExceptionReporter - Connection timed out
2025-06-27 14:54:48,664 [329] ERROR MCMS.Promotion.Common.GlobalExceptionFilter - URL:http://0.0.0.0:5009/PromotionTTClue/GetList;UserIP:127.0.0.1,ServerVariables:Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpRequestHeaders;Exception:could not execute query
[ SELECT this_.Id as id1_20_4_, this_.ParentId as parentid2_20_4_, this_.`AssignDepartmentId` as AssignDepartmentId3_20_4_, this_.`AssignDepartmentName` as AssignDepartmentName4_20_4_, this_.`AssignUserId` as AssignUserId5_20_4_, this_.`AssignUserName` as AssignUserName6_20_4_, this_.`AssignTime` as AssignTime7_20_4_, this_.`ClueId` as ClueId8_20_4_, this_.`AddTime` as AddTime9_20_4_, this_.`RealName` as RealName10_20_4_, this_.`Phone` as Phone11_20_4_, this_.`PhoneZone` as PhoneZone12_20_4_, this_.`SubmitTime` as SubmitTime13_20_4_, this_.`Status` as Status14_20_4_, this_.`AddCount` as AddCount15_20_4_, this_.`CompleteNote` as CompleteNote16_20_4_, this_.`CompleteTime` as CompleteTime17_20_4_, this_.`OriData` as OriData18_20_4_, this_.`TimeOutNoticeSelf` as TimeOutNoticeSelf19_20_4_, this_.`TimeOutNoticeExecutive` as TimeOutNoticeExecutive20_20_4_, this_.`AdPlanId` as AdPlanId21_20_4_, this_.`AdPlanName` as AdPlanName22_20_4_, this_.`ModuleId` as ModuleId23_20_4_, this_.`ModuleName` as ModuleName24_20_4_, this_.`TTAppName` as TTAppName25_20_4_, this_.`SourcePage` as SourcePage26_20_4_, this_.`RepeatAddCountNote` as RepeatAddCountNote27_20_4_, this_.`Price` as Price28_20_4_, this_.`OPCount` as OPCount29_20_4_, this_.`ClueReuse` as ClueReuse30_20_4_, this_.`ClueRating` as ClueRating31_20_4_, this_.`Point` as Point32_20_4_, this_.`SourceType` as SourceType33_20_4_, this_.`PromotionTTAccountId` as PromotionTTAccountId34_20_4_, this_.`Note` as Note35_20_4_, promotiont3_.Id as id1_20_0_, promotiont3_.ParentId as parentid2_20_0_, promotiont3_.`AssignDepartmentId` as AssignDepartmentId3_20_0_, promotiont3_.`AssignDepartmentName` as AssignDepartmentName4_20_0_, promotiont3_.`AssignUserId` as AssignUserId5_20_0_, promotiont3_.`AssignUserName` as AssignUserName6_20_0_, promotiont3_.`AssignTime` as AssignTime7_20_0_, promotiont3_.`ClueId` as ClueId8_20_0_, promotiont3_.`AddTime` as AddTime9_20_0_, promotiont3_.`RealName` as RealName10_20_0_, promotiont3_.`Phone` as Phone11_20_0_, promotiont3_.`PhoneZone` as PhoneZone12_20_0_, promotiont3_.`SubmitTime` as SubmitTime13_20_0_, promotiont3_.`Status` as Status14_20_0_, promotiont3_.`AddCount` as AddCount15_20_0_, promotiont3_.`CompleteNote` as CompleteNote16_20_0_, promotiont3_.`CompleteTime` as CompleteTime17_20_0_, promotiont3_.`OriData` as OriData18_20_0_, promotiont3_.`TimeOutNoticeSelf` as TimeOutNoticeSelf19_20_0_, promotiont3_.`TimeOutNoticeExecutive` as TimeOutNoticeExecutive20_20_0_, promotiont3_.`AdPlanId` as AdPlanId21_20_0_, promotiont3_.`AdPlanName` as AdPlanName22_20_0_, promotiont3_.`ModuleId` as ModuleId23_20_0_, promotiont3_.`ModuleName` as ModuleName24_20_0_, promotiont3_.`TTAppName` as TTAppName25_20_0_, promotiont3_.`SourcePage` as SourcePage26_20_0_, promotiont3_.`RepeatAddCountNote` as RepeatAddCountNote27_20_0_, promotiont3_.`Price` as Price28_20_0_, promotiont3_.`OPCount` as OPCount29_20_0_, promotiont3_.`ClueReuse` as ClueReuse30_20_0_, promotiont3_.`ClueRating` as ClueRating31_20_0_, promotiont3_.`Point` as Point32_20_0_, promotiont3_.`SourceType` as SourceType33_20_0_, promotiont3_.`PromotionTTAccountId` as PromotionTTAccountId34_20_0_, promotiont3_.`Note` as Note35_20_0_, promotiont1_.Id as id1_9_1_, promotiont1_.`Version` as Version2_9_1_, promotiont1_.`DepartmentId` as DepartmentId3_9_1_, promotiont1_.`DepartmentName` as DepartmentName4_9_1_, promotiont1_.`OwnUserId` as OwnUserId5_9_1_, promotiont1_.`OwnUserName` as OwnUserName6_9_1_, promotiont1_.PromotionSupplierId as promotionsupplierid7_9_1_, promotiont1_.`AdName` as AdName8_9_1_, promotiont1_.`AdId` as AdId9_9_1_, promotiont1_.`EMail` as EMail10_9_1_, promotiont1_.`AppKey` as AppKey11_9_1_, promotiont1_.`AppToken` as AppToken12_9_1_, promotiont1_.`ChannelType` as ChannelType13_9_1_, promotiont1_.`ChannelMode` as ChannelMode14_9_1_, promotiont1_.`Status` as Status15_9_1_, promotiont1_.`AccountType` as AccountType16_9_1_, promotiont1_.`PrimaryAccountId` as PrimaryAccountId17_9_1_, promotiont1_.`PrimaryAccountName` as PrimaryAccountName18_9_1_, promotiont1_.`InitPoint` as InitPoint19_9_1_, promotiont1_.`Points` as Points20_9_1_, promotiont1_.`UsedPoints` as UsedPoints21_9_1_, promotiont1_.`ThisMonthUsedPoints` as ThisMonthUsedPoints22_9_1_, promotiont1_.`ClueCount` as ClueCount23_9_1_, promotiont1_.`CluePrice` as CluePrice24_9_1_, promotiont1_.`FanCount` as FanCount25_9_1_, promotiont1_.`FanPrice` as FanPrice26_9_1_, promotiont1_.`ClueFanRate` as ClueFanRate27_9_1_, promotiont1_.`OrderTotal` as OrderTotal28_9_1_, promotiont1_.`ClueConvertRate` as ClueConvertRate29_9_1_, promotiont1_.`FanConvertRate` as FanConvertRate30_9_1_, promotiont1_.`FirstOrderRate` as FirstOrderRate31_9_1_, promotiont1_.`AgainOrderRate` as AgainOrderRate32_9_1_, promotiont1_.`Balance` as Balance33_9_1_, promotiont1_.`LinkMPAccountId` as LinkMPAccountId34_9_1_, promotiont1_.`LinkMPAccountName` as LinkMPAccountName35_9_1_, promotiont1_.`FollowGiftCouponPlanId` as FollowGiftCouponPlanId36_9_1_, promotiont1_.`FollowGiftCouponPlanName` as FollowGiftCouponPlanName37_9_1_, promotiont1_.`FollowGiftCouponPlanText` as FollowGiftCouponPlanText38_9_1_, promotiont1_.`FollowGiftCouponMaterialId` as FollowGiftCouponMaterialId39_9_1_, promotiont1_.`MPAccountScene` as MPAccountScene40_9_1_, promotiont1_.`ClueKeep` as ClueKeep41_9_1_, promotiont1_.`IsTokenRefresh` as IsTokenRefresh42_9_1_, promotiont1_.`AssignRole` as AssignRole43_9_1_, promotiont1_.`CostCalculationRule` as CostCalculationRule44_9_1_, promotiont1_.`Note` as Note45_9_1_, promotiont1_.`UseCompanyId` as UseCompanyId46_9_1_, promotiont1_.`UseCompanyName` as UseCompanyName47_9_1_, promotiont5_.Id as id1_22_2_, promotiont5_.`Address` as Address2_22_2_, promotiont5_.`Total` as Total3_22_2_, promotiont5_.`ProductInfo` as ProductInfo4_22_2_, promotiont5_.`Note` as Note5_22_2_, promotiont5_.`PromotionTTClueId` as PromotionTTClueId6_22_2_, promotions6_.Id as id1_8_3_, promotions6_.`Name` as Name2_8_3_, promotions6_.`SignedCompany` as SignedCompany3_8_3_, promotions6_.`CompanyName` as CompanyName4_8_3_, promotions6_.`CompanyTaxNumber` as CompanyTaxNumber5_8_3_, promotions6_.`Contact` as Contact6_8_3_, promotions6_.`Phone` as Phone7_8_3_, promotions6_.`InvoiceType` as InvoiceType8_8_3_, promotions6_.`Total` as Total9_8_3_, promotions6_.`RebateRate` as RebateRate10_8_3_, promotions6_.`Status` as Status11_8_3_, promotions6_.`AddUserName` as AddUserName12_8_3_, promotions6_.`AddTime` as AddTime13_8_3_, promotions6_.`UpdateUserName` as UpdateUserName14_8_3_, promotions6_.`UpdateTime` as UpdateTime15_8_3_, promotions6_.`Note` as Note16_8_3_ FROM `PromotionTTClue` this_ left outer join `PromotionTTClue` promotiont3_ on this_.ParentId=promotiont3_.Id inner join `PromotionTTAccount` promotiont1_ on this_.`PromotionTTAccountId`=promotiont1_.Id left outer join `PromotionTTClueExtend` promotiont5_ on this_.Id=promotiont5_.`PromotionTTClueId` left outer join `PromotionSupplier` promotions6_ on promotiont1_.PromotionSupplierId=promotions6_.Id WHERE this_.`AssignDepartmentId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9, ?p10, ?p11, ?p12, ?p13, ?p14, ?p15, ?p16, ?p17, ?p18, ?p19, ?p20, ?p21, ?p22, ?p23, ?p24, ?p25, ?p26, ?p27, ?p28, ?p29, ?p30, ?p31, ?p32, ?p33, ?p34, ?p35, ?p36, ?p37, ?p38, ?p39, ?p40, ?p41, ?p42, ?p43, ?p44, ?p45, ?p46, ?p47, ?p48, ?p49, ?p50, ?p51, ?p52, ?p53, ?p54, ?p55, ?p56, ?p57, ?p58, ?p59, ?p60, ?p61, ?p62, ?p63, ?p64, ?p65, ?p66) and this_.`AssignDepartmentId` in (?p67, ?p68, ?p69, ?p70, ?p71, ?p72, ?p73, ?p74, ?p75, ?p76, ?p77, ?p78, ?p79, ?p80, ?p81, ?p82, ?p83, ?p84, ?p85, ?p86, ?p87, ?p88, ?p89, ?p90, ?p91, ?p92, ?p93, ?p94, ?p95, ?p96, ?p97, ?p98, ?p99, ?p100, ?p101, ?p102, ?p103, ?p104, ?p105, ?p106, ?p107, ?p108, ?p109, ?p110, ?p111, ?p112, ?p113, ?p114, ?p115, ?p116, ?p117, ?p118, ?p119, ?p120, ?p121, ?p122, ?p123, ?p124, ?p125, ?p126, ?p127, ?p128, ?p129, ?p130, ?p131, ?p132, ?p133) and this_.`AssignTime` >= ?p134 and this_.`AssignTime` < ?p135 ORDER BY this_.Id desc ]
  Name:cp0 - Value:6 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp1 - Value:10 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp2 - Value:11 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp3 - Value:16 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp4 - Value:17 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp5 - Value:73 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp6 - Value:113 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp7 - Value:18 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp8 - Value:77 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp9 - Value:21 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp10 - Value:80 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp11 - Value:23 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp12 - Value:124 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp13 - Value:114 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp14 - Value:13 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp15 - Value:14 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp16 - Value:15 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp17 - Value:101 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp18 - Value:12 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp19 - Value:91 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp20 - Value:115 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp21 - Value:116 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp22 - Value:42 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp23 - Value:43 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp24 - Value:44 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp25 - Value:40 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp26 - Value:41 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp27 - Value:45 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp28 - Value:187 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp29 - Value:46 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp30 - Value:47 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp31 - Value:48 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp32 - Value:49 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp33 - Value:50 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp34 - Value:51 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp35 - Value:52 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp36 - Value:53 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp37 - Value:54 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp38 - Value:55 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp39 - Value:56 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp40 - Value:57 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp41 - Value:102 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp42 - Value:103 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp43 - Value:106 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp44 - Value:107 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp45 - Value:108 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp46 - Value:109 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp47 - Value:24 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp48 - Value:25 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp49 - Value:26 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp50 - Value:28 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp51 - Value:29 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp52 - Value:30 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp53 - Value:31 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp54 - Value:27 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp55 - Value:99 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp56 - Value:19 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp57 - Value:20 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp58 - Value:32 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp59 - Value:33 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp60 - Value:34 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp61 - Value:35 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp62 - Value:36 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp63 - Value:37 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp64 - Value:38 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp65 - Value:39 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp66 - Value:22 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp67 - Value:6 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp68 - Value:10 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp69 - Value:11 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp70 - Value:16 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp71 - Value:17 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp72 - Value:73 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp73 - Value:113 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp74 - Value:18 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp75 - Value:77 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp76 - Value:21 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp77 - Value:80 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp78 - Value:23 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp79 - Value:124 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp80 - Value:114 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp81 - Value:13 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp82 - Value:14 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp83 - Value:15 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp84 - Value:101 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp85 - Value:12 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp86 - Value:91 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp87 - Value:115 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp88 - Value:116 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp89 - Value:42 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp90 - Value:43 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp91 - Value:44 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp92 - Value:40 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp93 - Value:41 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp94 - Value:45 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp95 - Value:187 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp96 - Value:46 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp97 - Value:47 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp98 - Value:48 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp99 - Value:49 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp100 - Value:50 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp101 - Value:51 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp102 - Value:52 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp103 - Value:53 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp104 - Value:54 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp105 - Value:55 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp106 - Value:56 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp107 - Value:57 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp108 - Value:102 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp109 - Value:103 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp110 - Value:106 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp111 - Value:107 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp112 - Value:108 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp113 - Value:109 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp114 - Value:24 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp115 - Value:25 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp116 - Value:26 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp117 - Value:28 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp118 - Value:29 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp119 - Value:30 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp120 - Value:31 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp121 - Value:27 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp122 - Value:99 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp123 - Value:19 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp124 - Value:20 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp125 - Value:32 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp126 - Value:33 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp127 - Value:34 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp128 - Value:35 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp129 - Value:36 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp130 - Value:37 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp131 - Value:38 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp132 - Value:39 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp133 - Value:22 [Type: NHibernate.Type.Int32Type (SqlType: Int32)]  Name:cp134 - Value:2025/5/27 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)]  Name:cp135 - Value:2025/6/29 00:00:00 [Type: NHibernate.Type.DateTimeType (SqlType: DateTime)]
[SQL: SELECT this_.Id as id1_20_4_, this_.ParentId as parentid2_20_4_, this_.`AssignDepartmentId` as AssignDepartmentId3_20_4_, this_.`AssignDepartmentName` as AssignDepartmentName4_20_4_, this_.`AssignUserId` as AssignUserId5_20_4_, this_.`AssignUserName` as AssignUserName6_20_4_, this_.`AssignTime` as AssignTime7_20_4_, this_.`ClueId` as ClueId8_20_4_, this_.`AddTime` as AddTime9_20_4_, this_.`RealName` as RealName10_20_4_, this_.`Phone` as Phone11_20_4_, this_.`PhoneZone` as PhoneZone12_20_4_, this_.`SubmitTime` as SubmitTime13_20_4_, this_.`Status` as Status14_20_4_, this_.`AddCount` as AddCount15_20_4_, this_.`CompleteNote` as CompleteNote16_20_4_, this_.`CompleteTime` as CompleteTime17_20_4_, this_.`OriData` as OriData18_20_4_, this_.`TimeOutNoticeSelf` as TimeOutNoticeSelf19_20_4_, this_.`TimeOutNoticeExecutive` as TimeOutNoticeExecutive20_20_4_, this_.`AdPlanId` as AdPlanId21_20_4_, this_.`AdPlanName` as AdPlanName22_20_4_, this_.`ModuleId` as ModuleId23_20_4_, this_.`ModuleName` as ModuleName24_20_4_, this_.`TTAppName` as TTAppName25_20_4_, this_.`SourcePage` as SourcePage26_20_4_, this_.`RepeatAddCountNote` as RepeatAddCountNote27_20_4_, this_.`Price` as Price28_20_4_, this_.`OPCount` as OPCount29_20_4_, this_.`ClueReuse` as ClueReuse30_20_4_, this_.`ClueRating` as ClueRating31_20_4_, this_.`Point` as Point32_20_4_, this_.`SourceType` as SourceType33_20_4_, this_.`PromotionTTAccountId` as PromotionTTAccountId34_20_4_, this_.`Note` as Note35_20_4_, promotiont3_.Id as id1_20_0_, promotiont3_.ParentId as parentid2_20_0_, promotiont3_.`AssignDepartmentId` as AssignDepartmentId3_20_0_, promotiont3_.`AssignDepartmentName` as AssignDepartmentName4_20_0_, promotiont3_.`AssignUserId` as AssignUserId5_20_0_, promotiont3_.`AssignUserName` as AssignUserName6_20_0_, promotiont3_.`AssignTime` as AssignTime7_20_0_, promotiont3_.`ClueId` as ClueId8_20_0_, promotiont3_.`AddTime` as AddTime9_20_0_, promotiont3_.`RealName` as RealName10_20_0_, promotiont3_.`Phone` as Phone11_20_0_, promotiont3_.`PhoneZone` as PhoneZone12_20_0_, promotiont3_.`SubmitTime` as SubmitTime13_20_0_, promotiont3_.`Status` as Status14_20_0_, promotiont3_.`AddCount` as AddCount15_20_0_, promotiont3_.`CompleteNote` as CompleteNote16_20_0_, promotiont3_.`CompleteTime` as CompleteTime17_20_0_, promotiont3_.`OriData` as OriData18_20_0_, promotiont3_.`TimeOutNoticeSelf` as TimeOutNoticeSelf19_20_0_, promotiont3_.`TimeOutNoticeExecutive` as TimeOutNoticeExecutive20_20_0_, promotiont3_.`AdPlanId` as AdPlanId21_20_0_, promotiont3_.`AdPlanName` as AdPlanName22_20_0_, promotiont3_.`ModuleId` as ModuleId23_20_0_, promotiont3_.`ModuleName` as ModuleName24_20_0_, promotiont3_.`TTAppName` as TTAppName25_20_0_, promotiont3_.`SourcePage` as SourcePage26_20_0_, promotiont3_.`RepeatAddCountNote` as RepeatAddCountNote27_20_0_, promotiont3_.`Price` as Price28_20_0_, promotiont3_.`OPCount` as OPCount29_20_0_, promotiont3_.`ClueReuse` as ClueReuse30_20_0_, promotiont3_.`ClueRating` as ClueRating31_20_0_, promotiont3_.`Point` as Point32_20_0_, promotiont3_.`SourceType` as SourceType33_20_0_, promotiont3_.`PromotionTTAccountId` as PromotionTTAccountId34_20_0_, promotiont3_.`Note` as Note35_20_0_, promotiont1_.Id as id1_9_1_, promotiont1_.`Version` as Version2_9_1_, promotiont1_.`DepartmentId` as DepartmentId3_9_1_, promotiont1_.`DepartmentName` as DepartmentName4_9_1_, promotiont1_.`OwnUserId` as OwnUserId5_9_1_, promotiont1_.`OwnUserName` as OwnUserName6_9_1_, promotiont1_.PromotionSupplierId as promotionsupplierid7_9_1_, promotiont1_.`AdName` as AdName8_9_1_, promotiont1_.`AdId` as AdId9_9_1_, promotiont1_.`EMail` as EMail10_9_1_, promotiont1_.`AppKey` as AppKey11_9_1_, promotiont1_.`AppToken` as AppToken12_9_1_, promotiont1_.`ChannelType` as ChannelType13_9_1_, promotiont1_.`ChannelMode` as ChannelMode14_9_1_, promotiont1_.`Status` as Status15_9_1_, promotiont1_.`AccountType` as AccountType16_9_1_, promotiont1_.`PrimaryAccountId` as PrimaryAccountId17_9_1_, promotiont1_.`PrimaryAccountName` as PrimaryAccountName18_9_1_, promotiont1_.`InitPoint` as InitPoint19_9_1_, promotiont1_.`Points` as Points20_9_1_, promotiont1_.`UsedPoints` as UsedPoints21_9_1_, promotiont1_.`ThisMonthUsedPoints` as ThisMonthUsedPoints22_9_1_, promotiont1_.`ClueCount` as ClueCount23_9_1_, promotiont1_.`CluePrice` as CluePrice24_9_1_, promotiont1_.`FanCount` as FanCount25_9_1_, promotiont1_.`FanPrice` as FanPrice26_9_1_, promotiont1_.`ClueFanRate` as ClueFanRate27_9_1_, promotiont1_.`OrderTotal` as OrderTotal28_9_1_, promotiont1_.`ClueConvertRate` as ClueConvertRate29_9_1_, promotiont1_.`FanConvertRate` as FanConvertRate30_9_1_, promotiont1_.`FirstOrderRate` as FirstOrderRate31_9_1_, promotiont1_.`AgainOrderRate` as AgainOrderRate32_9_1_, promotiont1_.`Balance` as Balance33_9_1_, promotiont1_.`LinkMPAccountId` as LinkMPAccountId34_9_1_, promotiont1_.`LinkMPAccountName` as LinkMPAccountName35_9_1_, promotiont1_.`FollowGiftCouponPlanId` as FollowGiftCouponPlanId36_9_1_, promotiont1_.`FollowGiftCouponPlanName` as FollowGiftCouponPlanName37_9_1_, promotiont1_.`FollowGiftCouponPlanText` as FollowGiftCouponPlanText38_9_1_, promotiont1_.`FollowGiftCouponMaterialId` as FollowGiftCouponMaterialId39_9_1_, promotiont1_.`MPAccountScene` as MPAccountScene40_9_1_, promotiont1_.`ClueKeep` as ClueKeep41_9_1_, promotiont1_.`IsTokenRefresh` as IsTokenRefresh42_9_1_, promotiont1_.`AssignRole` as AssignRole43_9_1_, promotiont1_.`CostCalculationRule` as CostCalculationRule44_9_1_, promotiont1_.`Note` as Note45_9_1_, promotiont1_.`UseCompanyId` as UseCompanyId46_9_1_, promotiont1_.`UseCompanyName` as UseCompanyName47_9_1_, promotiont5_.Id as id1_22_2_, promotiont5_.`Address` as Address2_22_2_, promotiont5_.`Total` as Total3_22_2_, promotiont5_.`ProductInfo` as ProductInfo4_22_2_, promotiont5_.`Note` as Note5_22_2_, promotiont5_.`PromotionTTClueId` as PromotionTTClueId6_22_2_, promotions6_.Id as id1_8_3_, promotions6_.`Name` as Name2_8_3_, promotions6_.`SignedCompany` as SignedCompany3_8_3_, promotions6_.`CompanyName` as CompanyName4_8_3_, promotions6_.`CompanyTaxNumber` as CompanyTaxNumber5_8_3_, promotions6_.`Contact` as Contact6_8_3_, promotions6_.`Phone` as Phone7_8_3_, promotions6_.`InvoiceType` as InvoiceType8_8_3_, promotions6_.`Total` as Total9_8_3_, promotions6_.`RebateRate` as RebateRate10_8_3_, promotions6_.`Status` as Status11_8_3_, promotions6_.`AddUserName` as AddUserName12_8_3_, promotions6_.`AddTime` as AddTime13_8_3_, promotions6_.`UpdateUserName` as UpdateUserName14_8_3_, promotions6_.`UpdateTime` as UpdateTime15_8_3_, promotions6_.`Note` as Note16_8_3_ FROM `PromotionTTClue` this_ left outer join `PromotionTTClue` promotiont3_ on this_.ParentId=promotiont3_.Id inner join `PromotionTTAccount` promotiont1_ on this_.`PromotionTTAccountId`=promotiont1_.Id left outer join `PromotionTTClueExtend` promotiont5_ on this_.Id=promotiont5_.`PromotionTTClueId` left outer join `PromotionSupplier` promotions6_ on promotiont1_.PromotionSupplierId=promotions6_.Id WHERE this_.`AssignDepartmentId` in (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9, ?p10, ?p11, ?p12, ?p13, ?p14, ?p15, ?p16, ?p17, ?p18, ?p19, ?p20, ?p21, ?p22, ?p23, ?p24, ?p25, ?p26, ?p27, ?p28, ?p29, ?p30, ?p31, ?p32, ?p33, ?p34, ?p35, ?p36, ?p37, ?p38, ?p39, ?p40, ?p41, ?p42, ?p43, ?p44, ?p45, ?p46, ?p47, ?p48, ?p49, ?p50, ?p51, ?p52, ?p53, ?p54, ?p55, ?p56, ?p57, ?p58, ?p59, ?p60, ?p61, ?p62, ?p63, ?p64, ?p65, ?p66) and this_.`AssignDepartmentId` in (?p67, ?p68, ?p69, ?p70, ?p71, ?p72, ?p73, ?p74, ?p75, ?p76, ?p77, ?p78, ?p79, ?p80, ?p81, ?p82, ?p83, ?p84, ?p85, ?p86, ?p87, ?p88, ?p89, ?p90, ?p91, ?p92, ?p93, ?p94, ?p95, ?p96, ?p97, ?p98, ?p99, ?p100, ?p101, ?p102, ?p103, ?p104, ?p105, ?p106, ?p107, ?p108, ?p109, ?p110, ?p111, ?p112, ?p113, ?p114, ?p115, ?p116, ?p117, ?p118, ?p119, ?p120, ?p121, ?p122, ?p123, ?p124, ?p125, ?p126, ?p127, ?p128, ?p129, ?p130, ?p131, ?p132, ?p133) and this_.`AssignTime` >= ?p134 and this_.`AssignTime` < ?p135 ORDER BY this_.Id desc]   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer, QueryCacheResultBuilder queryCacheResultBuilder)
   at NHibernate.Loader.Criteria.CriteriaLoaderExtensions.LoadAllToList[T](IList`1 loaders, ISessionImplementor session)
   at NHibernate.Impl.SessionImpl.List[T](CriteriaImpl criteria)
   at NHibernate.Impl.CriteriaImpl.List[T]()
   at MCMS.Promotion.DAO.Hibernate.PromotionTTClueDAO.GetObjectListBySearch(PromotionTTClueQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) in E:\agent\_work\14\s\MCMS.Promotion.DAO.Hibernate\PromotionTTClueDAO.cs:line 238
   at MCMS.Promotion.Service.Impl.PromotionTTClueService.GetObjectListBySearch(PromotionTTClueQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField) in E:\agent\_work\14\s\MCMS.Promotion.Service.Impl\PromotionTTClueService.cs:line 433
   at _dynamic_MCMS.Promotion.Service.Impl.PromotionTTClueService.GetObjectListBySearch(Object , Object[] )
   at Spring.Reflection.Dynamic.SafeMethod.Invoke(Object target, Object[] arguments)
   at Spring.Aop.Framework.DynamicMethodInvocation.InvokeJoinpoint()
   at Spring.Aop.Framework.AbstractMethodInvocation.Proceed()
   at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation)
   at Spring.Aop.Framework.AbstractMethodInvocation.Proceed()
   at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, MethodInfo proxyMethod, Object[] args, IList interceptors)
   at CompositionAopProxy_3a0033d51cd44cada8394a6aa9d92971.GetObjectListBySearch(PromotionTTClueQueryDto queryDto, IPagingInfo pagingInfo, OrderField orderField)
   at MCMS.Promotion.Controllers.PromotionTTClueController.GetList(PromotionTTClueSearchDto searchDto)
   at lambda_method24(Closure , Object , Object[] )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)