Single Keyword        City        State List                         Category List

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

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

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

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

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

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

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

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

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

Reviews (Records=0, 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=54404695 AND a.Approved=1 AND b.Active=1
	ORDER BY	ReviewDate DESC

172 milliseconds