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

Healthcare in Peru > Expat Health Insurance & Healthcare Guide to Peru

Expat Health Insurance & Healthcare Guide to Peru

Expats share their experiences with healthcare and expat health insurance in Peru.

Share Your Healthcare Experiences Share Your Childbirth Experiences
Expat Health Insurance & Medical Care

Expat Health Insurance and Healthcare in Lima, Peru

Clinica Good Hope is an excellent private hospital with a 24 hour ER that is two blocks from my house.

Submitted By

AlpineprinceAlpineprince
expat health insurance from CIGNA

Choosing an expat health insurance provider is an important decision. Get a quote from our trusted expat health insurance partner, CIGNA. With Cigna Global Health Options, you can create an international health insurance plan that's perfectly tailored for the needs of you and your family.

Learn More Get a Quote

Integra Expat Health InsuranceExpatriate Health Insurance

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

Healthcare in LimaHealthcare in Lima, Peru

Clinica Good Hope is an excellent private hospital with a 24 hour ER that is two blocks from my house.

expat healthcare surveyAnswer Questions about Healthcare in Peru

Help others moving to Peru by answering a set of questions about health insurance, public healthcare in Peru, prescription medicine, quality of medical care and emergency services.

Having a Baby AbroadHaving a Baby Abroad Report

Being pregnant and giving birth abroad can be a bit unnerving. If you've had a baby abroad, please take a few minutes to answer a few questions about your experiences. Your insight will help to prepare other expat parents-to-be -- and hopefully calm their nerves.

Read Reports from Other Parents about their Childbirth experiences abroad.

Integra Expat Health InsuranceExpatriate Health Insurance

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

healthcare in LimaHealthcare in Lima, Peru

Clinica Good Hope is an excellent private hospital with a 24 hour ER that is two blocks from my house. -

healthcare surveyAnswer Questions about Healthcare in Peru

Help others moving to Peru by answering a set of questions about health insurance, public healthcare in Peru, prescription medicine, quality of medical care and emergency services.

Having a Baby AbroadHaving a Baby Abroad Report

Being pregnant and giving birth abroad can be a bit unnerving. If you've had a baby abroad, please take a few minutes to answer a few questions about your experiences. Your insight will help to prepare other expat parents-to-be -- and hopefully calm their nerves.

Read Reports from Other Parents about their Childbirth experiences abroad.

Peru 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 /eetr/tips.cfm
Time Stamp 12-Jul-20 10:30 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.179
Host Name 173.245.54.179


Execution Time

