March 2011

(default) 13 queries took 8 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `events`	12	12	1
2	DESCRIBE `event_comments`	8	8	2
3	DESCRIBE `menu_sections`	6	6	1
4	DESCRIBE `menu_items`	9	9	1
5	SELECT `Event`.`id`, `Event`.`name`, `Event`.`date`, `Event`.`time`, `Event`.`description`, `Event`.`promote`, `Event`.`opening_band`, `Event`.`cover_charge`, `Event`.`image`, `Event`.`tix_status`, `Event`.`modified`, `Event`.`created` FROM `events` AS `Event` WHERE `Event`.`date` >= '2011-03-01' AND `Event`.`date` <= '2011-03-31' ORDER BY `Event`.`date` asc	8	8	0
6	SELECT `EventComments`.`id`, `EventComments`.`event_id`, `EventComments`.`commenters_name`, `EventComments`.`comment`, `EventComments`.`approved`, `EventComments`.`ip_address`, `EventComments`.`created`, `EventComments`.`modified` FROM `event_comments` AS `EventComments` WHERE `EventComments`.`event_id` IN (73, 74, 68, 76, 120, 121, 119, 122)	2	2	0
7	DESCRIBE `weekly_specials`	6	6	1
8	SELECT `WeeklySpecial`.`id`, `WeeklySpecial`.`name`, `WeeklySpecial`.`day`, `WeeklySpecial`.`description`, `WeeklySpecial`.`created`, `WeeklySpecial`.`modified` FROM `weekly_specials` AS `WeeklySpecial` WHERE 1 = 1	4	4	0
9	SELECT `MenuSection`.`name` FROM `menu_sections` AS `MenuSection` WHERE `MenuSection`.`type` = 'Breakfast' ORDER BY `MenuSection`.`display_order` ASC	3	3	0
10	SELECT `MenuSection`.`name` FROM `menu_sections` AS `MenuSection` WHERE `MenuSection`.`type` = 'Lunch / Dinner' ORDER BY `MenuSection`.`display_order` ASC	3	3	0
11	DESCRIBE `settings`	3	3	2
12	SELECT `Setting`.`value` FROM `settings` AS `Setting` WHERE `name` = 'hours'	1	1	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

(default) 13 queries took 8 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `events`

DESCRIBE `event_comments`

DESCRIBE `menu_sections`

DESCRIBE `menu_items`

SELECT `Event`.`id`, `Event`.`name`, `Event`.`date`, `Event`.`time`, `Event`.`description`, `Event`.`promote`, `Event`.`opening_band`, `Event`.`cover_charge`, `Event`.`image`, `Event`.`tix_status`, `Event`.`modified`, `Event`.`created` FROM `events` AS `Event` WHERE `Event`.`date` >= '2011-03-01' AND `Event`.`date` <= '2011-03-31' ORDER BY `Event`.`date` asc

SELECT `EventComments`.`id`, `EventComments`.`event_id`, `EventComments`.`commenters_name`, `EventComments`.`comment`, `EventComments`.`approved`, `EventComments`.`ip_address`, `EventComments`.`created`, `EventComments`.`modified` FROM `event_comments` AS `EventComments` WHERE `EventComments`.`event_id` IN (73, 74, 68, 76, 120, 121, 119, 122)

DESCRIBE `weekly_specials`

SELECT `WeeklySpecial`.`id`, `WeeklySpecial`.`name`, `WeeklySpecial`.`day`, `WeeklySpecial`.`description`, `WeeklySpecial`.`created`, `WeeklySpecial`.`modified` FROM `weekly_specials` AS `WeeklySpecial` WHERE 1 = 1

SELECT `MenuSection`.`name` FROM `menu_sections` AS `MenuSection` WHERE `MenuSection`.`type` = 'Breakfast' ORDER BY `MenuSection`.`display_order` ASC

SELECT `MenuSection`.`name` FROM `menu_sections` AS `MenuSection` WHERE `MenuSection`.`type` = 'Lunch / Dinner' ORDER BY `MenuSection`.`display_order` ASC

DESCRIBE `settings`

SELECT `Setting`.`value` FROM `settings` AS `Setting` WHERE `name` = 'hours'

SELECT COUNT(*) AS `count` FROM `event_comments` AS `EventComment` LEFT JOIN `events` AS `Event` ON (`EventComment`.`event_id` = `Event`.`id`) WHERE `EventComment`.`approved` = 0