Expert Carpet Care Promises Made - Promises Kept  Home Advice From The Experts What We Do FAQs Customer Comments Service Request Form Glossary Stump The Expert   Friday November 21. 2008   E-mail Reminder Join E-mail     Home E-mail Reminder Join E-mail     Advice From The Experts Deodorization Types of Carpet Types of Cleaning     What We Do Mission Statement What We Don't Do     FAQs     Customer Comments     Service Request Form     Glossary     Stump The Expert   Welcome to the Expert Carpet Care web site. We have developed this web site to allow you to get to know our products and services a bit better, as well as make all of our information available to you 24 hours a day. We specialize in residential cleaning services that leave our customers happy, and their carpets clean!  We know that you have a choice when it comes to carpet and upholstery cleaning. With that in mind we pride ourselves on attention to detail, care in working with you on your needs and a dedication to making sure that you understand the process from start to finish.  When we give you a quote for your cleaning needs, it is based on our years of experience, and that means that you will not be surprised when we present the bill. The bottom line is this:  No Surprises. We use some of the latest technology that is availible, and that means that your carpets and upholstery will be handled with the same care and commitment that we give to each of our customers.  We are here to listen to your needs, and provide the level of service that you expect from a professional cleaning company. Thanks for visiting our site!  If there is anything that we can do, please let us know and we will make sure that we take the time to work with you every step of the way. If you require immediate attention you can send us an email at or give us a call at (651) 490-9208, or use our super quick online form.

Expert Carpet Care (651) 490-9208 info@expercare.com

version (Records=2, Time=0ms)
SQL = 
SELECT version from param

codetype (Records=2, Time=0ms)
SQL = 
SELECT codetype from param

get_color (Records=2, Time=0ms)
SQL = 
select vlinkcolor, alinkcolor, linkcolor from param

companyinfo (Records=2, Time=0ms)
SQL = 
select * from param

get_status (Records=1, Time=0ms)
SQL = 
select status
from dblist
where dbname = 'folder8033'

get_param (Records=2, Time=16ms)
SQL = 
select * from param

get_dblist (Records=1, Time=0ms)
SQL = 
select dbname, status
from dblist
where dbname = 'folder8033'

get_memberid (Records=2, Time=0ms)
SQL = 
select memberid from param

get_members (Records=1, Time=0ms)
SQL = 
select memberid, compcode, currency_symbol, js_text, js_type, soldby_memberid, reseller, memberid
from members
where memberid = 8033

get_pages (Records=1, Time=0ms)
SQL = 
select * from pages where pageid = '1' and displayed not like '0'
order by position

get_home (Records=1, Time=0ms)
SQL = 
select * from pages where pageid = '1'

get_theme (Records=1, Time=16ms)
SQL = 
select * from theme

get_products (Records=0, Time=0ms)
SQL = 
select productid from products

is_paid (Records=2, Time=0ms)
SQL = 
select payed from param

create_new_id (Records=0, Time=0ms)
SQL = 
INSERT into session(ip,referrer,dates,times,useragent,checkout,affiliate) values('38.103.63.56','','11/21/2008','07:53:38','CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',0,'none')

insert_refer (Records=0, Time=0ms)
SQL = 
insert into referrers(referrer, dates) 
	values('','11/21/2008')

get_new_id (Records=1, Time=0ms)
SQL = 
SELECT Max(id) as maxid from session

tot_htm (Records=2, Time=0ms)
SQL = 
select hits_this_month from param

upd_param_stats (Records=0, Time=0ms)
SQL = 
update param set hits_this_month = 33558

get_ids_ip (Records=1, Time=0ms)
SQL = 
select ip,checkout from session where id = 33580

is_flash_on (Records=1, Time=0ms)
SQL = 
select flashon from flashintro

atsbrowse (Records=1, Time=0ms)
SQL = 
select atsvisible from advanced_settings

get_pagename (Records=1, Time=0ms)
SQL = 
select page from pages where pageid = 1

get_pages_from_session (Records=1, Time=0ms)
SQL = 
select pages from session where id = 33580

get_pagename (Records=1, Time=0ms)
SQL = 
select page from pages where pageid = '1'

add_page_to_session (Records=0, Time=0ms)
SQL = 
update session
set pages = ',Home',
	timelast = '07:53:38'
where id = 33580

get_page_name (Records=1, Time=0ms)
SQL = 
select page, titlep, descrip, keywords from pages where pageid = 1

advancedoption (Records=1, Time=0ms)
SQL = 
select headuser, headsystem, headsystem2, headsystem3, headsystem4 from advanced_settings

get_background (Records=1, Time=0ms)
SQL = 
select background from pages where pageid = 1