Total Time Avg Time Count Template
291 ms 291 ms 1 /home/www/html/eetr/Application.cfm
190 ms 190 ms 1 top level /home/www/html/eetr/tips.cfm
95 ms 95 ms 1 /home/www/html/navtop_rdesign5.cfm
88 ms 88 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
31 ms 31 ms 1 /home/www/html/navcontentboxhealthcaremobile.cfm
12 ms 12 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
11 ms 11 ms 1 /home/www/html/navcontentboxhealthcarepc.cfm
11 ms 11 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/eetr/tipshealthcare.cfm
6 ms 3 ms 2 /home/www/html/eetr/rewritetipheadingstate.cfm
5 ms 5 ms 1 /home/www/html/eetr/tipshealthcarebaby.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/eetr/constants.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippaginglinkmaker.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippagingnew.cfm
1 ms 1 ms 1 /home/www/html/nativerotationtop_tester13.cfm
0 ms 0 ms 1 /home/www/html/boolsearch.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/eetr/datasources.cfm
0 ms 0 ms 3 /home/www/html/eetr/navconstants.cfm
0 ms 0 ms 1 /home/www/html/eetr/navinjection.cfm
0 ms 0 ms 1 /home/www/html/eetr/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/eetr/rewritealtimage.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/eetr/tippagingnewduplicate.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/navinjection.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
482 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/eetr/qry_GeneralSet.cfm @ 22:30:24.024
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=289ms, Records=1) in /home/www/html/eetr/Application.cfm @ 22:30:24.024
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=0ms, Records=153, Cached Query) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:30:24.024
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:30:24.024
	Select *
	From citynetworks
	Where networkID = 89
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:30:24.024
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 89 
getpropertycountries (Datasource=tipripper, Time=43ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:30:24.024
SELECT allreports.networkname, allreports.networkid, shortname, allreports.date
FROM allreports, Networks, sitecategories
WHERE rid = 100
and Networks.networkid = allreports.networkid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3
and allreports.hide <> 'y'

and allreports.tipcategoryid <> 2791

and allreports.tipcategoryid <> 2797
and allreports.networkid <> 159
group by allreports.networkid
order by allreports.networkname ASC
gettipcategories (Datasource=tipripper, Time=33ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:30:24.024
SELECT * 
FROM sitecategories, qoptions, allreports
WHERE qoptions.qoid = sitecategories.tipcategoryid
and qoptions.parent = 0
and allreports.hide <> 'y'
and sitecategories.siteid = 3
and sitecategories.tipcategoryid <> 2791
and sitecategories.tipcategoryid <> 2797
and sitecategories.tipcategoryid <> ''
and sitecategories.tipcategoryid <> 2793
and sitecategories.tipcategoryid <> 2792
and allreports.tipcategoryid = sitecategories.tipcategoryid
group by sitecategories.tipcategoryid 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:30:24.024
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.promophoto600, topics.tipstemplate
FROM topics

WHERE topicid = 7 
getname (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:30:24.024
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 89 
GetClassifieds (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:30:24.024
SELECT Networks.networkname, allreports.networkid, shortname, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allreports.allowcomments, allreports.citynetworkid, allreports.citynetworkid2, allreports.statenetworkid, allreports.city, sitecategories.categoryslug, sitecategories.headingnav, allreports.topicid, allreports.state, allreports.networkname, allreports.enddate, allreports.networkname as country
FROM allreports, sitecategories, Networks
WHERE allreports.rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and hide <> 'y'
and sitecategories.siteid = 3
and allreports.tipcategoryid <> 2797

and allreports.topicid = 7 
AND Networks.networkid = 89 
AND allreports.networkid = 89 
and allreports.tipcategoryid <> 2791

order by allreports.enddate DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:30:24.024
SELECT *
FROM topics

WHERE topicid = 7 
gettopic (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:30:24.024
SELECT *
FROM topics

WHERE topicid = 7 
getcountryphoto (Datasource=expert, Time=0ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 22:30:24.024
SELECT *
FROM countryphotos
WHERE networkid = 89 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:30:24.024
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.179'
and logtime > "2020-04-12"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 22:30:24.024
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.179'
and logtime > "2020-07-12 00:00:00.000"
and logtime < "2020-07-12 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 @ 22:30:24.024
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.179'
and logtime > "2020-07-05"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 22:30:24.024
	SELECT *
	From contentcountcountry
	Where networkid = 89 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 22:30:24.024
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-11"
    and fromDate < "2020-07-12"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 22:30:24.024
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getcount (Datasource=tipripper, Time=0ms, Records=6) in /home/www/html/eetr/tips.cfm @ 22:30:24.024
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 89 
order by city ASC, answerid DESC
gethealthintro (Datasource=expert, Time=5ms, Records=0) in /home/www/html/eetr/tips.cfm @ 22:30:24.024
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 89 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
   and articleCategories.section = '9'
    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-12"

    ORDER by articles.articleID asc   
    
getname (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tippaginglinkmaker.cfm @ 22:30:24.024
	Select *
	From Networks
	Where networkid = 89 
gettaxgeneral (Datasource=expert, Time=5ms, Records=0) in /home/www/html/eetr/tips.cfm @ 22:30:24.024
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, fbimg
	From articles, articleCategories, articlePlacement
	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-07-12"
    and articleCategories.articleID = articles.articleID
    and articlePlacement.articleID = articles.articleID
    and articlePlacement.networkID = 89
    and articleCategories.section = 9
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    ORDER by publishdate desc
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:30:24.024
SELECT *
FROM users
WHERE userid = '50099'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:30:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '89'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:30:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '89'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:30:24.024
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '4203'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:30:24.024
	SELECT summary 
	FROM answers
	WHERE answerid = 65947 
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:30:24.024
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65947 
	AND answerstext.qid = 409
	
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:30:24.024
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65947 
	AND answerstext.qid = 410
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 22:30:24.024
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 65947 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 22:30:24.024
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 65947 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 22:30:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65947'
	and qid = 391
	
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 22:30:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65947'
	and qid = 391
	
gettext402 (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 22:30:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65947'	and qid = 402
gettext401 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 22:30:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = '65947'	and qid = 401
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipshealthcare.cfm @ 22:30:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid	FROM answerstext	WHERE answerstext.answerid = 65947	AND answerstext.qid = 391
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:30:24.024
SELECT *
FROM natadoptions 
WHERE 'hibox' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:30:24.024
	Select *
	From Networks
	Where networkid = 89 
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:30:24.024
SELECT *
FROM natadoptions 
WHERE natadtypeid = 4 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:30:24.024
SELECT resourceid, natbox as adcode, natboxweight, natads.natadid
FROM natads, natadPlacement
WHERE natboxtype = 4
and natadPlacement.networkID = 89
and natadPlacement.natadid = natads.natadid
and natboxend > "2020-07-11"
and natboxstart < "2020-07-12"
and natboxstatus = 'live'

and (natboxweight = 'medium' or natboxweight = 'high')
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/eetr/tipshealthcarebaby.cfm @ 22:30:24.024
SELECT networkname as ctry, city, networkid, rid, answerid, networkname, userid
FROM allreports
WHERE rid = 88
and networkid = 89
GROUP BY answerid
ORDER BY answerid desc
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:30:24.024
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 89 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
   and articleCategories.section = '9'
    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-12"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
gethospitals (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:30:24.024
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 89 
		and (((title LIKE '%hospital%') OR (hitopic LIKE '%hospital%') OR (hidescript LIKE '%hospital%')))
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '22'
   and articleCategories.section = '9'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-12"
     ORDER by articles.title
 
GetClassifieds (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:30:24.024
SELECT *
FROM allreports, Networks, answers
WHERE allreports.rid = 100
and Networks.networkid = allreports.networkid
and allreports.topicid = 7
and hide <> 'y'
and allreports.networkid = 89 
and answers.answerid = allreports.answerid
and answers.reviewed = 'y'

    ORDER by allreports.answerid asc   
    
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:30:24.024
SELECT *
FROM topics
WHERE topicid = 7 
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:30:24.024
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65947 
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:30:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65947 
	AND answerstext.qid = 409
	
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:30:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65947 
	AND answerstext.qid = 410
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:30:24.024
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65947 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:30:24.024
	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 89
	and fbimg <> ''
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:30:24.024
	SELECT DISTINCT promophoto70 as photo 
	FROM topics
	WHERE topicid = 7 
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:30:24.024
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65947 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcaremobile.cfm @ 22:30:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '89'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:30:24.024
	SELECT summary as answer
	FROM answers
	WHERE answerid = 65947 
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:30:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65947 
	AND answerstext.qid = 409
	
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:30:24.024
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 65947 
	AND answerstext.qid = 410
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:30:24.024
	SELECT DISTINCT summary, hiimg as photo
	FROM answers 
	WHERE answers.answerid = 65947 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:30:24.024
	SELECT DISTINCT fbimg as photo 
	FROM countryphotos
	WHERE networkid = 89
	and fbimg <> ''
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:30:24.024
	SELECT DISTINCT promophoto70 as photo 
	FROM topics
	WHERE topicid = 7 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:30:24.024
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext
FROM topics
WHERE topicid = 7 
getphotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:30:24.024
SELECT DISTINCT summary, hiimg
FROM answers 
WHERE answers.answerid = 65947 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxhealthcarepc.cfm @ 22:30:24.024
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '89'


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/eetr/tips.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/eetr/tips.cfm
QUERY_STRING=topicid=7&tipcategoryid=0&networkid=89&s=1&sort=r&slug=healthcare-in&slug2=peru
REMOTE_ADDR=173.245.54.179
REMOTE_HOST=173.245.54.179
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/eetr/tips.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Client Variables:
cfid=31788345
cftoken=98436185
hitcount=1
lastvisit={ts '2020-07-12 22:30:24'}
timecreated={ts '2020-07-12 22:30:24'}
urltoken=CFID=31788345&CFTOKEN=98436185
Cookie Variables:
CFID=31788345
CFTOKEN=98436185
Session Variables:
cfid=31788345
cftoken=98436185
sessionid=IBEXPATEXCHANGE_31788345_98436185
urltoken=CFID=31788345&CFTOKEN=98436185
URL Parameters:
networkid=89
s=1
slug=healthcare-in
slug2=peru
sort=r
tipcategoryid=0
topicid=7
Debug Rendering Time: 10 ms