T1
TESTING
TOTAL QUERIES: 79
TOTAL TIME TAKEN FOR ENTIRE REQUEST: 1.021 seconds
| Order | Query | Time Taken Each (seconds) | Total Time Taken (seconds) | Number of Times | Number of Cache Hits | Cached | Calling Class |
|---|---|---|---|---|---|---|---|
| 0 | select top 1 iurlpattern from ctm_DomainMappings where hObjPointer=144261 and url='malta1.reslisting.com' and hObjectType=3 | 0.005 | 0.005 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.RCPropertySite ReadParams 279 |
| 1 | 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.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.RCPropertySite ReadParams 394 |
| 2 | select hMy from GeoUserData where sIPAddress = '10.246.3.246' | 0.005 | 0.005 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.DataClasses.ysiGeoUserData ReadByIP 164 |
| 3 | select r.hMy "Id" , r.sIPAddress "IpAddress" , r.sCountry "Country" , r.sState "State" , r.sCity "City" , r.sZipCode "ZipCode" , r.sLatitude "Latitude" , r.sLongitude "Longitude" , r.sMetro "Metro" , r.sAreaCode "AreaCode" , r.sISP "ISP" , r.sOrg "Org" , c.hMy "CBSAId" from GeoUserData r join ylsCBSA c on c.sMajorCBSAName = r.sCity and c.sMajorCBSAStateAbbreviation = r.sState where 1 = 1 and r.hMy = 16200432 | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.DataClasses.ysiGeoUserData ReadByIP 167 |
| 4 | 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.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.RCPropertySite ReadParams 595 |
| 5 | SELECT bEnableForMVC FROM ctm_PropertyConfig WHERE hProperty = 144261 | 0.011 | 0.011 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.RCPropertySite ReadParams 633 |
| 6 | select p.hmy myPortalId, p.hObjPointer myPropertyId, pm.iCafeType CafeType, template.hMy myThemeTemplateId, theme.hMy myThemeId, theme.sname themeName, isnull(pm.iPropertyType,0) PropertyType ,cpm.ActiveFlag isActive,cpm.busevoyagerportal UseVoyagerPortal, cpm.bAgreeToList AgreeToList, pm.bCompanyActive isCompanyActive ,cpm.bPublishOnPortal PublishOnPortal, isnull(cpm.bPublishOnAPI,0) PublishOnAPI, isnull(cpm.bUseiFrameContent ,0) UseIframeContent , theme.iThemeType , case when isnull(cpm.bAgreetoList,0) <> 0 then 1 else isnull(cpm.bEnableRCDynamicCampaign , 0) end UseRCDynamicCampaign, isnull(mt.sTag, '') MarketingTag , case when isnull(cpm.bAgreetoList,0) <> 0 then 1 else isnull(cpm.bEnableRCStandardCampaign, 0) end UseRCStandardCampaign from portal p inner join ctm_theme theme on theme.hMy = p.hTheme join ylsPropertyMaster pm on pm.hProperty = p.hObjPointer join ctm_param_master cpm on cpm.hProperty = p.hobjPointer inner join ctm_themetemplate template on template.hTheme = theme.hMy and template.hThemeTemplateType = 2 left join Ctm_CustomMarketingTag mt on mt.hobjpointer = pm.hcompany and mt.hobjtype = 2 and mt.ifunctionalitytype = pm.iPropertyType where 1=1 and p.sSiteName = 'cafe-malta' and p.hobjectType = 3 | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.RCPropertySite doThemeSite 1330 |
| 7 | 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.004 | 0.004 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.Utils.rcUtils GetPropertyAddress 114 |
| 8 | 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 |
| 9 | select isNULL(sContentClass,'') from ctm_themeMenuItem where hThemeMenu=85663 and sLink like 'community.aspx%' | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.RCPropertySite GetPageCaption 1866 |
| 10 | 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.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.Systems.PluginManager LoadCafePlugins 168 |
| 11 | select top 1 pi.sAssemblyName, pi.sname, pi.iCafeType from ylsPropMgmtCompany c left join CafeTypeAssembly pi on pi.icafetype = 7 where c.hmy = 84065 and ISNULL(c.bOwnerPortal,0) <> 0 and pi.sProgType = 'PropertySite' | 0.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.Systems.PluginManager LoadCafePlugins 187 |
| 12 | select iCafeType from property where hmy = 144261 | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.Systems.PluginManager SetPluginRoot 78 |
| 13 | Select ct.hmy ThemeId, ct.sCode ThemeCode, ct.iVersion Version, p.hObjectType ObjectTypeId, p.hObjPointer ObjectId, p.hMy PortalId, p.sSiteName PortalName, p.bShowCustomMetaTags ShowCustomMetaTags, p.sMetaDesc MetaDesc, p.sTitle PortalTitle, p.sFootertext FooterText, p.bUseCustomContent, p.bUseCustomCSSFile, isNull(p.sThemeColorVariation,isnull(cv.sname,'')) ThemeColorVariation, isNull(p.sPublishedCustomizationName,'') CustomizationName, p.bBundlingEnabled BundlingEnabled , pc.bEnableForMVC EnableForMVC , cpm.bPublishOnMVC PublishOnMVC , cpm.bPublishOnMVCForRPOLE PublishOnMVCForRPOLE from portal p inner join ctm_theme ct on ct.hmy = p.hTheme left join ctm_themevariations cv on cv.htheme = ct.hmy and p.hthemevariation = cv.hmy left Join ctm_propertyconfig pc with (nolock) on pc.hproperty = p.hObjPointer and p.hObjectType = 3 left Join ctm_param_master cpm with (nolock) on cpm.hproperty = p.hObjPointer and p.hObjectType = 3 where p.hmy = 143941 | 0.007 | 0.014 | 2 | 1 | Cached Result | YSI.Cafe.Systems.ysiPortalSettings Read 306 |
| 14 | Select iThemeType From ctm_theme where hMy = 344 | 0.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.Systems.ysiPortalSettings SetTemplatePathForPrivateTheme 531 |
| 15 | 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.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.Systems.ysiPortalSettings SetTemplatePathForCorporateListing 622 |
| 16 | select top 1 pc.sFooterText FooterText from ylspropmgmtcompany c with (NoLock) join property pr on pr.hPropMgmtCompany = c.hmy and isnull(c.bActive,0)<> 0 join ctm_propertyconfig pc on pc.hProperty = pr.hmy where pr.hMy = 144261 | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary GetCompanyFooterText 1337 |
| 17 | select sFooterTextRentcafe from ctm_globalsettings | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary CTM_GetGlobalInfo 728 |
| 18 | select sDomainName from ctm_globalsettings | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary CTM_GetGlobalInfo 728 |
| 19 | select top 1 isNULL(sContentClass,'') ContentClass, ISNULL(sContentAssembly, '') ContentAssembly, ISNULL(sContentNamespace, '') ContentNamespace from ctm_themeMenuItem where hThemeMenu=85663 and sLink like 'community.aspx%' | 0.008 | 0.048 | 6 | 5 | Cached Result | YSI.Cafe.RC.Library.Utils.rcUtils GetContentClassFromMenu 5022 |
| 20 | SELECT TOP 1 hmy, sDescription FROM ctm_contentclass WHERE lower(sContentClass) = 'community' | 0.007 | 0.035 | 5 | 4 | Cached Result | YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag getContentClass 792 |
| 21 | select mi.hSection from ctm_thememenuitem mi where mi.hThemeMenu = 85663 and mi.sLink like 'community.aspx%' | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag GetContent 183 |
| 22 | SELECT TOP 1 cm.sPageTitle, cm.sKeywords, cm.sDescription, cm.sH1Content, s.sData CustomMetaInfo FROM ctm_MetaTag cm left outer join ctm_section s on cm.hobjpointer = s.hobjpointer and cm.hContentClass = s.hContentClass and s.sCode = 'CustMeta' and cm.hlanguage = s.hlanguage WHERE cm.hObjPointer = 144261 and cm.iobjtype = 3 and cm.hLanguage in (0, 27, 28, 0) AND cm.hContentClass = 95 and s.hLanguage in (0, 27, 28, 0) ORDER BY cm.hlanguage DESC, cm.hmy DESC, s.hlanguage DESC | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag GetContent 261 |
| 23 | Select top 1 mc.sPageTitle, mc.sKeywords, mc.sDescription, mc.sH1Content, mc.sMetaHead CustomMetaInfo From ctm_section s join ctm_metatag mc on mc.hsectionid = s.hmy where s.iObjtype=3 and s.hObjpointer = 144261 and sPageName = 'community' and mc.hLanguage in (0, 27, 28, 0) order by mc.hlanguage desc | 0.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag GetContent 276 |
| 24 | SELECT TOP 1 cm.sPageTitle, cm.sKeywords, cm.sDescription FROM ctm_MetaTag cm JOIN ctm_ContentClass cc ON cc.hMY = cm.hContentClass WHERE cm.hObjPointer = 1 AND cc.sContentClass = 'community' | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.MetaTag GetContent 314 |
| 25 | select sTrackingCode, iTrackingType from ctm_CustomMarketingContent with (nolock,nowait) where iObjType=3 And hObjPointer=144261 And iTrackingType in (7,11, 12) And hPortalID = 0 | 0.01 | 0.01 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.GoogleAnalytics GetContent 159 |
| 26 | select hmy from ctm_thememenu where 1=1 and bInActiveCustomMenu = 0 and sCode = 'CustomMenu_144261' | 0.007 | 0.014 | 2 | 1 | Cached Result | YSI.Cafe.RC.Library.Utils.ClickTrack GetContentObject 186 |
| 27 | Select * from ctm_custommarketingcontent where iobjtype = 3 And hobjpointer = 144261 And isnull(benable, 0) = 1 And iCodeLocation = 1 And ( ipageType = 1 ) UNION ALL SELECT * FROM ctm_custommarketingcontent WHERE iObjType = 3 AND hObjPointer = 144261 AND isNULL(bEnable,0) = 1 AND (iTrackingType = 1 OR iTrackingType = 2 OR iTrackingType = 6) AND iEvent = 12 | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.PageScripts GetPageScripts 681 |
| 28 | Select ci.SCODE FROM Property P With (nolock) inner join country_info CI With (nolock) On P.HCOUNTRY = ci.HMY where P.hmy = 144261 | 0.007 | 0.021 | 3 | 2 | Cached Result | YSI.Cafe.RC.Library.ContentClasses.PageScripts IntHideEqualHousingLogoJs 744 |
| 29 | select iWidth, iHeight from ctm_imageDimensions where iType = 125 and hTheme = 344 | 0.011 | 0.011 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.Image ReadParams 115 |
| 30 | select bUseCloudinary from ctm_DomainMappings where hObjPointer = 84065 and hObjectType = 2 and url = 'malta1.reslisting.com' | 0.006 | 0.012 | 2 | 1 | Cached Result | YSI.Cafe.Systems.Cloudinary UsingCloudinary 150 |
| 31 | Select * from ctm_custommarketingcontent where iobjtype = 3 And hobjpointer = 144261 And isnull(benable, 0) = 1 And iCodeLocation = 2 And ( ipageType = 1 ) | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.PageScripts GetPageScripts 681 |
| 32 | select sTrackingCode, iTrackingType from ctm_CustomMarketingContent with (nolock,nowait) where iObjType=3 And hObjPointer=144261 And iTrackingType in (8, 12) And hPortalID = 0 | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.GoogleAnalytics GetContent 159 |
| 33 | 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.01 | 0.01 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.PageScripts GetContent 134 |
| 34 | select * from ctm_PropertySettings WITH(NOLOCK) where hObjPointer = 0 and hSettingType = 1 | 0.008 | 0.024 | 3 | 2 | Cached Result | YSI.Cafe.RC.Library.PropertySettings SetSystemDefaultValuesFromDB 570 |
| 35 | 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.024 | 3 | 2 | Cached Result | YSI.Cafe.RC.Library.PropertySettings Read 717 |
| 36 | select * from ctm_PropertySettings WITH(NOLOCK) where ( (hObjPointer = 144261 and hsettingtype=4) or (hObjPointer = 84065 and hsettingtype=2)) | 0.01 | 0.03 | 3 | 2 | Cached Result | YSI.Cafe.RC.Library.PropertySettings Read 747 |
| 37 | SELECT COUNT(*) num FROM AdWordsClients WHERE hPropertyId = 144261 And bActive = 1 | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.PageScripts GetContent 510 |
| 38 | 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.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.PageScripts GetContent 520 |
| 39 | SELECT sFloorPlanAssistantButtonLabel, sFloorPlanAssistantTagline, sFloorPlanThemeColor, dFloorPlanColorOpacity, sFloorPlanAssistantDockSide FROM ctm_propertyconfig WHERE hProperty = 144261 | 0.012 | 0.012 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.PageScripts GetFloorPlanAssistantSettings 772 |
| 40 | 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 |
| 41 | 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 |
| 42 | select top 1 sExternalURL from ylspropertymaster where hProperty = 144261 | 0.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.PropertyHomePageUrl GetContent 26 |
| 43 | select itype from ctm_itype where sName='Property Logo' | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.Image ReadParams 94 |
| 44 | select iWidth, iHeight from ctm_imageDimensions where iType = 6 and hTheme = 344 | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.Image ReadParams 115 |
| 45 | SELECT iVideoStatus FROM ctm_VideoEmbed WHERE hProperty=144261AND hFloorplan IS NULL | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu GetContent 92 |
| 46 | select * from ctm_thememenuitem where hthememenu = 85663 and isnull(iorder,0) <> 0 and isnull(bIgnoreSection,0) = 0 and isnull(sIosDeepLinkUrl,'') = '' AND isnull(sAndroidDeepLinkUrl,'') = '' and sMenuSet = 'Primary' and sContentClass <> 'PropertySiteRatings' and scontentclass <> 'Videos' order by iorder | 0.009 | 0.009 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu GetContent 115 |
| 47 | 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 |
| 48 | select top 1 hMY from ctm_ThemeMenuItem where hThemeMenu = 85663 and isnull(iorder,0) <> 0 and isnull(bIgnoreSection,0) = 0 and sMenuSet = 'Primary' and slink = 'community.aspx' | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.HeaderMenu getpageID 256 |
| 49 | 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.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine GetContent 38 |
| 50 | select * from taglinesettings where hobjpointer=144261 and hsettingtype=3 | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine GetContent 49 |
| 51 | select * from taglinesettings ts where ts.hObjPointer = 84065 and ts.hTheme =344 | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.TagLine GetContent 108 |
| 52 | select top 1 isnull(Dx.sAlias,'') ImageFile ,Dx.hmy DocMgrXrefId ,D.hmy DocMgrId ,isnull(D.sFile,'') FileName ,isnull(D.iWidth,0) FileWidth ,isnull(Dx.sTitle,'') sTitle ,isnull(Dx.sDesc,'') sDesc ,isnull(Dx.sCaption,'') sCaption ,isnull(Dx.sImageDescription,'') sImageDescription ,isnull(D.iHeight,0) FileHeight ,isnull(D.iSize,0) FileSize ,isnull(Dx.iOrder,0) FileOrder ,isnull(Dx.sModificationParams,'') ImageParams , isnull(Dx.cropX,'') cropX , isnull(Dx.cropY,'') cropY , isnull(Dx.cropH,'') cropH , isnull(Dx.cropW,'') cropW ,isnull(Dx.hDocMgrCategory,0) FileDocMgrCategory ,case when dx.hparent<>0 then dx1.iobjtype else dx.iobjtype end ObjectType , case when dx.hparent<>0 then dx1.hobjpointer else dx.hobjpointer end ObjectId , dx.itype iType , ISNULL(dx.bMediaLibrary, 0) IsMediaLibrary ,isnull(Dx.scontenttype,'') contenttype ,isnull(Dx.sextension,'') imagetype , dx.hparent hParent from ctm_docmgrxref Dx inner join ctm_docmgr D on DX.hdocmgr=D.hmy left outer join ctm_docmgrxref Dx1 on dx.hparent=dx1.hmy where dx.itype = 12 and dx.iObjType = 3 and dx.hObjPointer = 144261 and isnull(dx.iDelete,0) = 0 and isnull(dx.bInActive,0) = 0 order by FileOrder , DocMgrXrefId | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.Utils.RentCafeUtils GetActiveImages 1472 |
| 53 | SELECT top 1 sData ,sName FROM ctm_Section s with (nolock) WHERE s.iObjType = 3 AND s.hObjPointer = 144261 AND s.sCode = 'ResHome' AND s.sFunction = 'ResCommunityPage' | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.Community GetRomanceParagraph 166 |
| 54 | SELECT hProperty FROM listprop2 WHERE hPropList in (144261 ) | 0.007 | 0.014 | 2 | 1 | Cached Result | YSI.Cafe.Systems.ysiDataUtil BuildPropertyInClause 635 |
| 55 | Select distinct 0 UnitID ,ls.hUnitType UnitTypeID ,isnull(isnull(case when LS.sPortalDescription ='' then NULL else LS.sPortalDescription end ,ls.sdesc),'') PortalDescription ,ctm_FP.hFloorplan FloorPlanID ,YFP.hproperty PropertyID ,LS.hmy SpecialsID ,isnull(ls.hChargeCode,0) ChargeCodeID ,isnull(ls.iFrequencyType,0) RecurrenceType ,isnull(ls.iFrequencyNumber,0) Recurrences ,isnull(ls.dAmount,0) Amount ,isnull(ls.iMinLeaseTerm,1) LeaseTermFrom ,case when isnull(ls.iMaxLeaseTerm,0) = 0 then 0 else isnull(ls.iMaxLeaseTerm,0) end LeaseTermTo ,isnull(ls.dtInactive,'01/01/2500') ExpirationDate ,isnull(ls.iStartMonth,0) StartMonth ,isnull(ls.iProrateType,0) ProrateType ,isnull(ls.bTaxable,0) IsTaxable ,isnull(ls.bModifiable,0) IsModifiable ,isnull(ls.sNotes,'') Notes ,isnull(ls.sDesc,'') Description ,isnull(ls.dtStart,'01/01/1900') StartingDate ,isnull(ls.bNewMoveIn,0) IsNewMoveIn ,isnull(ls.bRenewal,0) IsRenewal ,isnull(ls.bTransfer,0) IsTransfer ,isnull(ls.bShowOnPortal,0) IsShowOnPortal ,isnull(ls.iAmountType,0) AmountType ,isnull(ls.hForeigndb,0) ForeigndbID ,isnull(ls.hExtReference,0) VoyagerID ,isnull(ls.bRentCafeSpecial,0) RentCafeSpecial ,isnull(ls.bPromotionalSpecial,0) PromotionalSpecial ,YFP.sname FloorplanName From ylsFloorPlan YFP inner join ctm_floorplanunittype ctm_FP on ctm_FP.hFloorplan = YFP.HMY and YFP.hProperty in (144261) inner Join LeasingSpecials ls on ls.hFloorplan = YFP.HMY and isnull(ls.bRentCafeSpecial,0) = 1 and isnull(ls.bInActive,0) = 0 and ls.bShowOnPortal <> 0 and 1 = (case when isnull(ls.bPromotionalSpecial,0) = 0 and isnull(ls.dAmount,0) > 0 then 1 when isnull(ls.bPromotionalSpecial,0)= 1 then 1 else 0 end ) and isnull(ls.bNewMoveIn,0) <> 0 and ls.hProperty in (144261) And Isnull(ls.dtinactive,convert(datetime, '05/08/2021', 101)) >= convert(datetime, '05/08/2021', 101) order by isnull(ls.iStartMonth,0) | 0.009 | 0.009 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.RentCafeSpecials GetFloorPlanSpecials 71 |
| 56 | SELECT sTitle, sDesc, IsNull(iOrder, 999), dtStartdate FROM ctm_Announcement with (nolock) WHERE bActive <> 0 AND ((iObjType = 3 AND hObjPointer = 144261 ) or hMy in (select hAnnouncement from AnnouncementPropXRef where hProperty = 144261)) AND dtStartdate <= convert(datetime, '05/07/2021', 101) AND (dtEndDate Is Null OR dtEndDate >= convert(datetime, '05/07/2021', 101)) AND iAnnouncementType = 0 AND bShowOnCommunity <> 0 ORDER BY 3 ASC, 4 DESC | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.CommunityAnnouncements GetAnnouncementsDatatable 87 |
| 57 | SELECT sDesc , dtEventdate , dtStartdate , dtEnddate , bRecurring , iRecurringType , iFutureIterationsDisplayed , iPastIterationsDisplayed , iRecurrenceFrequency , iMonthlyOccurrenceType , iDayOfMonth , iWeekDayOfMonth , iWeekDay , 0 isCached , sEventStartTime , sEventEndTime FROM ctm_CalendarEvent with (nolock) WHERE IsNull(bActive, 0) <> 0 AND ((iObjType = 3 AND hObjPointer = 144261 ) or hMy in (select hCalEvent from CalEventPropXRef where hProperty = 144261)) AND dtStartdate <= convert(datetime, '05/07/2021', 101) AND (dtEndDate Is Null OR dtEndDate >= convert(datetime, '05/07/2021', 101)) AND bShowOnCommunity <> 0 ORDER BY dtEventdate ASC | 0.02 | 0.04 | 2 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.CommunityCalendarEvents GetCalendarEvents 74 |
| 58 | SELECT w.sPostBody PostBody, isnull(s.sDisplayName, pm.ObjFirstName + ' ' + pm.ObjLastName) AuthorName ,isnull(wcc.wallpostcount,0) wallCommentcount ,w.dtCreated dateCreated FROM ctm_WallPosts w INNER JOIN PmUserex pm on pm.hMy = w.hUserCreatedBy left join pmuserex_settings s on s.hPmUserex = pm.hMy left Join ( SELECT wc.hWallPost , count(wc.hWallPost) wallpostcount FROM ctm_WallPostComments wc INNER JOIN PmUserex pm on pm.hMy = wc.hUserCreatedBy inner join ctm_WallPosts w on w.hMy = wc.hWallPost AND wc.iStatus = 1 AND w.iStatus = 1 group by wc.hWallPost) wcc on wcc.hWallPost = w.hmy WHERE w.hProperty = 144261 AND w.iStatus = 1 ORDER BY w.hmy DESC | 0.009 | 0.009 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.CommunityWallPost CommunityWallpostsDT 105 |
| 59 | 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.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.AddressBlock GetData 193 |
| 60 | Select sLink Link , sCaption Caption From ctm_footerlinks where htheme = 344 | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.FooterSection GetLinks 84 |
| 61 | Select sLink Link , sCaption Caption From ctm_footerlinks where isnull(htheme,0) = 0 and isnull(hobject,0) = 0 and isnull(iObjectType,0) = 0 and iFooterSection = 3 | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.PropertySiteContent.ContentClasses.FooterSection GetLinks 103 |
| 62 | select itype from ctm_itype where sName='Footer Image' | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.Image ReadParams 94 |
| 63 | select iWidth, iHeight from ctm_imageDimensions where iType = 29 and hTheme = 344 | 0.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.Image ReadParams 115 |
| 64 | Select * from ctm_custommarketingcontent where iobjtype = 3 And hobjpointer = 144261 And isnull(benable, 0) = 1 And iCodeLocation = 3 And ( ipageType = 1 ) | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.PageScripts GetPageScripts 681 |
| 65 | ;with cteProperty (PropertyId, DomainUrl, Latitude, Longitude, PageDescription, PropertyTypeId, CorporateDomainUrl) as(select PropertyId = p.hmy, dm.url, pm.dLatitude, pm.dLongitude, pm.[Description], p.iPropertyType, dmc.url from property p left join ctm_DomainMappings dm on p.hmy = dm.hObjPointer left join ctm_DomainMappings dmc on p.hPropMgmtCompany = dmc.hObjPointer join ctm_param_Master pm on p.hmy = pm.hproperty where p.hmy = 144261 And dm.hObjectType = 3), ctePropertyLogo(PropertyId, DomainUrl, Latitude, Longitude, PageDescription, PropertyImage, PropertyTypeId, CorporateDomainUrl) as(select top 1 cte.PropertyId, cte.DomainUrl, cte.Latitude, cte.Longitude, cte.PageDescription, PropertyImage = case when dm.sFile is null then '' else '/dmslivecafe/' + cast(dr.iObjType as varchar) + '/' + cast(dr.hObjPointer as varchar) + '/' + dm.sFile end, cte.PropertyTypeId, cte.CorporateDomainUrl from cteProperty cte left join ctm_DocMgrXRef dr on cte.PropertyId = dr.hObjPointer and dr.itype = 5 and dr.iObjType = 3 left join ctm_docmgr dm on dr.hDocMgr = dm.hmy where isnull(dr.bInActive,0) = 0 and isnull(dr.iDelete,0) = 0 order by dr.hmy desc ),ctePropertyLogoPropertyImage(PropertyId, DomainUrl, Latitude, Longitude, PageDescription, PropertyImage, PropertyLogo, PropertyTypeId, CorporateDomainUrl) as(select top 1 PropertyId, DomainUrl, Latitude, Longitude, PageDescription, PropertyImage, PropertyLogo = case when dm.sFile is null then '' else '/dmslivecafe/' + cast(dr.iObjType as varchar) + '/' + cast(dr.hObjPointer as varchar) + '/' + dm.sFile end, cte.PropertyTypeId, cte.CorporateDomainUrl from ctePropertyLogo cte left join ctm_DocMgrXRef dr on cte.PropertyId = dr.hObjPointer and itype = 6 and dr.iObjType = 3 left join ctm_docmgr dm on dr.hDocMgr = dm.hmy where isnull(dr.bInActive,0) = 0 and isnull(dr.iDelete,0) = 0 order by dr.hmy desc )select DomainUrl, Latitude, Longitude, PageDescription, PropertyImage, PropertyLogo, PropertyTypeId, CorporateDomainUrl from ctePropertyLogoPropertyImage | 0.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.SchemaMarkupJSONLD PopulatePrivateVariables 342 |
| 66 | 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('community.aspx') WHERE nudge.hObjPointer = 84065 AND nudge.hObjType = 2 AND ISNULL(bArchived,0) <> 1 AND (LOWER(nudgepages.sPageName) = LOWER('community.aspx') OR nudge.iAnypage = 1) AND (nudge.bEnabled = 1 OR (nudge.bEnabled = 3 AND (CONVERT(date, getdate()) BETWEEN nudge.scheduleFrom AND nudge.scheduleTo)) ) | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.companynudgemarketingpopup getNudgeData 288 |
| 67 | 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('community.aspx') LEFT JOIN ccp_client_property_phone phone on nudge.hPhoneNumber = phone.hmy LEFT JOIN LeasingSpecials special ON nudge.campaignXref = special.hmy LEFT JOIN ctm_promotions pr ON nudge.campaignXref = pr.hmy WHERE nudge.hObjPointer = 144261 AND nudge.hObjType = 3 AND ISNULL(bArchived,0) <> 1 AND (LOWER(nudgepages.sPageName) = LOWER('community.aspx') OR nudge.iAnypage = 1) AND (nudge.bEnabled = 1 OR (nudge.bEnabled = 3 AND (CONVERT(date, getdate()) BETWEEN nudge.scheduleFrom AND nudge.scheduleTo)) ) | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup getNudgeData 366 |
| 68 | 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.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.ContentClasses.nudgemarketingpopup BuildFormLeads 850 |
| 69 | 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.ContentClasses.nudgemarketingpopup IsGTAGUsedForGoogleAnalyic 1009 |
| 70 | select * FROM ctm_CustomMarketingContent cmc WHERE cmc.iObjType = 3 AND cmc.hObjPointer = 144261 AND cmc.bEnable = 1 AND cmc.iTrackingType = 11 | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.ThemeScripting GetContent 196 |
| 71 | 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.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative ReplaceParamsData 237 |
| 72 | Select hMy from ctm_ContentClass where sContentClass = 'portalcookiepolicy' | 0.006 | 0.006 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative GetCookiePolicyLinkPageName 350 |
| 73 | SELECT TOP(1) 1 FROM ctm_Section WHERE hContentClass = 110 AND ((iObjType = 3 And hObjPointer = 144261) OR (iObjType = 2 And hObjPointer = 84065)) | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.RC.Library.AppClasses.GetCustomNarrative GetCookiePolicyLinkPageName 361 |
| 74 | select sGoogleSiteVerification from ylsPropertyMaster where hProperty = 144261 | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary CTM_GetPropertyInfo 797 |
| 75 | 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 = 2 and p.hMy = 143941 AND ISNULL(c.hsettingstemplate, 0) = 0 order by c.hmy desc | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary GetCustomCSS 1130 |
| 76 | 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 = 2 and p.hMy = 143941 order by c.hmy desc | 0.005 | 0.005 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary GetCustomCSS 1150 |
| 77 | 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 = 2 and p.hMy = 143941 AND ISNULL(c.hsettingstemplate, 0) = 0 | 0.007 | 0.007 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary GetCustomJS 1212 |
| 78 | 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 = 2 and p.hMy = 143941 | 0.008 | 0.008 | 1 | 0 | Not Cached | YSI.Cafe.BaseCafePage.ysiCtmLibrary GetCustomJS 1232 |