WORKS
From:  To:    Horses:  
Date Horse Track Surface Distance Time Rank
04/08/2018  Must Be Dreaming  PayPk  Training Track  5F  1:02.20  3/5 
04/08/2018  Tower of Texas  PayPk  Training Track  5F  1:02.00  1/5 
04/08/2018  United  PayPk  Training Track  3F  :38.20  1/2 
04/08/2018  Encyclopedia  PayPk  Training Track  3F  :38.20  1/2 
03/24/2018  Saba (FR)  PayPk  Turf  3F  :37.00  3/6 Turf 
03/24/2018  Countryside Drive  PayPk  Turf  6F  1:13.40  1/2 Turf 
03/24/2018  Encyclopedia  PayPk  Turf  3F  :36.00  1/6 Turf 
03/24/2018  Vivacitas  PayPk  Turf  3F  :37.60  5/6 Turf 
03/24/2018  My Gal Betty  PayPk  Turf  3F  :36.00  1/6 Turf 
03/24/2018  Golden Attitude   PayPk  Turf  3F  :37.00  3/6 Turf 
03/24/2018  Tower of Texas  PayPk  Turf  5F  1:03.00  18/18 Turf 
03/24/2018  Are You Kidding Me  PayPk  Turf  5F  :59.00  1/18 Turf 
03/24/2018  Bet on Mike  PayPk  Turf  6F  1:13.40  1/2 Turf 
03/24/2018  Final Copy  PayPk  Turf  5F  :59.60  3/18 Turf 
03/24/2018  Tiz A Slam  PayPk  Turf  5F  :59.00  1/18 Turf 
03/24/2018  Hatch Gate  PayPk  Turf  3F  :37.60  5/6 Turf 
03/17/2018  Countryside Drive  PayPk  Turf  5F  1:01.00  8/15 Turf 
03/17/2018  Hatch Gate  PayPk  Dirt  2F  :25.00  1/2  
03/17/2018  Tiz A Slam  PayPk  Turf  5F  :59.60  1/15 Turf 
03/17/2018  Final Copy  PayPk  Turf  5F  1:01.00  8/15 Turf 
03/17/2018  Danish Dynaformer  PayPk  Turf  5F  1:00.00  3/15 Turf 
03/17/2018  Tower of Texas  PayPk  Turf  5F  1:00.20  5/15 Turf 
03/17/2018  Are You Kidding Me  PayPk  Turf  5F  :59.60  1/15 Turf 
03/17/2018  Bet on Mike  PayPk  Dirt  5F  1:03.00  2/16  
03/17/2018  Saba (FR)  PayPk  Turf  2F  :25.40  1/3 Turf 
03/17/2018  Golden Attitude   PayPk  Turf  2F  :25.40  1/3 Turf 
03/17/2018  Stormy Action  PayPk  Turf  5F  1:00.20  5/15 Turf 
03/17/2018  Vivacitas  PayPk  Turf  2F  :26.00  3/3 Turf 
03/17/2018  Encyclopedia  PayPk  Dirt  2F  :26.00  2/2  

Debugging Information
ColdFusion Server Standard 8,0,1,195765
Template /trainers/att/works.cfm
Time Stamp 15-Apr-18 03:05 PM
Locale English (US)
User Agent Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0
Remote IP 65.190.38.101
Host Name 65.190.38.101

Execution Time

Total Time Avg Time Count Template
1437 ms 1437 ms 1 C:\Inetpub\wwwroot\Clients\tlorehorses.com\www\trainers\att\works.cfm
235 ms 235 ms 1 C:\Inetpub\wwwroot\Clients\tlorehorses.com\www\trainers\att\includes\filter.cfm
16 ms 16 ms 1 C:\Inetpub\wwwroot\Clients\tlorehorses.com\www\trainers\att\Application.cfm
16 ms 16 ms 1 C:\Inetpub\wwwroot\Clients\tlorehorses.com\www\trainers\att\includes\check_ip_country.cfm
125 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1578 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

