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` = '811212' 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` = 'de715b8c-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` <= 9416 AND `TariffCode`.`rght` >= 9417 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 | 5 | |
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` <= 811212 AND `Rule`.`hs_end` >= 811212 ORDER BY `Treaty`.`id` ASC, `Rule`.`order` ASC | 7 | 7 | 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 (97, 680, 1106, 1107, 1108, 1375, 1374) | 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` = 3 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 235 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 467 | 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` = 468 | 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` = 469 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 569 | 1 | 1 | 0 | |
SELECT `RuleText`.`id`, `RuleText`.`text` FROM `tmsa_roo`.`rule_texts` AS `RuleText` WHERE `RuleText`.`id` = 574 | 1 | 1 | 0 | |