People who are planning on traveling in other countries will often contact an automobile road service to obtain passport photographs. Many automobile road services also provide the paper work to apply for an international driving permit. Staff that work for automobile road services may have additional information about driving rules and regulations in other countries. Some automobile road services do not require annual membership for people to take advantage of their assistance. An automobile road service may be able to provide other information about what to expect while driving in other countries such as historical points of interest and highway maps.

HOME MAJOR CITIES CATEGORIES LINK TO ZIPSLOCAL ABOUT US

Queries

sitevars (Records=1, Time=0ms)
SQL = 
select *
		from	sitevars where siteid = 4

GetCity (Records=1, Time=0ms)
SQL = 
SELECT	City, StateCode, GeoCityID
	FROM	ZipCoords
	WHERE	iZip=06040

GetCat (Records=1, Time=16ms)
SQL = 
SELECT	MYCatID, CatName, htmlTitle, keywordSingle2 AS KW
	FROM	listingcategories
	WHERE	CatName='Automobile Road Service' AND Display='Y'

 (Records=22, Time=63ms)
SQL = 
spZipsLocalListings

 (Records=28, Time=15ms)
SQL = 
spGetRelatedCats

getRelatedCats (Records=27, Time=0ms)
SQL = 
SELECT		*
	FROM		getRelatedCats1
	WHERE		MYCatID <> 241924
	ORDER BY	catName

GetNearbyZips1 (Records=50, Time=31ms)
SQL = 
SELECT		TOP 50 a.TargetZip, a.Distance, b.City, b.StateCode
	FROM		ZipDistances a INNER JOIN ZipCoords b ON a.TargetZip=b.iZip
	WHERE		a.BaseZip=06040 AND a.TargetZip<>06040
	ORDER BY	a.Distance

GetNearbyZips (Records=50, Time=0ms)
SQL = 
SELECT		*
	FROM		GetNearbyZips1
	ORDER BY	TargetZip

getArticleLong (Records=0, Time=125ms)
SQL = 
SELECT textSection1 AS articleText, title, articleID, myCatID, styleID
		FROM Article
		WHERE display = 1
			AND myCatID = 241924
			AND styleID = (SELECT StyleID FROM ArticlePlacementsCurrent WHERE PlacementID=11)
		ORDER BY createDt desc

getArticleLong (Records=1, Time=62ms)
SQL = 
SELECT textSection1 AS articleText, title, articleID, myCatID, styleID
		FROM Article
		WHERE display = 1
			AND myCatID = 241924
			AND styleID = (SELECT StyleID FROM ArticlePlacementsCurrent WHERE PlacementID=12)
		ORDER BY createDt desc

Execution Time

344 milliseconds

0 ms	D:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
62 ms	D:\WEBSITES\ZIPSLOCAL\ARTICLELISTINGSBOTTOM.CFM
125 ms	D:\WEBSITES\ZIPSLOCAL\ARTICLELISTINGSTOP.CFM
0 ms	D:\WEBSITES\ZIPSLOCAL\CHITIKA.CFM
0 ms	D:\WEBSITES\ZIPSLOCAL\FOOTER.CFML
0 ms	D:\WEBSITES\ZIPSLOCAL\GOOGLEADS.CFM
0 ms	D:\WEBSITES\ZIPSLOCAL\LINKS.CFM
111 ms	D:\WEBSITES\ZIPSLOCAL\LISTINGS.CFM
46 ms	D:\WEBSITES\ZIPSLOCAL\RELATEDCATS.CFM
0 ms	D:\WEBSITES\ZIPSLOCAL\SEARCHBOX.CFM
0 ms	D:\WEBSITES\ZIPSLOCAL\SERVERID.CFM
0 ms	D:\WEBSITES\_CFCUSTOMTAGS\IS_PAGE_OF_ZL.CFM
16 ms	D:\WEBSITES\_CFCUSTOMTAGS\IS_VALIDATE_PHONE.CFM
0 ms	STARTUP, PARSING, & SHUTDOWN

Parameters

URL Parameters:

CATNAME=Automobile_Road_Service
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
PAGE=1
ZIP=06040

CGI Variables:

AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\Websites\ZipsLocal\listings.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
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_COOKIE=CFID=117259947; CFTOKEN=11836560; CFCLIENT_MAGICYELLOW=CATNAME%3DBatteries%5FStorage%5FRetail%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D4%23LASTVISIT%3D%7Bts+%272010%2D09%2D07+08%3A09%3A48%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D07+08%3A07%3A41%27%7D%23
HTTP_HOST=06040.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/Automobile_Road_Service.html
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID=ccc03-02
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/listings.cfm
PATH_TRANSLATED=D:\Websites\ZipsLocal\listings.cfm
QUERY_STRING=CatName=Automobile_Road_Service
REMOTE_ADDR=38.107.191.108
REMOTE_HOST=38.107.191.108
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/listings.cfm
SERVER_NAME=06040.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI