Masdar portal - Courses

User panel

View chapters:

Showing page 1 of 1

8 queries took 124 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `chapters`	4	4	17
2	DESCRIBE `lessons`	8	8	18
3	DESCRIBE `groups`	2	2	18
4	DESCRIBE `authors`	5	5	18
5	DESCRIBE `files`	5	5	18
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	11
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 ORDER BY `Chapter`.`name` asc LIMIT 15	3	3	0
8	SELECT `Cfile`.`id`, `Cfile`.`name`, `Cfile`.`path`, `Cfile`.`chapter_id`, `Cfile`.`status` FROM `files` AS `Cfile` WHERE `Cfile`.`chapter_id` IN (2, 1, 3)	4	4	24