Comic Listing - Directory - Order by Last Published Comic Page 1

Debug :: Max query time » (0.02148) :: Querys 30 :: page load time » 0.040172 seconds :: close

Debug Info: [minimize]

Query :: time » 0.000403 :: affected rows » 0

SELECT * FROM bans WHERE ip='18.206.238.176' AND time>1593992252

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: directory.php function: include line: 6
page: consts.php function: query line: 41

Query :: time » 0.0002 :: affected rows » 0

SELECT id FROM log WHERE ip='18.206.238.176' AND time>1593992242 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: directory.php function: include line: 6
page: consts.php function: query line: 45

Query :: time » 0.02148 :: affected rows » 19653

SELECT id FROM comics

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

Trace

page: directory.php function: query line: 64

Query :: time » 0.000475 :: affected rows » 10

SELECT * FROM comics ORDER BY last_updated DESC LIMIT 0, 10

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	comics		index		last_updated	4		10	100.00

Trace

page: directory.php function: query line: 108

Query :: time » 0.000316 :: 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: directory.php function: load_things line: 109
page: consts.php function: query line: 162

Query :: time » 0.000219 :: 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: directory.php function: load_things line: 109
page: consts.php function: query line: 166

Query :: time » 0.000226 :: 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: directory.php function: load_things line: 109
page: consts.php function: query line: 170

Query :: time » 0.000209 :: 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: directory.php function: load_things line: 109
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: directory.php function: load_things line: 109
page: consts.php function: query line: 178

Query :: time » 0.000278 :: 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: directory.php function: load_things line: 109
page: consts.php function: query line: 182

Query :: time » 0.000299 :: affected rows » 0

SELECT * FROM comic_users WHERE comic_id=18952

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: directory.php function: print_comic line: 116
page: consts.php function: query line: 234

Query :: time » 0.000436 :: affected rows » 10

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

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	9	100.00	Using index
1	SIMPLE	t		eq_ref	PRIMARY	PRIMARY	3	comiclisting.ct.topic_id	1	100.00

Trace

page: directory.php function: print_comic line: 116
page: consts.php function: query line: 299

Query :: time » 0.000189 :: affected rows » 0

SELECT * FROM comic_users WHERE comic_id=18839

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: directory.php function: print_comic line: 116
page: consts.php function: query line: 234

Query :: time » 0.000272 :: affected rows » 3

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

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	3	100.00	Using index
1	SIMPLE	t		eq_ref	PRIMARY	PRIMARY	3	comiclisting.ct.topic_id	1	100.00

Trace

page: directory.php function: print_comic line: 116
page: consts.php function: query line: 299

Query :: time » 0.000179 :: affected rows » 0

SELECT * FROM comic_users WHERE comic_id=15210

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: directory.php function: print_comic line: 116
page: consts.php function: query line: 234

Query :: time » 0.000271 :: affected rows » 4

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

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	5	100.00	Using index
1	SIMPLE	t		eq_ref	PRIMARY	PRIMARY	3	comiclisting.ct.topic_id	1	100.00

Trace

page: directory.php function: print_comic line: 116
page: consts.php function: query line: 299

Query :: time » 0.000199 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=19570

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: directory.php function: print_comic line: 116
page: consts.php function: query line: 234

Query :: time » 0.000279 :: affected rows » 5

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

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	4	100.00	Using index
1	SIMPLE	t		eq_ref	PRIMARY	PRIMARY	3	comiclisting.ct.topic_id	1	100.00

Trace

page: directory.php function: print_comic line: 116
page: consts.php function: query line: 299

Query :: time » 0.000189 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=19617

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: directory.php function: print_comic line: 116
page: consts.php function: query line: 234

Query :: time » 0.000297 :: affected rows » 9

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

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	8	100.00	Using index
1	SIMPLE	t		eq_ref	PRIMARY	PRIMARY	3	comiclisting.ct.topic_id	1	100.00

Trace

page: directory.php function: print_comic line: 116
page: consts.php function: query line: 299

Query :: time » 0.000185 :: affected rows » 0

SELECT * FROM comic_users WHERE comic_id=1680

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: directory.php function: print_comic line: 116
page: consts.php function: query line: 234

Query :: time » 0.000233 :: affected rows » 0

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

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: directory.php function: print_comic line: 116
page: consts.php function: query line: 299

Query :: time » 0.000186 :: affected rows » 0

SELECT * FROM comic_users WHERE comic_id=19701

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: directory.php function: print_comic line: 116
page: consts.php function: query line: 234

Query :: time » 0.000314 :: affected rows » 8

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

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	8	100.00	Using index
1	SIMPLE	t		eq_ref	PRIMARY	PRIMARY	3	comiclisting.ct.topic_id	1	100.00

Trace

page: directory.php function: print_comic line: 116
page: consts.php function: query line: 299

Query :: time » 0.000187 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=19240

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: directory.php function: print_comic line: 116
page: consts.php function: query line: 234

Query :: time » 0.000252 :: affected rows » 5

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

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	5	100.00	Using index
1	SIMPLE	t		eq_ref	PRIMARY	PRIMARY	3	comiclisting.ct.topic_id	1	100.00

Trace

page: directory.php function: print_comic line: 116
page: consts.php function: query line: 299

Query :: time » 0.000177 :: affected rows » 0

SELECT * FROM comic_users WHERE comic_id=18995

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: directory.php function: print_comic line: 116
page: consts.php function: query line: 234

Query :: time » 0.000248 :: affected rows » 2

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

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	2	100.00	Using index
1	SIMPLE	t		eq_ref	PRIMARY	PRIMARY	3	comiclisting.ct.topic_id	1	100.00

Trace

page: directory.php function: print_comic line: 116
page: consts.php function: query line: 299

Query :: time » 0.000174 :: affected rows » 0

SELECT * FROM comic_users WHERE comic_id=19667

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: directory.php function: print_comic line: 116
page: consts.php function: query line: 234

Query :: time » 0.000271 :: affected rows » 6

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

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	5	100.00	Using index
1	SIMPLE	t		eq_ref	PRIMARY	PRIMARY	3	comiclisting.ct.topic_id	1	100.00

Trace

page: directory.php function: print_comic line: 116
page: consts.php function: query line: 299

Variables

Post :: array(0) {
}
Get :: array(2) {
  ["sort_id"]=>
  int(12)
  ["order_id"]=>
  int(1)
}
Session :: array(0) {
}
Files :: array(0) {
}

User Menu

Directory Ordering Options

Web Comic: Past Expiry

Past Expiry

Web Comic: Callous

Callous

Web Comic: AppleGeeks

AppleGeeks

Web Comic: Welcome to Agency X

Welcome to Agency X

Web Comic: Rowan's Diary

Rowan's Diary

Web Comic: LinT

LinT

Web Comic: Working Doodles

Working Doodles

Web Comic: Booby Trap

Booby Trap

Web Comic: messcomicstrip

messcomicstrip

Web Comic: The Toad's Spirit

The Toad's Spirit