Total Time	Avg Time	Count	Template
38 ms	38 ms	1	/var/www/html/pricepatch_linux/index.cfm
35 ms	35 ms	1	/var/www/html/pricepatch_linux/template1_inner.cfm
24 ms	24 ms	1	/var/www/html/pricepatch_linux/newprodlist.cfm
15 ms	2 ms	10	/var/www/html/pricepatch_linux/newsubcat.cfm
5 ms	5 ms	1	/var/www/html/pricepatch_linux/newsearch.cfm
2 ms	2 ms	1	/var/www/html/pricepatch_linux/newapplication.cfm
1 ms	1 ms	1	/var/www/html/pricepatch_linux/newcatbrowse.cfm
1 ms	1 ms	1	/var/www/html/pricepatch_linux/newrefineresults.cfm
0 ms	0 ms	1	/var/www/html/pricepatch_linux/newadsense.cfm
0 ms	0 ms	1	/var/www/html/pricepatch_linux/newcleanquerystring.cfm
0 ms	0 ms	1	/var/www/html/pricepatch_linux/newfooter.cfm
0 ms	0 ms	1	/var/www/html/pricepatch_linux/newpagination.cfm
0 ms	0 ms	10	/var/www/html/pricepatch_linux/newprodnotes.cfm
0 ms	0 ms	1	/var/www/html/pricepatch_linux/newtellafriend.cfm
1 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
39 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

select 'm=01j21&mname=Video%20Games' as requestid, l.prodid,p.aliasid,p.prodname,p.proddesc,p.thumburl, p.mediumurl, m.manname, m.manid, p.rank as prank, p.rankreviews as prankreviews,
1 as score,p.oldid,
count(l.listid) as listcount,
min(l.price) as lowestprice

from prodmaster_ext p
 
inner join listmaster l on p.prodid=l.prodid
inner join manmaster m on p.manid=m.manid

	inner join 
	(select distinct pm.prodid from prodmenu pm
	 
	where menuid LIKE '01j21%' 
	
	limit 10000) pm on p.prodid=pm.prodid
	

where 
l.active = 1 and p.prodname <> '' and l.price > 0

group by l.prodid,p.prodname,p.proddesc,m.manname,score,p.oldid
order by score desc,lowestprice desc, p.prodname 
limit 0,10

select 'm=01j21&mname=Video%20Games' as requestid, 
count(distinct l.prodid) as thecount
 from listmaster l

	inner join 
	(select distinct pm.prodid from prodmenu pm
	 
	where menuid LIKE '01j21%' 
	
	limit 10000) pm on l.prodid=pm.prodid
	
where 
l.active=1


limit 1100

select 'm=01j21&mname=Video%20Games' as requestid, m.manid,m.manname,
count(p.prodid) as prodcount from prodmaster p


inner join listmaster l on p.prodid=l.prodid

inner join manmaster m on p.manid=m.manid

inner join 
(select distinct pm.prodid from prodmenu pm 

where menuid LIKE '01j21%' 
	
limit 1000) pm on p.prodid=pm.prodid

where 
l.active = 1 and p.prodname <> ''

group by m.manname
order by prodcount desc
limit 100

select 'm=01j21&mname=Video%20Games' as requestid, max(price) as maxprice,min(price) as minprice, avg(price) as avgprice, std(price) as stdprice
from prodmaster p

inner join listmaster l on p.prodid=l.prodid

inner join 
(select distinct pm.prodid from prodmenu pm 

where menuid LIKE '01j21%' 
	limit 10000) pm on p.prodid=pm.prodid

where 
l.active = 1 and p.prodname <> ''


limit 5000

select 'm=01j21&mname=Video%20Games' as requestid, 
count(distinct l.prodid) as count,
 0.01 as lower, 50.322271 as upper
from listmaster l

inner join 
(select distinct pm.prodid from prodmenu pm 

where menuid LIKE '01j21%' 
	
limit 1000) pm on l.prodid=pm.prodid

where 
l.active = 1


and l.price between 0.01 and 50.322271
having count(l.prodid) > 0
union
select 'm=01j21&mname=Video%20Games' as requestid, 
count(distinct l.prodid),
50.332271 as lower, 100.634542 as upper
from listmaster l

inner join 
(select distinct pm.prodid from prodmenu pm 
 
where menuid LIKE '01j21%' 
	
limit 1000) pm on l.prodid=pm.prodid

where 
l.active = 1 


and l.price between 50.332271 and 100.634542
having count(l.prodid) > 0
union
select 'm=01j21&mname=Video%20Games' as requestid, 
count(distinct l.prodid),
 100.644542 as lower, 16550.312271 as upper
from listmaster l

inner join 
(select distinct pm.prodid from prodmenu pm 

where menuid LIKE '01j21%' 
	
limit 1000) pm on l.prodid=pm.prodid

where 
l.active = 1 


and l.price between 100.644542 and 16550.312271
having count(l.prodid) > 0
union
select 'm=01j21&mname=Video%20Games' as requestid, 
count(distinct l.prodid),
 16550.322271 as lower, 32999.99 as upper
from listmaster l

inner join 
(select distinct pm.prodid from prodmenu pm 

where menuid LIKE '01j21%' 
	
limit 1000) pm on l.prodid=pm.prodid

where 
l.active = 1


and l.price between 16550.322271 and 32999.99
having count(l.prodid) > 0
limit 5000

select 'm=01j21&mname=Video%20Games' as requestid, m.merchid, m.merchname,
count(distinct l.prodid) as prodcount 
from listmaster l

inner join merchmaster m on l.merchid=m.merchid

inner join 
(select distinct pm.prodid from prodmenu pm 

where menuid LIKE '01j21%' 
	
limit 1000) pm on l.prodid=pm.prodid

