test [Lvl. 5] 12.20% Orbit Explore Space IO Game

Debug :: Max query time » (0.006297) :: Querys 8 :: page load time » 0.011862 seconds :: close

Debug Info: [minimize]

Query :: time » 0.006297 :: affected rows » 1

INSERT INTO log_0 (time, ip, agent, site, page, vars) VALUES (1765944145, 3628718219, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '/profile.php?user_id=4443', 'a:4:{s:6:\"$_POST\";a:0:{}s:5:\"$_GET\";a:1:{s:7:\"user_id\";s:4:\"4443\";}s:9:\"$_SESSION\";a:0:{}s:7:\"$_FILES\";a:0:{}}')

Trace

page: profile.php function: include line: 2
page: consts.php function: query line: 141

Query :: time » 0.000379 :: affected rows » 0

SELECT gl.* FROM geo_blocks gb, geo_locations gl WHERE gb.start <= 3628718219 AND gb.stop >= 3628718219 AND gb.location=gl.id ORDER BY gb.start DESC LIMIT 1

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gb		range	PRIMARY,start	PRIMARY	8		1	100.00	Using where
1	SIMPLE	gl		eq_ref	PRIMARY	PRIMARY	4	orbit.gb.location	1	100.00	Using where

Trace

page: profile.php function: include line: 2
page: consts.php function: get_location line: 160
page: maxmind.class.php function: query line: 122

Query :: time » 0.000232 :: affected rows » 1

SELECT * FROM users WHERE id=4443

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

Trace

page: profile.php function: __construct line: 5
page: user.class.php function: __construct line: 25
page: item.class.php function: load line: 48
page: item.class.php function: query line: 88

Query :: time » 0.000367 :: affected rows » 1

SELECT * FROM user_stats WHERE user_id=4443 AND type=0

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	user_stats		const	PRIMARY	PRIMARY	5	const,const	1	100.00

Trace

page: profile.php function: where line: 21
page: item.class.php function: query line: 181

Query :: time » 0.000175 :: affected rows » 1

SELECT count(*) num FROM achievements

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	achievements		index		PRIMARY	4		108	100.00	Using index

Trace

page: profile.php function: query line: 22

Query :: time » 0.000147 :: affected rows » 6

SELECT * FROM runs

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	runs		ALL					6	100.00

Trace

page: profile.php function: load_list line: 111
page: item.class.php function: query line: 135

Query :: time » 0.00043 :: affected rows » 0

SELECT ur.* FROM (SELECT min(run_time) best_time, run_id, type FROM `user_runs` WHERE user_id=4443 GROUP BY run_id, type) x INNER JOIN user_runs ur ON ur.user_id=4443 AND ur.run_time=x.best_time AND ur.run_id=x.run_id AND ur.type=x.type ORDER BY type, run_id

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	ur		ref	user_id,run_id	user_id	4	const	1	100.00	Using index condition; Using filesort
1	PRIMARY			ref			10	orbit.ur.run_time,orbit.ur.run_id,orbit.ur.type	2	100.00	Using index
2	DERIVED	user_runs		ref	user_id,run_id	user_id	4	const	1	100.00	Using index condition; Using temporary; Using filesort

Trace

page: profile.php function: query line: 113

Query :: time » 0.000396 :: affected rows » 18

SELECT a.*, ua.time FROM achievements a, user_achievements ua WHERE ua.achiv_id=a.id AND ua.user_id=4443 ORDER BY time DESC

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ua		ref	PRIMARY	PRIMARY	4	const	18	100.00	Using where; Using filesort
1	SIMPLE	a		eq_ref	PRIMARY	PRIMARY	4	orbit.ua.achiv_id	1	100.00	Using where

Trace

page: profile.php function: get_achievements line: 134
page: user.class.php function: query line: 134

Variables

Post :: array(0) {
}
Get :: array(1) {
  ["user_id"]=>
  string(4) "4443"
}
Session :: array(1) {
  ["location"]=>
  NULL
}
Cookie :: array(0) {
}
Files :: array(0) {
}

test profile

Game Completion 12.20%

Achievements (18/148)