advancedoption (Records=1, Time=0ms)
SQL = 
select bodyuser, bodysystem, bodysystem2 from advanced_settings

get_popups (Records=0, Time=0ms)
SQL = 
select * from mktg_popups
where pageid = '1'

get_body (Records=1, Time=0ms)
SQL = 
SELECT parent, body, body2, body3, pageparsed, imagesright, leftnavw, width, rightnavw, subpages, topnavparent from pages where pageid = 1

get_parent (Records=1, Time=0ms)
SQL = 
select width, imagesright, leftnavw, rightnavw from pages where pageid = 1

get_specials (Records=0, Time=0ms)
SQL = 
select * from products where parent = 0

show_sub_pages (Records=1, Time=0ms)
SQL = 
select bodysubpages from pages where pageid = 1

show_sub_items (Records=1, Time=0ms)
SQL = 
select bodyshowitems from pages where pageid = 1

get_left_nav (Records=1, Time=0ms)
SQL = 
SELECT * from pages where pageid = '1'

get_top_nav (Records=1, Time=0ms)
SQL = 
select imagestop, imagesizest, imagestoproll, linktop, topnavh from pages where pageid = '1'

get_head_info (Records=1, Time=0ms)
SQL = 
select width,topnavh from pages where pageid = 1

get_topnav_parent (Records=1, Time=0ms)
SQL = 
select topnavparent from pages where ((pageid = 1) AND (displayed NOT LIKE '0'))

get_leftnav (Records=1, Time=0ms)
SQL = 
select * from leftnav

get_searchshow (Records=2, Time=0ms)
SQL = 
select showsearch from param

get_subpages_topnav (Records=8, Time=15ms)
SQL = 
select * from pages where ((topnavparent = 'none') AND (displayed NOT LIKE '0')) order by position

get_session (Records=1, Time=0ms)
SQL = 
select * from session where id = 33580

chk_b2bpage (Records=1, Time=0ms)
SQL = 
select pid from item_library where iid = 1

get_subpages_topnav (Records=2, Time=0ms)
SQL = 
select distinct page, pageid, page_type, position from pages where ((topnavparent = '1') AND (pages.displayed NOT LIKE '0')) order by position

get_products (Records=0, Time=0ms)
SQL = 
select productid from products

get_main_pages (Records=8, Time=0ms)
SQL = 
select * from pages where  topnavparent = 'none' AND (displayed NOT LIKE '0') order by position

advancedoption (Records=1, Time=0ms)
SQL = 
select leftnavuser, leftnavsystem, leftnavsystem2, leftnavsystem3 from advanced_settings

get_qvpageid (Records=0, Time=0ms)
SQL = 
select pid, iid from item_library where pid = '40'

get_topics (Records=0, Time=0ms)
SQL = 
select * from qvtopics
where leftnav = 1
order by tname

get_cal (Records=2, Time=0ms)
SQL = 
select calendar_left from param

get_items_in_cart (Records=0, Time=0ms)
SQL = 
select * from carts right join products on carts.item = products.productid where ownerid like 33580 order by carts.item, carts.cartoptions

chk_b2bpage (Records=1, Time=0ms)
SQL = 
select pid from item_library where iid = 1

get_sub_pages (Records=2, Time=0ms)
SQL = 
select distinct page, pageid, page_type, position from pages where ((topnavparent = '1') AND (pages.displayed NOT LIKE '0')) order by position

chk_b2bpage (Records=1, Time=0ms)
SQL = 
select pid from item_library where iid = 21

get_sub_pages (Records=3, Time=0ms)
SQL = 
select distinct page, pageid, page_type, position from pages where ((topnavparent = '21') AND (pages.displayed NOT LIKE '0')) order by position

chk_b2bpage (Records=1, Time=0ms)
SQL = 
select pid from item_library where iid = 29

get_sub_pages (Records=2, Time=0ms)
SQL = 
select distinct page, pageid, page_type, position from pages where ((topnavparent = '29') AND (pages.displayed NOT LIKE '0')) order by position

chk_b2bpage (Records=1, Time=0ms)
SQL = 
select pid from item_library where iid = 23

get_sub_pages (Records=0, Time=0ms)
SQL = 
select distinct page, pageid, page_type, position from pages where ((topnavparent = '23') AND (pages.displayed NOT LIKE '0')) order by position

chk_b2bpage (Records=1, Time=0ms)
SQL = 
select pid from item_library where iid = 22

get_sub_pages (Records=0, Time=0ms)
SQL = 
select distinct page, pageid, page_type, position from pages where ((topnavparent = '22') AND (pages.displayed NOT LIKE '0')) order by position

