When a manufacturing firm needs to buy bearings they normally buy them from a bearing wholesaler. Bearings are devices that help reduce friction and are used in everything from industrial engines to skateboards. There are many different types of bearings and some bearing wholesalers may specialize in selling a certain kind of bearing or bearings that are used for specific purposes. Some common kinds of bearings are ball bearings; bronze sleeve bearings; mounted bearings; dry bearings; deep groove ball bearings; graphite-metal bearings; thrust bearings; wear strips; bushings; spherical bearings; tapered roller bearings; polymer bearings; sleeve bearings; linear bearings; linear motion systems; miniature bearings; and ceramic bearings.

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=80110

GetCat (Records=1, Time=0ms)
SQL = 
SELECT	MYCatID, CatName, htmlTitle, keywordSingle2 AS KW
	FROM	listingcategories
	WHERE	CatName='Bearings (wholesale)' AND Display='Y'

 (Records=10, Time=31ms)
SQL = 
spZipsLocalListings

 (Records=27, Time=0ms)
SQL = 
spGetRelatedCats

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

GetNearbyZips1 (Records=50, Time=0ms)
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=80110 AND a.TargetZip<>80110
	ORDER BY	a.Distance

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

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

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

Execution Time

109 milliseconds

0 ms	D:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
31 ms	D:\WEBSITES\ZIPSLOCAL\ARTICLELISTINGSBOTTOM.CFM
31 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
31 ms	D:\WEBSITES\ZIPSLOCAL\LISTINGS.CFM
16 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
0 ms	D:\WEBSITES\_CFCUSTOMTAGS\IS_VALIDATE_PHONE.CFM
0 ms	STARTUP, PARSING, & SHUTDOWN

Parameters

URL Parameters:

CATNAME=Bearings_(wholesale)
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
PAGE=1
ZIP=80110

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=118163333; CFTOKEN=44168381; CFCLIENT_MAGICYELLOW=CATNAME%3DBarbers%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D5%23LASTVISIT%3D%7Bts+%272010%2D09%2D09+14%3A48%3A52%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+14%3A46%3A20%27%7D%23
HTTP_HOST=80110.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/Bearings_(wholesale).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=Bearings_(wholesale)
REMOTE_ADDR=38.107.191.109
REMOTE_HOST=38.107.191.109
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/listings.cfm
SERVER_NAME=80110.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI