Teddy Volkswagen
3743 Boston Rd Bronx, NY 10466-5840
Parts & Service : abc ,
Today 9:00 AM - 8:00 PM Parts & Service 7:30 AM - 6:00 PM
Open Today !
Sales: 9:00 AM - 8:00 PM
Parts & Service: 7:30 AM - 6:00 PM
All Hours
7.72 ms
https://www.teamvstagingacura.com/
primary-offersites-client-web-app-657b546b7b-9kvwb
(7.72 ms)
Tue, 08 Apr 2025 01:21:33 GMT
duration (ms) with children (ms) from start (ms)
https://www.teamvstagingacura.com/ 7.25 7.72 +0.00
Redis Key: domainredirect.www.teamvstagingacura.com.domainredirect 0.47 0.47 +5.80
208.30 ms
Inventory/VehicleDetails
primary-offersites-client-web-app-657b546b7b-9kvwb
(208.30 ms)
Tue, 08 Apr 2025 01:46:51 GMT
duration (ms) with children (ms) from start (ms) sql (ms)
https://teamvstagingvolkswagen.com/viewdetails/used/1ftbw9ck7pka41099/2023-ford-e-transit-cargo-van- 20.07 208.30 +0.00 4.54 (1)
Redis Key: domainredirect.teamvstagingvolkswagen.com.domainredirect 0.89 0.89 +5.85
Redis Key: campaignsettings.teamvstagingvolkswagen.com.settings 1.31 1.31 +7.21
Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails 0.24 186.03 +16.97
Resource Filter (Execing): SaveTempDataFilter 0.00 0.00 +16.99
Action Filter (Exec): ControllerActionFilter 0.03 47.14 +17.14
Action Filter (Execing): UnsupportedContentTypeFilter 0.00 0.00 +17.15
Action Filter (Exec): EventLoggerActionFilter 7.63 47.11 +17.15 3.97 (1)
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails 35.34 39.48 +24.75 11.56 (3)
Redis Key: pagesettings.teamvstagingvolkswagen.com_usedinventoryvehicledetails_295_22_14.pagesettings 0.97 0.97 +24.80
Redis Key: dealercampaignsettingscache.teamvstagingvolkswagen.com.dealercampaignsettingscache 0.85 0.85 +25.86
Redis Key: dealerCampaignVDPSettings.teamvstagingvolkswagen.com.295.dealerCampaignVDPSettings 2.32 2.32 +29.60
Action Filter (Execed): UnsupportedContentTypeFilter 0.00 0.00 +64.28
Result Filter (Execing): SaveTempDataFilter 0.00 0.00 +64.30
Result Filter (Exec): EventLoggerActionFilter 0.02 138.65 +64.30
View: ~/Views/Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml 29.39 138.63 +64.31
View: _ViewStart.cshtml 0.07 0.07 +64.42
View: Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml 9.25 78.16 +64.54 6.76 (2)
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml 12.24 19.06 +72.15 9.27 (4)
Redis Key: dealerCampaignSRPSettings.teamvstagingvolkswagen.com.295.dealerCampaignSRPSettings 0.93 0.93 +72.19
Redis Key: DigitalRetailerSettings.teamvstagingvolkswagen.com_44550.DigitalRetailerSettings 0.80 0.80 +79.07
Redis Key: WebValuationProvider.teamvstagingvolkswagen.com.WebValuationProvider 0.92 0.92 +85.51
Redis Key: SoftPullSettings.teamvstagingvolkswagen.com.SoftPullSettings 0.74 0.74 +86.72
Redis Key: dealerships.teamvstagingvolkswagen.com.59271.dealerships 0.72 0.72 +87.52
View: Shared/Partials/TrackingPixels/_TrackingPixel.cshtml 2.71 2.71 +88.37 2.39 (1)
View: Shared/Partials/Scripts/InventoryDetailsJsonLD.cshtml 3.36 4.01 +91.31 2.32 (1)
Redis Key: dealerCampaignSeoEnabled.teamvstagingvolkswagen.com.dealerCampaignSeoEnabled 0.65 0.65 +91.33
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header.cshtml 0.00 0.00 +95.71
Component (Invoke): StickyPriceBar 3.25 3.25 +95.78 2.74 (1)
View: Shared/Components/StickyPriceBar/StickyPriceBar.cshtml 0.03 0.03 +99.11
View: Shared/_VehicleTellInVdp.cshtml 0.00 0.00 +99.18
Component (Invoke): OEMInventoryGallery 0.01 0.01 +99.22
View: Shared/Components/OEMInventoryGallery/OEMInventoryGallery.cshtml 0.00 0.00 +99.26
View: Shared/Partials/Scripts/PureCarsWidget.cshtml 0.00 0.00 +99.28
Component (Invoke): VehicleDetailsPayments 0.00 0.00 +99.32
View: Shared/Components/VehicleDetailsPayments/VehicleDetailsPaymentsViewComponent.cshtml 0.03 0.03 +99.34
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Button.cshtml 3.74 3.74 +99.41 2.95 (1)
Component (Invoke): OEMVehicleDetails 0.01 0.01 +103.22
View: Shared/Components/OEMVehicleDetails/OEMVehicleDetails.cshtml 3.17 3.17 +103.29 2.56 (1)
Component (Invoke): Empty 0.01 0.01 +106.55
View: Shared/Components/Empty/Empty.cshtml 0.00 0.00 +106.61
Component (Invoke): PrimaryInventoryKeyFeatures 0.01 0.01 +106.63
View: Shared/Components/PrimaryInventoryKeyFeatures/PrimaryInventoryKeyFeatures.cshtml 0.00 0.00 +106.66
Component (Invoke): OEMInventorySpecifications 3.54 3.54 +106.68 3.06 (1)
View: Shared/Components/OEMInventorySpecifications/OEMInventorySpecifications.cshtml 28.10 28.10 +110.32 3.02 (1)
Component (Invoke): PrimaryInventorySimilarVehicles 0.01 0.01 +138.52
View: Shared/Components/PrimaryInventorySimilarVehicles/PrimaryInventorySimilarVehicles.cshtml 0.00 0.00 +138.58
Component (Invoke): Empty 0.00 0.00 +138.60
View: Shared/Components/Empty/Empty.cshtml 0.00 0.00 +138.61
Component (Invoke): Empty 0.00 0.00 +138.62
View: Shared/Components/Empty/Empty.cshtml 0.00 0.00 +138.63
Component (Invoke): Empty 0.00 0.00 +138.63
View: Shared/Components/Empty/Empty.cshtml 0.00 0.00 +138.64
View: Shared/Partials/VdpCommon/_Inventory_Vdp_LeadForms.cshtml 3.93 3.93 +138.67 3.38 (1)
View: Shared/_Website_Gemini.cshtml 5.71 31.01 +142.79 2.73 (1)
Component (Invoke): SeoTags 3.15 3.15 +147.05 2.41 (1)
View: Shared/Components/SeoTags/SeoTags.cshtml 0.01 0.01 +150.28
View: Shared/Partials/WindowVariable/WindowVariables.cshtml 13.19 14.87 +150.44 9.25 (4)
Redis Key: leadformglobalsettings.teamvstagingvolkswagen.com.leadformglobalsettings 0.63 0.63 +150.87
Redis Key: dealerCampaignProgramSettings.teamvstagingvolkswagen.com.295.dealerCampaignProgramSettings 0.75 0.75 +151.54
Redis Key: dealerCampaignMobileCtaSettings.teamvstagingvolkswagen.com.295.dealerCampaignMobileCtaSettings 0.30 0.30 +152.33
View: Shared/Partials/Scripts/_DA_HeaderMobileNumberChange_Script.cshtml 0.03 0.86 +165.43
Redis Key: DAScript.teamvstagingvolkswagen.com.DAScript 0.83 0.83 +165.44
View: Shared/Partials/Styles/_Gemini_Default_Color.cshtml 0.00 0.00 +166.37
View: Shared/Partials/Template/Application_Font_Sets.cshtml 0.00 0.00 +166.40
View: Shared/Partials/Scripts/Schema_Org.cshtml 0.00 0.00 +166.48
View: Shared/Partials/Scripts/Login_Redirection.cshtml 0.00 0.00 +166.50
View: Shared/Partials/Scripts/Spanish.cshtml 0.00 0.00 +166.51
View: Shared/Partials/Scripts/RoadsterAnalyticsScript.cshtml 0.00 0.00 +166.53
View: Shared/Partials/Scripts/HondaGMTCodeHeaderScript.cshtml 0.00 0.00 +166.55
View: Shared/_Event_Script.cshtml 0.00 0.00 +166.57
View: Shared/_ShiftDigital_DataLayer_Script.cshtml 0.00 0.00 +166.59
View: Shared/Partials/TrackingPixels/_TrackingPixel.cshtml 0.01 0.01 +166.62
View: Shared/Partials/Styles/_Library_Styles.cshtml 0.01 0.01 +166.65
View: Shared/Partials/Scripts/_Sonic_DataLayer.cshtml 0.00 0.00 +166.69
View: Shared/Partials/_Disaster_Vue_Component.cshtml 0.00 0.00 +166.76
View: Shared/Partials/Styles/GeminiAdminHeaderSelector.cshtml 0.60 2.91 +166.78
Component (Invoke): Header 0.01 0.01 +166.81
View: Shared/Components/Header/Website_Gemini_Header_Utility_WithNav_Desktop.cshtml 0.67 2.30 +167.37
Component (Invoke): Menu 0.24 1.50 +167.50
Redis Key: MenuCache.teamvstagingvolkswagen.com.MenuCache 1.26 1.26 +167.53
View: Shared/Components/Menu/Website_Gemini_header_Utility_Menu_Desktop.cshtml 0.13 0.13 +169.52
Component (Invoke): Footer 0.08 0.08 +169.76
View: Shared/Components/Footer/Website_Gemini_Footer_Desktop.cshtml 0.10 0.68 +169.88
Redis Key: dealerships.teamvstagingvolkswagen.com.44550.dealerships 0.58 0.58 +169.90
View: Shared/Partials/Styles/GeminiAdminFooterStyles.cshtml 0.00 0.00 +170.64
View: Shared/Partials/Scripts/_Ga4_Scripts.cshtml 0.01 0.01 +170.69
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Bottom_Scripts.cshtml 0.02 0.02 +170.82
View: Shared/Partials/Styles/AdminTemplateStyles/DefaultGeminiAdminTemplateStyles.cshtml 0.00 0.00 +170.87
View: Shared/Partials/Scripts/HondaGMTCodeBodyScript.cshtml 0.00 0.00 +170.89
View: Shared/Partials/Scripts/_AccessibilitySettingsScript.cshtml 2.69 2.69 +170.91 2.55 (1)
View: Shared/Partials/Scripts/_UpStartScript.cshtml 0.00 0.00 +173.75
View: Shared/Partials/Scripts/_AppLevelIntegrations.cshtml 0.00 0.00 +173.77
Result Filter (Execed): SaveTempDataFilter 0.00 0.00 +202.98
Resource Filter (Execed): SaveTempDataFilter 0.00 0.00 +203.00
sql: 36.23 %
client event duration (ms) from start (ms)
Fetch
+0
DNS Lookup
76 +3
Connect
2 +79
SSL/TLS Connect
11 +81
Request
278 +92
Response
3 +370
DOM Loading
6 +373
First Paint
+522
DOM Interactive
+646
DOM Content Loaded
2 +4969
Call Type
Step
Duration (from start)
Call Stack
Command
9.24 ms
https://teamvstagingvolkswagen.com/viewdetails/used/1ftbw9ck7pka41099/2023-ford-e-transit-cargo-van- — 7.04 ms
sql - OpenAsync
https://teamvstagingvolkswagen.com/viewdetails/used/1ftbw9ck7pka41099/2023-ford-e-transit-cargo-van-
0.60 ms (T+9.24 ms)
MoveNext > LogSessionEvent > Start > MoveNext > Execute > Start > MoveNext > LogSession > Start > MoveNext > Start > Start
Connection OpenAsync()
0.06 ms
https://teamvstagingvolkswagen.com/viewdetails/used/1ftbw9ck7pka41099/2023-ford-e-transit-cargo-van- — 0.06 ms
sql - Reader
https://teamvstagingvolkswagen.com/viewdetails/used/1ftbw9ck7pka41099/2023-ford-e-transit-cargo-van-
3.65 ms (T+9.90 ms)
First Result: 3.62 ms
MoveNext > LogSessionEvent > Start > MoveNext > Execute > Start > MoveNext > LogSession > Start > MoveNext > Start > Start
LogSession_Insert
sql - Close
https://teamvstagingvolkswagen.com/viewdetails/used/1ftbw9ck7pka41099/2023-ford-e-transit-cargo-van-
0.29 ms (T+13.55 ms)
RunOrScheduleAction > MoveNext > RunInternal > TrySetResult > RunContinuations > RunOrScheduleAction > MoveNext > RunInternal
Connection Close()
3.44 ms
https://teamvstagingvolkswagen.com/viewdetails/used/1ftbw9ck7pka41099/2023-ford-e-transit-cargo-van- — 3.13 ms
sql - OpenAsync
Action Filter (Exec): EventLoggerActionFilter
0.75 ms (T+17.28 ms)
MoveNext > LogPageView > Start > MoveNext > Execute > Start > MoveNext > LogPageViews > Start > MoveNext > Start > Start
Connection OpenAsync()
0.07 ms
Action Filter (Exec): EventLoggerActionFilter — 0.07 ms
sql - Reader
Action Filter (Exec): EventLoggerActionFilter
2.94 ms (T+18.10 ms)
First Result: 2.91 ms
MoveNext > LogPageView > Start > MoveNext > Execute > Start > MoveNext > LogPageViews > Start > MoveNext > Start > Start
LogPageViews_Insert
sql - Close
Action Filter (Exec): EventLoggerActionFilter
0.28 ms (T+21.04 ms)
RunOrScheduleAction > MoveNext > RunInternal > TrySetResult > RunContinuations > RunOrScheduleAction > MoveNext > RunInternal
Connection Close()
5.59 ms
Action Filter (Exec): EventLoggerActionFilter — 3.43 ms
sql - OpenAsync
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails
0.57 ms (T+26.91 ms)
Start > MoveNext > GetInventoryGroupSettings > Start > MoveNext > GetInventoryGroupSettings > Start > MoveNext > Start > Start
Connection OpenAsync()
0.09 ms
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails — 0.09 ms
sql - Reader
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails
1.70 ms (T+27.57 ms)
First Result: 1.65 ms
Start > MoveNext > GetInventoryGroupSettings > Start > MoveNext > GetInventoryGroupSettings > Start > MoveNext > Start > Start
select Type, ISNULL(GroupTPIds, '') AS GroupTPIds, ISNULL(GroupName, '') AS GroupName, EnableCallForPriceforSRP, EnableCallForPriceforVDP from Dealership_inventorygroupsettings where 
                                                            AccountId = 44550 AND (Type in (used, cpo))
