Questions And Answers

Most Recent Questions

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

1136 West Evelyn Avenue
Sunnyvale, California 94086-5742

17 queries took 191 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `questions`	7	7	72
2	DESCRIBE `categories`	7	7	67
3	DESCRIBE `users`	25	25	3
4	DESCRIBE `groups`	5	5	2
5	DESCRIBE `accesses`	6	6	2
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`, `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	3
7	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
8	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
9	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	3
10	DESCRIBE `settings`	3	3	1
11	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1	2	2	2
12	SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`date_created`, `Category`.`date_modified`, `Category`.`rght`, `Category`.`lft` FROM `categories` AS `Category` WHERE 1 = 1	1	1	14
13	SELECT COUNT(*) AS `count` FROM `questions` AS `Question` LEFT JOIN `categories` AS `Parent` ON (`Question`.`category_id` = `Parent`.`id`) LEFT JOIN `categories` AS `Category` ON (`Question`.`category_id` = `Category`.`id`) WHERE `Question`.`category_id` = 2 AND `Question`.`active` = 1	1	1	3
14	SELECT `Question`.`id`, `Question`.`category_id`, `Question`.`question`, `Question`.`answer`, `Question`.`question_date`, `Question`.`answer_date`, `Question`.`active`, `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`name`, `Parent`.`date_created`, `Parent`.`date_modified`, `Parent`.`rght`, `Parent`.`lft`, `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`date_created`, `Category`.`date_modified`, `Category`.`rght`, `Category`.`lft` FROM `questions` AS `Question` LEFT JOIN `categories` AS `Parent` ON (`Question`.`category_id` = `Parent`.`id`) LEFT JOIN `categories` AS `Category` ON (`Question`.`category_id` = `Category`.`id`) WHERE `Question`.`active` = 1 ORDER BY `Question`.`answer_date` DESC LIMIT 20	0	0	11
15	SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`date_created`, `Category`.`date_modified`, `Category`.`rght`, `Category`.`lft` FROM `categories` AS `Category` WHERE 1 = 1	1	1	1
16	SELECT `Question`.`id`, `Question`.`category_id`, `Question`.`question`, `Question`.`answer`, `Question`.`question_date`, `Question`.`answer_date`, `Question`.`active` FROM `questions` AS `Question` WHERE `Question`.`category_id` IN (2)	0	0	1
17	SELECT COUNT(*) AS `count` FROM `questions` AS `Question` LEFT JOIN `categories` AS `Parent` ON (`Question`.`category_id` = `Parent`.`id`) LEFT JOIN `categories` AS `Category` ON (`Question`.`category_id` = `Category`.`id`) WHERE `Question`.`category_id` = 2 AND `Question`.`active` = 1	1	1	1

17 queries took 191 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `questions`

DESCRIBE `categories`

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 `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`date_created`, `Category`.`date_modified`, `Category`.`rght`, `Category`.`lft` FROM `categories` AS `Category` WHERE 1 = 1

SELECT COUNT(*) AS `count` FROM `questions` AS `Question` LEFT JOIN `categories` AS `Parent` ON (`Question`.`category_id` = `Parent`.`id`) LEFT JOIN `categories` AS `Category` ON (`Question`.`category_id` = `Category`.`id`) WHERE `Question`.`category_id` = 2 AND `Question`.`active` = 1

SELECT `Question`.`id`, `Question`.`category_id`, `Question`.`question`, `Question`.`answer`, `Question`.`question_date`, `Question`.`answer_date`, `Question`.`active`, `Parent`.`id`, `Parent`.`parent_id`, `Parent`.`name`, `Parent`.`date_created`, `Parent`.`date_modified`, `Parent`.`rght`, `Parent`.`lft`, `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`date_created`, `Category`.`date_modified`, `Category`.`rght`, `Category`.`lft` FROM `questions` AS `Question` LEFT JOIN `categories` AS `Parent` ON (`Question`.`category_id` = `Parent`.`id`) LEFT JOIN `categories` AS `Category` ON (`Question`.`category_id` = `Category`.`id`) WHERE `Question`.`active` = 1 ORDER BY `Question`.`answer_date` DESC LIMIT 20