Pendekar BB: a cakephp forum: Board Index

Pendekar BB

Page 1 of 1, showing 5 records out of 5 total, starting on record 1, ending on 5

CakePHP Discussion Forum
	Bincang CakePHP Topics: 7 Description: Bincang apa sahaja mengenai Framework Cakephp	Last post by: bazet in Array => set::merge around on 18/10/08
	Bincang PHP/MySQL Topics: 3 Description: Bincang programming PHP dan MySQL	Last post by: bazet in topik under bincang php around on 17/10/08
	Bincang Kosong Topics: 4 Description: Borak-borak kosong	Last post by: bazet in bug #1 around on 17/10/08
	Bincang Sistem Operasi Topics: Description: Bincang sistem operasi seperi Windows, Linux, FreeBSD	Last post by: bazet in MamakSpot Wifi Controller around on 17/10/08
	Pendekar BB Forum Development Topics: 2 Description: Update from dev	Last post by: bazet in Unread Post/Topic detection around on 17/10/08

Top Posters

bazet posted 18 topics

GoogleBot posted 0 topics

serimurni posted 0 topics

jakemeup posted 0 topics

botaks posted 0 topics

<< previous

next >>

(default) 22 queries took 20 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `forums`	6	6	1
2	DESCRIBE `topics`	9	9	1
3	DESCRIBE `users`	8	8	1
4	DESCRIBE `roles`	2	2	2
5	DESCRIBE `roles_users`	2	2	1
6	DESCRIBE `posts`	7	7	1
7	SELECT COUNT(*) AS `count` FROM `forums` AS `Forum` WHERE 1 = 1	1	1	1
8	SELECT `Forum`.`name`, `Forum`.`description`, `Forum`.`topics_count`, `Forum`.`id` FROM `forums` AS `Forum` WHERE 1 = 1 LIMIT 20	5	5	1
9	SELECT `Topic`.`id`, `Topic`.`title`, `Topic`.`created`, `Topic`.`user_id`, `Topic`.`forum_id` FROM `topics` AS `Topic` WHERE `Topic`.`forum_id` = (13) ORDER BY `Topic`.`id` DESC LIMIT 1	1	1	1
10	SELECT `User`.`username` FROM `users` AS `User` WHERE `User`.`id` = 1	1	1	1
11	SELECT `Topic`.`id`, `Topic`.`title`, `Topic`.`created`, `Topic`.`user_id`, `Topic`.`forum_id` FROM `topics` AS `Topic` WHERE `Topic`.`forum_id` = (14) ORDER BY `Topic`.`id` DESC LIMIT 1	1	1	1
12	SELECT `User`.`username` FROM `users` AS `User` WHERE `User`.`id` = 1	1	1	1
13	SELECT `Topic`.`id`, `Topic`.`title`, `Topic`.`created`, `Topic`.`user_id`, `Topic`.`forum_id` FROM `topics` AS `Topic` WHERE `Topic`.`forum_id` = (15) ORDER BY `Topic`.`id` DESC LIMIT 1	1	1	1
14	SELECT `User`.`username` FROM `users` AS `User` WHERE `User`.`id` = 1	1	1	0
15	SELECT `Topic`.`id`, `Topic`.`title`, `Topic`.`created`, `Topic`.`user_id`, `Topic`.`forum_id` FROM `topics` AS `Topic` WHERE `Topic`.`forum_id` = (16) ORDER BY `Topic`.`id` DESC LIMIT 1	1	1	1
16	SELECT `User`.`username` FROM `users` AS `User` WHERE `User`.`id` = 1	1	1	0
17	SELECT `Topic`.`id`, `Topic`.`title`, `Topic`.`created`, `Topic`.`user_id`, `Topic`.`forum_id` FROM `topics` AS `Topic` WHERE `Topic`.`forum_id` = (17) ORDER BY `Topic`.`id` DESC LIMIT 1	1	1	1
18	SELECT `User`.`username` FROM `users` AS `User` WHERE `User`.`id` = 1	1	1	0
19	SELECT `User`.`username`, `User`.`created` FROM `users` AS `User` WHERE 1 = 1 ORDER BY `User`.`id` DESC LIMIT 5	5	5	1
20	SELECT `User`.`username`, `Topic`.`created`, `Topic`.`title`, `Topic`.`forum_id`, `Topic`.`id` FROM `topics` AS `Topic` LEFT JOIN `users` AS `User` ON (`Topic`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY `Topic`.`created` DESC LIMIT 5	5	5	1
21	SELECT `User`.`username`, `User`.`posts_count` FROM `users` AS `User` WHERE 1 = 1 ORDER BY `User`.`posts_count` DESC LIMIT 5	5	5	1
22	SELECT `User`.`username`, `User`.`topics_count` FROM `users` AS `User` WHERE 1 = 1 ORDER BY `User`.`topics_count` DESC LIMIT 5	5	5	1

(default) 22 queries took 20 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `forums`

DESCRIBE `topics`

DESCRIBE `users`

DESCRIBE `roles`

DESCRIBE `roles_users`

DESCRIBE `posts`

SELECT COUNT(*) AS `count` FROM `forums` AS `Forum` WHERE 1 = 1

SELECT `Forum`.`name`, `Forum`.`description`, `Forum`.`topics_count`, `Forum`.`id` FROM `forums` AS `Forum` WHERE 1 = 1 LIMIT 20

SELECT `Topic`.`id`, `Topic`.`title`, `Topic`.`created`, `Topic`.`user_id`, `Topic`.`forum_id` FROM `topics` AS `Topic` WHERE `Topic`.`forum_id` = (13) ORDER BY `Topic`.`id` DESC LIMIT 1