sql - Close
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails
0.26 ms (T+29.28 ms)
RunOrScheduleAction > MoveNext > RunInternal > TrySetResult > RunContinuations > RunOrScheduleAction > MoveNext > RunInternal
Connection Close()
24.91 ms
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails — 22.59 ms
sql - OpenAsync
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails
0.65 ms (T+54.45 ms)
MoveNext > RunInternal > MoveNext > GetDealerShipInfo > Start > MoveNext > QueryMultipleAsync > Start > MoveNext > Start > Start
Connection OpenAsync()
0.12 ms
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails — 0.12 ms
sql - Reader
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails
1.97 ms (T+55.22 ms)
First Result: 1.91 ms
MoveNext > RunInternal > MoveNext > GetDealerShipInfo > Start > MoveNext > QueryMultipleAsync > Start > MoveNext > Start > Start
Select ShowLocationOnVehicleCards, ShowLocationOnVehicleCardsForUsed
                                                           from Dealerships where Accountid=44550

                                                            select ClientName, AddressCity, AddressState  from Dealerships where Accountid=59271
0.18 ms
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails — 0.18 ms
sql - OpenAsync
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails
0.58 ms (T+57.37 ms)
ImplementationAsync > ImplementationAsync > Start > MoveNext > <CheckVehicleIsSpecialOrNot>b__0 > Start > MoveNext > Start > Start
Connection OpenAsync()
0.08 ms
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails — 0.08 ms
sql - Reader
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails
5.54 ms (T+58.03 ms)
First Result: 4.79 ms
ImplementationAsync > ImplementationAsync > Start > MoveNext > <CheckVehicleIsSpecialOrNot>b__0 > Start > MoveNext > Start > Start
Usp_CheckVehicleIsSpecial
sql - Close
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails
0.29 ms (T+63.58 ms)
RunOrScheduleAction > MoveNext > RunInternal > TrySetResult > RunContinuations > RunOrScheduleAction > MoveNext > RunInternal
Connection Close()
0.87 ms
Controller Action: Velocity.PrimaryOffersites.Web.Controllers.Inventory.InventoryController.VehicleDetails — 0.36 ms
sql - OpenAsync
View: Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml
0.86 ms (T+64.74 ms)
<ImplementationAsync>b__0 > Start > MoveNext > <GetInventoryPaymentSettingsAsync>b__0 > Start > MoveNext > Start > Start
Connection OpenAsync()
0.14 ms
View: Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml — 0.14 ms
sql - Reader
View: Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml
2.81 ms (T+65.74 ms)
First Result: 2.74 ms
<ImplementationAsync>b__0 > Start > MoveNext > <GetInventoryPaymentSettingsAsync>b__0 > Start > MoveNext > Start > Start

                                        SELECT TOP 1 InventoryPaymentSettingsID AS InventoryPaymentSettingsId
                                                , AccountID AS AccountId
                                                , ActivateNEW AS ActivateNew
                                                , ActivateUSED AS ActivateUsed
                                                , PaymentTypeID AS PaymentTypeId
                                                , PriceTypeID AS PriceTypeId
                                                , UseLeaseCash
                                                , UseLeaseDealerCash
                                                , UseRebate
                                                , UseRebateDealerCash
                                                , SellingPriceLabel
                                                , UsedSellingPriceLabel
                                                , ImageTypeID AS ImageTypeId
                                                , CreatedDate
                                                , ModifiedDate
                                                , HideTotalSaving_YourPrice AS HideTotalSavingYourPrice
                                                , HideNoMsrpVehicles
                                                , ActiveBuyForPrice
                                                , BuyForPriceTypeID
                                                , ShowExpandedSavings
                                                , ShowFees_Used AS ShowFeesUsed
                                                , FeeLabel_Used AS FeeLabelUsed
                                                , FinalPriceLabel_Used AS FinalPriceLabelUsed
                                                , ShowFees_New AS ShowFeesNew
                                                , FeeLabel_New AS FeeLabelNew
                                                , FinalPriceLabel_New AS FinalPriceLabelNew
                                                , ShowExpandedSavings_Used AS ShowExpandedSavingsUsed
                                                , SellingPriceLabelForCash
                                                , UsedSellingPriceLabelForCash
                                                , UsedMsrpLabel
                                                , MiscPriceTypeID_New
                                                , HideNewFinalPrice
                                                , HideUsedFinalPrice
                                                , HideNewCashFinalPrice
                                                , HideUsedCashFinalPrice
                                                , HideNewDiscount
                                                , HideUsedDiscount
                                                , NewMsrpLabel
                                                , ListPriceLabel
                                                , ListPriceField
                                                , DiscountLabel
                                                , DiscountLabelUsed
                                                , RebateLabelUsed
                                                , ShowExpandedSavings_New_SRP
                                                , ShowExpandedSavings_Used_SRP
                                                , ShowDealerMarkup
                                                , DealerMarkupLabel
                                                , ShowDealerMarkupUsed
                                                , DealerMarkupLabelUsed
                                                , HideUsedSavingsAndPrice
                                                , HideUsedWithoutPrice
                                                , HideNewWithoutPrice
                                                , ListPriceLabelUsed
                                                , ListPriceFieldUsed
                                                , AlwaysShowMSRP
                                                , AlwaysShowMSRPUsed
                                                , RebateLabelNew
                                                , ShowConditionalRebates
                                                , ShowHighMSRP
                                                , ShowRebatesDetails
                                                , ShowPackageSavingsDetails
                                                , ShowPlusAndMinus
                                                , HideConditionalRebatesTotal
                                                , ConditionalRebatesBreakoutIncentives
                                                , ConditionalRebatesBreakoutIncentivesForVDP
                                                , ListPriceFieldPositionNew
                                                , ListPriceFieldPositionUsed
                                                , AddRebateToBuyFor
                                                , HideNewMSRP
                                                , ShowLeaseFinalPriceSRP
                                                , ShowLeaseFinalPriceVDP
                                                , ShowDealerDiscountPrice
                                                , ShowExpandedFeesNewSRP
                                                , ShowExpandedFeesNewVDP
                                                , ShowExpandedFeesUsedSRP
                                                , ShowExpandedFeesUsedVDP
                                                , HideNewSavingsAndPriceSRP
                                                , ShowRebatesBreakoutSRP
                                                , ShowRebatesBreakoutVDP
                                                , UnBoldFinalPrice
                                                , DealerDiscountedPriceLabel
                                                , FinancePriceTypeID
                                                , ShowExpandedSavingsLeaseVDP
                                                , ShowMSRPOnLeaseSRP
                                                , ShowMSRPOnLeaseVDP
                                                , ShowFinalConditionalPriceSRP
                                                , ShowFinalConditionalPriceVDP
                                                , FinalConditionalPrice
                                                , ShowFinancePriceStack
                                                , ShowTaxesNew
                                                , ShowTaxesUsed
                                                , DemoLoanerDiscountLabel
                                                , BuyForPriceTypeID_used
                                                , ShowDealerDiscountPrice_Used
                                                , DealerDiscountedPriceLabel_Used
                                                , TotalSavingsNew
                                                , TotalSavingsUsed
                                                , LeaseFinalPriceLabel
                                                , ShowMinusOnConditionalOffers
                                                , ShowPriceAfterRebates
                                                , ConditionalOffersHeaderLabel
                                                , DisplayIncentiveDetailsInsteadOfQuestionMarkIcon
                                                , ConditionalsDisplayDetailsInsteadOfQuestionMarkIcon
                                                , TransactFinalPriceLabel_Used
                                                , ShowAlternatePriceForVDP
                                                , ShowAlternatePriceForSRP
                                                , AlternatePriceTypeId
                                                , ShowAZXPricePlanLablesOnSRP
                                                , ShowAZXPricePlanLablesOnVDP
                                            FROM ADV_DealershipInventoryPaymentSettings
                                            WHERE AccountID = 59271
