Home | Employment | Q&A | WHL Associated Companies | Login

Contact Us | Map & Directions | Where To Stay

Projects/Other | WHL Advisors | WHL Pro Bono

• Images

- Biotech Gallery

------------------------------------

• WHL Biotech Accounts

- Agilent Technologies
- Amgen Inc
- BioMed Realty Trust, Inc.
- BioSeek, Inc
- Catalyst Biomedical
- Cognate Bioservices, Inc.
- Cytokinetics
- Genentech, Inc.
- KaloBios
- LBA Realty
- MetLife
- Newcastle Partners
- Simeon Properties
- Renovis
- Sutro BioPharma, Inc.
- United States Department of Defense Center for Deployment Health Research, Naval Health Research Center
- VaxGen, Inc.
- ZKS Real Estate Partners

------------------------------------

• Biotech Overview

------------------------------------

• Related Documentation

- Vivaria
- Eckhart Beatty

Biotech Galleries

- Biotech Gallery

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

1136 West Evelyn Avenue
Sunnyvale, California 94086-5742

26 queries took 114 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `galleries`	6	6	2
2	DESCRIBE `sectors`	6	6	6
3	DESCRIBE `overviews`	6	6	2
4	DESCRIBE `documents`	6	6	3
5	DESCRIBE `accounts`	6	6	3
6	DESCRIBE `gallery_images`	7	7	2
7	DESCRIBE `users`	25	25	4
8	DESCRIBE `groups`	5	5	2
9	DESCRIBE `accesses`	6	6	2
10	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
11	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	2
12	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
13	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	4
14	DESCRIBE `settings`	3	3	2
15	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1	2	2	1
16	SELECT `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `sectors` AS `Sector` WHERE `Sector`.`name` = 'Biotech' LIMIT 1	1	1	6
17	SELECT `Overview`.`id`, `Overview`.`sector_id`, `Overview`.`name`, `Overview`.`description`, `Overview`.`date_created`, `Overview`.`date_modified` FROM `overviews` AS `Overview` WHERE `Overview`.`sector_id` IN (1)	1	1	7
18	SELECT `Document`.`id`, `Document`.`name`, `Document`.`sector_id`, `Document`.`description`, `Document`.`date_created`, `Document`.`date_modified` FROM `documents` AS `Document` WHERE `Document`.`sector_id` IN (1)	2	2	3
19	SELECT `Account`.`id`, `Account`.`name`, `Account`.`sector_id`, `Account`.`link`, `Account`.`date_created`, `Account`.`date_modified` FROM `accounts` AS `Account` WHERE `Account`.`sector_id` IN (1)	18	18	2
20	SELECT `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`sector_id`, `Gallery`.`parent_id`, `Gallery`.`date_created`, `Gallery`.`date_modified` FROM `galleries` AS `Gallery` WHERE `Gallery`.`sector_id` IN (1)	4	4	2
21	SELECT `Document`.`id`, `Document`.`name`, `Document`.`sector_id`, `Document`.`description`, `Document`.`date_created`, `Document`.`date_modified`, `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `documents` AS `Document` LEFT JOIN `sectors` AS `Sector` ON (`Document`.`sector_id` = `Sector`.`id`) WHERE `Document`.`sector_id` = 1	2	2	3
22	SELECT `Account`.`id`, `Account`.`name`, `Account`.`sector_id`, `Account`.`link`, `Account`.`date_created`, `Account`.`date_modified`, `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `accounts` AS `Account` LEFT JOIN `sectors` AS `Sector` ON (`Account`.`sector_id` = `Sector`.`id`) WHERE `Account`.`sector_id` = 1	18	18	3
23	SELECT `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`sector_id`, `Gallery`.`parent_id`, `Gallery`.`date_created`, `Gallery`.`date_modified`, `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `galleries` AS `Gallery` LEFT JOIN `sectors` AS `Sector` ON (`Gallery`.`sector_id` = `Sector`.`id`) WHERE `Gallery`.`sector_id` = 1 AND `Gallery`.`parent_id` = 0	1	1	3
24	SELECT `GalleryImage`.`id`, `GalleryImage`.`file_name`, `GalleryImage`.`gallery_id`, `GalleryImage`.`caption`, `GalleryImage`.`order`, `GalleryImage`.`date_created`, `GalleryImage`.`date_modified` FROM `gallery_images` AS `GalleryImage` WHERE `GalleryImage`.`gallery_id` IN (99) ORDER BY `GalleryImage`.`order` ASC	0	0	4
25	SELECT `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`sector_id`, `Gallery`.`parent_id`, `Gallery`.`date_created`, `Gallery`.`date_modified`, `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `galleries` AS `Gallery` LEFT JOIN `sectors` AS `Sector` ON (`Gallery`.`sector_id` = `Sector`.`id`) WHERE `Gallery`.`sector_id` = 1 AND `Gallery`.`parent_id` <> 0	3	3	3
26	SELECT `GalleryImage`.`id`, `GalleryImage`.`file_name`, `GalleryImage`.`gallery_id`, `GalleryImage`.`caption`, `GalleryImage`.`order`, `GalleryImage`.`date_created`, `GalleryImage`.`date_modified` FROM `gallery_images` AS `GalleryImage` WHERE `GalleryImage`.`gallery_id` IN (67, 93, 98) ORDER BY `GalleryImage`.`order` ASC	156	156	36