chk_b2bpage (Records=1, Time=0ms)
SQL = 
select pid from item_library where iid = 25

get_sub_pages (Records=0, Time=0ms)
SQL = 
select distinct page, pageid, page_type, position from pages where ((topnavparent = '25') AND (pages.displayed NOT LIKE '0')) order by position

chk_b2bpage (Records=1, Time=0ms)
SQL = 
select pid from item_library where iid = 24

get_sub_pages (Records=0, Time=0ms)
SQL = 
select distinct page, pageid, page_type, position from pages where ((topnavparent = '24') AND (pages.displayed NOT LIKE '0')) order by position

chk_b2bpage (Records=1, Time=0ms)
SQL = 
select pid from item_library where iid = 30

get_sub_pages (Records=0, Time=0ms)
SQL = 
select distinct page, pageid, page_type, position from pages where ((topnavparent = '30') AND (pages.displayed NOT LIKE '0')) order by position

newcommand (Records=0, Time=0ms)
SQL = 
INSERT INTO tabchange (tab)
values ('1')

select (Records=1, Time=0ms)
SQL = 
SELECT MAX(command) AS comm FROM tabchange

get_all_sub_items (Records=0, Time=16ms)
SQL = 
select * from products_pages
	left join products on products_pages.productid = products.productid
	where products_pages.pageid = 1
	and products.display = 1
	order by products.partno desc

get_theme (Records=1, Time=0ms)
SQL = 
select * from theme

get_parsed (Records=1, Time=0ms)
SQL = 
select parsedcode from pages where pageid = 1

get_body (Records=1, Time=0ms)
SQL = 
SELECT parent, body, body2, body3, pageparsed, imagesright, leftnavw, width, rightnavw, subpages, topnavparent from pages where pageid like '1'

advancedoption (Records=1, Time=0ms)
SQL = 
select pageheaduser, pageheadsystem, pageheadsystem2 from advanced_settings

check (Records=1, Time=93ms)
SQL = 
SELECT special, page, pageid, page_type
from pages
where pageid = 1

getinfo (Records=1, Time=0ms)
SQL = 
SELECT *
from item_library
where iid = 1 and p_or_l = 0

getinfo2 (Records=1, Time=0ms)
SQL = 
SELECT *
from page_item_library
where pid = '1'

get_body (Records=1, Time=0ms)
SQL = 
SELECT pageparsed
FROM pages
where pageid = 1

format (Records=1, Time=0ms)
SQL = 
SELECT *
FROM formatting_library
where fid = '1'

format (Records=1, Time=0ms)
SQL = 
SELECT *
FROM formatting_library
where fid = '1'

format (Records=1, Time=0ms)
SQL = 
SELECT *
FROM formatting_library
where fid = '1'

get_listings (Records=0, Time=0ms)
SQL = 
SELECT *
FROM item_library
WHERE iid = 1 AND p_or_l = 1

advancedoption (Records=1, Time=0ms)
SQL = 
select pagefootuser, pagefootsystem, pagefootsystem2 from advanced_settings

search_for (Records=0, Time=0ms)
SQL = 
select * from products_pages
		left join products on products_pages.productid = products.productid
		where products_pages.pageid = 1
		and products.display = 1
		and products.b2b not like 1 
		order by products.partno desc

get_specials (Records=0, Time=0ms)
SQL = 
select * from products_pages
	left join products on products_pages.productid = products.productid
	where products_pages.pageid = 0 AND products_pages.pageid NOT LIKE 'h'

get_bot_grfx (Records=1, Time=0ms)
SQL = 
select min(powered_logo) as powered_logo, min(powered_logo_link) as powered_logo_link
from resellers_data 
where resid = 6078

get_bot_comp (Records=1, Time=0ms)
SQL = 
select compcode from members where memberid = 6078

get_brand_site (Records=1, Time=0ms)
SQL = 
select memberid, compcode from members where portal_site = 1

get_logo (Records=1, Time=0ms)
SQL = 
select powered_logo, powered_logo_link
from resellers_data 
where resid = 6078

281 milliseconds

CGI Variables:

AUTH_TYPE=
CF_TEMPLATE_PATH=d:/commercecreators/ccv5/sites/folder8033/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
HTTP_ACCEPT=Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
HTTP_ACCEPT_CHARSET=ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CACHE_CONTROL=no-cache
HTTP_CONNECTION=close
HTTP_HOST=expercare.com
HTTP_PRAGMA=no-cache
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
QUERY_STRING=
REMOTE_ADDR=38.103.63.56
REMOTE_HOST=
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=expercare.com
SERVER_PORT=80
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/1.3.29 (Win32) mod_ssl/2.8.16 OpenSSL/0.9.7c