Masdar portal

User panel

View lessons:

Lesson name	Group	Author
الدرس الأول	المجموعة الأولى	Ata Alqadi
Test	المجموعة الأولى	Ata Alqadi
الدرس الأول	المجموعة الثانية	Ata Alqadi

Chart

Advanced Software Engineering
Ticker Symbol Time Period Chart Size Show Volume Bars Vertical Grid Horizontal Grid Log Scale Chart Type Price Band Moving Averages Technical Indicators	ChartDirector Financial Chart Demonstration

Comapny Headlines

Comapny Announcements

10 queries took 380 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Lesson`.`id`, `Lesson`.`name`, `Lesson`.`group_id`, `Lesson`.`description`, `Lesson`.`author_id`, `Lesson`.`duration`, `Lesson`.`status`, `Lesson`.`sort_id`, `Group`.`id`, `Group`.`name`, `Author`.`id`, `Author`.`name`, `Author`.`website`, `Author`.`email`, `Author`.`picture` FROM `lessons` AS `Lesson` LEFT JOIN `groups` AS `Group` ON (`Lesson`.`group_id` = `Group`.`id`) LEFT JOIN `authors` AS `Author` ON (`Lesson`.`author_id` = `Author`.`id`) WHERE 1 = 1 LIMIT 5	3	3	1
2	SELECT `Chapter`.`id`, `Chapter`.`name`, `Chapter`.`lesson_id`, `Chapter`.`status` FROM `chapters` AS `Chapter` WHERE `Chapter`.`lesson_id` IN (1, 2, 3)	3	3	2
3	DESCRIBE `symbols`	4	4	107
4	DESCRIBE `sectors`	3	3	53
5	DESCRIBE `markets`	2	2	16
6	SELECT `Symbol`.`id`, `Symbol`.`name` FROM `symbols` AS `Symbol` WHERE 1 = 1	7	7	15
7	DESCRIBE `headlines`	8	8	37
8	SELECT `Headline`.`id`, `Headline`.`title`, `Headline`.`content`, `Headline`.`market_id`, `Headline`.`sector_id`, `Headline`.`symbol_id`, `Headline`.`created`, `Headline`.`updated`, `Market`.`id`, `Market`.`name`, `Sector`.`id`, `Sector`.`name`, `Sector`.`market_id`, `Symbol`.`id`, `Symbol`.`name`, `Symbol`.`sector_id`, `Symbol`.`market_id` FROM `headlines` AS `Headline` LEFT JOIN `markets` AS `Market` ON (`Headline`.`market_id` = `Market`.`id`) LEFT JOIN `sectors` AS `Sector` ON (`Headline`.`sector_id` = `Sector`.`id`) LEFT JOIN `symbols` AS `Symbol` ON (`Headline`.`symbol_id` = `Symbol`.`id`) WHERE `Headline`.`symbol_id` = 1	0	0	92
9	DESCRIBE `announcements`	8	8	34
10	SELECT `Announcement`.`id`, `Announcement`.`title`, `Announcement`.`content`, `Announcement`.`market_id`, `Announcement`.`sector_id`, `Announcement`.`symbol_id`, `Announcement`.`created`, `Announcement`.`updated`, `Market`.`id`, `Market`.`name`, `Sector`.`id`, `Sector`.`name`, `Sector`.`market_id`, `Symbol`.`id`, `Symbol`.`name`, `Symbol`.`sector_id`, `Symbol`.`market_id` FROM `announcements` AS `Announcement` LEFT JOIN `markets` AS `Market` ON (`Announcement`.`market_id` = `Market`.`id`) LEFT JOIN `sectors` AS `Sector` ON (`Announcement`.`sector_id` = `Sector`.`id`) LEFT JOIN `symbols` AS `Symbol` ON (`Announcement`.`symbol_id` = `Symbol`.`id`) WHERE `Announcement`.`symbol_id` = 1	0	0	23

10 queries took 380 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Lesson`.`id`, `Lesson`.`name`, `Lesson`.`group_id`, `Lesson`.`description`, `Lesson`.`author_id`, `Lesson`.`duration`, `Lesson`.`status`, `Lesson`.`sort_id`, `Group`.`id`, `Group`.`name`, `Author`.`id`, `Author`.`name`, `Author`.`website`, `Author`.`email`, `Author`.`picture` FROM `lessons` AS `Lesson` LEFT JOIN `groups` AS `Group` ON (`Lesson`.`group_id` = `Group`.`id`) LEFT JOIN `authors` AS `Author` ON (`Lesson`.`author_id` = `Author`.`id`) WHERE 1 = 1 LIMIT 5

SELECT `Chapter`.`id`, `Chapter`.`name`, `Chapter`.`lesson_id`, `Chapter`.`status` FROM `chapters` AS `Chapter` WHERE `Chapter`.`lesson_id` IN (1, 2, 3)

DESCRIBE `symbols`

107

DESCRIBE `sectors`

DESCRIBE `markets`

SELECT `Symbol`.`id`, `Symbol`.`name` FROM `symbols` AS `Symbol` WHERE 1 = 1

DESCRIBE `headlines`

SELECT `Headline`.`id`, `Headline`.`title`, `Headline`.`content`, `Headline`.`market_id`, `Headline`.`sector_id`, `Headline`.`symbol_id`, `Headline`.`created`, `Headline`.`updated`, `Market`.`id`, `Market`.`name`, `Sector`.`id`, `Sector`.`name`, `Sector`.`market_id`, `Symbol`.`id`, `Symbol`.`name`, `Symbol`.`sector_id`, `Symbol`.`market_id` FROM `headlines` AS `Headline` LEFT JOIN `markets` AS `Market` ON (`Headline`.`market_id` = `Market`.`id`) LEFT JOIN `sectors` AS `Sector` ON (`Headline`.`sector_id` = `Sector`.`id`) LEFT JOIN `symbols` AS `Symbol` ON (`Headline`.`symbol_id` = `Symbol`.`id`) WHERE `Headline`.`symbol_id` = 1

DESCRIBE `announcements`

SELECT `Announcement`.`id`, `Announcement`.`title`, `Announcement`.`content`, `Announcement`.`market_id`, `Announcement`.`sector_id`, `Announcement`.`symbol_id`, `Announcement`.`created`, `Announcement`.`updated`, `Market`.`id`, `Market`.`name`, `Sector`.`id`, `Sector`.`name`, `Sector`.`market_id`, `Symbol`.`id`, `Symbol`.`name`, `Symbol`.`sector_id`, `Symbol`.`market_id` FROM `announcements` AS `Announcement` LEFT JOIN `markets` AS `Market` ON (`Announcement`.`market_id` = `Market`.`id`) LEFT JOIN `sectors` AS `Sector` ON (`Announcement`.`sector_id` = `Sector`.`id`) LEFT JOIN `symbols` AS `Symbol` ON (`Announcement`.`symbol_id` = `Symbol`.`id`) WHERE `Announcement`.`symbol_id` = 1