World Newspapers and Magazines

Total Time	Avg Time	Count	Template
125 ms	125 ms	1	D:\WebsitesDev\worldpress.org\admin_tools\newspapermodel.cfm
78 ms	10 ms	8	D:/WebsitesDev/worldpress.org/adsys/include_ads.cfm
47 ms	47 ms	1	D:/WebsitesDev/worldpress.org/admin_tools/front/leftbar-new.cfm
31 ms	31 ms	1	D:/WebsitesDev/worldpress.org/aaron/bottom/bottom_links.cfm
31 ms	31 ms	1	D:/WebsitesDev/worldpress.org/admin_tools/front/bottom-new.cfm
16 ms	16 ms	1	D:/WebsitesDev/worldpress.org/admin_tools/front/rightbar-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/top-new.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
125 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 'United Kingdom/Scotland'	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 'United Kingdom/Scotland'	
				
				and  id not in (2954,828,837)
				
				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=EUROPE&country=United_Kingdom/Scotland
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=EUROPE&country=United_Kingdom/Scotland
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=EUROPE
country=United_Kingdom/Scotland