PCSD Home Page
Design - Blend
 Welcome to the Parma City School District Web Site
   
undefined
 
Error 404
File not found
Sorry, that page can not be found. It may have been deleted or moved. Please try either the search box above or click on 'Home' to return to the main page.
[ Home | Board | Buildings | Departments | Information | Staff ]
Last modified on 08/24/2004
Board of Education: Cynthia L. Bratz, Pres | Rosemary C. Gulick, VP | Karen S. Dendorfer | J. Kevin Kelley | Kathleen A. Petro
Administration:
Dr. Sarah C. Zatik, Superintendent | Dr. Christina M. Dinklocker, Deputy Superintendent of Operations
Bruce Basalla, Chief Financial Officer | Mark A. Daniels, Business Manager
Visit Paperthin.com
c. 2003-2008 Parma City School District
All Rights Reserved		 v) 440-842-5300
f) 440-885-2452		 Contact us at:
webmaster@parmacityschools.org

Debugging Information
ColdFusion Server Standard 6,1,0,hf56580_611
Template /pcsd404.cfm
Time Stamp 09-May-08 01:01 AM
Locale English (US)
User Agent CFSCHEDULE
Remote IP 10.99.2.215
Host Name 10.99.2.215

Execution Time

Total Time Avg Time Count Template
5177 ms 272 ms 19 E:\web\commonspot\cache\cached-render.cfm
3454 ms 3454 ms 1 top level E:\web\pcsd\pcsd404.cfm
3438 ms 3438 ms 1 E:\web\commonspot\master.cfm
3079 ms 3079 ms 1 E:\web\commonspot\master-render.cfm
2938 ms 2938 ms 1 E:\web\commonspot\render-page.cfm
2922 ms 2922 ms 1 E:\web\commonspot\render-page-meat.cfm
2361 ms 124 ms 19 E:\web\commonspot\utilities\ct-render-element.cfm
1844 ms 1844 ms 1 E:\web\pcsd\templates\template-basepage.cfm
1780 ms 127 ms 14 E:\web\commonspot\utilities\ct-render-named-element.cfm
1062 ms 1062 ms 1 E:\web\commonspot\controls\dhtmlmenu\cpe-menu.cfm
796 ms 398 ms 2 E:\web\commonspot\controls\layout\cpe-layout.cfm
703 ms 234 ms 3 E:\web\commonspot\controls\layout\render-cell.cfm
563 ms 563 ms 1 E:\web\commonspot\controls\dhtmlmenu\menu-get-data.cfm
499 ms 29 ms 17 E:\web\commonspot\controls\tabbar\restrict-item-list.cfm
313 ms 78 ms 4 E:\web\commonspot\utilities\cp-cffile.cfm
312 ms 156 ms 2 E:\web\commonspot\utilities\verify-stub-data.cfm
265 ms 265 ms 1 E:\web\commonspot\utilities\write-stub.cfm
250 ms 63 ms 4 E:\web\commonspot\controls\image\cpe-image.cfm
188 ms 94 ms 2 E:\web\commonspot\controls\linkbar\cpe-linkbar.cfm
188 ms 94 ms 2 E:\web\commonspot\utilities\cp-cffile-charset.cfm
187 ms 37 ms 5 E:\web\commonspot\controls\textblock\cpe-textblock.cfm
156 ms 156 ms 1 E:\web\commonspot\controls\tabbar\cpe-tabbar.cfm
141 ms 35 ms 4 E:\web\commonspot\controls\upfront-generic.cfm
125 ms 31 ms 4 E:\web\commonspot\controls\image\sic-default-params.cfm
125 ms 18 ms 7 E:\web\commonspot\utilities\ct-limit-inheritance.cfm
109 ms 14 ms 8 E:\web\commonspot\utilities\ct-extract-wddx-data.cfm
94 ms 5 ms 19 E:\web\commonspot\utilities\cp-cfdirectory.cfm
79 ms 4 ms 18 E:\web\commonspot\controls\control-setup.cfm
78 ms 20 ms 4 E:\web\commonspot\controls\image\image-upfront.cfm
78 ms 1 ms 144 E:\web\commonspot\utilities\ct-decipher-linkurl.cfm
63 ms 32 ms 2 E:\web\commonspot\controls\linkbar\lbar-standard-render.cfm
61 ms 3 ms 18 E:\web\commonspot\security\security-control.cfm
47 ms 5 ms 9 E:\web\commonspot\approve\ct-render-approval-icon.cfm
47 ms 47 ms 1 E:\web\commonspot\controls\date\cpe-date.cfm
47 ms 47 ms 1 E:\web\commonspot\controls\schedule\cpe-schedule.cfm
47 ms 47 ms 1 E:\web\commonspot\controls\search\cpe-searchform.cfm
47 ms 47 ms 1 E:\web\commonspot\controls\tabbar\tbar-standard-render.cfm
47 ms 47 ms 1 E:\web\commonspot\controls\tabbar\tbar-style-3.cfm
47 ms 5 ms 9 E:\web\commonspot\utilities\ct-render-edit-icon.cfm
47 ms 2 ms 27 E:\web\commonspot\utilities\ct-render-text.cfm
47 ms 47 ms 1 E:\web\commonspot\utilities\populate-page.cfm
46 ms 46 ms 1 E:\web\commonspot\security\security-detail-queries.cfm
32 ms 16 ms 2 E:\web\commonspot\controls\linkbar\lbar-get-params.cfm
32 ms 32 ms 1 E:\web\commonspot\metadata\build-struct.cfm
32 ms 6 ms 5 E:\web\commonspot\tb-data-upfront-queries.cfm
31 ms 10 ms 3 E:\web\commonspot\controls\linklist\linklist-itempos-upfront.cfm
31 ms 6 ms 5 E:\web\commonspot\controls\textblock\tb-standard-render.cfm
31 ms 31 ms 1 E:\web\commonspot\generate-usage-stats.cfm
16 ms 8 ms 2 E:\web\commonspot\approve\ct-render-approval-icon-subitems.cfm
16 ms 16 ms 1 E:\web\commonspot\controls\date\date-get-params.cfm
16 ms 4 ms 4 E:\web\commonspot\controls\image\sic-standard-render.cfm
16 ms 16 ms 1 E:\web\commonspot\controls\tabbar\tbar-get-params.cfm
16 ms 16 ms 1 E:\web\commonspot\security\security-page.cfm
16 ms 16 ms 1 E:\web\commonspot\sic-data-upfront-queries.cfm
16 ms 16 ms 1 E:\web\commonspot\sic-param-upfront-queries.cfm
16 ms 1 ms 26 E:\web\commonspot\utilities\cp-cfwddx.cfm
16 ms 0 ms 131 E:\web\commonspot\utilities\item-visible.cfm
16 ms 16 ms 1 E:\web\commonspot\utilities\load-template-stub.cfm
15 ms 15 ms 1 E:\web\commonspot\controls\customcf\cpe-customcf.cfm
15 ms 15 ms 1 E:\web\commonspot\controls\date\date-get-data.cfm
15 ms 1 ms 16 E:\web\commonspot\controls\default-mode.cfm
15 ms 15 ms 1 E:\web\commonspot\controls\dhtmlmenu\menu-get-props.cfm
15 ms 15 ms 1 E:\web\commonspot\controls\schedule\schedule-get-params.cfm
15 ms 3 ms 5 E:\web\commonspot\controls\textblock\tb-default-params.cfm
15 ms 15 ms 1 E:\web\commonspot\site-application.cfm
15 ms 15 ms 1 E:\web\commonspot\startup\site-application-meat.cfm
15 ms 15 ms 1 E:\web\commonspot\tb-param-upfront-queries.cfm
15 ms 15 ms 1 E:\web\commonspot\utilities\add-multiple-images-to-image-cache.cfm
15 ms 8 ms 2 E:\web\commonspot\utilities\ct-limit-inheritance-modebased.cfm
15 ms 8 ms 2 E:\web\commonspot\utilities\ct-render-edit-icon-subitem.cfm
15 ms 15 ms 1 E:\web\commonspot\utilities\upload\is-anon-upload.cfm
15 ms 15 ms 1 E:\web\pcsd\Application.cfm
15 ms 15 ms 1 E:\web\pcsd\cache\s1-n7-p2838-c0-t0-mr-blame.cache
0 ms 0 ms 1 E:\web\commonspot\controls\ct-get-inheritance.cfm
0 ms 0 ms 4 E:\web\commonspot\controls\ct-include-once.cfm
0 ms 0 ms 2 E:\web\commonspot\controls\layout\layout-rowcol-actions.cfm
0 ms 0 ms 3 E:\web\commonspot\controls\layout\layout-setcellvars.cfm
0 ms 0 ms 2 E:\web\commonspot\controls\layout\layout-settablevars.cfm
0 ms 0 ms 2 E:\web\commonspot\controls\linkbar\lbar-ghost-text.cfm
0 ms 0 ms 1 E:\web\commonspot\controls\search\sf-get-params.cfm
0 ms 0 ms 91 E:\web\commonspot\controls\set-caller-vars.cfm
0 ms 0 ms 1 E:\web\commonspot\menu\core-js.cfm
0 ms 0 ms 1 E:\web\commonspot\menu_ie_style.cfm
0 ms 0 ms 1 E:\web\commonspot\metadata\init-cache.cfm
0 ms 0 ms 1 E:\web\commonspot\pagemode\newpagemodeui.cfm
0 ms 0 ms 1 E:\web\commonspot\pagemode\pagemodeui.cfm
0 ms 0 ms 1 E:\web\commonspot\render-body-tag.cfm
0 ms 0 ms 1 E:\web\commonspot\render-head.cfm
0 ms 0 ms 1 E:\web\commonspot\render-metatags.cfm
0 ms 0 ms 1 E:\web\commonspot\security\session-user-approvals.cfm
0 ms 0 ms 1 E:\web\commonspot\set-page-vars.cfm
0 ms 0 ms 1 E:\web\commonspot\startup\core-application-meat.cfm
0 ms 0 ms 1 E:\web\commonspot\startup\handle-head-request.cfm
0 ms 0 ms 1 E:\web\commonspot\startup\handle-request-timeout.cfm
0 ms 0 ms 1 E:\web\commonspot\startup\session-first-global.cfm
0 ms 0 ms 1 E:\web\commonspot\startup\session-first-site.cfm
0 ms 0 ms 1 E:\web\commonspot\static\do-replacements.cfm
0 ms 0 ms 1 E:\web\commonspot\static\get-feature-enabled.cfm
0 ms 0 ms 1 E:\web\commonspot\static\replacement-wrapper.cfm
0 ms 0 ms 1 E:\web\commonspot\utilities\build-dynamic-page-list.cfm
0 ms 0 ms 1 E:\web\commonspot\utilities\build-pagedata.cfm
0 ms 0 ms 1 E:\web\commonspot\utilities\build-user-struct.cfm
0 ms 0 ms 2 E:\web\commonspot\utilities\capture-text.cfm
0 ms 0 ms 1 E:\web\commonspot\utilities\cp-setencoding.cfm
0 ms 0 ms 4 E:\web\commonspot\utilities\ct-render-image.cfm
0 ms 0 ms 2 E:\web\commonspot\utilities\ct-render-input.cfm
0 ms 0 ms 2 E:\web\commonspot\utilities\define-upfront-vars.cfm
0 ms 0 ms 11 E:\web\commonspot\utilities\edit-mode-get-valid.cfm
0 ms 0 ms 8 E:\web\commonspot\utilities\get-image-given-pageid.cfm
0 ms 0 ms 19 E:\web\commonspot\utilities\handle-cache-flags.cfm
0 ms 0 ms 10 E:\web\commonspot\utilities\handle-in-list.cfm
0 ms 0 ms 1 E:\web\commonspot\utilities\newwindow-js-meat.cfm
0 ms 0 ms 2 E:\web\commonspot\utilities\newwindow-js.cfm
0 ms 0 ms 1 E:\web\commonspot\utilities\set-style-vars.cfm
0 ms 0 ms 1 E:\web\commonspot\utilities\upload\get-upload-filename.cfm
0 ms 0 ms 1 E:\web\commonspot\utilities\validation\render-info.cfm
0 ms 0 ms 1 E:\web\commonspot\utilities\write-page-stub.cfm
0 ms 0 ms 1 E:\web\pcsd\OnRequestEnd.cfm
0 ms 0 ms 1 E:\web\pcsd\customcf\ShowHelpButton.cfm
0 ms 0 ms 2 E:\web\pcsd\template-1x1-Base.cfm
32 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
3501 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

