001

SET 
    NAMES "utf8" COLLATE "utf8_general_ci"

execution time: 0.000 seconds (12.44%)
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 = 7

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

id	event_id	round	ring	base_points	jump_order
7		2	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/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 = 7 
ORDER BY 
    champsGroups.sort_order

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

group_id	name
11	Pre Elite X-Large
12	Pre Elite Large
13	Pre Elite Medium
14	Pre Elite Small
15	Pre Elite Miniature

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 
    `id`, 
    `dog_id`, 
    `callname`, 
    `group_id` 
FROM 
    `champsEntries` 
WHERE 
    group_id = 11

execution time: 0.000 seconds (13.73%)
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	champsEntries	ALL					1	100.00	Using where

File	Function	Line
/home/nadac1/public_html/administration/champs/runAssign.php	query()	114
/home/nadac1/public_html/administration/champs/runAssign.php	set_newRuns()	222

005

SELECT 
    `id`, 
    `dog_id`, 
    `callname`, 
    `group_id` 
FROM 
    `champsEntries` 
WHERE 
    group_id = 12

execution time: 0.000 seconds (6.66%)
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	champsEntries	ALL					1	100.00	Using where

File	Function	Line
/home/nadac1/public_html/administration/champs/runAssign.php	query()	114
/home/nadac1/public_html/administration/champs/runAssign.php	set_newRuns()	222

006

SELECT 
    `id`, 
    `dog_id`, 
    `callname`, 
    `group_id` 
FROM 
    `champsEntries` 
WHERE 
    group_id = 13

execution time: 0.000 seconds (6.84%)
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	champsEntries	ALL					1	100.00	Using where

File	Function	Line
/home/nadac1/public_html/administration/champs/runAssign.php	query()	114
/home/nadac1/public_html/administration/champs/runAssign.php	set_newRuns()	222

007

SELECT 
    `id`, 
    `dog_id`, 
    `callname`, 
    `group_id` 
FROM 
    `champsEntries` 
WHERE 
    group_id = 14

execution time: 0.000 seconds (7.59%)
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	champsEntries	ALL					1	100.00	Using where

File	Function	Line
/home/nadac1/public_html/administration/champs/runAssign.php	query()	114
/home/nadac1/public_html/administration/champs/runAssign.php	set_newRuns()	222

008

SELECT 
    `id`, 
    `dog_id`, 
    `callname`, 
    `group_id` 
FROM 
    `champsEntries` 
WHERE 
    group_id = 15

execution time: 0.000 seconds (6.23%)
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	champsEntries	ALL					1	100.00	Using where

File	Function	Line
/home/nadac1/public_html/administration/champs/runAssign.php	query()	114
/home/nadac1/public_html/administration/champs/runAssign.php	set_newRuns()	222

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 ( 'action' => 'add', 'id' => '7', )

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' => 'action=add&id=7',
  'REDIRECT_STATUS' => '200',
  'REMOTE_ADDR' => '216.73.216.135',
  'REMOTE_PORT' => '20965',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_SCHEME' => 'http',
  'REQUEST_URI' => '/administration/champs/runAssign.php?action=add&id=7',
  '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' => 'aKHuB6QYkFhNwWL7D61LpAAAAEI',
  'PHP_SELF' => '/administration/champs/runAssign.php',
  'REQUEST_TIME_FLOAT' => 1755442695.9758388996124267578125,
  'REQUEST_TIME' => 1755442695,
  'argv' => 
  array (
    0 => 'action=add&id=7',
  ),
  'argc' => 1,
)

Bulk Add Runs

Round 2 / Ring 2