Advanced Hedge Fund Directory Search

Close this window

Forgot Password

15 queries took 39 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `hfd_contents`	6	6	6
2	DESCRIBE `hfd_auto_responders`	4	4	5
3	DESCRIBE `hfd_email_templates`	4	4	5
4	DESCRIBE `hfd_my_funds`	4	4	5
5	DESCRIBE `hfd_my_contacts`	5	5	5
6	DESCRIBE `hfd_assets`	3	3	4
7	DESCRIBE `hfd_strategies`	2	2	4
8	DESCRIBE `hfd_redemptions`	10	10	5
9	SELECT `Contact`.`id` FROM `hfd_contacts` AS `Contact` LEFT JOIN `hfd_funds` AS `Fund` ON (`Contact`.`fund_id` = `Fund`.`id`) WHERE `Contact`.`status` = 'P' AND `Contact`.`source` = 'U'	0	0	0
10	SELECT `Fund`.`id` FROM `hfd_funds` AS `Fund` WHERE `Fund`.`status` = 'P' AND `Fund`.`source` = 'U'	2	2	0
11	SELECT `Contact`.`id`, `Contact`.`fund_id`, `Contact`.`fund_name`, `Contact`.`contact_salutation`, `Contact`.`contact_surname`, `Contact`.`contact_forename`, `Contact`.`contact_job_title`, `Contact`.`contact_address`, `Contact`.`contact_country`, `Contact`.`contact_phone`, `Contact`.`contact_fax`, `Contact`.`contact_email`, `Contact`.`contact_region`, `Contact`.`source`, `Contact`.`status`, `Contact`.`created`, `Contact`.`modified` FROM `hfd_contacts` AS `Contact` WHERE `Contact`.`fund_id` IN (1222339, 1222341)	0	0	0
12	SELECT `Inaccuracy`.`id`, `Inaccuracy`.`user_id`, `Inaccuracy`.`fund_id`, `Inaccuracy`.`desc`, `Inaccuracy`.`created` FROM `hfd_inaccuracies` AS `Inaccuracy` WHERE `Inaccuracy`.`fund_id` IN (1222339, 1222341)	0	0	0
13	SELECT `Redemption`.`id` FROM `hfd_redemptions` AS `Redemption` WHERE `Redemption`.`status` = 'P'	0	0	0
14	SELECT `Asset`.`id`, `Asset`.`ind`, `Asset`.`asset` FROM `hfd_assets` AS `Asset` WHERE 1 = 1	10	10	0
15	SELECT `Strategy`.`id`, `Strategy`.`strategy` FROM `hfd_strategies` AS `Strategy` WHERE 1 = 1 ORDER BY `strategy` ASC	34	34	0

15 queries took 39 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `hfd_contents`

DESCRIBE `hfd_auto_responders`

DESCRIBE `hfd_email_templates`

DESCRIBE `hfd_my_funds`

DESCRIBE `hfd_my_contacts`

DESCRIBE `hfd_assets`

DESCRIBE `hfd_strategies`

DESCRIBE `hfd_redemptions`

SELECT `Contact`.`id` FROM `hfd_contacts` AS `Contact` LEFT JOIN `hfd_funds` AS `Fund` ON (`Contact`.`fund_id` = `Fund`.`id`) WHERE `Contact`.`status` = 'P' AND `Contact`.`source` = 'U'

SELECT `Fund`.`id` FROM `hfd_funds` AS `Fund` WHERE `Fund`.`status` = 'P' AND `Fund`.`source` = 'U'

SELECT `Contact`.`id`, `Contact`.`fund_id`, `Contact`.`fund_name`, `Contact`.`contact_salutation`, `Contact`.`contact_surname`, `Contact`.`contact_forename`, `Contact`.`contact_job_title`, `Contact`.`contact_address`, `Contact`.`contact_country`, `Contact`.`contact_phone`, `Contact`.`contact_fax`, `Contact`.`contact_email`, `Contact`.`contact_region`, `Contact`.`source`, `Contact`.`status`, `Contact`.`created`, `Contact`.`modified` FROM `hfd_contacts` AS `Contact` WHERE `Contact`.`fund_id` IN (1222339, 1222341)

SELECT `Inaccuracy`.`id`, `Inaccuracy`.`user_id`, `Inaccuracy`.`fund_id`, `Inaccuracy`.`desc`, `Inaccuracy`.`created` FROM `hfd_inaccuracies` AS `Inaccuracy` WHERE `Inaccuracy`.`fund_id` IN (1222339, 1222341)

SELECT `Redemption`.`id` FROM `hfd_redemptions` AS `Redemption` WHERE `Redemption`.`status` = 'P'

SELECT `Asset`.`id`, `Asset`.`ind`, `Asset`.`asset` FROM `hfd_assets` AS `Asset` WHERE 1 = 1

SELECT `Strategy`.`id`, `Strategy`.`strategy` FROM `hfd_strategies` AS `Strategy` WHERE 1 = 1 ORDER BY `strategy` ASC