sql - Close
View: Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml
0.27 ms (T+68.55 ms)
RunOrScheduleAction > MoveNext > RunInternal > TrySetResult > RunContinuations > RunOrScheduleAction > MoveNext > RunInternal
Connection Close()
0.16 ms
View: Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml — 0.16 ms
sql - OpenAsync
View: Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml
0.49 ms (T+68.98 ms)
MoveNext > RunInternal > MoveNext > GetPagSeoTags > Start > MoveNext > GetOffersiteSeoByPageId > Start > MoveNext > Start > Start
Connection OpenAsync()
0.11 ms
View: Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml — 0.11 ms
sql - Reader
View: Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml
2.10 ms (T+69.58 ms)
First Result: 2.03 ms
MoveNext > RunInternal > MoveNext > GetPagSeoTags > Start > MoveNext > GetOffersiteSeoByPageId > Start > MoveNext > Start > Start
select      ID
                                                                    , CampaignID
                                                                    , PageId
                                                                    , Description
                                                                    , Keywords
                                                                    , RobotParameters
                                                                    , CanonicalUrl
                                                                    , OgLocale
                                                                    , OgSiteName
                                                                    , OgTitle
                                                                    , OgDescription
                                                                    , PageTitle
                                                                    , SEOText
                                                                    , CorePageH1TagText
                                                                    , UsedSEOText
                                                                    , CPOSEOText
                                                                    , UsedCorePageH1TagText
                                                                    , CpoCorePageH1TagText
                                                                    , UsedPageTitle
                                                                    , CpoPageTitle
                                                                    , UsedOgSiteName
                                                                    , CpoOgSiteName
                                                                    , UsedOgTitle
                                                                    , CpoOgTitle
                                                                    , UsedOgDescription
                                                                    , CpoOgDescription
                                                                    , UsedDescription
                                                                    , CpoDescription
                                                                    , UsedKeywords
                                                                    , CpoKeywords
                                                                    , UsedOgLocale
                                                                    , CpoOgLocale
                                                                    , UsedRobotParameters
                                                                    , CpoRobotParameters
                                                                    , UsedCanonicalUrl
                                                                    , CpoCanonicalUrl
                                                                    , AddNewSeoTextToTop
                                                                    , AddUsedSeoTextToTop
                                                                    , AddCpoSeoTextToTop
                                                                    , NewSEOCustomStructuredData
                                                                    , UsedSEOCustomStructuredData
                                                                    , CpoSEOCustomStructuredData
                                                                    , HidePageH1Tag
                                                                    , PageURL
                                                                    , RootURL
                                                                    , [BottomSeoText]
                                                                    , [BottomUsedSeoText]
                                                                    , [BottomCpoSeoText]
                                                                    , [HideSrpFilters]
                                                                    , BreadcrumbText
                                                                    from OffersiteSeo where
                                                                    (67778 <> 0 and PageId = 67778) or 
																	(PageId = 0 and CampaignID = 295)
