FPA live

Welcome to Cafe Malta

Test Description

 

test

test body

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

TOTAL QUERIES: 76

TOTAL TIME TAKEN FOR ENTIRE REQUEST: 1.272 seconds

OrderQueryTime Taken Each (seconds)Total Time Taken (seconds)Number of TimesNumber of Cache HitsCachedCalling Class
0select 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.0020.00211Cached Result YSI.Cafe.RC.PropertySiteContent.RCPropertySite
ReadParams
394
1select 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
2SELECT bEnableForMVC FROM ctm_PropertyConfig WHERE hProperty = 1442610.0140.01410Not Cached YSI.Cafe.RC.PropertySiteContent.RCPropertySite
ReadParams
633
3 select isNull(hTheme, 0) hTheme from portal where sSiteName = 'cafe-malta' and hobjecttype = 3 0.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.RCPropertySite
DoLoad
131
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.0090.00910Not 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.0050.00510Not 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.0090.00910Not Cached 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 0.0090.00910Not Cached 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' 0.0060.00610Not Cached YSI.Cafe.Systems.PluginManager
LoadCafePlugins
187
9select iCafeType from property where hmy = 144261 0.0070.00710Not Cached 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 0.0080.01621Cached Result YSI.Cafe.Systems.ysiPortalSettings
Read
306
11Select iThemeType From ctm_theme where hMy = 3440.0140.01410Not Cached 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'0.0090.00910Not Cached 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 = 1442610.0080.00810Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCompanyFooterText
1337
14select sFooterTextRentcafe from ctm_globalsettings0.0060.00610Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
CTM_GetGlobalInfo
728
15select sDomainName from ctm_globalsettings0.0130.01310Not Cached 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 'index.aspx%'0.0120.0654Cached Result YSI.Cafe.RC.Library.Utils.rcUtils
GetContentClassFromMenu
5022
17 select top 1 isNULL(sContentClass,'') ContentClass, ISNULL(sContentAssembly, '') ContentAssembly, ISNULL(sContentNamespace, '') ContentNamespace from ctm_themeMenuItem where hThemeMenu=85663 and sLink like 'home.aspx%'0.010.0554Cached Result YSI.Cafe.RC.Library.Utils.rcUtils
GetContentClassFromMenu
5037
18SELECT TOP 1 hmy, sDescription FROM ctm_contentclass WHERE lower(sContentClass) = 'index' 0.0070.03554Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag
getContentClass
792
19 select mi.hSection from ctm_thememenuitem mi where mi.hThemeMenu = 85663 and mi.sLink like 'index.aspx%'0.0080.00810Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag
GetContent
183
20 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.0170.01710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag
GetContent
261
21 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.0070.00710Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.GoogleAnalytics
GetContent
159
22 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
23 Select * from ctm_custommarketingcontent where iobjtype = 3 And hobjpointer = 144261 And isnull(benable, 0) = 1 And iCodeLocation = 1 And ( ipageType = 1 Or ipageType = 2 ) 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.010.0110Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetPageScripts
681
24 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.0130.03932Cached Result YSI.Cafe.RC.Library.ContentClasses.PageScripts
IntHideEqualHousingLogoJs
744
25 select iWidth, iHeight from ctm_imageDimensions where iType = 125 and hTheme = 3440.010.0110Not Cached YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
115
26select bUseCloudinary from ctm_DomainMappings where hObjPointer = 84065 and hObjectType = 2 and url = 'malta1.reslisting.com'0.0150.0321Cached Result YSI.Cafe.Systems.Cloudinary
UsingCloudinary
150
27 Select * from ctm_custommarketingcontent where iobjtype = 3 And hobjpointer = 144261 And isnull(benable, 0) = 1 And iCodeLocation = 2 And ( ipageType = 1 Or ipageType = 2 ) 0.0110.01110Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetPageScripts
681
28 select sTrackingCode, iTrackingType from ctm_CustomMarketingContent with (nolock,nowait) where iObjType=3 And hObjPointer=144261 And iTrackingType in (8, 12) And hPortalID = 0 0.0080.00810Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.GoogleAnalytics
GetContent
159
29select 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.0110.01110Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetContent
134
30select * from ctm_PropertySettings WITH(NOLOCK) where hObjPointer = 0 and hSettingType = 10.0090.04554Cached Result YSI.Cafe.RC.Library.PropertySettings
SetSystemDefaultValuesFromDB
570
31select 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.0454Cached Result YSI.Cafe.RC.Library.PropertySettings
Read
717
32select * from ctm_PropertySettings WITH(NOLOCK) where ( (hObjPointer = 144261 and hsettingtype=4) or (hObjPointer = 84065 and hsettingtype=2))0.0140.0754Cached Result YSI.Cafe.RC.Library.PropertySettings
Read
747
33SELECT COUNT(*) num FROM AdWordsClients WHERE hPropertyId = 144261 And bActive = 10.0090.00910Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetContent
510
34SELECT 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.0070.00710Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetContent
520
35SELECT sFloorPlanAssistantButtonLabel, sFloorPlanAssistantTagline, sFloorPlanThemeColor, dFloorPlanColorOpacity, sFloorPlanAssistantDockSide FROM ctm_propertyconfig WHERE hProperty = 144261 0.0060.00610Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetFloorPlanAssistantSettings
772
36SELECT 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
37select 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
38select itype from ctm_itype where sName='Property Logo'0.0070.00710Not Cached YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
94
39 select iWidth, iHeight from ctm_imageDimensions where iType = 6 and hTheme = 3440.0060.00610Not Cached YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
115
40SELECT iVideoStatus FROM ctm_VideoEmbed WHERE hProperty=144261AND hFloorplan IS NULL0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu
GetContent
92
41 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
42 SELECT IsNull(hPropMgmtCompany, 0) FROM property with (nolock) WHERE hmy = 144261 0.0060.01832Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu
GetContent
129
43 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 = 'index.aspx' 0.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu
getpageID
256
44select 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.0160.01610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine
GetContent
38
45 select * from taglinesettings where hobjpointer=144261 and hsettingtype=3 0.0150.01510Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine
GetContent
49
46 select * from taglinesettings ts where ts.hObjPointer = 84065 and ts.hTheme =344 0.0080.00810Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine
GetContent
108
47 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.0090.00910Not Cached YSI.Cafe.RC.Library.Utils.RentCafeUtils
GetActiveImages
1472
48select 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
49select 'Welcome to ' + p.sAddr1 from property p where hmy = 1442610.0060.00610Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.IndexSection
GetContent
145
50SELECT bEnableStudentHousing FROM stuProperty WHERE hMyProperty = 1442610.0040.00410Not Cached YSI.Cafe.RC.Library.Utils.RentCafeUtils
IsFlexSubType
13007
51 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 0.0080.00810Not Cached YSI.Cafe.RC.Library.Utils.RentCafeUtils
IsLegacy
13063
52 Select 1 from SpamIPAddr where sIPAddress = '3.238.130.97'0.0040.00410Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.contactus
DoGetContent
280
53select 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.01832Cached Result YSI.Cafe.RC.PropertySiteContent.ContentClasses.AddressBlock
GetData
193
54select sGoogleMapsListingLink from ctm_PropertyConfig where hproperty=1442610.0040.00410Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.ContatcUsOfficeHoursAndPropAddress
RenderContactUsLayout1RHS
66
55 Select bShortOfficeHoursFormat From ctm_param_master where hProperty = 144261 0.0040.00820Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.ContatcUsOfficeHoursAndPropAddress
RenderContactUsLayout1RHS
76
56select isnull(bSupressOfficeHours,0) from ctm_PropertyConfig where hProperty = 144261 0.0080.01621Cached Result YSI.Cafe.RC.Library.Utils.RentCafeUtils
isOfficeHoursSuppressed
4107
57 Select sLink Link , sCaption Caption From ctm_footerlinks where htheme = 344 0.0130.01310Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.FooterSection
GetLinks
84
58 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.0120.01210Not Cached YSI.Cafe.RC.PropertySiteContent.ContentClasses.FooterSection
GetLinks
103
59select itype from ctm_itype where sName='Footer Image'0.0070.00710Not Cached YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
94
60 select iWidth, iHeight from ctm_imageDimensions where iType = 29 and hTheme = 3440.0070.00710Not Cached YSI.Cafe.RC.Library.AppClasses.Image
ReadParams
115
61 Select * from ctm_custommarketingcontent where iobjtype = 3 And hobjpointer = 144261 And isnull(benable, 0) = 1 And iCodeLocation = 3 And ( ipageType = 1 Or ipageType = 2 ) 0.0070.00710Not Cached YSI.Cafe.RC.Library.ContentClasses.PageScripts
GetPageScripts
681
62;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.0090.00910Not Cached YSI.Cafe.RC.Library.AppClasses.SchemaMarkupJSONLD
PopulatePrivateVariables
342
63SELECT 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('index.aspx') WHERE nudge.hObjPointer = 84065 AND nudge.hObjType = 2 AND ISNULL(bArchived,0) <> 1 AND (LOWER(nudgepages.sPageName) = LOWER('index.aspx') OR nudge.iAnypage = 1) AND (nudge.bEnabled = 1 OR (nudge.bEnabled = 3 AND (CONVERT(date, getdate()) BETWEEN nudge.scheduleFrom AND nudge.scheduleTo)) )0.0140.01410Not Cached YSI.Cafe.RC.Library.ContentClasses.companynudgemarketingpopup
getNudgeData
288
64SELECT 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('index.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('index.aspx') OR nudge.iAnypage = 1) AND (nudge.bEnabled = 1 OR (nudge.bEnabled = 3 AND (CONVERT(date, getdate()) BETWEEN nudge.scheduleFrom AND nudge.scheduleTo)) )0.020.0210Not Cached YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup
getNudgeData
366
65select 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.020.0210Not Cached YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup
BuildFormLeads
850
66select * FROM ctm_CustomMarketingContent cmc WHERE cmc.iObjType = 3 AND cmc.hObjPointer = 144261 AND cmc.bEnable = 1 AND cmc.iTrackingType = 11 0.010.0110Not Cached YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup
IsGTAGUsedForGoogleAnalyic
1009
67select * FROM ctm_CustomMarketingContent cmc WHERE cmc.iObjType = 3 AND cmc.hObjPointer = 144261 AND cmc.bEnable = 1 AND cmc.iTrackingType = 110.0060.00610Not Cached YSI.Cafe.RC.Library.AppClasses.ThemeScripting
GetContent
196
68Select 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.0140.01410Not Cached YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative
ReplaceParamsData
237
69 Select hMy from ctm_ContentClass where sContentClass = 'portalcookiepolicy' 0.0180.01810Not Cached YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative
GetCookiePolicyLinkPageName
350
70 SELECT TOP(1) 1 FROM ctm_Section WHERE hContentClass = 110 AND ((iObjType = 3 And hObjPointer = 144261) OR (iObjType = 2 And hObjPointer = 84065))0.0180.01810Not Cached YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative
GetCookiePolicyLinkPageName
361
71select sGoogleSiteVerification from ylsPropertyMaster where hProperty = 1442610.0130.01310Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
CTM_GetPropertyInfo
797
72select 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.010.0110Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomCSS
1130
73select 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.0110.01110Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomCSS
1150
74select 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.0610.06110Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomJS
1212
75select 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.010.0110Not Cached YSI.Cafe.BaseCafePage.ysiCtmLibrary
GetCustomJS
1232