a:14:{s:6:"config";s:1630:"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:76:"/home/webprjlw/public_html/api.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:84:"/home/webprjlw/public_html/api.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:81:"/home/webprjlw/public_html/api.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:74:"/home/webprjlw/public_html/api.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:76:"/home/webprjlw/public_html/api.cpbroadcast.com/vendor/yiisoft/yii2-debug/src";}}}}";s:3:"log";s:17016:"a:1:{s:8:"messages";a:30:{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:1780672417.14702701568603515625;i:4;a:0:{}i:5;i:2756624;}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:1780672417.1479508876800537109375;i:4;a:0:{}i:5;i:2932736;}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:1780672417.147964000701904296875;i:4;a:0:{}i:5;i:2933536;}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:1780672417.155735015869140625;i:4;a:0:{}i:5;i:4095160;}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:1780672417.158999919891357421875;i:4;a:0:{}i:5;i:4659208;}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:1780672417.15923309326171875;i:4;a:0:{}i:5;i:4684072;}i:17;a:6:{i:0;s:33:"Route requested: 'api/lead/stats'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1780672417.1614339351654052734375;i:4;a:0:{}i:5;i:4911384;}i:18;a:6:{i:0;s:19:"Loading module: api";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1780672417.161446094512939453125;i:4;a:0:{}i:5;i:4913008;}i:19;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:1780672417.1707479953765869140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6266816;}i:20;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_cpbroadcast_smcp";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1780672417.1707820892333984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6269648;}i:25;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:1780672417.173346996307373046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6366120;}i:28;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='2d8457f931e99e6e9a792e356a016960') 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:1780672417.1766359806060791015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6647016;}i:31;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=178";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.1896679401397705078125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6929216;}i:34;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:1780672417.190310001373291015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6962840;}i:37;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:1780672417.1910059452056884765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6972312;}i:40;a:6:{i:0;s:215:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/ld_stats', 2, '[]', '2026-06-05 20:43:37', 178, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.1915171146392822265625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:6977096;}i:43;a:6:{i:0;s:28:"Route to run: api/lead/stats";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1780672417.195416927337646484375;i:4;a:0:{}i:5;i:7246848;}i:44;a:6:{i:0;s:73:"Running action: app\modules\api\controllers\LeadController::actionStats()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1780672417.196650028228759765625;i:4;a:0:{}i:5;i:7447968;}i:45;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='2d8457f931e99e6e9a792e356a016960') 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:1780672417.1968219280242919921875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:302;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7459128;}i:48;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=178";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.2078189849853515625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:302;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7471976;}i:51;a:6:{i:0;s:65:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=178) AND (`is_deleted`=0)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.222321033477783203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:605;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8674;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9049136;}i:54;a:6:{i:0;s:342:"SELECT `sm_cp1`.`sm_cp_id` FROM `sm_cp` `sm_cp1` LEFT JOIN `sm_cp` `sm_cp2` ON sm_cp1.parent_id=sm_cp2.sm_cp_id AND sm_cp2.is_deleted=0 LEFT JOIN `sm_cp` `sm_cp3` ON sm_cp2.parent_id=sm_cp3.sm_cp_id AND sm_cp3.is_deleted=0 WHERE ((178 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=178) AND sm_cp1.is_deleted=0";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.222930908203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:616;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:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8674;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9055840;}i:57;a:6:{i:0;s:397:"SELECT SUM(IF(1, 1, 0)) AS total, SUM(IF((leadmaster.followup_date>='2026-06-05'), 1, 0)) AS followup,SUM(IF((leadmaster.followup_date='2026-06-05' ), 1, 0)) AS today,SUM(IF((leadmaster.followup_date<'2026-06-05'), 1, 0)) AS missed,SUM(IF((DATE(leadmaster.created_on)='2026-06-05' ), 1, 0)) AS fresh FROM leadmaster where leadmaster.created_by IN(179,180,349,879,178) AND leadmaster.is_deleted=0 ";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.23344707489013671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8684;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9058560;}i:60;a:6:{i:0;s:45:"SELECT * FROM `channelpartner` WHERE `id`=558";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2734849452972412109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9105384;}i:63;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `channelpartner`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.273992061614990234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9124896;}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` = 'channelpartner' AND `kcu`.`TABLE_NAME` = 'channelpartner'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2753570079803466796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9182040;}i:69;a:6:{i:0;s:51:"SELECT COUNT(*) FROM `leadmaster` WHERE cp_id='558'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.27587604522705078125;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8698;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9181272;}i:72;a:6:{i:0;s:91:"SELECT * FROM `sm_cp` WHERE (`channelpartner_id`=558) AND (`status`=1) AND (`is_deleted`=0)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2770340442657470703125;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:1982;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8701;s:8:"function";s:11:"getsmcpteam";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9191960;}i:75;a:6:{i:0;s:184:"SELECT `banner`, `name`, `location_id`, `market_category` FROM `package_banners` WHERE ((`status`=1) AND (`type`=2)) AND (`start_date` <= '2026-06-05') AND (`end_date` >= '2026-06-05')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.278317928314208984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8737;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9246416;}i:78;a:6:{i:0;s:102:"Access to debugger is denied due to IP address restriction. The requesting IP address is 114.79.136.87";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1780672417.2798120975494384765625;i:4;a:0:{}i:5;i:9268320;}}}";s:9:"profiling";s:30158:"a:3:{s:6:"memory";i:11366144;s:4:"time";d:0.1475861072540283203125;s:8:"messages";a:38:{i:21;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_cpbroadcast_smcp";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1780672417.1707909107208251953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6271152;}i:22;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_cpbroadcast_smcp";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1780672417.1716930866241455078125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6316736;}i:23;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:1780672417.171720027923583984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6317336;}i:24;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:1780672417.1727809906005859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6360312;}i:26;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:1780672417.173369884490966796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6369360;}i:27;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:1780672417.17401409149169921875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6371944;}i:29;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='2d8457f931e99e6e9a792e356a016960') 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:1780672417.1766579151153564453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6648192;}i:30;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='2d8457f931e99e6e9a792e356a016960') 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:1780672417.187550067901611328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6656056;}i:32;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=178";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.1896879673004150390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6930808;}i:33;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=178";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.18999195098876953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6933712;}i:35;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:1780672417.1903460025787353515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6964208;}i:36;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:1780672417.1908929347991943359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6972816;}i:38;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:1780672417.191020965576171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6975176;}i:39;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:1780672417.191318988800048828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6977384;}i:41;a:6:{i:0;s:215:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/ld_stats', 2, '[]', '2026-06-05 20:43:37', 178, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.1915600299835205078125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:6977448;}i:42;a:6:{i:0;s:215:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/ld_stats', 2, '[]', '2026-06-05 20:43:37', 178, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.19235897064208984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:6978840;}i:46;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='2d8457f931e99e6e9a792e356a016960') 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:1780672417.196836948394775390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:302;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7460304;}i:47;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='2d8457f931e99e6e9a792e356a016960') 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:1780672417.207489013671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:302;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7467040;}i:49;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=178";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.2078340053558349609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:302;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7473568;}i:50;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=178";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.2080230712890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:302;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7475192;}i:52;a:6:{i:0;s:65:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=178) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.222354888916015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:605;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8674;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9051120;}i:53;a:6:{i:0;s:65:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=178) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2226779460906982421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:605;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8674;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9058104;}i:55;a:6:{i:0;s:342:"SELECT `sm_cp1`.`sm_cp_id` FROM `sm_cp` `sm_cp1` LEFT JOIN `sm_cp` `sm_cp2` ON sm_cp1.parent_id=sm_cp2.sm_cp_id AND sm_cp2.is_deleted=0 LEFT JOIN `sm_cp` `sm_cp3` ON sm_cp2.parent_id=sm_cp3.sm_cp_id AND sm_cp3.is_deleted=0 WHERE ((178 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=178) AND sm_cp1.is_deleted=0";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2229449748992919921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:616;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:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8674;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9058624;}i:56;a:6:{i:0;s:342:"SELECT `sm_cp1`.`sm_cp_id` FROM `sm_cp` `sm_cp1` LEFT JOIN `sm_cp` `sm_cp2` ON sm_cp1.parent_id=sm_cp2.sm_cp_id AND sm_cp2.is_deleted=0 LEFT JOIN `sm_cp` `sm_cp3` ON sm_cp2.parent_id=sm_cp3.sm_cp_id AND sm_cp3.is_deleted=0 WHERE ((178 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=178) AND sm_cp1.is_deleted=0";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.233375072479248046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:616;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:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8674;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9062544;}i:58;a:6:{i:0;s:397:"SELECT SUM(IF(1, 1, 0)) AS total, SUM(IF((leadmaster.followup_date>='2026-06-05'), 1, 0)) AS followup,SUM(IF((leadmaster.followup_date='2026-06-05' ), 1, 0)) AS today,SUM(IF((leadmaster.followup_date<'2026-06-05'), 1, 0)) AS missed,SUM(IF((DATE(leadmaster.created_on)='2026-06-05' ), 1, 0)) AS fresh FROM leadmaster where leadmaster.created_by IN(179,180,349,879,178) AND leadmaster.is_deleted=0 ";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.233460903167724609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8684;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9061096;}i:59;a:6:{i:0;s:397:"SELECT SUM(IF(1, 1, 0)) AS total, SUM(IF((leadmaster.followup_date>='2026-06-05'), 1, 0)) AS followup,SUM(IF((leadmaster.followup_date='2026-06-05' ), 1, 0)) AS today,SUM(IF((leadmaster.followup_date<'2026-06-05'), 1, 0)) AS missed,SUM(IF((DATE(leadmaster.created_on)='2026-06-05' ), 1, 0)) AS fresh FROM leadmaster where leadmaster.created_by IN(179,180,349,879,178) AND leadmaster.is_deleted=0 ";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2730159759521484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8684;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9063808;}i:61;a:6:{i:0;s:45:"SELECT * FROM `channelpartner` WHERE `id`=558";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2735080718994140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9107208;}i:62;a:6:{i:0;s:45:"SELECT * FROM `channelpartner` WHERE `id`=558";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2739059925079345703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9123064;}i:64;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `channelpartner`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2740089893341064453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9126640;}i:65;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `channelpartner`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2748320102691650390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9214632;}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` = 'channelpartner' AND `kcu`.`TABLE_NAME` = 'channelpartner'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2753849029541015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9185280;}i:68;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` = 'channelpartner' AND `kcu`.`TABLE_NAME` = 'channelpartner'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2757160663604736328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9187864;}i:70;a:6:{i:0;s:51:"SELECT COUNT(*) FROM `leadmaster` WHERE cp_id='558'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.275888919830322265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8698;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9183048;}i:71;a:6:{i:0;s:51:"SELECT COUNT(*) FROM `leadmaster` WHERE cp_id='558'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.27684497833251953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8698;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9184656;}i:73;a:6:{i:0;s:91:"SELECT * FROM `sm_cp` WHERE (`channelpartner_id`=558) AND (`status`=1) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.27704906463623046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:1982;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8701;s:8:"function";s:11:"getsmcpteam";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9193104;}i:74;a:6:{i:0;s:91:"SELECT * FROM `sm_cp` WHERE (`channelpartner_id`=558) AND (`status`=1) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2773959636688232421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:1982;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8701;s:8:"function";s:11:"getsmcpteam";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9215856;}i:76;a:6:{i:0;s:184:"SELECT `banner`, `name`, `location_id`, `market_category` FROM `package_banners` WHERE ((`status`=1) AND (`type`=2)) AND (`start_date` <= '2026-06-05') AND (`end_date` >= '2026-06-05')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.278335094451904296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8737;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9247736;}i:77;a:6:{i:0;s:184:"SELECT `banner`, `name`, `location_id`, `market_category` FROM `package_banners` WHERE ((`status`=1) AND (`type`=2)) AND (`start_date` <= '2026-06-05') AND (`end_date` >= '2026-06-05')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2791221141815185546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8737;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9249648;}}}";s:2:"db";s:28802:"a:1:{s:8:"messages";a:36:{i:23;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:1780672417.171720027923583984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6317336;}i:24;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:1780672417.1727809906005859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6360312;}i:26;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:1780672417.173369884490966796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6369360;}i:27;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:1780672417.17401409149169921875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6371944;}i:29;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='2d8457f931e99e6e9a792e356a016960') 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:1780672417.1766579151153564453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6648192;}i:30;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='2d8457f931e99e6e9a792e356a016960') 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:1780672417.187550067901611328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6656056;}i:32;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=178";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.1896879673004150390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6930808;}i:33;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=178";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.18999195098876953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;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:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6933712;}i:35;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:1780672417.1903460025787353515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6964208;}i:36;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:1780672417.1908929347991943359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6972816;}i:38;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:1780672417.191020965576171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6975176;}i:39;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:1780672417.191318988800048828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6977384;}i:41;a:6:{i:0;s:215:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/ld_stats', 2, '[]', '2026-06-05 20:43:37', 178, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.1915600299835205078125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:6977448;}i:42;a:6:{i:0;s:215:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/ld_stats', 2, '[]', '2026-06-05 20:43:37', 178, '{\"apk_type\":\"Android\",\"apk_version\":\"35\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.19235897064208984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:6978840;}i:46;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='2d8457f931e99e6e9a792e356a016960') 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:1780672417.196836948394775390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:302;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7460304;}i:47;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='2d8457f931e99e6e9a792e356a016960') 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:1780672417.207489013671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:302;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7467040;}i:49;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=178";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.2078340053558349609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:302;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7473568;}i:50;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=178";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780672417.2080230712890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:302;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7475192;}i:52;a:6:{i:0;s:65:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=178) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.222354888916015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:605;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8674;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9051120;}i:53;a:6:{i:0;s:65:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=178) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2226779460906982421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:605;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8674;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9058104;}i:55;a:6:{i:0;s:342:"SELECT `sm_cp1`.`sm_cp_id` FROM `sm_cp` `sm_cp1` LEFT JOIN `sm_cp` `sm_cp2` ON sm_cp1.parent_id=sm_cp2.sm_cp_id AND sm_cp2.is_deleted=0 LEFT JOIN `sm_cp` `sm_cp3` ON sm_cp2.parent_id=sm_cp3.sm_cp_id AND sm_cp3.is_deleted=0 WHERE ((178 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=178) AND sm_cp1.is_deleted=0";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2229449748992919921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:616;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:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8674;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9058624;}i:56;a:6:{i:0;s:342:"SELECT `sm_cp1`.`sm_cp_id` FROM `sm_cp` `sm_cp1` LEFT JOIN `sm_cp` `sm_cp2` ON sm_cp1.parent_id=sm_cp2.sm_cp_id AND sm_cp2.is_deleted=0 LEFT JOIN `sm_cp` `sm_cp3` ON sm_cp2.parent_id=sm_cp3.sm_cp_id AND sm_cp3.is_deleted=0 WHERE ((178 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=178) AND sm_cp1.is_deleted=0";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.233375072479248046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:616;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:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8674;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9062544;}i:58;a:6:{i:0;s:397:"SELECT SUM(IF(1, 1, 0)) AS total, SUM(IF((leadmaster.followup_date>='2026-06-05'), 1, 0)) AS followup,SUM(IF((leadmaster.followup_date='2026-06-05' ), 1, 0)) AS today,SUM(IF((leadmaster.followup_date<'2026-06-05'), 1, 0)) AS missed,SUM(IF((DATE(leadmaster.created_on)='2026-06-05' ), 1, 0)) AS fresh FROM leadmaster where leadmaster.created_by IN(179,180,349,879,178) AND leadmaster.is_deleted=0 ";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.233460903167724609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8684;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9061096;}i:59;a:6:{i:0;s:397:"SELECT SUM(IF(1, 1, 0)) AS total, SUM(IF((leadmaster.followup_date>='2026-06-05'), 1, 0)) AS followup,SUM(IF((leadmaster.followup_date='2026-06-05' ), 1, 0)) AS today,SUM(IF((leadmaster.followup_date<'2026-06-05'), 1, 0)) AS missed,SUM(IF((DATE(leadmaster.created_on)='2026-06-05' ), 1, 0)) AS fresh FROM leadmaster where leadmaster.created_by IN(179,180,349,879,178) AND leadmaster.is_deleted=0 ";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2730159759521484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8684;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9063808;}i:61;a:6:{i:0;s:45:"SELECT * FROM `channelpartner` WHERE `id`=558";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2735080718994140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9107208;}i:62;a:6:{i:0;s:45:"SELECT * FROM `channelpartner` WHERE `id`=558";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2739059925079345703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9123064;}i:64;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `channelpartner`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2740089893341064453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9126640;}i:65;a:6:{i:0;s:39:"SHOW FULL COLUMNS FROM `channelpartner`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2748320102691650390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9214632;}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` = 'channelpartner' AND `kcu`.`TABLE_NAME` = 'channelpartner'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2753849029541015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9185280;}i:68;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` = 'channelpartner' AND `kcu`.`TABLE_NAME` = 'channelpartner'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2757160663604736328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8691;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9187864;}i:70;a:6:{i:0;s:51:"SELECT COUNT(*) FROM `leadmaster` WHERE cp_id='558'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.275888919830322265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8698;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9183048;}i:71;a:6:{i:0;s:51:"SELECT COUNT(*) FROM `leadmaster` WHERE cp_id='558'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.27684497833251953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8698;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:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9184656;}i:73;a:6:{i:0;s:91:"SELECT * FROM `sm_cp` WHERE (`channelpartner_id`=558) AND (`status`=1) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.27704906463623046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:1982;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8701;s:8:"function";s:11:"getsmcpteam";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9193104;}i:74;a:6:{i:0;s:91:"SELECT * FROM `sm_cp` WHERE (`channelpartner_id`=558) AND (`status`=1) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2773959636688232421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:1982;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8701;s:8:"function";s:11:"getsmcpteam";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9215856;}i:76;a:6:{i:0;s:184:"SELECT `banner`, `name`, `location_id`, `market_category` FROM `package_banners` WHERE ((`status`=1) AND (`type`=2)) AND (`start_date` <= '2026-06-05') AND (`end_date` >= '2026-06-05')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.278335094451904296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8737;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9247736;}i:77;a:6:{i:0;s:184:"SELECT `banner`, `name`, `location_id`, `market_category` FROM `package_banners` WHERE ((`status`=1) AND (`type`=2)) AND (`start_date` <= '2026-06-05') AND (`end_date` >= '2026-06-05')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780672417.2791221141815185546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:8737;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:97:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:315;s:8:"function";s:15:"getleadstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9249648;}}}";s:5:"event";s:9382:"a:50:{i:0;a:5:{s:4:"time";d:1780672417.1608750820159912109375;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:1780672417.16769504547119140625;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:1780672417.1716859340667724609375;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:1780672417.187602996826171875;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:1780672417.1876571178436279296875;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:1780672417.1877329349517822265625;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:1780672417.1895730495452880859375;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:1780672417.189587116241455078125;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:1780672417.190083026885986328125;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:1780672417.1901710033416748046875;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:1780672417.1913659572601318359375;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:1780672417.19143199920654296875;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:1780672417.191441059112548828125;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:1780672417.192428112030029296875;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:1780672417.19548892974853515625;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:1780672417.195497035980224609375;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:1780672417.1966359615325927734375;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:"app\modules\api\controllers\LeadController";}i:17;a:5:{s:4:"time";d:1780672417.196681976318359375;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:1780672417.2075479030609130859375;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:1780672417.2075960636138916015625;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:1780672417.20761394500732421875;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:1780672417.2077529430389404296875;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:1780672417.2077600955963134765625;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:1780672417.2080490589141845703125;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:1780672417.2222080230712890625;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:1780672417.222238063812255859375;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:1780672417.222712993621826171875;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:27;a:5:{s:4:"time";d:1780672417.22276210784912109375;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:28;a:5:{s:4:"time";d:1780672417.2733910083770751953125;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:1780672417.2739460468292236328125;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:"app\models\Channelpartner";}i:30;a:5:{s:4:"time";d:1780672417.27581310272216796875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\models\Channelpartner";}i:31;a:5:{s:4:"time";d:1780672417.27688694000244140625;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:32;a:5:{s:4:"time";d:1780672417.2774269580841064453125;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:33;a:5:{s:4:"time";d:1780672417.277472972869873046875;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:34;a:5:{s:4:"time";d:1780672417.2774970531463623046875;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:35;a:5:{s:4:"time";d:1780672417.2775180339813232421875;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:36;a:5:{s:4:"time";d:1780672417.2775619029998779296875;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:37;a:5:{s:4:"time";d:1780672417.277596950531005859375;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:38;a:5:{s:4:"time";d:1780672417.2776010036468505859375;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:39;a:5:{s:4:"time";d:1780672417.27760410308837890625;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:40;a:5:{s:4:"time";d:1780672417.277606964111328125;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:41;a:5:{s:4:"time";d:1780672417.2776100635528564453125;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:42;a:5:{s:4:"time";d:1780672417.2777690887451171875;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:43;a:5:{s:4:"time";d:1780672417.2791750431060791015625;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:"app\modules\api\controllers\LeadController";}i:44;a:5:{s:4:"time";d:1780672417.2791860103607177734375;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:45;a:5:{s:4:"time";d:1780672417.27919292449951171875;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:46;a:5:{s:4:"time";d:1780672417.279202938079833984375;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:47;a:5:{s:4:"time";d:1780672417.27921009063720703125;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:48;a:5:{s:4:"time";d:1780672417.2798249721527099609375;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:49;a:5:{s:4:"time";d:1780672417.279872894287109375;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:1780672417.1342029571533203125;s:3:"end";d:1780672417.281980991363525390625;s:6:"memory";i:11366144;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:2320:"a:3:{s:8:"messages";a:11:{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:1780672417.1612489223480224609375;i:4;a:0:{}i:5;i:4903472;}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:1780672417.16129589080810546875;i:4;a:0:{}i:5;i:4904224;}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:1780672417.1613290309906005859375;i:4;a:0:{}i:5;i:4904976;}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:1780672417.1613409519195556640625;i:4;a:0:{}i:5;i:4906048;}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:1780672417.1613690853118896484375;i:4;a:0:{}i:5;i:4906800;}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:1780672417.1613800525665283203125;i:4;a:0:{}i:5;i:4907552;}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:1780672417.1613891124725341796875;i:4;a:0:{}i:5;i:4908304;}i:13;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:1780672417.1613979339599609375;i:4;a:0:{}i:5;i:4909056;}i:14;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:1780672417.161406040191650390625;i:4;a:0:{}i:5;i:4909808;}i:15;a:6:{i:0;s:38:"Request parsed with URL rule: ld_stats";i:1;i:8;i:2;s:29:"yii\web\UrlRule::parseRequest";i:3;d:1780672417.161425113677978515625;i:4;a:0:{}i:5;i:4911072;}i:16;a:6:{i:0;a:3:{s:4:"rule";s:8:"ld_stats";s:5:"match";b:1;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780672417.161427974700927734375;i:4;a:0:{}i:5;i:4911376;}}s:5:"route";s:14:"api/lead/stats";s:6:"action";s:57:"app\modules\api\controllers\LeadController::actionStats()";}";s:7:"request";s:2656:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:7:{s:15:"accept-encoding";s:4:"gzip";s:6:"apikey";s:32:"2d8457f931e99e6e9a792e356a016960";s:11:"channeltype";s:7:"Android";s:10:"connection";s:10:"Keep-Alive";s:4:"host";s:19:"api.cpbroadcast.com";s:10:"user-agent";s:13:"okhttp/4.10.0";s:7:"version";s:2:"35";}s:15:"responseHeaders";a:1:{s:12:"Content-Type";s:31:"application/json; charset=UTF-8";}s:5:"route";s:14:"api/lead/stats";s:6:"action";s:57:"app\modules\api\controllers\LeadController::actionStats()";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:42:{s:21:"CONTEXT_DOCUMENT_ROOT";s:46:"/home/webprjlw/public_html/api.cpbroadcast.com";s:14:"CONTEXT_PREFIX";s:0:"";s:13:"DOCUMENT_ROOT";s:46:"/home/webprjlw/public_html/api.cpbroadcast.com";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:5:"HTTPS";s:2:"on";s:20:"HTTP_ACCEPT_ENCODING";s:4:"gzip";s:11:"HTTP_APIKEY";s:32:"2d8457f931e99e6e9a792e356a016960";s:16:"HTTP_CHANNELTYPE";s:7:"Android";s:15:"HTTP_CONNECTION";s:10:"Keep-Alive";s:9:"HTTP_HOST";s:19:"api.cpbroadcast.com";s:15:"HTTP_USER_AGENT";s:13:"okhttp/4.10.0";s:12:"HTTP_VERSION";s:2:"35";s:4:"PATH";s:13:"/bin:/usr/bin";s:16:"PHP_INI_SCAN_DIR";s:67:"/opt/cpanel/ea-php80/root/etc:/opt/cpanel/ea-php80/root/etc/php.d:.";s:12:"QUERY_STRING";s:0:"";s:14:"REDIRECT_HTTPS";s:2:"on";s:20:"REDIRECT_SSL_TLS_SNI";s:19:"api.cpbroadcast.com";s:15:"REDIRECT_STATUS";s:3:"200";s:18:"REDIRECT_UNIQUE_ID";s:27:"aiLnoZGsUqymYEhb_-Wl7QAAABs";s:12:"REDIRECT_URL";s:21:"/backend/web/ld_stats";s:11:"REMOTE_ADDR";s:13:"114.79.136.87";s:11:"REMOTE_PORT";s:5:"14749";s:14:"REQUEST_METHOD";s:3:"GET";s:14:"REQUEST_SCHEME";s:5:"https";s:11:"REQUEST_URI";s:21:"/backend/web/ld_stats";s:15:"SCRIPT_FILENAME";s:68:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/web/index.php";s:11:"SCRIPT_NAME";s:22:"/backend/web/index.php";s:11:"SERVER_ADDR";s:13:"65.254.80.108";s:12:"SERVER_ADMIN";s:29:"webmaster@api.cpbroadcast.com";s:11:"SERVER_NAME";s:19:"api.cpbroadcast.com";s:11:"SERVER_PORT";s:3:"443";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:16:"SERVER_SIGNATURE";s:0:"";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:11:"SSL_TLS_SNI";s:19:"api.cpbroadcast.com";s:2:"TZ";s:12:"Asia/Kolkata";s:9:"UNIQUE_ID";s:27:"aiLnoZGsUqymYEhb_-Wl7QAAABs";s:8:"PHP_SELF";s:22:"/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1780672417.1274158954620361328125;s:12:"REQUEST_TIME";i:1780672417;s:4:"argv";a:0:{}s:4:"argc";i:0;}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:0:{}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}";s:4:"user";s:2:"N;";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:13:{s:3:"tag";s:13:"6a22e7a1261dd";s:3:"url";s:48:"https://api.cpbroadcast.com/backend/web/ld_stats";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:13:"114.79.136.87";s:4:"time";d:1780672417.1274158954620361328125;s:10:"statusCode";i:200;s:8:"sqlCount";i:18;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:11366144;s:14:"processingTime";d:0.1475861072540283203125;}s:10:"exceptions";a:0:{}}