Logování Web API

Start read sql - InputParams: @{SelDivision_IDFrag}=('1300000101','1400000101','3400000101','2400000101','2200000101','1200000101','2100000101');@{SelStore_IDFrag}=('1300000101','2600000101','1600000101','3400000101','3200000101','4400000101','1500000101','2500000101','3500000101','2300000101','3300000101','2100000101');@{$IndexAndWhere}=;
				select T_1.StoreCard_ID as F_1$REFERENCE, T_1.Store_ID as F_2$REFERENCE, sum(T_1.Quantity) as F_3, sum(T_1.DeliveredQuantity) as F_4, T_1.StoreCard_ID as F_5, T_1.Store_ID as F_6
				from ReceivedOrders2 T_1
				join ReceivedOrders T_2 on T_2.ID = T_1.Parent_ID
				where (T_1.Store_ID in ('2100000101', '2200000101') and T_1.RowType = 3 and T_2.Confirmed = 'A' and T_2.Closed = 'N' and T_1.Quantity > T_1.DeliveredQuantity) and (((T_1.Division_ID IS NULL) OR (T_1.Division_ID = '0000000000') OR (T_1.Division_ID = ' ') OR (T_1.Division_ID IN {SelDivision_IDFrag}))) and (((T_1.Store_ID IS NULL) OR (T_1.Store_ID = '0000000000') OR (T_1.Store_ID = ' ') OR (T_1.Store_ID IN {SelStore_IDFrag})))
				group by T_1.StoreCard_ID, T_1.Store_ID
  
				SQL plan:   |--Stream Aggregate(GROUP BY:([T_1].[StoreCard_ID]) DEFINE:([Expr1002]=SUM([toho].[dbo].[ReceivedOrders2].[Quantity] as [T_1].[Quantity]), [Expr1003]=SUM([toho].[dbo].[ReceivedOrders2].[DeliveredQuantity] as [T_1].[DeliveredQuantity]), [T_1].[Store_ID]=ANY([toho].[dbo].[ReceivedOrders2].[Store_ID] as [T_1].[Store_ID])))
				|--Sort(ORDER BY:([T_1].[StoreCard_ID] ASC))
				|--Nested Loops(Inner Join, OUTER REFERENCES:([T_1].[Parent_ID]))
				|--Clustered Index Scan(OBJECT:([toho].[dbo].[ReceivedOrders2].[ReceivedOrders2PK] AS [T_1]), WHERE:([toho].[dbo].[ReceivedOrders2].[RowType] as [T_1].[RowType]=(3) AND [toho].[dbo].[ReceivedOrders2].[Quantity] as [T_1].[Quantity]>[toho].[dbo].[ReceivedOrders2].[DeliveredQuantity] as [T_1].[DeliveredQuantity] AND [toho].[dbo].[ReceivedOrders2].[Store_ID] as [T_1].[Store_ID]='2100000101' AND ([toho].[dbo].[ReceivedOrders2].[Division_ID] as [T_1].[Division_ID]=' ' OR [toho].[dbo].[ReceivedOrders2].[Division_ID] as [T_1].[Division_ID]='0000000000' OR [toho].[dbo].[ReceivedOrders2].[Division_ID] as [T_1].[Division_ID]='1200000101' OR [toho].[dbo].[ReceivedOrders2].[Division_ID] as [T_1].[Division_ID]='1300000101' OR [toho].[dbo].[ReceivedOrders2].[Division_ID] as [T_1].[Division_ID]='1400000101' OR [toho].[dbo].[ReceivedOrders2].[Division_ID] as [T_1].[Division_ID]='2100000101' OR [toho].[dbo].[ReceivedOrders2].[Division_ID] as [T_1].[Division_ID]='2200000101' OR [toho].[dbo].[ReceivedOrders2].[Division_ID] as [T_1].[Division_ID]='2400000101' OR [toho].[dbo].[ReceivedOrders2].[Division_ID] as [T_1].[Division_ID]='3400000101')))
		|--Clustered Index Seek(OBJECT:([toho].[dbo].[ReceivedOrders].[ReceivedOrdersPK] AS [T_2]), SEEK:([T_2].[ID]=[toho].[dbo].[ReceivedOrders2].[Parent_ID] as [T_1].[Parent_ID]),  WHERE:([toho].[dbo].[ReceivedOrders].[Confirmed] as [T_2].[Confirmed]='A' AND [toho].[dbo].[ReceivedOrders].[Closed] as [T_2].[Closed]='N') ORDERED FORWARD)

