a:14:{s:6:"config";s:3477:"a:5:{s:10:"phpVersion";s:6:"8.2.35";s:10:"yiiVersion";s:6:"2.0.47";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.47";s:4:"name";s:14:"My Application";s:7:"version";s:3:"1.0";s:8:"language";s:5:"en-US";s:14:"sourceLanguage";s:5:"en-US";s:7:"charset";s:5:"UTF-8";s:3:"env";s:3:"dev";s:5:"debug";b:1;}s:3:"php";a:5:{s:7:"version";s:6:"8.2.35";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:13:{s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:64:"/home/rootpanelskygain/public_html/vendor/yiisoft/yii2-faker/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.21.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:64:"/home/rootpanelskygain/public_html/vendor/yiisoft/yii2-debug/src";}}s:26:"yiisoft/yii2-symfonymailer";a:3:{s:4:"name";s:26:"yiisoft/yii2-symfonymailer";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:18:"@yii/symfonymailer";s:72:"/home/rootpanelskygain/public_html/vendor/yiisoft/yii2-symfonymailer/src";}}s:23:"yiisoft/yii2-bootstrap5";a:4:{s:4:"name";s:23:"yiisoft/yii2-bootstrap5";s:7:"version";s:7:"2.0.3.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap5";s:69:"/home/rootpanelskygain/public_html/vendor/yiisoft/yii2-bootstrap5/src";}s:9:"bootstrap";s:40:"yii\bootstrap5\i18n\TranslationBootstrap";}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.2.5.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:62:"/home/rootpanelskygain/public_html/vendor/yiisoft/yii2-gii/src";}}s:25:"kartik-v/yii2-krajee-base";a:3:{s:4:"name";s:25:"kartik-v/yii2-krajee-base";s:7:"version";s:7:"3.0.5.0";s:5:"alias";a:1:{s:12:"@kartik/base";s:71:"/home/rootpanelskygain/public_html/vendor/kartik-v/yii2-krajee-base/src";}}s:28:"kartik-v/yii2-widget-select2";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-select2";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:15:"@kartik/select2";s:74:"/home/rootpanelskygain/public_html/vendor/kartik-v/yii2-widget-select2/src";}}s:31:"kartik-v/yii2-widget-datepicker";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-datepicker";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:12:"@kartik/date";s:77:"/home/rootpanelskygain/public_html/vendor/kartik-v/yii2-widget-datepicker/src";}}s:24:"rmrevin/yii2-fontawesome";a:3:{s:4:"name";s:24:"rmrevin/yii2-fontawesome";s:7:"version";s:7:"3.7.0.0";s:5:"alias";a:1:{s:24:"@rmrevin/yii/fontawesome";s:66:"/home/rootpanelskygain/public_html/vendor/rmrevin/yii2-fontawesome";}}s:25:"froala/yii2-froala-editor";a:3:{s:4:"name";s:25:"froala/yii2-froala-editor";s:7:"version";s:8:"4.0.16.0";s:5:"alias";a:1:{s:20:"@froala/froalaeditor";s:71:"/home/rootpanelskygain/public_html/vendor/froala/yii2-froala-editor/src";}}s:24:"kartik-v/yii2-date-range";a:3:{s:4:"name";s:24:"kartik-v/yii2-date-range";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:17:"@kartik/daterange";s:70:"/home/rootpanelskygain/public_html/vendor/kartik-v/yii2-date-range/src";}}s:35:"kartik-v/yii2-widget-datetimepicker";a:3:{s:4:"name";s:35:"kartik-v/yii2-widget-datetimepicker";s:7:"version";s:7:"1.5.1.0";s:5:"alias";a:1:{s:16:"@kartik/datetime";s:81:"/home/rootpanelskygain/public_html/vendor/kartik-v/yii2-widget-datetimepicker/src";}}s:20:"yii2tech/spreadsheet";a:3:{s:4:"name";s:20:"yii2tech/spreadsheet";s:7:"version";s:7:"1.0.5.0";s:5:"alias";a:1:{s:21:"@yii2tech/spreadsheet";s:66:"/home/rootpanelskygain/public_html/vendor/yii2tech/spreadsheet/src";}}}}";s:3:"log";s:10848:"a:1:{s:8:"messages";a:23:{i:0;a:6:{i:0;s:68:"Bootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1793001393.0557920932769775390625;i:4;a:0:{}i:5;i:2559488;}i:1;a:6:{i:0;s:33:"Bootstrap with yii\log\Dispatcher";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1793001393.0564620494842529296875;i:4;a:0:{}i:5;i:2670600;}i:2;a:6:{i:0;s:21:"Loading module: debug";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1793001393.05646991729736328125;i:4;a:0:{}i:5;i:2671240;}i:3;a:6:{i:0;s:44:"Bootstrap with yii\debug\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1793001393.0622060298919677734375;i:4;a:0:{}i:5;i:3872488;}i:4;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1793001393.0642659664154052734375;i:4;a:0:{}i:5;i:4178224;}i:5;a:6:{i:0;s:42:"Bootstrap with yii\gii\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1793001393.064423084259033203125;i:4;a:0:{}i:5;i:4202640;}i:12;a:6:{i:0;s:48:"Route requested: 'tracking-api/velocity-webhook'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1793001393.065888881683349609375;i:4;a:0:{}i:5;i:4489384;}i:13;a:6:{i:0;s:43:"Route to run: tracking-api/velocity-webhook";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1793001393.07201099395751953125;i:4;a:0:{}i:5;i:5373840;}i:14;a:6:{i:0;s:82:"Running action: backend\controllers\TrackingApiController::actionVelocityWebhook()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1793001393.0720770359039306640625;i:4;a:0:{}i:5;i:5380304;}i:15;a:6:{i:0;s:57:"SHOW FULL COLUMNS FROM `it_easy_order_dispatch_2025_2026`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.0787041187286376953125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6638312;}i:16;a:6:{i:0;s:79:"Opening DB connection: mysql:host=localhost;dbname=crmnutriherbs_new_yii2_panel";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1793001393.078731060028076171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6640448;}i:21;a:6:{i:0;s:820:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_order_dispatch_2025_2026' AND `kcu`.`TABLE_NAME` = 'it_easy_order_dispatch_2025_2026'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.08168888092041015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6737648;}i:24;a:6:{i:0;s:92:"SELECT * FROM `it_easy_order_dispatch_2025_2026` WHERE `it_easy_awb_number`='41332238317951'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.0841529369354248046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7075248;}i:27;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `it_easy_order_2023_2024`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.5411860942840576171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7811624;}i:30;a:6:{i:0;s:802:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_order_2023_2024' AND `kcu`.`TABLE_NAME` = 'it_easy_order_2023_2024'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.5436251163482666015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7873328;}i:33;a:6:{i:0;s:71:"SELECT * FROM `it_easy_order_2023_2024` WHERE `it_easy_order_id`=642547";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.544528961181640625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7890456;}i:36;a:6:{i:0;s:93:"SELECT * FROM `it_easy_query_tracking` WHERE `awb_number`='41332238317951' ORDER BY `id` DESC";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.545053005218505859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7924280;}i:39;a:6:{i:0;s:47:"SHOW FULL COLUMNS FROM `it_easy_query_tracking`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793001401.9029490947723388671875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7931520;}i:42;a:6:{i:0;s:800:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_query_tracking' AND `kcu`.`TABLE_NAME` = 'it_easy_query_tracking'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793001401.9042971134185791015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7943112;}i:45;a:6:{i:0;s:144:"UPDATE `it_easy_order_2023_2024` SET `it_easy_order_status_id`=3, `it_easy_delivered_time`='2026-10-26 13:26:33' WHERE `it_easy_order_id`=642547";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.905787944793701171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3950;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7959176;}i:48;a:6:{i:0;s:204:"UPDATE `it_easy_order_dispatch_2025_2026` SET `it_easy_order_status`='DELIVERED', `it_easy_status_updated_at`='2026-10-26 13:26:33', `it_easy_delivery_date`='2026-10-26 13:26:33' WHERE `it_easy_id`=209986";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.9074909687042236328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3962;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7965528;}i:51;a:6:{i:0;s:1221:"INSERT INTO `it_easy_query_tracking` (`courier_name`, `order_id`, `awb_number`, `remark`, `status_code`, `status_description_bucket`, `status_description`, `location`, `timestamp`, `query`, `status_time`) VALUES ('Delhivery Standard', 642547, '41332238317951', 'premises_closed_or_inaccesible', 'delivered', 'delivered', 'delivered', '', '2026-10-26 13:26:33', '{\"data\":{\"carrier_name\":\"Delhivery Standard\",\"delivered_at\":\"2026-10-26T13:24:54+05:30\",\"estimated_delivery_date\":\"2026-10-27T23:59:59+05:30\",\"event_timestamp\":\"2026-10-26T13:24:54+05:30\",\"ndr_reason\":\"premises_closed_or_inaccesible\",\"order_display_id\":\"NH642547\",\"order_external_id\":\"NH642547\",\"order_id\":\"ORD5ZUUVFKLXV\",\"original_edd\":\"2026-10-27T23:59:59+05:30\",\"shipment_id\":\"SHII4EIQHKV1U\",\"shipment_type\":\"forward\",\"shipment_uuid\":\"c3c0f0c0-2a8f-4fc0-bb25-fd4ac28e3f68\",\"status\":\"delivered\",\"sub_status\":\"delivered\",\"tracking_number\":\"41332238317951\",\"tracking_url\":\"https:\\/\\/www.velocityshipping.in\\/track\\/41332238317951\"},\"event\":\"status_change\",\"event_id\":\"ca570170-4761-445c-9bff-f42a213e8b83\",\"webhook_sent_at\":\"2026-10-26T13:26:32+05:30\"}', '2026-10-26 13:26:41')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.908596038818359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3968;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7972296;}i:54;a:6:{i:0;s:102:"Access to debugger is denied due to IP address restriction. The requesting IP address is 3.110.114.135";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1793001401.911345005035400390625;i:4;a:0:{}i:5;i:8219472;}}}";s:9:"profiling";s:18028:"a:3:{s:6:"memory";i:8918960;s:4:"time";d:8.8633899688720703125;s:8:"messages";a:26:{i:17;a:6:{i:0;s:79:"Opening DB connection: mysql:host=localhost;dbname=crmnutriherbs_new_yii2_panel";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1793001393.0787379741668701171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6641576;}i:18;a:6:{i:0;s:79:"Opening DB connection: mysql:host=localhost;dbname=crmnutriherbs_new_yii2_panel";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1793001393.079235076904296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6684872;}i:19;a:6:{i:0;s:57:"SHOW FULL COLUMNS FROM `it_easy_order_dispatch_2025_2026`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.079247951507568359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6684656;}i:20;a:6:{i:0;s:57:"SHOW FULL COLUMNS FROM `it_easy_order_dispatch_2025_2026`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.0811860561370849609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6739464;}i:22;a:6:{i:0;s:820:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_order_dispatch_2025_2026' AND `kcu`.`TABLE_NAME` = 'it_easy_order_dispatch_2025_2026'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.0817050933837890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6738688;}i:23;a:6:{i:0;s:820:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_order_dispatch_2025_2026' AND `kcu`.`TABLE_NAME` = 'it_easy_order_dispatch_2025_2026'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.0825169086456298828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6740544;}i:25;a:6:{i:0;s:92:"SELECT * FROM `it_easy_order_dispatch_2025_2026` WHERE `it_easy_awb_number`='41332238317951'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.0841639041900634765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7076376;}i:26;a:6:{i:0;s:92:"SELECT * FROM `it_easy_order_dispatch_2025_2026` WHERE `it_easy_awb_number`='41332238317951'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.5370919704437255859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7084208;}i:28;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `it_easy_order_2023_2024`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.541203022003173828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7812536;}i:29;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `it_easy_order_2023_2024`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.5431969165802001953125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7923616;}i:31;a:6:{i:0;s:802:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_order_2023_2024' AND `kcu`.`TABLE_NAME` = 'it_easy_order_2023_2024'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.5436379909515380859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7874368;}i:32;a:6:{i:0;s:802:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_order_2023_2024' AND `kcu`.`TABLE_NAME` = 'it_easy_order_2023_2024'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.5442860126495361328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7876224;}i:34;a:6:{i:0;s:71:"SELECT * FROM `it_easy_order_2023_2024` WHERE `it_easy_order_id`=642547";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.544538974761962890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7891584;}i:35;a:6:{i:0;s:71:"SELECT * FROM `it_easy_order_2023_2024` WHERE `it_easy_order_id`=642547";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.544846057891845703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7910584;}i:37;a:6:{i:0;s:93:"SELECT * FROM `it_easy_query_tracking` WHERE `awb_number`='41332238317951' ORDER BY `id` DESC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.54506206512451171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7925408;}i:38;a:6:{i:0;s:93:"SELECT * FROM `it_easy_query_tracking` WHERE `awb_number`='41332238317951' ORDER BY `id` DESC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001401.9028339385986328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7928616;}i:40;a:6:{i:0;s:47:"SHOW FULL COLUMNS FROM `it_easy_query_tracking`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001401.902966976165771484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7932432;}i:41;a:6:{i:0;s:47:"SHOW FULL COLUMNS FROM `it_easy_query_tracking`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001401.9041779041290283203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7948016;}i:43;a:6:{i:0;s:800:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_query_tracking' AND `kcu`.`TABLE_NAME` = 'it_easy_query_tracking'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001401.9043090343475341796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7944152;}i:44;a:6:{i:0;s:800:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_query_tracking' AND `kcu`.`TABLE_NAME` = 'it_easy_query_tracking'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001401.9049279689788818359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7946008;}i:46;a:6:{i:0;s:144:"UPDATE `it_easy_order_2023_2024` SET `it_easy_order_status_id`=3, `it_easy_delivered_time`='2026-10-26 13:26:33' WHERE `it_easy_order_id`=642547";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.9058001041412353515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3950;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7960096;}i:47;a:6:{i:0;s:144:"UPDATE `it_easy_order_2023_2024` SET `it_easy_order_status_id`=3, `it_easy_delivered_time`='2026-10-26 13:26:33' WHERE `it_easy_order_id`=642547";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.9072539806365966796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3950;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7961152;}i:49;a:6:{i:0;s:204:"UPDATE `it_easy_order_dispatch_2025_2026` SET `it_easy_order_status`='DELIVERED', `it_easy_status_updated_at`='2026-10-26 13:26:33', `it_easy_delivery_date`='2026-10-26 13:26:33' WHERE `it_easy_id`=209986";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.9075019359588623046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3962;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7966344;}i:50;a:6:{i:0;s:204:"UPDATE `it_easy_order_dispatch_2025_2026` SET `it_easy_order_status`='DELIVERED', `it_easy_status_updated_at`='2026-10-26 13:26:33', `it_easy_delivery_date`='2026-10-26 13:26:33' WHERE `it_easy_id`=209986";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.908483028411865234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3962;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7967416;}i:52;a:6:{i:0;s:1221:"INSERT INTO `it_easy_query_tracking` (`courier_name`, `order_id`, `awb_number`, `remark`, `status_code`, `status_description_bucket`, `status_description`, `location`, `timestamp`, `query`, `status_time`) VALUES ('Delhivery Standard', 642547, '41332238317951', 'premises_closed_or_inaccesible', 'delivered', 'delivered', 'delivered', '', '2026-10-26 13:26:33', '{\"data\":{\"carrier_name\":\"Delhivery Standard\",\"delivered_at\":\"2026-10-26T13:24:54+05:30\",\"estimated_delivery_date\":\"2026-10-27T23:59:59+05:30\",\"event_timestamp\":\"2026-10-26T13:24:54+05:30\",\"ndr_reason\":\"premises_closed_or_inaccesible\",\"order_display_id\":\"NH642547\",\"order_external_id\":\"NH642547\",\"order_id\":\"ORD5ZUUVFKLXV\",\"original_edd\":\"2026-10-27T23:59:59+05:30\",\"shipment_id\":\"SHII4EIQHKV1U\",\"shipment_type\":\"forward\",\"shipment_uuid\":\"c3c0f0c0-2a8f-4fc0-bb25-fd4ac28e3f68\",\"status\":\"delivered\",\"sub_status\":\"delivered\",\"tracking_number\":\"41332238317951\",\"tracking_url\":\"https:\\/\\/www.velocityshipping.in\\/track\\/41332238317951\"},\"event\":\"status_change\",\"event_id\":\"ca570170-4761-445c-9bff-f42a213e8b83\",\"webhook_sent_at\":\"2026-10-26T13:26:32+05:30\"}', '2026-10-26 13:26:41')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.908606052398681640625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3968;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7972064;}i:53;a:6:{i:0;s:1221:"INSERT INTO `it_easy_query_tracking` (`courier_name`, `order_id`, `awb_number`, `remark`, `status_code`, `status_description_bucket`, `status_description`, `location`, `timestamp`, `query`, `status_time`) VALUES ('Delhivery Standard', 642547, '41332238317951', 'premises_closed_or_inaccesible', 'delivered', 'delivered', 'delivered', '', '2026-10-26 13:26:33', '{\"data\":{\"carrier_name\":\"Delhivery Standard\",\"delivered_at\":\"2026-10-26T13:24:54+05:30\",\"estimated_delivery_date\":\"2026-10-27T23:59:59+05:30\",\"event_timestamp\":\"2026-10-26T13:24:54+05:30\",\"ndr_reason\":\"premises_closed_or_inaccesible\",\"order_display_id\":\"NH642547\",\"order_external_id\":\"NH642547\",\"order_id\":\"ORD5ZUUVFKLXV\",\"original_edd\":\"2026-10-27T23:59:59+05:30\",\"shipment_id\":\"SHII4EIQHKV1U\",\"shipment_type\":\"forward\",\"shipment_uuid\":\"c3c0f0c0-2a8f-4fc0-bb25-fd4ac28e3f68\",\"status\":\"delivered\",\"sub_status\":\"delivered\",\"tracking_number\":\"41332238317951\",\"tracking_url\":\"https:\\/\\/www.velocityshipping.in\\/track\\/41332238317951\"},\"event\":\"status_change\",\"event_id\":\"ca570170-4761-445c-9bff-f42a213e8b83\",\"webhook_sent_at\":\"2026-10-26T13:26:32+05:30\"}', '2026-10-26 13:26:41')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.909368038177490234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3968;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7974368;}}}";s:2:"db";s:17116:"a:1:{s:8:"messages";a:24:{i:19;a:6:{i:0;s:57:"SHOW FULL COLUMNS FROM `it_easy_order_dispatch_2025_2026`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.079247951507568359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6684656;}i:20;a:6:{i:0;s:57:"SHOW FULL COLUMNS FROM `it_easy_order_dispatch_2025_2026`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.0811860561370849609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6739464;}i:22;a:6:{i:0;s:820:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_order_dispatch_2025_2026' AND `kcu`.`TABLE_NAME` = 'it_easy_order_dispatch_2025_2026'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.0817050933837890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6738688;}i:23;a:6:{i:0;s:820:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_order_dispatch_2025_2026' AND `kcu`.`TABLE_NAME` = 'it_easy_order_dispatch_2025_2026'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.0825169086456298828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:6740544;}i:25;a:6:{i:0;s:92:"SELECT * FROM `it_easy_order_dispatch_2025_2026` WHERE `it_easy_awb_number`='41332238317951'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.0841639041900634765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7076376;}i:26;a:6:{i:0;s:92:"SELECT * FROM `it_easy_order_dispatch_2025_2026` WHERE `it_easy_awb_number`='41332238317951'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.5370919704437255859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3803;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7084208;}i:28;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `it_easy_order_2023_2024`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.541203022003173828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7812536;}i:29;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `it_easy_order_2023_2024`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.5431969165802001953125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7923616;}i:31;a:6:{i:0;s:802:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_order_2023_2024' AND `kcu`.`TABLE_NAME` = 'it_easy_order_2023_2024'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.5436379909515380859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7874368;}i:32;a:6:{i:0;s:802:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_order_2023_2024' AND `kcu`.`TABLE_NAME` = 'it_easy_order_2023_2024'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.5442860126495361328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7876224;}i:34;a:6:{i:0;s:71:"SELECT * FROM `it_easy_order_2023_2024` WHERE `it_easy_order_id`=642547";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.544538974761962890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7891584;}i:35;a:6:{i:0;s:71:"SELECT * FROM `it_easy_order_2023_2024` WHERE `it_easy_order_id`=642547";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.544846057891845703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3821;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:7910584;}i:37;a:6:{i:0;s:93:"SELECT * FROM `it_easy_query_tracking` WHERE `awb_number`='41332238317951' ORDER BY `id` DESC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001393.54506206512451171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7925408;}i:38;a:6:{i:0;s:93:"SELECT * FROM `it_easy_query_tracking` WHERE `awb_number`='41332238317951' ORDER BY `id` DESC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001401.9028339385986328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7928616;}i:40;a:6:{i:0;s:47:"SHOW FULL COLUMNS FROM `it_easy_query_tracking`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001401.902966976165771484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7932432;}i:41;a:6:{i:0;s:47:"SHOW FULL COLUMNS FROM `it_easy_query_tracking`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001401.9041779041290283203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7948016;}i:43;a:6:{i:0;s:800:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_query_tracking' AND `kcu`.`TABLE_NAME` = 'it_easy_query_tracking'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793001401.9043090343475341796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7944152;}i:44;a:6:{i:0;s:800:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'it_easy_query_tracking' AND `kcu`.`TABLE_NAME` = 'it_easy_query_tracking'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793001401.9049279689788818359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3843;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7946008;}i:46;a:6:{i:0;s:144:"UPDATE `it_easy_order_2023_2024` SET `it_easy_order_status_id`=3, `it_easy_delivered_time`='2026-10-26 13:26:33' WHERE `it_easy_order_id`=642547";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.9058001041412353515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3950;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7960096;}i:47;a:6:{i:0;s:144:"UPDATE `it_easy_order_2023_2024` SET `it_easy_order_status_id`=3, `it_easy_delivered_time`='2026-10-26 13:26:33' WHERE `it_easy_order_id`=642547";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.9072539806365966796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3950;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7961152;}i:49;a:6:{i:0;s:204:"UPDATE `it_easy_order_dispatch_2025_2026` SET `it_easy_order_status`='DELIVERED', `it_easy_status_updated_at`='2026-10-26 13:26:33', `it_easy_delivery_date`='2026-10-26 13:26:33' WHERE `it_easy_id`=209986";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.9075019359588623046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3962;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7966344;}i:50;a:6:{i:0;s:204:"UPDATE `it_easy_order_dispatch_2025_2026` SET `it_easy_order_status`='DELIVERED', `it_easy_status_updated_at`='2026-10-26 13:26:33', `it_easy_delivery_date`='2026-10-26 13:26:33' WHERE `it_easy_id`=209986";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.908483028411865234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3962;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7967416;}i:52;a:6:{i:0;s:1221:"INSERT INTO `it_easy_query_tracking` (`courier_name`, `order_id`, `awb_number`, `remark`, `status_code`, `status_description_bucket`, `status_description`, `location`, `timestamp`, `query`, `status_time`) VALUES ('Delhivery Standard', 642547, '41332238317951', 'premises_closed_or_inaccesible', 'delivered', 'delivered', 'delivered', '', '2026-10-26 13:26:33', '{\"data\":{\"carrier_name\":\"Delhivery Standard\",\"delivered_at\":\"2026-10-26T13:24:54+05:30\",\"estimated_delivery_date\":\"2026-10-27T23:59:59+05:30\",\"event_timestamp\":\"2026-10-26T13:24:54+05:30\",\"ndr_reason\":\"premises_closed_or_inaccesible\",\"order_display_id\":\"NH642547\",\"order_external_id\":\"NH642547\",\"order_id\":\"ORD5ZUUVFKLXV\",\"original_edd\":\"2026-10-27T23:59:59+05:30\",\"shipment_id\":\"SHII4EIQHKV1U\",\"shipment_type\":\"forward\",\"shipment_uuid\":\"c3c0f0c0-2a8f-4fc0-bb25-fd4ac28e3f68\",\"status\":\"delivered\",\"sub_status\":\"delivered\",\"tracking_number\":\"41332238317951\",\"tracking_url\":\"https:\\/\\/www.velocityshipping.in\\/track\\/41332238317951\"},\"event\":\"status_change\",\"event_id\":\"ca570170-4761-445c-9bff-f42a213e8b83\",\"webhook_sent_at\":\"2026-10-26T13:26:32+05:30\"}', '2026-10-26 13:26:41')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.908606052398681640625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3968;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7972064;}i:53;a:6:{i:0;s:1221:"INSERT INTO `it_easy_query_tracking` (`courier_name`, `order_id`, `awb_number`, `remark`, `status_code`, `status_description_bucket`, `status_description`, `location`, `timestamp`, `query`, `status_time`) VALUES ('Delhivery Standard', 642547, '41332238317951', 'premises_closed_or_inaccesible', 'delivered', 'delivered', 'delivered', '', '2026-10-26 13:26:33', '{\"data\":{\"carrier_name\":\"Delhivery Standard\",\"delivered_at\":\"2026-10-26T13:24:54+05:30\",\"estimated_delivery_date\":\"2026-10-27T23:59:59+05:30\",\"event_timestamp\":\"2026-10-26T13:24:54+05:30\",\"ndr_reason\":\"premises_closed_or_inaccesible\",\"order_display_id\":\"NH642547\",\"order_external_id\":\"NH642547\",\"order_id\":\"ORD5ZUUVFKLXV\",\"original_edd\":\"2026-10-27T23:59:59+05:30\",\"shipment_id\":\"SHII4EIQHKV1U\",\"shipment_type\":\"forward\",\"shipment_uuid\":\"c3c0f0c0-2a8f-4fc0-bb25-fd4ac28e3f68\",\"status\":\"delivered\",\"sub_status\":\"delivered\",\"tracking_number\":\"41332238317951\",\"tracking_url\":\"https:\\/\\/www.velocityshipping.in\\/track\\/41332238317951\"},\"event\":\"status_change\",\"event_id\":\"ca570170-4761-445c-9bff-f42a213e8b83\",\"webhook_sent_at\":\"2026-10-26T13:26:32+05:30\"}', '2026-10-26 13:26:41')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1793001401.909368038177490234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/rootpanelskygain/public_html/backend/controllers/TrackingApiController.php";s:4:"line";i:3968;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7974368;}}}";s:5:"event";s:5129:"a:26:{i:0;a:5:{s:4:"time";d:1793001393.0655210018157958984375;s:4:"name";s:13:"beforeRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:1;a:5:{s:4:"time";d:1793001393.0720579624176025390625;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:2;a:5:{s:4:"time";d:1793001393.0720670223236083984375;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:41:"backend\controllers\TrackingApiController";}i:3;a:5:{s:4:"time";d:1793001393.07660007476806640625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:4;a:5:{s:4:"time";d:1793001393.0792310237884521484375;s:4:"name";s:9:"afterOpen";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\db\Connection";}i:5;a:5:{s:4:"time";d:1793001393.537147998809814453125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"backend\models\ItEasyOrderDispatch";}i:6;a:5:{s:4:"time";d:1793001393.5372130870819091796875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"backend\models\ItEasyOrderDispatch";}i:7;a:5:{s:4:"time";d:1793001393.541120052337646484375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:8;a:5:{s:4:"time";d:1793001393.5448620319366455078125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"backend\models\ItEasyOrder";}i:9;a:5:{s:4:"time";d:1793001393.544929027557373046875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"backend\models\ItEasyOrder";}i:10;a:5:{s:4:"time";d:1793001393.5450038909912109375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:11;a:5:{s:4:"time";d:1793001401.9028909206390380859375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"backend\models\ItEasyQueryTracking";}i:12;a:5:{s:4:"time";d:1793001401.9049599170684814453125;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"backend\models\ItEasyQueryTracking";}i:13;a:5:{s:4:"time";d:1793001401.9049708843231201171875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"backend\models\ItEasyQueryTracking";}i:14;a:5:{s:4:"time";d:1793001401.905314922332763671875;s:4:"name";s:12:"beforeUpdate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"backend\models\ItEasyOrder";}i:15;a:5:{s:4:"time";d:1793001401.9073259830474853515625;s:4:"name";s:11:"afterUpdate";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"backend\models\ItEasyOrder";}i:16;a:5:{s:4:"time";d:1793001401.90734004974365234375;s:4:"name";s:12:"beforeUpdate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"backend\models\ItEasyOrderDispatch";}i:17;a:5:{s:4:"time";d:1793001401.908504962921142578125;s:4:"name";s:11:"afterUpdate";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"backend\models\ItEasyOrderDispatch";}i:18;a:5:{s:4:"time";d:1793001401.90851593017578125;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"backend\models\ItEasyQueryTracking";}i:19;a:5:{s:4:"time";d:1793001401.9094130992889404296875;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:34:"backend\models\ItEasyQueryTracking";}i:20;a:5:{s:4:"time";d:1793001401.9094409942626953125;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:41:"backend\controllers\TrackingApiController";}i:21;a:5:{s:4:"time";d:1793001401.9094469547271728515625;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:22;a:5:{s:4:"time";d:1793001401.9094541072845458984375;s:4:"name";s:12:"afterRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:23;a:5:{s:4:"time";d:1793001401.90945911407470703125;s:4:"name";s:10:"beforeSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:24;a:5:{s:4:"time";d:1793001401.91135501861572265625;s:4:"name";s:12:"afterPrepare";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:25;a:5:{s:4:"time";d:1793001401.9114029407501220703125;s:4:"name";s:9:"afterSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:122:"a:3:{s:5:"start";d:1793001393.049768924713134765625;s:3:"end";d:1793001401.9132349491119384765625;s:6:"memory";i:8918960;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:1387:"a:3:{s:8:"messages";a:6:{i:6;a:6:{i:0;a:3:{s:4:"rule";s:3:"gii";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1793001393.0657970905303955078125;i:4;a:0:{}i:5;i:4487040;}i:7;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/<id:\w+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1793001393.0658299922943115234375;i:4;a:0:{}i:5;i:4487632;}i:8;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1793001393.06585407257080078125;i:4;a:0:{}i:5;i:4488224;}i:9;a:6:{i:0;a:3:{s:4:"rule";s:5:"debug";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1793001393.0658628940582275390625;i:4;a:0:{}i:5;i:4488976;}i:10;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1793001393.0658829212188720703125;i:4;a:0:{}i:5;i:4489568;}i:11;a:6:{i:0;s:55:"No matching URL rules. Using default URL parsing logic.";i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1793001393.065885066986083984375;i:4;a:0:{}i:5;i:4489784;}}s:5:"route";s:29:"tracking-api/velocity-webhook";s:6:"action";s:66:"backend\controllers\TrackingApiController::actionVelocityWebhook()";}";s:7:"request";s:6261:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:16:{s:10:"connection";s:10:"Keep-Alive";s:7:"baggage";s:199:"sentry-environment=prod,sentry-public_key=05575def535d134e931a1f33298d2646,sentry-trace_id=36651d694bb34009a7dc087e54ebb6e9,sentry-transaction=webhook-events-prod-dispatchWebhook,sentry-sampled=false";s:12:"sentry-trace";s:51:"36651d694bb34009a7dc087e54ebb6e9-b086d87f98941c25-0";s:9:"x-api-key";s:42:"VEL-CRM-9f73a21c-45b6-4b90-8d4c-9aa27e2025";s:6:"cf-ray";s:20:"a507e7b25dd1aed9-BOM";s:13:"x-shipment-id";s:13:"SHII4EIQHKV1U";s:14:"content-length";s:3:"748";s:6:"accept";s:33:"application/json, text/plain, */*";s:12:"content-type";s:16:"application/json";s:10:"user-agent";s:21:"Shipfast-Webhooks/1.0";s:15:"x-webhook-event";s:13:"status_change";s:12:"x-webhook-id";s:36:"d99f2350-2ba0-48ac-87c4-ad63d336c0b0";s:8:"cdn-loop";s:19:"cloudflare; loops=1";s:12:"cf-ipcountry";s:2:"IN";s:10:"cf-visitor";s:18:"{"scheme":"https"}";s:4:"host";s:30:"rootpanel.skygainnutricare.com";}s:15:"responseHeaders";a:2:{s:27:"Access-Control-Allow-Origin";s:1:"*";s:12:"Content-Type";s:31:"application/json; charset=UTF-8";}s:5:"route";s:29:"tracking-api/velocity-webhook";s:6:"action";s:66:"backend\controllers\TrackingApiController::actionVelocityWebhook()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:4:"POST";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:1;}s:11:"requestBody";a:3:{s:12:"Content Type";s:16:"application/json";s:3:"Raw";s:748:"{"data":{"carrier_name":"Delhivery Standard","delivered_at":"2026-10-26T13:24:54+05:30","estimated_delivery_date":"2026-10-27T23:59:59+05:30","event_timestamp":"2026-10-26T13:24:54+05:30","ndr_reason":"premises_closed_or_inaccesible","order_display_id":"NH642547","order_external_id":"NH642547","order_id":"ORD5ZUUVFKLXV","original_edd":"2026-10-27T23:59:59+05:30","shipment_id":"SHII4EIQHKV1U","shipment_type":"forward","shipment_uuid":"c3c0f0c0-2a8f-4fc0-bb25-fd4ac28e3f68","status":"delivered","sub_status":"delivered","tracking_number":"41332238317951","tracking_url":"https://www.velocityshipping.in/track/41332238317951"},"event":"status_change","event_id":"ca570170-4761-445c-9bff-f42a213e8b83","webhook_sent_at":"2026-10-26T13:26:32+05:30"}";s:17:"Decoded to Params";a:0:{}}s:6:"SERVER";a:66:{s:2:"TZ";s:12:"Asia/Kolkata";s:27:"REDIRECT_REDIRECT_UNIQUE_ID";s:27:"at8Hsbcb1GuCgMt3crcEWAAAAIA";s:28:"REDIRECT_REDIRECT_SCRIPT_URL";s:42:"/backend/web/tracking-api/velocity-webhook";s:28:"REDIRECT_REDIRECT_SCRIPT_URI";s:79:"http://rootpanel.skygainnutricare.com/backend/web/tracking-api/velocity-webhook";s:36:"REDIRECT_REDIRECT_HTTP_AUTHORIZATION";s:0:"";s:27:"REDIRECT_REDIRECT_x_api_key";s:42:"VEL-CRM-9f73a21c-45b6-4b90-8d4c-9aa27e2025";s:24:"REDIRECT_REDIRECT_STATUS";s:3:"200";s:18:"REDIRECT_UNIQUE_ID";s:27:"at8Hsbcb1GuCgMt3crcEWAAAAIA";s:19:"REDIRECT_SCRIPT_URL";s:42:"/backend/web/tracking-api/velocity-webhook";s:19:"REDIRECT_SCRIPT_URI";s:79:"http://rootpanel.skygainnutricare.com/backend/web/tracking-api/velocity-webhook";s:27:"REDIRECT_HTTP_AUTHORIZATION";s:0:"";s:18:"REDIRECT_x_api_key";s:42:"VEL-CRM-9f73a21c-45b6-4b90-8d4c-9aa27e2025";s:16:"REDIRECT_HANDLER";s:28:"application/x-httpd-ea-php82";s:15:"REDIRECT_STATUS";s:3:"200";s:9:"UNIQUE_ID";s:27:"at8Hsbcb1GuCgMt3crcEWAAAAIA";s:10:"SCRIPT_URL";s:42:"/backend/web/tracking-api/velocity-webhook";s:10:"SCRIPT_URI";s:79:"http://rootpanel.skygainnutricare.com/backend/web/tracking-api/velocity-webhook";s:15:"HTTP_CONNECTION";s:10:"Keep-Alive";s:12:"HTTP_BAGGAGE";s:199:"sentry-environment=prod,sentry-public_key=05575def535d134e931a1f33298d2646,sentry-trace_id=36651d694bb34009a7dc087e54ebb6e9,sentry-transaction=webhook-events-prod-dispatchWebhook,sentry-sampled=false";s:17:"HTTP_SENTRY_TRACE";s:51:"36651d694bb34009a7dc087e54ebb6e9-b086d87f98941c25-0";s:14:"HTTP_X_API_KEY";s:42:"VEL-CRM-9f73a21c-45b6-4b90-8d4c-9aa27e2025";s:11:"HTTP_CF_RAY";s:20:"a507e7b25dd1aed9-BOM";s:20:"HTTP_X_FORWARDED_FOR";s:13:"3.110.114.135";s:18:"HTTP_X_SHIPMENT_ID";s:13:"SHII4EIQHKV1U";s:14:"CONTENT_LENGTH";s:3:"748";s:11:"HTTP_ACCEPT";s:33:"application/json, text/plain, */*";s:12:"CONTENT_TYPE";s:16:"application/json";s:15:"HTTP_USER_AGENT";s:21:"Shipfast-Webhooks/1.0";s:20:"HTTP_X_WEBHOOK_EVENT";s:13:"status_change";s:17:"HTTP_X_WEBHOOK_ID";s:36:"d99f2350-2ba0-48ac-87c4-ad63d336c0b0";s:13:"HTTP_CDN_LOOP";s:19:"cloudflare; loops=1";s:17:"HTTP_CF_IPCOUNTRY";s:2:"IN";s:15:"HTTP_CF_VISITOR";s:18:"{"scheme":"https"}";s:22:"HTTP_X_FORWARDED_PROTO";s:5:"https";s:9:"HTTP_HOST";s:30:"rootpanel.skygainnutricare.com";s:4:"PATH";s:180:"/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin";s:16:"SERVER_SIGNATURE";s:0:"";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:11:"SERVER_NAME";s:30:"rootpanel.skygainnutricare.com";s:11:"SERVER_ADDR";s:14:"172.105.43.203";s:11:"SERVER_PORT";s:2:"80";s:11:"REMOTE_ADDR";s:13:"3.110.114.135";s:13:"DOCUMENT_ROOT";s:34:"/home/rootpanelskygain/public_html";s:14:"REQUEST_SCHEME";s:4:"http";s:14:"CONTEXT_PREFIX";s:8:"/cgi-sys";s:21:"CONTEXT_DOCUMENT_ROOT";s:26:"/usr/local/cpanel/cgi-sys/";s:12:"SERVER_ADMIN";s:40:"webmaster@rootpanel.skygainnutricare.com";s:15:"SCRIPT_FILENAME";s:56:"/home/rootpanelskygain/public_html/backend/web/index.php";s:11:"REMOTE_PORT";s:5:"10163";s:12:"REDIRECT_URL";s:22:"/backend/web/index.php";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:4:"POST";s:12:"QUERY_STRING";s:0:"";s:11:"REQUEST_URI";s:42:"/backend/web/tracking-api/velocity-webhook";s:11:"SCRIPT_NAME";s:22:"/backend/web/index.php";s:20:"ORIG_SCRIPT_FILENAME";s:34:"/usr/local/cpanel/cgi-sys/ea-php82";s:14:"ORIG_PATH_INFO";s:22:"/backend/web/index.php";s:20:"ORIG_PATH_TRANSLATED";s:56:"/home/rootpanelskygain/public_html/backend/web/index.php";s:16:"ORIG_SCRIPT_NAME";s:17:"/cgi-sys/ea-php82";s:8:"PHP_SELF";s:22:"/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1793001393.0451219081878662109375;s:12:"REQUEST_TIME";i:1793001393;s:4:"argv";a:0:{}s:4:"argc";i:0;s:5:"HTTPS";s:2:"on";}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:0:{}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}";s:4:"user";s:2:"N;";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:12:{s:3:"tag";s:13:"6adf07b10f459";s:3:"url";s:80:"https://rootpanel.skygainnutricare.com/backend/web/tracking-api/velocity-webhook";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:13:"3.110.114.135";s:4:"time";d:1793001393.0451219081878662109375;s:10:"statusCode";i:200;s:8:"sqlCount";i:12;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8918960;s:14:"processingTime";d:8.8633899688720703125;}s:10:"exceptions";a:0:{}}