a:14:{s:6:"config";s:1753:"a:5:{s:10:"phpVersion";s:5:"8.2.4";s:10:"yiiVersion";s:6:"2.0.54";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.54";s:4:"name";s:13:"SJ Nutrizione";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:5:"8.2.4";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:5:{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:101:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/vendor/yiisoft/yii2-faker/src";}}s:23:"yiisoft/yii2-bootstrap5";a:4:{s:4:"name";s:23:"yiisoft/yii2-bootstrap5";s:7:"version";s:8:"2.0.51.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap5";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/vendor/yiisoft/yii2-bootstrap5/src";}s:9:"bootstrap";s:40:"yii\bootstrap5\i18n\TranslationBootstrap";}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.27.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:101:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/vendor/yiisoft/yii2-debug/src";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.2.7.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:99:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/vendor/yiisoft/yii2-gii/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:109:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/vendor/yiisoft/yii2-symfonymailer/src";}}}}";s:3:"log";s:34830:"a:1:{s:8:"messages";a:47:{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:1777914806.01296901702880859375;i:4;a:0:{}i:5;i:2708040;}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:1777914806.01478290557861328125;i:4;a:0:{}i:5;i:2819000;}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:1777914806.014810085296630859375;i:4;a:0:{}i:5;i:2819640;}i:3;a:6:{i:0;s:15:"Session started";i:1;i:4;i:2;s:21:"yii\web\Session::open";i:3;d:1777914806.0257160663604736328125;i:4;a:0:{}i:5;i:3762040;}i:4;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.040853977203369140625;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5157984;}i:5;a:6:{i:0;s:112:"Opening DB connection: mysql:unix_socket=/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock;dbname=sjnutrizione";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1777914806.040957927703857421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5160168;}i:10;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.042964935302734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5220560;}i:13;a:6:{i:0;s:764:"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` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.04392910003662109375;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5242240;}i:16;a:6:{i:0;s:53:"SELECT * FROM `user` WHERE (`id`=1) AND (`status`=10)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.049129009246826171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5686648;}i:19;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:1777914806.05714511871337890625;i:4;a:0:{}i:5;i:6417240;}i:20;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1777914806.06529903411865234375;i:4;a:0:{}i:5;i:6622664;}i:21;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:1777914806.06571197509765625;i:4;a:0:{}i:5;i:6647224;}i:31;a:6:{i:0;s:39:"Route requested: 'customer-plan/assign'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1777914806.0716059207916259765625;i:4;a:0:{}i:5;i:6691064;}i:32;a:6:{i:0;s:34:"Route to run: customer-plan/assign";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1777914806.073841094970703125;i:4;a:0:{}i:5;i:6883552;}i:33;a:6:{i:0;s:74:"Running action: backend\controllers\CustomerPlanController::actionAssign()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1777914806.0766689777374267578125;i:4;a:0:{}i:5;i:7085904;}i:34;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `plans`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.077146053314208984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7125896;}i:37;a:6:{i:0;s:25:"SHOW CREATE TABLE `plans`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0782530307769775390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7143032;}i:40;a:6:{i:0;s:766:"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` = 'plans' AND `kcu`.`TABLE_NAME` = 'plans'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0784509181976318359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7142288;}i:43;a:6:{i:0;s:34:"SELECT * FROM `plans` WHERE `id`=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0790660381317138671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7144640;}i:46;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `customers`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0797750949859619140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7193848;}i:49;a:6:{i:0;s:29:"SHOW CREATE TABLE `customers`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.080565929412841796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7212032;}i:52;a:6:{i:0;s:774:"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` = 'customers' AND `kcu`.`TABLE_NAME` = 'customers'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.080996990203857421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7210600;}i:55;a:6:{i:0;s:38:"SELECT * FROM `customers` WHERE `id`=7";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0812389850616455078125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7214400;}i:58;a:6:{i:0;s:17:"Begin transaction";i:1;i:8;i:2;s:25:"yii\db\Transaction::begin";i:3;d:1777914806.081780910491943359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:53;s:8:"function";s:16:"beginTransaction";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7241584;}i:59;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `customer_plans`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.082048892974853515625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7276208;}i:62;a:6:{i:0;s:34:"SHOW CREATE TABLE `customer_plans`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0828349590301513671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7288360;}i:65;a:6:{i:0;s:784:"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` = 'customer_plans' AND `kcu`.`TABLE_NAME` = 'customer_plans'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.082952976226806640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7291256;}i:68;a:6:{i:0;s:96:"UPDATE `customer_plans` SET `status`='cancelled' WHERE (`customer_id`=7) AND (`status`='active')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.0831339359283447265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7293240;}i:71;a:6:{i:0;s:77:"SELECT EXISTS(SELECT * FROM `customers` WHERE `customers`.`id`=7) AS `result`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0879380702972412109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7496496;}i:74;a:6:{i:0;s:69:"SELECT EXISTS(SELECT * FROM `plans` WHERE `plans`.`id`=1) AS `result`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0883090496063232421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7500888;}i:77;a:6:{i:0;s:195:"INSERT INTO `customer_plans` (`customer_id`, `plan_id`, `start_date`, `status`, `end_date`, `created_at`, `updated_at`) VALUES (7, 1, '2026-05-04', 'active', '2026-06-04', 1777914806, 1777914806)";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.0886108875274658203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7499488;}i:80;a:6:{i:0;s:15:"Set savepoint 1";i:1;i:8;i:2;s:25:"yii\db\Transaction::begin";i:3;d:1777914806.0894138813018798828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:49;s:8:"function";s:16:"beginTransaction";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7503000;}i:81;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.0894300937652587890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:49;s:8:"function";s:16:"beginTransaction";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7506088;}i:84;a:6:{i:0;s:100:"SELECT `invoice_number` FROM `invoices` WHERE `invoice_number` LIKE '%INV-2026-%' ORDER BY `id` DESC";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0930531024932861328125;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:29;s:8:"function";s:6:"scalar";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:21:"generateInvoiceNumber";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}}i:5;i:7576296;}i:87;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `invoices`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0936450958251953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7580600;}i:90;a:6:{i:0;s:28:"SHOW CREATE TABLE `invoices`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.09469509124755859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7602952;}i:93;a:6:{i:0;s:772:"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` = 'invoices' AND `kcu`.`TABLE_NAME` = 'invoices'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0948870182037353515625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7601904;}i:96;a:6:{i:0;s:101:"SELECT EXISTS(SELECT * FROM `invoices` WHERE `invoices`.`invoice_number`='INV-2026-0005') AS `result`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.096251964569091796875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7687904;}i:99;a:6:{i:0;s:77:"SELECT EXISTS(SELECT * FROM `customers` WHERE `customers`.`id`=7) AS `result`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.09696102142333984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7694200;}i:102;a:6:{i:0;s:416:"INSERT INTO `invoices` (`invoice_number`, `customer_id`, `customer_plan_id`, `invoice_date`, `due_date`, `gst_rate`, `discount_amount`, `notes`, `created_by`, `subtotal`, `gst_amount`, `total_amount`, `paid_amount`, `status`, `created_at`, `updated_at`) VALUES ('INV-2026-0005', 7, 3, '2026-05-04', '2026-05-04', '18', '0', 'Plan: Basic Nutrition Plan', 1, '1500', '270', '1770', 0, 'unpaid', 1777914806, 1777914806)";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.097754955291748046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7731528;}i:105;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `invoice_items`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0987260341644287109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7754624;}i:108;a:6:{i:0;s:33:"SHOW CREATE TABLE `invoice_items`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.099605083465576171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7766936;}i:111;a:6:{i:0;s:782:"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` = 'invoice_items' AND `kcu`.`TABLE_NAME` = 'invoice_items'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0997140407562255859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7769920;}i:114;a:6:{i:0;s:182:"INSERT INTO `invoice_items` (`invoice_id`, `description`, `quantity`, `unit_price`, `total_price`, `sort_order`) VALUES (5, 'Basic Nutrition Plan (1 months)', '1', '1500', '1500', 0)";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.1000540256500244140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:93;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7780256;}i:117;a:6:{i:0;s:19:"Release savepoint 1";i:1;i:8;i:2;s:26:"yii\db\Transaction::commit";i:3;d:1777914806.1010119915008544921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:98;s:8:"function";s:6:"commit";s:5:"class";s:18:"yii\db\Transaction";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7780312;}i:118;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.101026058197021484375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:98;s:8:"function";s:6:"commit";s:5:"class";s:18:"yii\db\Transaction";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7783408;}i:121;a:6:{i:0;s:18:"Commit transaction";i:1;i:8;i:2;s:26:"yii\db\Transaction::commit";i:3;d:1777914806.10115909576416015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:103;s:8:"function";s:6:"commit";s:5:"class";s:18:"yii\db\Transaction";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7781144;}}}";s:9:"profiling";s:59872:"a:3:{s:6:"memory";i:7909688;s:4:"time";d:0.1056249141693115234375;s:8:"messages";a:66:{i:6;a:6:{i:0;s:112:"Opening DB connection: mysql:unix_socket=/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock;dbname=sjnutrizione";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1777914806.0409729480743408203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5160976;}i:7;a:6:{i:0;s:112:"Opening DB connection: mysql:unix_socket=/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock;dbname=sjnutrizione";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1777914806.04135799407958984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5208568;}i:8;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0413820743560791015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5208352;}i:9;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0429248809814453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5219272;}i:11;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0429840087890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5221472;}i:12;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0430829524993896484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5223536;}i:14;a:6:{i:0;s:764:"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` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0439510345458984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5243280;}i:15;a:6:{i:0;s:764:"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` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0443160533905029296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5245136;}i:17;a:6:{i:0;s:53:"SELECT * FROM `user` WHERE (`id`=1) AND (`status`=10)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.049148082733154296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5687352;}i:18;a:6:{i:0;s:53:"SELECT * FROM `user` WHERE (`id`=1) AND (`status`=10)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.04957294464111328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5689640;}i:35;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `plans`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0771610736846923828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7127184;}i:36;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `plans`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.078227996826171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7141368;}i:38;a:6:{i:0;s:25:"SHOW CREATE TABLE `plans`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0782630443572998046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7144320;}i:39;a:6:{i:0;s:25:"SHOW CREATE TABLE `plans`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0783360004425048828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7147240;}i:41;a:6:{i:0;s:766:"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` = 'plans' AND `kcu`.`TABLE_NAME` = 'plans'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0784609317779541015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7143704;}i:42;a:6:{i:0;s:766:"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` = 'plans' AND `kcu`.`TABLE_NAME` = 'plans'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.079010009765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7145936;}i:44;a:6:{i:0;s:34:"SELECT * FROM `plans` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.079080104827880859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7146144;}i:45;a:6:{i:0;s:34:"SELECT * FROM `plans` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0792949199676513671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7149016;}i:47;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `customers`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.079782962799072265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7195136;}i:48;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `customers`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0805470943450927734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7210368;}i:50;a:6:{i:0;s:29:"SHOW CREATE TABLE `customers`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.08057403564453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7213320;}i:51;a:6:{i:0;s:29:"SHOW CREATE TABLE `customers`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.080913066864013671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7216760;}i:53;a:6:{i:0;s:774:"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` = 'customers' AND `kcu`.`TABLE_NAME` = 'customers'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.08100605010986328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7212016;}i:54;a:6:{i:0;s:774:"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` = 'customers' AND `kcu`.`TABLE_NAME` = 'customers'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0811879634857177734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7215472;}i:56;a:6:{i:0;s:38:"SELECT * FROM `customers` WHERE `id`=7";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0812470912933349609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7215904;}i:57;a:6:{i:0;s:38:"SELECT * FROM `customers` WHERE `id`=7";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.08135890960693359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7218560;}i:60;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `customer_plans`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.08205890655517578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7277496;}i:61;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `customer_plans`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0828230381011962890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7286688;}i:63;a:6:{i:0;s:34:"SHOW CREATE TABLE `customer_plans`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0828430652618408203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7289648;}i:64;a:6:{i:0;s:34:"SHOW CREATE TABLE `customer_plans`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0828990936279296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7292576;}i:66;a:6:{i:0;s:784:"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` = 'customer_plans' AND `kcu`.`TABLE_NAME` = 'customer_plans'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.08296108245849609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7292672;}i:67;a:6:{i:0;s:784:"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` = 'customer_plans' AND `kcu`.`TABLE_NAME` = 'customer_plans'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.083095073699951171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7296104;}i:69;a:6:{i:0;s:96:"UPDATE `customer_plans` SET `status`='cancelled' WHERE (`customer_id`=7) AND (`status`='active')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.0831410884857177734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7294536;}i:70;a:6:{i:0;s:96:"UPDATE `customer_plans` SET `status`='cancelled' WHERE (`customer_id`=7) AND (`status`='active')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.08329010009765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7295944;}i:72;a:6:{i:0;s:77:"SELECT EXISTS(SELECT * FROM `customers` WHERE `customers`.`id`=7) AS `result`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.087954044342041015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7498000;}i:73;a:6:{i:0;s:77:"SELECT EXISTS(SELECT * FROM `customers` WHERE `customers`.`id`=7) AS `result`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0881230831146240234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7499264;}i:75;a:6:{i:0;s:69:"SELECT EXISTS(SELECT * FROM `plans` WHERE `plans`.`id`=1) AS `result`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0883209705352783203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7502392;}i:76;a:6:{i:0;s:69:"SELECT EXISTS(SELECT * FROM `plans` WHERE `plans`.`id`=1) AS `result`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.088430881500244140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7503712;}i:78;a:6:{i:0;s:195:"INSERT INTO `customer_plans` (`customer_id`, `plan_id`, `start_date`, `status`, `end_date`, `created_at`, `updated_at`) VALUES (7, 1, '2026-05-04', 'active', '2026-06-04', 1777914806, 1777914806)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.08862209320068359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7500368;}i:79;a:6:{i:0;s:195:"INSERT INTO `customer_plans` (`customer_id`, `plan_id`, `start_date`, `status`, `end_date`, `created_at`, `updated_at`) VALUES (7, 1, '2026-05-04', 'active', '2026-06-04', 1777914806, 1777914806)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.0891959667205810546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7501816;}i:82;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.0894410610198974609375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:49;s:8:"function";s:16:"beginTransaction";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7507752;}i:83;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.0904369354248046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:49;s:8:"function";s:16:"beginTransaction";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7509320;}i:85;a:6:{i:0;s:100:"SELECT `invoice_number` FROM `invoices` WHERE `invoice_number` LIKE '%INV-2026-%' ORDER BY `id` DESC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0930640697479248046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:29;s:8:"function";s:6:"scalar";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:21:"generateInvoiceNumber";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}}i:5;i:7578176;}i:86;a:6:{i:0;s:100:"SELECT `invoice_number` FROM `invoices` WHERE `invoice_number` LIKE '%INV-2026-%' ORDER BY `id` DESC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0936100482940673828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:29;s:8:"function";s:6:"scalar";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:21:"generateInvoiceNumber";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}}i:5;i:7579960;}i:88;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `invoices`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.093656063079833984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7582264;}i:89;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `invoices`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.094676971435546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7600912;}i:91;a:6:{i:0;s:28:"SHOW CREATE TABLE `invoices`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0947039127349853515625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7604616;}i:92;a:6:{i:0;s:28:"SHOW CREATE TABLE `invoices`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0947821140289306640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7608688;}i:94;a:6:{i:0;s:772:"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` = 'invoices' AND `kcu`.`TABLE_NAME` = 'invoices'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0948970317840576171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7603696;}i:95;a:6:{i:0;s:772:"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` = 'invoices' AND `kcu`.`TABLE_NAME` = 'invoices'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.09510707855224609375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7607536;}i:97;a:6:{i:0;s:101:"SELECT EXISTS(SELECT * FROM `invoices` WHERE `invoices`.`invoice_number`='INV-2026-0005') AS `result`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.096263885498046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7689784;}i:98;a:6:{i:0;s:101:"SELECT EXISTS(SELECT * FROM `invoices` WHERE `invoices`.`invoice_number`='INV-2026-0005') AS `result`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0965459346771240234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7691528;}i:100;a:6:{i:0;s:77:"SELECT EXISTS(SELECT * FROM `customers` WHERE `customers`.`id`=7) AS `result`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.096970081329345703125;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7696080;}i:101;a:6:{i:0;s:77:"SELECT EXISTS(SELECT * FROM `customers` WHERE `customers`.`id`=7) AS `result`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0970671176910400390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7697776;}i:103;a:6:{i:0;s:416:"INSERT INTO `invoices` (`invoice_number`, `customer_id`, `customer_plan_id`, `invoice_date`, `due_date`, `gst_rate`, `discount_amount`, `notes`, `created_by`, `subtotal`, `gst_amount`, `total_amount`, `paid_amount`, `status`, `created_at`, `updated_at`) VALUES ('INV-2026-0005', 7, 3, '2026-05-04', '2026-05-04', '18', '0', 'Plan: Basic Nutrition Plan', 1, '1500', '270', '1770', 0, 'unpaid', 1777914806, 1777914806)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.0977671146392822265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7731208;}i:104;a:6:{i:0;s:416:"INSERT INTO `invoices` (`invoice_number`, `customer_id`, `customer_plan_id`, `invoice_date`, `due_date`, `gst_rate`, `discount_amount`, `notes`, `created_by`, `subtotal`, `gst_amount`, `total_amount`, `paid_amount`, `status`, `created_at`, `updated_at`) VALUES ('INV-2026-0005', 7, 3, '2026-05-04', '2026-05-04', '18', '0', 'Plan: Basic Nutrition Plan', 1, '1500', '270', '1770', 0, 'unpaid', 1777914806, 1777914806)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.09848499298095703125;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7733288;}i:106;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `invoice_items`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0987339019775390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7756288;}i:107;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `invoice_items`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0995919704437255859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7764888;}i:109;a:6:{i:0;s:33:"SHOW CREATE TABLE `invoice_items`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0996119976043701171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7768600;}i:110;a:6:{i:0;s:33:"SHOW CREATE TABLE `invoice_items`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0996549129486083984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7771520;}i:112;a:6:{i:0;s:782:"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` = 'invoice_items' AND `kcu`.`TABLE_NAME` = 'invoice_items'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0997219085693359375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7771712;}i:113;a:6:{i:0;s:782:"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` = 'invoice_items' AND `kcu`.`TABLE_NAME` = 'invoice_items'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0998790264129638671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7775016;}i:115;a:6:{i:0;s:182:"INSERT INTO `invoice_items` (`invoice_id`, `description`, `quantity`, `unit_price`, `total_price`, `sort_order`) VALUES (5, 'Basic Nutrition Plan (1 months)', '1', '1500', '1500', 0)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.1000630855560302734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:93;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7781296;}i:116;a:6:{i:0;s:182:"INSERT INTO `invoice_items` (`invoice_id`, `description`, `quantity`, `unit_price`, `total_price`, `sort_order`) VALUES (5, 'Basic Nutrition Plan (1 months)', '1', '1500', '1500', 0)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.1009809970855712890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:93;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7783120;}i:119;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.1010310649871826171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:98;s:8:"function";s:6:"commit";s:5:"class";s:18:"yii\db\Transaction";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7785072;}i:120;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.101149082183837890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:98;s:8:"function";s:6:"commit";s:5:"class";s:18:"yii\db\Transaction";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7786640;}}}";s:2:"db";s:58865:"a:1:{s:8:"messages";a:64:{i:8;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0413820743560791015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5208352;}i:9;a:6:{i:0;s:29:"SHOW FULL COLUMNS FROM `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0429248809814453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5219272;}i:11;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0429840087890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5221472;}i:12;a:6:{i:0;s:24:"SHOW CREATE TABLE `user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0430829524993896484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5223536;}i:14;a:6:{i:0;s:764:"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` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0439510345458984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5243280;}i:15;a:6:{i:0;s:764:"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` = 'user' AND `kcu`.`TABLE_NAME` = 'user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0443160533905029296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5245136;}i:17;a:6:{i:0;s:53:"SELECT * FROM `user` WHERE (`id`=1) AND (`status`=10)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.049148082733154296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5687352;}i:18;a:6:{i:0;s:53:"SELECT * FROM `user` WHERE (`id`=1) AND (`status`=10)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.04957294464111328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:94:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/models/User.php";s:4:"line";i:65;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}i:5;i:5689640;}i:35;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `plans`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0771610736846923828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7127184;}i:36;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `plans`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.078227996826171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7141368;}i:38;a:6:{i:0;s:25:"SHOW CREATE TABLE `plans`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0782630443572998046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7144320;}i:39;a:6:{i:0;s:25:"SHOW CREATE TABLE `plans`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0783360004425048828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7147240;}i:41;a:6:{i:0;s:766:"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` = 'plans' AND `kcu`.`TABLE_NAME` = 'plans'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0784609317779541015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7143704;}i:42;a:6:{i:0;s:766:"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` = 'plans' AND `kcu`.`TABLE_NAME` = 'plans'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.079010009765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7145936;}i:44;a:6:{i:0;s:34:"SELECT * FROM `plans` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.079080104827880859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7146144;}i:45;a:6:{i:0;s:34:"SELECT * FROM `plans` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0792949199676513671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:43;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7149016;}i:47;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `customers`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.079782962799072265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7195136;}i:48;a:6:{i:0;s:34:"SHOW FULL COLUMNS FROM `customers`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0805470943450927734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7210368;}i:50;a:6:{i:0;s:29:"SHOW CREATE TABLE `customers`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.08057403564453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7213320;}i:51;a:6:{i:0;s:29:"SHOW CREATE TABLE `customers`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.080913066864013671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7216760;}i:53;a:6:{i:0;s:774:"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` = 'customers' AND `kcu`.`TABLE_NAME` = 'customers'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.08100605010986328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7212016;}i:54;a:6:{i:0;s:774:"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` = 'customers' AND `kcu`.`TABLE_NAME` = 'customers'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0811879634857177734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7215472;}i:56;a:6:{i:0;s:38:"SELECT * FROM `customers` WHERE `id`=7";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0812470912933349609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7215904;}i:57;a:6:{i:0;s:38:"SELECT * FROM `customers` WHERE `id`=7";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.08135890960693359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:44;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7218560;}i:60;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `customer_plans`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.08205890655517578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7277496;}i:61;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `customer_plans`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0828230381011962890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7286688;}i:63;a:6:{i:0;s:34:"SHOW CREATE TABLE `customer_plans`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0828430652618408203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7289648;}i:64;a:6:{i:0;s:34:"SHOW CREATE TABLE `customer_plans`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0828990936279296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7292576;}i:66;a:6:{i:0;s:784:"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` = 'customer_plans' AND `kcu`.`TABLE_NAME` = 'customer_plans'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.08296108245849609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7292672;}i:67;a:6:{i:0;s:784:"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` = 'customer_plans' AND `kcu`.`TABLE_NAME` = 'customer_plans'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.083095073699951171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7296104;}i:69;a:6:{i:0;s:96:"UPDATE `customer_plans` SET `status`='cancelled' WHERE (`customer_id`=7) AND (`status`='active')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.0831410884857177734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7294536;}i:70;a:6:{i:0;s:96:"UPDATE `customer_plans` SET `status`='cancelled' WHERE (`customer_id`=7) AND (`status`='active')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.08329010009765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:56;s:8:"function";s:9:"updateAll";s:5:"class";s:19:"yii\db\ActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7295944;}i:72;a:6:{i:0;s:77:"SELECT EXISTS(SELECT * FROM `customers` WHERE `customers`.`id`=7) AS `result`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.087954044342041015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7498000;}i:73;a:6:{i:0;s:77:"SELECT EXISTS(SELECT * FROM `customers` WHERE `customers`.`id`=7) AS `result`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0881230831146240234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7499264;}i:75;a:6:{i:0;s:69:"SELECT EXISTS(SELECT * FROM `plans` WHERE `plans`.`id`=1) AS `result`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0883209705352783203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7502392;}i:76;a:6:{i:0;s:69:"SELECT EXISTS(SELECT * FROM `plans` WHERE `plans`.`id`=1) AS `result`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.088430881500244140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7503712;}i:78;a:6:{i:0;s:195:"INSERT INTO `customer_plans` (`customer_id`, `plan_id`, `start_date`, `status`, `end_date`, `created_at`, `updated_at`) VALUES (7, 1, '2026-05-04', 'active', '2026-06-04', 1777914806, 1777914806)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.08862209320068359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7500368;}i:79;a:6:{i:0;s:195:"INSERT INTO `customer_plans` (`customer_id`, `plan_id`, `start_date`, `status`, `end_date`, `created_at`, `updated_at`) VALUES (7, 1, '2026-05-04', 'active', '2026-06-04', 1777914806, 1777914806)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.0891959667205810546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:77;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7501816;}i:82;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.0894410610198974609375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:49;s:8:"function";s:16:"beginTransaction";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7507752;}i:83;a:6:{i:0;s:16:"SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.0904369354248046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:49;s:8:"function";s:16:"beginTransaction";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7509320;}i:85;a:6:{i:0;s:100:"SELECT `invoice_number` FROM `invoices` WHERE `invoice_number` LIKE '%INV-2026-%' ORDER BY `id` DESC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0930640697479248046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:29;s:8:"function";s:6:"scalar";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:21:"generateInvoiceNumber";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}}i:5;i:7578176;}i:86;a:6:{i:0;s:100:"SELECT `invoice_number` FROM `invoices` WHERE `invoice_number` LIKE '%INV-2026-%' ORDER BY `id` DESC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0936100482940673828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:29;s:8:"function";s:6:"scalar";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:21:"generateInvoiceNumber";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}}i:5;i:7579960;}i:88;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `invoices`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.093656063079833984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7582264;}i:89;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `invoices`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.094676971435546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7600912;}i:91;a:6:{i:0;s:28:"SHOW CREATE TABLE `invoices`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0947039127349853515625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7604616;}i:92;a:6:{i:0;s:28:"SHOW CREATE TABLE `invoices`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0947821140289306640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7608688;}i:94;a:6:{i:0;s:772:"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` = 'invoices' AND `kcu`.`TABLE_NAME` = 'invoices'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0948970317840576171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7603696;}i:95;a:6:{i:0;s:772:"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` = 'invoices' AND `kcu`.`TABLE_NAME` = 'invoices'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.09510707855224609375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:53;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7607536;}i:97;a:6:{i:0;s:101:"SELECT EXISTS(SELECT * FROM `invoices` WHERE `invoices`.`invoice_number`='INV-2026-0005') AS `result`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.096263885498046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7689784;}i:98;a:6:{i:0;s:101:"SELECT EXISTS(SELECT * FROM `invoices` WHERE `invoices`.`invoice_number`='INV-2026-0005') AS `result`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0965459346771240234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7691528;}i:100;a:6:{i:0;s:77:"SELECT EXISTS(SELECT * FROM `customers` WHERE `customers`.`id`=7) AS `result`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.096970081329345703125;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7696080;}i:101;a:6:{i:0;s:77:"SELECT EXISTS(SELECT * FROM `customers` WHERE `customers`.`id`=7) AS `result`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0970671176910400390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7697776;}i:103;a:6:{i:0;s:416:"INSERT INTO `invoices` (`invoice_number`, `customer_id`, `customer_plan_id`, `invoice_date`, `due_date`, `gst_rate`, `discount_amount`, `notes`, `created_by`, `subtotal`, `gst_amount`, `total_amount`, `paid_amount`, `status`, `created_at`, `updated_at`) VALUES ('INV-2026-0005', 7, 3, '2026-05-04', '2026-05-04', '18', '0', 'Plan: Basic Nutrition Plan', 1, '1500', '270', '1770', 0, 'unpaid', 1777914806, 1777914806)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.0977671146392822265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7731208;}i:104;a:6:{i:0;s:416:"INSERT INTO `invoices` (`invoice_number`, `customer_id`, `customer_plan_id`, `invoice_date`, `due_date`, `gst_rate`, `discount_amount`, `notes`, `created_by`, `subtotal`, `gst_amount`, `total_amount`, `paid_amount`, `status`, `created_at`, `updated_at`) VALUES ('INV-2026-0005', 7, 3, '2026-05-04', '2026-05-04', '18', '0', 'Plan: Basic Nutrition Plan', 1, '1500', '270', '1770', 0, 'unpaid', 1777914806, 1777914806)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.09848499298095703125;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:79;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7733288;}i:106;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `invoice_items`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0987339019775390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7756288;}i:107;a:6:{i:0;s:38:"SHOW FULL COLUMNS FROM `invoice_items`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0995919704437255859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7764888;}i:109;a:6:{i:0;s:33:"SHOW CREATE TABLE `invoice_items`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0996119976043701171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7768600;}i:110;a:6:{i:0;s:33:"SHOW CREATE TABLE `invoice_items`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0996549129486083984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7771520;}i:112;a:6:{i:0;s:782:"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` = 'invoice_items' AND `kcu`.`TABLE_NAME` = 'invoice_items'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0997219085693359375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7771712;}i:113;a:6:{i:0;s:782:"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` = 'invoice_items' AND `kcu`.`TABLE_NAME` = 'invoice_items'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1777914806.0998790264129638671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:86;s:8:"function";s:5:"__set";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7775016;}i:115;a:6:{i:0;s:182:"INSERT INTO `invoice_items` (`invoice_id`, `description`, `quantity`, `unit_price`, `total_price`, `sort_order`) VALUES (5, 'Basic Nutrition Plan (1 months)', '1', '1500', '1500', 0)";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.1000630855560302734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:93;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7781296;}i:116;a:6:{i:0;s:182:"INSERT INTO `invoice_items` (`invoice_id`, `description`, `quantity`, `unit_price`, `total_price`, `sort_order`) VALUES (5, 'Basic Nutrition Plan (1 months)', '1', '1500', '1500', 0)";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.1009809970855712890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:93;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7783120;}i:119;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.1010310649871826171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:98;s:8:"function";s:6:"commit";s:5:"class";s:18:"yii\db\Transaction";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7785072;}i:120;a:6:{i:0;s:24:"RELEASE SAVEPOINT LEVEL1";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1777914806.101149082183837890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:106:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/InvoiceService.php";s:4:"line";i:98;s:8:"function";s:6:"commit";s:5:"class";s:18:"yii\db\Transaction";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:111:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/common/services/CustomerPlanService.php";s:4:"line";i:83;s:8:"function";s:13:"createInvoice";s:5:"class";s:30:"common\services\InvoiceService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:118:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/controllers/CustomerPlanController.php";s:4:"line";i:67;s:8:"function";s:10:"assignPlan";s:5:"class";s:35:"common\services\CustomerPlanService";s:4:"type";s:2:"->";}}i:5;i:7786640;}}}";s:5:"event";s:8773:"a:46:{i:0;a:5:{s:4:"time";d:1777914806.037086963653564453125;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:1;a:5:{s:4:"time";d:1777914806.0413510799407958984375;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:2;a:5:{s:4:"time";d:1777914806.0502541065216064453125;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:"common\models\User";}i:3;a:5:{s:4:"time";d:1777914806.050283908843994140625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"common\models\User";}i:4;a:5:{s:4:"time";d:1777914806.0548250675201416015625;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:"common\models\User";}i:5;a:5:{s:4:"time";d:1777914806.06597805023193359375;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:6;a:5:{s:4:"time";d:1777914806.0740220546722412109375;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:7;a:5:{s:4:"time";d:1777914806.0763809680938720703125;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"backend\controllers\CustomerPlanController";}i:8;a:5:{s:4:"time";d:1777914806.0770320892333984375;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:9;a:5:{s:4:"time";d:1777914806.0793170928955078125;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:"common\models\Plan";}i:10;a:5:{s:4:"time";d:1777914806.07933807373046875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"common\models\Plan";}i:11;a:5:{s:4:"time";d:1777914806.079760074615478515625;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:12;a:5:{s:4:"time";d:1777914806.081378936767578125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"common\models\Customer";}i:13;a:5:{s:4:"time";d:1777914806.08139896392822265625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"common\models\Customer";}i:14;a:5:{s:4:"time";d:1777914806.0817921161651611328125;s:4:"name";s:16:"beginTransaction";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\db\Connection";}i:15;a:5:{s:4:"time";d:1777914806.0833110809326171875;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:"common\models\CustomerPlan";}i:16;a:5:{s:4:"time";d:1777914806.0839750766754150390625;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"common\models\CustomerPlan";}i:17;a:5:{s:4:"time";d:1777914806.08714008331298828125;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:18;a:5:{s:4:"time";d:1777914806.0872700214385986328125;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:19;a:5:{s:4:"time";d:1777914806.0881519317626953125;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:20;a:5:{s:4:"time";d:1777914806.0882689952850341796875;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:21;a:5:{s:4:"time";d:1777914806.088447093963623046875;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"common\models\CustomerPlan";}i:22;a:5:{s:4:"time";d:1777914806.088551998138427734375;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"common\models\CustomerPlan";}i:23;a:5:{s:4:"time";d:1777914806.0894010066986083984375;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:26:"common\models\CustomerPlan";}i:24;a:5:{s:4:"time";d:1777914806.0907421112060546875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\Invoice";}i:25;a:5:{s:4:"time";d:1777914806.090755939483642578125;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:26;a:5:{s:4:"time";d:1777914806.0951778888702392578125;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\Invoice";}i:27;a:5:{s:4:"time";d:1777914806.0960490703582763671875;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:28;a:5:{s:4:"time";d:1777914806.0962030887603759765625;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:29;a:5:{s:4:"time";d:1777914806.0968658924102783203125;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:30;a:5:{s:4:"time";d:1777914806.0969240665435791015625;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:31;a:5:{s:4:"time";d:1777914806.0970818996429443359375;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\Invoice";}i:32;a:5:{s:4:"time";d:1777914806.0971009731292724609375;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\Invoice";}i:33;a:5:{s:4:"time";d:1777914806.098514080047607421875;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"common\models\Invoice";}i:34;a:5:{s:4:"time";d:1777914806.0987079143524169921875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"common\models\InvoiceItem";}i:35;a:5:{s:4:"time";d:1777914806.0999081134796142578125;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"common\models\InvoiceItem";}i:36;a:5:{s:4:"time";d:1777914806.099997043609619140625;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"common\models\InvoiceItem";}i:37;a:5:{s:4:"time";d:1777914806.1000020503997802734375;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"common\models\InvoiceItem";}i:38;a:5:{s:4:"time";d:1777914806.101006031036376953125;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"common\models\InvoiceItem";}i:39;a:5:{s:4:"time";d:1777914806.10126399993896484375;s:4:"name";s:17:"commitTransaction";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\db\Connection";}i:40;a:5:{s:4:"time";d:1777914806.1032619476318359375;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"backend\controllers\CustomerPlanController";}i:41;a:5:{s:4:"time";d:1777914806.103269100189208984375;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:42;a:5:{s:4:"time";d:1777914806.1032741069793701171875;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:43;a:5:{s:4:"time";d:1777914806.1032779216766357421875;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:44;a:5:{s:4:"time";d:1777914806.103806972503662109375;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:45;a:5:{s:4:"time";d:1777914806.103867053985595703125;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:121:"a:3:{s:5:"start";d:1777914805.999557971954345703125;s:3:"end";d:1777914806.105413913726806640625;s:6:"memory";i:7920992;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:1984:"a:3:{s:8:"messages";a:9:{i:22;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:1777914806.066338062286376953125;i:4;a:0:{}i:5;i:6686976;}i:23;a:6:{i:0;a:3:{s:4:"rule";s:12:"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:1777914806.0663940906524658203125;i:4;a:0:{}i:5;i:6687568;}i:24;a:6:{i:0;a:3:{s:4:"rule";s:41:"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:1777914806.0664160251617431640625;i:4;a:0:{}i:5;i:6688160;}i:25;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:1777914806.0664188861846923828125;i:4;a:0:{}i:5;i:6688752;}i:26;a:6:{i:0;a:3:{s:4:"rule";s:43:"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:1777914806.06651210784912109375;i:4;a:0:{}i:5;i:6689344;}i:27;a:6:{i:0;a:3:{s:4:"rule";s:15:"api/create-lead";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1777914806.070600986480712890625;i:4;a:0:{}i:5;i:6689936;}i:28;a:6:{i:0;a:3:{s:4:"rule";s:16:"api/food-suggest";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1777914806.07075595855712890625;i:4;a:0:{}i:5;i:6690528;}i:29;a:6:{i:0;s:56:"Request parsed with URL rule: customer-plan/";i:1;i:8;i:2;s:29:"yii\web\UrlRule::parseRequest";i:3;d:1777914806.071588993072509765625;i:4;a:0:{}i:5;i:6692184;}i:30;a:6:{i:0;a:3:{s:4:"rule";s:26:"customer-plan/";s:5:"match";b:1;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1777914806.07159709930419921875;i:4;a:0:{}i:5;i:6691752;}}s:5:"route";s:20:"customer-plan/assign";s:6:"action";s:58:"backend\controllers\CustomerPlanController::actionAssign()";}";s:7:"request";s:9653:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:302;s:14:"requestHeaders";a:20:{s:4:"host";s:9:"localhost";s:10:"connection";s:10:"keep-alive";s:14:"content-length";s:3:"171";s:13:"cache-control";s:9:"max-age=0";s:9:"sec-ch-ua";s:64:""Google Chrome";v="147", "Not.A/Brand";v="8", "Chromium";v="147"";s:16:"sec-ch-ua-mobile";s:2:"?0";s:18:"sec-ch-ua-platform";s:7:""macOS"";s:6:"origin";s:16:"http://localhost";s:12:"content-type";s:33:"application/x-www-form-urlencoded";s:25:"upgrade-insecure-requests";s:1:"1";s:10:"user-agent";s:117:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36";s:6:"accept";s:135:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7";s:14:"sec-fetch-site";s:11:"same-origin";s:14:"sec-fetch-mode";s:8:"navigate";s:14:"sec-fetch-user";s:2:"?1";s:14:"sec-fetch-dest";s:8:"document";s:7:"referer";s:78:"http://localhost/bluesky/sjnutrizione/sjnutrizione/backend/web/customer/view/7";s:15:"accept-encoding";s:23:"gzip, deflate, br, zstd";s:15:"accept-language";s:26:"en-GB,en-US;q=0.9,en;q=0.8";s:6:"cookie";s:1214:"_identity-frontend=f04c12c8aaf9d68a5629158a4e1f23fafa39083c0e042d5455d2b41f88d7bcaba%3A2%3A%7Bi%3A0%3Bs%3A18%3A%22_identity-frontend%22%3Bi%3A1%3Bs%3A46%3A%22%5B1%2C%22rYQ0vo5FPmNyxqET7Cbpr3Roh49zQ3uc%22%2C2592000%5D%22%3B%7D; _identity-backend=34f6d76438e79bf758e8b96368c038266b29ab130396524f17588076e229d8e9a%3A2%3A%7Bi%3A0%3Bs%3A17%3A%22_identity-backend%22%3Bi%3A1%3Bs%3A46%3A%22%5B1%2C%22rYQ0vo5FPmNyxqET7Cbpr3Roh49zQ3uc%22%2C2592000%5D%22%3B%7D; _ga=GA1.1.1814254141.1776423672; _ga_BS69MC8NTG=GS2.1.s1776423671$o1$g1$t1776425419$j43$l0$h0; _identity=97c054ec16e84f11b7f990a5cf50cada2326416546fd0095a3b46b9a7e0cefeba%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A28%3A%22%5B%22100%22%2C%22test100key%22%2C2592000%5D%22%3B%7D; advanced-frontend=7uv2l83fnr0pm2dip4jvqn57ad; _csrf-frontend=751483224797985e8f7888b2ed8fcddd229cde5cd8a64052a2d2dcba50d0fad5a%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%22kk66fuQO5P5Vzi4d_-OZ4JwfkLjI8ldD%22%3B%7D; advanced-backend=mgm3td2cs7uo9a57t9clped5t7; _csrf-backend=1221c2b6a7290eb989b646cb9ebdbb4654d837213aba819519f39081a6a0daf9a%3A2%3A%7Bi%3A0%3Bs%3A13%3A%22_csrf-backend%22%3Bi%3A1%3Bs%3A32%3A%22FPVdzMZ22CeJHEUfv30W3BUazH3itEtg%22%3B%7D";}s:15:"responseHeaders";a:10:{s:12:"X-Powered-By";s:9:"PHP/8.2.4";s:7:"Expires";s:29:"Thu, 19 Nov 1981 08:52:00 GMT";s:13:"Cache-Control";s:35:"no-store, no-cache, must-revalidate";s:6:"Pragma";s:8:"no-cache";s:8:"Location";s:78:"http://localhost/bluesky/sjnutrizione/sjnutrizione/backend/web/customer/view/7";s:12:"Content-Type";s:24:"text/html; charset=UTF-8";s:11:"X-Debug-Tag";s:13:"69f8d3b60e0fe";s:16:"X-Debug-Duration";s:3:"105";s:12:"X-Debug-Link";s:83:"/bluesky/sjnutrizione/sjnutrizione/backend/web/debug/default/view?tag=69f8d3b60e0fe";s:10:"Set-Cookie";s:311:"_identity-backend=34f6d76438e79bf758e8b96368c038266b29ab130396524f17588076e229d8e9a%3A2%3A%7Bi%3A0%3Bs%3A17%3A%22_identity-backend%22%3Bi%3A1%3Bs%3A46%3A%22%5B1%2C%22rYQ0vo5FPmNyxqET7Cbpr3Roh49zQ3uc%22%2C2592000%5D%22%3B%7D; expires=Wed, 03 Jun 2026 17:13:26 GMT; Max-Age=2592000; path=/; HttpOnly; SameSite=Lax";}s:5:"route";s:20:"customer-plan/assign";s:6:"action";s:58:"backend\controllers\CustomerPlanController::actionAssign()";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:0;}s:11:"requestBody";a:3:{s:12:"Content Type";s:33:"application/x-www-form-urlencoded";s:3:"Raw";s:171:"_csrf-backend=hetslalXm8HQliDgh2UNsl5mAKYoKTzbqEKU_faX2aDDuzrx0xrB8-LVRarPIFjUKFUw8RtrabrSCqeUgtKtxw%3D%3D&customer_id=7&plan_id=1&start_date=2026-05-04&generate_invoice=1";s:7:"Decoded";a:5:{s:13:"_csrf-backend";s:88:"hetslalXm8HQliDgh2UNsl5mAKYoKTzbqEKU_faX2aDDuzrx0xrB8-LVRarPIFjUKFUw8RtrabrSCqeUgtKtxw==";s:11:"customer_id";s:1:"7";s:7:"plan_id";s:1:"1";s:10:"start_date";s:10:"2026-05-04";s:16:"generate_invoice";s:1:"1";}}s:6:"SERVER";a:48:{s:18:"REDIRECT_UNIQUE_ID";s:27:"afjTtVd4KTX-uFJgFYZ7mgAAAAI";s:15:"REDIRECT_STATUS";s:3:"200";s:9:"UNIQUE_ID";s:27:"afjTtVd4KTX-uFJgFYZ7mgAAAAI";s:9:"HTTP_HOST";s:9:"localhost";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:14:"CONTENT_LENGTH";s:3:"171";s:18:"HTTP_CACHE_CONTROL";s:9:"max-age=0";s:14:"HTTP_SEC_CH_UA";s:64:""Google Chrome";v="147", "Not.A/Brand";v="8", "Chromium";v="147"";s:21:"HTTP_SEC_CH_UA_MOBILE";s:2:"?0";s:23:"HTTP_SEC_CH_UA_PLATFORM";s:7:""macOS"";s:11:"HTTP_ORIGIN";s:16:"http://localhost";s:12:"CONTENT_TYPE";s:33:"application/x-www-form-urlencoded";s:30:"HTTP_UPGRADE_INSECURE_REQUESTS";s:1:"1";s:15:"HTTP_USER_AGENT";s:117:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36";s:11:"HTTP_ACCEPT";s:135:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7";s:19:"HTTP_SEC_FETCH_SITE";s:11:"same-origin";s:19:"HTTP_SEC_FETCH_MODE";s:8:"navigate";s:19:"HTTP_SEC_FETCH_USER";s:2:"?1";s:19:"HTTP_SEC_FETCH_DEST";s:8:"document";s:12:"HTTP_REFERER";s:78:"http://localhost/bluesky/sjnutrizione/sjnutrizione/backend/web/customer/view/7";s:20:"HTTP_ACCEPT_ENCODING";s:23:"gzip, deflate, br, zstd";s:20:"HTTP_ACCEPT_LANGUAGE";s:26:"en-GB,en-US;q=0.9,en;q=0.8";s:11:"HTTP_COOKIE";s:1214:"_identity-frontend=f04c12c8aaf9d68a5629158a4e1f23fafa39083c0e042d5455d2b41f88d7bcaba%3A2%3A%7Bi%3A0%3Bs%3A18%3A%22_identity-frontend%22%3Bi%3A1%3Bs%3A46%3A%22%5B1%2C%22rYQ0vo5FPmNyxqET7Cbpr3Roh49zQ3uc%22%2C2592000%5D%22%3B%7D; _identity-backend=34f6d76438e79bf758e8b96368c038266b29ab130396524f17588076e229d8e9a%3A2%3A%7Bi%3A0%3Bs%3A17%3A%22_identity-backend%22%3Bi%3A1%3Bs%3A46%3A%22%5B1%2C%22rYQ0vo5FPmNyxqET7Cbpr3Roh49zQ3uc%22%2C2592000%5D%22%3B%7D; _ga=GA1.1.1814254141.1776423672; _ga_BS69MC8NTG=GS2.1.s1776423671$o1$g1$t1776425419$j43$l0$h0; _identity=97c054ec16e84f11b7f990a5cf50cada2326416546fd0095a3b46b9a7e0cefeba%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A28%3A%22%5B%22100%22%2C%22test100key%22%2C2592000%5D%22%3B%7D; advanced-frontend=7uv2l83fnr0pm2dip4jvqn57ad; _csrf-frontend=751483224797985e8f7888b2ed8fcddd229cde5cd8a64052a2d2dcba50d0fad5a%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%22kk66fuQO5P5Vzi4d_-OZ4JwfkLjI8ldD%22%3B%7D; advanced-backend=mgm3td2cs7uo9a57t9clped5t7; _csrf-backend=1221c2b6a7290eb989b646cb9ebdbb4654d837213aba819519f39081a6a0daf9a%3A2%3A%7Bi%3A0%3Bs%3A13%3A%22_csrf-backend%22%3Bi%3A1%3Bs%3A32%3A%22FPVdzMZ22CeJHEUfv30W3BUazH3itEtg%22%3B%7D";s:4:"PATH";s:29:"/usr/bin:/bin:/usr/sbin:/sbin";s:17:"DYLD_LIBRARY_PATH";s:34:"/Applications/XAMPP/xamppfiles/lib";s:16:"SERVER_SIGNATURE";s:0:"";s:15:"SERVER_SOFTWARE";s:74:"Apache/2.4.56 (Unix) OpenSSL/1.1.1t PHP/8.2.4 mod_perl/2.0.12 Perl/v5.34.1";s:11:"SERVER_NAME";s:9:"localhost";s:11:"SERVER_ADDR";s:3:"::1";s:11:"SERVER_PORT";s:2:"80";s:11:"REMOTE_ADDR";s:3:"::1";s:13:"DOCUMENT_ROOT";s:37:"/Applications/XAMPP/xamppfiles/htdocs";s:14:"REQUEST_SCHEME";s:4:"http";s:14:"CONTEXT_PREFIX";s:0:"";s:21:"CONTEXT_DOCUMENT_ROOT";s:37:"/Applications/XAMPP/xamppfiles/htdocs";s:12:"SERVER_ADMIN";s:15:"you@example.com";s:15:"SCRIPT_FILENAME";s:93:"/Applications/XAMPP/xamppfiles/htdocs/bluesky/sjnutrizione/sjnutrizione/backend/web/index.php";s:11:"REMOTE_PORT";s:5:"64575";s:12:"REDIRECT_URL";s:67:"/bluesky/sjnutrizione/sjnutrizione/backend/web/customer-plan/assign";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:67:"/bluesky/sjnutrizione/sjnutrizione/backend/web/customer-plan/assign";s:11:"SCRIPT_NAME";s:56:"/bluesky/sjnutrizione/sjnutrizione/backend/web/index.php";s:8:"PHP_SELF";s:56:"/bluesky/sjnutrizione/sjnutrizione/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1777914805.9696099758148193359375;s:12:"REQUEST_TIME";i:1777914805;}s:3:"GET";a:0:{}s:4:"POST";a:5:{s:13:"_csrf-backend";s:88:"hetslalXm8HQliDgh2UNsl5mAKYoKTzbqEKU_faX2aDDuzrx0xrB8-LVRarPIFjUKFUw8RtrabrSCqeUgtKtxw==";s:11:"customer_id";s:1:"7";s:7:"plan_id";s:1:"1";s:10:"start_date";s:10:"2026-05-04";s:16:"generate_invoice";s:1:"1";}s:6:"COOKIE";a:9:{s:18:"_identity-frontend";s:158:"f04c12c8aaf9d68a5629158a4e1f23fafa39083c0e042d5455d2b41f88d7bcaba:2:{i:0;s:18:"_identity-frontend";i:1;s:46:"[1,"rYQ0vo5FPmNyxqET7Cbpr3Roh49zQ3uc",2592000]";}";s:17:"_identity-backend";s:157:"34f6d76438e79bf758e8b96368c038266b29ab130396524f17588076e229d8e9a:2:{i:0;s:17:"_identity-backend";i:1;s:46:"[1,"rYQ0vo5FPmNyxqET7Cbpr3Roh49zQ3uc",2592000]";}";s:3:"_ga";s:27:"GA1.1.1814254141.1776423672";s:14:"_ga_BS69MC8NTG";s:45:"GS2.1.s1776423671$o1$g1$t1776425419$j43$l0$h0";s:9:"_identity";s:130:"97c054ec16e84f11b7f990a5cf50cada2326416546fd0095a3b46b9a7e0cefeba:2:{i:0;s:9:"_identity";i:1;s:28:"["100","test100key",2592000]";}";s:17:"advanced-frontend";s:26:"7uv2l83fnr0pm2dip4jvqn57ad";s:14:"_csrf-frontend";s:140:"751483224797985e8f7888b2ed8fcddd229cde5cd8a64052a2d2dcba50d0fad5a:2:{i:0;s:14:"_csrf-frontend";i:1;s:32:"kk66fuQO5P5Vzi4d_-OZ4JwfkLjI8ldD";}";s:16:"advanced-backend";s:26:"mgm3td2cs7uo9a57t9clped5t7";s:13:"_csrf-backend";s:139:"1221c2b6a7290eb989b646cb9ebdbb4654d837213aba819519f39081a6a0daf9a:2:{i:0;s:13:"_csrf-backend";i:1;s:32:"FPVdzMZ22CeJHEUfv30W3BUazH3itEtg";}";}s:5:"FILES";a:0:{}s:7:"SESSION";a:4:{s:7:"__flash";a:1:{s:7:"success";i:-1;}s:4:"__id";i:1;s:9:"__authKey";s:32:"rYQ0vo5FPmNyxqET7Cbpr3Roh49zQ3uc";s:7:"success";s:46:"Plan assigned successfully. Invoice generated.";}}";s:4:"user";s:1299:"a:5:{s:2:"id";i:1;s:8:"identity";a:10:{s:2:"id";s:1:"1";s:8:"username";s:7:"'jubin'";s:8:"auth_key";s:34:"'rYQ0vo5FPmNyxqET7Cbpr3Roh49zQ3uc'";s:13:"password_hash";s:62:"'$2y$13$v1E5SbbmMTd.WdqbA8ARO.UUhDTccDqW1bwfUstWx6BJLFZcv5EVK'";s:20:"password_reset_token";s:4:"null";s:5:"email";s:25:"'jubinmathai90@gmail.com'";s:6:"status";s:2:"10";s:10:"created_at";s:10:"1774936979";s:10:"updated_at";s:10:"1774936979";s:18:"verification_token";s:45:"'0f_TQHBsfl0lUzhvQ0xHPct1P5cz4xIX_1774936979'";}s:10:"attributes";a:10:{i:0;a:2:{s:9:"attribute";s:2:"id";s:5:"label";s:2:"Id";}i:1;a:2:{s:9:"attribute";s:8:"username";s:5:"label";s:8:"Username";}i:2;a:2:{s:9:"attribute";s:8:"auth_key";s:5:"label";s:8:"Auth Key";}i:3;a:2:{s:9:"attribute";s:13:"password_hash";s:5:"label";s:13:"Password Hash";}i:4;a:2:{s:9:"attribute";s:20:"password_reset_token";s:5:"label";s:20:"Password Reset Token";}i:5;a:2:{s:9:"attribute";s:5:"email";s:5:"label";s:5:"Email";}i:6;a:2:{s:9:"attribute";s:6:"status";s:5:"label";s:6:"Status";}i:7;a:2:{s:9:"attribute";s:10:"created_at";s:5:"label";s:10:"Created At";}i:8;a:2:{s:9:"attribute";s:10:"updated_at";s:5:"label";s:10:"Updated At";}i:9;a:2:{s:9:"attribute";s:18:"verification_token";s:5:"label";s:18:"Verification Token";}}s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:13:{s:3:"tag";s:13:"69f8d3b60e0fe";s:3:"url";s:83:"http://localhost/bluesky/sjnutrizione/sjnutrizione/backend/web/customer-plan/assign";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:3:"::1";s:4:"time";d:1777914805.9696099758148193359375;s:10:"statusCode";i:302;s:8:"sqlCount";i:32;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:7909688;s:14:"processingTime";d:0.1056249141693115234375;}s:10:"exceptions";a:0:{}}