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` FROM `tmsa_roo`.`tariff_codes` AS `TariffCode` WHERE `TariffCode`.`heading` = '86 - 89' 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 `TariffCode`.`parent_id` = 'de58dbea-c58c-11df-9bb7-0be149cb1d31' ORDER BY `TariffCode`.`lft` ASC | 4 | 4 | 0 | |
SELECT `TariffCode`.`lft`, `TariffCode`.`rght` FROM `tmsa_roo`.`tariff_codes` AS `TariffCode` WHERE `TariffCode`.`id` = 'de58dbea-c58c-11df-9bb7-0be149cb1d31' ORDER BY `TariffCode`.`lft` ASC LIMIT 1 | 1 | 1 | 1 | |
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` <= 11501 AND `TariffCode`.`rght` >= 11848 ORDER BY `TariffCode`.`lft` asc | 1 | 1 | 4 | maybe slow |
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 `TariffCode`.`parent_id` IS NULL ORDER BY `TariffCode`.`lft` ASC | 16 | 16 | 0 | |