February 2011

Prev Month Next Month

03
2-4-1 Mexican Dinners

06
Burger Night
Sunday Breakfast

07
Taco Night

10
2-4-1 Mexican Dinners

13
Burger Night
Sunday Breakfast

14
Taco Night

17
2-4-1 Mexican Dinners

18
Test event with no pic
Derek's Event

19
Test Event with pic

20
Burger Night
Sunday Breakfast

21
Taco Night

24
Another test event
2-4-1 Mexican Dinners

27
Burger Night
Sunday Breakfast

28
Taco Night

(default) 13 queries took 1 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `events`	12	12	1
2	DESCRIBE `event_comments`	8	8	0
3	DESCRIBE `menu_sections`	6	6	0
4	DESCRIBE `menu_items`	9	9	0
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-02-01' AND `Event`.`date` <= '2011-02-28' ORDER BY `Event`.`date` asc	4	4	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 (69, 72, 66, 75)	0	0	0
7	DESCRIBE `weekly_specials`	6	6	0
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	0
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 1 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-02-01' AND `Event`.`date` <= '2011-02-28' 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 (69, 72, 66, 75)

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