Services We Provide

We provide Residential and Commercial Excavating services such as:

Septic System Design & Installation
Road Building
Driveways
Site Preparation
Basements
Lot Clearing
Building Demolition
Dozer Work
Black Dirt
Fill Dirt
Sand
Class 5 Gravel
Class 1 Gravel
Field Rock

Raymond would be happy to meet with you at your project site to provide you with a free estimate. His knowledge and experience can be very beneficial in planning your project.

TESTIMONIALS

We have been using Schrupp Excavating for all of North Ward Homes' excavation, septic, site work, road construction and demo needs for over 15 years.

Ray and his crew have proved to be an invaluable resource over the past years by providing North Ward Homes with professionalism, timeliness, vast experience and knowledge in the excavation and septic industry.

Ray and his wife, Wendy, are respected members of the business and construction community.

The office and field operations are equally efficient!

You can always count on things being done right and delivered on schedule.

Schrupp Excavating is our solid professional choice for earth work every time.

Daren Ward
North Ward Homes, Inc.

Debugging Information

ColdFusion Server Standard	2018,0,13,329786
Template	/index.cfm
Time Stamp	24-Sep-22 07:00 PM
Locale	English (US)
User Agent	Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
Remote IP	24.111.43.158
Host Name	24.111.43.158

Execution Time

Total Time	Avg Time	Count	Template
47 ms	47 ms	1	C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\index.cfm
16 ms	16 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runapp.cfm
16 ms	16 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runnavulli.cfm
16 ms	16 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runtextlinks.cfm
16 ms	16 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/webapp.cfm
16 ms	16 ms	1	C:/inetpub/wwwroot/partners/seriouslyfunmarketing.com/schruppexcavating.com/Application.cfm
16 ms	16 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| CustomURLsToULLI(argumentcollection = [complex value]) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
16 ms	16 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| RCInitSite(domain = schruppexcavating.com, bForceReload = true) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
15 ms	15 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runslideshow.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/content.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runBootstrap3.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/rundetectSQLinjection.cfm
0 ms	0 ms	3	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runjQuery.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runjQueryValidate.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runmain.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runmetatags.cfm
0 ms	0 ms	6	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runscriptinclude.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runscroll.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runstats.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/scroll.cfm
0 ms	0 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/website.cfm
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| getRunSpotSpiderSafeURL(url = /index.cfm?about-us) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| getRunSpotSpiderSafeURL(url = /index.cfm?contact-us) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| getRunSpotSpiderSafeURL(url = /index.cfm?home) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| getRunSpotSpiderSafeURL(url = /index.cfm?links-numbers) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| getRunSpotSpiderSafeURL(url = /index.cfm?services) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| getSiteURLs(bIncludeDocuments = false, stSession = [complex value]) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc \| parseRunSpotSpiderSafeURL() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNav.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNavTree.cfc \| NavTreeAddAttributes(argumentcollection = [complex value]) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNavTree.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNavTree.cfc \| NavTreeToULLI_render(arrNavTreeWithAttributes = [complex value]) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSNavTree.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSVPV.cfc \| doVPVGroupsExist(1) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSVPV.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSVPV.cfc \| doVPVGroupsExist(WebsiteID = 1) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSVPV.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSVPV.cfc \| doVPVTablesExist(dsn_override = schruppexcavating.com, WebsiteID = 1) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/RSVPV.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcCommonDBPageTypes.cfc \| SelectByPK(PageTypeID = 1, dsn_override = common) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcCommonDBPageTypes.cfc
0 ms	0 ms	2	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBPages.cfc \| SelectByPK(17, schruppexcavating.com) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBPages.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBScrollItems.cfc \| SelectByPK(6, schruppexcavating.com) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBScrollItems.cfc
0 ms	0 ms	2	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBScrollItems.cfc \| getCOLUMNSCOLUMNTYPESstruct() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBScrollItems.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBWebsites.cfc \| SelectByPK(1, schruppexcavating.com) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/db/rcDBWebsites.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsCGI.cfc \| INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsCGI.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsCGI.cfc \| isSpider() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsCGI.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsConfigDB.cfc \| GetConfigGroupStruct(vcGroup = SystemSetup1) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsConfigDB.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsList.cfc \| ListRemoveDupes(list = Pine River,Backus,Hackensack,Akeley,Park Rapids,Walker,Longville,Pequot Lakes,Outing,Fifty Lakes,Emily,Crosslake,Cross lake,Nisswa,Staples,Crosby,Emily,Excavating,Schrupp Excavating,septic systems,sewer systems,rock,gravel,demolition,black dirt,sand,fill,dirt,driveways,clearing,brushing,grading,sewer,septic,excavating pequot lakes,excavating crosslake,excavating nisswa,septic pequot lakes,septic pine river,septic crosslake) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsList.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsSQLInjectionDetect.cfc \| SQLInjectionDetected() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsSQLInjectionDetect.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsStruct.cfc \| structRemoveEmptyKeys(structure = [complex value]) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsStruct.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsTCPIP.cfc \| IPv4ToUInt32(vcIPv4 = 24.111.43.158) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsTCPIP.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsURL.cfc \| isXSS(vcContent = ) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/jcsURL.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| SelectMediaByTypeIDIDValue(15, 6, schruppexcavating.com) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| SelectMediaByTypeIDIDValue(dsn_override = schruppexcavating.com, MediaTypeID = 23, IDValue = 2) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| TableColumnExists(vcColumnName = Target, dsn_override = schruppexcavating.com, vcTableName = Pages) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	1	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| cleanUpMetaKeywords(meta_keywords = Pine River, Backus, Hackensack, Akeley, Park Rapids, Walker, Longville, Pequot Lakes, Outing, Fifty Lakes, Emily, Crosslake, Cross lake, Nisswa, Staples, Crosby, Emily, Excavating, Schrupp Excavating, septic systems, sewer systems, rock, gravel, demolition, black dirt, sand, fill, dirt, driveways, clearing, brushing, grading, sewer, septic, excavating pequot lakes, excavating crosslake, excavating nisswa, septic pequot lakes, septic pine river, septic crosslake) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	2	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| init() ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms	0 ms	2	CFC[ C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc \| isProductsMeta_KeywordsDefined(dsn_override = schruppexcavating.com) ] from C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runcontent.cfc
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
63 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