GetPageRec (Datasource=commonspot-pcsd, Time=0ms, Records=1) in E:\web\commonspot\utilities\verify-stub-data.cfm @ 01:01:00.000
		SELECT *
		  FROM SitePages
		 WHERE ID=?
			AND AudienceID=0
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2838

FindKeywords (Datasource=commonspot-pcsd, Time=15ms, Records=0) in E:\web\commonspot\utilities\populate-page.cfm @ 01:01:00.000
		SELECT UserID,Keyword
		  FROM Keywords,UserKeywords
		 WHERE Keywords.ID=UserKeywords.KeywordID
			AND UserID = 0
			AND PageID=?
	 ORDER BY Keyword,UserID
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2838

GetRenderOptions (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\utilities\populate-page.cfm @ 01:01:00.000
			SELECT GeneralCategories.Category, RenderOptions.PageID
			  FROM RenderOptions, GeneralCategories
			 WHERE GeneralCategories.ID = RenderOptions.CategoryID
				AND (RenderOptions.PageID IN (1,2,7,2838)) 
		 ORDER BY RenderOptions.PageID Desc
FormData (Datasource=commonspot-pcsd, Time=16ms, Records=0) in E:\web\commonspot\metadata\build-struct.cfm @ 01:01:00.000
	SELECT Data_FieldValue.FieldValue,FormInputControl.FieldName,FormInputControl.type,FormControl.FormName,
			 FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
			 Data_FieldValue.MemoValue, Data_FieldValue.listid
	  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
	 WHERE Data_FieldValue.PageID = ?
		AND Data_FieldValue.FieldID = FormInputControl.ID
		AND Data_FieldValue.FormID = FormControl.ID
		AND FormInputControl.ID = FormInputControlMap.FieldID
		AND FormControl.ID = FormInputControlMap.FormID
		AND FormControl.ID = FormControlMap.FormID
		AND (
				((FormControlMap.ClassConstant = 4)
			
				AND (FormControlMap.ClassID = ?) 
			)
	
			OR ((FormControlMap.ClassConstant = 1) AND ( (FormControlMap.ClassID IN (1,2,7)) ))
	
			OR ((FormControlMap.ClassConstant = 2) AND (FormControlMap.ClassID = ?))
	
			 )
 ORDER BY FormControl.ID, FormInputControl.ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2838
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 1

CheckCustomRender (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\utilities\populate-page.cfm @ 01:01:00.000
		SELECT *
		  FROM Data_Custom_Render
		 WHERE (PageID IN (1,2,7,2838)) 
			AND VersionState >= ?
			AND ModuleID <> 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

ParentTemplateInfo (Datasource=commonspot-pcsd, Time=0ms, Records=1) in E:\web\commonspot\utilities\write-stub.cfm @ 01:01:00.000
			SELECT SubsiteID,Filename,PageType
			  FROM SitePages
			 WHERE ID = 7
CheckUsage (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\generate-usage-stats.cfm @ 01:01:00.000
			SELECT HitCount
			  FROM UsageData
			 WHERE PageID = ?
				AND UserID = ?
				AND DateAccessed = ?
				AND SiteID = ?
				AND ServerID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2838
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_VARCHAR) = 2008-05-09
Parameter #4(CF_SQL_INTEGER) = 2
Parameter #5(CF_SQL_INTEGER) = 1

InsertUsageRec (Datasource=commonspot-pcsd, Time=31ms, Records=0) in E:\web\commonspot\generate-usage-stats.cfm @ 01:01:00.000
				INSERT INTO UsageData
					(ServerID,SiteID,PageID,UserID,DateAccessed,HitCount)
				VALUES
					(?,
					 ?,
					 ?,
					 ?,
					 ?,1)
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 2838
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_VARCHAR) = 2008-05-09

Request.PageData.PageParams (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\render-page-meat.cfm @ 01:01:00.000
				SELECT *
				  FROM Param_Page
				 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
				   AND VersionState=2
	 		 ORDER BY PageID DESC
CheckInheritance (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\utilities\ct-limit-inheritance.cfm @ 01:01:00.000
   SELECT PageID,VersionState,AuthorID
     FROM Data_Menu_Items
    WHERE ControlID=?
		AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

request.pageDHTMLMenus (Datasource=commonspot-pcsd, Time=16ms, Records=18) in E:\web\commonspot\controls\dhtmlmenu\menu-get-data.cfm @ 01:01:00.000
		SELECT *
		FROM Param_WDDX
		WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
			AND ElementTypeID = ?
			AND ControlID > 0
		ORDER BY ControlID, PageID DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 47

request.pageDHTMLItems (Datasource=commonspot-pcsd, Time=15ms, Records=118) in E:\web\commonspot\controls\upfront-generic.cfm @ 01:01:00.000
	SELECT *
	  FROM Data_Menu_Items
	 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) AND ControlID IN (3305,3313,3314,3315,3316,3359,3368,3372,3376,49286,49287,49290,49296,56156,56157,56158,56170,56434)
 ORDER BY ControlID, PageID DESC, ItemPos,VersionID DESC
FindMaxVersions (Datasource=commonspot-pcsd, Time=32ms, Records=118) in E:\web\commonspot\controls\upfront-generic.cfm @ 01:01:01.001
		SELECT PageID,ControlID,ItemID,Max(VersionID) AS MaxVersion
		  FROM Data_Menu_Items
		 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2) AND ControlID IN (3305,3313,3314,3315,3316,3359,3368,3372,3376,49286,49287,49290,49296,56156,56157,56158,56170,56434)
	 GROUP BY PageID,ControlID,ItemID
GetWDDXData (Datasource=commonspot-pcsd, Time=15ms, Records=1) in E:\web\commonspot\utilities\ct-extract-wddx-data.cfm @ 01:01:01.001
	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND ElementTypeID = 47 AND (VersionState = 2) AND PageID IN (2838,7,2,1)
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 47

CurrentCacheClear (Datasource=commonspot-pcsd, Time=0ms, Records=1) in E:\web\commonspot\controls\dhtmlmenu\cpe-menu.cfm @ 01:01:01.001
		SELECT DateLastCacheClear
		  FROM SitePages
		 WHERE ID=?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2838

FindSubSiteID (Datasource=commonspot-pcsd, Time=16ms, Records=1) in E:\web\commonspot\utilities\ct-decipher-linkurl.cfm @ 01:01:01.001
			SELECT SubSiteID, PageType, publicreleasedate, expdate, filename, uploaded
			  FROM SitePages
			 WHERE ID=?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 33598

getPublic (Datasource=commonspot-pcsd, Time=15ms, Records=1) in E:\web\commonspot\utilities\upload\is-anon-upload.cfm @ 01:01:01.001
			SELECT expdate, publicreleasedate
			  FROM sitepages
			 WHERE id = ?
				AND (publicreleasedate <= ?
					OR publicreleasedate = ''
					OR publicreleasedate = NULL)
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 33598
Parameter #2(CF_SQL_VARCHAR) = 2008-05-09 01:01:00

getFiles (Datasource=commonspot-pcsd, Time=0ms, Records=1) in E:\web\commonspot\utilities\upload\get-upload-filename.cfm @ 01:01:01.001
	SELECT ud.publicfilename
	  FROM uploadedDocs ud
	 WHERE ud.pageid = ?
		AND ud.versionstate = 2
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 33598

Request.CtrlInstUpFront (Datasource=commonspot-pcsd, Time=0ms, Records=32) in E:\web\commonspot\controls\control-setup.cfm @ 01:01:02.002
			SELECT ControlID,ControlName
			  FROM ControlInstance
			 WHERE (PageID IN (1,2,7,2838)) 
		 ORDER BY PageID DESC
ReadRestrictions (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\utilities\ct-render-element.cfm @ 01:01:02.002
			SELECT DISTINCT ControlID
			  FROM ItemSecurity
			 WHERE ((PageID = ? AND ApplyTo=0)
						OR ( (PageID IN (1,2,7,2838)) 
							AND ApplyTo = 1))
			   AND ControlID <> 0
			   AND pRead=0
				AND pAuthor=0
				AND pEdit=0
				AND pDesign=0
				AND pApprove=0
				AND pAdmin=0
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2838

Request.PageData.Restrictions (Datasource=commonspot-pcsd, Time=15ms, Records=22) in E:\web\commonspot\security\security-detail-queries.cfm @ 01:01:02.002
			SELECT *
			  FROM RestrictedSecurity
			 WHERE PageID IN (7,2,1)
SecureElements (Datasource=commonspot-pcsd, Time=16ms, Records=0) in E:\web\commonspot\security\security-detail-queries.cfm @ 01:01:02.002
		SELECT DISTINCT ControlID
		  FROM ItemSecurity
		 WHERE
			(
				((ApplyTo=?)
					AND (PageID=?))
				OR
				((ApplyTo=?)
					AND (PageID IN (7,2,1)))
			)
			AND ControlID<>0
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 2838
Parameter #3(CF_SQL_INTEGER) = 1

Request.PageData.ExplicitSecurity (Datasource=commonspot-pcsd, Time=15ms, Records=0) in E:\web\commonspot\security\security-detail-queries.cfm @ 01:01:02.002
			SELECT ControlID,
					 Max(pRead) AS maxRead,
					 Max(pAuthor) AS maxAuthor,
					 Max(pEdit) AS maxEdit,
					 Max(pDesign) AS maxDesign,
					 Max(pStyle) AS maxStyle,
					 Max(pAdmin) AS maxAdmin,
					 Max(pApprove) AS maxApprove
			  FROM ItemSecurity
			 WHERE ( (UserGroupID = ?) )
		      AND
				(
					((ApplyTo=?)
						AND (PageID=?))
					OR
					((ApplyTo=?)
						AND (PageID IN (7,2,1)))
				)
				AND ControlID<>0
		 GROUP BY ControlID
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 2838
Parameter #4(CF_SQL_INTEGER) = 1

Request.SICUpfrontParam (Datasource=commonspot-pcsd, Time=16ms, Records=4) in E:\web\commonspot\sic-param-upfront-queries.cfm @ 01:01:02.002
			
			SELECT *
			  FROM Param_ImageWithCaption
			 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
				AND (VersionState = 2)
		 ORDER BY ControlID,PageID Desc, VersionID Desc
Request.ImageUpfront (Datasource=commonspot-pcsd, Time=31ms, Records=4) in E:\web\commonspot\controls\upfront-generic.cfm @ 01:01:02.002
	SELECT *
	  FROM Data_Image
	 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, ItemPos,VersionID DESC
FindMaxVersions (Datasource=commonspot-pcsd, Time=16ms, Records=4) in E:\web\commonspot\controls\upfront-generic.cfm @ 01:01:02.002
		SELECT PageID,ControlID,ItemID,Max(VersionID) AS MaxVersion
		  FROM Data_Image
		 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2) 
	 GROUP BY PageID,ControlID,ItemID
GetImageURLS (Datasource=commonspot-pcsd, Time=0ms, Records=1) in E:\web\commonspot\utilities\add-multiple-images-to-image-cache.cfm @ 01:01:02.002
	SELECT PageID, SubSiteID, FileName, OrigWidth, OrigHeight
	  FROM ImageGallery
	 WHERE (PageID = ?) 
		AND (VersionState = 2)
		AND SubSiteID IN (SELECT ID FROM SubSites WHERE SiteState=1)
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2846

Request.SICUpfront (Datasource=commonspot-pcsd, Time=16ms, Records=4) in E:\web\commonspot\sic-data-upfront-queries.cfm @ 01:01:02.002
		
		SELECT *
		  FROM Data_ImageWithCaption
		 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 ORDER BY ControlID, PageID Desc, VersionID Desc
UpdateElementInstance (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\cache\cached-render.cfm @ 01:01:02.002
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 2838
Parameter #6(CF_SQL_INTEGER) = 486
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

UpdateElementInstance (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\cache\cached-render.cfm @ 01:01:02.002
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 2838
Parameter #6(CF_SQL_INTEGER) = 487
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

Request.customCFUpfront (Datasource=commonspot-pcsd, Time=0ms, Records=1) in E:\web\commonspot\controls\upfront-generic.cfm @ 01:01:02.002
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC
UpdateElementInstance (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\cache\cached-render.cfm @ 01:01:02.002
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 3
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 2838
Parameter #6(CF_SQL_INTEGER) = 34033
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

CheckInheritance (Datasource=commonspot-pcsd, Time=16ms, Records=6) in E:\web\commonspot\utilities\ct-limit-inheritance.cfm @ 01:01:02.002
   SELECT PageID,VersionState,AuthorID
     FROM Data_LinkList_Items
    WHERE ControlID=?
		AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 488

GetWDDXData (Datasource=commonspot-pcsd, Time=0ms, Records=1) in E:\web\commonspot\utilities\ct-extract-wddx-data.cfm @ 01:01:02.002
	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (2838,7,2,1)  AND (VersionState = 2)) AND ((PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2))))
 ORDER BY PageID Desc, VersionID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 488
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 29

Request.LinkDataUpfront_ItemPos (Datasource=commonspot-pcsd, Time=15ms, Records=21) in E:\web\commonspot\controls\upfront-generic.cfm @ 01:01:02.002
	SELECT *
	  FROM Data_LinkList_Items
	 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, ItemPos,VersionID DESC
FindMaxVersions (Datasource=commonspot-pcsd, Time=16ms, Records=21) in E:\web\commonspot\controls\upfront-generic.cfm @ 01:01:02.002
		SELECT PageID,ControlID,ItemID,Max(VersionID) AS MaxVersion
		  FROM Data_LinkList_Items
		 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2) 
	 GROUP BY PageID,ControlID,ItemID
