About Schrupp Excavating

Starting in 1983 with an old tractor/backhoe and an old dump truck, Raymond is now operating a company with 22 employees, many pieces of new equipment and dump trucks. The crew is made up of dedicated, knowledgeable, and courteous men that know their job and do it well.

Check out this awesome video by our amazing friends Jon & Kari Bergmann.
Click here to watch.

Schrupp Excavating LLC is known through the lakes area for their professionalism, timeliness, and getting the job done right.

Contact Information
Business Phone: 218-587-4038
Fax: 218-587-3473
Email: schruppexcavating@gmail.com

TESTIMONIALS

It has been our pleasure to work with Schrupp Excavating on construction projects for the past four years. We have developed a great working relationship with Ray and Wendy Schrupp and their employees. There quick response to calls and questions is surpassed only by their service and ability to get the job done right and on time. Schrupp Excavating always has the right machine with talented operators for any job. We would recommend Schrupp Excavating for any job, large or small, without reservation. They are simply one of the best.

Baratto Brothers Construction, Inc.

Just a note to let you know how pleased we are with the job you folks did. You have a great crew of men.

Jamie Duke

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
46 ms	46 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/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/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
15 ms	15 ms	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runtextlinks.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	1	C:/ColdFusion2018/cfusion/CustomTags/RunContent_20/runnavulli.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 \| CustomURLsToULLI(argumentcollection = [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 \| 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(12, 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(9, 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, 9, 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
62 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=0ms, 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) = about-us

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) = 12

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) = 12

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) = 12

			    
			        Parameter #2(CF_SQL_INTEGER) = 1

			    
			        Parameter #3(CF_SQL_INTEGER) = 12

			    
			        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) = 12

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) = 12

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) = 12

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) = 12

			    
			        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) = 9

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) = 9

gettl (Datasource=schruppexcavating.com, Time=0ms, 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/about-us
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=64.73.214.25
PATH_INFO=/about-us
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=About Us
pageid=12
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=12
preset=about-us

Debug Rendering Time: 0 ms