Start read sql - InputParams: @{SelDivision_IDFrag}=('1300000101','1400000101','3400000101','2400000101','2200000101','1200000101','1500000101','2100000101');@{SelStore_IDFrag}=('1620000101','1600000101','3200000101','4400000101','2300000101','3300000101','1300000101','2600000101','3400000101','1500000101','2500000101','3500000101','2100000101');@{$IndexAndWhere}=;
				select T_1.StoreCard_ID as F_1$REFERENCE, T_1.Store_ID as F_2$REFERENCE, sum(T_1.Quantity) as F_3, sum(T_1.DeliveredQuantity) as F_4, T_1.StoreCard_ID as F_5, T_1.Store_ID as F_6
				from ReceivedOrders2 T_1
				join ReceivedOrders T_2 on T_2.ID = T_1.Parent_ID
				where (T_1.Store_ID in ('2100000101', '2200000101') and T_1.RowType = 3 and T_2.Confirmed = 'A' and T_2.Closed = 'N' and T_1.Quantity > T_1.DeliveredQuantity) and (((T_1.Division_ID IS NULL) OR (T_1.Division_ID = '0000000000') OR (T_1.Division_ID = ' ') OR (T_1.Division_ID IN {SelDivision_IDFrag}))) and (((T_1.Store_ID IS NULL) OR (T_1.Store_ID = '0000000000') OR (T_1.Store_ID = ' ') OR (T_1.Store_ID IN {SelStore_IDFrag})))
				group by T_1.StoreCard_ID, T_1.Store_ID
  
				SQL plan: Plan hash value: 2830092148
  
				---------------------------------------------------------------------------------------------------------------
				| Id  | Operation                     | Name                          | Rows  | Bytes | Cost (%CPU)| Time     |
				---------------------------------------------------------------------------------------------------------------
				|   0 | SELECT STATEMENT              |                               |     1 |    64 |     6  (17)| 00:00:01 |
				|   1 |  HASH GROUP BY                |                               |     1 |    64 |     6  (17)| 00:00:01 |
				|   2 |   NESTED LOOPS                |                               |     1 |    64 |     5   (0)| 00:00:01 |
				|   3 |    NESTED LOOPS               |                               |     4 |    64 |     5   (0)| 00:00:01 |
				|*  4 |     TABLE ACCESS FULL         | RECEIVEDORDERS                |     1 |    15 |     4   (0)| 00:00:01 |
				|*  5 |     INDEX RANGE SCAN          | IX_WS4K5TC4FSM43JGFVBMIIWSEXK |     4 |       |     0   (0)| 00:00:01 |
				|*  6 |    TABLE ACCESS BY INDEX ROWID| RECEIVEDORDERS2               |     2 |    98 |     1   (0)| 00:00:01 |
				---------------------------------------------------------------------------------------------------------------
  
				Predicate Information (identified by operation id):
				---------------------------------------------------
  
				4 - filter("T_2"."CONFIRMED"='A' AND "T_2"."CLOSED"='N')
				5 - access("T_2"."ID"="T_1"."PARENT_ID")
				6 - filter("T_1"."QUANTITY">"T_1"."DELIVEREDQUANTITY" AND "T_1"."ROWTYPE"=3 AND ("T_1"."STORE_ID" 
				IS NULL OR "T_1"."STORE_ID"='2100000101') AND ("T_1"."STORE_ID"='2100000101' OR 
				"T_1"."STORE_ID"='2200000101') AND ("T_1"."DIVISION_ID"=' ' OR "T_1"."DIVISION_ID"='0000000000' OR 
				"T_1"."DIVISION_ID"='1200000101' OR "T_1"."DIVISION_ID"='1300000101' OR 
				"T_1"."DIVISION_ID"='1400000101' OR "T_1"."DIVISION_ID"='1500000101' OR 
				"T_1"."DIVISION_ID"='2100000101' OR "T_1"."DIVISION_ID"='2200000101' OR 
		"T_1"."DIVISION_ID"='2400000101' OR "T_1"."DIVISION_ID"='3400000101'))