Where To Stay

Residence Inn by Marriott
1854 W. El Camino Real
Mountain View, CA 94040-2356
Telephone: (650) 940-1300
Phone: (650) 940-1300
Reservation: 1-800-331-3131
Fax: (650) 969-4997
Directions

Value Inn Sunnyale
852 W. El Camino Real
Sunnyvale, CA 94087-1153
Telephone: (408) 773-1234
Reservation: 1-800-466-9075
Fax: (408) 773-0420
Directions

Hilton Inn Sunnyvale
1250 Lakeside Drive Sunnyvale,
CA 94086-4010
Telephone: (408) 738-4888
Reservation: 1-800-445-8667
Fax: (408) 737-7147
Directions

Phone: (408) 730-9500
Fax: (408) 730-9588

1136 West Evelyn Avenue
Sunnyvale, California 94086-5742

10 queries took 28 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `groups`	5	5	2
2	DESCRIBE `users`	25	25	2
3	DESCRIBE `accesses`	6	6	2
4	SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active`, `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`email` IS NULL AND `User`.`password` IS NULL AND `User`.`id` IS NULL AND `User`.`active` = 1 LIMIT 1	0	0	4
5	SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1	1	1	1
6	SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active` FROM `users` AS `User` WHERE `User`.`group_id` IN (3)	0	0	3
7	SELECT `Access`.`id`, `Access`.`group_id`, `Access`.`controller`, `Access`.`action`, `Access`.`date_created`, `Access`.`date_modified` FROM `accesses` AS `Access` WHERE `Access`.`group_id` IN (3)	25	25	5
8	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1	2	2	2
9	SELECT `Page`.`id`, `Page`.`title`, `Page`.`content`, `Page`.`filename`, `Page`.`layout`, `Page`.`show_title`, `Page`.`date_created`, `Page`.`date_modified`, `Page`.`active` FROM `pages` AS `Page` WHERE `Page`.`filename` = 'where_to_stay' LIMIT 1	1	1	3
10	SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified`, `GroupsPage`.`id`, `GroupsPage`.`page_id`, `GroupsPage`.`group_id` FROM `groups` AS `Group` LEFT JOIN `groups_pages` AS `GroupsPage` ON (`GroupsPage`.`page_id` IN (17) AND `GroupsPage`.`group_id` = `Group`.`id`)	3	3	4

10 queries took 28 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `groups`

DESCRIBE `users`

DESCRIBE `accesses`

SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active`, `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`email` IS NULL AND `User`.`password` IS NULL AND `User`.`id` IS NULL AND `User`.`active` = 1 LIMIT 1

SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'ANONYMOUS' LIMIT 1

SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`company`, `User`.`phone`, `User`.`fax`, `User`.`phone_alt`, `User`.`email`, `User`.`shipping_address1`, `User`.`shipping_address2`, `User`.`shipping_city`, `User`.`shipping_state_id`, `User`.`shipping_country_id`, `User`.`shipping_zipcode`, `User`.`billing_address1`, `User`.`billing_address2`, `User`.`billing_city`, `User`.`billing_state_id`, `User`.`billing_country_id`, `User`.`billing_zipcode`, `User`.`password`, `User`.`group_id`, `User`.`date_created`, `User`.`date_modified`, `User`.`active` FROM `users` AS `User` WHERE `User`.`group_id` IN (3)

SELECT `Access`.`id`, `Access`.`group_id`, `Access`.`controller`, `Access`.`action`, `Access`.`date_created`, `Access`.`date_modified` FROM `accesses` AS `Access` WHERE `Access`.`group_id` IN (3)

SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1

SELECT `Page`.`id`, `Page`.`title`, `Page`.`content`, `Page`.`filename`, `Page`.`layout`, `Page`.`show_title`, `Page`.`date_created`, `Page`.`date_modified`, `Page`.`active` FROM `pages` AS `Page` WHERE `Page`.`filename` = 'where_to_stay' LIMIT 1

SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified`, `GroupsPage`.`id`, `GroupsPage`.`page_id`, `GroupsPage`.`group_id` FROM `groups` AS `Group` LEFT JOIN `groups_pages` AS `GroupsPage` ON (`GroupsPage`.`page_id` IN (17) AND `GroupsPage`.`group_id` = `Group`.`id`)