qryGetWorkouts (Datasource=tlhdata, Time=1187ms, Records=29) in C:\Inetpub\wwwroot\Clients\tlorehorses.com\www\trainers\att\works.cfm @ 15:05:26.026
   select *,syndicate_trainer
   from training_summary ts inner join horse_summary_display hs
   on ts.horse_id = hs.horse_id
   where ts.trainer_id = ?
		and [date] between ?
			and ?
			
		and (activity_1 = 'breeze' or activity_2 = 'breeze')
   order by date desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 469
Parameter #2(cf_sql_date) = {ts '2018-03-15 00:00:00'}
Parameter #3(cf_sql_date) = {ts '2018-04-15 00:00:00'}

horse_list (Datasource=tlhdata, Time=125ms, Records=74) in C:\Inetpub\wwwroot\Clients\tlorehorses.com\www\trainers\att\includes\filter.cfm @ 15:05:26.026
		SELECT distinct name,horse_id
		FROM tlhdata.dbo.training_summary
		WHERE trainer_id=469
		
		ORDER by name asc
first_location (Datasource=tlhdata, Time=63ms, Records=1) in C:\Inetpub\wwwroot\Clients\tlorehorses.com\www\trainers\att\includes\filter.cfm @ 15:05:26.026
   SELECT top 1
      location_id, abbr, full_name
   FROM tlhdata.dbo.current_trainer_locations
   WHERE trainer_id=469
   ORDER by abbr
loc_list (Datasource=tlhdata, Time=47ms, Records=5) in C:\Inetpub\wwwroot\Clients\tlorehorses.com\www\trainers\att\includes\filter.cfm @ 15:05:26.026
   SELECT DISTINCT
      trainer_id,
      location_id,
      full_name,
      abbr
   FROM tlhdata.dbo.current_trainer_locations
   WHERE trainer_id = 469 and active_cd = 1
   ORDER BY abbr
locations (Datasource=tlhdata, Time=0ms, Records=0) in C:\Inetpub\wwwroot\Clients\tlorehorses.com\www\trainers\att\includes\filter.cfm @ 15:05:26.026
   SELECT
      trainer_id,
      location_id,
      full_name,
      abbr
   FROM tlhdata.dbo.current_trainer_locations
      WHERE location_id=999999999

Stored Procedures

check_ip_country (Datasource=ipdata, Time=16ms) in C:\Inetpub\wwwroot\Clients\tlorehorses.com\www\trainers\att\includes\check_ip_country.cfm @ 15:05:25.025

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  65.190.38.101    
    
resultsets
nameresultset
 getcountry  1

Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=168
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O="thawte, Inc.", CN=thawte SSL CA - G2
CERT_SERVER_SUBJECT=C=US, S=Florida, L=Delray Beach, O=TLore Management LLC, OU=Management, CN=www.tlore.net
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\Inetpub\wwwroot\Clients\tlorehorses.com\www\trainers\att\works.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=168
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O="thawte, Inc.", CN=thawte SSL CA - G2
HTTPS_SERVER_SUBJECT=C=US, S=Florida, L=Delray Beach, O=TLore Management LLC, OU=Management, CN=www.tlore.net
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip, deflate, br
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=
HTTP_HOST=www.tlore.net
HTTP_REFERER=http://www.attfieldracingstable.com/works/
HTTP_USER_AGENT=Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0
PATH_INFO=/trainers/att/works.cfm
PATH_TRANSLATED=C:\Inetpub\wwwroot\Clients\tlorehorses.com\www\trainers\att\works.cfm
QUERY_STRING=
REMOTE_ADDR=65.190.38.101
REMOTE_HOST=65.190.38.101
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/trainers/att/works.cfm
SERVER_NAME=www.tlore.net
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Cookie Variables:
CFID=81851389
CFTOKEN=13211234

Session Variables:
cfid=81851389
cftoken=13211234
current_loc=999999999
sessionid=TLORENET_81851389_13211234
urltoken=CFID=81851389&CFTOKEN=13211234
Debug Rendering Time: 31 ms