local.qryGetWebSiteByDomain (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT * FROM websites WHERE domain = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_VARCHAR) = schruppexcavating.com

local.qryTableColumnExist (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ? AND COLUMN_NAME = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_VARCHAR) = AdminNav

			    
			        Parameter #2(CF_SQL_VARCHAR) = WebsiteID

local.qryEcommerceTools (Datasource=schruppexcavating.com, Time=16ms, Records=0) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT TOP 1
	AN.WebsiteID, AN.CustomTool, AN.CommonTool, AN.AdminNavID,
	MG.M_GroupID, GroupName = MG.Name,
	MT.M_ToolID, ToolName = MT.Name, MT.TagName, MT.OrderBy
FROM
	AdminNav AN
	JOIN common.dbo.M_Tools MT ON AN.M_ToolID = MT.M_ToolID
	JOIN common.dbo.M_Groups MG ON MT.M_GroupID = MG.M_GroupID
WHERE
	AN.WebsiteID = 1
	AND AN.commontool = 1
	AND MG.M_GroupID = 4

local.qryConfigSGroupByGroup (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\jcsConfigDB.cfc @ 19:00:51.051

SELECT
	[nConfigID], [vcGroup], [vcKey], [vcValue]
FROM
	[Config]
WHERE
	[vcGroup] = ?
ORDER BY
	[vcKey]

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = SystemSetup1

getpreset (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

				select pageid from pages where pagepresetid=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_VARCHAR) = services

verifycart (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

			select count(*) as total from [orders] where ordernum=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_VARCHAR) = 0

local.qryVPVPageGroups (Datasource=schruppexcavating.com, Time=0ms, Records=0) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\RSNav.cfc @ 19:00:51.051

SELECT
	pg.*
FROM
	VPVPageGroup pg
	JOIN VPVGroup g ON pg.nVPVGroupID = g.nVPVGroupID
WHERE
	g.WebsiteID = ?
ORDER BY
	pg.PageID, pg.nVPVGroupID

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

local.qryTableColumnExist (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ? AND COLUMN_NAME = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_VARCHAR) = Pages

			    
			        Parameter #2(CF_SQL_VARCHAR) = Target

local.qryGetAllURLs (Datasource=schruppexcavating.com, Time=0ms, Records=5) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\RSNav.cfc @ 19:00:51.051

SELECT
	p.PageID, p.[Name], p.PagePresetID, p.OrderBy, p.location
	,COALESCE(p.target, '_self') AS target, p.secure
	,p.PageDisplay, p.MenuDisplay, p.[meta_descrip], p.PageNonLinkable
	,COALESCE(po.PageID, 0) AS ParentID, COALESCE(po.OrderBy, 0) AS ChildOrderBy
	,(SELECT TOP 1 m.filename FROM media m WHERE m.mediatypeid = 2 AND m.idvalue = p.PageID) AS ImageFilename
	,(SELECT COUNT(*) FROM pageorder po1 WHERE po1.pageid = p.PageID AND po1.childid IN (SELECT DISTINCT p1.pageid FROM pages p1 WHERE p1.menudisplay=1 AND p1.pagedisplay=1)) AS childtotal
FROM
	pages p LEFT JOIN pageorder po ON p.PageID = po.ChildID
WHERE
	p.websiteid = ?
	AND COALESCE(p.[name],'') <> ''
ORDER BY
	COALESCE(po.PageID, 0) DESC,
	CASE
		WHEN COALESCE(po.PageID, 0) = 0 THEN p.OrderBy
		ELSE COALESCE(po.OrderBy, 0)
	END DESC

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

qryGetOrderedURLs (Datasource=, Time=0ms, Records=5) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\RSNav.cfc @ 19:00:51.051

SELECT
	*
FROM
	[local].qryGetAllURLs
ORDER BY
	Ancestry

local.qrySelectByPK (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\db\rcDBPages.cfc @ 19:00:51.051

SELECT
	*
FROM
	[Pages]
WHERE
	[PageID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 17

getpagemeta (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runmetatags.cfm @ 19:00:51.051

select pageid,meta_title,meta_descrip,meta_keywords from pages where

pageid=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 17

getproductmeta (Datasource=schruppexcavating.com, Time=0ms, Records=0) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runmetatags.cfm @ 19:00:51.051

SELECT
	CAST(p.Meta_Keywords AS VARCHAR(MAX)) AS Meta_Keywords
FROM
	Products p
WHERE
	COALESCE(CAST(p.Meta_Keywords AS VARCHAR(MAX)), '''') <> ''''
	AND p.ProductID IN (SELECT idvaluetext FROM pageproducts WHERE idtype=2 AND (pageid=? OR pageid IN (SELECT pageid FROM pages WHERE websiteid=? AND mainpage=1)))
UNION
SELECT
	CAST(p.Meta_Keywords AS VARCHAR(MAX)) AS Meta_Keywords
FROM
	Products p
WHERE
	COALESCE(CAST(p.Meta_Keywords AS VARCHAR(MAX)), '''') <> ''''
	AND p.FamilyID IN (SELECT idvalue FROM pageproducts WHERE idtype=1 AND (pageid=? OR pageid IN (SELECT pageid FROM pages WHERE websiteid=? AND mainpage=1)))

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 17

			    
			        Parameter #2(CF_SQL_INTEGER) = 1

			    
			        Parameter #3(CF_SQL_INTEGER) = 17

			    
			        Parameter #4(CF_SQL_INTEGER) = 1

local.qrySelectByPK (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\db\rcDBWebsites.cfc @ 19:00:51.051

SELECT
	*
FROM
	[Websites]
WHERE
	[WebsiteID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

qryGALogin (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runstats.cfm @ 19:00:51.051

SELECT TOP 1 * FROM stats ORDER BY StatID

qrySlideShow (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runslideshow.cfm @ 19:00:51.051

SELECT TOP 1 * FROM [SlideShow] WHERE [name] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_VARCHAR) = slides-banner

qrySlideShowItem (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runslideshow.cfm @ 19:00:51.051

SELECT
	ssi.*
FROM
	SlideShowItem AS ssi LEFT JOIN SlideShowPage AS ssp ON ssi.nSlideShowItemID = ssp.nSlideShowItemID
WHERE
	ssi.nSlideShowID = ?
	AND (ssp.PageID IS NULL OR ssp.PageID = ?)
ORDER BY
	ssi.orderby ASC

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

			    
			        Parameter #2(CF_SQL_INTEGER) = 17

local.qryMediaByTypeIDIDValue (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT
	*
FROM
	[media]
WHERE
	[MediaTypeID] = ?
	AND [IDValue] = ?
ORDER BY
	[OrderBy], [MediaID]

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 23

			    
			        Parameter #2(CF_SQL_INTEGER) = 2

local.qryVPVGroupsExist (Datasource=schruppexcavating.com, Time=0ms, Records=0) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\RSVPV.cfc @ 19:00:51.051

SELECT
	1
FROM
	[VPVGroup]
WHERE
	[WebsiteID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

local.qryVPVGroupsExist (Datasource=schruppexcavating.com, Time=0ms, Records=0) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\RSVPV.cfc @ 19:00:51.051

SELECT
	1
FROM
	[VPVGroup]
WHERE
	[WebsiteID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

local.qrySelectByPK (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\db\rcDBPages.cfc @ 19:00:51.051

SELECT
	*
FROM
	[Pages]
WHERE
	[PageID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 17

getsections (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\website.cfm @ 19:00:51.051

select
  *
from
  pagedisplay
where
  pageid=?
order by
  orderby

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 17

local.qrySelectByPK (Datasource=common, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\db\rcCommonDBPageTypes.cfc @ 19:00:51.051

SELECT
	*
FROM
	[PageTypes]
WHERE
	[PageTypeID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

chkcustom (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\website.cfm @ 19:00:51.051

					select * from websiteoptions where websiteid=? and pagetypeid=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

			    
			        Parameter #2(CF_SQL_INTEGER) = 1

getitem (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\content.cfm @ 19:00:51.051

select
  body
from 
  pagetext 
where
  websiteid = ?
  and pageid = ?
  and pagedisplayid = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

			    
			        Parameter #2(CF_SQL_INTEGER) = 17

			    
			        Parameter #3(CF_SQL_INTEGER) = 0

qryScroll (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\scroll.cfm @ 19:00:51.051

select * from scroll
where
	websiteid = ? 
	AND name = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

			    
			        Parameter #2(CF_SQL_VARCHAR) = testimonials

chk (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\scroll.cfm @ 19:00:51.051

		select count(*) as total from scrollitems where scrollid=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 2

getnums (Datasource=schruppexcavating.com, Time=0ms, Records=9) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\scroll.cfm @ 19:00:51.051

					select scrollitemid from scrollitems where scrollid=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 2

local.qrySelectByPK (Datasource=schruppexcavating.com, Time=0ms, Records=1) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\db\rcDBScrollItems.cfc @ 19:00:51.051

SELECT
	*
FROM
	[ScrollItems]
WHERE
	[ScrollItemID] = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 6

local.qryMediaByTypeIDIDValue (Datasource=schruppexcavating.com, Time=0ms, Records=0) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runcontent.cfc @ 19:00:51.051

SELECT
	*
FROM
	[media]
WHERE
	[MediaTypeID] = ?
	AND [IDValue] = ?
ORDER BY
	[OrderBy], [MediaID]

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 15

			    
			        Parameter #2(CF_SQL_INTEGER) = 6

gettl (Datasource=schruppexcavating.com, Time=16ms, Records=5) in C:\ColdFusion2018\cfusion\CustomTags\RunContent_20\runtextlinks.cfm @ 19:00:51.051

SELECT pageid,[name],location,target,PagePresetID FROM pages 
WHERE NOT pageid IN (SELECT childid FROM pageorder) AND menudisplay=1 AND pagedisplay=1
ORDER BY orderby

Scope Variables

Application Variables:
abspath=/
address1=3003 - 36th Street SW
address2=
applicationname=schruppexcavating.com
arrsiteurls=Array (5)
baseurl=index.cfm
bdebug=true
bgcolor=FFFFFF
bmobileuseragent=false
bpagenonlinkabledefined=Yes
bproductsmeta_keywordsdefined=Yes
brunshop=false
bvpvtablesexist=Yes
cachedwithin=0.00694444444444
cart_fontcolor=000000
cart_hicolor=DDDDDD
cart_lowcolor=EEEEEE
cartpath=http://schruppexcavating.com/cart
cc=
cgi_domain=schruppexcavating.com
checkoutsecure=https://runspot.biz/partners/seriouslyfunmarketing.com/schruppexcavating.com/secure/
city=Pine River
companyname=Schrupp Excavating, LLC
contentwidth=760
country=United States
debuggingipaddresses=Array (2)
domain=schruppexcavating.com
dsn=schruppexcavating.com
dtcreatednav={ts '2022-09-20 22:14:25'}
email=contact@schruppexcavating.com
fax=
fontcolor=000000
fontface=Arial
fontsize=2
hicolor=
iconpath=https://runspot.biz/!admin/soeditor/
imagedisplay=/media/content/
imagepath=/partners/seriouslyfunmarketing.com/schruppexcavating.com/media/content/
imageupload=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\media\content\
imagewrite=http://schruppexcavating.com/media/content/
lowcolor=EEEEEE
lstdebugips=10.10.1.158,24.111.43.158
maindsn=schruppexcavating.com
media=media
mediafilepath=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\media
mediaurl=http://schruppexcavating.com/media
meta_descrip=Excavating, Septic System, Demolition
meta_keywords=Pine River,Backus,Hackensack,Akeley,Park Rapids,Walker,Longville,Pequot Lakes,Outing,Fifty Lakes,Emily,Crosslake,Cross lake,Nisswa,Staples,Crosby,Excavating,Schrupp Excavating,septic systems,sewer systems,rock,gravel,demolition,black dirt,sand,fill,dirt,driveways,clearing,brushing,grading,sewer,septic,excavating pequot lakes,excavating crosslake,excavating nisswa,septic pequot lakes,septic pine river,septic crosslake
midcolor=DDDDDD
phone=218-587-4038
productpath=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\media\products
producturl=http://schruppexcavating.com/media/products
reloadfilepath=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\admin\reload
rootfilepath=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\
scriptpath=/!admin/soeditor/
secureabspath=/partners/seriouslyfunmarketing.com/schruppexcavating.com/
sfontsize=1
shipaddress=
shipcity=
shippingbypercent=0
shippingid=1
shipstate=
shipzip=
showpriceid=0
siteframework=Bootstrap 3.x
spchurl=http://schruppexcavating.com
spidersafe=1
state=MN
tollfree=
url=http://schruppexcavating.com
urlssl=https://runspot.biz
webpalette=
websiteid=1
zip=56474

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=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\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=text/html,image/png,image/jpeg,image/pjpeg,image/x-xbitmap,image/svg+xml,image/gif;q=0.9,*/*;q=0.1
HTTP_ACCEPT_ENCODING=gzip, identity;q=0.9
HTTP_ACCEPT_LANGUAGE=en, *
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=$Version=1; CFID=16120770; $Path=/; CFTOKEN=87f84cae21c7f43b-7376403A-5056-A834-8F8B274B1A69E8F7; $Path=/
HTTP_HOST=schruppexcavating.com
HTTP_REFERER=http://schruppexcavating.com/
HTTP_URL=/index.cfm/services
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=64.73.214.25
PATH_INFO=/services
PATH_TRANSLATED=C:\inetpub\wwwroot\partners\seriouslyfunmarketing.com\schruppexcavating.com\index.cfm
QUERY_STRING=
REMOTE_ADDR=24.111.43.158
REMOTE_HOST=24.111.43.158
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=schruppexcavating.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=

Cookie Variables:
CFID=16120770
CFTOKEN=87f84cae21c7f43b-7376403A-5056-A834-8F8B274B1A69E8F7

Request Parameters:
additional_methods_min=true
blogwebpages=true
bootstrap_min_js=true
bootstrapcssurlpath=/css/bootstrap/
bootstrapthemecssurl_inc=true
bootstrapthemefn=bootstrap.min.css
bootstrapversion=3.3.7
bspider=false
dsnconfig=schruppexcavating.com
dsnrunspot=schruppexcavating.com
jquery_cycle_all=true
jquery_form=true
jquery_validate_min=true
jqueryincluded=true
jqueryuiincluded=false
lstdebugips=10.10.1.158,24.111.43.158
samesite_value=
server_name=https://runspot.biz
server_name_no_protocol=//runspot.biz
stjqmigratescriptattribs=Struct (15)
stjqscriptattribs=Struct (79)
stsession=Struct (74)
useragent=mozilla/4.5 (compatible; httrack 3.0x; windows 98)

Session Variables:
adminlevel=none
adminlogin=notcool
arrsiteurls=Array (5)
cfid=16120770
cftoken=87f84cae21c7f43b-7376403A-5056-A834-8F8B274B1A69E8F7
loginname=
mainpage=0
orderid=0
ordernum=0
page_title=Services
pageid=17
scrollitemid=0
sessionid=SCHRUPPEXCAVATING.COM_16120770_87f84cae21c7f43b-7376403A-5056-A834-8F8B274B1A69E8F7
t_pageid=0
t_websiteid=0
toolpageid=0
totalcart=0
totalqty=0
urltoken=CFID=16120770&CFTOKEN=87f84cae21c7f43b-7376403A-5056-A834-8F8B274B1A69E8F7
userid=0
userlogin=notcool
websiteid=0
welcome=

URL Parameters:
PageID=17
preset=services

Debug Rendering Time: 0 ms