sql - Close
View: Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml
0.23 ms (T+71.68 ms)
RunOrScheduleAction > MoveNext > RunInternal > TrySetResult > RunContinuations > RunOrScheduleAction > MoveNext > RunInternal
Connection Close()
1.59 ms
Redis Key: dealerCampaignSRPSettings.teamvstagingvolkswagen.com.295.dealerCampaignSRPSettings — 0.93 ms
sql - OpenAsync
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml
0.53 ms (T+73.50 ms)
OpenAsync > Start > MoveNext > OpenInternalAsync > Start > MoveNext > ConnectionOpeningAsync > DispatchEventData > Write
Connection OpenAsync()
0.10 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml — 0.10 ms
sql - ExecuteReader (Async)
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml
1.53 ms (T+74.13 ms)
InitializeReaderAsync > Start > MoveNext > ExecuteReaderAsync > Start > MoveNext > CommandReaderExecutingAsync > DispatchEventData > Write
SELECT TOP(1) [o].[Id], [o].[ButtonImgUrl], [o].[CampaignId], [o].[ColorPrimary], [o].[ColorSecondary], [o].[EnableOfferLogixBuyerCall], [o].[InfoSectionBackground], [o].[OpenHours], [o].[Phonenumber], [o].[Source], [o].[SubTitle], [o].[Title]
FROM [OfferLogixBuyerCallSettings] AS [o]
WHERE [o].[CampaignId] = 295
0.12 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml — 0.12 ms
sql - CloseAsync
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml
0.40 ms (T+75.78 ms)
DisposeAsync > DisposeAsync > Start > MoveNext > CloseAsync > Start > MoveNext > ConnectionClosingAsync > DispatchEventData > Write
Connection CloseAsync()
0.32 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml — 0.32 ms
sql - OpenAsync
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml
0.46 ms (T+76.50 ms)
OpenAsync > Start > MoveNext > OpenInternalAsync > Start > MoveNext > ConnectionOpeningAsync > DispatchEventData > Write
Connection OpenAsync()
0.10 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml — 0.10 ms
sql - ExecuteReader (Async)
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml
1.51 ms (T+77.06 ms)
InitializeReaderAsync > Start > MoveNext > ExecuteReaderAsync > Start > MoveNext > CommandReaderExecutingAsync > DispatchEventData > Write
SELECT TOP(1) [d].[Id], [d].[ActivEngageButtounLabelDesktop], [d].[ActivEngageButtounLabelMobile], [d].[ApiKey], [d].[CTXIdNew], [d].[CTXIdUsed], [d].[CampaignId], [d].[ClientId], [d].[DiscountUsedDetails], [d].[EnableDiscountUsedDetails], [d].[EnableFinalPriceUsedDetails], [d].[EnableListPriceUsedDetails], [d].[EnableTagRailIntegration], [d].[EnableTextium], [d].[FinalPriceUsedDetails], [d].[IPacketAPIKey], [d].[ListPriceUsedDetails], [d].[OpenIPacketUsingModalPopupVersion], [d].[ShowMileageNewVehicles], [d].[SourceId], [d].[TagRailDealerId], [d].[TagRailPurchaseOnlineLabel], [d].[TagRailValueYourTradeLabel], [d].[TransactButtonBorderColor], [d].[TransactCPOButtonColor], [d].[TransactCPOFontColor], [d].[TransactCpoButtonBorderColor], [d].[TransactUsedButtonBorderColor], [d].[TransactUsedButtonColor], [d].[TransactUsedFontColor], [d].[WhispTextPidNew], [d].[WhispTextPidUsed], [d].[WhispTextPidVdpNew], [d].[WhispTextPidVdpUsed], [d].[WhispTextSrp], [d].[WhispTextSrpButtonLabel], [d].[WhispTextVdp], [d].[WhispTextVdpButtonLabel]
FROM [DealerCampaignSrpVdpSettings] AS [d]
WHERE [d].[CampaignId] = 295
0.14 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml — 0.14 ms
sql - CloseAsync
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml
0.31 ms (T+78.71 ms)
DisposeAsync > DisposeAsync > Start > MoveNext > CloseAsync > Start > MoveNext > ConnectionClosingAsync > DispatchEventData > Write
Connection CloseAsync()
1.15 ms
Redis Key: DigitalRetailerSettings.teamvstagingvolkswagen.com_44550.DigitalRetailerSettings — 0.80 ms
sql - OpenAsync
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml
0.46 ms (T+80.17 ms)
OpenAsync > Start > MoveNext > OpenInternalAsync > Start > MoveNext > ConnectionOpeningAsync > DispatchEventData > Write
Connection OpenAsync()
0.14 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml — 0.14 ms
sql - ExecuteReader (Async)
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml
1.52 ms (T+80.77 ms)
InitializeReaderAsync > Start > MoveNext > ExecuteReaderAsync > Start > MoveNext > CommandReaderExecutingAsync > DispatchEventData > Write
SELECT TOP(1) [s].[Id], [s].[AddressErrorMessage], [s].[AutoToggleVehicleAppraisal], [s].[BookingInterval], [s].[BotdocCompanyId], [s].[BotdocDealerHandler], [s].[BotdocTriggerId], [s].[ButtonLabel], [s].[CampaignId], [s].[CustomText], [s].[DeliveryHours], [s].[DeliveryMiles], [s].[DisclaimerMessage], [s].[EnableBotdoc], [s].[EnablePickupAndDelivery], [s].[EnableTestDriveSignInReminder], [s].[FirstRadioButtonLabel], [s].[IsActive], [s].[MaximumbookingsPerFifteenMin], [s].[SecondRadioButtonLabel], [s].[ThirdRadioButtonLabel]
FROM [ScheduleTestDriveSettings] AS [s]
WHERE [s].[CampaignId] = 295
0.16 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml — 0.16 ms
sql - CloseAsync
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml
0.33 ms (T+82.45 ms)
DisposeAsync > DisposeAsync > Start > MoveNext > CloseAsync > Start > MoveNext > ConnectionClosingAsync > DispatchEventData > Write
Connection CloseAsync()
0.31 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml — 0.31 ms
sql - OpenAsync
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml
0.46 ms (T+83.09 ms)
OpenAsync > Start > MoveNext > OpenInternalAsync > Start > MoveNext > ConnectionOpeningAsync > DispatchEventData > Write
Connection OpenAsync()
0.09 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml — 0.09 ms
sql - ExecuteReader (Async)
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml
1.43 ms (T+83.64 ms)
InitializeReaderAsync > Start > MoveNext > ExecuteReaderAsync > Start > MoveNext > CommandReaderExecutingAsync > DispatchEventData > Write
SELECT TOP(1) [d].[Id], [d].[Badge6ClickThoroughURL], [d].[Badge6HoverText], [d].[Badge6Logo], [d].[Badge6PageTypes], [d].[Badge6VehicleTypes], [d].[CampaignId], [d].[CreatedDate], [d].[CustomDealerCertifiedLogo], [d].[CustomDealerCertifiedLogoTextMatch], [d].[CustomDealerHoverText], [d].[CustomThoroughURL], [d].[EnableBadge6Hover], [d].[EnableCustomDealerCertifiedLogo], [d].[EnableCustomDealerHover], [d].[EnableHoverOnCustomBadges], [d].[EnableInTransitHover], [d].[EnableInTransitLogo], [d].[EnableMiscHover], [d].[EnableMiscLogo], [d].[EnableSpecialField4Badge], [d].[EnableSpecialField5Badge], [d].[EnableSpecialFieldBadge4Hover], [d].[EnableSpecialFieldBadge5Hover], [d].[HoverContentOnCustomBadges], [d].[InTransitHoverText], [d].[InTransitLogo], [d].[InTransitTextMatch], [d].[InTransitVehicleTypes], [d].[MiscHoverText], [d].[MiscLogo], [d].[MiscLogoTextMatch], [d].[MiscThoroughURL], [d].[ModifiedDate], [d].[SpecialField4BadgeLogo], [d].[SpecialField4BadgeMatch], [d].[SpecialField4BadgePageTypes], [d].[SpecialField4BadgeUrl], [d].[SpecialField4BadgeVehicleTypes], [d].[SpecialField5BadgeLogo], [d].[SpecialField5BadgeMatch], [d].[SpecialField5BadgeUrl], [d].[SpecialFieldBadge4HoverText], [d].[SpecialFieldBadge5HoverText], [d].[TransitThoroughURL]
FROM [DealerCustomBadges] AS [d]
WHERE [d].[CampaignId] = 295
0.05 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml — 0.05 ms
sql - CloseAsync
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Header_Scripts.cshtml
0.33 ms (T+85.12 ms)
DisposeAsync > DisposeAsync > Start > MoveNext > CloseAsync > Start > MoveNext > ConnectionClosingAsync > DispatchEventData > Write
Connection CloseAsync()
3.07 ms
Redis Key: WebValuationProvider.teamvstagingvolkswagen.com.WebValuationProvider — 0.92 ms
sql - OpenAsync
View: Shared/Partials/TrackingPixels/_TrackingPixel.cshtml
0.56 ms (T+88.52 ms)
MoveNext > GetTrackingPixels > Start > MoveNext > Start > MoveNext > GetTrackingPixelsAsync > Start > MoveNext > Start > Start
Connection OpenAsync()
0.11 ms
View: Shared/Partials/TrackingPixels/_TrackingPixel.cshtml — 0.11 ms
sql - Reader
View: Shared/Partials/TrackingPixels/_TrackingPixel.cshtml
1.59 ms (T+89.19 ms)
First Result: 1.53 ms
MoveNext > GetTrackingPixels > Start > MoveNext > Start > MoveNext > GetTrackingPixelsAsync > Start > MoveNext > Start > Start
SELECT * FROM [TrackingPixels] TP WHERE TP.CampaignID = 295 AND TP.Location IN ('AllVDPs', 'Pre-OwnedVdps') AND TrackingDISABLE = 0;
sql - Close
View: Shared/Partials/TrackingPixels/_TrackingPixel.cshtml
0.24 ms (T+90.78 ms)
RunOrScheduleAction > MoveNext > RunInternal > TrySetResult > RunContinuations > RunOrScheduleAction > MoveNext > RunInternal
Connection Close()
1.57 ms
Redis Key: dealerCampaignSeoEnabled.teamvstagingvolkswagen.com.dealerCampaignSeoEnabled — 0.65 ms
sql - OpenAsync
View: Shared/Partials/Scripts/InventoryDetailsJsonLD.cshtml
0.51 ms (T+92.59 ms)
OpenAsync > Start > MoveNext > OpenInternalAsync > Start > MoveNext > ConnectionOpeningAsync > DispatchEventData > Write
Connection OpenAsync()
0.08 ms
View: Shared/Partials/Scripts/InventoryDetailsJsonLD.cshtml — 0.08 ms
sql - ExecuteReader (Async)
View: Shared/Partials/Scripts/InventoryDetailsJsonLD.cshtml
1.43 ms (T+93.18 ms)
InitializeReaderAsync > Start > MoveNext > ExecuteReaderAsync > Start > MoveNext > CommandReaderExecutingAsync > DispatchEventData > Write
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [CampaignSeoSettings] AS [c]
        WHERE [c].[CampaignId] = 295 AND [c].[IsActive] = CAST(1 AS bit) AND [c].[IsRobotsEnabled] = CAST(1 AS bit)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