UpdateElementInstance (Datasource=commonspot-pcsd, Time=16ms, Records=0) in E:\web\commonspot\cache\cached-render.cfm @ 01:01:02.002
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 2838
Parameter #6(CF_SQL_INTEGER) = 488
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

CheckInheritance (Datasource=commonspot-pcsd, Time=16ms, Records=1) in E:\web\commonspot\utilities\ct-limit-inheritance.cfm @ 01:01:02.002
   SELECT PageID,VersionState,AuthorID
     FROM Param_WDDX
    WHERE ControlID=?
		AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 489

checkSearchResults (Datasource=commonspot-pcsd, Time=15ms, Records=0) in E:\web\commonspot\controls\search\cpe-searchform.cfm @ 01:01:02.002
	SELECT PageID
	  FROM ControlInstance
	 WHERE (pageid IN (1,2,7,2838)) 
		AND ControlType = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 37

GetWDDXData (Datasource=commonspot-pcsd, Time=0ms, Records=1) in E:\web\commonspot\utilities\ct-extract-wddx-data.cfm @ 01:01:02.002
	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (2838,7,2,1)  AND (VersionState = 2)) AND ((PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2))))
 ORDER BY PageID Desc, VersionID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 489
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 38

UpdateElementInstance (Datasource=commonspot-pcsd, Time=16ms, Records=0) in E:\web\commonspot\cache\cached-render.cfm @ 01:01:02.002
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 2838
Parameter #6(CF_SQL_INTEGER) = 489
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

