Rick Brown     (417) 546-7000

 
 

Username:

Password:

 

 
218 Sunken Forest Drive
$159,900.00
Lakes area tri-level home
 
Contact
phone (417) 546-7000
cell (417) 546-7000
fax (800) 889-2970
 
Powered By VOBRE Real Estate Technology


Debugging Information
ColdFusion Server Enterprise 11,0,03,292866
Template /index.cfm
Time Stamp 12-Apr-15 09:49 PM
Locale English (US)
User Agent ColdFusion
Remote IP 10.15.30.224
Host Name 10.15.30.224


Execution Time

Total Time Avg Time Count Template
60 ms 60 ms 1 D:/web/agent sites/common/application-common.cfm
60 ms 60 ms 1 D:/web/agent sites/design5/Application.cfm
14 ms 14 ms 1 top level D:\web\agent sites\design5\index.cfm
2 ms 2 ms 1 D:/ColdFusion11/cfusion/CustomTags/slideshow.cfm
1 ms 1 ms 1 D:/web/agent sites/common/includes/site_header.cfm
0 ms 0 ms 1 D:/ColdFusion11/cfusion/CustomTags/define_globals.cfm
0 ms 0 ms 1 D:/web/agent sites/common/includes/fp_login.cfm
0 ms 0 ms 1 D:/web/agent sites/common/includes/globalfooter.cfm
0 ms 0 ms 1 D:/web/agent sites/common/license.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
75 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GetInfo (Datasource=rsforms-mysql, Time=52ms, Records=1) in D:\web\agent sites\common\application-common.cfm @ 21:49:51.051
	select LogoPath, PrimaryColor, SecondaryColor, Table1Color, Table2Color, AgentName, DefaultPhone, BackgroundColor, TextColor, 
		PageTitle, FlashFile, PersonalFolder, HeadshotFile, ServerPath, UploadedHeadshotImageID, 
		HeadshotPlaceholderID, coalesce(aw.StyleID,10) as StyleID, UploadedLogoImageID, LogoID, Font, aw.AgentWebsiteID, 
		aw.VendorContactID, FrontpageText as FrontpageMessage, FlashID, SiteFontTextColor, SiteLoginTextColor, SiteNameTextColor,
			SiteFeaturedTextColor, SiteFontTextColorLink, SiteLoginTextColorLink, SiteNameTextColorLink,
			SiteFeaturedTextColorLink, FlashSectionContent, FlashSectionImageID, FlashSectionSlideshowID,
			MLSURL, MLSDisplayType, HeaderTags, FooterText, CustomLinks, coalesce(vl.HidePoweredBy,aw.HidePoweredBy) as HidePoweredBy, LogoLink, 
			TitleBackgroundImage, aw.ContactID, aw.IDXFrameWidth, aw.HideLoginPane, FacebookLink, TwitterLink, 
			LinkedInLink, GplusLink, aw.CustomTitle
	from AGENT_WEBSITE aw, AGENT_WEBSITE_DOMAIN awd, vendor_login vl
	where awd.DomainName = 'rickbrown.biz'
	and awd.AgentWebsiteID = aw.AgentWebsiteID
	and aw.ContactID = vl.ContactID
FindCustomHeader (Datasource=rsforms-mysql, Time=1ms, Records=0) in D:\web\agent sites\common\application-common.cfm @ 21:49:51.051
	select HeaderTags
	from agent_website_custom_header
	where ContactID = 10796
	and Page = 'index.cfm'	
GetLogo (Datasource=rsforms-mysql, Time=1ms, Records=1) in D:\web\agent sites\common\application-common.cfm @ 21:49:51.051
		select ImageRelativePath, Width, Height
		from VENDOR_USER_UPLOADED_IMAGE
		where VendorContactID = 5726
		and UserImageID = 93906
		and ImageType = 1			
	
GetPages (Datasource=rsforms-mysql, Time=0ms, Records=1) in D:\web\agent sites\common\application-common.cfm @ 21:49:51.051
	select ShowHomePageStatement, ShowMLS, ShowNeighborhoodProfiles, 
			ShowTestimonials, ShowPersonalProfile, ShowLicense, ShowDisclaimer, ShowListings, ShowBuyers, ShowSellers,
			ShowMortgage, ShowContact, ShowSearchProperties, ShowCustom, ShowLogin
	from AGENT_WEBSITE
	where VendorContactID = 5726 
GetDefMtgpage (Datasource=rsforms-mysql, Time=0ms, Records=1) in D:\web\agent sites\common\application-common.cfm @ 21:49:51.051
	select DefaultPage
	from agent_website_mortgage_section
	where AgentWebsiteID = 2248 
GetGlobalFooter (Datasource=rsforms-mysql, Time=0ms, Records=0) in D:\web\agent sites\common\application-common.cfm @ 21:49:51.051
	select apc.GlobalFooter
	from agent_promo_code apc, vendor_login vl
	where apc.PromoCode = vl.PromoCodeEntered
	and vl.ContactID = 10796 