0.06 ms
View: Shared/Partials/Scripts/InventoryDetailsJsonLD.cshtml — 0.06 ms
sql - CloseAsync
View: Shared/Partials/Scripts/InventoryDetailsJsonLD.cshtml
0.38 ms (T+94.67 ms)
DisposeAsync > DisposeAsync > Start > MoveNext > CloseAsync > Start > MoveNext > ConnectionClosingAsync > DispatchEventData > Write
Connection CloseAsync()
1.02 ms
View: Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml — 0.46 ms
sql - OpenAsync
Component (Invoke): StickyPriceBar
0.75 ms (T+96.07 ms)
OpenAsync > Start > MoveNext > OpenInternalAsync > Start > MoveNext > ConnectionOpeningAsync > DispatchEventData > Write
Connection OpenAsync()
0.13 ms
Component (Invoke): StickyPriceBar — 0.13 ms
sql - ExecuteReader (Async)
Component (Invoke): StickyPriceBar
1.64 ms (T+96.95 ms)
InitializeReaderAsync > Start > MoveNext > ExecuteReaderAsync > Start > MoveNext > CommandReaderExecutingAsync > DispatchEventData > Write
SELECT TOP(1) [l].[LeadTypeID], [l].[AccountID], [l].[AlwaysActive], [l].[ButtonColor], [l].[ButtonName], [l].[ButtonTextColor], [l].[City], [l].[Comments], [l].[ConsumerEventID], [l].[Description], [l].[DisclaimerText], [l].[EmailAddress], [l].[FirstName], [l].[FormDescription], [l].[FriendlyName], [l].[Heading], [l].[IsCustomLead], [l].[IsVehicleLead], [l].[LastName], [l].[Make], [l].[Model], [l].[Name], [l].[RightColumn], [l].[ShowVehicleDetails], [l].[Street], [l].[SubHeading], [l].[Telephone], [l].[Trim], [l].[VehicleInformation], [l].[Year], [l].[Zip]
FROM [LeadType] AS [l]
WHERE [l].[LeadTypeID] = 0
0.05 ms
Component (Invoke): StickyPriceBar — 0.05 ms
sql - CloseAsync
Component (Invoke): StickyPriceBar
0.35 ms (T+98.64 ms)
DisposeAsync > DisposeAsync > Start > MoveNext > CloseAsync > Start > MoveNext > ConnectionClosingAsync > DispatchEventData > Write
Connection CloseAsync()
0.73 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Button.cshtml — 0.31 ms
sql - Open
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Button.cshtml
0.59 ms (T+99.72 ms)
MoveNext > Execute > InitializeReader > ExecuteReader > Open > OpenInternal > ConnectionOpening > DispatchEventData > Write
Connection Open()
0.16 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Button.cshtml — 0.16 ms
sql - ExecuteReader
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Button.cshtml
1.83 ms (T+100.47 ms)
GetVDPCTASettings > ToList > MoveNext > Execute > InitializeReader > ExecuteReader > CommandReaderExecuting > DispatchEventData > Write
SELECT [v].[Id], [v].[CTABorderColor], [v].[CTAButtonActualName], [v].[CTAButtonColor], [v].[CTAButtonName], [v].[CTAButtonType], [v].[CTACustomLeadForms], [v].[CTAFontColor], [v].[CampaignId], [v].[CreatedDate], [v].[CustomUrl], [v].[HideInMobile], [v].[IsCTAButtonEnabled], [v].[ModifiedDate], [v].[ShowInDesktop], [v].[ShowInMobile], [v].[TabType], [v].[Type]
FROM [VDPCTASettings] AS [v]
WHERE ([v].[CampaignId] = 295 OR ([v].[CampaignId] = 0 AND [v].[IsCTAButtonEnabled] = CAST(1 AS bit))) AND LOWER([v].[Type]) = 'used'
0.21 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Button.cshtml — 0.21 ms
sql - Close
View: Shared/Partials/VdpCommon/_Inventory_Vdp_Button.cshtml
0.53 ms (T+102.51 ms)
Start > MoveNext > GetVDPCTASettings > ToList > Dispose > Dispose > Close > ConnectionClosing > DispatchEventData > Write
Connection Close()
0.54 ms
View: Shared/Components/OEMVehicleDetails/OEMVehicleDetails.cshtml — 0.29 ms
sql - OpenAsync
View: Shared/Components/OEMVehicleDetails/OEMVehicleDetails.cshtml
0.62 ms (T+103.58 ms)
OpenAsync > Start > MoveNext > OpenInternalAsync > Start > MoveNext > ConnectionOpeningAsync > DispatchEventData > Write
Connection OpenAsync()
0.12 ms
View: Shared/Components/OEMVehicleDetails/OEMVehicleDetails.cshtml — 0.12 ms
sql - ExecuteReader (Async)
View: Shared/Components/OEMVehicleDetails/OEMVehicleDetails.cshtml
1.63 ms (T+104.32 ms)
InitializeReaderAsync > Start > MoveNext > ExecuteReaderAsync > Start > MoveNext > CommandReaderExecutingAsync > DispatchEventData > Write
SELECT TOP(1) [i].[Id], [i].[AccountId], [i].[CreatedDate], [i].[InventoryField], [i].[InventoryField2], [i].[Logo], [i].[LogoUrl], [i].[LogoUrlTab], [i].[Make], [i].[ModifiedDate], [i].[ValueFrom], [i].[ValueTo]
FROM [InventoryUsedLogoSettings] AS [i]
WHERE [i].[AccountId] = 44550
0.13 ms
View: Shared/Components/OEMVehicleDetails/OEMVehicleDetails.cshtml — 0.13 ms
sql - CloseAsync
View: Shared/Components/OEMVehicleDetails/OEMVehicleDetails.cshtml
0.31 ms (T+106.08 ms)
DisposeAsync > DisposeAsync > Start > MoveNext > CloseAsync > Start > MoveNext > ConnectionClosingAsync > DispatchEventData > Write
Connection CloseAsync()
0.62 ms
Component (Invoke): OEMInventorySpecifications — 0.33 ms
sql - OpenAsync
Component (Invoke): OEMInventorySpecifications
0.57 ms (T+107.01 ms)
GetVehicleDetailsOverView > Start > MoveNext > GetModelHighlights > Start > MoveNext > GetModelHighlightsAsync > Start > MoveNext > Start > Start
Connection OpenAsync()
0.09 ms
Component (Invoke): OEMInventorySpecifications — 0.09 ms
sql - Reader
Component (Invoke): OEMInventorySpecifications
2.27 ms (T+107.67 ms)
First Result: 2.24 ms
GetVehicleDetailsOverView > Start > MoveNext > GetModelHighlights > Start > MoveNext > GetModelHighlightsAsync > Start > MoveNext > Start > Start
SELECT TOP 1
                                                [Model Overview]
                                                FROM [ChromeReviews]
                                                WHERE [Model Year] = 2023
                                                AND [Division Name] LIKE Ford
                                                AND [Model Name] LIKE E-Transit Cargo Van
