Comic Listing - Wukrii - A Fantasy Adventure Webcomic By Lagoloid and Gatsumann

Debug :: Max query time » (0.000591) :: Querys 13 :: page load time » 0.009747 seconds :: close

Debug Info: [minimize]

Query :: time » 0.000591 :: affected rows » 0

SELECT * FROM bans WHERE ip='18.212.206.217' AND time>1550463208

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bans		ref	ip,time	ip	17	const	1	5.00	Using where

Trace

page: comic.php function: include line: 2
page: consts.php function: query line: 41

Query :: time » 0.000439 :: affected rows » 0

SELECT id FROM log WHERE ip='18.212.206.217' AND time>1550463198 AND site=''

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE										Impossible WHERE noticed after reading const tables

Trace

page: comic.php function: include line: 2
page: consts.php function: query line: 45

Query :: time » 0.000337 :: affected rows » 1

SELECT * FROM comics WHERE id=19841

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

Trace

page: comic.php function: query line: 4

Query :: time » 0.000289 :: affected rows » 8

SELECT * FROM arts ORDER BY name ASC

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	arts		ALL					8	100.00	Using filesort

Trace

page: comic.php function: load_things line: 32
page: consts.php function: query line: 162

Query :: time » 0.000253 :: affected rows » 8

SELECT * FROM updates

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

Trace

page: comic.php function: load_things line: 32
page: consts.php function: query line: 166

Query :: time » 0.000292 :: affected rows » 6

SELECT * FROM styles ORDER BY name ASC

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

Trace

page: comic.php function: load_things line: 32
page: consts.php function: query line: 170

Query :: time » 0.00023 :: affected rows » 4

SELECT * FROM stories

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

Trace

page: comic.php function: load_things line: 32
page: consts.php function: query line: 174

Query :: time » 0.000211 :: affected rows » 5

SELECT * FROM ratings

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

Trace

page: comic.php function: load_things line: 32
page: consts.php function: query line: 178

Query :: time » 0.000262 :: affected rows » 34

SELECT * FROM topics ORDER BY name ASC

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	topics		ALL					34	100.00	Using filesort

Trace

page: comic.php function: load_things line: 32
page: consts.php function: query line: 182

Query :: time » 0.000271 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=19841

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	comic_users		ref	PRIMARY	PRIMARY	3	const	2	100.00	Using index

Trace

page: comic.php function: query line: 49

Query :: time » 0.000393 :: affected rows » 15

SELECT t.name FROM comic_topics ct, topics t WHERE ct.topic_id=t.id AND ct.comic_id=19841

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ct		ref	PRIMARY,comic_id,topic_id	PRIMARY	3	const	14	100.00	Using index
1	SIMPLE	t		eq_ref	PRIMARY	PRIMARY	3	comiclisting.ct.topic_id	1	100.00

Trace

page: comic.php function: query line: 70

Query :: time » 0.000527 :: affected rows » 5

SELECT c.* FROM comics c, comic_relations cr WHERE comic_id=19841 AND type=1 AND comic2_id=c.id

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cr		ref	PRIMARY	PRIMARY	3	const	5	10.00	Using where; Using index
1	SIMPLE	c		eq_ref	PRIMARY	PRIMARY	3	comiclisting.cr.comic2_id	1	100.00

Trace

page: comic.php function: query line: 178

Query :: time » 0.00031 :: affected rows » 0

SELECT c.* FROM comics c, comic_relations cr WHERE comic_id=19841 AND type=2 AND comic2_id=c.id

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cr		ref	PRIMARY	PRIMARY	3	const	5	10.00	Using where; Using index
1	SIMPLE	c		eq_ref	PRIMARY	PRIMARY	3	comiclisting.cr.comic2_id	1	100.00

Trace

page: comic.php function: query line: 193

Variables

Post :: array(0) {
}
Get :: array(2) {
  ["comic_id"]=>
  int(19841)
  ["cname"]=>
  string(37) "Wukrii - A Fantasy Adventure Webcomic"
}
Session :: array(0) {
}
Files :: array(0) {
}

Web Comic: Wukrii - A Fantasy Adventure Webcomic

Web Comic Info

Wukrii - A Fantasy Adventure Webcomic

Web Comic Stats

Web Comic, Topic Relations

Exploding Fetus

Makes Lem Laugh

Infinity Komix Studios

The Loose Screw

Fridgebound

Web Comic, User Relations

ComicListing Suggested Web Comics

User Menu