TOTAL QUERIES: 76
TOTAL TIME TAKEN FOR ENTIRE REQUEST: 1.272 seconds
| Order | Query | Time Taken Each (seconds) | Total Time Taken (seconds) | Number of Times | Number of Cache Hits | Cached | Calling Class |
|---|---|---|---|---|---|---|---|
| 0 | select 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.002 | 0.002 | 1 | 1 | Cached Result | YSI.Cafe.RC.PropertySiteContent.RCPropertySite ReadParams 394 |
| 1 | select 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.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.RCPropertySite ReadParams 595 |
| 2 | SELECT bEnableForMVC FROM ctm_PropertyConfig WHERE hProperty = 144261 | 0.014 | 0.014 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.RCPropertySite ReadParams 633 |
| 3 | select isNull(hTheme, 0) hTheme from portal where sSiteName = 'cafe-malta' and hobjecttype = 3 | 0.007 | 0.007 | 1 | 0 | Not 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.009 | 0.009 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.RCPropertySite doThemeSite 1330 |
| 5 | select 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 = 144261 | 0.005 | 0.005 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.Utils.rcUtils GetPropertyAddress 114 |
| 6 | Select hMy from ctm_themeMenu where isNull(hPortal,0) <> 0 And hPortal = 143941 And hThemeTemplateType = 1 And isNull(bInActiveCustomMenu,0) = 0 | 0.009 | 0.009 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.Utils.RentCafeUtils GetThemeMenuId 1272 |
| 7 | select 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.009 | 0.009 | 1 | 0 | Not 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.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.Systems.PluginManager LoadCafePlugins 187 |
| 9 | select iCafeType from property where hmy = 144261 | 0.007 | 0.007 | 1 | 0 | Not 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.008 | 0.016 | 2 | 1 | Cached Result | YSI.Cafe.Systems.ysiPortalSettings Read 306 |
| 11 | Select iThemeType From ctm_theme where hMy = 344 | 0.014 | 0.014 | 1 | 0 | Not Cached | YSI.Cafe.Systems.ysiPortalSettings SetTemplatePathForPrivateTheme 531 |
| 12 | select 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.009 | 0.009 | 1 | 0 | Not 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 = 144261 | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary GetCompanyFooterText 1337 |
| 14 | select sFooterTextRentcafe from ctm_globalsettings | 0.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary CTM_GetGlobalInfo 728 |
| 15 | select sDomainName from ctm_globalsettings | 0.013 | 0.013 | 1 | 0 | Not 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.012 | 0.06 | 5 | 4 | Cached 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.01 | 0.05 | 5 | 4 | Cached Result | YSI.Cafe.RC.Library.Utils.rcUtils GetContentClassFromMenu 5037 |
| 18 | SELECT TOP 1 hmy, sDescription FROM ctm_contentclass WHERE lower(sContentClass) = 'index' | 0.007 | 0.035 | 5 | 4 | Cached 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.008 | 0.008 | 1 | 0 | Not 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 DESC | 0.017 | 0.017 | 1 | 0 | Not 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.007 | 0.007 | 1 | 0 | Not 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.007 | 0.014 | 2 | 1 | Cached 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 = 12 | 0.01 | 0.01 | 1 | 0 | Not 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.013 | 0.039 | 3 | 2 | Cached Result | YSI.Cafe.RC.Library.ContentClasses.PageScripts IntHideEqualHousingLogoJs 744 |
| 25 | select iWidth, iHeight from ctm_imageDimensions where iType = 125 and hTheme = 344 | 0.01 | 0.01 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.Image ReadParams 115 |
| 26 | select bUseCloudinary from ctm_DomainMappings where hObjPointer = 84065 and hObjectType = 2 and url = 'malta1.reslisting.com' | 0.015 | 0.03 | 2 | 1 | Cached 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.011 | 0.011 | 1 | 0 | Not 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.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.GoogleAnalytics GetContent 159 |
| 29 | select 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.011 | 0.011 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.PageScripts GetContent 134 |
| 30 | select * from ctm_PropertySettings WITH(NOLOCK) where hObjPointer = 0 and hSettingType = 1 | 0.009 | 0.045 | 5 | 4 | Cached Result | YSI.Cafe.RC.Library.PropertySettings SetSystemDefaultValuesFromDB 570 |
| 31 | select 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=144261 | 0.008 | 0.04 | 5 | 4 | Cached Result | YSI.Cafe.RC.Library.PropertySettings Read 717 |
| 32 | select * from ctm_PropertySettings WITH(NOLOCK) where ( (hObjPointer = 144261 and hsettingtype=4) or (hObjPointer = 84065 and hsettingtype=2)) | 0.014 | 0.07 | 5 | 4 | Cached Result | YSI.Cafe.RC.Library.PropertySettings Read 747 |
| 33 | SELECT COUNT(*) num FROM AdWordsClients WHERE hPropertyId = 144261 And bActive = 1 | 0.009 | 0.009 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.PageScripts GetContent 510 |
| 34 | SELECT 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 = 144261 | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.PageScripts GetContent 520 |
| 35 | SELECT sFloorPlanAssistantButtonLabel, sFloorPlanAssistantTagline, sFloorPlanThemeColor, dFloorPlanColorOpacity, sFloorPlanAssistantDockSide FROM ctm_propertyconfig WHERE hProperty = 144261 | 0.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.PageScripts GetFloorPlanAssistantSettings 772 |
| 36 | SELECT TOP 1 * FROM ctm_DocMgrXRef WHERE hProperty = 144261 AND iType = 134 AND bInActive = 0 | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.PageScripts GetFloorPlanAssistantSettings 792 |
| 37 | select bUseCloudinary from ctm_DomainMappings where hObjPointer = 144261 and hObjectType = 3 and url = 'malta1.reslisting.com' | 0.007 | 0.021 | 3 | 2 | Cached Result | YSI.Cafe.Systems.Cloudinary UsingCloudinary 150 |
| 38 | select itype from ctm_itype where sName='Property Logo' | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.Image ReadParams 94 |
| 39 | select iWidth, iHeight from ctm_imageDimensions where iType = 6 and hTheme = 344 | 0.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.Image ReadParams 115 |
| 40 | SELECT iVideoStatus FROM ctm_VideoEmbed WHERE hProperty=144261AND hFloorplan IS NULL | 0.006 | 0.006 | 1 | 0 | Not 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.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu GetContent 115 |
| 42 | SELECT IsNull(hPropMgmtCompany, 0) FROM property with (nolock) WHERE hmy = 144261 | 0.006 | 0.018 | 3 | 2 | Cached 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.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu getpageID 256 |
| 44 | select 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.016 | 0.016 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine GetContent 38 |
| 45 | select * from taglinesettings where hobjpointer=144261 and hsettingtype=3 | 0.015 | 0.015 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine GetContent 49 |
| 46 | select * from taglinesettings ts where ts.hObjPointer = 84065 and ts.hTheme =344 | 0.008 | 0.008 | 1 | 0 | Not 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.009 | 0.009 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.Utils.RentCafeUtils GetActiveImages 1472 |
| 48 | select 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.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.IndexSection GetContent 108 |
| 49 | select 'Welcome to ' + p.sAddr1 from property p where hmy = 144261 | 0.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.IndexSection GetContent 145 |
| 50 | SELECT bEnableStudentHousing FROM stuProperty WHERE hMyProperty = 144261 | 0.004 | 0.004 | 1 | 0 | Not 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.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.Utils.RentCafeUtils IsLegacy 13063 |
| 52 | Select 1 from SpamIPAddr where sIPAddress = '3.238.130.97' | 0.004 | 0.004 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.contactus DoGetContent 280 |
| 53 | select 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 = 144261 | 0.006 | 0.018 | 3 | 2 | Cached Result | YSI.Cafe.RC.PropertySiteContent.ContentClasses.AddressBlock GetData 193 |
| 54 | select sGoogleMapsListingLink from ctm_PropertyConfig where hproperty=144261 | 0.004 | 0.004 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.ContatcUsOfficeHoursAndPropAddress RenderContactUsLayout1RHS 66 |
| 55 | Select bShortOfficeHoursFormat From ctm_param_master where hProperty = 144261 | 0.004 | 0.008 | 2 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.ContatcUsOfficeHoursAndPropAddress RenderContactUsLayout1RHS 76 |
| 56 | select isnull(bSupressOfficeHours,0) from ctm_PropertyConfig where hProperty = 144261 | 0.008 | 0.016 | 2 | 1 | Cached Result | YSI.Cafe.RC.Library.Utils.RentCafeUtils isOfficeHoursSuppressed 4107 |
| 57 | Select sLink Link , sCaption Caption From ctm_footerlinks where htheme = 344 | 0.013 | 0.013 | 1 | 0 | Not 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.012 | 0.012 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.FooterSection GetLinks 103 |
| 59 | select itype from ctm_itype where sName='Footer Image' | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.Image ReadParams 94 |
| 60 | select iWidth, iHeight from ctm_imageDimensions where iType = 29 and hTheme = 344 | 0.007 | 0.007 | 1 | 0 | Not 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.007 | 0.007 | 1 | 0 | Not 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.009 | 0.009 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.SchemaMarkupJSONLD PopulatePrivateVariables 342 |
| 63 | SELECT 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.014 | 0.014 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.companynudgemarketingpopup getNudgeData 288 |
| 64 | SELECT 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.02 | 0.02 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup getNudgeData 366 |
| 65 | select 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.02 | 0.02 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup BuildFormLeads 850 |
| 66 | select * FROM ctm_CustomMarketingContent cmc WHERE cmc.iObjType = 3 AND cmc.hObjPointer = 144261 AND cmc.bEnable = 1 AND cmc.iTrackingType = 11 | 0.01 | 0.01 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup IsGTAGUsedForGoogleAnalyic 1009 |
| 67 | select * FROM ctm_CustomMarketingContent cmc WHERE cmc.iObjType = 3 AND cmc.hObjPointer = 144261 AND cmc.bEnable = 1 AND cmc.iTrackingType = 11 | 0.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.ThemeScripting GetContent 196 |
| 68 | Select 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.014 | 0.014 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative ReplaceParamsData 237 |
| 69 | Select hMy from ctm_ContentClass where sContentClass = 'portalcookiepolicy' | 0.018 | 0.018 | 1 | 0 | Not 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.018 | 0.018 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative GetCookiePolicyLinkPageName 361 |
| 71 | select sGoogleSiteVerification from ylsPropertyMaster where hProperty = 144261 | 0.013 | 0.013 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary CTM_GetPropertyInfo 797 |
| 72 | select 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.01 | 0.01 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary GetCustomCSS 1130 |
| 73 | select 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 desc | 0.011 | 0.011 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary GetCustomCSS 1150 |
| 74 | select 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.061 | 0.061 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary GetCustomJS 1212 |
| 75 | select 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 = 143941 | 0.01 | 0.01 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary GetCustomJS 1232 |