sql - Close
Component (Invoke): OEMInventorySpecifications
0.22 ms (T+109.95 ms)
RunOrScheduleAction > MoveNext > RunInternal > TrySetResult > RunContinuations > RunOrScheduleAction > MoveNext > RunInternal
Connection Close()
0.54 ms
View: Shared/Components/OEMInventorySpecifications/OEMInventorySpecifications.cshtml — 0.39 ms
sql - OpenAsync
View: Shared/Components/OEMInventorySpecifications/OEMInventorySpecifications.cshtml
0.66 ms (T+110.71 ms)
OpenAsync > Start > MoveNext > OpenInternalAsync > Start > MoveNext > ConnectionOpeningAsync > DispatchEventData > Write
Connection OpenAsync()
0.15 ms
View: Shared/Components/OEMInventorySpecifications/OEMInventorySpecifications.cshtml — 0.15 ms
sql - ExecuteReader (Async)
View: Shared/Components/OEMInventorySpecifications/OEMInventorySpecifications.cshtml
2.02 ms (T+111.52 ms)
InitializeReaderAsync > Start > MoveNext > ExecuteReaderAsync > Start > MoveNext > CommandReaderExecutingAsync > DispatchEventData > Write
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [ResearchModel] AS [r]
        WHERE [r].[Year] = 2023 AND LOWER([r].[Make]) = 'ford' AND LOWER([r].[Model]) = 'e-transit cargo van') THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
