cpqtest-standaorg.endeavorcpq.com Open in urlscan Pro
20.3.144.8  Public Scan

Form analysis
3 forms found in the DOM

POST /Account/JsonLogin?ReturnUrl=%2Fsalesdashboard

<form action="/Account/JsonLogin?ReturnUrl=%2Fsalesdashboard" class="form form-small" id="loginForm" method="post"><input name="__RequestVerificationToken" type="hidden"
    value="oJJnWWNzyPY32bp6nsWQto_qK6QaRhL9AgeoT0zvcmiSJ0-8G2ZcXxsXyi4nPjvXdVG1GK2jbFm6I4phfH1bb5LNB8k1">
  <div class="form-wrapper">
    <div class="icon">
      <img class="icon company-logo" src="/Images/Vendavo_logo_tag_transparent.png">
    </div>
    <div class="well well-lg">
      <div class="form-group-lg">
        <div class="text-danger">
          <div class="validation-summary-valid" data-valmsg-summary="true">
            <ul>
              <li style="display:none"></li>
            </ul>
          </div>
        </div>
        <label class="sr-only" for="UserName">User name</label><input autofocus="" class="form-control" data-fv-notempty="true" data-fv-notempty-message="You must provide a Username." data-val="true"
          data-val-required="The User name field is required." id="loginName" name="UserName" placeholder="User Name" type="text" value=""><span class="field-validation-valid" data-valmsg-for="UserName" data-valmsg-replace="true"></span>
      </div>
      <div class="form-group-lg">
        <label class="sr-only" for="Password">Password</label>
        <input class="form-control" data-fv-notempty="true" data-fv-notempty-message="You must provide a Password." data-val="true" data-val-required="The Password field is required." id="Password" name="Password" placeholder="Password"
          type="password">
        <span class="field-validation-valid" data-valmsg-for="Password" data-valmsg-replace="true"></span>
      </div>
      <button type="submit" onclick="GuidedSelling.ShowStatus(this);" class="btn btn-lg btn-primary btn-block"><i class="uno login"></i> <span>Log In</span></button>
      <div class="form-group-lg">
        <br>
        <p> New here? <a href="/Home/Register">
                    Register
                </a>
        </p>
        <p>Forgot your password? <a href="#" id="showForgotPassword">Recover</a></p>
        <p>Forgot your username? <a href="#" id="showForgotUserName">Recover</a></p>
      </div>
      <div class="form-group-lg">
        <div class="checkbox">
          <label>
            <input data-val="true" data-val-required="The Remember me? field is required." id="RememberMe" name="RememberMe" type="checkbox" value="true"><input name="RememberMe" type="hidden" value="false"> Remember me? </label>
        </div>
      </div>
    </div>
  </div>
</form>

POST /Account/JsonForgotPassword?ReturnUrl=%2Fsalesdashboard

<form action="/Account/JsonForgotPassword?ReturnUrl=%2Fsalesdashboard" class="form-small" id="forgotPasswordForm" method="post"><input name="__RequestVerificationToken" type="hidden"
    value="qJekjiZImWUxaBPY1IZGOT0Z2tQe85wjTZsKkoXVBF9a6Ydsk1o6Jj_Iv30XCcbfUoFIvKPPd7qa0WgkTeA-ftJvjPQ1">
  <div class="form-wrapper">
    <div class="icon">
      <img class="icon company-logo" src="/Images/Vendavo_logo_tag_transparent.png">
    </div>
    <div class="alert alert-info">
      <h4>Forgot your password?</h4>
      <p>Please enter your UserName and we will send an Email to you which will allow you to reset your password.</p>
    </div>
    <div class="well well-lg">
      <div class="form-group-lg">
        <label class="sr-only" for="UserName">User name</label>
        <input autofocus="" class="form-control" data-val="true" data-val-required="The User name field is required." id="userName" name="UserName" placeholder="User Name" type="text" value="">
        <span class="field-validation-valid" data-valmsg-for="UserName" data-valmsg-replace="true"></span>
      </div>
      <button type="submit" onclick="GuidedSelling.ShowStatus(this);" class="btn btn-lg btn-primary btn-block">Continue</button>
      <button type="button" id="goBackFromForgotPassword" class="btn btn-lg btn-default btn-block">Back</button>
    </div>
    <div class="validation-summary-valid" data-valmsg-summary="true">
      <ul>
        <li style="display:none"></li>
      </ul>
    </div>
  </div>
</form>

POST /Account/JsonForgotUserName?ReturnUrl=%2Fsalesdashboard

<form action="/Account/JsonForgotUserName?ReturnUrl=%2Fsalesdashboard" class="form-small" id="forgotUserNameForm" method="post"><input name="__RequestVerificationToken" type="hidden"
    value="6D-XqMSVlx91VELT3t5oHq4xAJVUCzzruY-txaBbgoU_tbGakmhCXAuJBQXkPHBiEncaj78ORiswdBIka3l1ANnpz3k1">
  <div class="form-wrapper">
    <div class="icon">
      <img class="icon company-logo" src="/Images/Vendavo_logo_tag_transparent.png">
    </div>
    <div class="alert alert-info">
      <h4>Forgot your username?</h4>
      <p>Please enter the email address that is on file for this user and we will send your UserName to you.</p>
    </div>
    <div class="well">
      <div class="form-group-lg">
        <label class="sr-only" for="Email">Email</label>
        <input autofocus="" class="form-control" data-val="true" data-val-required="The Email field is required." id="email" name="Email" placeholder="Email Address" type="text" value="">
        <span class="field-validation-valid" data-valmsg-for="Email" data-valmsg-replace="true"></span>
      </div>
      <button type="submit" onclick="GuidedSelling.ShowStatus(this);" class="btn btn-lg btn-primary btn-block">Continue</button>
      <button type="button" id="goBackFromUserNamePanel" class="btn btn-lg btn-default btn-block">Back</button>
    </div>
    <div class="validation-summary-valid" data-valmsg-summary="true">
      <ul>
        <li style="display:none"></li>
      </ul>
    </div>
  </div>
</form>

Text Content

LOADING...


 * 

User name
Password
Log In



New here? Register

Forgot your password? Recover

Forgot your username? Recover

Remember me?


FORGOT YOUR PASSWORD?

Please enter your UserName and we will send an Email to you which will allow you
to reset your password.

User name
Continue Back
 * 

FORGOT YOUR USERNAME?

Please enter the email address that is on file for this user and we will send
your UserName to you.

Email
Continue Back
 * 

× Close



Cancel Ok
167.3 ms
home/login (167.3 ms) PD1MDWK00148E on Sat, 22 Jun 2024 21:11:55 GMT

duration with children from start sql
https://cpq-uswest2-coredev-wa1.azurewebsites... 13.0 167.3 +0.0  
Application_BeginRequest 0.0 0.0 +0.1   Authenticating Request... 0.3 5.2 +0.3
   Cache: Retrieving Profile 4.9 4.9 +0.6   Cache: GetCacheList 8.5 8.5 +8.8  
Executing Query: Profile 1.5 1.5 +19.3   Controller: HomeController.login 21.2
120.2 +27.7    Load View Data 1.3 99.0 +27.7     Cache: Retrieving Profile 7.6
7.6 +27.9     Load Organization Messages 0.0 0.0 +35.6    
GuidedSellingRequestContext 25.3 58.2 +35.6      BasketProvider - GetBasket 1.3
3.6 +35.9       Executing Query: Basket 2.3 2.3 +37.2 0.0 (1)       Sort 0.0 0.0
+39.5       MaterializeEntitiesFromDatatable 0.0 0.0 +39.5      QuoteProvider -
GetQuote 1.1 2.8 +39.6       Executing Query: Quote 1.7 1.7 +40.7 0.0 (1)      
Sort 0.0 0.0 +42.4       MaterializeEntitiesFromDatatable 0.0 0.0 +42.4     
Cache: Retrieving Profile 3.6 7.3 +42.5       Retrieving Profile via Database
1.6 3.7 +46.1        Executing Query: Profile 2.1 2.1 +47.7      Executing
Query: Profile 7.1 7.1 +58.4      Executing Query: PickList 1.6 1.6 +66.8 0.0
(1)      Sort 0.0 0.0 +68.5      MaterializeEntitiesFromDatatable 0.0 0.0 +68.5
     Executing Query: TeamMember 3.9 3.9 +70.4      Executing Query: PickList
1.6 1.6 +76.5 0.0 (1)      Sort 0.0 0.0 +78.2     
MaterializeEntitiesFromDatatable 0.1 0.1 +78.2      Executing Query: TeamMember
3.8 3.8 +79.7      Executing Query: PickListValue 1.1 1.1 +84.5 0.0 (1)     
Sort 0.0 0.0 +85.7      MaterializeEntitiesFromDatatable 0.0 0.0 +85.7    
Application Parameters 0.4 0.4 +93.9     Request Parameters 0.0 0.0 +94.3    
PageScript 3.2 6.2 +94.3      Executing Query: Page 2.7 2.7 +95.1 0.0 (1)     
Sort 0.0 0.0 +97.9      MaterializeEntitiesFromDatatable 0.3 0.3 +97.9    
Service Urls 0.0 0.0 +100.6     Admin link info 0.0 0.0 +100.7     GetPageView
0.0 3.1 +100.8      GetPageView 0.0 3.1 +100.8       provider.GetPageView 0.1
3.1 +100.8        PageView - DbFetch 3.0 3.0 +100.9        turn results into
PageView 0.0 0.0 +103.9     EntityMetadata - DbFetch 20.7 20.7 +104.1     Turn
results into List 1.4 1.4 +124.8     navbar 0.1 0.1 +126.5   Find: v2/Login 0.0
0.0 +147.9   Render: v2/Login 2.8 18.9 +147.9    Find: v2/_Login 0.0 0.0 +148.1
   Render partial: v2/_Login 7.8 7.8 +148.1    Find: v2/_ForgotPassword 0.0 0.0
+156.0    Render partial: v2/_ForgotPassword 3.8 3.8 +156.0    Find:
v2/_ForgotUserName 0.0 0.0 +159.9    Render partial: v2/_ForgotUserName 3.8 3.8
+159.9    Find: _AppHead 0.0 0.0 +163.8    Render partial: _AppHead 0.7 0.7
+163.9    Find: _SessionManagement 0.0 0.0 +165.4    Render partial:
_SessionManagement 0.0 0.0 +165.4

sql: 0.0 %

client event duration from start Connect 0.0 +1093.0 Domain Lookup 0.0 +1093.0
Fetch Start +1093.0 Request Start +1094.0 Response 2.0 +1458.0 Dom Loading
+1462.0 Dom Content Loaded Event 5.0 +3072.0 Dom Interactive +3072.0 First Paint
Time +3131.0 Load Event 3.0 +3300.0 Dom Complete +3300.0

share more columns show trivial

step
time from start
call type
duration call stack
call 37.30 ms
https://cpq-uswest2-coredev-wa1.azurewebsites.net:443/home/login?ReturnUrl=%2fsalesdashboard
— 12.50 ms
Executing Query: Basket
T+37.3 ms
sql - Reader
0.0 ms

GetDataSet GetExtlessQueryResultsData GetExtlessQueryResults InternalExecuteQueryAction b__1 b__0

