Videos

(default) 13 queries took 32 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `videos`	5	5	1
2	DESCRIBE `menu_sections`	6	6	0
3	DESCRIBE `menu_items`	9	9	0
4	SELECT COUNT(*) AS `count` FROM `videos` AS `Video` WHERE 1 = 1	1	1	0
5	SELECT COUNT(*) AS `count` FROM `videos` AS `Video` WHERE 1 = 1	1	1	0
6	SELECT `Video`.`id`, `Video`.`title`, `Video`.`code`, `Video`.`created`, `Video`.`modified` FROM `videos` AS `Video` WHERE 1 = 1 ORDER BY `Video`.`created` DESC LIMIT 10	4	4	31
7	SELECT `MenuSection`.`name` FROM `menu_sections` AS `MenuSection` WHERE `MenuSection`.`type` = 'Breakfast' ORDER BY `MenuSection`.`display_order` ASC	3	3	0
8	SELECT `MenuSection`.`name` FROM `menu_sections` AS `MenuSection` WHERE `MenuSection`.`type` = 'Lunch / Dinner' ORDER BY `MenuSection`.`display_order` ASC	3	3	0
9	DESCRIBE `settings`	3	3	0
10	SELECT `Setting`.`value` FROM `settings` AS `Setting` WHERE `name` = 'hours'	1	1	0
11	DESCRIBE `event_comments`	8	8	0
12	DESCRIBE `events`	12	12	0
13	SELECT COUNT(*) AS `count` FROM `event_comments` AS `EventComment` LEFT JOIN `events` AS `Event` ON (`EventComment`.`event_id` = `Event`.`id`) WHERE `EventComment`.`approved` = 0	1	1	0