001

SET 
    NAMES "utf8" COLLATE "utf8_general_ci"

execution time: 0.000 seconds (20.57%)
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/groupAssign.php	set_charset()	142

002

SELECT 
    * 
FROM 
    `champsRoundConfig` 
WHERE 
    id = 8

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

id	event_id	round	ring	base_points	jump_order
8		3	2	150	Asc

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/groupAssign.php	query()	175

003

SELECT 
    * 
FROM 
    `champsGroups` 
ORDER BY 
    `sort_order`

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

id	sort_order	name
1	1	Elite Standard Large
2	2	Elite Standard Medium
3	3	Elite Standard X-Large
4	4	Elite Standard Small
5	5	Elite Standard Miniature
6	6	Elite Veteran X-Large
7	7	Elite Veteran Large
8	8	Elite Veteran Medium
9	9	Elite Veteran Small
10	10	Elite Veteran Miniature
11	11	Pre Elite X-Large
12	12	Pre Elite Large
13	13	Pre Elite Medium
14	14	Pre Elite Small
15	15	Pre Elite Miniature
16	16	Elite-VH-X-Large
18	17	Elite VH-Medium
17	17	Elite VH-Large
19	18	Elite VH-Small
20	19	Elite VH-Miniature

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	champsGroups	ALL					33	100.00	Using filesort

File	Function	Line
/home/nadac1/public_html/administration/champs/groupAssign.php	query()	35
/home/nadac1/public_html/administration/champs/groupAssign.php	get_roundGroups()	212

004

SELECT 
    `id`, 
    `group_id` 
FROM 
    `champsGroupsToRings` 
WHERE 
    `round_id` = 8

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

id	group_id
58	11
59	12
60	13
61	14
62	15

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

File	Function	Line
/home/nadac1/public_html/administration/champs/groupAssign.php	query()	17
/home/nadac1/public_html/administration/champs/groupAssign.php	get_ringGroups()	51
/home/nadac1/public_html/administration/champs/groupAssign.php	get_roundGroups()	212

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' => '8', )

001	$_SESSION array ( )

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=8',
  'REDIRECT_STATUS' => '200',
  'REMOTE_ADDR' => '216.73.216.135',
  'REMOTE_PORT' => '23537',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_SCHEME' => 'http',
  'REQUEST_URI' => '/administration/champs/groupAssign.php?id=8',
  'SCRIPT_FILENAME' => '/home/nadac1/public_html/administration/champs/groupAssign.php',
  'SCRIPT_NAME' => '/administration/champs/groupAssign.php',
  'SCRIPT_URI' => 'http://www.nadac.com/administration/champs/groupAssign.php',
  'SCRIPT_URL' => '/administration/champs/groupAssign.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' => 'aKFmmaYBcy2mqarap9CsYwAAAUc',
  'PHP_SELF' => '/administration/champs/groupAssign.php',
  'REQUEST_TIME_FLOAT' => 1755408025.6964309215545654296875,
  'REQUEST_TIME' => 1755408025,
  'argv' => 
  array (
    0 => 'id=8',
  ),
  'argc' => 1,
)

Group Assignment to Rounds & Rings

Round 3 / Ring 2