FPA live
 

test

test body

Your Info:
^ My phone (800) 866-1111
ProfileCLOSE

TOTAL QUERIES: 88

TOTAL TIME TAKEN FOR ENTIRE REQUEST: 1.262 seconds

OrderQueryTime Taken Each (seconds)Total Time Taken (seconds)Number of TimesNumber of Cache HitsCachedCalling Class
0select top 1 iurlpattern from ctm_DomainMappings where hObjPointer=144261 and url='malta1.reslisting.com' and hObjectType=30.0190.01910Not Cached YSI.Cafe.RC.PropertySiteContent.RCPropertySite
ReadParams
279
1select isnull(bPublishOnPortal,0) PublishOnPortal,isnull(bAgreetoList,0) PublishOnILS from ctm_param_Master with(nolock,nowait) where hproperty in (select hObjPointer from portal where hObjPointer = '144261' and hobjecttype = 3)0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.RCPropertySite
ReadParams
394
2select hMy from GeoUserData where sIPAddress = '10.246.3.243'0.0120.01210Not Cached YSI.Cafe.RC.Library.DataClasses.ysiGeoUserData
ReadByIP
164
3select r.hMy "Id" , r.sIPAddress "IpAddress" , r.sCountry "Country" , r.sState "State" , r.sCity "City" , r.sZipCode "ZipCode" , r.sLatitude "Latitude" , r.sLongitude "Longitude" , r.sMetro "Metro" , r.sAreaCode "AreaCode" , r.sISP "ISP" , r.sOrg "Org" , c.hMy "CBSAId" from GeoUserData r join ylsCBSA c on c.sMajorCBSAName = r.sCity and c.sMajorCBSAStateAbbreviation = r.sState where 1 = 1 and r.hMy = 16200371 0.0060.00610Not Cached YSI.Cafe.RC.Library.DataClasses.ysiGeoUserData
ReadByIP
167
4select top 1 isnull(t.iVersion,0) from ctm_theme t inner join portal p on t.hmy = p.htheme where p.hObjectType = 3 and p.ssitename = 'cafe-malta'0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.RCPropertySite
ReadParams
595
5SELECT bEnableForMVC FROM ctm_PropertyConfig WHERE hProperty = 1442610.010.0110Not Cached YSI.Cafe.RC.PropertySiteContent.RCPropertySite
ReadParams
633
6 select p.hmy myPortalId, p.hObjPointer myPropertyId, pm.iCafeType CafeType, template.hMy myThemeTemplateId, theme.hMy myThemeId, theme.sname themeName, isnull(pm.iPropertyType,0) PropertyType ,cpm.ActiveFlag isActive,cpm.busevoyagerportal UseVoyagerPortal, cpm.bAgreeToList AgreeToList, pm.bCompanyActive isCompanyActive ,cpm.bPublishOnPortal PublishOnPortal, isnull(cpm.bPublishOnAPI,0) PublishOnAPI, isnull(cpm.bUseiFrameContent ,0) UseIframeContent , theme.iThemeType , case when isnull(cpm.bAgreetoList,0) <> 0 then 1 else isnull(cpm.bEnableRCDynamicCampaign , 0) end UseRCDynamicCampaign, isnull(mt.sTag, '') MarketingTag , case when isnull(cpm.bAgreetoList,0) <> 0 then 1 else isnull(cpm.bEnableRCStandardCampaign, 0) end UseRCStandardCampaign from portal p inner join ctm_theme theme on theme.hMy = p.hTheme join ylsPropertyMaster pm on pm.hProperty = p.hObjPointer join ctm_param_master cpm on cpm.hProperty = p.hobjPointer inner join ctm_themetemplate template on template.hTheme = theme.hMy and template.hThemeTemplateType = 2 left join Ctm_CustomMarketingTag mt on mt.hobjpointer = pm.hcompany and mt.hobjtype = 2 and mt.ifunctionalitytype = pm.iPropertyType where 1=1 and p.sSiteName = 'cafe-malta' and p.hobjectType = 3 0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.RCPropertySite
doThemeSite
1330
7select p.Name PropertyName,p.Address Address, p.City City, p.State State, p.ZipCode ZipCode, p.Email Email, p.Phone PhoneNum from ylsPropertyMaster p where p.hproperty = 1442610.0050.00510Not Cached YSI.Cafe.RC.Library.Utils.rcUtils
GetPropertyAddress
114
8Select hMy from ctm_themeMenu where isNull(hPortal,0) <> 0 And hPortal = 143941 And hThemeTemplateType = 1 And isNull(bInActiveCustomMenu,0) = 0 0.0060.00610Not Cached YSI.Cafe.RC.Library.Utils.RentCafeUtils
GetThemeMenuId
1272
9 select isNULL(sContentClass,'') from ctm_themeMenuItem where hThemeMenu=85663 and sLink like 'mapsanddirections.aspx%'0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.RCPropertySite
GetPageCaption
1866
10select distinct pi.sAssemblyName, pi.sname, pi.iCafeType from property p inner join CafeTypeAssembly pi on p.icafetype = pi.icafetype where pi.sProgType = 'PropertySite' and p.hmy = 144261 0.0060.00610Not Cached YSI.Cafe.Systems.PluginManager
LoadCafePlugins
168
11 select top 1 pi.sAssemblyName, pi.sname, pi.iCafeType from ylsPropMgmtCompany c left join CafeTypeAssembly pi on pi.icafetype = 7 where c.hmy = 84065 and ISNULL(c.bOwnerPortal,0) <> 0 and pi.sProgType = 'PropertySite' 0.0050.00510Not Cached YSI.Cafe.Systems.PluginManager
LoadCafePlugins
187
12select iCafeType from property where hmy = 144261 0.0070.00710Not Cached YSI.Cafe.Systems.PluginManager
SetPluginRoot
78
13 Select ct.hmy ThemeId, ct.sCode ThemeCode, ct.iVersion Version, p.hObjectType ObjectTypeId, p.hObjPointer ObjectId, p.hMy PortalId, p.sSiteName PortalName, p.bShowCustomMetaTags ShowCustomMetaTags, p.sMetaDesc MetaDesc, p.sTitle PortalTitle, p.sFootertext FooterText, p.bUseCustomContent, p.bUseCustomCSSFile, isNull(p.sThemeColorVariation,isnull(cv.sname,'')) ThemeColorVariation, isNull(p.sPublishedCustomizationName,'') CustomizationName, p.bBundlingEnabled BundlingEnabled , pc.bEnableForMVC EnableForMVC , cpm.bPublishOnMVC PublishOnMVC , cpm.bPublishOnMVCForRPOLE PublishOnMVCForRPOLE from portal p inner join ctm_theme ct on ct.hmy = p.hTheme left join ctm_themevariations cv on cv.htheme = ct.hmy and p.hthemevariation = cv.hmy left Join ctm_propertyconfig pc with (nolock) on pc.hproperty = p.hObjPointer and p.hObjectType = 3 left Join ctm_param_master cpm with (nolock) on cpm.hproperty = p.hObjPointer and p.hObjectType = 3 where p.hmy = 143941 0.0060.01221Cached Result YSI.Cafe.Systems.ysiPortalSettings
Read
306
14Select iThemeType From ctm_theme where hMy = 3440.0060.00610Not Cached YSI.Cafe.Systems.ysiPortalSettings
SetTemplatePathForPrivateTheme
531
15select sCode from ylsPropMgmtCompany inner join ctm_DomainMappings on ylsPropMgmtCompany.hMy = ctm_DomainMappings.hObjPointer and ctm_DomainMappings.hObjectType = 2 where bUsePrivateTheme <> 0 and ctm_DomainMappings.url = 'malta1.reslisting.com'0.0070.00710Not Cached YSI.Cafe.Systems.ysiPortalSettings
SetTemplatePathForCorporateListing
622
16 select top 1 pc.sFooterText FooterText from ylspropmgmtcompany c with (NoLock) join property pr on pr.hPropMgmtCompany = c.hmy and isnull(c.bActive,0)<> 0 join ctm_propertyconfig pc on pc.hProperty = pr.hmy where pr.hMy = 1442610.0070.00710Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCompanyFooterText
1337
17select sFooterTextRentcafe from ctm_globalsettings0.0060.00610Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
CTM_GetGlobalInfo
728
18select sDomainName from ctm_globalsettings0.0060.00610Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
CTM_GetGlobalInfo
728
19 select top 1 isNULL(sContentClass,'') ContentClass, ISNULL(sContentAssembly, '') ContentAssembly, ISNULL(sContentNamespace, '') ContentNamespace from ctm_themeMenuItem where hThemeMenu=85663 and sLink like 'mapsanddirections.aspx%'0.0060.03665Cached Result YSI.Cafe.RC.Library.Utils.rcUtils
GetContentClassFromMenu
5022
20SELECT TOP 1 hmy, sDescription FROM ctm_contentclass WHERE lower(sContentClass) = 'mapsanddirections' 0.0050.02554Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag
getContentClass
792
21 select mi.hSection from ctm_thememenuitem mi where mi.hThemeMenu = 85663 and mi.sLink like 'mapsanddirections.aspx%'0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag
GetContent
183
22 SELECT TOP 1 cm.sPageTitle, cm.sKeywords, cm.sDescription, cm.sH1Content, s.sData CustomMetaInfo FROM ctm_MetaTag cm left outer join ctm_section s on cm.hobjpointer = s.hobjpointer and cm.hContentClass = s.hContentClass and s.sCode = 'CustMeta' and cm.hlanguage = s.hlanguage WHERE cm.hObjPointer = 144261 and cm.iobjtype = 3 and cm.hLanguage in (0, 27, 28, 0) AND cm.hContentClass = 44 and s.hLanguage in (0, 27, 28, 0) ORDER BY cm.hlanguage DESC, cm.hmy DESC, s.hlanguage DESC0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag
GetContent
261
23Select top 1 mc.sPageTitle, mc.sKeywords, mc.sDescription, mc.sH1Content, mc.sMetaHead CustomMetaInfo From ctm_section s join ctm_metatag mc on mc.hsectionid = s.hmy where s.iObjtype=3 and s.hObjpointer = 144261 and sPageName = 'mapsanddirections' and mc.hLanguage in (0, 27, 28, 0) order by mc.hlanguage desc 0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag
GetContent
276
24SELECT TOP 1 cm.sPageTitle, cm.sKeywords, cm.sDescription FROM ctm_MetaTag cm JOIN ctm_ContentClass cc ON cc.hMY = cm.hContentClass WHERE cm.hObjPointer = 1 AND cc.sContentClass = 'mapsanddirections' 0.0050.00510Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag
GetContent
314
25 select sTrackingCode, iTrackingType from ctm_CustomMarketingContent with (nolock,nowait) where iObjType=3 And hObjPointer=144261 And iTrackingType in (7,11, 12) And hPortalID = 0 0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.GoogleAnalytics
GetContent
159
26 select hmy from ctm_thememenu where 1=1 and bInActiveCustomMenu = 0 and sCode = 'CustomMenu_144261' 0.0060.01221Cached Result YSI.Cafe.RC.Library.Utils.ClickTrack
GetContentObject
186
27 Select * from ctm_custommarketingcontent where iobjtype = 3 And hobjpointer = 144261 And isnull(benable, 0) = 1 And iCodeLocation = 1 And ( ipageType = 1 ) UNION ALL SELECT * FROM ctm_custommarketingcontent WHERE iObjType = 3 AND hObjPointer = 144261 AND isNULL(bEnable,0) = 1 AND (iTrackingType = 1 OR iTrackingType = 2 OR iTrackingType = 6) AND iEvent = 120.0070.00710Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetPageScripts
681
28 Select ci.SCODE FROM Property P With (nolock) inner join country_info CI With (nolock) On P.HCOUNTRY = ci.HMY where P.hmy = 144261 0.0060.01832Cached Result YSI.Cafe.RC.Library.ContentClasses.PageScripts
IntHideEqualHousingLogoJs
744
29 select iWidth, iHeight from ctm_imageDimensions where iType = 125 and hTheme = 3440.0130.02621Cached Result YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
115
30select bUseCloudinary from ctm_DomainMappings where hObjPointer = 84065 and hObjectType = 2 and url = 'malta1.reslisting.com'0.0040.01232Cached Result YSI.Cafe.Systems.Cloudinary
UsingCloudinary
150
31 Select * from ctm_custommarketingcontent where iobjtype = 3 And hobjpointer = 144261 And isnull(benable, 0) = 1 And iCodeLocation = 2 And ( ipageType = 1 ) 0.0060.00610Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetPageScripts
681
32 select sTrackingCode, iTrackingType from ctm_CustomMarketingContent with (nolock,nowait) where iObjType=3 And hObjPointer=144261 And iTrackingType in (8, 12) And hPortalID = 0 0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.GoogleAnalytics
GetContent
159
33select p.HMY "ID" , p.SCODE "Code" , p.hCountry "CountryID" , p.SADDR1 "Name" , p.ITYPE "myType" , p.SADDR2 "Address" , p.SCITY "City" , p.SSTATE "State" , p.SZIPCODE "ZipCode" , p.SEXTRAADDRLINE "SEXTRAADDRLINE" , p.ITYPERES "ITYPERES" , p.bInactive "bInactive" , p.dtInactive "dtInactive" , p.hLegalEntity "hLegalEntity" , p.iTypeCommercial "iTypeCommercial" , p.iTypeCondo "iTypeCondo" , p.iTypeStudent "iTypeStudent" , p.iTypeSenior "iTypeSenior" , p.iTypeMilitary "iTypeMilitary" , p.iTypeAffordable "iTypeAffordable" , p.iTypePublicHousing "iTypePublicHousing" , p.iTypeCoop "iTypeCoop" , p.iTypeAssociation "iTypeAssociation" , p.iSubTypeAssoc "iSubTypeAssoc" , p.iTypeInternational "iTypeInternational" , p.hcompany "hcompany" , p.hForeigndb "hForeigndb" , p.sExtReference "sExtReference" , p.hExtReference "hExtReference" , p.iCBSACode "iCBSACode" , p.iType2 "iType2" , p.bForRentProperty "IsForRentProperty" , p.sSourceReference "sSourceReference" , p.hPropMgmtCompany "PropMgmtCompanyId" , p.hUserCreatedBy "UserCreatedBy" , p.hUserModifiedBy "UserModifiedBy" , p.dtCreated "DateCreated" , p.dtLastModified "DateLastModified" , p.bDelete "IsDelete" , p.hImportSource "ImportSource" , p.hImportRentSource "ImportRentSource" , p.iPropertyType "PropertyType" , p.iRentcafeSource "RentcafeSource" , p.hNeighborhood "Neighborhood" , p.hWorkflowTemplate "WorkflowTemplateID" , p.hSettingsTemplate "SettingsTemplateId" , pm.dLatitude "Latitude" , pm.dLongitude "Longitude" , p.iCafeType "CafeType" , p.sHmProjectType "ProjectType" , c.sPropertyPhone "PropertyPhone" , c.Phone "ListingPhone" , c.Fax "Fax" , p.bChat "IsChat" , p.sChatURL "ChatURL" , p.bTextUs "IsTextUs" , p.hTextUsPhoneId "textUsPhoneID" , p.iChatVersion "ChatVersion" , p.sTextUsRequiredFields "TextUsRequiredFields" , p.bIsFloorPlanAssistantEnabled "IsFloorPlanAssistantEnabled" from property p inner join ylspropertymaster pm on pm.hproperty = p.hmy left join ctm_param_master c on p.hMy = c.hProperty where 1 = 1 and p.HMY = 144261 0.0430.04310Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetContent
134
34select * from ctm_PropertySettings WITH(NOLOCK) where hObjPointer = 0 and hSettingType = 10.0070.02132Cached Result YSI.Cafe.RC.Library.PropertySettings
SetSystemDefaultValuesFromDB
570
35select p.hmy, p.hPropMgmtCompany companyId, lp.hPropList listId, p.iPropertyType from property p left join listprop2 lp on lp.hProperty = p.hmy and lp.hPropList <> lp.hProperty where hmy=1442610.0060.01831Cached Result YSI.Cafe.RC.Library.PropertySettings
Read
717
36select * from ctm_PropertySettings WITH(NOLOCK) where ( (hObjPointer = 144261 and hsettingtype=4) or (hObjPointer = 84065 and hsettingtype=2))0.0090.02731Cached Result YSI.Cafe.RC.Library.PropertySettings
Read
747
37SELECT COUNT(*) num FROM AdWordsClients WHERE hPropertyId = 144261 And bActive = 10.0070.00710Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetContent
510
38SELECT TOP 1 p.bIsFloorPlanAssistantEnabled, p.bIsfpaAmenitiesEnabled, pc.sFloorPlanAssistantButtonLabel, pc.sFloorPlanAssistantTagline, pc.sFloorPlanThemeColor, pc.dFloorPlanColorOpacity, pc.sFloorPlanAssistantDockSide FROM property p INNER JOIN ctm_propertyConfig pc ON p.hmy = pc.hProperty WHERE p.hmy = 1442610.0050.00510Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetContent
520
39SELECT sFloorPlanAssistantButtonLabel, sFloorPlanAssistantTagline, sFloorPlanThemeColor, dFloorPlanColorOpacity, sFloorPlanAssistantDockSide FROM ctm_propertyconfig WHERE hProperty = 144261 0.0060.00610Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetFloorPlanAssistantSettings
772
40SELECT TOP 1 * FROM ctm_DocMgrXRef WHERE hProperty = 144261 AND iType = 134 AND bInActive = 00.0070.00710Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetFloorPlanAssistantSettings
792
41select bUseCloudinary from ctm_DomainMappings where hObjPointer = 144261 and hObjectType = 3 and url = 'malta1.reslisting.com'0.0060.01832Cached Result YSI.Cafe.Systems.Cloudinary
UsingCloudinary
150
42select top 1 sExternalURL from ylspropertymaster where hProperty = 1442610.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.PropertyHomePageUrl
GetContent
26
43select itype from ctm_itype where sName='Property Logo'0.0060.00610Not Cached YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
94
44 select iWidth, iHeight from ctm_imageDimensions where iType = 6 and hTheme = 3440.0050.00510Not Cached YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
115
45SELECT iVideoStatus FROM ctm_VideoEmbed WHERE hProperty=144261AND hFloorplan IS NULL0.0050.00510Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu
GetContent
92
46 select * from ctm_thememenuitem where hthememenu = 85663 and isnull(iorder,0) <> 0 and isnull(bIgnoreSection,0) = 0 and isnull(sIosDeepLinkUrl,'') = '' AND isnull(sAndroidDeepLinkUrl,'') = '' and sMenuSet = 'Primary' and sContentClass <> 'PropertySiteRatings' and scontentclass <> 'Videos' order by iorder 0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu
GetContent
115
47 SELECT IsNull(hPropMgmtCompany, 0) FROM property with (nolock) WHERE hmy = 144261 0.0060.01832Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu
GetContent
129
48 select top 1 hMY from ctm_ThemeMenuItem where hThemeMenu = 85663 and isnull(iorder,0) <> 0 and isnull(bIgnoreSection,0) = 0 and sMenuSet = 'Primary' and slink = 'mapsanddirections.aspx' 0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu
getpageID
256
49select t.hMY hmy,t.iTaglineType TaglineType from portal p with(nolock,nowait) inner join ctm_theme t with(nolock,nowait) on p.hTheme=t.hmy where p.hmy = 143941 0.0050.00510Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine
GetContent
38
50 select * from taglinesettings where hobjpointer=144261 and hsettingtype=3 0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine
GetContent
49
51 select * from taglinesettings ts where ts.hObjPointer = 84065 and ts.hTheme =344 0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine
GetContent
108
52 select top 1 isnull(Dx.sAlias,'') ImageFile ,Dx.hmy DocMgrXrefId ,D.hmy DocMgrId ,isnull(D.sFile,'') FileName ,isnull(D.iWidth,0) FileWidth ,isnull(Dx.sTitle,'') sTitle ,isnull(Dx.sDesc,'') sDesc ,isnull(Dx.sCaption,'') sCaption ,isnull(Dx.sImageDescription,'') sImageDescription ,isnull(D.iHeight,0) FileHeight ,isnull(D.iSize,0) FileSize ,isnull(Dx.iOrder,0) FileOrder ,isnull(Dx.sModificationParams,'') ImageParams , isnull(Dx.cropX,'') cropX , isnull(Dx.cropY,'') cropY , isnull(Dx.cropH,'') cropH , isnull(Dx.cropW,'') cropW ,isnull(Dx.hDocMgrCategory,0) FileDocMgrCategory ,case when dx.hparent<>0 then dx1.iobjtype else dx.iobjtype end ObjectType , case when dx.hparent<>0 then dx1.hobjpointer else dx.hobjpointer end ObjectId , dx.itype iType , ISNULL(dx.bMediaLibrary, 0) IsMediaLibrary ,isnull(Dx.scontenttype,'') contenttype ,isnull(Dx.sextension,'') imagetype , dx.hparent hParent from ctm_docmgrxref Dx inner join ctm_docmgr D on DX.hdocmgr=D.hmy left outer join ctm_docmgrxref Dx1 on dx.hparent=dx1.hmy where dx.itype = 12 and dx.iObjType = 3 and dx.hObjPointer = 144261 and isnull(dx.iDelete,0) = 0 and isnull(dx.bInActive,0) = 0 order by FileOrder , DocMgrXrefId 0.0060.00610Not Cached YSI.Cafe.RC.Library.Utils.RentCafeUtils
GetActiveImages
1472
53select top 1 p.Name PropertyName,p.Address Address, p.City City, p.State State, p.ZipCode ZipCode, p.Email Email, p.Phone PhoneNuml, pc.iGoogleMapTypeId, sGoogleMapTypeName, p.dLatitude dLatitude, p.dLongitude dLongitude, sshortname, pc.bIsGoogleMaps, pc.sWalkScoreLink, pc.sGoogleMapsListingLink, bShowSisterProps, bAllowWebsiteForPin, pc.iMapBoxMapTypeId, sMapTypeName, bEnableLocalAreaMarketing, bShowSisterProps, bLocalAreaMapPublished, iMapZoomLevel from ylsPropertyMaster p inner join ctm_PropertyConfig pc on pc.hProperty = 144261inner join RCMapBoxMapTypes map on map.iMapBoxMapTypeId = pc.iMapBoxMapTypeId inner join RCGoogleMapTypes Gmap on Gmap.iGoogleMapTypeId = pc.iGoogleMapTypeId where p.hproperty = 1442610.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.AppClasses.MapsandDirections
getPropertyData
251
54select hSisterProperty from ctm_sisterproperties where hproperty = 1442610.0080.00810Not Cached YSI.Cafe.RC.PropertySiteContent.AppClasses.MapsandDirections
getPropertyData
323
55Select iMinBed, iMaxBed, dminBath, dmaxBath, dminRent, dmaxRent from ylsPropertyMaster where hproperty = 1442610.0050.00510Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.mapsanddirections
GetContent
133
56Select ci.SCODE from country_info ci WITH(NOLOCK) inner join property p WITH(NOLOCK) on ci.HMY = p.HCOUNTRY where p.HMY = 1442610.0050.00510Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.mapsanddirections
GetContent
148
57Select p.sCode PropertyCode , cpm.name PropertyName, cpm.address PropertyAddress, cpm.city PropertyCity, cpm.state PropertyState, cpm.ZipCode PropertyZip, cpm.sPropertyPhone PropertyPhone, cpm.email PropertyEmail, cpm.Phone PropertyListingPhone, p.hMy PropertyId, IsNull(p.sExtReference, '') VoyagerPropertyCode from Property p inner join ctm_param_master cpm on cpm.hproperty = p.hmy and p.hmy = 144261 inner join ylsPropertyMaster ypm on ypm.hproperty = p.hmy 0.0080.04865Cached Result YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative
ReplaceParamsData
237
58Select hmy, hProperty, MapGroupName, MapGroupMarkerColor From RCPropertyMapGroups where hProperty = 144261 ORDER BY iSortOrder ASC0.0220.02210Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.mapsanddirections
BuildLocalMarketingMap
199
59Select rcp.hmy As PlaceID, sPlace, sPlaceAddress, sPlaceCity, sPlaceState, sPlaceZipCode, dPlaceLatitude, dPlaceLongitude , Isnull(iMapGroupId, 0) As iMapGroupId, isNull(MapGroupName, 'Unassigned') as 'MapGroupName', isnull(MapGroupMarkerColor, '#000000') as MapGroupMarkerColor, MapMarkersTyleValue, sPlacesGUID, sPlaceWebsite, bInclude, bOverrideLatLong, dUserLongitude, dUserLatitude From RCPlaces rcp with(nolock) Left join RCPropertyMapGroups mg with(nolock) on mg.hmy = rcp.imapgroupid join RCMapMarkerStyles ms on ms.hmy = mg.MapMarkerStyleId Where rcp.hProperty = 144261 0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.mapsanddirections
GetPropertyPlaces
566
60Select rcp.hmy As PlaceID, sPlace, sPlaceAddress, sPlaceCity, sPlaceState, sPlaceZipCode, dPlaceLatitude, dPlaceLongitude, sPlacesGUID , Isnull(iMapGroupId, 0) As iMapGroupId, isNull(MapGroupName, 'Unassigned') as 'MapGroupName', sPlaceWebsite , bOverrideLatLong, dUserLongitude, dUserLatitude From RCPlaces rcp with(nolock) Left join RCPropertyMapGroups mg with(nolock) on mg.hmy = rcp.imapgroupid Where rcp.hProperty = 144261 and iMapGroupId = 26154 and bInclude = 1 0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.mapsanddirections
GetPropertyPlacesByCatagory
579
61Select rcp.hmy As PlaceID, sPlace, sPlaceAddress, sPlaceCity, sPlaceState, sPlaceZipCode, dPlaceLatitude, dPlaceLongitude, sPlacesGUID , Isnull(iMapGroupId, 0) As iMapGroupId, isNull(MapGroupName, 'Unassigned') as 'MapGroupName', sPlaceWebsite , bOverrideLatLong, dUserLongitude, dUserLatitude From RCPlaces rcp with(nolock) Left join RCPropertyMapGroups mg with(nolock) on mg.hmy = rcp.imapgroupid Where rcp.hProperty = 144261 and iMapGroupId = 26155 and bInclude = 1 0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.mapsanddirections
GetPropertyPlacesByCatagory
579
62Select rcp.hmy As PlaceID, sPlace, sPlaceAddress, sPlaceCity, sPlaceState, sPlaceZipCode, dPlaceLatitude, dPlaceLongitude, sPlacesGUID , Isnull(iMapGroupId, 0) As iMapGroupId, isNull(MapGroupName, 'Unassigned') as 'MapGroupName', sPlaceWebsite , bOverrideLatLong, dUserLongitude, dUserLatitude From RCPlaces rcp with(nolock) Left join RCPropertyMapGroups mg with(nolock) on mg.hmy = rcp.imapgroupid Where rcp.hProperty = 144261 and iMapGroupId = 26156 and bInclude = 1 0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.mapsanddirections
GetPropertyPlacesByCatagory
579
63Select rcp.hmy As PlaceID, sPlace, sPlaceAddress, sPlaceCity, sPlaceState, sPlaceZipCode, dPlaceLatitude, dPlaceLongitude, sPlacesGUID , Isnull(iMapGroupId, 0) As iMapGroupId, isNull(MapGroupName, 'Unassigned') as 'MapGroupName', sPlaceWebsite , bOverrideLatLong, dUserLongitude, dUserLatitude From RCPlaces rcp with(nolock) Left join RCPropertyMapGroups mg with(nolock) on mg.hmy = rcp.imapgroupid Where rcp.hProperty = 144261 and iMapGroupId = 26157 and bInclude = 1 0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.mapsanddirections
GetPropertyPlacesByCatagory
579
64Select rcp.hmy As PlaceID, sPlace, sPlaceAddress, sPlaceCity, sPlaceState, sPlaceZipCode, dPlaceLatitude, dPlaceLongitude, sPlacesGUID , Isnull(iMapGroupId, 0) As iMapGroupId, isNull(MapGroupName, 'Unassigned') as 'MapGroupName', sPlaceWebsite , bOverrideLatLong, dUserLongitude, dUserLatitude From RCPlaces rcp with(nolock) Left join RCPropertyMapGroups mg with(nolock) on mg.hmy = rcp.imapgroupid Where rcp.hProperty = 144261 and iMapGroupId = 26158 and bInclude = 1 0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.mapsanddirections
GetPropertyPlacesByCatagory
579
65Select rcp.hmy As PlaceID, sPlace, sPlaceAddress, sPlaceCity, sPlaceState, sPlaceZipCode, dPlaceLatitude, dPlaceLongitude, sPlacesGUID , Isnull(iMapGroupId, 0) As iMapGroupId, isNull(MapGroupName, 'Unassigned') as 'MapGroupName', sPlaceWebsite , bOverrideLatLong, dUserLongitude, dUserLatitude From RCPlaces rcp with(nolock) Left join RCPropertyMapGroups mg with(nolock) on mg.hmy = rcp.imapgroupid Where rcp.hProperty = 144261 and iMapGroupId = 26159 and bInclude = 1 0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.mapsanddirections
GetPropertyPlacesByCatagory
579
66Select rcp.hmy As PlaceID, sPlace, sPlaceAddress, sPlaceCity, sPlaceState, sPlaceZipCode, dPlaceLatitude, dPlaceLongitude, sPlacesGUID , Isnull(iMapGroupId, 0) As iMapGroupId, isNull(MapGroupName, 'Unassigned') as 'MapGroupName', sPlaceWebsite , bOverrideLatLong, dUserLongitude, dUserLatitude From RCPlaces rcp with(nolock) Left join RCPropertyMapGroups mg with(nolock) on mg.hmy = rcp.imapgroupid Where rcp.hProperty = 144261 and iMapGroupId = 26160 and bInclude = 1 0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.mapsanddirections
GetPropertyPlacesByCatagory
579
67 select top 1 doc.sAlias filename, case when doc.hparent>0 then doc1.iobjtype else doc.iobjtype end ObjectType, case when doc.hparent>0 then doc1.hobjpointer else doc.hobjpointer end ObjectId, doc.sDesc ImageAltText, doc.sTitle ImageTitle from ctm_docmgrxref doc left outer join ctm_DocMgrXRef doc1 on doc.hparent = doc1.hmy where doc.hObjPointer = 144261 and doc.iObjType = 3 and doc.itype = 5 and isnull(doc.bInActive,0) = 0 and isnull(doc.iDelete,0) = 0 order by doc.hmy desc0.0060.00610Not Cached YSI.Cafe.RC.Library.Utils.RentCafeUtils
getPropThumbnail
1957
68select sText, sSource from Testimonials where hProperty = 144261 0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.ResQuotesWidget
ReadSettings
130
69select cpm.sPropertyPhone, c.sCompanyName, c.sCompanyDisplayName, ypm.Name, ypm.Address, '' Address2, ypm.City, ypm.State, ypm.ZipCode, ypm.Email, ypm.Phone RCILSListingPhone, cpm.phone ListingPhone, ypm.iPropertyType, pc.bShowCompanyName from property p join ylspropertymaster ypm on ypm.hproperty = p.hmy join ylspropmgmtcompany c on c.hmy = p.hpropmgmtcompany join ctm_param_master cpm on cpm.hproperty = p.hmy join ctm_propertyconfig pc on pc.hproperty = p.hmy where p.hmy = 1442610.0060.01221Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.AddressBlock
GetData
193
70 Select sLink Link , sCaption Caption From ctm_footerlinks where htheme = 344 0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.FooterSection
GetLinks
84
71 Select sLink Link , sCaption Caption From ctm_footerlinks where isnull(htheme,0) = 0 and isnull(hobject,0) = 0 and isnull(iObjectType,0) = 0 and iFooterSection = 3 0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.FooterSection
GetLinks
103
72select itype from ctm_itype where sName='Footer Image'0.0060.00610Not Cached YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
94
73 select iWidth, iHeight from ctm_imageDimensions where iType = 29 and hTheme = 3440.0060.00610Not Cached YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
115
74 Select * from ctm_custommarketingcontent where iobjtype = 3 And hobjpointer = 144261 And isnull(benable, 0) = 1 And iCodeLocation = 3 And ( ipageType = 1 ) 0.0070.00710Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetPageScripts
681
75;with cteProperty (PropertyId, DomainUrl, Latitude, Longitude, PageDescription, PropertyTypeId, CorporateDomainUrl) as(select PropertyId = p.hmy, dm.url, pm.dLatitude, pm.dLongitude, pm.[Description], p.iPropertyType, dmc.url from property p left join ctm_DomainMappings dm on p.hmy = dm.hObjPointer left join ctm_DomainMappings dmc on p.hPropMgmtCompany = dmc.hObjPointer join ctm_param_Master pm on p.hmy = pm.hproperty where p.hmy = 144261 And dm.hObjectType = 3), ctePropertyLogo(PropertyId, DomainUrl, Latitude, Longitude, PageDescription, PropertyImage, PropertyTypeId, CorporateDomainUrl) as(select top 1 cte.PropertyId, cte.DomainUrl, cte.Latitude, cte.Longitude, cte.PageDescription, PropertyImage = case when dm.sFile is null then '' else '/dmslivecafe/' + cast(dr.iObjType as varchar) + '/' + cast(dr.hObjPointer as varchar) + '/' + dm.sFile end, cte.PropertyTypeId, cte.CorporateDomainUrl from cteProperty cte left join ctm_DocMgrXRef dr on cte.PropertyId = dr.hObjPointer and dr.itype = 5 and dr.iObjType = 3 left join ctm_docmgr dm on dr.hDocMgr = dm.hmy where isnull(dr.bInActive,0) = 0 and isnull(dr.iDelete,0) = 0 order by dr.hmy desc ),ctePropertyLogoPropertyImage(PropertyId, DomainUrl, Latitude, Longitude, PageDescription, PropertyImage, PropertyLogo, PropertyTypeId, CorporateDomainUrl) as(select top 1 PropertyId, DomainUrl, Latitude, Longitude, PageDescription, PropertyImage, PropertyLogo = case when dm.sFile is null then '' else '/dmslivecafe/' + cast(dr.iObjType as varchar) + '/' + cast(dr.hObjPointer as varchar) + '/' + dm.sFile end, cte.PropertyTypeId, cte.CorporateDomainUrl from ctePropertyLogo cte left join ctm_DocMgrXRef dr on cte.PropertyId = dr.hObjPointer and itype = 6 and dr.iObjType = 3 left join ctm_docmgr dm on dr.hDocMgr = dm.hmy where isnull(dr.bInActive,0) = 0 and isnull(dr.iDelete,0) = 0 order by dr.hmy desc )select DomainUrl, Latitude, Longitude, PageDescription, PropertyImage, PropertyLogo, PropertyTypeId, CorporateDomainUrl from ctePropertyLogoPropertyImage 0.0070.00710Not Cached YSI.Cafe.RC.Library.AppClasses.SchemaMarkupJSONLD
PopulatePrivateVariables
342
76SELECT TOP 1 nudge.hmy HMY, nudge.bEnabled benabled, nudge.sTitle Title, nudge.sDescription Description, nudge.sPhoneCaption PhoneCaption, nudge.iSecondsOnPage SecondsOnPage, nudge.iNumPageVisits PageVisits, ISNULL(nudge.iAnypage,0) anypage, nudge.scheduleFrom schedulefrom, nudge.scheduleTo scheduleto,nudge.dtModifiedUTC lastModified, nudgepages.hPage pageID, LOWER(nudgepages.sPageName) pageName, ISNULL(nudge.campaignType,0) campType, nudge.outboundText outButton, nudge.cancelText cancelButton, ISNULL(nudge.hFloorplan,0) floorplan, ISNULL(nudge.hunittype,0) unittype, ISNULL(nudge.hunit,0) unit, ISNULL(nudge.ibeds,0) beds, nudge.campaignXref xRef, nudge.sLinkPageName htmlLink FROM ctm_nudgemarketing nudge LEFT JOIN ctm_nudgemarketing_pages nudgepages ON nudge.hmy = nudgepages.hCampaign AND LOWER(nudgepages.sPageName) = LOWER('mapsanddirections.aspx') WHERE nudge.hObjPointer = 84065 AND nudge.hObjType = 2 AND ISNULL(bArchived,0) <> 1 AND (LOWER(nudgepages.sPageName) = LOWER('mapsanddirections.aspx') OR nudge.iAnypage = 1) AND (nudge.bEnabled = 1 OR (nudge.bEnabled = 3 AND (CONVERT(date, getdate()) BETWEEN nudge.scheduleFrom AND nudge.scheduleTo)) )0.0060.00610Not Cached YSI.Cafe.RC.Library.ContentClasses.companynudgemarketingpopup
getNudgeData
288
77SELECT TOP 1 nudge.hmy HMY, nudge.bEnabled benabled, nudge.sTitle Title, nudge.sDescription Description, CASE WHEN ISNULL(phone.sPhoneNumber,'') = '' THEN pm.phone ELSE phone.sPhoneNumber END PhoneNumber, nudge.sPhoneCaption PhoneCaption, nudge.iSecondsOnPage SecondsOnPage, nudge.iNumPageVisits PageVisits, ISNULL(nudge.iAnypage,0) anypage, nudge.scheduleFrom schedulefrom, nudge.scheduleTo scheduleto, nudgepages.hPage pageID, LOWER(nudgepages.sPageName) pageName, CASE WHEN phone.hmy > 0 THEN phone.sVoyagerSource ELSE 'Portal' END CallType, ISNULL(nudge.campaignType,0) campType, nudge.outboundText outButton, nudge.cancelText cancelButton, special.sPortalDescription specialDesc, ISNULL(nudge.hFloorplan,0) floorplan, ISNULL(nudge.hunittype,0) unittype, ISNULL(nudge.hunit,0) unit, ISNULL(nudge.ibeds,0) beds, ISNULL(pr.sPromoCode,'') promoCode,ISNULL(pr.sDescription,'') promoDescription, ISNULL(pr.bAutoApply,0) IsPromoAutoApply, ISNULL(pr.iAmountType,0) AmountType, ISNULL(pr.dAmount,0) promoAmount, ISNULL(pr.bHoldingDeposit, 0) isHoldingDeposit, ISNULL(pr.bAppFee, 0) isAppFee, ISNULL(pr.bAdminFee, 0) isAdminFee, ISNULL(pr.bEarnestmoney, 0) isEarnestMoney, nudge.campaignXref xRef, nudge.sLinkPageName htmlLink FROM ctm_nudgemarketing nudge INNER JOIN ctm_param_Master pm ON nudge.hObjPointer = pm.hproperty LEFT JOIN ctm_nudgemarketing_pages nudgepages ON nudge.hmy = nudgepages.hCampaign AND LOWER(nudgepages.sPageName) = LOWER('mapsanddirections.aspx') LEFT JOIN ccp_client_property_phone phone on nudge.hPhoneNumber = phone.hmy LEFT JOIN LeasingSpecials special ON nudge.campaignXref = special.hmy LEFT JOIN ctm_promotions pr ON nudge.campaignXref = pr.hmy WHERE nudge.hObjPointer = 144261 AND nudge.hObjType = 3 AND ISNULL(bArchived,0) <> 1 AND (LOWER(nudgepages.sPageName) = LOWER('mapsanddirections.aspx') OR nudge.iAnypage = 1) AND (nudge.bEnabled = 1 OR (nudge.bEnabled = 3 AND (CONVERT(date, getdate()) BETWEEN nudge.scheduleFrom AND nudge.scheduleTo)) )0.0070.00710Not Cached YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup
getNudgeData
366
78select top 1 hmy, sTrackingCode, iTrackingType, bEnable FROM ctm_CustomMarketingContent cmc WHERE cmc.iObjType = 3 AND cmc.hObjPointer = 144261 AND cmc.bEnable = 1 AND cmc.iEvent = 9 AND cmc.iTrackingType = 1 0.0070.00710Not Cached YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup
BuildFormLeads
850
79select * FROM ctm_CustomMarketingContent cmc WHERE cmc.iObjType = 3 AND cmc.hObjPointer = 144261 AND cmc.bEnable = 1 AND cmc.iTrackingType = 11 0.0060.00610Not Cached YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup
IsGTAGUsedForGoogleAnalyic
1009
80select * FROM ctm_CustomMarketingContent cmc WHERE cmc.iObjType = 3 AND cmc.hObjPointer = 144261 AND cmc.bEnable = 1 AND cmc.iTrackingType = 110.0050.00510Not Cached YSI.Cafe.RC.Library.AppClasses.ThemeScripting
GetContent
196
81 Select hMy from ctm_ContentClass where sContentClass = 'portalcookiepolicy' 0.0050.00510Not Cached YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative
GetCookiePolicyLinkPageName
350
82 SELECT TOP(1) 1 FROM ctm_Section WHERE hContentClass = 110 AND ((iObjType = 3 And hObjPointer = 144261) OR (iObjType = 2 And hObjPointer = 84065))0.0050.00510Not Cached YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative
GetCookiePolicyLinkPageName
361
83select sGoogleSiteVerification from ylsPropertyMaster where hProperty = 1442610.0060.00610Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
CTM_GetPropertyInfo
797
84select top 1 c.sCSS from ctm_customCSS c WITH (NOLOCK) join property pr WITH (NOLOCK) on pr.hPropMgmtCompany = c.hCompany and isnull(c.benable,0)<>0 join portal p WITH (NOLOCK) on p.hObjPointer = pr.hmy and p.htheme = c.htheme where c.hThemeTemplateType = 2 and p.hMy = 143941 AND ISNULL(c.hsettingstemplate, 0) = 0 order by c.hmy desc 0.0060.00610Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomCSS
1130
85select top 1 c.sCSS from ctm_customCSS c WITH (NOLOCK) join portal p WITH (NOLOCK) on p.hObjPointer = c.hProperty and isnull(c.benable,0)<>0 and (p.htheme = c.htheme or isnull(c.htheme,0) = 0) where c.hThemeTemplateType = 2 and p.hMy = 143941 order by c.hmy desc0.0060.00610Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomCSS
1150
86select c.sJs from ctm_customJs c WITH (NOLOCK) join property pr WITH (NOLOCK) on pr.hPropMgmtCompany = c.hCompany and isnull(c.benable,0)<>0 join portal p WITH (NOLOCK) on p.hObjPointer = pr.hmy and p.htheme = c.htheme where c.hThemeTemplateType = 2 and p.hMy = 143941 AND ISNULL(c.hsettingstemplate, 0) = 0 0.0070.00710Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomJS
1212
87select c.sJS from ctm_customJS c WITH (NOLOCK) join portal p WITH (NOLOCK) on p.hObjPointer = c.hProperty and isnull(c.benable,0)<>0 and (p.htheme = c.htheme or isnull(c.htheme,0) = 0) where c.hThemeTemplateType = 2 and p.hMy = 1439410.0060.00610Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomJS
1232