CheckInheritance (Datasource=commonspot-pcsd, Time=16ms, Records=0) in E:\web\commonspot\utilities\ct-limit-inheritance.cfm @ 01:01:02.002
   SELECT PageID,VersionState,AuthorID
     FROM Data_LinkList_Items
    WHERE ControlID=?
		AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 490

GetWDDXData (Datasource=commonspot-pcsd, Time=16ms, Records=1) in E:\web\commonspot\utilities\ct-extract-wddx-data.cfm @ 01:01:02.002
	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (2838,7,2,1)  AND (VersionState = 2)) AND ((PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2))))
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 490
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 39

UpdateElementInstance (Datasource=commonspot-pcsd, Time=15ms, Records=0) in E:\web\commonspot\cache\cached-render.cfm @ 01:01:02.002
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 2838
Parameter #6(CF_SQL_INTEGER) = 490
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

CheckInheritanceForCurrentRecs (Datasource=commonspot-pcsd, Time=15ms, Records=1) in E:\web\commonspot\utilities\ct-limit-inheritance-modebased.cfm @ 01:01:02.002
	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

GetTableValues (Datasource=commonspot-pcsd, Time=16ms, Records=1) in E:\web\commonspot\controls\layout\cpe-layout.cfm @ 01:01:02.002
	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