0.06 ms
View: Shared/Components/OEMInventorySpecifications/OEMInventorySpecifications.cshtml — 0.06 ms
sql - CloseAsync
View: Shared/Components/OEMInventorySpecifications/OEMInventorySpecifications.cshtml
0.34 ms (T+113.60 ms)
DisposeAsync > DisposeAsync > Start > MoveNext > CloseAsync > Start > MoveNext > ConnectionClosingAsync > DispatchEventData > Write
Connection CloseAsync()
25.01 ms
View: Shared/Components/OEMInventorySpecifications/OEMInventorySpecifications.cshtml — 24.48 ms
sql - OpenAsync
View: Shared/Partials/VdpCommon/_Inventory_Vdp_LeadForms.cshtml
0.86 ms (T+138.95 ms)
OpenAsync > Start > MoveNext > OpenInternalAsync > Start > MoveNext > ConnectionOpeningAsync > DispatchEventData > Write
Connection OpenAsync()
0.19 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_LeadForms.cshtml — 0.19 ms
sql - ExecuteReader (Async)
View: Shared/Partials/VdpCommon/_Inventory_Vdp_LeadForms.cshtml
2.10 ms (T+140.00 ms)
InitializeReaderAsync > Start > MoveNext > ExecuteReaderAsync > Start > MoveNext > CommandReaderExecutingAsync > DispatchEventData > Write
SELECT TOP(1) [p].[Id], [p].[CampaignId], [p].[EnablePopupVideo], [p].[PopupTypeId], [p].[VideoCTALink], [p].[VideoCTAName], [p].[VideoURL]
FROM [PopupVideo] AS [p]
WHERE [p].[CampaignId] = 295 AND [p].[PopupTypeId] = 4
0.06 ms
View: Shared/Partials/VdpCommon/_Inventory_Vdp_LeadForms.cshtml — 0.06 ms
sql - CloseAsync
View: Shared/Partials/VdpCommon/_Inventory_Vdp_LeadForms.cshtml
0.42 ms (T+142.16 ms)
DisposeAsync > DisposeAsync > Start > MoveNext > CloseAsync > Start > MoveNext > ConnectionClosingAsync > DispatchEventData > Write
Connection CloseAsync()
0.25 ms
View: Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml — 0.10 ms
sql - OpenAsync
View: Shared/_Website_Gemini.cshtml
0.62 ms (T+142.83 ms)
GetHeadAndBodyPixelsWithCondition > Start > MoveNext > GetCampaignPixelsAsync > Start > MoveNext > GetTrackingPixels > Start > MoveNext > Start > Start
Connection OpenAsync()
0.07 ms
View: Shared/_Website_Gemini.cshtml — 0.07 ms
sql - Reader
View: Shared/_Website_Gemini.cshtml
1.91 ms (T+143.52 ms)
First Result: 1.73 ms
GetHeadAndBodyPixelsWithCondition > Start > MoveNext > GetCampaignPixelsAsync > Start > MoveNext > GetTrackingPixels > Start > MoveNext > Start > Start
SELECT * FROM TrackingPixels WHERE CampaignId = 295 AND TrackingDISABLE = 0;
sql - Close
View: Shared/_Website_Gemini.cshtml
0.20 ms (T+145.45 ms)
RunOrScheduleAction > MoveNext > RunInternal > TrySetResult > RunContinuations > RunOrScheduleAction > MoveNext > RunInternal
Connection Close()
1.67 ms
View: Shared/_Website_Gemini.cshtml — 1.40 ms
sql - OpenAsync
Component (Invoke): SeoTags
0.60 ms (T+147.32 ms)
OpenAsync > Start > MoveNext > OpenInternalAsync > Start > MoveNext > ConnectionOpeningAsync > DispatchEventData > Write
Connection OpenAsync()
0.13 ms
Component (Invoke): SeoTags — 0.13 ms
sql - ExecuteReader (Async)
Component (Invoke): SeoTags
1.46 ms (T+148.05 ms)
InitializeReaderAsync > Start > MoveNext > ExecuteReaderAsync > Start > MoveNext > CommandReaderExecutingAsync > DispatchEventData > Write
SELECT TOP(1) [t].[Id], [t].[IsActive], [t].[ThemeName]
FROM [ThemeSEOSettings] AS [t]
WHERE [t].[ThemeName] = 'Volkswagen'
0.12 ms
Component (Invoke): SeoTags — 0.12 ms
sql - CloseAsync
Component (Invoke): SeoTags
0.35 ms (T+149.63 ms)
DisposeAsync > DisposeAsync > Start > MoveNext > CloseAsync > Start > MoveNext > ConnectionClosingAsync > DispatchEventData > Write
Connection CloseAsync()
3.24 ms
View: Shared/Partials/WindowVariable/WindowVariables.cshtml — 1.10 ms
sql - OpenAsync
View: Shared/Partials/WindowVariable/WindowVariables.cshtml
0.60 ms (T+153.22 ms)
OpenAsync > Start > MoveNext > OpenInternalAsync > Start > MoveNext > ConnectionOpeningAsync > DispatchEventData > Write
Connection OpenAsync()
0.08 ms
View: Shared/Partials/WindowVariable/WindowVariables.cshtml — 0.08 ms
sql - ExecuteReader (Async)
View: Shared/Partials/WindowVariable/WindowVariables.cshtml
1.62 ms (T+153.90 ms)
InitializeReaderAsync > Start > MoveNext > ExecuteReaderAsync > Start > MoveNext > CommandReaderExecutingAsync > DispatchEventData > Write
SELECT TOP(1) [e].[Id], [e].[CampaignId], [e].[CreatedDate], [e].[FeaturedSpecial], [e].[ModifiedDate], [e].[SRPMouseOver], [e].[SpecialRotator]
FROM [EnhancedMediaAssetSettings] AS [e]
WHERE [e].[CampaignId] = 295
0.06 ms
View: Shared/Partials/WindowVariable/WindowVariables.cshtml — 0.06 ms
sql - CloseAsync
View: Shared/Partials/WindowVariable/WindowVariables.cshtml
0.41 ms (T+155.58 ms)
DisposeAsync > DisposeAsync > Start > MoveNext > CloseAsync > Start > MoveNext > ConnectionClosingAsync > DispatchEventData > Write
Connection CloseAsync()
0.53 ms
View: Shared/Partials/WindowVariable/WindowVariables.cshtml — 0.53 ms
sql - OpenAsync
View: Shared/Partials/WindowVariable/WindowVariables.cshtml
0.53 ms (T+156.52 ms)
OpenAsync > Start > MoveNext > OpenInternalAsync > Start > MoveNext > ConnectionOpeningAsync > DispatchEventData > Write
Connection OpenAsync()
0.08 ms
View: Shared/Partials/WindowVariable/WindowVariables.cshtml — 0.08 ms
sql - ExecuteReader (Async)
View: Shared/Partials/WindowVariable/WindowVariables.cshtml
1.56 ms (T+157.13 ms)
InitializeReaderAsync > Start > MoveNext > ExecuteReaderAsync > Start > MoveNext > CommandReaderExecutingAsync > DispatchEventData > Write
SELECT TOP(1) [i].[CampaignId], [i].[DealerID], [i].[Description], COALESCE([i].[DisclaimerText], N'') + N' - Expires: ', [i].[ToDate], [i].[LeadTypeID], [i].[OfferID], [i].[ImageID], [i].[IsSales], [i].[ShowAtEntry], [i].[Heading]
FROM [IncentiveOffers] AS [i]
INNER JOIN [DealerCampaign] AS [d] ON [i].[CampaignId] = [d].[CampaignID]
WHERE [i].[CampaignId] = 295 AND (([i].[ToDate] >= GETDATE() AND [i].[FromDate] <= GETDATE()) OR [i].[AutoRenew] = CAST(1 AS bit)) AND ([i].[DealerID] = [d].[AccountID] OR ([i].[DealerID] IS NULL AND [d].[AccountID] IS NULL))
ORDER BY [i].[FromDate]
0.08 ms
View: Shared/Partials/WindowVariable/WindowVariables.cshtml — 0.08 ms
sql - CloseAsync
View: Shared/Partials/WindowVariable/WindowVariables.cshtml
0.36 ms (T+158.77 ms)
DisposeAsync > DisposeAsync > Start > MoveNext > CloseAsync > Start > MoveNext > ConnectionClosingAsync > DispatchEventData > Write
Connection CloseAsync()
0.04 ms
View: Shared/Partials/WindowVariable/WindowVariables.cshtml — 0.04 ms
sql - OpenAsync
View: Shared/Partials/WindowVariable/WindowVariables.cshtml
0.34 ms (T+159.17 ms)
RunInternal > MoveNext > GetDigitalScriptConfig > Start > MoveNext > QueryMultipleAsync > Start > MoveNext > Start > Start
Connection OpenAsync()
0.07 ms
View: Shared/Partials/WindowVariable/WindowVariables.cshtml — 0.07 ms
sql - Reader
View: Shared/Partials/WindowVariable/WindowVariables.cshtml
1.47 ms (T+159.58 ms)
First Result: 1.39 ms
RunInternal > MoveNext > GetDigitalScriptConfig > Start > MoveNext > QueryMultipleAsync > Start > MoveNext > Start > Start

                            SELECT 
                            TOP 1 
                            Id,                     
                            AdwordsConversionId,
                            SalesConversionLabel,
                            ServiceConversionLabel,
                            FacebookPixelId,
                            ConversionAPIKey,
                            EnableEvoxDriveIn 
                            FROM 
                            dbo.Dealer_Digital WHERE DealerId = 44550


                            SELECT 
                            TagType,
                            Template
                            FROM dbo.DigitalTagTemplates
