Masdar portal - Courses

User panel

View chapters:

Showing page 1 of 1

8 queries took 167 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `chapters`	4	4	13
2	DESCRIBE `lessons`	8	8	12
3	DESCRIBE `groups`	2	2	11
4	DESCRIBE `authors`	5	5	11
5	DESCRIBE `files`	5	5	12
6	SELECT COUNT(*) AS `count` FROM `chapters` AS `Chapter` LEFT JOIN `lessons` AS `Lesson` ON (`Chapter`.`lesson_id` = `Lesson`.`id`) WHERE 1 = 1	1	1	13
7	SELECT `Chapter`.`id`, `Chapter`.`name`, `Chapter`.`lesson_id`, `Chapter`.`status`, `Lesson`.`id`, `Lesson`.`name`, `Lesson`.`group_id`, `Lesson`.`description`, `Lesson`.`author_id`, `Lesson`.`duration`, `Lesson`.`status`, `Lesson`.`sort_id` FROM `chapters` AS `Chapter` LEFT JOIN `lessons` AS `Lesson` ON (`Chapter`.`lesson_id` = `Lesson`.`id`) WHERE 1 = 1 LIMIT 15	3	3	86
8	SELECT `Cfile`.`id`, `Cfile`.`name`, `Cfile`.`path`, `Cfile`.`chapter_id`, `Cfile`.`status` FROM `files` AS `Cfile` WHERE `Cfile`.`chapter_id` IN (1, 2, 3)	4	4	9