Comic Listing - Black Snow: Two Drink Minimum By Michael Balistreri

Debug :: Max query time » (0.000968) :: Querys 14 :: page load time » 0.006586 seconds :: close

Debug Info: [minimize]

Query :: time » 0.000265 :: affected rows » 0

SELECT * FROM bans WHERE ip='3.236.27.143' AND time>1685267975

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

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

SELECT * FROM comics WHERE id=19111

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.000124 :: 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 » 8.0E-5 :: 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 » 8.1E-5 :: 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 » 6.8E-5 :: 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 » 9.0E-5 :: 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.000142 :: 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.000181 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=19111

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: 49

Query :: time » 0.000168 :: affected rows » 7

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

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	6	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.000968 :: affected rows » 1

SELECT * FROM forum_topics WHERE id=33

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

Trace

page: comic.php function: query line: 105

Query :: time » 0.000336 :: affected rows » 5

SELECT c.* FROM comics c, comic_relations cr WHERE comic_id=19111 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	3	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.00014 :: affected rows » 0

SELECT c.* FROM comics c, comic_relations cr WHERE comic_id=19111 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	3	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(19111)
  ["cname"]=>
  string(29) "Black Snow: Two Drink Minimum"
}
Session :: array(0) {
}
Files :: array(0) {
}

Web Comic: Black Snow: Two Drink Minimum

Web Comic Info

Black Snow: Two Drink Minimum

Web Comic Stats

Web Comic, Topic Relations

Exploding Fetus

Hero

Ampersand Comics

The Loose Screw

Inky Stories

Web Comic, User Relations

ComicListing Suggested Web Comics

User Menu