FPA live

Welcome to Cafe Malta

Test Description

 

test

test body

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

TOTAL QUERIES: 75

TOTAL TIME TAKEN FOR ENTIRE REQUEST: 0.661 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.0040.00410Not 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.0010.00111Cached Result YSI.Cafe.RC.PropertySiteContent.RCPropertySite
ReadParams
394
2select 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'0011Cached Result YSI.Cafe.RC.PropertySiteContent.RCPropertySite
ReadParams
595
3SELECT bEnableForMVC FROM ctm_PropertyConfig WHERE hProperty = 1442610.0010.00111Cached Result YSI.Cafe.RC.PropertySiteContent.RCPropertySite
ReadParams
633
4 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 = 1 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.0440.04410Not Cached YSI.Cafe.RC.PropertySiteContent.RCPropertySite
doThemeSite
1330
5select 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
6Select hMy from ctm_themeMenu where isNull(hPortal,0) <> 0 And hPortal = 143941 And hThemeTemplateType = 1 And isNull(bInActiveCustomMenu,0) = 0 0.0030.00311Cached Result YSI.Cafe.RC.Library.Utils.RentCafeUtils
GetThemeMenuId
1272
7select 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 0011Cached Result YSI.Cafe.Systems.PluginManager
LoadCafePlugins
168
8 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' 0011Cached Result YSI.Cafe.Systems.PluginManager
LoadCafePlugins
187
9select iCafeType from property where hmy = 144261 0011Cached Result YSI.Cafe.Systems.PluginManager
SetPluginRoot
78
10 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 0022Cached Result YSI.Cafe.Systems.ysiPortalSettings
Read
306
11Select iThemeType From ctm_theme where hMy = 3440011Cached Result YSI.Cafe.Systems.ysiPortalSettings
SetTemplatePathForPrivateTheme
531
12select 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'0011Cached Result YSI.Cafe.Systems.ysiPortalSettings
SetTemplatePathForCorporateListing
622
13 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 = 1442610011Cached Result YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCompanyFooterText
1337
14select sFooterTextRentcafe from ctm_globalsettings0011Cached Result YSI.Cafe.BaseCafePage.ysiCtmLibrary
CTM_GetGlobalInfo
728
15select sDomainName from ctm_globalsettings0011Cached Result YSI.Cafe.BaseCafePage.ysiCtmLibrary
CTM_GetGlobalInfo
728
16 select top 1 isNULL(sContentClass,'') ContentClass, ISNULL(sContentAssembly, '') ContentAssembly, ISNULL(sContentNamespace, '') ContentNamespace from ctm_themeMenuItem where hThemeMenu=85663 and sLink like 'home.aspx%'0.0070.03554Cached Result YSI.Cafe.RC.Library.Utils.rcUtils
GetContentClassFromMenu
5022
17SELECT TOP 1 hmy, sDescription FROM ctm_contentclass WHERE lower(sContentClass) = 'index' 0.0080.0454Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag
getContentClass
792
18 select mi.hSection from ctm_thememenuitem mi where mi.hThemeMenu = 85663 and mi.sLink like 'home.aspx%'0.0090.00910Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag
GetContent
183
19 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 = 40 and s.hLanguage in (0, 27, 28, 0) ORDER BY cm.hlanguage DESC, cm.hmy DESC, s.hlanguage DESC0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag
GetContent
261
20 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.0020.00211Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.GoogleAnalytics
GetContent
159
21 select hmy from ctm_thememenu where 1=1 and bInActiveCustomMenu = 0 and sCode = 'CustomMenu_144261' 0022Cached Result YSI.Cafe.RC.Library.Utils.ClickTrack
GetContentObject
186
22 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.0010.00111Cached Result YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetPageScripts
681
23 Select ci.SCODE FROM Property P With (nolock) inner join country_info CI With (nolock) On P.HCOUNTRY = ci.HMY where P.hmy = 144261 0033Cached Result YSI.Cafe.RC.Library.ContentClasses.PageScripts
IntHideEqualHousingLogoJs
744
24 select iWidth, iHeight from ctm_imageDimensions where iType = 125 and hTheme = 3440011Cached Result YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
115
25select bUseCloudinary from ctm_DomainMappings where hObjPointer = 84065 and hObjectType = 2 and url = 'malta1.reslisting.com'0022Cached Result YSI.Cafe.Systems.Cloudinary
UsingCloudinary
150
26 Select * from ctm_custommarketingcontent where iobjtype = 3 And hobjpointer = 144261 And isnull(benable, 0) = 1 And iCodeLocation = 2 And ( ipageType = 1 ) 0.0010.00111Cached Result YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetPageScripts
681
27 select sTrackingCode, iTrackingType from ctm_CustomMarketingContent with (nolock,nowait) where iObjType=3 And hObjPointer=144261 And iTrackingType in (8, 12) And hPortalID = 0 0.0010.00111Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.GoogleAnalytics
GetContent
159
28select 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.0030.00311Cached Result YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetContent
134
29select * from ctm_PropertySettings WITH(NOLOCK) where hObjPointer = 0 and hSettingType = 10.0010.00555Cached Result YSI.Cafe.RC.Library.PropertySettings
SetSystemDefaultValuesFromDB
570
30select 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=1442610055Cached Result YSI.Cafe.RC.Library.PropertySettings
Read
717
31select * from ctm_PropertySettings WITH(NOLOCK) where ( (hObjPointer = 144261 and hsettingtype=4) or (hObjPointer = 84065 and hsettingtype=2))0.0020.0155Cached Result YSI.Cafe.RC.Library.PropertySettings
Read
747
32SELECT COUNT(*) num FROM AdWordsClients WHERE hPropertyId = 144261 And bActive = 10011Cached Result YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetContent
510
33SELECT 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 = 1442610011Cached Result YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetContent
520
34SELECT sFloorPlanAssistantButtonLabel, sFloorPlanAssistantTagline, sFloorPlanThemeColor, dFloorPlanColorOpacity, sFloorPlanAssistantDockSide FROM ctm_propertyconfig WHERE hProperty = 144261 0011Cached Result YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetFloorPlanAssistantSettings
772
35SELECT TOP 1 * FROM ctm_DocMgrXRef WHERE hProperty = 144261 AND iType = 134 AND bInActive = 00.0030.00311Cached Result YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetFloorPlanAssistantSettings
792
36select bUseCloudinary from ctm_DomainMappings where hObjPointer = 144261 and hObjectType = 3 and url = 'malta1.reslisting.com'0033Cached Result YSI.Cafe.Systems.Cloudinary
UsingCloudinary
150
37select itype from ctm_itype where sName='Property Logo'0011Cached Result YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
94
38 select iWidth, iHeight from ctm_imageDimensions where iType = 6 and hTheme = 3440011Cached Result YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
115
39SELECT iVideoStatus FROM ctm_VideoEmbed WHERE hProperty=144261AND hFloorplan IS NULL0011Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu
GetContent
92
40 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.0010.00111Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu
GetContent
115
41 SELECT IsNull(hPropMgmtCompany, 0) FROM property with (nolock) WHERE hmy = 144261 0033Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu
GetContent
129
42 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 = 'home.aspx' 0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu
getpageID
256
43select 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 0011Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine
GetContent
38
44 select * from taglinesettings where hobjpointer=144261 and hsettingtype=3 0011Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine
GetContent
49
45 select * from taglinesettings ts where ts.hObjPointer = 84065 and ts.hTheme =344 0011Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine
GetContent
108
46 select 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 ,'' Video1, '' Video2, '' Video3, 0 ReplaceImage , 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 = 10 and dx.iObjType = 3 and dx.hObjPointer = 144261 and isnull(dx.iDelete,0) = 0 and isnull(dx.bInActive,0) = 0 UNION ALL select top 1 sAlias, DocMgrXrefId,DocMgrId,FileName,FileWidth,sTitle, sDesc,sCaption, sImageDescription,FileHeight,FileSize, FileOrder,ImageParams, cropx, cropy, croph, cropw, FileDocMgrCategory,ObjectType, ObjectId,Video1,Video2,Video3,ReplaceImage,itype, ismedialibrary, contenttype,imagetype,hParent from ( select isnull(Dx1.sAlias,'') sAlias , Dx1.hmy DocMgrXrefId ,D1.hmy DocMgrId ,isnull(D1.sFile,'') FileName ,isnull(D1.iWidth,0) FileWidth ,isnull(Dx1.sTitle,'') sTitle , isnull(Dx1.sDesc,'') sDesc ,isnull(Dx1.sCaption,'') sCaption, isnull(Dx1.sImageDescription,'') sImageDescription, isnull(D1.iHeight,0) FileHeight ,isnull(D1.iSize,0) FileSize ,isnull(Dx1.iOrder,0) FileOrder ,isnull(Dx1.sModificationParams,'') ImageParams, isnull(Dx1.cropX,'') cropX , isnull(Dx1.cropY,'') cropY , isnull(Dx1.cropH,'') cropH, isnull(Dx1.cropW,'') cropW ,isnull(Dx1.hDocMgrCategory,0) FileDocMgrCategory ,dx1.iobjtype ObjectType ,dx1.hobjpointer ObjectId ,sVideoPath1 Video1 ,sVideoPath2 Video2 ,sVideoPath3 Video3 , isnull(vs.breplaceimage,0) ReplaceImage, dx1.itype iType , dx1.bMediaLibrary IsMediaLibrary, dx1.scontenttype contenttype ,dx1.sextension imagetype ,dx1.hParent from VideoSlider vs inner join ctm_docmgrxref Dx1 on vs.hDocMgrxref=dx1.hmy and dx1.iObjType = vs.iObjType and dx1.hObjPointer = vs.hObjPointer inner join ctm_docmgr D1 on DX1.hdocmgr=D1.hmy where vs.itype = 10 and vs.iObjType = 3 and vs.hObjPointer = 144261 And isnull(dx1.iDelete,0) = 0 And isnull(dx1.bInActive,0) = 0 UNION ALL select isnull(dx2.sAlias,'') sAlias ,dx2.hmy DocMgrXrefId ,D2.hmy DocMgrId ,isnull(D2.sFile,'') FileName ,isnull(D2.iWidth,0) FileWidth ,isnull(dx2.sTitle,'') sTitle , isnull(dx2.sDesc,'') sDesc ,isnull(dx2.sCaption,'') sCaption, isnull(dx2.sImageDescription,'') sImageDescription, isnull(D2.iHeight,0) FileHeight ,isnull(D2.iSize,0) FileSize ,isnull(dx2.iOrder,0) FileOrder ,isnull(dx2.sModificationParams,'') ImageParams , isnull(Dx2.cropX,'') cropX , isnull(Dx2.cropY,'') cropY , isnull(Dx2.cropH,'') cropH, isnull(Dx2.cropW,'') cropW ,isnull(dx2.hDocMgrCategory,0) FileDocMgrCategory ,dx2.iobjtype ObjectType ,dx2.hobjpointer ObjectId ,sVideoPath1 Video1 ,sVideoPath2 Video2 ,sVideoPath3 Video3 , isnull(vs1.breplaceimage,0) ReplaceImage, dx2.itype iType , dx2.bMediaLibrary IsMediaLibrary, dx2.scontenttype contenttype ,dx2.sextension imagetype ,dx2.hParent from ctm_docmgrxref dx2 inner join ctm_docmgr D2 on dx2.hdocmgr=D2.hmy and dx2.itype=128 and Dx2.hparent<>0 and dx2.iObjType = 3 and dx2.hObjPointer = 144261 inner join VideoSlider vs1 on vs1.hDocMgrxref=dx2.hparent where isnull(dx2.iDelete,0) = 0 And isnull(dx2.bInActive,0) = 0 ) test order by FileOrder , DocMgrXrefId 0.0080.00810Not Cached YSI.Cafe.RC.Library.Utils.RentCafeUtils
GetActiveImages
1472
47select top 1 s.sData InnerHtmlString, s.sName Title from ctm_section s inner join ctm_contentclass c on c.hmy = s.hContentClass where hObjPointer = 144261 and s.iObjType = 3 and c.sContentClass = 'IndexSection' order by iOrder asc 0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.IndexSection
GetContent
108
48select 'Welcome to ' + p.sAddr1 from property p where hmy = 1442610.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.IndexSection
GetContent
145
49SELECT bEnableStudentHousing FROM stuProperty WHERE hMyProperty = 1442610.0040.00410Not Cached YSI.Cafe.RC.Library.Utils.RentCafeUtils
IsFlexSubType
13007
50 Select isnull(pc.iContactUsLayout,0) OLELayoutProperty ,isnull(y.iContactUsLayout,0) OLELayoutCompany from Property p inner join ylspropmgmtcompany y on p.hPropmgmtcompany = y.hmy inner join ctm_propertyconfig pc on pc.hProperty = p.hmy where p.hmy = 144261 0011Cached Result YSI.Cafe.RC.Library.Utils.RentCafeUtils
IsLegacy
13063
51 Select 1 from SpamIPAddr where sIPAddress = '3.238.130.97'0.0050.00510Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.contactus
DoGetContent
280
52select 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 = 1442610022Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.AddressBlock
GetData
193
53select sGoogleMapsListingLink from ctm_PropertyConfig where hproperty=1442610.0040.00410Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.ContatcUsOfficeHoursAndPropAddress
RenderContactUsLayout1RHS
66
54 Select bShortOfficeHoursFormat From ctm_param_master where hProperty = 144261 0.0040.00820Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.ContatcUsOfficeHoursAndPropAddress
RenderContactUsLayout1RHS
76
55select isnull(bSupressOfficeHours,0) from ctm_PropertyConfig where hProperty = 144261 0.0070.01421Cached Result YSI.Cafe.RC.Library.Utils.RentCafeUtils
isOfficeHoursSuppressed
4107
56 Select sLink Link , sCaption Caption From ctm_footerlinks where htheme = 344 0011Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.FooterSection
GetLinks
84
57 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.0010.00111Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.FooterSection
GetLinks
103
58select itype from ctm_itype where sName='Footer Image'0.0030.00311Cached Result YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
94
59 select iWidth, iHeight from ctm_imageDimensions where iType = 29 and hTheme = 3440011Cached Result YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
115
60 Select * from ctm_custommarketingcontent where iobjtype = 3 And hobjpointer = 144261 And isnull(benable, 0) = 1 And iCodeLocation = 3 And ( ipageType = 1 ) 0.0020.00211Cached Result YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetPageScripts
681
61;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 0011Cached Result YSI.Cafe.RC.Library.AppClasses.SchemaMarkupJSONLD
PopulatePrivateVariables
342
62SELECT 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('home.aspx') WHERE nudge.hObjPointer = 84065 AND nudge.hObjType = 2 AND ISNULL(bArchived,0) <> 1 AND (LOWER(nudgepages.sPageName) = LOWER('home.aspx') OR nudge.iAnypage = 1) AND (nudge.bEnabled = 1 OR (nudge.bEnabled = 3 AND (CONVERT(date, getdate()) BETWEEN nudge.scheduleFrom AND nudge.scheduleTo)) )0.0090.00910Not Cached YSI.Cafe.RC.Library.ContentClasses.companynudgemarketingpopup
getNudgeData
288
63SELECT 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('home.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('home.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
64select 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.0010.00111Cached Result YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup
BuildFormLeads
850
65select * FROM ctm_CustomMarketingContent cmc WHERE cmc.iObjType = 3 AND cmc.hObjPointer = 144261 AND cmc.bEnable = 1 AND cmc.iTrackingType = 11 0011Cached Result YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup
IsGTAGUsedForGoogleAnalyic
1009
66select * FROM ctm_CustomMarketingContent cmc WHERE cmc.iObjType = 3 AND cmc.hObjPointer = 144261 AND cmc.bEnable = 1 AND cmc.iTrackingType = 110011Cached Result YSI.Cafe.RC.Library.AppClasses.ThemeScripting
GetContent
196
67Select 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.0010.00111Cached Result YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative
ReplaceParamsData
237
68 Select hMy from ctm_ContentClass where sContentClass = 'portalcookiepolicy' 0011Cached Result YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative
GetCookiePolicyLinkPageName
350
69 SELECT TOP(1) 1 FROM ctm_Section WHERE hContentClass = 110 AND ((iObjType = 3 And hObjPointer = 144261) OR (iObjType = 2 And hObjPointer = 84065))0011Cached Result YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative
GetCookiePolicyLinkPageName
361
70select sGoogleSiteVerification from ylsPropertyMaster where hProperty = 1442610011Cached Result YSI.Cafe.BaseCafePage.ysiCtmLibrary
CTM_GetPropertyInfo
797
71select 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 = 1 and p.hMy = 143941 AND ISNULL(c.hsettingstemplate, 0) = 0 order by c.hmy desc 0.0080.00810Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomCSS
1130
72select 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 = 1 and p.hMy = 143941 order by c.hmy desc0.0070.00710Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomCSS
1150
73select 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 = 1 and p.hMy = 143941 AND ISNULL(c.hsettingstemplate, 0) = 0 0.0070.00710Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomJS
1212
74select 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 = 1 and p.hMy = 1439410.0070.00710Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomJS
1232