Home Germany Forum Germany Guide Moving to Germany Real Estate Healthcare in Germany
Germany
Resources
City Guides
JoinSign In
AGS Worldwide Movers
Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in Germany from our partner, Cigna Global Health.
Get a Quote

12-Expats-Talk-about-What-its-Like-Living-in-Germany12 Expats Talk about What it's Like Living in Germany

Expats talk about living in Germany. From meeting people to adjusting to the German culture, expats offer a glimpse of life in Germany.
Expats talk about living in Germany. From meeting people to adjusting to the German culture, expats offer a glimpse of life in Germany. ...

Expats-in-GermanyMoving to Germany

Expats in Germany share 10 things they wish they had known before moving to Germany - from the importance of learning German to residency permits to understanding the culture and more.

Expats in Germany share 10 things they wish they had known before moving to Germany - from the importance of learning German to residency permits to understanding the culture and more....

Expats-in-Germany8 Best Places to Live in Germany

Expats love Germany for its historic towns, festivals, Christmas markets and diversity. In this article, we cover 8 of the best places to live in Germany.

Expats love Germany for its historic towns, festivals, Christmas markets and diversity. In this article, we cover 8 of the best places to live in Germany....

Retirement-In-Eifel-An Expat Shares What it's Like Retiring in Eifel , Germany

A couple from the UK discusses their decision to move abroad to reduce living costs and travel more. For now, they are living in Eifel, but the locals are not welcoming and they are considering moving again.

A couple from the UK discusses their decision to move abroad to reduce living costs and travel more. For now, they are living in Eifel, but the locals are not welcoming and they are considering movin...

Moving-To-MunichAn Expat Talks about Moving to Munich, Germany

An expat living in Munich offers advice on moving to the southern German city. Great advice on getting a drivers license, renting a flat, and more.

An expat living in Munich offers advice on moving to the southern German city. Great advice on getting a drivers license, renting a flat, and more....

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /rspnet.cfm
Time Stamp 02-Jul-20 08:57 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.37
Host Name 172.69.63.37


Execution Time

Total Time Avg Time Count Template
39 ms 39 ms 1 top level /home/www/html/rspnet.cfm
27 ms 27 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/navcontentbox.cfm
26 ms 26 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
8 ms 8 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/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 2 /home/www/html/navinjection.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.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 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.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
44 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 08:57:32.032
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 08:57:32.032
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getreportresponses (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 08:57:32.032
SELECT  networkname as ctry, city, networkid, rid, networkname, answerid, citynetworkid
FROM allreports
WHERE rid = 62
AND networkid = 3 
AND 70179 = answerid

GROUP BY answerid
ORDER by city
citystatus (Datasource=expert, Time=0ms, Records=0) in /home/www/html/rspnet.cfm @ 08:57:32.032
	Select *
	From allreports, citynetworks 
	Where allreports.answerid = 70179
	and allreports.citynetworkid = citynetworks.citynetworkid
getquestions (Datasource=reports, Time=1ms, Records=0) in /home/www/html/rspnet.cfm @ 08:57:32.032
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 70179 = answerstext.answerid
 
AND answerstext.score > 1
AND answerstext.answer <> ''

AND answers.answerid = 70179 
AND answers.reviewed = 'y'
AND questions.qid = responsequestions.qid
AND responses.responseid = responsequestions.responseid
AND answers.rid = responses.rid
ORDER BY responsequestions.listorder ASC
getphotos (Datasource=reports, Time=0ms, Records=0) in /home/www/html/rspnet.cfm @ 08:57:32.032
SELECT DISTINCT img, photocaption, summary, hpimg, fbimg, twimg
FROM answers 
WHERE answers.answerid = 70179 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 08:57:32.032
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 3 
GetNetworks (Datasource=expert, Time=1ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 08:57:32.032
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 08:57:32.032
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 3 
getcities (Datasource=expert, Time=1ms, Records=13) in /home/www/html/navmeta_rdesign4.cfm @ 08:57:32.032
	Select *
	From citynetworks
	Where networkID = 3
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 08:57:32.032
  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
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 08:57:32.032
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-04-02"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 08:57:32.032
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-07-02 00:00:00.000"
and logtime < "2020-07-02 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 08:57:32.032
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.37'
and logtime > "2020-06-25"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 08:57:32.032
	SELECT *
	From contentcountcountry
	Where networkid = 3 
gettopbanner (Datasource=expert, Time=0ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 08:57:32.032
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-01"
    and fromDate < "2020-07-02"
    and bannerPlacement.networkid = 3
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 08:57:32.032
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 08:57:32.032
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-02"
     
         and rptarticlenetworks.networkid = 3 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 08:57:32.032
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 4
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 08:57:32.032
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 3 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 08:57:32.032
SELECT  hiimg
FROM rptarticles
where rptarticleID = 4
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 08:57:32.032
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 3 
	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-07-02"

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 08:57:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 3 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 08:57:32.032
		Select summary, hiimg 
		FROM answers
         where answerid = 46590
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 08:57:32.032
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 3 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 08:57:32.032
		Select summary, hiimg 
		FROM answers
         where answerid = 74522
         and summary <> ''


Scope Variables

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/rspnet.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/rspnet.cfm
QUERY_STRING=rid=62&answerid=70179&networkid=3&start=70179
REMOTE_ADDR=172.69.63.37
REMOTE_HOST=172.69.63.37
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rspnet.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=30724950
cftoken=71855244
sessionid=IBEXPATEXCHANGE.COM_30724950_71855244
urltoken=CFID=30724950&CFTOKEN=71855244
URL Parameters:
answerid=70179
networkid=3
rid=62
start=70179
Debug Rendering Time: 9 ms