| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `MetaDatum`.`id`, `MetaDatum`.`controller`, `MetaDatum`.`action`, `MetaDatum`.`type`, `MetaDatum`.`heading`, `MetaDatum`.`title`, `MetaDatum`.`description`, `MetaDatum`.`keywords`, `MetaDatum`.`created`, `MetaDatum`.`modified` FROM `clubentr_staging`.`meta_data` AS `MetaDatum` WHERE `controller` = 'Members' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Member`.`id`, `Member`.`logo`, `Member`.`company_name`, `Member`.`brand_name`, `Member`.`legal_structure`, `Member`.`short_description`, `Member`.`presentation`, `Member`.`num_employees`, `Member`.`services`, `Member`.`club_advantages`, `Member`.`date_creation_business`, `Member`.`business_sector_id`, `Member`.`contact_civility`, `Member`.`contact_last_name`, `Member`.`contact_first_name`, `Member`.`contact_position`, `Member`.`contact_dob`, `Member`.`address`, `Member`.`address_2`, `Member`.`post_code`, `Member`.`city`, `Member`.`lat`, `Member`.`lng`, `Member`.`telephone`, `Member`.`mobile`, `Member`.`email`, `Member`.`web_url`, `Member`.`facebook_url`, `Member`.`twitter_url`, `Member`.`gplus_url`, `Member`.`date_joined`, `Member`.`date_renewal`, `Member`.`last_payment_received`, `Member`.`is_active`, `Member`.`created`, `Member`.`modified`, (CASE WHEN `Member`.`brand_name` IS NULL OR `Member`.`brand_name` = '' THEN `Member`.`company_name` ELSE `Member`.`brand_name` END) AS `Member__title`, `BusinessSector`.`id`, `BusinessSector`.`title` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) WHERE `BusinessSector`.`id` = 9 AND `Member`.`is_active` = 'true' ORDER BY `Member__title` ASC LIMIT 10 | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` LEFT JOIN `clubentr_staging`.`business_sectors` AS `BusinessSector` ON (`Member`.`business_sector_id` = `BusinessSector`.`id`) WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 9 | 1 | 1 | 0 | |
| SELECT `BusinessSector`.`id`, `BusinessSector`.`title` FROM `clubentr_staging`.`business_sectors` AS `BusinessSector` WHERE 1 = 1 ORDER BY `title` ASC | 26 | 26 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 18 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 19 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 12 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 14 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 3 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 25 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 26 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 21 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 9 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 27 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 8 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 24 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 15 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 23 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 22 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 10 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 13 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 6 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 5 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 4 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 7 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 16 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 20 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 17 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 2 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `clubentr_staging`.`members` AS `Member` WHERE `Member`.`is_active` = 'true' AND `Member`.`business_sector_id` = 11 | 1 | 1 | 0 | |
