a:14:{s:6:"config";s:1645:"a:5:{s:10:"phpVersion";s:6:"8.0.30";s:10:"yiiVersion";s:8:"2.0.49.3";s:11:"application";a:8:{s:3:"yii";s:8:"2.0.49.3";s:4:"name";s:14:"My Application";s:7:"version";s:3:"1.0";s:8:"language";s:5:"en-US";s:14:"sourceLanguage";s:5:"en-US";s:7:"charset";s:5:"UTF-8";s:3:"env";s:3:"dev";s:5:"debug";b:1;}s:3:"php";a:5:{s:7:"version";s:6:"8.0.30";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:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/vendor/yiisoft/yii2-faker/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:87:"/home/webprjlw/public_html/devapi.cpbroadcast.com/vendor/yiisoft/yii2-symfonymailer/src";}}s:23:"yiisoft/yii2-bootstrap5";a:4:{s:4:"name";s:23:"yiisoft/yii2-bootstrap5";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap5";s:84:"/home/webprjlw/public_html/devapi.cpbroadcast.com/vendor/yiisoft/yii2-bootstrap5/src";}s:9:"bootstrap";s:40:"yii\bootstrap5\i18n\TranslationBootstrap";}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.2.6.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:77:"/home/webprjlw/public_html/devapi.cpbroadcast.com/vendor/yiisoft/yii2-gii/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.25.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/vendor/yiisoft/yii2-debug/src";}}}}";s:3:"log";s:12109:"a:1:{s:8:"messages";a:23:{i:0;a:6:{i:0;s:68:"Bootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1792563778.8428859710693359375;i:4;a:0:{}i:5;i:2768328;}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:1792563778.84379100799560546875;i:4;a:0:{}i:5;i:2944472;}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:1792563778.8438069820404052734375;i:4;a:0:{}i:5;i:2945272;}i:3;a:6:{i:0;s:44:"Bootstrap with yii\debug\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1792563778.8508970737457275390625;i:4;a:0:{}i:5;i:4107024;}i:4;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1792563778.8537299633026123046875;i:4;a:0:{}i:5;i:4683992;}i:5;a:6:{i:0;s:42:"Bootstrap with yii\gii\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1792563778.8539550304412841796875;i:4;a:0:{}i:5;i:4708888;}i:28;a:6:{i:0;s:37:"Route requested: 'api/marketing/list'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1792563778.8557369709014892578125;i:4;a:0:{}i:5;i:4944784;}i:29;a:6:{i:0;s:19:"Loading module: api";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1792563778.8557450771331787109375;i:4;a:0:{}i:5;i:4946408;}i:30;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `sm_cp`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8642508983612060546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6304992;}i:31;a:6:{i:0;s:64:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_smcp";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1792563778.864304065704345703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6307808;}i:36;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` = 'sm_cp' AND `kcu`.`TABLE_NAME` = 'sm_cp'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.86626911163330078125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6412408;}i:39;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='688a6904574e01ce3c5cff46d120794e') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8689930438995361328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6694032;}i:42;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=148";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.871819019317626953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:144;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6976912;}i:45;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `log_api`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8724238872528076171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7009256;}i:48;a:6:{i:0;s:770:"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` = 'log_api' AND `kcu`.`TABLE_NAME` = 'log_api'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8730781078338623046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7018728;}i:51;a:6:{i:0;s:305:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/mk_list?offer_type=1&page=2&page_count=15', 2, '{\"offer_type\":\"1\",\"page\":\"2\",\"page_count\":\"15\"}', '2026-10-21 11:52:58', 148, '{\"apk_type\":\"Android\",\"apk_version\":\"41\"}')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.8736209869384765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7023640;}i:54;a:6:{i:0;s:32:"Route to run: api/marketing/list";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1792563778.8761680126190185546875;i:4;a:0:{}i:5;i:7184624;}i:55;a:6:{i:0;s:77:"Running action: app\modules\api\controllers\MarketingController::actionList()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1792563778.877316951751708984375;i:4;a:0:{}i:5;i:7320224;}i:56;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='688a6904574e01ce3c5cff46d120794e') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8775279521942138671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:474;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7396920;}i:59;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=148";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.8787019252777099609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:144;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:474;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7409840;}i:62;a:6:{i:0;s:481:"SELECT COUNT(*) FROM `marketing_schedule` LEFT JOIN `marketing_campaign` ON marketing_schedule.campaign_id=marketing_campaign.id LEFT JOIN `projects` ON marketing_campaign.project_id=projects.id LEFT JOIN `location` ON projects.location_id=location.id WHERE marketing_schedule.status=1 AND marketing_campaign.status=1 AND projects.builder_id IN(90) AND marketing_schedule.offer_type IN(1) AND DATE("2026-10-21") BETWEEN marketing_campaign.start_date AND marketing_campaign.end_date";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8932759761810302734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:11931;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:491;s:8:"function";s:16:"getmarketlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9284192;}i:65;a:6:{i:0;s:1027:"SELECT `marketing_schedule`.`id`, `marketing_schedule`.`campaign_id`, `projects`.`name` AS `projectname`, `marketing_campaign`.`project_id`, `marketing_campaign`.`start_date`, `marketing_campaign`.`end_date`, `marketing_schedule`.`created_on`, `marketing_schedule`.`website`, `marketing_schedule`.`name` AS `title`, `marketing_schedule`.`brief` AS `schedule_brief`, `marketing_campaign`.`feedback` AS `campaign_feedback`, `location`.`name` AS `location_name`, `marketing_schedule`.`offer_type` FROM `marketing_schedule` LEFT JOIN `marketing_campaign` ON marketing_schedule.campaign_id=marketing_campaign.id LEFT JOIN `projects` ON marketing_campaign.project_id=projects.id LEFT JOIN `location` ON projects.location_id=location.id WHERE marketing_schedule.status=1 AND marketing_campaign.status=1 AND projects.builder_id IN(90) AND marketing_schedule.offer_type IN(1) AND DATE("2026-10-21") BETWEEN marketing_campaign.start_date AND marketing_campaign.end_date ORDER BY `marketing_schedule`.`modified_on` DESC LIMIT 15 OFFSET 15";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8940670490264892578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:11938;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:491;s:8:"function";s:16:"getmarketlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9301504;}i:68;a:6:{i:0;s:104:"Access to debugger is denied due to IP address restriction. The requesting IP address is 106.222.252.244";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1792563778.8951270580291748046875;i:4;a:0:{}i:5;i:9335272;}}}";s:9:"profiling";s:20283:"a:3:{s:6:"memory";i:12253400;s:4:"time";d:0.0637509822845458984375;s:8:"messages";a:24:{i:32;a:6:{i:0;s:64:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_smcp";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1792563778.8643128871917724609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6309312;}i:33;a:6:{i:0;s:64:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_smcp";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1792563778.8648059368133544921875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6356120;}i:34;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `sm_cp`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8648281097412109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6356720;}i:35;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `sm_cp`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8657009601593017578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6415256;}i:37;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` = 'sm_cp' AND `kcu`.`TABLE_NAME` = 'sm_cp'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.866303920745849609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6415648;}i:38;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` = 'sm_cp' AND `kcu`.`TABLE_NAME` = 'sm_cp'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8667480945587158203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6418232;}i:40;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='688a6904574e01ce3c5cff46d120794e') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8690140247344970703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6695208;}i:41;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='688a6904574e01ce3c5cff46d120794e') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.86985111236572265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6704312;}i:43;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=148";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.871840000152587890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:144;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6978504;}i:44;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=148";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.8720700740814208984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:144;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6980128;}i:46;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `log_api`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.87244510650634765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7010624;}i:47;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `log_api`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.87296009063720703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7019232;}i:49;a:6:{i:0;s:770:"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` = 'log_api' AND `kcu`.`TABLE_NAME` = 'log_api'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8730928897857666015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7021592;}i:50;a:6:{i:0;s:770:"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` = 'log_api' AND `kcu`.`TABLE_NAME` = 'log_api'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8734200000762939453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7023800;}i:52;a:6:{i:0;s:305:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/mk_list?offer_type=1&page=2&page_count=15', 2, '{\"offer_type\":\"1\",\"page\":\"2\",\"page_count\":\"15\"}', '2026-10-21 11:52:58', 148, '{\"apk_type\":\"Android\",\"apk_version\":\"41\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.8736340999603271484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7023992;}i:53;a:6:{i:0;s:305:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/mk_list?offer_type=1&page=2&page_count=15', 2, '{\"offer_type\":\"1\",\"page\":\"2\",\"page_count\":\"15\"}', '2026-10-21 11:52:58', 148, '{\"apk_type\":\"Android\",\"apk_version\":\"41\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.8744161128997802734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7025512;}i:57;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='688a6904574e01ce3c5cff46d120794e') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8775451183319091796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:474;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7398096;}i:58;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='688a6904574e01ce3c5cff46d120794e') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.878386020660400390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:474;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7405480;}i:60;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=148";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.878715991973876953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:144;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:474;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7411432;}i:61;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=148";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.8788979053497314453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:144;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:474;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7413056;}i:63;a:6:{i:0;s:481:"SELECT COUNT(*) FROM `marketing_schedule` LEFT JOIN `marketing_campaign` ON marketing_schedule.campaign_id=marketing_campaign.id LEFT JOIN `projects` ON marketing_campaign.project_id=projects.id LEFT JOIN `location` ON projects.location_id=location.id WHERE marketing_schedule.status=1 AND marketing_campaign.status=1 AND projects.builder_id IN(90) AND marketing_schedule.offer_type IN(1) AND DATE("2026-10-21") BETWEEN marketing_campaign.start_date AND marketing_campaign.end_date";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8933250904083251953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:11931;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:491;s:8:"function";s:16:"getmarketlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9286856;}i:64;a:6:{i:0;s:481:"SELECT COUNT(*) FROM `marketing_schedule` LEFT JOIN `marketing_campaign` ON marketing_schedule.campaign_id=marketing_campaign.id LEFT JOIN `projects` ON marketing_campaign.project_id=projects.id LEFT JOIN `location` ON projects.location_id=location.id WHERE marketing_schedule.status=1 AND marketing_campaign.status=1 AND projects.builder_id IN(90) AND marketing_schedule.offer_type IN(1) AND DATE("2026-10-21") BETWEEN marketing_campaign.start_date AND marketing_campaign.end_date";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8939440250396728515625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:11931;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:491;s:8:"function";s:16:"getmarketlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9288416;}i:66;a:6:{i:0;s:1027:"SELECT `marketing_schedule`.`id`, `marketing_schedule`.`campaign_id`, `projects`.`name` AS `projectname`, `marketing_campaign`.`project_id`, `marketing_campaign`.`start_date`, `marketing_campaign`.`end_date`, `marketing_schedule`.`created_on`, `marketing_schedule`.`website`, `marketing_schedule`.`name` AS `title`, `marketing_schedule`.`brief` AS `schedule_brief`, `marketing_campaign`.`feedback` AS `campaign_feedback`, `location`.`name` AS `location_name`, `marketing_schedule`.`offer_type` FROM `marketing_schedule` LEFT JOIN `marketing_campaign` ON marketing_schedule.campaign_id=marketing_campaign.id LEFT JOIN `projects` ON marketing_campaign.project_id=projects.id LEFT JOIN `location` ON projects.location_id=location.id WHERE marketing_schedule.status=1 AND marketing_campaign.status=1 AND projects.builder_id IN(90) AND marketing_schedule.offer_type IN(1) AND DATE("2026-10-21") BETWEEN marketing_campaign.start_date AND marketing_campaign.end_date ORDER BY `marketing_schedule`.`modified_on` DESC LIMIT 15 OFFSET 15";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.89408111572265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:11938;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:491;s:8:"function";s:16:"getmarketlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9305704;}i:67;a:6:{i:0;s:1027:"SELECT `marketing_schedule`.`id`, `marketing_schedule`.`campaign_id`, `projects`.`name` AS `projectname`, `marketing_campaign`.`project_id`, `marketing_campaign`.`start_date`, `marketing_campaign`.`end_date`, `marketing_schedule`.`created_on`, `marketing_schedule`.`website`, `marketing_schedule`.`name` AS `title`, `marketing_schedule`.`brief` AS `schedule_brief`, `marketing_campaign`.`feedback` AS `campaign_feedback`, `location`.`name` AS `location_name`, `marketing_schedule`.`offer_type` FROM `marketing_schedule` LEFT JOIN `marketing_campaign` ON marketing_schedule.campaign_id=marketing_campaign.id LEFT JOIN `projects` ON marketing_campaign.project_id=projects.id LEFT JOIN `location` ON projects.location_id=location.id WHERE marketing_schedule.status=1 AND marketing_campaign.status=1 AND projects.builder_id IN(90) AND marketing_schedule.offer_type IN(1) AND DATE("2026-10-21") BETWEEN marketing_campaign.start_date AND marketing_campaign.end_date ORDER BY `marketing_schedule`.`modified_on` DESC LIMIT 15 OFFSET 15";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8945140838623046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:11938;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:491;s:8:"function";s:16:"getmarketlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9307744;}}}";s:2:"db";s:18939:"a:1:{s:8:"messages";a:22:{i:34;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `sm_cp`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8648281097412109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6356720;}i:35;a:6:{i:0;s:30:"SHOW FULL COLUMNS FROM `sm_cp`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8657009601593017578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6415256;}i:37;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` = 'sm_cp' AND `kcu`.`TABLE_NAME` = 'sm_cp'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.866303920745849609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6415648;}i:38;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` = 'sm_cp' AND `kcu`.`TABLE_NAME` = 'sm_cp'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8667480945587158203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6418232;}i:40;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='688a6904574e01ce3c5cff46d120794e') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8690140247344970703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6695208;}i:41;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='688a6904574e01ce3c5cff46d120794e') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.86985111236572265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6704312;}i:43;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=148";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.871840000152587890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:144;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6978504;}i:44;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=148";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.8720700740814208984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:144;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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6980128;}i:46;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `log_api`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.87244510650634765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7010624;}i:47;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `log_api`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.87296009063720703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7019232;}i:49;a:6:{i:0;s:770:"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` = 'log_api' AND `kcu`.`TABLE_NAME` = 'log_api'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8730928897857666015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7021592;}i:50;a:6:{i:0;s:770:"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` = 'log_api' AND `kcu`.`TABLE_NAME` = 'log_api'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8734200000762939453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7023800;}i:52;a:6:{i:0;s:305:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/mk_list?offer_type=1&page=2&page_count=15', 2, '{\"offer_type\":\"1\",\"page\":\"2\",\"page_count\":\"15\"}', '2026-10-21 11:52:58', 148, '{\"apk_type\":\"Android\",\"apk_version\":\"41\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.8736340999603271484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7023992;}i:53;a:6:{i:0;s:305:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/mk_list?offer_type=1&page=2&page_count=15', 2, '{\"offer_type\":\"1\",\"page\":\"2\",\"page_count\":\"15\"}', '2026-10-21 11:52:58', 148, '{\"apk_type\":\"Android\",\"apk_version\":\"41\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.8744161128997802734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7025512;}i:57;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='688a6904574e01ce3c5cff46d120794e') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8775451183319091796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:474;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7398096;}i:58;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='688a6904574e01ce3c5cff46d120794e') AND (`status`=1) AND (`is_logged`=1) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.878386020660400390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:127;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:474;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7405480;}i:60;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=148";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.878715991973876953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:144;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:474;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7411432;}i:61;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=148";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1792563778.8788979053497314453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:144;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:474;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7413056;}i:63;a:6:{i:0;s:481:"SELECT COUNT(*) FROM `marketing_schedule` LEFT JOIN `marketing_campaign` ON marketing_schedule.campaign_id=marketing_campaign.id LEFT JOIN `projects` ON marketing_campaign.project_id=projects.id LEFT JOIN `location` ON projects.location_id=location.id WHERE marketing_schedule.status=1 AND marketing_campaign.status=1 AND projects.builder_id IN(90) AND marketing_schedule.offer_type IN(1) AND DATE("2026-10-21") BETWEEN marketing_campaign.start_date AND marketing_campaign.end_date";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8933250904083251953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:11931;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:491;s:8:"function";s:16:"getmarketlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9286856;}i:64;a:6:{i:0;s:481:"SELECT COUNT(*) FROM `marketing_schedule` LEFT JOIN `marketing_campaign` ON marketing_schedule.campaign_id=marketing_campaign.id LEFT JOIN `projects` ON marketing_campaign.project_id=projects.id LEFT JOIN `location` ON projects.location_id=location.id WHERE marketing_schedule.status=1 AND marketing_campaign.status=1 AND projects.builder_id IN(90) AND marketing_schedule.offer_type IN(1) AND DATE("2026-10-21") BETWEEN marketing_campaign.start_date AND marketing_campaign.end_date";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8939440250396728515625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:11931;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:491;s:8:"function";s:16:"getmarketlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9288416;}i:66;a:6:{i:0;s:1027:"SELECT `marketing_schedule`.`id`, `marketing_schedule`.`campaign_id`, `projects`.`name` AS `projectname`, `marketing_campaign`.`project_id`, `marketing_campaign`.`start_date`, `marketing_campaign`.`end_date`, `marketing_schedule`.`created_on`, `marketing_schedule`.`website`, `marketing_schedule`.`name` AS `title`, `marketing_schedule`.`brief` AS `schedule_brief`, `marketing_campaign`.`feedback` AS `campaign_feedback`, `location`.`name` AS `location_name`, `marketing_schedule`.`offer_type` FROM `marketing_schedule` LEFT JOIN `marketing_campaign` ON marketing_schedule.campaign_id=marketing_campaign.id LEFT JOIN `projects` ON marketing_campaign.project_id=projects.id LEFT JOIN `location` ON projects.location_id=location.id WHERE marketing_schedule.status=1 AND marketing_campaign.status=1 AND projects.builder_id IN(90) AND marketing_schedule.offer_type IN(1) AND DATE("2026-10-21") BETWEEN marketing_campaign.start_date AND marketing_campaign.end_date ORDER BY `marketing_schedule`.`modified_on` DESC LIMIT 15 OFFSET 15";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.89408111572265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:11938;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:491;s:8:"function";s:16:"getmarketlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9305704;}i:67;a:6:{i:0;s:1027:"SELECT `marketing_schedule`.`id`, `marketing_schedule`.`campaign_id`, `projects`.`name` AS `projectname`, `marketing_campaign`.`project_id`, `marketing_campaign`.`start_date`, `marketing_campaign`.`end_date`, `marketing_schedule`.`created_on`, `marketing_schedule`.`website`, `marketing_schedule`.`name` AS `title`, `marketing_schedule`.`brief` AS `schedule_brief`, `marketing_campaign`.`feedback` AS `campaign_feedback`, `location`.`name` AS `location_name`, `marketing_schedule`.`offer_type` FROM `marketing_schedule` LEFT JOIN `marketing_campaign` ON marketing_schedule.campaign_id=marketing_campaign.id LEFT JOIN `projects` ON marketing_campaign.project_id=projects.id LEFT JOIN `location` ON projects.location_id=location.id WHERE marketing_schedule.status=1 AND marketing_campaign.status=1 AND projects.builder_id IN(90) AND marketing_schedule.offer_type IN(1) AND DATE("2026-10-21") BETWEEN marketing_campaign.start_date AND marketing_campaign.end_date ORDER BY `marketing_schedule`.`modified_on` DESC LIMIT 15 OFFSET 15";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792563778.8945140838623046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:11938;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/MarketingController.php";s:4:"line";i:491;s:8:"function";s:16:"getmarketlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9307744;}}}";s:5:"event";s:6115:"a:32:{i:0;a:5:{s:4:"time";d:1792563778.8554248809814453125;s:4:"name";s:13:"beforeRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:1;a:5:{s:4:"time";d:1792563778.861712932586669921875;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:2;a:5:{s:4:"time";d:1792563778.864799022674560546875;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:3;a:5:{s:4:"time";d:1792563778.86989307403564453125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:4;a:5:{s:4:"time";d:1792563778.8699491024017333984375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:5;a:5:{s:4:"time";d:1792563778.870026111602783203125;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:6;a:5:{s:4:"time";d:1792563778.8717250823974609375;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:7;a:5:{s:4:"time";d:1792563778.871737003326416015625;s:4:"name";s:12:"beforeUpdate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:8;a:5:{s:4:"time";d:1792563778.8721549510955810546875;s:4:"name";s:11:"afterUpdate";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:9;a:5:{s:4:"time";d:1792563778.872251987457275390625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\LogApi";}i:10;a:5:{s:4:"time";d:1792563778.8734691143035888671875;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\LogApi";}i:11;a:5:{s:4:"time";d:1792563778.873538970947265625;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\LogApi";}i:12;a:5:{s:4:"time";d:1792563778.873548030853271484375;s:4:"name";s:12:"beforeInsert";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\LogApi";}i:13;a:5:{s:4:"time";d:1792563778.8744699954986572265625;s:4:"name";s:11:"afterInsert";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\LogApi";}i:14;a:5:{s:4:"time";d:1792563778.87623500823974609375;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:15;a:5:{s:4:"time";d:1792563778.876243114471435546875;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\modules\api\ApiModule";}i:16;a:5:{s:4:"time";d:1792563778.8773019313812255859375;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:47:"app\modules\api\controllers\MarketingController";}i:17;a:5:{s:4:"time";d:1792563778.8773479461669921875;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:1792563778.87843608856201171875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:19;a:5:{s:4:"time";d:1792563778.8784830570220947265625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:20;a:5:{s:4:"time";d:1792563778.8784999847412109375;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:21;a:5:{s:4:"time";d:1792563778.8786370754241943359375;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:22;a:5:{s:4:"time";d:1792563778.87864398956298828125;s:4:"name";s:12:"beforeUpdate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:23;a:5:{s:4:"time";d:1792563778.8789269924163818359375;s:4:"name";s:11:"afterUpdate";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:24;a:5:{s:4:"time";d:1792563778.893086910247802734375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Common";}i:25;a:5:{s:4:"time";d:1792563778.894568920135498046875;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:47:"app\modules\api\controllers\MarketingController";}i:26;a:5:{s:4:"time";d:1792563778.89457988739013671875;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\modules\api\ApiModule";}i:27;a:5:{s:4:"time";d:1792563778.894586086273193359375;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:28;a:5:{s:4:"time";d:1792563778.894596099853515625;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:29;a:5:{s:4:"time";d:1792563778.8946020603179931640625;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:30;a:5:{s:4:"time";d:1792563778.8951389789581298828125;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:31;a:5:{s:4:"time";d:1792563778.8951709270477294921875;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:120:"a:3:{s:5:"start";d:1792563778.8331699371337890625;s:3:"end";d:1792563778.897039890289306640625;s:6:"memory";i:12253400;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:4474:"a:3:{s:8:"messages";a:22:{i:6;a:6:{i:0;a:3:{s:4:"rule";s:3:"gii";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.8556520938873291015625;i:4;a:0:{}i:5;i:4928280;}i:7;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:1792563778.8556649684906005859375;i:4;a:0:{}i:5;i:4929032;}i:8;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:1792563778.85566997528076171875;i:4;a:0:{}i:5;i:4929784;}i:9;a:6:{i:0;a:3:{s:4:"rule";s:5:"debug";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.8556740283966064453125;i:4;a:0:{}i:5;i:4930856;}i:10;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:1792563778.855678081512451171875;i:4;a:0:{}i:5;i:4931608;}i:11;a:6:{i:0;a:3:{s:4:"rule";s:12:"cp_getbyrera";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.855681896209716796875;i:4;a:0:{}i:5;i:4932360;}i:12;a:6:{i:0;a:3:{s:4:"rule";s:11:"cp_createcp";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.8556840419769287109375;i:4;a:0:{}i:5;i:4933112;}i:13;a:6:{i:0;a:3:{s:4:"rule";s:11:"showcontact";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.8556869029998779296875;i:4;a:0:{}i:5;i:4933864;}i:14;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_create";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.85569000244140625;i:4;a:0:{}i:5;i:4934616;}i:15;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_detail";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.8556931018829345703125;i:4;a:0:{}i:5;i:4935368;}i:16;a:6:{i:0;a:3:{s:4:"rule";s:8:"ld_stats";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.8556959629058837890625;i:4;a:0:{}i:5;i:4936120;}i:17;a:6:{i:0;a:3:{s:4:"rule";s:7:"ld_list";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.855699062347412109375;i:4;a:0:{}i:5;i:4937512;}i:18;a:6:{i:0;a:3:{s:4:"rule";s:11:"ld_listname";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.855701923370361328125;i:4;a:0:{}i:5;i:4938264;}i:19;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_update";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.8557050228118896484375;i:4;a:0:{}i:5;i:4939016;}i:20;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_delete";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.8557078838348388671875;i:4;a:0:{}i:5;i:4939768;}i:21;a:6:{i:0;a:3:{s:4:"rule";s:11:"ld_feedback";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.8557109832763671875;i:4;a:0:{}i:5;i:4940520;}i:22;a:6:{i:0;a:3:{s:4:"rule";s:10:"ld_monthly";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.8557140827178955078125;i:4;a:0:{}i:5;i:4941272;}i:23;a:6:{i:0;a:3:{s:4:"rule";s:8:"loc_list";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.8557159900665283203125;i:4;a:0:{}i:5;i:4942024;}i:24;a:6:{i:0;a:3:{s:4:"rule";s:11:"locsub_list";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.855719089508056640625;i:4;a:0:{}i:5;i:4942776;}i:25;a:6:{i:0;a:3:{s:4:"rule";s:12:"locationlist";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.855720996856689453125;i:4;a:0:{}i:5;i:4943528;}i:26;a:6:{i:0;s:37:"Request parsed with URL rule: mk_list";i:1;i:8;i:2;s:29:"yii\web\UrlRule::parseRequest";i:3;d:1792563778.8557269573211669921875;i:4;a:0:{}i:5;i:4944784;}i:27;a:6:{i:0;a:3:{s:4:"rule";s:7:"mk_list";s:5:"match";b:1;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1792563778.8557300567626953125;i:4;a:0:{}i:5;i:4945096;}}s:5:"route";s:18:"api/marketing/list";s:6:"action";s:61:"app\modules\api\controllers\MarketingController::actionList()";}";s:7:"request";s:3107:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:7:{s:10:"user-agent";s:13:"okhttp/4.10.0";s:15:"accept-encoding";s:4:"gzip";s:10:"connection";s:10:"Keep-Alive";s:4:"host";s:22:"devapi.cpbroadcast.com";s:7:"version";s:2:"41";s:11:"channeltype";s:7:"Android";s:6:"apikey";s:32:"688a6904574e01ce3c5cff46d120794e";}s:15:"responseHeaders";a:1:{s:12:"Content-Type";s:31:"application/json; charset=UTF-8";}s:5:"route";s:18:"api/marketing/list";s:6:"action";s:61:"app\modules\api\controllers\MarketingController::actionList()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:3:"GET";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:1;}s:11:"requestBody";a:0:{}s:6:"SERVER";a:45:{s:4:"USER";s:8:"webprjlw";s:4:"HOME";s:14:"/home/webprjlw";s:11:"SCRIPT_NAME";s:22:"/backend/web/index.php";s:11:"REQUEST_URI";s:54:"/backend/web/mk_list?offer_type=1&page=2&page_count=15";s:12:"QUERY_STRING";s:33:"offer_type=1&page=2&page_count=15";s:14:"REQUEST_METHOD";s:3:"GET";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:21:"REDIRECT_QUERY_STRING";s:33:"offer_type=1&page=2&page_count=15";s:12:"REDIRECT_URL";s:20:"/backend/web/mk_list";s:11:"REMOTE_PORT";s:5:"52302";s:15:"SCRIPT_FILENAME";s:71:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/web/index.php";s:12:"SERVER_ADMIN";s:32:"webmaster@devapi.cpbroadcast.com";s:21:"CONTEXT_DOCUMENT_ROOT";s:49:"/home/webprjlw/public_html/devapi.cpbroadcast.com";s:14:"CONTEXT_PREFIX";s:0:"";s:14:"REQUEST_SCHEME";s:5:"https";s:13:"DOCUMENT_ROOT";s:49:"/home/webprjlw/public_html/devapi.cpbroadcast.com";s:11:"REMOTE_ADDR";s:15:"106.222.252.244";s:11:"SERVER_PORT";s:3:"443";s:11:"SERVER_ADDR";s:13:"65.254.80.108";s:11:"SERVER_NAME";s:22:"devapi.cpbroadcast.com";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:16:"SERVER_SIGNATURE";s:0:"";s:4:"PATH";s:180:"/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin";s:15:"HTTP_USER_AGENT";s:13:"okhttp/4.10.0";s:20:"HTTP_ACCEPT_ENCODING";s:4:"gzip";s:15:"HTTP_CONNECTION";s:10:"Keep-Alive";s:9:"HTTP_HOST";s:22:"devapi.cpbroadcast.com";s:12:"HTTP_VERSION";s:2:"41";s:16:"HTTP_CHANNELTYPE";s:7:"Android";s:11:"HTTP_APIKEY";s:32:"688a6904574e01ce3c5cff46d120794e";s:17:"proxy-nokeepalive";s:1:"1";s:11:"SSL_TLS_SNI";s:22:"devapi.cpbroadcast.com";s:5:"HTTPS";s:2:"on";s:9:"UNIQUE_ID";s:27:"athaQha6OBs7dw6NVy-iCwAAAGY";s:15:"REDIRECT_STATUS";s:3:"200";s:20:"REDIRECT_SSL_TLS_SNI";s:22:"devapi.cpbroadcast.com";s:14:"REDIRECT_HTTPS";s:2:"on";s:18:"REDIRECT_UNIQUE_ID";s:27:"athaQha6OBs7dw6NVy-iCwAAAGY";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:22:"/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1792563778.8269519805908203125;s:12:"REQUEST_TIME";i:1792563778;s:4:"argv";a:1:{i:0;s:33:"offer_type=1&page=2&page_count=15";}s:4:"argc";i:1;}s:3:"GET";a:3:{s:10:"offer_type";s:1:"1";s:4:"page";s:1:"2";s:10:"page_count";s:2:"15";}s:4:"POST";a:0:{}s:6:"COOKIE";a:0:{}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}";s:4:"user";s:2:"N;";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:13:{s:3:"tag";s:13:"6ad85a42cfd31";s:3:"url";s:84:"https://devapi.cpbroadcast.com/backend/web/mk_list?offer_type=1&page=2&page_count=15";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:15:"106.222.252.244";s:4:"time";d:1792563778.8269519805908203125;s:10:"statusCode";i:200;s:8:"sqlCount";i:11;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:12253400;s:14:"processingTime";d:0.0637509822845458984375;}s:10:"exceptions";a:0:{}}