GetCells (Datasource=commonspot-pcsd, Time=0ms, Records=1) in E:\web\commonspot\controls\layout\cpe-layout.cfm @ 01:01:02.002
	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=7 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

GetCellData (Datasource=commonspot-pcsd, Time=31ms, Records=2) in E:\web\commonspot\controls\layout\cpe-layout.cfm @ 01:01:02.002
			SELECT *
			  FROM Data_LayoutCell
			 WHERE ControlID = ?
				AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
				AND (VersionState = 2)
		 ORDER BY ItemID, PageID DESC, VersionID DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

CheckInheritanceForCurrentRecs (Datasource=commonspot-pcsd, Time=0ms, Records=1) in E:\web\commonspot\utilities\ct-limit-inheritance-modebased.cfm @ 01:01:02.002
	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2839

GetTableValues (Datasource=commonspot-pcsd, Time=15ms, Records=1) in E:\web\commonspot\controls\layout\cpe-layout.cfm @ 01:01:02.002
	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2839

GetCells (Datasource=commonspot-pcsd, Time=0ms, Records=2) in E:\web\commonspot\controls\layout\cpe-layout.cfm @ 01:01:02.002
	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=2838 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2839

GetCellData (Datasource=commonspot-pcsd, Time=16ms, Records=2) in E:\web\commonspot\controls\layout\cpe-layout.cfm @ 01:01:02.002
			SELECT *
			  FROM Data_LayoutCell
			 WHERE ControlID = ?
				AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
				AND (VersionState = 2)
		 ORDER BY ItemID, PageID DESC, VersionID DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2839

