98: Original equipment components
COMESA
No applicable rules
SADC
No applicable rules
EAC
No applicable rules
EU GSP
No applicable rules
No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
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` = '98' 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` = 'de59cc78-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` <= 12794 AND `TariffCode`.`rght` >= 12795 ORDER BY `TariffCode`.`lft` asc | 2 | 2 | 4 | maybe slow |
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 | 6 | |
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` <= 98 AND `Rule`.`hs_end` >= 98 ORDER BY `Treaty`.`id` ASC, `Rule`.`order` ASC | 0 | 0 | 7 | maybe slow |
Peak Memory Use 22.02 MB
Message | Memory use |
---|---|
Component initialization | 3.40 MB |
Controller action start | 3.71 MB |
Controller render start | 7.88 MB |
View render complete | 9.66 MB |
Total Request Time: 268 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 38.14 | |
Event: Controller.initialize | 0.11 | |
Event: Controller.startup | 0.52 | |
Controller action | 124.46 | |
Event: Controller.beforeRender | 48.41 | |
» Processing toolbar data | 48.28 | |
Rendering View | 5.58 | |
» Event: View.beforeRender | 0.05 | |
» Rendering APP/View/Rules/view.ctp | 1.95 | |
» Event: View.afterRender | 0.03 | |
» Event: View.beforeLayout | 0.03 | |
» Rendering APP/View/Layouts/default.ctp | 2.71 | |
» » Rendering APP/View/Elements/nav_links.ctp | 1.09 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
APP | /var/www/sites/rulesoforigin.org/ |
APP_DIR | rulesoforigin.org |
APPLIBS | /var/www/sites/rulesoforigin.org/Lib/ |
CACHE | /var/www/sites/rulesoforigin.org/tmp/cache/ |
CAKE | /var/www/common/frameworks/cakephp/lib/Cake/ |
CAKE_CORE_INCLUDE_PATH | /var/www/common/frameworks/cakephp/lib |
CORE_PATH | /var/www/common/frameworks/cakephp/lib/ |
CAKE_VERSION | 2.4.4 |
CSS | /var/www/sites/rulesoforigin.org/webroot/css/ |
CSS_URL | css/ |
DS | / |
FULL_BASE_URL | https://rulesoforigin.org |
IMAGES | /var/www/sites/rulesoforigin.org/webroot/img/ |
IMAGES_URL | img/ |
JS | /var/www/sites/rulesoforigin.org/webroot/js/ |
JS_URL | js/ |
LOGS | /var/www/sites/rulesoforigin.org/tmp/logs/ |
ROOT | /var/www/sites |
TESTS | /var/www/sites/rulesoforigin.org/Test/ |
TMP | /var/www/sites/rulesoforigin.org/tmp/ |
VENDORS | /var/www/sites/vendors/ |
WEBROOT_DIR | webroot |
WWW_ROOT | /var/www/sites/rulesoforigin.org/webroot/ |
Environment Variable | Value |
---|---|
Php Version | 5.6.40 |
User | nginx |
Home | /var/lib/nginx |
Fcgi Role | RESPONDER |
Path Info | |
Script Filename | /var/www/sites/rulesoforigin.org/webroot/index.php |
Query String | |
Request Method | GET |
Content Type | |
Content Length | |
Script Name | /index.php |
Request Uri | /rules/98 |
Document Uri | /index.php |
Document Root | /var/www/sites/rulesoforigin.org/webroot |
Server Protocol | HTTP/1.1 |
Request Scheme | https |
Https | on |
Gateway Interface | CGI/1.1 |
Server Software | nginx/1.20.1 |
Remote Addr | 18.226.165.234 |
Remote Port | 53609 |
Server Addr | 197.189.200.130 |
Server Port | 443 |
Server Name | rulesoforigin.org |
Redirect Status | 200 |
Http Accept | */* |
Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Http Accept Encoding | gzip, br, zstd, deflate |
Http Host | rulesoforigin.org |
Php Self | /index.php |
Request Time Float | 1735318292.1982 |
Request Time | 1735318292 |