Single Keyword        City        State List                         Category List

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

listing (Records=1, Time=78ms)
SQL = 
SELECT  *
	FROM	dbo.vSoldListingsSafe
	WHERE	(MYID = 56840385)

LocaleInfo (Records=1, Time=0ms)
SQL = 
select LocID,
			country,
			state,
			stateCode,
			city,
			defaultLocale,
			defaultZip,
			cityList,
			localeList,
			townList,
			townList30
		from	Server.Locales
		where	LocID = 'USOHCD'

getPhase (Records=1, Time=0ms)
SQL = 
select lPhase
		from listings
		where MYID = 56840385

getStates (Records=51, Time=0ms)
SQL = 
SELECT *
	from states

getCity2 (Records=8, Time=0ms)
SQL = 
select *
								from application.cities2
								where stateCode = 'OH' order by city
								order by city

 (Records=30, Time=16ms)
SQL = 
spGetRelatedCats

getRelatedCats (Records=30, Time=0ms)
SQL = 
select *
							from getRelatedCats1
							order by catName

Reviews (Records=1, Time=16ms)
SQL = 
SELECT		a.rid, a.UserID, a.ReviewDate, a.Rating, a.Title, a.Anonymous, a.Pros, a.Cons, a.Comments, b.FirstName, b.LastName, b.City, B.State
	FROM		ReviewsMagic a RIGHT OUTER JOIN RegisteredUsersMagic b ON a.UserID=b.UserID
	WHERE		a.MYID=56840385 AND a.Approved=1 AND b.Active=1
	ORDER BY	ReviewDate DESC

getRatingTotal (Records=1, Time=0ms)
SQL = 
SELECT	MYID, RatingTotal, RatingCount
		FROM	ReviewTotalsMagic
		WHERE	MYID=56840385

ReviewofReviews (Records=0, Time=0ms)
SQL = 
SELECT	rrid, rid, Agree
		FROM	ReviewReviewsMagic
		WHERE	rid IN (20746)

rrs20746 (Records=0, Time=0ms)
SQL = 
SELECT	Agree
			FROM	ReviewofReviews
			WHERE	rid=20746

rrsA20746 (Records=0, Time=0ms)
SQL = 
SELECT	Agree
			FROM	ReviewofReviews
			WHERE	rid=20746 AND Agree=1

2813 milliseconds