UpdateElementInstance (Datasource=commonspot-pcsd, Time=16ms, Records=0) in E:\web\commonspot\cache\cached-render.cfm @ 01:01:02.002
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 2839
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 2838
Parameter #6(CF_SQL_INTEGER) = 2842
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

Request.TBUpfrontParam (Datasource=commonspot-pcsd, Time=0ms, Records=12) in E:\web\commonspot\tb-param-upfront-queries.cfm @ 01:01:02.002
		
		SELECT *
		  FROM Param_TextBlock
		 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 ORDER BY ControlID, PageID Desc, VersionID Desc
Request.TBUpfront (Datasource=commonspot-pcsd, Time=32ms, Records=9) in E:\web\commonspot\tb-data-upfront-queries.cfm @ 01:01:03.003
			
			SELECT *
			  FROM Data_TextBlock
			 WHERE (pageID IN (1,2,7,2838)) 
			 	AND versionState = 2
		 ORDER BY ControlID, PageID Desc, VersionID Desc
UpdateElementInstance (Datasource=commonspot-pcsd, Time=16ms, Records=0) in E:\web\commonspot\cache\cached-render.cfm @ 01:01:03.003
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 2839
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 2838
Parameter #6(CF_SQL_INTEGER) = 2843
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

UpdateElementInstance (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\cache\cached-render.cfm @ 01:01:03.003
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 2839
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 2838
Parameter #6(CF_SQL_INTEGER) = 2844
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

UpdateElementInstance (Datasource=commonspot-pcsd, Time=16ms, Records=0) in E:\web\commonspot\cache\cached-render.cfm @ 01:01:03.003
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 2838
Parameter #6(CF_SQL_INTEGER) = 2839
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

UpdateElementInstance (Datasource=commonspot-pcsd, Time=16ms, Records=0) in E:\web\commonspot\cache\cached-render.cfm @ 01:01:03.003
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 2838
Parameter #6(CF_SQL_INTEGER) = 2
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

CheckInheritance (Datasource=commonspot-pcsd, Time=16ms, Records=1) in E:\web\commonspot\utilities\ct-limit-inheritance.cfm @ 01:01:03.003
   SELECT PageID,VersionState,AuthorID
     FROM Data_Schedule_Items
    WHERE ControlID=?
		AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1824

GetWDDXData (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\utilities\ct-extract-wddx-data.cfm @ 01:01:03.003
	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (2838,7,2,1)  AND (VersionState = 2)) AND ((PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2))))
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1824
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 31