SELECT 
[Basket].[BasketId] [Basket_BasketId] , [Basket].[ProfileId] [Basket_ProfileId] , [Basket].[OwningTeamId] [Basket_OwningTeamId] , [Basket].[IsPrivate] [Basket_IsPrivate] , [Basket].[EntityDisplayName] [Basket_EntityDisplayName] , [Basket].[RequiresApproval] [Basket_RequiresApproval] , [Basket].[ApproverId] [Basket_ApproverId] , [Basket].[CustomerId] [Basket_CustomerId] , [Basket].[CustomerName] [Basket_CustomerName] , [Basket].[CustomerType] [Basket_CustomerType] , [Basket].[CustomerRiskScore] [Basket_CustomerRiskScore] , [Basket].[CustomerRiskLevel] [Basket_CustomerRiskLevel] , [Basket].[CustomerRiskDescription] [Basket_CustomerRiskDescription] , [Basket].[PricingSegmentId] [Basket_PricingSegmentId] , [Basket].[ContactId] [Basket_ContactId] , [Basket].[ContactName] [Basket_ContactName] , [Basket].[QuoteId] [Basket_QuoteId] , [Basket].[OpportunityId] [Basket_OpportunityId] , [Basket].[OrderId] [Basket_OrderId] , [Basket].[LeadId] [Basket_LeadId] , [Basket].[IsCurrent] [Basket_IsCurrent] , [Basket].[ExpiresOn] [Basket_ExpiresOn] , [Basket].[Note] [Basket_Note] , [Basket].[ApprovalNotes] [Basket_ApprovalNotes] , [Basket].[Description] [Basket_Description] , [Basket].[QuoteNumber] [Basket_QuoteNumber] , [Basket].[OrderNumber] [Basket_OrderNumber] , [Basket].[PriceLevelId] [Basket_PriceLevelId] , [Basket].[PriceLevelName] [Basket_PriceLevelName] , [Basket].[PricingMethod] [Basket_PricingMethod] , [Basket].[Revision] [Basket_Revision] , [Basket].[ShippingMethod] [Basket_ShippingMethod] , [Basket].[ShippingMethodId] [Basket_ShippingMethodId] , [Basket].[ShipToName] [Basket_ShipToName] , [Basket].[ShipToAddress1] [Basket_ShipToAddress1] , [Basket].[ShipToAddress2] [Basket_ShipToAddress2] , [Basket].[ShipToAddress3] [Basket_ShipToAddress3] , [Basket].[ShipToCity] [Basket_ShipToCity] , [Basket].[ShipToState] [Basket_ShipToState] , [Basket].[ShipToCountry] [Basket_ShipToCountry] , [Basket].[ShipToPostalCode] [Basket_ShipToPostalCode] , [Basket].[ShipToAddressId] [Basket_ShipToAddressId] , [Basket].[ShipFromAddressId] [Basket_ShipFromAddressId] , [Basket].[BillToName] [Basket_BillToName] , [Basket].[BillToAddress1] [Basket_BillToAddress1] , [Basket].[BillToAddress2] [Basket_BillToAddress2] , [Basket].[BillToAddress3] [Basket_BillToAddress3] , [Basket].[BillToCity] [Basket_BillToCity] , [Basket].[BillToState] [Basket_BillToState] , [Basket].[BillToCountry] [Basket_BillToCountry] , [Basket].[BillToPostalCode] [Basket_BillToPostalCode] , [Basket].[BillToAddressId] [Basket_BillToAddressId] , [Basket].[PurchaseOrderNumber] [Basket_PurchaseOrderNumber] , [Basket].[CreditCardInfoId] [Basket_CreditCardInfoId] , [Basket].[Total] [Basket_Total] , [Basket].[TaxTotal] [Basket_TaxTotal] , [Basket].[ShippingTotal] [Basket_ShippingTotal] , [Basket].[CurrencyId] [Basket_CurrencyId] , [Basket].[CurrencyCode] [Basket_CurrencyCode] , [Basket].[ExchangeRate] [Basket_ExchangeRate] , [Basket].[Culture] [Basket_Culture] , [Basket].[Status] [Basket_Status] , [Basket].[StatusReason] [Basket_StatusReason] , [Basket].[ApprovalStatus] [Basket_ApprovalStatus] , [Basket].[DiscountPercentage] [Basket_DiscountPercentage] , [Basket].[DiscountAmount] [Basket_DiscountAmount] , [Basket].[MarkupPercentage] [Basket_MarkupPercentage] , [Basket].[MarkupAmount] [Basket_MarkupAmount] , [Basket].[UserText1] [Basket_UserText1] , [Basket].[UserText2] [Basket_UserText2] , [Basket].[UserText3] [Basket_UserText3] , [Basket].[UserText4] [Basket_UserText4] , [Basket].[UserText5] [Basket_UserText5] , [Basket].[UserText6] [Basket_UserText6] , [Basket].[UserText7] [Basket_UserText7] , [Basket].[UserText8] [Basket_UserText8] , [Basket].[UserText9] [Basket_UserText9] , [Basket].[UserText10] [Basket_UserText10] , [Basket].[OrganizationId] [Basket_OrganizationId] , [Basket].[ReviseOnSave] [Basket_ReviseOnSave] , [Basket].[LanguageId] [Basket_LanguageId] , [Basket].[Commission] [Basket_Commission] , [Basket].[Margin] [Basket_Margin] , [Basket].[QuoteNumberPrefix] [Basket_QuoteNumberPrefix] , [Basket].[IsTemplate] [Basket_IsTemplate] , [Basket].[DeletionState] [Basket_DeletionState] , [Basket].[CreatedOn] [Basket_CreatedOn] , [Basket].[ModifiedOn] [Basket_ModifiedOn] , [Basket].[CreatedBy] [Basket_CreatedBy] , [Basket].[ModifiedBy] [Basket_ModifiedBy] , [Basket].[DynamicDropdown] [Basket_DynamicDropdown] , [Basket].[Mode] [Basket_Mode] , [Basket].[PriceAgreementId] [Basket_PriceAgreementId] , [Basket].[SomeTextProp] [Basket_SomeTextProp] , [Basket].[SomeTextProp1] [Basket_SomeTextProp1] , [Basket].[SomeText] [Basket_SomeText] , [Basket].[QuetePropTest] [Basket_QuetePropTest] , [Basket].[SomeTestTextProp] [Basket_SomeTestTextProp] , [Basket].[TextProp] [Basket_TextProp] , [Basket].[TestProp3] [Basket_TestProp3] , [Basket].[ASdasdasda] [Basket_ASdasdasda] , [Basket].[dwqdqwdqw] [Basket_dwqdqwdqw] , [Basket].[RequiredProperties] [Basket_RequiredProperties] , [Basket].[UnRequiredProperties] [Basket_UnRequiredProperties] , [Basket].[RequiredText] [Basket_RequiredText] , [Basket].[RequiredNumber] [Basket_RequiredNumber] , [Basket].[NotRequiredNumber] [Basket_NotRequiredNumber] , [Basket].[RequiredDate] [Basket_RequiredDate] , [Basket].[notRequiredDate] [Basket_notRequiredDate] , [Basket].[NotRequiredText] [Basket_NotRequiredText] , [Basket].[BusinessEntityId] [Basket_BusinessEntityId] , [Basket].[BusinessEntityName] [Basket_BusinessEntityName] , [Basket].[DistributionChannel] [Basket_DistributionChannel] , [Basket].[Industry] [Basket_Industry] , [Basket].[IsValid] [Basket_IsValid] , [Basket].[ProductType] [Basket_ProductType] , [Basket].[Color] [Basket_Color] , [Basket].[EscapeBug] [Basket_EscapeBug] , [Basket].[ApprovalLevel] [Basket_ApprovalLevel] , [Basket].[Region] [Basket_Region] , [Basket].[CustomText] [Basket_CustomText] , [Basket].[ExecutePriceRule] [Basket_ExecutePriceRule] , [Basket].[PriceRule] [Basket_PriceRule] 
 FROM [Basket]
 WHERE [Basket].[BasketId] IN (  SELECT DISTINCT TOP 7500 [Basket].[BasketId] FROM ( 
 SELECT DISTINCT TOP 7500 [Basket].[BasketId] 
 FROM [Basket] 
 WHERE 1 = 1  And [Basket].[BasketId] = @0
 ORDER BY [Basket].[BasketId]
) as [Basket]
)

