Total Time	Avg Time	Count	Template
99 ms	99 ms	1	/home/www/html/index.cfm
53 ms	53 ms	1	/home/www/html/navcontentboxcomobile.cfm
5 ms	5 ms	1	/home/www/html/navtop_rdesign5.cfm
4 ms	4 ms	1	/home/www/html/Application.cfm
2 ms	2 ms	1	/home/www/html/navmeta_rdesign4.cfm
2 ms	2 ms	1	/home/www/html/navsidesbottom_rdesign5.cfm
1 ms	1 ms	1	/home/www/html/navcontentboxcopc.cfm
1 ms	1 ms	2	/home/www/html/navinjection.cfm
1 ms	1 ms	1	/home/www/html/navrightmidcolumn_rdesign5.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/constants.cfm
0 ms	0 ms	10	/home/www/html/eetr/rewritetipheading.cfm
0 ms	0 ms	1	/home/www/html/leftnav_rdesign5.cfm
0 ms	0 ms	3	/home/www/html/rewritearticle.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
1 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
104 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 *
	From Networks
	where isCity = 'country'
	order by networkname

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

	Select *
	From citynetworks
	Where networkID = 159
	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.62.82'
and logtime > "2020-03-02"
and param1 = 'aw'
ORDER BY logtime DESC

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

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

	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles
	Where hitopic <> ''
    and hidescript <> ''
    and type = '3'
    and articles.hihp <> 'n'
    and articles.hinet <> 'n'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
     and general <> 'bb'
        and summary <> ''
    and publishdate < "2020-06-01"
and (articles.articleid = 4362 or articles.articleid = 5590 or articles.articleid = 5219 or articles.articleid = 5591) 
   ORDER by articleid desc

SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 17
and allreports.answerid = answers.answerid
and answers.hpimg <> ''
and hide <> 'y'

order by allreports.answerid DESC

SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 17 

SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement, answers.date
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 80699
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid = 429
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
and answers.hpimg <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 80699 = answerstext.answerid 
ORDER BY answers.lastcomment ASC

SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'

SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement, answers.date
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 80697
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid = 429
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
and answers.hpimg <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 80697 = answerstext.answerid 
ORDER BY answers.lastcomment ASC

SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '116'

SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement, answers.date
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 80696
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid = 429
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
and answers.hpimg <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 80696 = answerstext.answerid 
ORDER BY answers.lastcomment ASC

SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '115'

SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement, answers.date
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 80694
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid = 429
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
and answers.hpimg <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 80694 = answerstext.answerid 
ORDER BY answers.lastcomment ASC

SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '92'

SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement, answers.date
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 80693
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid = 429
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
and answers.hpimg <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 80693 = answerstext.answerid 
ORDER BY answers.lastcomment ASC

SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'

	SELECT healthguideurl, networkname, shortname
	From contentcountcountry, Networks
	Where  (contentcountcountry.networkID = '15' or contentcountcountry.networkID = '16' or contentcountcountry.networkID = '18' or contentcountcountry.networkID = '4' or contentcountcountry.networkID = '20' or contentcountcountry.networkID = '24' or contentcountcountry.networkID = '26' or contentcountcountry.networkID = '28' or contentcountcountry.networkID = '30' or contentcountcountry.networkID = '31' or contentcountcountry.networkID = '32' or contentcountcountry.networkID = '33' or contentcountcountry.networkID = '35' or contentcountcountry.networkID = '38' or contentcountcountry.networkID = '39' or contentcountcountry.networkID = '40' or contentcountcountry.networkID = '45' or contentcountcountry.networkID = '47' or contentcountcountry.networkID = '49' or contentcountcountry.networkID = '51' or contentcountcountry.networkID = '52' or contentcountcountry.networkID = '54' or contentcountcountry.networkID = '55' or contentcountcountry.networkID = '56' or contentcountcountry.networkID = '58' or contentcountcountry.networkID = '60' or contentcountcountry.networkID = '62' or contentcountcountry.networkID = '75' or contentcountcountry.networkID = '77' or contentcountcountry.networkID = '81' or contentcountcountry.networkID = '83' or contentcountcountry.networkID = '295' or contentcountcountry.networkID = '85' or contentcountcountry.networkID = '87' or contentcountcountry.networkID = '89' or contentcountcountry.networkID = '90' or contentcountcountry.networkID = '92' or contentcountcountry.networkID = '94' or contentcountcountry.networkID = '95' or contentcountcountry.networkID = '97' or contentcountcountry.networkID = '100' or contentcountcountry.networkID = '101' or contentcountcountry.networkID = '102' or contentcountcountry.networkID = '108' or contentcountcountry.networkID = '110' or contentcountcountry.networkID = '112' or contentcountcountry.networkID = '1' or contentcountcountry.networkID = '114' or contentcountcountry.networkID = '129' or contentcountcountry.networkID = '115' or contentcountcountry.networkID = '119')
	and Networks.networkid = contentcountcountry.networkID

	SELECT *
	From contentcountcountry
	Where networkid = 77

SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and answers.answerid = allreports.answerid
and answers.reviewed = 'y'

    ORDER by allreports.answerid asc   
    

SELECT *
FROM topics
WHERE topicid = 7 

SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 7 

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65919 

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65919 

SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65919 

SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '26'

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65920 

	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65920 
	AND answerstext.qid = 409
	

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65920 

	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 77
	and fbimg <> ''
	

SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65920 

SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65921 

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65921 

SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65921 

SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '15'

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65922 

	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65922 
	AND answerstext.qid = 409
	

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65922 

	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 55
	and fbimg <> ''
	

	SELECT DISTINCT promophoto70 as photo 
	FROM topics
	WHERE topicid = 7 

SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65922 

SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '55'

	SELECT summary as answer
	FROM answers
	WHERE answerid = 65923 

	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65923 
	AND answerstext.qid = 409
	

	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65923 

	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 45
	and fbimg <> ''
	

SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65923 

SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '45'

	SELECT *
	From contentcountcountry
	Where networkid = 77

SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 7 

  SELECT networkname, frmid, networkid, location1, location2, location3, location4, location5, shortname
  FROM mostcountries
  order by networkname

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/index.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/index.cfm
QUERY_STRING=
REMOTE_ADDR=172.69.62.82
REMOTE_HOST=172.69.62.82
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.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=28830808
cftoken=83413819
sessionid=IBEXPATEXCHANGE.COM_28830808_83413819
urltoken=CFID=28830808&CFTOKEN=83413819