Cigna International Health Insurance

Mali Travel Warning

Issued by US Department of State

Oct 04, 2011

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /trv.cfm
Time Stamp 30-May-20 09:18 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.60
Host Name 162.158.78.60


Execution Time

Total Time Avg Time Count Template
57 ms 57 ms 1 top level /home/www/html/trv.cfm
44 ms 44 ms 1 /home/www/html/navrightmidcolumn_rdesign4.cfm
44 ms 44 ms 1 /home/www/html/navsidesbottom_rdesign4.cfm
43 ms 43 ms 1 /home/www/html/navpropertybox_interim_main_new.cfm
7 ms 7 ms 1 /home/www/html/navtop_rdesign4.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/leftnav_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navtower_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign4.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/navmeta_rdesign4.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign4.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign4.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navlikeandmore.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
62 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 @ 21:18:24.024
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 21:18:24.024
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/trv.cfm @ 21:18:24.024
	Select *
	From articles
	Where articleID = 3970 
countrystatus (Datasource=expert, Time=1ms, Records=0) in /home/www/html/trv.cfm @ 21:18:24.024
	Select articlePlacement.networkID
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 3970 
	and articles.articleID = 3970 
	and articlePlacement.networkID = Networks.networkID 
UpdateImpressions (Datasource=expert, Time=1ms, Records=1) in /home/www/html/trv.cfm @ 21:18:24.024
  UPDATE articles
  SET impressions = impressions + 1
	Where articleID = 3970 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 21:18:24.024
	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 @ 21:18:24.024
	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 @ 21:18:24.024
	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 @ 21:18: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=1ms, Records=1) in /home/www/html/navtop_rdesign4.cfm @ 21:18:24.024
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.60'
and logtime > "2020-05-30 00:00:00.000"
and logtime < "2020-05-30 23:59:59.999"
ORDER BY logtime DESC
gettower (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navtower_rdesign4.cfm @ 21:18:24.024
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eesubtower"
	and weight > 7
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtower_rdesign4.cfm @ 21:18:24.024
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 867 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign4.cfm @ 21:18:24.024
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
	and weight = 7
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign4.cfm @ 21:18:24.024
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eebanner")
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign4.cfm @ 21:18:24.024
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getpropertyslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
SELECT *
FROM topics
WHERE topicid = 6
getclass (Datasource=tipripper, Time=25ms, Records=66) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid, answers.rid, allreports.networkname, allreports.networkid, allreports.city, allreports.state
	FROM answersphoto, answers, allreports 
	WHERE answersphoto.answerid = answers.answerid
	and allreports.answerid = answers.answerid
	and allreports.topicid = 6
	and allreports.hide <> 'y'
	and (answers.paid = 'yes' or answers.paid = 'free')
	AND answersphoto.qid = '104'
	AND "2020-05-30" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
getprice (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80601'
	AND answerstext.qid = 109
getbed (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80601'
	AND answerstext.qid = 113
getbath (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80601'
	AND answerstext.qid = 114
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '87'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80601'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80601'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80601'
AND answersmc.qoid = qoptions.qoid
getprice (Datasource=tipripper, Time=0ms, Records=0, Cached Query) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80600'
	AND answerstext.qid = 109
getbed (Datasource=tipripper, Time=0ms, Records=0, Cached Query) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80600'
	AND answerstext.qid = 113
getbath (Datasource=tipripper, Time=0ms, Records=0, Cached Query) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80600'
	AND answerstext.qid = 114
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '87'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1, Cached Query) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80600'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1, Cached Query) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80600'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1, Cached Query) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80600'
AND answersmc.qoid = qoptions.qoid
getprice (Datasource=tipripper, Time=0ms, Records=0, Cached Query) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80599'
	AND answerstext.qid = 109
getbed (Datasource=tipripper, Time=0ms, Records=0, Cached Query) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80599'
	AND answerstext.qid = 113
getbath (Datasource=tipripper, Time=0ms, Records=0, Cached Query) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80599'
	AND answerstext.qid = 114
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '87'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1, Cached Query) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80599'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1, Cached Query) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80599'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1, Cached Query) in /home/www/html/navpropertybox_interim_main_new.cfm @ 21:18:24.024
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80599'
AND answersmc.qoid = qoptions.qoid
GetCountryList (Datasource=expert, Time=0ms, Records=96, Cached Query) in /home/www/html/navsidesbottom_rdesign4.cfm @ 21:18:24.024
  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/trv.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/trv.cfm
QUERY_STRING=networkID=159&articleID=3970
REMOTE_ADDR=162.158.78.60
REMOTE_HOST=162.158.78.60
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/trv.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=28725432
cftoken=78540161
sessionid=IBEXPATEXCHANGE.COM_28725432_78540161
urltoken=CFID=28725432&CFTOKEN=78540161
URL Parameters:
articleID=3970
networkID=159
Debug Rendering Time: 9 ms