3.50 ms
Executing Query: Basket — 2.20 ms
Executing Query: Quote
T+40.8 ms
sql - Reader
0.0 ms

GetDataSet GetExtlessQueryResultsData GetExtlessQueryResults InternalExecuteQueryAction b__1 b__0

SELECT 
[Quote].[QuoteId] [Quote_QuoteId] , [Quote].[ProfileId] [Quote_ProfileId] , [Quote].[IsPrivate] [Quote_IsPrivate] , [Quote].[OwningTeamId] [Quote_OwningTeamId] , [Quote].[RequiresApproval] [Quote_RequiresApproval] , [Quote].[ApproverId] [Quote_ApproverId] , [Quote].[CustomerId] [Quote_CustomerId] , [Quote].[CustomerType] [Quote_CustomerType] , [Quote].[CustomerName] [Quote_CustomerName] , [Quote].[CustomerRiskScore] [Quote_CustomerRiskScore] , [Quote].[CustomerRiskLevel] [Quote_CustomerRiskLevel] , [Quote].[CustomerRiskDescription] [Quote_CustomerRiskDescription] , [Quote].[PricingSegmentId] [Quote_PricingSegmentId] , [Quote].[ContactId] [Quote_ContactId] , [Quote].[ContactName] [Quote_ContactName] , [Quote].[OpportunityId] [Quote_OpportunityId] , [Quote].[LeadId] [Quote_LeadId] , [Quote].[IsCurrent] [Quote_IsCurrent] , [Quote].[ExpiresOn] [Quote_ExpiresOn] , [Quote].[Note] [Quote_Note] , [Quote].[ApprovalNotes] [Quote_ApprovalNotes] , [Quote].[Description] [Quote_Description] , [Quote].[QuoteNumber] [Quote_QuoteNumber] , [Quote].[EntityDisplayName] [Quote_EntityDisplayName] , [Quote].[PriceLevelId] [Quote_PriceLevelId] , [Quote].[PricingMethod] [Quote_PricingMethod] , [Quote].[Revision] [Quote_Revision] , [Quote].[ShippingMethod] [Quote_ShippingMethod] , [Quote].[ShippingMethodId] [Quote_ShippingMethodId] , [Quote].[ShipToName] [Quote_ShipToName] , [Quote].[ShipToAddress1] [Quote_ShipToAddress1] , [Quote].[ShipToAddress2] [Quote_ShipToAddress2] , [Quote].[ShipToAddress3] [Quote_ShipToAddress3] , [Quote].[ShipToCity] [Quote_ShipToCity] , [Quote].[ShipToState] [Quote_ShipToState] , [Quote].[ShipToCountry] [Quote_ShipToCountry] , [Quote].[ShipToPostalCode] [Quote_ShipToPostalCode] , [Quote].[ShipToAddressId] [Quote_ShipToAddressId] , [Quote].[ShipFromAddressId] [Quote_ShipFromAddressId] , [Quote].[BillToName] [Quote_BillToName] , [Quote].[BillToAddress1] [Quote_BillToAddress1] , [Quote].[BillToAddress2] [Quote_BillToAddress2] , [Quote].[BillToAddress3] [Quote_BillToAddress3] , [Quote].[BillToCity] [Quote_BillToCity] , [Quote].[BillToState] [Quote_BillToState] , [Quote].[BillToCountry] [Quote_BillToCountry] , [Quote].[BillToPostalCode] [Quote_BillToPostalCode] , [Quote].[BillToAddressId] [Quote_BillToAddressId] , [Quote].[PurchaseOrderNumber] [Quote_PurchaseOrderNumber] , [Quote].[CreditCardAuthCode] [Quote_CreditCardAuthCode] , [Quote].[Total] [Quote_Total] , [Quote].[TaxTotal] [Quote_TaxTotal] , [Quote].[ShippingTotal] [Quote_ShippingTotal] , [Quote].[CurrencyId] [Quote_CurrencyId] , [Quote].[CurrencyCode] [Quote_CurrencyCode] , [Quote].[PriceLevelName] [Quote_PriceLevelName] , [Quote].[ExchangeRate] [Quote_ExchangeRate] , [Quote].[Culture] [Quote_Culture] , [Quote].[Status] [Quote_Status] , [Quote].[StatusReason] [Quote_StatusReason] , [Quote].[ApprovalStatus] [Quote_ApprovalStatus] , [Quote].[DiscountPercentage] [Quote_DiscountPercentage] , [Quote].[DiscountAmount] [Quote_DiscountAmount] , [Quote].[MarkupPercentage] [Quote_MarkupPercentage] , [Quote].[MarkupAmount] [Quote_MarkupAmount] , [Quote].[UserText1] [Quote_UserText1] , [Quote].[UserText2] [Quote_UserText2] , [Quote].[UserText3] [Quote_UserText3] , [Quote].[UserText4] [Quote_UserText4] , [Quote].[UserText5] [Quote_UserText5] , [Quote].[UserText6] [Quote_UserText6] , [Quote].[UserText7] [Quote_UserText7] , [Quote].[UserText8] [Quote_UserText8] , [Quote].[UserText9] [Quote_UserText9] , [Quote].[UserText10] [Quote_UserText10] , [Quote].[LanguageId] [Quote_LanguageId] , [Quote].[Commission] [Quote_Commission] , [Quote].[Margin] [Quote_Margin] , [Quote].[QuoteNumberPrefix] [Quote_QuoteNumberPrefix] , [Quote].[IsTemplate] [Quote_IsTemplate] , [Quote].[OrganizationId] [Quote_OrganizationId] , [Quote].[DeletionState] [Quote_DeletionState] , [Quote].[SubscriberOrganizationName] [Quote_SubscriberOrganizationName] , [Quote].[SubscriberUserFullName] [Quote_SubscriberUserFullName] , [Quote].[CreatedOn] [Quote_CreatedOn] , [Quote].[ModifiedOn] [Quote_ModifiedOn] , [Quote].[CreatedBy] [Quote_CreatedBy] , [Quote].[ModifiedBy] [Quote_ModifiedBy] , [Quote].[DynamicDropdown] [Quote_DynamicDropdown] , [Quote].[SomeTextProp] [Quote_SomeTextProp] , [Quote].[SomeTextProp1] [Quote_SomeTextProp1] , [Quote].[SomeText] [Quote_SomeText] , [Quote].[QuetePropTest] [Quote_QuetePropTest] , [Quote].[SomeTestTextProp] [Quote_SomeTestTextProp] , [Quote].[TextProp] [Quote_TextProp] , [Quote].[TestProp3] [Quote_TestProp3] , [Quote].[ASdasdasda] [Quote_ASdasdasda] , [Quote].[dwqdqwdqw] [Quote_dwqdqwdqw] , [Quote].[RequiredProperties] [Quote_RequiredProperties] , [Quote].[UnRequiredProperties] [Quote_UnRequiredProperties] , [Quote].[RequiredText] [Quote_RequiredText] , [Quote].[RequiredNumber] [Quote_RequiredNumber] , [Quote].[NotRequiredNumber] [Quote_NotRequiredNumber] , [Quote].[RequiredDate] [Quote_RequiredDate] , [Quote].[notRequiredDate] [Quote_notRequiredDate] , [Quote].[NotRequiredText] [Quote_NotRequiredText] , [Quote].[BusinessEntityId] [Quote_BusinessEntityId] , [Quote].[BusinessEntityName] [Quote_BusinessEntityName] , [Quote].[DistributionChannel] [Quote_DistributionChannel] , [Quote].[Industry] [Quote_Industry] , [Quote].[ProductType] [Quote_ProductType] , [Quote].[Color] [Quote_Color] , [Quote].[EscapeBug] [Quote_EscapeBug] , [Quote].[ApprovalLevel] [Quote_ApprovalLevel] , [Quote].[Region] [Quote_Region] , [Quote].[CustomText] [Quote_CustomText] , [Quote].[ExecutePriceRule] [Quote_ExecutePriceRule] , [Quote].[PriceRule] [Quote_PriceRule] 
 FROM [Quote]
 WHERE [Quote].[QuoteId] IN (  SELECT DISTINCT TOP 7500 [Quote].[QuoteId] FROM ( 
 SELECT DISTINCT TOP 7500 [Quote].[QuoteId] 
 FROM [Quote] 
 WHERE 1 = 1  And [Quote].[QuoteId] = @0
 ORDER BY [Quote].[QuoteId]
) as [Quote]
)

