Comic Listing - The Loose Screw By Max Greenzweig

Debug :: Max query time » (0.000618) :: Querys 13 :: page load time » 0.008613 seconds :: close

Debug Info: [minimize]

Query :: time » 0.000384 :: affected rows » 0

SELECT * FROM bans WHERE ip='3.214.184.223' AND time>1696345548

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

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

SELECT * FROM comics WHERE id=18967

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.000356 :: 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.000237 :: 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.000248 :: 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.000195 :: 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.000162 :: 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.000292 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=18967

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.000453 :: affected rows » 31

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

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	28	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.000618 :: affected rows » 5

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

SELECT c.* FROM comics c, comic_relations cr WHERE comic_id=18967 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(18967)
  ["cname"]=>
  string(15) "The-Loose-Screw"
}
Session :: array(0) {
}
Files :: array(0) {
}

Web Comic: The Loose Screw

Web Comic Info

The Loose Screw

Web Comic Stats

Web Comic, Topic Relations

Exploding Fetus

Makes Lem Laugh

Erratic Beat Comics

Ampersand Comics

Infinity Komix Studios

Web Comic, User Relations

ComicListing Suggested Web Comics

User Menu