001

SET 
    NAMES "utf8" COLLATE "utf8_general_ci"

execution time: 0.000 seconds (7.64%)
affected rows: 0
backtrace
to the top
close all

File	Function	Line
/home/nadac1/public_html/administration/database/Zebra_Database.php	query()	3477
/home/nadac1/public_html/administration/champs/runAssign.php	set_charset()	148

002

SELECT 
    * 
FROM 
    `champsRoundConfig` 
WHERE 
    id = 16

execution time: 0.000 seconds (10.21%)
returned rows: 1
explain
backtrace
to the top
close all

id	event_id	round	ring	base_points	jump_order
16		8	2	0	Desc

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	champsRoundConfig	const	PRIMARY	PRIMARY	4	const	1	100.00

File	Function	Line
/home/nadac1/public_html/administration/champs/runAssign.php	query()	175

003

SELECT 
    group_id, 
    champsGroups.name 
FROM 
    `champsGroupsToRings` 
    INNER JOIN `champsGroups` ON champsGroupsToRings.group_id = champsGroups.id 
WHERE 
    champsGroupsToRings.round_id = 16 
ORDER BY 
    champsGroups.sort_order

execution time: 0.000 seconds (13.04%)
returned rows: 0
explain
backtrace
to the top
close all

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	champsGroupsToRings	ALL					180	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	champsGroups	eq_ref	PRIMARY	PRIMARY	4	nadac1_opsDB.champsGroupsToRings.group_id	1	100.00	Using where

File	Function	Line
/home/nadac1/public_html/administration/champs/runAssign.php	query()	36
/home/nadac1/public_html/administration/champs/runAssign.php	get_groupsToRing()	208

004

SELECT 
    COUNT(id) AS counted 
FROM 
    `champsRuns` 
WHERE 
    round_id = '16'

execution time: 0.001 seconds (69.11%)
returned rows: 1
explain
backtrace
to the top
close all

counted
0

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	champsRuns	ALL					5580	100.00	Using where

File	Function	Line
/home/nadac1/public_html/administration/database/Zebra_Database.php	query()	859
/home/nadac1/public_html/administration/champs/runAssign.php	dcount()	12
/home/nadac1/public_html/administration/champs/runAssign.php	get_currentRunCount()	213

001	The "memcache" extension is available on you server - consider using memcache for caching query results. See the documentation for more information. to the top close all

001	$_POST array ( )

001	$_GET array ( 'id' => '16', )

001	$_SESSION NULL

001	$_FILES array ( )

001

$_SERVER

array (
  'CONTEXT_DOCUMENT_ROOT' => '/home/nadac1/public_html',
  'CONTEXT_PREFIX' => '',
  'DOCUMENT_ROOT' => '/home/nadac1/public_html',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'HTTP_ACCEPT' => '*/*',
  'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate',
  'HTTP_AUTHORIZATION' => '',
  'HTTP_CACHE_CONTROL' => 'max-age=0',
  'HTTP_CONNECTION' => 'keep-alive',
  'HTTP_HOST' => 'www.nadac.com',
  'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
  'HTTP_VIA' => '1.1 squid-proxy-5b5d847c96-vgtzk (squid/6.10)',
  'HTTP_X_FORWARDED_FOR' => '10.2.14.2',
  'PATH' => '/bin:/usr/bin',
  'PHP_INI_SCAN_DIR' => '/opt/cpanel/ea-php73/root/etc:/opt/cpanel/ea-php73/root/etc/php.d:.',
  'QUERY_STRING' => 'id=16',
  'REDIRECT_STATUS' => '200',
  'REMOTE_ADDR' => '216.73.216.135',
  'REMOTE_PORT' => '1435',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_SCHEME' => 'http',
  'REQUEST_URI' => '/administration/champs/runAssign.php?id=16',
  'SCRIPT_FILENAME' => '/home/nadac1/public_html/administration/champs/runAssign.php',
  'SCRIPT_NAME' => '/administration/champs/runAssign.php',
  'SCRIPT_URI' => 'http://www.nadac.com/administration/champs/runAssign.php',
  'SCRIPT_URL' => '/administration/champs/runAssign.php',
  'SERVER_ADDR' => '67.227.174.58',
  'SERVER_ADMIN' => 'webmaster@nadac.com',
  'SERVER_NAME' => 'www.nadac.com',
  'SERVER_PORT' => '80',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'SERVER_SIGNATURE' => '',
  'SERVER_SOFTWARE' => 'Apache',
  'TZ' => 'America/Detroit',
  'UNIQUE_ID' => 'aKFnY22WnIRCZWZRuaxX2AAAAcQ',
  'PHP_SELF' => '/administration/champs/runAssign.php',
  'REQUEST_TIME_FLOAT' => 1755408227.7107760906219482421875,
  'REQUEST_TIME' => 1755408227,
  'argv' => 
  array (
    0 => 'id=16',
  ),
  'argc' => 1,
)

Bulk Add Runs

Round 8 / Ring 2