Single Keyword        City        State List                         Category List

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

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

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

log (Records=0, Time=0ms)
SQL = 
INSERT INTO	logs_vpv (code,
							event,
							client,
							source,
							sourceSite,
							sourceQuery,
							clientIP,
							admin,
							vid,
							MYCatID,
							locID,
							
							userAgent,
							aid,
							
							siteID)
					VALUES ('VPV',
							'Listing Page View (56847698)',
							'[47830276.69369991]',
							'(no referrer)',
							NULL,
							NULL,
							'38.107.191.103',
							0,
							56847698,
							294543,
							'USCASD',
							
							'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',
							'0',
							
							1)

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

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

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

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

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

Reviews (Records=1, Time=125ms)
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=56847698 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=56847698

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

rrs24814 (Records=0, Time=0ms)
SQL = 
SELECT	Agree
			FROM	ReviewofReviews
			WHERE	rid=24814

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

250 milliseconds