Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `TariffCode`.`id`, `TariffCode`.`heading`, `TariffCode`.`int_heading`, `TariffCode`.`description`, `TariffCode`.`parent_id`, `TariffCode`.`lft`, `TariffCode`.`rght`, (CONCAT(`TariffCode`.`heading`, ': ', `TariffCode`.`description`)) AS `TariffCode__name`, (IF(`TariffCode`.`rght` - `TariffCode`.`lft` = 1, 0, 1)) AS `TariffCode__hasChildren`, `Parent`.`id`, `Parent`.`heading`, `Parent`.`int_heading`, `Parent`.`description`, `Parent`.`parent_id`, `Parent`.`lft`, `Parent`.`rght`, (CONCAT(`TariffCode`.`heading`, ': ', `TariffCode`.`description`)) AS `Parent__name`, (IF(`TariffCode`.`rght` - `TariffCode`.`lft` = 1, 0, 1)) AS `Parent__hasChildren` FROM `tmsa_roo`.`tariff_codes` AS `TariffCode` LEFT JOIN `tmsa_roo`.`tariff_codes` AS `Parent` ON (`TariffCode`.`parent_id` = `Parent`.`id`) WHERE `TariffCode`.`heading` = '847230' ORDER BY `TariffCode`.`lft` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `TariffCode`.`lft`, `TariffCode`.`rght` FROM `tmsa_roo`.`tariff_codes` AS `TariffCode` WHERE `TariffCode`.`id` = 'de74a3de-c58c-11df-9bb7-0be149cb1d31' ORDER BY `TariffCode`.`lft` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `TariffCode`.`id`, `TariffCode`.`heading`, `TariffCode`.`int_heading`, `TariffCode`.`description`, `TariffCode`.`parent_id`, `TariffCode`.`lft`, `TariffCode`.`rght`, (CONCAT(`TariffCode`.`heading`, ': ', `TariffCode`.`description`)) AS `TariffCode__name`, (IF(`TariffCode`.`rght` - `TariffCode`.`lft` = 1, 0, 1)) AS `TariffCode__hasChildren` FROM `tmsa_roo`.`tariff_codes` AS `TariffCode` WHERE 1 = 1 AND `TariffCode`.`lft` <= 10694 AND `TariffCode`.`rght` >= 10695 ORDER BY `TariffCode`.`lft` asc | 4 | 4 | 4 | |
SELECT `Treaty`.`id`, `Treaty`.`name` FROM `tmsa_roo`.`treaties` AS `Treaty` WHERE 1 = 1 ORDER BY `id` ASC | 4 | 4 | 0 | |
SELECT `TariffCode`.`heading`, `TariffCode`.`description` FROM `tmsa_roo`.`tariff_codes` AS `TariffCode` WHERE 1 = 1 ORDER BY `TariffCode`.`lft` ASC | 6398 | 6398 | 4 | |
SELECT `Treaty`.`name`, `Rule`.`id`, `Rule`.`hs_range`, `Rule`.`hs_start`, `Rule`.`hs_end`, `Rule`.`exception`, `Rule`.`main_rule`, `Treaty`.`id` FROM `tmsa_roo`.`rules` AS `Rule` LEFT JOIN `tmsa_roo`.`treaties` AS `Treaty` ON (`Rule`.`treaty_id` = `Treaty`.`id`) WHERE `Rule`.`hs_start` <= 847230 AND `Rule`.`hs_end` >= 847230 ORDER BY `Treaty`.`id` ASC, `Rule`.`order` ASC | 6 | 6 | 3 | maybe slow |
SELECT `AvailableRule`.`id`, `AvailableRule`.`rule_id`, `AvailableRule`.`rule_text_id`, `AvailableRule`.`wholly_produced`, `AvailableRule`.`cif`, `AvailableRule`.`value_added`, `AvailableRule`.`tariff_change`, `AvailableRule`.`exception`, `AvailableRule`.`process`, `AvailableRule`.`ex_works`, `AvailableRule`.`weight`, `AvailableRule`.`no_rule`, `AvailableRule`.`alternative` FROM `tmsa_roo`.`available_rules` AS `AvailableRule` WHERE `AvailableRule`.`rule_id` IN (75, 690, 1118, 1154, 1352, 1320) | 13 | 13 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 1 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 2 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 29 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 267 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 1 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 2 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 416 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 1 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 2 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 486 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 175 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 555 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 239 | 1 | 1 | 0 | |