Cigna International Health Insurance

One Month in Buenos Aires

Musings on Buenos Aires, greater Argentina, and the Argentine Tango, from a Canadian ex-pat's point of view.

Web Site:

Culture-Shock-in-HannoverAn Expat Talks about Culture Shock & Living in Hannover, Germany

Do you need to learn German before moving to Hannover? What are Germans like? An expat talks about living in Hannover, the cultural stereotype about German people being rude, healthcare in Germany and more.

Do you need to learn German before moving to Hannover? What are Germans like? An expat talks about living in Hannover, the cultural stereotype about German people being rude, healthcare in Germany a...

Living-in-TaguigAn Expat Discusses Living in Taguig, Philippines

An British expat talks about spending winters in Taguig, Philippines with his Filipina wife of 25 years. He does miss chatting with other English speakers and hopes to find some expat clubs in Bonifacio Global City.

An British expat talks about spending winters in Taguig, Philippines with his Filipina wife of 25 years. He does miss chatting with other English speakers and hopes to find some expat clubs in Bonifa...

Youre-Not-Too-Old-To-Live-AbroadYou're Not Too Old To Live Abroad

Who doesn't want to get out there and see the world? So many of us put off the prospect of moving overseas until later in life, and that shouldn't keep you from considering retiring abroad.

Who doesn't want to get out there and see the world? So many of us put off the prospect of moving overseas until later in life, and that shouldn't keep you from considering retiring abroad....

Lisbon,-PortugalLisbon, Portugal

Lisbon is the capital and largest city in Portugal, which is one of the most popular countries for expats in Europe. You'll find basic information to help you get acquainted with Lisbon and what it has to offer.

Lisbon is the capital and largest city in Portugal, which is one of the most popular countries for expats in Europe. You'll find basic information to help you get acquainted with Lisbon and what it h...

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /rgblog.cfm
Time Stamp 15-Jul-20 02:48 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.79.9
Host Name 162.158.79.9


Execution Time

Total Time Avg Time Count Template
23 ms 23 ms 1 top level /home/www/html/rgblog.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
5 ms 5 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navleader_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navcontentbox.cfm
1 ms 1 ms 1 /home/www/html/navmeta_rdesign4.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 2 /home/www/html/navinjection.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 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
29 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 @ 14:48:44.044
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 14:48:44.044
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getresources (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rgblog.cfm @ 14:48:44.044
	SELECT *
	FROM Resources
	where resourceID = 11223 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rgblog.cfm @ 14:48:44.044
	Select *
	From Networks
	Where networkID = 159 
getcatname (Datasource=expert, Time=6ms, Records=1) in /home/www/html/rgblog.cfm @ 14:48:44.044
	Select DISTINCT Resources.resourceID, Categories.categoryname, Categories.usermeta, Categories.titletagglobal, Categories.keywordsglobal, Categories.descripttagglobal, Categories.searchterms, Categories.descriptionglobal, Categories.usedescription, Categories.usearticles, Categories.headinglocal, Categories.categoryname2, Categories.headingglobal, Categories.titletaglocal, Categories.keywordslocal, Categories.descripttaglocal, Categories.descriptionlocal
    From Resources, Categories, resourceCats
    WHERE Categories.categoryid = resourceCats.categoryID 
	AND resourceCats.resourceID = Resources.resourceID 
	and Resources.resourceID = 11223
	ORDER by Categories.categoryID
	
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 14:48:44.044
	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 @ 14:48:44.044
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 159 
getcities (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 14:48:44.044
	Select *
	From citynetworks
	Where networkID = 159
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 14:48:44.044
  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=2ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 14:48:44.044
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-04-15"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 14:48:44.044
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-15 00:00:00.000"
and logtime < "2020-07-15 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 14:48:44.044
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-08"
and param1 = 'awdyn'
ORDER BY logtime DESC
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 14:48:44.044
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
	and weight = 10
    and toDate > "2020-07-14"
    and fromDate < "2020-07-15"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 14:48:44.044
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
UpdateImpressions (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rgblog.cfm @ 14:48:44.044
  UPDATE Resources
  SET impressions = impressions + 1
  WHERE resourceID = 11223 
checkculturefeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:48:44.044
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 14:48:44.044
		Select summary, hiimg 
		FROM answers
         where answerid = 76524
         and summary <> ''
checklivingfeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:48:44.044
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 14:48:44.044
		Select summary, hiimg 
		FROM answers
         where answerid = 76398
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:48:44.044
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles 
	Where hitopic <> ''
	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-15"
    ORDER by articles.articleID desc   
checkrptarticles (Datasource=reports, Time=0ms, Records=0, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:48:44.044
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-15"
     
         and rptarticlenetworks.networkid = 159 
    ORDER by rptarticles.rptarticleID asc   
    
GetCountryList (Datasource=expert, Time=0ms, Records=96, Cached Query) in /home/www/html/navsidesbottom_rdesign5.cfm @ 14:48:44.044
  SELECT networkname, frmid, networkid, location1, location2, location3, location4, location5, shortname
  FROM mostcountries
  order by networkname


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/rgblog.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/rgblog.cfm
QUERY_STRING=resourceID=11223
REMOTE_ADDR=162.158.79.9
REMOTE_HOST=162.158.79.9
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rgblog.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=31942398
cftoken=58286052
sessionid=IBEXPATEXCHANGE.COM_31942398_58286052
urltoken=CFID=31942398&CFTOKEN=58286052
URL Parameters:
resourceID=11223
Debug Rendering Time: 11 ms