Comic Listing - Directory - Order by Last Edited Page 3

Debug :: Max query time » (0.011183) :: Querys 30 :: page load time » 0.025531 seconds :: close

Debug Info: [minimize]

Query :: time » 0.000632 :: affected rows » 0

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

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

SELECT id FROM log WHERE ip='3.214.184.223' AND time>1696337217 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.011183 :: 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: 65

Query :: time » 0.000437 :: affected rows » 10

SELECT * FROM comics ORDER BY edit_time DESC LIMIT 20, 10

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

Trace

page: directory.php function: query line: 109

Query :: time » 0.000225 :: 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: 110
page: consts.php function: query line: 162

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

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

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

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

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

Query :: time » 0.000214 :: affected rows » 0

SELECT * FROM comic_users WHERE comic_id=19768

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

Query :: time » 0.000225 :: affected rows » 0

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

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

Query :: time » 0.000101 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=19233

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

Query :: time » 0.000153 :: affected rows » 0

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

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

Query :: time » 9.3E-5 :: affected rows » 0

SELECT * FROM comic_users WHERE comic_id=1185

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

Query :: time » 0.000136 :: affected rows » 0

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

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

Query :: time » 0.000121 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=19746

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

Query :: time » 0.000125 :: affected rows » 0

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

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

Query :: time » 9.5E-5 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=19741

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

Query :: time » 0.000115 :: affected rows » 0

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

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

Query :: time » 0.000104 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=19740

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

Query :: time » 0.000139 :: affected rows » 0

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

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

Query :: time » 9.3E-5 :: affected rows » 0

SELECT * FROM comic_users WHERE comic_id=4777

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

Query :: time » 0.000125 :: affected rows » 0

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

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

Query :: time » 0.000146 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=19521

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

Query :: time » 0.000176 :: affected rows » 0

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

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

Query :: time » 0.00014 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=19730

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

Query :: time » 0.000183 :: affected rows » 0

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

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

Query :: time » 0.000135 :: affected rows » 1

SELECT * FROM comic_users WHERE comic_id=19722

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

Query :: time » 0.000167 :: affected rows » 0

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

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

Variables

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

User Menu

Directory Ordering Options

Web Comic: My Hero!

My Hero!

Web Comic: A Broken Winter

A Broken Winter

Web Comic: PoKeMoN HEROES

PoKeMoN HEROES

Web Comic: M

M

Web Comic: Caraway Crew

Caraway Crew

Web Comic: Emu Sher Et

Emu Sher Et

Web Comic: Galumph

Galumph

Web Comic: Amy, Headshot and a Cat

Amy, Headshot and a Cat

Web Comic: Entanglement

Entanglement

Web Comic: SCARY-OKE

SCARY-OKE