GetWDDXData (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\utilities\ct-extract-wddx-data.cfm @ 01:01:03.003
		SELECT *
		  FROM Param_WDDX
		 WHERE PageID=0
			AND ControlID=0
			AND ItemID=?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 31

ScheduleItems (Datasource=commonspot-pcsd, Time=16ms, Records=1) in E:\web\commonspot\controls\schedule\cpe-schedule.cfm @ 01:01:03.003
	SELECT *
	  FROM Data_Schedule_Items
	 WHERE ControlID=1824
		AND ((PageID=2) AND (VersionState=2))
		AND (VersionState = 2) 
		AND ((itemEndDate >= ?)
			OR (itemEndDate is NULL) OR (itemEndDate = ''))
	
	ORDER BY PageID Desc, ItemPos Asc, VersionID DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2008-05-09 01:01:00

GetNumElements (Datasource=commonspot-pcsd, Time=0ms, Records=1) in E:\web\commonspot\controls\schedule\cpe-schedule.cfm @ 01:01:03.003
    SELECT Count(x.uniqueid) AS Total
      FROM (Select DISTINCT uniqueid
			FROM Data_Schedule_Items
			WHERE PageID=?
						AND ControlID = ?
						AND VersionState >= ?
			) x
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2838
Parameter #2(CF_SQL_INTEGER) = 1824
Parameter #3(CF_SQL_INTEGER) = 2

UpdateElementInstance (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\cache\cached-render.cfm @ 01:01:03.003
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 2838
Parameter #6(CF_SQL_INTEGER) = 1824
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

UpdateElementInstance (Datasource=commonspot-pcsd, Time=0ms, Records=0) in E:\web\commonspot\cache\cached-render.cfm @ 01:01:03.003
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 2838
Parameter #6(CF_SQL_INTEGER) = 5221
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

CheckInheritance (Datasource=commonspot-pcsd, Time=0ms, Records=6) in E:\web\commonspot\utilities\ct-limit-inheritance.cfm @ 01:01:03.003
   SELECT PageID,VersionState,AuthorID
     FROM Data_LinkList_Items
    WHERE ControlID=?
		AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5211

GetWDDXData (Datasource=commonspot-pcsd, Time=0ms, Records=1) in E:\web\commonspot\utilities\ct-extract-wddx-data.cfm @ 01:01:03.003
	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (2838,7,2,1)  AND (VersionState = 2)) AND ((PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2