| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `SocialSecurity`.`id`, `SocialSecurity`.`country_id`, `SocialSecurity`.`name`, `SocialSecurity`.`short_code`, `SocialSecurity`.`use_brackets`, `SocialSecurity`.`employee_percentage`, `SocialSecurity`.`employer_percentage`, `SocialSecurity`.`special_employer_percentage`, `SocialSecurity`.`employer_redundancy_percentage`, `SocialSecurity`.`monthly_limit`, `SocialSecurity`.`fortnightly_limit`, `SocialSecurity`.`weekly_limit`, `SocialSecurity`.`currency_code_id`, `SocialSecurity`.`active`, `Country`.`id`, `Country`.`name`, `CurrencyCode`.`id`, `CurrencyCode`.`country_id`, `CurrencyCode`.`currency`, `CurrencyCode`.`alphabetic_code`, `CurrencyCode`.`numeric_code` FROM `cube_4cs`.`social_security` AS `SocialSecurity` LEFT JOIN `cube_4cs`.`countries` AS `Country` ON (`SocialSecurity`.`country_id` = `Country`.`id`) LEFT JOIN `cube_4cs`.`currency_codes` AS `CurrencyCode` ON (`SocialSecurity`.`currency_code_id` = `CurrencyCode`.`id`) WHERE `SocialSecurity`.`country_id` = 175 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Company`.`monthly_working_hours` FROM `cube_4cs`.`companies` AS `Company` WHERE `Company`.`id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
| SELECT `EducationTaxSetting`.`id`, `EducationTaxSetting`.`country_id`, `EducationTaxSetting`.`name`, `EducationTaxSetting`.`short_code`, `EducationTaxSetting`.`employee_percentage`, `EducationTaxSetting`.`employer_percentage`, `EducationTaxSetting`.`currency_code_id`, `EducationTaxSetting`.`active`, `Country`.`id`, `Country`.`name`, `CurrencyCode`.`id`, `CurrencyCode`.`country_id`, `CurrencyCode`.`currency`, `CurrencyCode`.`alphabetic_code`, `CurrencyCode`.`numeric_code`, `Payee`.`id`, `Payee`.`name`, `PayeeAccount`.`id`, `PayeeAccount`.`account_number` FROM `cube_4cs`.`education_tax_settings` AS `EducationTaxSetting` LEFT JOIN `cube_4cs`.`countries` AS `Country` ON (`EducationTaxSetting`.`country_id` = `Country`.`id`) LEFT JOIN `cube_4cs`.`currency_codes` AS `CurrencyCode` ON (`EducationTaxSetting`.`currency_code_id` = `CurrencyCode`.`id`) LEFT JOIN `cube_4cs`.`payees` AS `Payee` ON (`EducationTaxSetting`.`payee_id` = `Payee`.`id`) LEFT JOIN `cube_4cs`.`payee_accounts` AS `PayeeAccount` ON (`EducationTaxSetting`.`payee_account_id` = `PayeeAccount`.`id`) WHERE `EducationTaxSetting`.`country_id` = 175 LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `NationalHousingTrustSetting`.`id`, `NationalHousingTrustSetting`.`country_id`, `NationalHousingTrustSetting`.`name`, `NationalHousingTrustSetting`.`short_code`, `NationalHousingTrustSetting`.`employee_percentage`, `NationalHousingTrustSetting`.`employer_percentage`, `NationalHousingTrustSetting`.`currency_code_id`, `NationalHousingTrustSetting`.`active`, `Country`.`id`, `Country`.`name`, `CurrencyCode`.`id`, `CurrencyCode`.`country_id`, `CurrencyCode`.`currency`, `CurrencyCode`.`alphabetic_code`, `CurrencyCode`.`numeric_code`, `Payee`.`id`, `Payee`.`name`, `PayeeAccount`.`id`, `PayeeAccount`.`account_number` FROM `cube_4cs`.`national_housing_trust_settings` AS `NationalHousingTrustSetting` LEFT JOIN `cube_4cs`.`countries` AS `Country` ON (`NationalHousingTrustSetting`.`country_id` = `Country`.`id`) LEFT JOIN `cube_4cs`.`currency_codes` AS `CurrencyCode` ON (`NationalHousingTrustSetting`.`currency_code_id` = `CurrencyCode`.`id`) LEFT JOIN `cube_4cs`.`payees` AS `Payee` ON (`NationalHousingTrustSetting`.`payee_id` = `Payee`.`id`) LEFT JOIN `cube_4cs`.`payee_accounts` AS `PayeeAccount` ON (`NationalHousingTrustSetting`.`payee_account_id` = `PayeeAccount`.`id`) WHERE `NationalHousingTrustSetting`.`country_id` = 175 LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `ResilienceRegenerationFundSetting`.`id`, `ResilienceRegenerationFundSetting`.`country_id`, `ResilienceRegenerationFundSetting`.`name`, `ResilienceRegenerationFundSetting`.`short_code`, `ResilienceRegenerationFundSetting`.`employee_percentage`, `ResilienceRegenerationFundSetting`.`employer_percentage`, `ResilienceRegenerationFundSetting`.`currency_code_id`, `ResilienceRegenerationFundSetting`.`active`, `Country`.`id`, `Country`.`name`, `CurrencyCode`.`id`, `CurrencyCode`.`country_id`, `CurrencyCode`.`currency`, `CurrencyCode`.`alphabetic_code`, `CurrencyCode`.`numeric_code`, `Payee`.`id`, `Payee`.`name`, `PayeeAccount`.`id`, `PayeeAccount`.`account_number` FROM `cube_4cs`.`resilience_regeneration_fund_settings` AS `ResilienceRegenerationFundSetting` LEFT JOIN `cube_4cs`.`countries` AS `Country` ON (`ResilienceRegenerationFundSetting`.`country_id` = `Country`.`id`) LEFT JOIN `cube_4cs`.`currency_codes` AS `CurrencyCode` ON (`ResilienceRegenerationFundSetting`.`currency_code_id` = `CurrencyCode`.`id`) LEFT JOIN `cube_4cs`.`payees` AS `Payee` ON (`ResilienceRegenerationFundSetting`.`payee_id` = `Payee`.`id`) LEFT JOIN `cube_4cs`.`payee_accounts` AS `PayeeAccount` ON (`ResilienceRegenerationFundSetting`.`payee_account_id` = `PayeeAccount`.`id`) WHERE `ResilienceRegenerationFundSetting`.`country_id` = 175 LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `HeartContributionSetting`.`id`, `HeartContributionSetting`.`country_id`, `HeartContributionSetting`.`name`, `HeartContributionSetting`.`short_code`, `HeartContributionSetting`.`employee_percentage`, `HeartContributionSetting`.`employer_percentage`, `HeartContributionSetting`.`currency_code_id`, `HeartContributionSetting`.`active`, `Country`.`id`, `Country`.`name`, `CurrencyCode`.`id`, `CurrencyCode`.`country_id`, `CurrencyCode`.`currency`, `CurrencyCode`.`alphabetic_code`, `CurrencyCode`.`numeric_code`, `Payee`.`id`, `Payee`.`name`, `PayeeAccount`.`id`, `PayeeAccount`.`account_number` FROM `cube_4cs`.`heart_contribution_settings` AS `HeartContributionSetting` LEFT JOIN `cube_4cs`.`countries` AS `Country` ON (`HeartContributionSetting`.`country_id` = `Country`.`id`) LEFT JOIN `cube_4cs`.`currency_codes` AS `CurrencyCode` ON (`HeartContributionSetting`.`currency_code_id` = `CurrencyCode`.`id`) LEFT JOIN `cube_4cs`.`payees` AS `Payee` ON (`HeartContributionSetting`.`payee_id` = `Payee`.`id`) LEFT JOIN `cube_4cs`.`payee_accounts` AS `PayeeAccount` ON (`HeartContributionSetting`.`payee_account_id` = `PayeeAccount`.`id`) WHERE `HeartContributionSetting`.`country_id` = 175 LIMIT 1 | 0 | 0 | 0 | |
| SELECT COUNT(DISTINCT EmploymentData.employee_id) AS employee_count FROM `cube_4cs`.`employment_data` AS `EmploymentData` WHERE `EmploymentData`.`active` = '1' AND `EmploymentData`.`is_current` = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Company`.`display_inactive_employees` FROM `cube_4cs`.`companies` AS `Company` WHERE `Company`.`id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Company`.`filter_vacation_by_job_class` FROM `cube_4cs`.`companies` AS `Company` WHERE `Company`.`id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Company`.`filter_vacation_by_bargaining_unit` FROM `cube_4cs`.`companies` AS `Company` WHERE `Company`.`id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SocialSecurity`.`short_code` FROM `cube_4cs`.`social_security` AS `SocialSecurity` WHERE `SocialSecurity`.`country_id` = 175 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `IncomeTax`.`short_code` FROM `cube_4cs`.`income_taxes` AS `IncomeTax` WHERE `IncomeTax`.`country_id` = 175 LIMIT 1 | 1 | 1 | 0 | |