26 queries took 114 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `galleries`

DESCRIBE `sectors`

DESCRIBE `overviews`

DESCRIBE `documents`

DESCRIBE `accounts`

DESCRIBE `gallery_images`

DESCRIBE `users`

DESCRIBE `groups`

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)

DESCRIBE `settings`

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

SELECT `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `sectors` AS `Sector` WHERE `Sector`.`name` = 'Biotech' LIMIT 1

SELECT `Overview`.`id`, `Overview`.`sector_id`, `Overview`.`name`, `Overview`.`description`, `Overview`.`date_created`, `Overview`.`date_modified` FROM `overviews` AS `Overview` WHERE `Overview`.`sector_id` IN (1)

SELECT `Document`.`id`, `Document`.`name`, `Document`.`sector_id`, `Document`.`description`, `Document`.`date_created`, `Document`.`date_modified` FROM `documents` AS `Document` WHERE `Document`.`sector_id` IN (1)

SELECT `Account`.`id`, `Account`.`name`, `Account`.`sector_id`, `Account`.`link`, `Account`.`date_created`, `Account`.`date_modified` FROM `accounts` AS `Account` WHERE `Account`.`sector_id` IN (1)

SELECT `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`sector_id`, `Gallery`.`parent_id`, `Gallery`.`date_created`, `Gallery`.`date_modified` FROM `galleries` AS `Gallery` WHERE `Gallery`.`sector_id` IN (1)

SELECT `Document`.`id`, `Document`.`name`, `Document`.`sector_id`, `Document`.`description`, `Document`.`date_created`, `Document`.`date_modified`, `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `documents` AS `Document` LEFT JOIN `sectors` AS `Sector` ON (`Document`.`sector_id` = `Sector`.`id`) WHERE `Document`.`sector_id` = 1

SELECT `Account`.`id`, `Account`.`name`, `Account`.`sector_id`, `Account`.`link`, `Account`.`date_created`, `Account`.`date_modified`, `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `accounts` AS `Account` LEFT JOIN `sectors` AS `Sector` ON (`Account`.`sector_id` = `Sector`.`id`) WHERE `Account`.`sector_id` = 1

SELECT `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`sector_id`, `Gallery`.`parent_id`, `Gallery`.`date_created`, `Gallery`.`date_modified`, `Sector`.`id`, `Sector`.`name`, `Sector`.`short_name`, `Sector`.`image`, `Sector`.`date_created`, `Sector`.`date_modified` FROM `galleries` AS `Gallery` LEFT JOIN `sectors` AS `Sector` ON (`Gallery`.`sector_id` = `Sector`.`id`) WHERE `Gallery`.`sector_id` = 1 AND `Gallery`.`parent_id` = 0

SELECT `GalleryImage`.`id`, `GalleryImage`.`file_name`, `GalleryImage`.`gallery_id`, `GalleryImage`.`caption`, `GalleryImage`.`order`, `GalleryImage`.`date_created`, `GalleryImage`.`date_modified` FROM `gallery_images` AS `GalleryImage` WHERE `GalleryImage`.`gallery_id` IN (99) ORDER BY `GalleryImage`.`order` ASC

156