where 
l.active = 1


group by m.merchname
order by prodcount desc
limit 100

select 'm=01j21&mname=Video%20Games' as requestid, lstparent from menumaster 
where menuid='01j21'

select 'm=01j21&mname=Video%20Games' as requestid, mm.menuid,mm.name 
, menus.prodcount 
from (
		select 
			substring(pm.menuid,1,6)
			
		as menuid 
		
		,count(distinct l.prodid) as prodcount 
		
		from listmaster l
		
		inner join 
		(select pm.prodid,pm.menuid from prodmenu pm 
		
		where menuid LIKE '01j21%' 
	limit 1000) pm on l.prodid=pm.prodid
		inner join menumaster mm on pm.menuid=mm.menuid
		
		where 
		l.active = 1
		
		and pm.menuid<>'01j21'
		and mm.menuid like '01j21%'
		
		
			group by 
			
			substring(pm.menuid,1,6)
			
			
) menus
inner join menumaster mm on menus.menuid = mm.menuid			
	

order by prodcount desc

limit 20

SELECT *		
FROM menumaster
WHERE MenuID = '01j21'
and active=1

SELECT *		
FROM menumaster
WHERE menuid in ('0','01','01j')
and active = 1
order by menuid 

SELECT *
FROM menumaster 
WHERE lstParent = '0,01,01j,01j21'
and active=1
ORDER BY MenuID

SELECT menuid
from prodmenu
WHERE prodid='1441490'
AND (menuid like '01j21%' or menuid='01j21')
limit 1

SELECT lstparent		
from menumaster 
WHERE menuid='01j21A03'
limit 1

SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01','01j','01j21','01j21A')
OR menuid='01j21A03')
AND menuid <> '01'
order by menuid 

SELECT menuid
from prodmenu
WHERE prodid='1441175'
AND (menuid like '01j21%' or menuid='01j21')
limit 1

SELECT lstparent		
from menumaster 
WHERE menuid='01j21A03'
limit 1

SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01','01j','01j21','01j21A')
OR menuid='01j21A03')
AND menuid <> '01'
order by menuid 

SELECT menuid
from prodmenu
WHERE prodid='1422280'
AND (menuid like '01j21%' or menuid='01j21')
limit 1

SELECT lstparent		
from menumaster 
WHERE menuid='01j21A03'
limit 1

SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01','01j','01j21','01j21A')
OR menuid='01j21A03')
AND menuid <> '01'
order by menuid 

SELECT menuid
from prodmenu
WHERE prodid='632767'
AND (menuid like '01j21%' or menuid='01j21')
limit 1

SELECT lstparent		
from menumaster 
WHERE menuid='01j21'
limit 1

SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01','01j')
OR menuid='01j21')
AND menuid <> '01'
order by menuid 

SELECT menuid
from prodmenu
WHERE prodid='1410397'
AND (menuid like '01j21%' or menuid='01j21')
limit 1

SELECT lstparent		
from menumaster 
WHERE menuid='01j21A03'
limit 1

SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01','01j','01j21','01j21A')
OR menuid='01j21A03')
AND menuid <> '01'
order by menuid 

SELECT menuid
from prodmenu
WHERE prodid='1444056'
AND (menuid like '01j21%' or menuid='01j21')
limit 1

SELECT lstparent		
from menumaster 
WHERE menuid='01j21'
limit 1

SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01','01j')
OR menuid='01j21')
AND menuid <> '01'
order by menuid 

SELECT menuid
from prodmenu
WHERE prodid='1441897'
AND (menuid like '01j21%' or menuid='01j21')
limit 1

SELECT lstparent		
from menumaster 
WHERE menuid='01j21A03'
limit 1

SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01','01j','01j21','01j21A')
OR menuid='01j21A03')
AND menuid <> '01'
order by menuid 

SELECT menuid
from prodmenu
WHERE prodid='1441895'
AND (menuid like '01j21%' or menuid='01j21')
limit 1

SELECT lstparent		
from menumaster 
WHERE menuid='01j21A03'
limit 1

SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01','01j','01j21','01j21A')
OR menuid='01j21A03')
AND menuid <> '01'
order by menuid 

SELECT menuid
from prodmenu
WHERE prodid='1441893'
AND (menuid like '01j21%' or menuid='01j21')
limit 1

SELECT lstparent		
from menumaster 
WHERE menuid='01j21A03'
limit 1

SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01','01j','01j21','01j21A')
OR menuid='01j21A03')
AND menuid <> '01'
order by menuid 

SELECT menuid
from prodmenu
WHERE prodid='1440533'
AND (menuid like '01j21%' or menuid='01j21')
limit 1

SELECT lstparent		
from menumaster 
WHERE menuid='01j21C07'
limit 1

SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01','01j','01j21','01j21C')
OR menuid='01j21C07')
AND menuid <> '01'
order by menuid 

Application Variables:
applicationname=pricepatch

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=/var/www/html/pricepatch_linux/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=CFID=2284933; CFTOKEN=35288966
HTTP_HOST=www.pricepatch.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=
PATH_TRANSLATED=/var/www/html/pricepatch_linux/index.cfm
QUERY_STRING=m=01j21&mname=Video%20Games
REMOTE_ADDR=192.168.1.4
REMOTE_HOST=192.168.1.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.pricepatch.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Apache/2.2.6 (Fedora)
WEB_SERVER_API=

Cookie Variables:
CFID=2284933
CFTOKEN=35288966

Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)

Session Variables:
cfid=2284933
cftoken=35288966
sessionid=PRICEPATCH_2284933_35288966
urltoken=CFID=2284933&CFTOKEN=35288966

URL Parameters:
M=01j21
MNAME=Video Games