Total Time	Avg Time	Count	Template
149 ms	149 ms	1	/home/www/html/rspnetall.cfm
54 ms	54 ms	1	/home/www/html/navtop_rdesign5.cfm
31 ms	31 ms	1	/home/www/html/Application.cfm
26 ms	26 ms	1	/home/www/html/navcontentboxmovingmobile.cfm
23 ms	23 ms	1	/home/www/html/navleader_rdesign5.cfm
19 ms	19 ms	1	/home/www/html/rspnet_readnext.cfm
3 ms	3 ms	1	/home/www/html/navmeta_rdesign4.cfm
3 ms	3 ms	1	/home/www/html/navsidesbottom_rdesign5.cfm
2 ms	2 ms	1	/home/www/html/breadcrumb.cfm
2 ms	2 ms	1	/home/www/html/navcontentboxmovingpc.cfm
2 ms	2 ms	1	/home/www/html/navrightmidcolumn_rdesign5.cfm
1 ms	1 ms	1	/home/www/html/boolsearch.cfm
1 ms	1 ms	1	/home/www/html/constants.cfm
0 ms	0 ms	1	/home/www/html/bottommobilenav_rdesign5.cfm
0 ms	0 ms	1	/home/www/html/bottomnav_rdesign5.cfm
0 ms	0 ms	1	/home/www/html/leftnav_rdesign5.cfm
0 ms	0 ms	2	/home/www/html/navinjection.cfm
0 ms	0 ms	12	/home/www/html/rewritearticle.cfm
0 ms	0 ms	6	/home/www/html/rewritecityname.cfm
0 ms	0 ms	9	/home/www/html/rewriteqoptionsctry.cfm
0 ms	0 ms	6	/home/www/html/rewritereport.cfm
0 ms	0 ms	3	/home/www/html/rewritereportscountry.cfm
0 ms	0 ms	1	/var/www/expatexchange.com/expat/datasources.cfm
0 ms	0 ms	1	/var/www/expatexchange.com/expat/ibkey.cfm
0 ms	0 ms	1	/var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
3 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
183 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

  SELECT * FROM genset 
WHERE dbname = "ee"

      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	

SELECT  networkname as ctry, city, networkid, rid, networkname, answerid, citynetworkid
FROM allreports
WHERE rid = 63
AND networkid = 92
GROUP BY answerid
ORDER by answerid DESC

SELECT DISTINCT questions.qid, answers.answerid, questions.question, responsequestions.qid, answerstext.qid, answerstext.answer as answer, answerstext.reviewed, answerstext.score, answers.rid, answers.reviewed, responses.intro, responses.responsename, responsequestions.listorder, answers.userid, answers.date
FROM responsequestions, questions, answers, responses, answerstext
WHERE answerstext.qid = questions.qid

AND 25986 = answerstext.answerid
 
AND answerstext.score > 1
AND answerstext.answer <> ''

AND answers.answerid = 25986 
AND answers.reviewed = 'y'
AND questions.qid = responsequestions.qid
AND responses.responseid = responsequestions.responseid
AND answers.rid = responses.rid
ORDER BY responsequestions.listorder ASC

	Select *
	From Networks
	where isCity = 'country'
	order by networkname

	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 92 

	Select *
	From citynetworks
	Where networkID = 92
	and status <> 'hold'
	ORDER by city

  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname

SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-03-07"
and param1 = 'aw'
ORDER BY logtime DESC

SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-06-06 00:00:00.000"
and logtime < "2020-06-06 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC

SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.143'
and logtime > "2020-05-30"
and param1 = 'awdyn'
ORDER BY logtime DESC

	SELECT *
	From contentcountcountry
	Where networkid = 92 

	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-05"
    and fromDate < "2020-06-06"
    and bannerPlacement.networkid = 92
    and bannerPlacement.bannerid = banners.bannerid

  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 810 

SELECT *
FROM articleCategories
 
WHERE section = 1

		Select *
		FROM allreports, citynetworks
         where answerid = 1234567899999999
         and citynetworks.citynetworkid = allreports.citynetworkid
         and citynetworks.status = 'live'

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 76515 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 76515 
AND answerstext.qid = 95

SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 76515 

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 25986 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 25986 
AND answerstext.qid = 95

SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 25986 

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 25454 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 25454 
AND answerstext.qid = 95

SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 25454 

SELECT DISTINCT summary
FROM answers
WHERE answers.answerid = 24957 

SELECT DISTINCT answerstext.answer
FROM answerstext
WHERE answerstext.answerid = 24957 
AND answerstext.qid = 95

SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 24957 

	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 92 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
   and (articleCategories.section = '1' or articleCategories.section = '2' or articleCategories.section = '4' or articleCategories.section = '5')   
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-06"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
      
         and networkid = 92 
         and city <> ''
         order by date DESC

		Select summary, hiimg 
		FROM answers
         where answerid = 25454
         and summary <> ''

	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl, publishdate
	FROM articles, articlePlacement, articleCategories 
 	Where hitopic <> ''
	and (((title LIKE '%Best%') OR (author LIKE '%Best%') OR (hitopic LIKE '%Best%') OR (hidescript LIKE '%Best%')) AND ((title LIKE '%Places%') OR (author LIKE '%Places%') OR (hitopic LIKE '%Places%') OR (hidescript LIKE '%Places%')))
	and articlePlacement.networkID = 92
	AND articlePlacement.articleID = articles.articleID
	  and articleCategories.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and (articleCategories.section <> '1' and articleCategories.section <> '2' and articleCategories.section <> '4' and articleCategories.section <> '5')   
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and summary <> ''
    and publishdate < "2020-06-06"
    ORDER by articles.articleID desc

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 92 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC

		Select summary, hiimg 
		FROM answers
         where answerid = 72761
         and summary <> ''

		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 92 
          and date > '2013-04-01'
		order by date DESC

		Select summary, hiimg 
		FROM answers
         where answerid = 76515
         and summary <> ''

	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 92 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-06"

    ORDER by articles.articleID desc
    

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=/home/www/html/rspnetall.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/rspnetall.cfm
QUERY_STRING=rid=63&networkid=92
REMOTE_ADDR=172.69.63.143
REMOTE_HOST=172.69.63.143
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rspnetall.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=

Session Variables:
cfid=29076867
cftoken=13586868
sessionid=IBEXPATEXCHANGE.COM_29076867_13586868
urltoken=CFID=29076867&CFTOKEN=13586868

URL Parameters:
networkid=92
rid=63