World Newspapers and Magazines

Total Time	Avg Time	Count	Template
47 ms	47 ms	1	D:\WebsitesDev\worldpress.org\admin_tools\newspapermodel.cfm
32 ms	4 ms	8	D:/WebsitesDev/worldpress.org/adsys/include_ads.cfm
16 ms	16 ms	1	D:/WebsitesDev/worldpress.org/aaron/bottom/bottom_links.cfm
16 ms	16 ms	1	D:/WebsitesDev/worldpress.org/admin_tools/front/bottom-new.cfm
16 ms	16 ms	1	D:/WebsitesDev/worldpress.org/admin_tools/front/leftbar-new.cfm
0 ms	0 ms	1	D:/WebsitesDev/worldpress.org/Application.cfm
0 ms	0 ms	1	D:/WebsitesDev/worldpress.org/aaron/aaronnew.cfm
0 ms	0 ms	1	D:/WebsitesDev/worldpress.org/admin_tools/front/rightbar-new.cfm
0 ms	0 ms	1	D:/WebsitesDev/worldpress.org/admin_tools/front/top-new.cfm
16 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
63 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

		SELECT     C.id, AT.Type, C.TitleBoxText, C.BoxText, C.TitleBoxStyle, C.BoxStyle, C.LinkStyle
		FROM campaigns AS C 
			INNER JOIN ads_types AS AT ON C.adtypeid = AT.id
		WHERE C.ID = ?
			AND C.Active = 1
	

			SELECT     CA.adid, CA.weight, CA.datebegin, CA.dateend, CA.timebegin, CA.timeend, A.title, A.url, A.active, A.target, A.html
			FROM         campaigns_ads AS CA INNER JOIN
			                      ads AS A ON CA.adid = A.id
			WHERE     (CA.campaignid = '025DC7EA-EE35-4BA6-AC3A7426F9C73720')
				AND (A.active = 1)
				and a.name != 'Nicole Rocklin' and a.name != 'academi' and a.name not like 'Bluesky Interactive%' and a.name not like '%china%' and a.name not like '%AdvancedWriters%' and a.name not like '%DressFirm%'   and a.name not like '%Turkey%' and a.name not like 'Jayson Gibson%' 
					AND CA.adid <> '747A4FCA-3048-66AA-CB1C1477774EF483'
				

		SELECT     C.id, AT.Type, C.TitleBoxText, C.BoxText, C.TitleBoxStyle, C.BoxStyle, C.LinkStyle
		FROM campaigns AS C 
			INNER JOIN ads_types AS AT ON C.adtypeid = AT.id
		WHERE C.ID = ?
			AND C.Active = 1
	

			SELECT     CA.adid, CA.weight, CA.datebegin, CA.dateend, CA.timebegin, CA.timeend, A.title, A.url, A.active, A.target, A.html
			FROM         campaigns_ads AS CA INNER JOIN
			                      ads AS A ON CA.adid = A.id
			WHERE     (CA.campaignid = 'CCE7CFB0-2291-4A79-B051A23DE1B375C4')
				AND (A.active = 1)
				and a.id != 'BD50E3EA-3048-66AA-CB55A6612E1C93BF' and a.name != 'Nicole Rocklin' and a.name != 'academi' and a.name not like 'Bluesky Interactive%' and a.name not like '%china%' and a.name not like '%AdvancedWriters%' and a.name not like '%DressFirm%'   and a.name not like '%Turkey%' and a.name not like 'Jayson Gibson%' 
					AND CA.adid <> '747A4FCA-3048-66AA-CB1C1477774EF483'
				

		SELECT     C.id, AT.Type, C.TitleBoxText, C.BoxText, C.TitleBoxStyle, C.BoxStyle, C.LinkStyle
		FROM campaigns AS C 
			INNER JOIN ads_types AS AT ON C.adtypeid = AT.id
		WHERE C.ID = ?
			AND C.Active = 1
	

			SELECT     CA.adid, CA.weight, CA.datebegin, CA.dateend, CA.timebegin, CA.timeend, A.title, A.url, A.active, A.target, A.html
			FROM         campaigns_ads AS CA INNER JOIN
			                      ads AS A ON CA.adid = A.id
			WHERE     (CA.campaignid = '27EA174B-A0F0-48A8-9DA068E1B8F106E8')
				AND (A.active = 1)
				and a.name != 'Nicole Rocklin' and a.name != 'academi' and a.name not like 'Bluesky Interactive%' and a.name not like '%china%' and a.name not like '%AdvancedWriters%' and a.name not like '%DressFirm%'   and a.name not like '%Turkey%' and a.name not like 'Jayson Gibson%' 
					AND CA.adid <> '747A4FCA-3048-66AA-CB1C1477774EF483'
				

		SELECT     C.id, AT.Type, C.TitleBoxText, C.BoxText, C.TitleBoxStyle, C.BoxStyle, C.LinkStyle
		FROM campaigns AS C 
			INNER JOIN ads_types AS AT ON C.adtypeid = AT.id
		WHERE C.ID = ?
			AND C.Active = 1
	

			SELECT     CA.adid, CA.weight, CA.datebegin, CA.dateend, CA.timebegin, CA.timeend, A.title, A.url, A.active, A.target, A.html
			FROM         campaigns_ads AS CA INNER JOIN
			                      ads AS A ON CA.adid = A.id
			WHERE     (CA.campaignid = 'F9DE18E7-5355-4AC0-A9588218008DA997')
				AND (A.active = 1)
				and a.name != 'Nicole Rocklin' and a.name != 'academi' and a.name not like 'Bluesky Interactive%' and a.name not like '%china%' and a.name not like '%AdvancedWriters%' and a.name not like '%DressFirm%'   and a.name not like '%Turkey%' and a.name not like 'Jayson Gibson%' 
					AND CA.adid <> '747A4FCA-3048-66AA-CB1C1477774EF483'
				

		SELECT     C.id, AT.Type, C.TitleBoxText, C.BoxText, C.TitleBoxStyle, C.BoxStyle, C.LinkStyle
		FROM campaigns AS C 
			INNER JOIN ads_types AS AT ON C.adtypeid = AT.id
		WHERE C.ID = ?
			AND C.Active = 1
	

			SELECT     CA.adid, CA.weight, CA.datebegin, CA.dateend, CA.timebegin, CA.timeend, A.title, A.url, A.active, A.target, A.html
			FROM         campaigns_ads AS CA INNER JOIN
			                      ads AS A ON CA.adid = A.id
			WHERE     (CA.campaignid = '43051CAF-7D15-45C1-8D0109A42CF28CB8')
				AND (A.active = 1)
				and a.name != 'Nicole Rocklin' and a.name != 'academi' and a.name not like 'Bluesky Interactive%' and a.name not like '%china%' and a.name not like '%AdvancedWriters%' and a.name not like '%DressFirm%'   and a.name not like '%Turkey%' and a.name not like 'Jayson Gibson%' 
					AND CA.adid <> '747A4FCA-3048-66AA-CB1C1477774EF483'
				

		SELECT     C.id, AT.Type, C.TitleBoxText, C.BoxText, C.TitleBoxStyle, C.BoxStyle, C.LinkStyle
		FROM campaigns AS C 
			INNER JOIN ads_types AS AT ON C.adtypeid = AT.id
		WHERE C.ID = ?
			AND C.Active = 1
	

			SELECT     CA.adid, CA.weight, CA.datebegin, CA.dateend, CA.timebegin, CA.timeend, A.title, A.url, A.active, A.target, A.html
			FROM         campaigns_ads AS CA INNER JOIN
			                      ads AS A ON CA.adid = A.id
			WHERE     (CA.campaignid = '3512C467-A066-4D35-A0EC2A675BBDCDBD')
				AND (A.active = 1)
				and a.name != 'Nicole Rocklin' and a.name != 'academi' and a.name not like 'Bluesky Interactive%' and a.name not like '%china%' and a.name not like '%AdvancedWriters%' and a.name not like '%DressFirm%'   and a.name not like '%Turkey%' and a.name not like 'Jayson Gibson%' 
					AND CA.adid <> '747A4FCA-3048-66AA-CB1C1477774EF483'
				

				Select id,country,city,affiliation, "Publication Name" as Publication_Name,"web site" as web_site
				From "Foreign Publications (Reprints)"	
				where country like 'Sierra Leone'	and  "web site" <> ''
				order by  "Publication Name" asc					
				

				Select country,city,affiliation, "Publication Name" as Publication_Name,"web site" as web_site
				From "Foreign Publications (Reprints)"	
				where country like 'Sierra Leone'	
				
				and  id not in (2936,3257,2978,3193,2506)
				
				order by  "Publication Name" asc					
				

		SELECT     C.id, AT.Type, C.TitleBoxText, C.BoxText, C.TitleBoxStyle, C.BoxStyle, C.LinkStyle
		FROM campaigns AS C 
			INNER JOIN ads_types AS AT ON C.adtypeid = AT.id
		WHERE C.ID = ?
			AND C.Active = 1
	

			SELECT     CA.adid, CA.weight, CA.datebegin, CA.dateend, CA.timebegin, CA.timeend, A.title, A.url, A.active, A.target, A.html
			FROM         campaigns_ads AS CA INNER JOIN
			                      ads AS A ON CA.adid = A.id
			WHERE     (CA.campaignid = '8E11504E-03AD-40B9-B9BF547DF5FAE270')
				AND (A.active = 1)
				and a.name != 'Nicole Rocklin' and a.name != 'academi' and a.name not like 'Bluesky Interactive%' and a.name not like '%china%' and a.name not like '%AdvancedWriters%' and a.name not like '%DressFirm%'   and a.name not like '%Turkey%' and a.name not like 'Jayson Gibson%' 
					AND CA.adid <> '747A4FCA-3048-66AA-CB1C1477774EF483'
				

		SELECT     C.id, AT.Type, C.TitleBoxText, C.BoxText, C.TitleBoxStyle, C.BoxStyle, C.LinkStyle
		FROM campaigns AS C 
			INNER JOIN ads_types AS AT ON C.adtypeid = AT.id
		WHERE C.ID = ?
			AND C.Active = 1
	

			SELECT     CA.adid, CA.weight, CA.datebegin, CA.dateend, CA.timebegin, CA.timeend, A.title, A.url, A.active, A.target, A.html
			FROM         campaigns_ads AS CA INNER JOIN
			                      ads AS A ON CA.adid = A.id
			WHERE     (CA.campaignid = '7692CB3D-83CF-4487-A39DB677EFBABD5B')
				AND (A.active = 1)
				and a.id != 'C2F2A15D-1BA3-4A00-B1C07D81EC133E8E' and a.id != '97CB7D53-6D4C-4E81-BD3FB440D1FA34B5' and a.id != 'AFDEF7F7-6A1C-4F4C-9EE29D3BE0ED5382' and a.name != 'Nicole Rocklin' and a.name != 'academi' and a.name not like 'Bluesky Interactive%' and a.name not like '%china%' and a.name not like '%AdvancedWriters%' and a.name not like '%DressFirm%'   and a.name not like '%Turkey%' and a.name not like 'Jayson Gibson%' 
					AND CA.adid <> '747A4FCA-3048-66AA-CB1C1477774EF483'
				

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=128
CERT_SECRETKEYSIZE=3072
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=Let's Encrypt Authority X3
CERT_SERVER_SUBJECT=CN=worldpress.org
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\WebsitesDev\worldpress.org\admin_tools\newspapermodel.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=128
HTTPS_SECRETKEYSIZE=3072
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=Let's Encrypt Authority X3
HTTPS_SERVER_SUBJECT=CN=worldpress.org
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=gzip,deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=worldpress.org
HTTP_REFERER=
HTTP_URL=/admin_tools/newspapermodel.cfm?act=continent&continent=AFRICA&country=Sierra_Leone
HTTP_USER_AGENT=ColdFusion
LOCAL_ADDR=64.71.73.226
PATH_INFO=
PATH_TRANSLATED=D:\WebsitesDev\worldpress.org\admin_tools\newspapermodel.cfm
QUERY_STRING=act=continent&continent=AFRICA&country=Sierra_Leone
REMOTE_ADDR=64.71.73.226
REMOTE_HOST=64.71.73.226
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/admin_tools/newspapermodel.cfm
SERVER_NAME=worldpress.org
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=

URL Parameters:
act=continent
continent=AFRICA
country=Sierra_Leone