Comic Listing - Regarding Dandelions Issue 03 By Kari McElroy

Debug :: Max query time » (0.000387) :: Querys 13 :: page load time » 0.00904 seconds :: close

Debug Info: [minimize]

Query :: time » 0.000387 :: affected rows » 0

SELECT * FROM bans WHERE ip='35.172.165.64' AND time>1701792488

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.00025 :: affected rows » 0

SELECT id FROM log WHERE ip='35.172.165.64' AND time>1701792478 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.000204 :: affected rows » 1

SELECT * FROM comics WHERE id=19566

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.000219 :: 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: 34
page: consts.php function: query line: 162

Query :: time » 0.000152 :: 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: 34
page: consts.php function: query line: 166

Query :: time » 0.000154 :: 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: 34
page: consts.php function: query line: 170

Query :: time » 0.000191 :: 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: 34
page: consts.php function: query line: 174

Query :: time » 0.000183 :: 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: 34
page: consts.php function: query line: 178

Query :: time » 0.000191 :: 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: 34
page: consts.php function: query line: 182

Query :: time » 0.000221 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=19566

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

Trace

page: comic.php function: query line: 51

Query :: time » 0.000244 :: affected rows » 0

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

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	1	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: 72

Query :: time » 0.000318 :: affected rows » 5

SELECT c.* FROM comics c, comic_relations cr WHERE comic_id=19566 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	4	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: 180

Query :: time » 0.000161 :: affected rows » 0

SELECT c.* FROM comics c, comic_relations cr WHERE comic_id=19566 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	4	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: 195

Variables

Post :: array(0) {
}
Get :: array(2) {
  ["comic_id"]=>
  int(19566)
  ["cname"]=>
  string(29) "Regarding-Dandelions-Issue-03"
}
Session :: array(0) {
}
Files :: array(0) {
}

Web Comic: Regarding Dandelions Issue 03

Web Comic Info

Regarding Dandelions Issue 03

Web Comic Stats

Web Comic, Topic Relations

Chrusher Comix

Exploding Fetus

The Xcentrikz Interactive Comic

The Loose Screw

Jesus Death Metal

Web Comic, User Relations

ComicListing Suggested Web Comics

User Menu