Home Sri Lanka Forum Sri Lanka Guide Sri Lanka Resources Real Estate Healthcare in Sri Lanka
Sri Lanka
Resources
City Guides
JoinSign In
Cigna International Health Insurance

Sri Lanka: International Life Insurance

Get international term life insurance quotes from reputable insurance companies with products tailored to meet the unique needs of expats in Sri Lanka.

Interested in being included in this section. Contact us to discuss partnership opportunities.

Clements Worldwide

Clements Worldwide

Clements offers Term Life insurance which provides financial disbursements to your loved ones upon loss of life, protecting them against future financial burdens.

Learn More Get a Quote

Expats-in-Sri-Lanka5 Tips For Living In Sri Lanka

Expats in Sri Lanka live in a country just south of India that is regularly reported by expats as being a clean and hospitable place to create a life abroad.

Expats in Sri Lanka live in a country just south of India that is regularly reported by expats as being a clean and hospitable place to create a life abroad....

Sri Lanka Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


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


Execution Time

Total Time Avg Time Count Template
130 ms 130 ms 1 top level /home/www/html/rgall.cfm
39 ms 39 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
37 ms 37 ms 1 /home/www/html/navcontentbox.cfm
37 ms 37 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
9 ms 9 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/navmeta_rdesign4.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 1 /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
135 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 @ 18:03:24.024
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 18:03:24.024
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getcatname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rgall.cfm @ 18:03:24.024
	Select *
	From Categories
	Where categoryid = 96 
getbidders (Datasource=expert, Time=20ms, Records=0) in /home/www/html/rgall.cfm @ 18:03:24.024
Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.directlink, Resources.includelink, Resources.photo, Resources.phototype, Resources.quotebutton, Resources.usefullrewriteurl, Resources.fullrewriteurl
    From Resources, resourcePlacement, resourceCats
    WHERE 96 = resourceCats.categoryID 
	AND resourceCats.resourceID = Resources.resourceID 
	AND Resources.type <> 'hold'
	AND Resources.type <> 'guide'
	and Resources.type  <> 'local'
	and Resources.type  <> 'free'
	and Resources.type  <> 'affiliate'
	and Resources.type  <> 'locaff'
	and Resources.type <> 'bonusonly'
   and Resources.bid = 'yes'
    and todate > {ts '2020-07-01 18:03:24'}
    and fromdate <{ts '2020-07-02 18:03:24'}
	AND resourcePlacement.networkID = '159'
	AND resourcePlacement.resourceID = Resources.resourceID
	Order by Resources.resourcename
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 18:03:24.024
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 18:03:24.024
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 102 
getcities (Datasource=expert, Time=1ms, Records=3) in /home/www/html/navmeta_rdesign4.cfm @ 18:03:24.024
	Select *
	From citynetworks
	Where networkID = 102
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 18:03:24.024
  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 @ 18:03:24.024
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.195'
and logtime > "2020-04-02"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 18:03:24.024
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.195'
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=0) in /home/www/html/navtop_rdesign5.cfm @ 18:03:24.024
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.195'
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 @ 18:03:24.024
	SELECT *
	From contentcountcountry
	Where networkid = 102 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 18:03:24.024
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-01"
    and fromDate < "2020-07-02"
UpdatePageViews (Datasource=expert, Time=3ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 18:03:24.024
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getaffiliates (Datasource=expert, Time=20ms, Records=0) in /home/www/html/rgall.cfm @ 18:03:24.024
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.contactname, Resources.email, Resources.phone, Resources.fax, Resources.street, Resources.city, Resources.state_prov, Resources.zip, Resources.country, Resources.longdescription, Resources.photo, Resources.site, Resources.directlink, Resources.includelink, Resources.photo, Resources.phototype, Resources.quotebutton, Resources.usefullrewriteurl, Resources.fullrewriteurl
    From Resources, resourceCats
    WHERE 96 = resourceCats.categoryID 
	and resourceCats.resourceID = Resources.resourceID 
	and Resources.type = 'affiliate'
    and Resources.bid <> 'yes'
    and todate > {ts '2020-07-01 18:03:24'}
    and fromdate <{ts '2020-07-02 18:03:24'}
	Order by Resources.resourcename
getcatname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rgall.cfm @ 18:03:24.024
	Select *
	From Categories
	Where categoryid = 96 
UpdateImpressions (Datasource=expert, Time=2ms, Records=1) in /home/www/html/rgall.cfm @ 18:03:24.024
  UPDATE Categories
  SET rgnetimpressions = rgnetimpressions + 1
  Where categoryid = 96 
getlistings (Datasource=expert, Time=18ms, Records=1) in /home/www/html/rgall.cfm @ 18:03:24.024
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.directlink, Resources.includelink, Resources.photo, Resources.phototype, Resources.quotebutton, Resources.usefullrewriteurl, Resources.fullrewriteurl, resourceCats.categoryorder
    From Resources, resourcePlacement, resourceCats
    WHERE 96 = resourceCats.categoryID 
	AND resourceCats.resourceID = Resources.resourceID 
	AND Resources.type <> 'hold'
	AND Resources.type <> 'guide'
	AND Resources.type <> 'local'
	AND Resources.type <> 'free'
	and Resources.type <> 'bonusonly'
    and Resources.bid <> 'yes'
    and todate > {ts '2020-07-01 18:03:24'}
    and fromdate <{ts '2020-07-02 18:03:24'}
	AND (102 = resourcePlacement.networkID OR resourcePlacement.networkID = '159')
	AND resourcePlacement.resourceID = Resources.resourceID
    
	Order by Resources.resourcename
	
gettaxgeneral (Datasource=expert, Time=19ms, Records=4) in /home/www/html/rgall.cfm @ 18:03:24.024
	Select *
	From articles, articlePlacement
	Where type = 3
   	and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
   	and articlePlacement.networkid = 102
   	and articles.articleid = articlePlacement.articleid
    and publishdate <{ts '2020-07-02 18:03:24'}
    ORDER by publishdate desc 
checkrptarticles (Datasource=reports, Time=12ms, Records=0) in /home/www/html/navcontentbox.cfm @ 18:03:24.024
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-02"
     
         and rptarticlenetworks.networkid = 102 
    ORDER by rptarticles.rptarticleID desc
    
gettaxgeneral2 (Datasource=expert, Time=11ms, Records=1) in /home/www/html/navcontentbox.cfm @ 18:03:24.024
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 102 
	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=7ms, Records=0) in /home/www/html/navcontentbox.cfm @ 18:03:24.024
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 102 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentbox.cfm @ 18:03:24.024
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 102 
          and date > '2013-04-01'
		order by date DESC


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/rgall.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/rgall.cfm
QUERY_STRING=categoryID=96&networkID=102
REMOTE_ADDR=172.69.63.195
REMOTE_HOST=172.69.63.195
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rgall.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=30842059
cftoken=18930636
sessionid=IBEXPATEXCHANGE.COM_30842059_18930636
urltoken=CFID=30842059&CFTOKEN=18930636
URL Parameters:
categoryID=96
networkID=102
Debug Rendering Time: 9 ms