GetFeatured (Datasource=rsforms-mysql, Time=1ms, Records=1) in D:\web\agent sites\design5\index.cfm @ 21:49:51.051
	select awpl.Title, lpi.Address, lpi.City, lpi.State, pli.ListingPrice, pli.TransactionID, pli.PriceUponRequest
	from AGENT_WEBSITE_PROPERTY_LISTING awpl, PROPERTY_LISTING_INFO pli, LOANAPP_PROP_INFO lpi
	where awpl.TransactionID = pli.TransactionID
	and awpl.AgentWebsiteID = 2248
	and lpi.BorrowerID = pli.TransactionID
	and IsFeatured = 1
GetUserInfo (Datasource=rsforms-mysql, Time=1ms, Records=1) in D:\web\agent sites\design5\index.cfm @ 21:49:51.051
	select Coalesce(aw.FirstName,c.FirstName) as FirstName, Coalesce(aw.LastName,c.LastName) as LastName, 
		c.HomePhone, Coalesce(aw.Busphone,c.Busphone) as Busphone, 
		Coalesce(aw.Fax,c.Fax) as Fax, Coalesce(aw.Mobile,c.Mobile) as Mobile, c.MobileCarrierID, c.Email
	from CONTACT c, VENDOR_CONTACT vc, AGENT_WEBSITE aw
	where c.COntactID = vc.ContactID
	and vc.VendorContactID = 5726
	and c.ContactID = aw.ContactID
GetImages (Datasource=rsforms-mysql, Time=0ms, Records=6) in D:\ColdFusion11\cfusion\CustomTags\slideshow.cfm @ 21:49:51.051
	select ImageRelativePath as ImagePath, case Coalesce(awsi.Transition,'Fade') when '' then 'Fade' else Coalesce(awsi.Transition,'Fade') end as Transition, awsi.Duration, aws.SlideshowType
	from VENDOR_USER_UPLOADED_IMAGE vui, agent_website_slideshow_slide awsi, agent_website_slideshow aws
	where vui.UserImageID = awsi.UserImageID
	and awsi.SlideshowID = aws.SlideshowID
	and aws.ContactID = 10796
	and aws.SlideshowID = 3482
	and Resized=1
	order by awsi.DisplayOrder
GetImages (Datasource=rsforms-mysql, Time=2ms, Records=24) in D:\web\agent sites\design5\index.cfm @ 21:49:51.051
		select ImageRelativePath as ImagePath, Width, Height, UserImageID, Description, IsDefault
		from VENDOR_USER_UPLOADED_IMAGE
		where VendorContactID = 5726
		and ImageType in (3,5)
		and TransactionID = 19979
		order by IsDefault desc
	


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\web\agent sites\design5\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=gzip,deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=rickbrown.biz
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=
PATH_TRANSLATED=D:\web\agent sites\design5\index.cfm
QUERY_STRING=force=1
REMOTE_ADDR=10.15.30.224
REMOTE_HOST=10.15.30.224
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=rickbrown.biz
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=
Cookie Variables:
CFID=24219
CFTOKEN=ee340862f525437d-EB1D0DEE-B083-FEE3-C7EF8713B028189B
Session Variables:
agentname=Rick Brown
agentwebsiteid=2248
agentwebsitepath=
backgroundcolor=#c0c0c0
cfid=24219
cftoken=ee340862f525437d-EB1D0DEE-B083-FEE3-C7EF8713B028189B
customtitle=
defaultmortgagepage=qc-disclaimer.cfm
defaultphone=
flashsectioncontent=Slideshow
flashsectionimageid=
flashsectionimagepath=/agentcommon/defaultflashimage5.jpg
flashsectionslideshowid=3482
font=Verdana
frontpagemessage=
globalfooter=
headshotfile=/common/spacer.gif
logoheight=80
logoheightsm=45
logopath=/agentcommon/personal/582455140/890640844-80.jpg
logopathsm=/agentcommon/personal/582455140/890640844-45.jpg
logowidth=137
logowidthsm=77
mlsdisplaytype=2
mlsurl=www.trilakesmls.com/cgi-brn/PUB_login?brown3
pagetitle=Rick Brown - by VOBRE
personalfolder=582455140
primarycolor=#000080
secondarycolor=#000080
sessionid=AGENTOUTSIDE_24219_ee340862f525437d-EB1D0DEE-B083-FEE3-C7EF8713B028189B
setup=1
showbuyers=0
showcontact=0
showcustom=0
showdisclaimer=0
showhomepagestatement=0
showlicense=0
showlistings=0
showlogin=0
showmls=0
showmortgage=0
showneighborhoodprofiles=0
showpersonalprofile=0
showsearchproperties=0
showsellers=0
showtestimonials=0
sitefeaturedtextcolor=#FFFFFF
sitefeaturedtextcolorlink=#000080
sitefonttextcolor=#FFFFFF
sitefonttextcolorlink=#00009E
sitelogintextcolor=#000000
sitelogintextcolorlink=#00009E
sitenametextcolor=#FFFFFF
sitenametextcolorlink=#00009E
styleid=5
table1color=
table2color=
textcolor=
uploadedimageid=93906
urltoken=CFID=24219&CFTOKEN=ee340862f525437d-EB1D0DEE-B083-FEE3-C7EF8713B028189B
usercontactid=10796
URL Parameters:
force=1
Debug Rendering Time: 8 ms