January 2012

Prev Month Next Month

01
Burger Night
Sunday Breakfast

02
Taco Night

05
2-4-1 Mexican Dinners

08
Burger Night
Sunday Breakfast

09
Taco Night

12
2-4-1 Mexican Dinners

15
Burger Night
Sunday Breakfast

16
Taco Night

19
2-4-1 Mexican Dinners

21
test

22
Burger Night
Sunday Breakfast

23
Taco Night

26
2-4-1 Mexican Dinners

29
Burger Night
Sunday Breakfast

30
Taco Night

(default) 13 queries took 0 ms
Nr	Query	Affected	Num. rows
1	DESCRIBE `events`	12	12
2	DESCRIBE `event_comments`	8	8
3	DESCRIBE `menu_sections`	6	6
4	DESCRIBE `menu_items`	9	9
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` >= '2012-01-01' AND `Event`.`date` <= '2012-01-31' ORDER BY `Event`.`date` asc	1	1
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` = (124)	0	0
7	DESCRIBE `weekly_specials`	6	6
8	SELECT `WeeklySpecial`.`id`, `WeeklySpecial`.`name`, `WeeklySpecial`.`day`, `WeeklySpecial`.`description`, `WeeklySpecial`.`created`, `WeeklySpecial`.`modified` FROM `weekly_specials` AS `WeeklySpecial` WHERE 1 = 1	4	4
9	SELECT `MenuSection`.`name` FROM `menu_sections` AS `MenuSection` WHERE `MenuSection`.`type` = 'Breakfast' ORDER BY `MenuSection`.`display_order` ASC	3	3
10	SELECT `MenuSection`.`name` FROM `menu_sections` AS `MenuSection` WHERE `MenuSection`.`type` = 'Lunch / Dinner' ORDER BY `MenuSection`.`display_order` ASC	3	3
11	DESCRIBE `settings`	3	3
12	SELECT `Setting`.`value` FROM `settings` AS `Setting` WHERE `name` = 'hours'	1	1
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

(default) 13 queries took 0 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` >= '2012-01-01' AND `Event`.`date` <= '2012-01-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` = (124)

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