1.01 ms
View: Shared/Partials/WindowVariable/WindowVariables.cshtml — 1.01 ms
sql - OpenAsync
View: Shared/Partials/WindowVariable/WindowVariables.cshtml
0.56 ms (T+162.06 ms)
OpenAsync > Start > MoveNext > OpenInternalAsync > Start > MoveNext > ConnectionOpeningAsync > DispatchEventData > Write
Connection OpenAsync()
0.09 ms
View: Shared/Partials/WindowVariable/WindowVariables.cshtml — 0.09 ms
sql - ExecuteReader (Async)
View: Shared/Partials/WindowVariable/WindowVariables.cshtml
1.40 ms (T+162.71 ms)
InitializeReaderAsync > Start > MoveNext > ExecuteReaderAsync > Start > MoveNext > CommandReaderExecutingAsync > DispatchEventData > Write
SELECT TOP(1) [d].[AccountID], [d].[CampaignID], [d].[DigitalAnalyticsKey], [d].[WebsiteAnalyticsKey]
FROM [Dealer_GA_MeasurementKeys] AS [d]
WHERE [d].[CampaignID] = 295
0.06 ms
View: Shared/Partials/WindowVariable/WindowVariables.cshtml — 0.06 ms
sql - CloseAsync
View: Shared/Partials/WindowVariable/WindowVariables.cshtml
0.40 ms (T+164.17 ms)
DisposeAsync > DisposeAsync > Start > MoveNext > CloseAsync > Start > MoveNext > ConnectionClosingAsync > DispatchEventData > Write
Connection CloseAsync()
6.39 ms
Redis Key: MenuCache.teamvstagingvolkswagen.com.MenuCache — 1.26 ms
sql - OpenAsync
View: Shared/Partials/Scripts/_AccessibilitySettingsScript.cshtml
0.71 ms (T+170.96 ms)
MoveNext > ExecuteAsync > Start > MoveNext > GetAsync > Start > MoveNext > GetByCampaignIdAsync > Start > MoveNext > Start > Start
Connection OpenAsync()
0.06 ms
View: Shared/Partials/Scripts/_AccessibilitySettingsScript.cshtml — 0.06 ms
sql - Reader
View: Shared/Partials/Scripts/_AccessibilitySettingsScript.cshtml
1.59 ms (T+171.73 ms)
First Result: 1.56 ms
MoveNext > ExecuteAsync > Start > MoveNext > GetAsync > Start > MoveNext > GetByCampaignIdAsync > Start > MoveNext > Start > Start
SELECT * FROM dbo.AccessibilitySettings WHERE CampaignId = 295
sql - Close
View: Shared/Partials/Scripts/_AccessibilitySettingsScript.cshtml
0.25 ms (T+173.33 ms)
RunOrScheduleAction > MoveNext > RunInternal > TrySetResult > RunContinuations > RunOrScheduleAction > MoveNext > RunInternal
Connection Close()
34.72 ms
View: ~/Views/Inventory/Website_Mazda_OEM_Used_Inventory_VDP.cshtml — 29.14 ms

toggle trivial gaps