26.10 ms
GuidedSellingRequestContext — 10.00 ms
Executing Query: PickList
T+66.9 ms
sql - Reader
0.0 ms

GetDataSet GetExtlessQueryResultsData GetExtlessQueryResults InternalExecuteQueryAction b__1 b__0

SELECT [PickList].[PickListId] [PickList_PickListId] , [PickList].[Name] [PickList_Name] , [PickList].[Description] [PickList_Description] , [PickList].[DataType] [PickList_DataType] , [PickList].[IsSystemDefined] [PickList_IsSystemDefined] , [PickList].[MessageId] [PickList_MessageId] , [PickList].[OrganizationId] [PickList_OrganizationId] , [PickList].[DeletionState] [PickList_DeletionState] , [PickList].[CreatedOn] [PickList_CreatedOn] , [PickList].[ModifiedOn] [PickList_ModifiedOn] , [PickList].[CreatedBy] [PickList_CreatedBy] , [PickList].[ModifiedBy] [PickList_ModifiedBy] , [PickListValue].[PickListValueId] [PickListValue_PickListValueId] , [PickListValue].[PickListId] [PickListValue_PickListId] , case when[PickListValue_T].[LanguageId] is not null and [PickListValue_T].Translation1 is not null then [PickListValue_T].Translation1 else [PickListValue].[Name] END as [PickListValue_Name] , [PickListValue].[Code] [PickListValue_Code] , [PickListValue].[Value] [PickListValue_Value] , [PickListValue].[MessageId] [PickListValue_MessageId] , [PickListValue].[SortOrder] [PickListValue_SortOrder] , [PickListValue].[OrganizationId] [PickListValue_OrganizationId] , [PickListValue].[DeletionState] [PickListValue_DeletionState] , [PickListValue].[CreatedOn] [PickListValue_CreatedOn] , [PickListValue].[ModifiedOn] [PickListValue_ModifiedOn] , [PickListValue].[CreatedBy] [PickListValue_CreatedBy] , [PickListValue].[ModifiedBy] [PickListValue_ModifiedBy] , [PickListValue].[IsSystemDefined] [PickListValue_IsSystemDefined] , [PickListValue].[IsDefault] [PickListValue_IsDefault]  FROM [PickList] LEFT OUTER JOIN [PickListValue] ON [PickList].PickListId = [PickListValue].PickListId
 left join [Translation] [PickListValue_T] on PickListValue.PickListValueId = [PickListValue_T].EntityId and [PickListValue_T].LanguageId = 'en-US'
 WHERE [PickList].[PickListId] IN ( SELECT DISTINCT TOP 7500 [PickList].[PickListId] FROM ( 
 SELECT DISTINCT TOP 7500 [PickList].[PickListId] 
 FROM [PickList] 
 WHERE 1 = 1  And ( [PickList].[Name] = @0 ) AND [PickList].[DeletionState] <> 1 
 ORDER BY [PickList].[PickListId]
) as [PickList]
)

