Videos

(default) 8 queries took 2 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `videos`	5	5	1
2	SELECT COUNT(*) AS `count` FROM `videos` AS `Video` WHERE 1 = 1	1	1	0
3	SELECT COUNT(*) AS `count` FROM `videos` AS `Video` WHERE 1 = 1	1	1	0
4	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	1
5	SELECT `MenuSection`.`name` FROM `menu_sections` AS `MenuSection` WHERE `MenuSection`.`type` = 'Breakfast' ORDER BY `MenuSection`.`display_order` ASC	3	3	0
6	SELECT `MenuSection`.`name` FROM `menu_sections` AS `MenuSection` WHERE `MenuSection`.`type` = 'Lunch / Dinner' ORDER BY `MenuSection`.`display_order` ASC	3	3	0
7	SELECT `Setting`.`value` FROM `settings` AS `Setting` WHERE `name` = 'hours'	1	1	0
8	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