FPA live

T1

TESTING

Resident Services

 

test

test body

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

TOTAL QUERIES: 79

TOTAL TIME TAKEN FOR ENTIRE REQUEST: 1.021 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.0050.00510Not 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.0080.00810Not Cached YSI.Cafe.RC.PropertySiteContent.RCPropertySite
ReadParams
394
2select hMy from GeoUserData where sIPAddress = '10.246.3.246'0.0050.00510Not 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 = 16200432 0.0070.00710Not 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.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.RCPropertySite
ReadParams
595
5SELECT bEnableForMVC FROM ctm_PropertyConfig WHERE hProperty = 1442610.0110.01110Not 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.0080.00810Not 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.0040.00410Not 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.0090.00910Not Cached YSI.Cafe.RC.Library.Utils.RentCafeUtils
GetThemeMenuId
1272
9 select isNULL(sContentClass,'') from ctm_themeMenuItem where hThemeMenu=85663 and sLink like 'community.aspx%'0.0070.00710Not 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.0060.00610Not 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.0070.01421Cached 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.0080.00810Not 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.0080.00810Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCompanyFooterText
1337
17select sFooterTextRentcafe from ctm_globalsettings0.0070.00710Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
CTM_GetGlobalInfo
728
18select sDomainName from ctm_globalsettings0.0070.00710Not 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 'community.aspx%'0.0080.04865Cached Result YSI.Cafe.RC.Library.Utils.rcUtils
GetContentClassFromMenu
5022
20SELECT TOP 1 hmy, sDescription FROM ctm_contentclass WHERE lower(sContentClass) = 'community' 0.0070.03554Cached 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 'community.aspx%'0.0070.00710Not 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 = 95 and s.hLanguage in (0, 27, 28, 0) ORDER BY cm.hlanguage DESC, cm.hmy DESC, s.hlanguage DESC0.0080.00810Not 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 = 'community' and mc.hLanguage in (0, 27, 28, 0) order by mc.hlanguage desc 0.0060.00610Not 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 = 'community' 0.0070.00710Not 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.010.0110Not 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.0070.01421Cached 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.0070.02132Cached Result YSI.Cafe.RC.Library.ContentClasses.PageScripts
IntHideEqualHousingLogoJs
744
29 select iWidth, iHeight from ctm_imageDimensions where iType = 125 and hTheme = 3440.0110.01110Not Cached 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.0060.01221Cached 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.0070.00710Not 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.0070.00710Not 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.010.0110Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetContent
134
34select * from ctm_PropertySettings WITH(NOLOCK) where hObjPointer = 0 and hSettingType = 10.0080.02432Cached 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.0080.02432Cached 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.010.0332Cached Result YSI.Cafe.RC.Library.PropertySettings
Read
747
37SELECT COUNT(*) num FROM AdWordsClients WHERE hPropertyId = 144261 And bActive = 10.0080.00810Not 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.0080.00810Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetContent
520
39SELECT sFloorPlanAssistantButtonLabel, sFloorPlanAssistantTagline, sFloorPlanThemeColor, dFloorPlanColorOpacity, sFloorPlanAssistantDockSide FROM ctm_propertyconfig WHERE hProperty = 144261 0.0120.01210Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetFloorPlanAssistantSettings
772
40SELECT TOP 1 * FROM ctm_DocMgrXRef WHERE hProperty = 144261 AND iType = 134 AND bInActive = 00.0080.00810Not 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.0070.02132Cached 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.0080.00810Not Cached YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
94
44 select iWidth, iHeight from ctm_imageDimensions where iType = 6 and hTheme = 3440.0070.00710Not Cached YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
115
45SELECT iVideoStatus FROM ctm_VideoEmbed WHERE hProperty=144261AND hFloorplan IS NULL0.0070.00710Not 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.0090.00910Not 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 = 'community.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.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine
GetContent
38
50 select * from taglinesettings where hobjpointer=144261 and hsettingtype=3 0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine
GetContent
49
51 select * from taglinesettings ts where ts.hObjPointer = 84065 and ts.hTheme =344 0.0070.00710Not 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.0070.00710Not Cached YSI.Cafe.RC.Library.Utils.RentCafeUtils
GetActiveImages
1472
53 SELECT top 1 sData ,sName FROM ctm_Section s with (nolock) WHERE s.iObjType = 3 AND s.hObjPointer = 144261 AND s.sCode = 'ResHome' AND s.sFunction = 'ResCommunityPage' 0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.Community
GetRomanceParagraph
166
54 SELECT hProperty FROM listprop2 WHERE hPropList in (144261 )0.0070.01421Cached Result YSI.Cafe.Systems.ysiDataUtil
BuildPropertyInClause
635
55 Select distinct 0 UnitID ,ls.hUnitType UnitTypeID ,isnull(isnull(case when LS.sPortalDescription ='' then NULL else LS.sPortalDescription end ,ls.sdesc),'') PortalDescription ,ctm_FP.hFloorplan FloorPlanID ,YFP.hproperty PropertyID ,LS.hmy SpecialsID ,isnull(ls.hChargeCode,0) ChargeCodeID ,isnull(ls.iFrequencyType,0) RecurrenceType ,isnull(ls.iFrequencyNumber,0) Recurrences ,isnull(ls.dAmount,0) Amount ,isnull(ls.iMinLeaseTerm,1) LeaseTermFrom ,case when isnull(ls.iMaxLeaseTerm,0) = 0 then 0 else isnull(ls.iMaxLeaseTerm,0) end LeaseTermTo ,isnull(ls.dtInactive,'01/01/2500') ExpirationDate ,isnull(ls.iStartMonth,0) StartMonth ,isnull(ls.iProrateType,0) ProrateType ,isnull(ls.bTaxable,0) IsTaxable ,isnull(ls.bModifiable,0) IsModifiable ,isnull(ls.sNotes,'') Notes ,isnull(ls.sDesc,'') Description ,isnull(ls.dtStart,'01/01/1900') StartingDate ,isnull(ls.bNewMoveIn,0) IsNewMoveIn ,isnull(ls.bRenewal,0) IsRenewal ,isnull(ls.bTransfer,0) IsTransfer ,isnull(ls.bShowOnPortal,0) IsShowOnPortal ,isnull(ls.iAmountType,0) AmountType ,isnull(ls.hForeigndb,0) ForeigndbID ,isnull(ls.hExtReference,0) VoyagerID ,isnull(ls.bRentCafeSpecial,0) RentCafeSpecial ,isnull(ls.bPromotionalSpecial,0) PromotionalSpecial ,YFP.sname FloorplanName From ylsFloorPlan YFP inner join ctm_floorplanunittype ctm_FP on ctm_FP.hFloorplan = YFP.HMY and YFP.hProperty in (144261) inner Join LeasingSpecials ls on ls.hFloorplan = YFP.HMY and isnull(ls.bRentCafeSpecial,0) = 1 and isnull(ls.bInActive,0) = 0 and ls.bShowOnPortal <> 0 and 1 = (case when isnull(ls.bPromotionalSpecial,0) = 0 and isnull(ls.dAmount,0) > 0 then 1 when isnull(ls.bPromotionalSpecial,0)= 1 then 1 else 0 end ) and isnull(ls.bNewMoveIn,0) <> 0 and ls.hProperty in (144261) And Isnull(ls.dtinactive,convert(datetime, '05/08/2021', 101)) >= convert(datetime, '05/08/2021', 101) order by isnull(ls.iStartMonth,0) 0.0090.00910Not Cached YSI.Cafe.RC.Library.AppClasses.RentCafeSpecials
GetFloorPlanSpecials
71
56 SELECT sTitle, sDesc, IsNull(iOrder, 999), dtStartdate FROM ctm_Announcement with (nolock) WHERE bActive <> 0 AND ((iObjType = 3 AND hObjPointer = 144261 ) or hMy in (select hAnnouncement from AnnouncementPropXRef where hProperty = 144261)) AND dtStartdate <= convert(datetime, '05/07/2021', 101) AND (dtEndDate Is Null OR dtEndDate >= convert(datetime, '05/07/2021', 101)) AND iAnnouncementType = 0 AND bShowOnCommunity <> 0 ORDER BY 3 ASC, 4 DESC 0.0080.00810Not Cached YSI.Cafe.RC.Library.ContentClasses.CommunityAnnouncements
GetAnnouncementsDatatable
87
57 SELECT sDesc , dtEventdate , dtStartdate , dtEnddate , bRecurring , iRecurringType , iFutureIterationsDisplayed , iPastIterationsDisplayed , iRecurrenceFrequency , iMonthlyOccurrenceType , iDayOfMonth , iWeekDayOfMonth , iWeekDay , 0 isCached , sEventStartTime , sEventEndTime FROM ctm_CalendarEvent with (nolock) WHERE IsNull(bActive, 0) <> 0 AND ((iObjType = 3 AND hObjPointer = 144261 ) or hMy in (select hCalEvent from CalEventPropXRef where hProperty = 144261)) AND dtStartdate <= convert(datetime, '05/07/2021', 101) AND (dtEndDate Is Null OR dtEndDate >= convert(datetime, '05/07/2021', 101)) AND bShowOnCommunity <> 0 ORDER BY dtEventdate ASC 0.020.0420Not Cached YSI.Cafe.RC.Library.ContentClasses.CommunityCalendarEvents
GetCalendarEvents
74
58 SELECT w.sPostBody PostBody, isnull(s.sDisplayName, pm.ObjFirstName + ' ' + pm.ObjLastName) AuthorName ,isnull(wcc.wallpostcount,0) wallCommentcount ,w.dtCreated dateCreated FROM ctm_WallPosts w INNER JOIN PmUserex pm on pm.hMy = w.hUserCreatedBy left join pmuserex_settings s on s.hPmUserex = pm.hMy left Join ( SELECT wc.hWallPost , count(wc.hWallPost) wallpostcount FROM ctm_WallPostComments wc INNER JOIN PmUserex pm on pm.hMy = wc.hUserCreatedBy inner join ctm_WallPosts w on w.hMy = wc.hWallPost AND wc.iStatus = 1 AND w.iStatus = 1 group by wc.hWallPost) wcc on wcc.hWallPost = w.hmy WHERE w.hProperty = 144261 AND w.iStatus = 1 ORDER BY w.hmy DESC0.0090.00910Not Cached YSI.Cafe.RC.Library.ContentClasses.CommunityWallPost
CommunityWallpostsDT
105
59select 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.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.AddressBlock
GetData
193
60 Select sLink Link , sCaption Caption From ctm_footerlinks where htheme = 344 0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.FooterSection
GetLinks
84
61 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.0080.00810Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.FooterSection
GetLinks
103
62select itype from ctm_itype where sName='Footer Image'0.0080.00810Not Cached YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
94
63 select iWidth, iHeight from ctm_imageDimensions where iType = 29 and hTheme = 3440.0060.00610Not Cached YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
115
64 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
65;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.0060.00610Not Cached YSI.Cafe.RC.Library.AppClasses.SchemaMarkupJSONLD
PopulatePrivateVariables
342
66SELECT 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('community.aspx') WHERE nudge.hObjPointer = 84065 AND nudge.hObjType = 2 AND ISNULL(bArchived,0) <> 1 AND (LOWER(nudgepages.sPageName) = LOWER('community.aspx') OR nudge.iAnypage = 1) AND (nudge.bEnabled = 1 OR (nudge.bEnabled = 3 AND (CONVERT(date, getdate()) BETWEEN nudge.scheduleFrom AND nudge.scheduleTo)) )0.0080.00810Not Cached YSI.Cafe.RC.Library.ContentClasses.companynudgemarketingpopup
getNudgeData
288
67SELECT 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('community.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('community.aspx') OR nudge.iAnypage = 1) AND (nudge.bEnabled = 1 OR (nudge.bEnabled = 3 AND (CONVERT(date, getdate()) BETWEEN nudge.scheduleFrom AND nudge.scheduleTo)) )0.0080.00810Not Cached YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup
getNudgeData
366
68select 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
69select * 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
70select * FROM ctm_CustomMarketingContent cmc WHERE cmc.iObjType = 3 AND cmc.hObjPointer = 144261 AND cmc.bEnable = 1 AND cmc.iTrackingType = 110.0080.00810Not Cached YSI.Cafe.RC.Library.AppClasses.ThemeScripting
GetContent
196
71Select 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.0070.00710Not Cached YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative
ReplaceParamsData
237
72 Select hMy from ctm_ContentClass where sContentClass = 'portalcookiepolicy' 0.0060.00610Not Cached YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative
GetCookiePolicyLinkPageName
350
73 SELECT TOP(1) 1 FROM ctm_Section WHERE hContentClass = 110 AND ((iObjType = 3 And hObjPointer = 144261) OR (iObjType = 2 And hObjPointer = 84065))0.0070.00710Not Cached YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative
GetCookiePolicyLinkPageName
361
74select sGoogleSiteVerification from ylsPropertyMaster where hProperty = 1442610.0080.00810Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
CTM_GetPropertyInfo
797
75select 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.0070.00710Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomCSS
1130
76select 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.0050.00510Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomCSS
1150
77select 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
78select 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.0080.00810Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomJS
1232