9.80 ms
GuidedSellingRequestContext — 4.20 ms
Executing Query: PickList
T+76.7 ms
sql - Reader
0.0 ms

GetDataSet GetExtlessQueryResultsData GetExtlessQueryResults InternalExecuteQueryAction b__1 b__0

SELECT [PickList].[PickListId] [PickList_PickListId] , [PickList].[Name] [PickList_Name] , [PickList].[Description] [PickList_Description] , [PickList].[DataType] [PickList_DataType] , [PickList].[IsSystemDefined] [PickList_IsSystemDefined] , [PickList].[MessageId] [PickList_MessageId] , [PickList].[OrganizationId] [PickList_OrganizationId] , [PickList].[DeletionState] [PickList_DeletionState] , [PickList].[CreatedOn] [PickList_CreatedOn] , [PickList].[ModifiedOn] [PickList_ModifiedOn] , [PickList].[CreatedBy] [PickList_CreatedBy] , [PickList].[ModifiedBy] [PickList_ModifiedBy] , [PickListValue].[PickListValueId] [PickListValue_PickListValueId] , [PickListValue].[PickListId] [PickListValue_PickListId] , case when[PickListValue_T].[LanguageId] is not null and [PickListValue_T].Translation1 is not null then [PickListValue_T].Translation1 else [PickListValue].[Name] END as [PickListValue_Name] , [PickListValue].[Code] [PickListValue_Code] , [PickListValue].[Value] [PickListValue_Value] , [PickListValue].[MessageId] [PickListValue_MessageId] , [PickListValue].[SortOrder] [PickListValue_SortOrder] , [PickListValue].[OrganizationId] [PickListValue_OrganizationId] , [PickListValue].[DeletionState] [PickListValue_DeletionState] , [PickListValue].[CreatedOn] [PickListValue_CreatedOn] , [PickListValue].[ModifiedOn] [PickListValue_ModifiedOn] , [PickListValue].[CreatedBy] [PickListValue_CreatedBy] , [PickListValue].[ModifiedBy] [PickListValue_ModifiedBy] , [PickListValue].[IsSystemDefined] [PickListValue_IsSystemDefined] , [PickListValue].[IsDefault] [PickListValue_IsDefault]  FROM [PickList] LEFT OUTER JOIN [PickListValue] ON [PickList].PickListId = [PickListValue].PickListId
 left join [Translation] [PickListValue_T] on PickListValue.PickListValueId = [PickListValue_T].EntityId and [PickListValue_T].LanguageId = 'en-US'
 WHERE [PickList].[PickListId] IN ( SELECT DISTINCT TOP 7500 [PickList].[PickListId] FROM ( 
 SELECT DISTINCT TOP 7500 [PickList].[PickListId] 
 FROM [PickList] 
 WHERE 1 = 1  And ( [PickList].[Name] = @0 ) AND [PickList].[DeletionState] <> 1 
 ORDER BY [PickList].[PickListId]
) as [PickList]
)

7.90 ms
Executing Query: TeamMember — 3.80 ms
Executing Query: PickListValue
T+84.6 ms
sql - Reader
0.0 ms

GetDataSet GetExtlessQueryResultsData GetExtlessQueryResults InternalExecuteQueryAction b__1 b__0

SELECT 
[PickListValue].[PickListValueId] [PickListValue_PickListValueId] , [PickListValue].[PickListId] [PickListValue_PickListId] , case when[PickListValue_T].[LanguageId] is not null and [PickListValue_T].Translation1 is not null then [PickListValue_T].Translation1 else [PickListValue].[Name] END as [PickListValue_Name] , [PickListValue].[Code] [PickListValue_Code] , [PickListValue].[Value] [PickListValue_Value] , [PickListValue].[MessageId] [PickListValue_MessageId] , [PickListValue].[SortOrder] [PickListValue_SortOrder] , [PickListValue].[OrganizationId] [PickListValue_OrganizationId] , [PickListValue].[DeletionState] [PickListValue_DeletionState] , [PickListValue].[CreatedOn] [PickListValue_CreatedOn] , [PickListValue].[ModifiedOn] [PickListValue_ModifiedOn] , [PickListValue].[CreatedBy] [PickListValue_CreatedBy] , [PickListValue].[ModifiedBy] [PickListValue_ModifiedBy] , [PickListValue].[IsSystemDefined] [PickListValue_IsSystemDefined] , [PickListValue].[IsDefault] [PickListValue_IsDefault] 
 FROM [PickListValue]
LEFT OUTER JOIN [PickList] ON [PickList].PickListId = [PickListValue].PickListId
 left join [Translation] [PickListValue_T] on PickListValue.PickListValueId = [PickListValue_T].EntityId and [PickListValue_T].LanguageId = 'en-US'
 WHERE [PickListValue].[PickListValueId] IN (  SELECT DISTINCT TOP 7500 [PickListValue].[PickListValueId] FROM ( 
 SELECT DISTINCT TOP 7500 [PickListValue].[PickListValueId] 
 FROM [PickListValue] LEFT OUTER JOIN [PickList] ON [PickList].PickListId = [PickListValue].PickListId
 WHERE 1 = 1  And ( [PickList].[Name] = @0 And [PickListValue].[IsDefault] = @1 ) AND [PickListValue].[DeletionState] <> 1 
 ORDER BY [PickListValue].[PickListValueId]
) as [PickListValue]
)

10.70 ms
GuidedSellingRequestContext — 8.20 ms
Executing Query: Page
T+95.3 ms
sql - Reader
0.0 ms

GetDataSet GetExtlessQueryResultsData GetExtlessQueryResults InternalExecuteQueryAction b__1 b__0

SELECT 
[Page].[PageId] [Page_PageId] , [Page].[Name] [Page_Name] , case when[Page_T].[LanguageId] is not null and [Page_T].Translation1 is not null then [Page_T].Translation1 else [Page].[DisplayName] END as [Page_DisplayName] , [Page].[Icon] [Page_Icon] , [Page].[MessageId] [Page_MessageId] , case when[Page_T].[LanguageId] is not null and [Page_T].Translation2 is not null then [Page_T].Translation2 else [Page].[Description] END as [Page_Description] , [Page].[Url] [Page_Url] , [Page].[PresenterUrl] [Page_PresenterUrl] , [Page].[SortOrder] [Page_SortOrder] , [Page].[Entity] [Page_Entity] , [Page].[Template] [Page_Template] , [Page].[OnLoadScript] [Page_OnLoadScript] , [Page].[OnSubmitScript] [Page_OnSubmitScript] , [Page].[IsActive] [Page_IsActive] , [Page].[DisplayOnHeader] [Page_DisplayOnHeader] , [Page].[DisplayOnSubHeader] [Page_DisplayOnSubHeader] , [Page].[DisplayAsTile] [Page_DisplayAsTile] , [Page].[EnforceRoleSecurity] [Page_EnforceRoleSecurity] , [Page].[Role] [Page_Role] , [Page].[IsSystemDefined] [Page_IsSystemDefined] , [Page].[OrganizationId] [Page_OrganizationId] , [Page].[DeletionState] [Page_DeletionState] , [Page].[CreatedOn] [Page_CreatedOn] , [Page].[ModifiedOn] [Page_ModifiedOn] , [Page].[CreatedBy] [Page_CreatedBy] , [Page].[ModifiedBy] [Page_ModifiedBy] , [Page].[LockEntity] [Page_LockEntity] 
 FROM [Page]

 left join [Translation] [Page_T] on Page.PageId = [Page_T].EntityId and [Page_T].LanguageId = 'en-US'
 WHERE [Page].[PageId] IN (  SELECT DISTINCT TOP 7500 [Page].[PageId] FROM ( 
 SELECT DISTINCT TOP 7500 [Page].[PageId] 
, [Page].[SortOrder] 
 FROM [Page] 
 WHERE 1 = 1  AND [Page].[DeletionState] <> 1 
 ORDER BY [Page].[SortOrder], [Page].[PageId]
) as [Page]
)

72.00 ms
Controller: HomeController.login — 21.20 ms

show trivial gaps

mc