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:16438:"a:1:{s:8:"messages";a:29:{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:1791227129.258469104766845703125;i:4;a:0:{}i:5;i:2756720;}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:1791227129.2593619823455810546875;i:4;a:0:{}i:5;i:2932832;}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:1791227129.2593739032745361328125;i:4;a:0:{}i:5;i:2933632;}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:1791227129.266892910003662109375;i:4;a:0:{}i:5;i:4095256;}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:1791227129.269969940185546875;i:4;a:0:{}i:5;i:4661144;}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:1791227129.2701890468597412109375;i:4;a:0:{}i:5;i:4686008;}i:68;a:6:{i:0;s:36:"Route requested: 'api/tagging/stats'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1791227129.27274799346923828125;i:4;a:0:{}i:5;i:4958584;}i:69;a:6:{i:0;s:19:"Loading module: api";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1791227129.2727539539337158203125;i:4;a:0:{}i:5;i:4960208;}i:70;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:1791227129.281764984130859375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6315032;}i:71;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:1791227129.281794071197509765625;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6317864;}i:76;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:1791227129.283958911895751953125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6421224;}i:79;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='44683df68f648cabf642fc437348a80c') 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:1791227129.28701305389404296875;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6702800;}i:82;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9303";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.2947061061859130859375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6985656;}i:85;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:1791227129.2961521148681640625;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:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7018000;}i:88;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:1791227129.29670810699462890625;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:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7027472;}i:91;a:6:{i:0;s:216:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/tg_stats', 2, '[]', '2026-10-06 00:35:29', 9303, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.297151088714599609375;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:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7032256;}i:94;a:6:{i:0;s:31:"Route to run: api/tagging/stats";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1791227129.3107669353485107421875;i:4;a:0:{}i:5;i:7447680;}i:95;a:6:{i:0;s:76:"Running action: app\modules\api\controllers\TaggingController::actionStats()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1791227129.311923980712890625;i:4;a:0:{}i:5;i:7648800;}i:96;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='44683df68f648cabf642fc437348a80c') 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:1791227129.3121280670166015625;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1871;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7659960;}i:99;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9303";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.318090915679931640625;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1871;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7672872;}i:102;a:6:{i:0;s:66:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=9303) AND (`is_deleted`=0)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.332623004913330078125;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:628;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:10297;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9329976;}i:105;a:6:{i:0;s:344:"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 ((9303 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=9303) AND sm_cp1.is_deleted=0";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.33331298828125;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:639;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:10297;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9336744;}i:108;a:6:{i:0;s:642:"SELECT IFNULL(SUM(IF((taggingmaster.id!=''), 1, 0)), 0) AS total, IFNULL(SUM(IF((taggingmaster.status=0), 1, 0)), 0) AS appointment,IFNULL(SUM(IF((taggingmaster.status=1 OR taggingmaster.status=3), 1, 0)), 0) AS visited,IFNULL(SUM(IF((taggingmaster.status=2), 1, 0)), 0) AS notvisited,IFNULL(SUM(IF((taggingmaster.status=7), 1, 0)), 0) AS physical_visit,IFNULL(SUM(IF((taggingmaster.status=6 OR taggingmaster.status=4), 1, 0)), 0) AS booked FROM taggingmaster where  taggingmaster.created_by IN(9303) AND taggingmaster.is_deleted=0  AND taggingmaster.id NOT IN( SELECT id from taggingmaster where appointment_date < "2026-09-06" AND status=2)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3476409912109375;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:10341;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9339688;}i:111;a:6:{i:0;s:184:"SELECT `banner`, `name`, `location_id`, `market_category` FROM `package_banners` WHERE ((`status`=1) AND (`type`=3)) AND (`start_date` <= '2026-10-06') AND (`end_date` >= '2026-10-06')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.37213611602783203125;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:10352;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9395152;}i:114;a:6:{i:0;s:43:"SELECT * FROM `sm_cp` WHERE `sm_cp_id`=9303";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3725140094757080078125;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:10356;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9398392;}i:117;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=57847";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3732430934906005859375;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9455144;}i:120;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:1791227129.3736419677734375;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9474224;}i:123;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:1791227129.375030994415283203125;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9527024;}i:126;a:6:{i:0;s:101:"Access to debugger is denied due to IP address restriction. The requesting IP address is 152.58.2.102";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1791227129.3761060237884521484375;i:4;a:0:{}i:5;i:9545912;}}}";s:9:"profiling";s:29041:"a:3:{s:6:"memory";i:11798224;s:4:"time";d:0.1317050457000732421875;s:8:"messages";a:36:{i:72;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:1791227129.2818028926849365234375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6319368;}i:73;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:1791227129.2823810577392578125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6364952;}i:74;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:1791227129.2824079990386962890625;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6365552;}i:75;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:1791227129.2833459377288818359375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6424152;}i:77;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:1791227129.28398609161376953125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6424464;}i:78;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:1791227129.2845211029052734375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6427048;}i:80;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='44683df68f648cabf642fc437348a80c') 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:1791227129.2870390415191650390625;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6703976;}i:81;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='44683df68f648cabf642fc437348a80c') 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:1791227129.292665958404541015625;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6713072;}i:83;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9303";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.294724941253662109375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6987248;}i:84;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9303";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.2958920001983642578125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6988872;}i:86;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:1791227129.2961819171905517578125;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:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7019368;}i:87;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:1791227129.2966139316558837890625;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:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7027976;}i:89;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:1791227129.296721935272216796875;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:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7030336;}i:90;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:1791227129.296987056732177734375;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:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7032544;}i:92;a:6:{i:0;s:216:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/tg_stats', 2, '[]', '2026-10-06 00:35:29', 9303, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.2971630096435546875;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:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7032608;}i:93;a:6:{i:0;s:216:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/tg_stats', 2, '[]', '2026-10-06 00:35:29', 9303, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.2985820770263671875;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:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7034000;}i:97;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='44683df68f648cabf642fc437348a80c') 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:1791227129.3121440410614013671875;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1871;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7661136;}i:98;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='44683df68f648cabf642fc437348a80c') 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:1791227129.317802906036376953125;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1871;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7668512;}i:100;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9303";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.3181049823760986328125;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1871;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7674464;}i:101;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9303";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.318646907806396484375;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1871;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7676088;}i:103;a:6:{i:0;s:66:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=9303) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.332643985748291015625;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:628;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:10297;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9331960;}i:104;a:6:{i:0;s:66:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=9303) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3330800533294677734375;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:628;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:10297;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9339584;}i:106;a:6:{i:0;s:344:"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 ((9303 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=9303) AND sm_cp1.is_deleted=0";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3333399295806884765625;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:639;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:10297;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9339528;}i:107;a:6:{i:0;s:344:"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 ((9303 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=9303) AND sm_cp1.is_deleted=0";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.347546100616455078125;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:639;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:10297;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9341496;}i:109;a:6:{i:0;s:642:"SELECT IFNULL(SUM(IF((taggingmaster.id!=''), 1, 0)), 0) AS total, IFNULL(SUM(IF((taggingmaster.status=0), 1, 0)), 0) AS appointment,IFNULL(SUM(IF((taggingmaster.status=1 OR taggingmaster.status=3), 1, 0)), 0) AS visited,IFNULL(SUM(IF((taggingmaster.status=2), 1, 0)), 0) AS notvisited,IFNULL(SUM(IF((taggingmaster.status=7), 1, 0)), 0) AS physical_visit,IFNULL(SUM(IF((taggingmaster.status=6 OR taggingmaster.status=4), 1, 0)), 0) AS booked FROM taggingmaster where  taggingmaster.created_by IN(9303) AND taggingmaster.is_deleted=0  AND taggingmaster.id NOT IN( SELECT id from taggingmaster where appointment_date < "2026-09-06" AND status=2)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3476541042327880859375;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:10341;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9342864;}i:110;a:6:{i:0;s:642:"SELECT IFNULL(SUM(IF((taggingmaster.id!=''), 1, 0)), 0) AS total, IFNULL(SUM(IF((taggingmaster.status=0), 1, 0)), 0) AS appointment,IFNULL(SUM(IF((taggingmaster.status=1 OR taggingmaster.status=3), 1, 0)), 0) AS visited,IFNULL(SUM(IF((taggingmaster.status=2), 1, 0)), 0) AS notvisited,IFNULL(SUM(IF((taggingmaster.status=7), 1, 0)), 0) AS physical_visit,IFNULL(SUM(IF((taggingmaster.status=6 OR taggingmaster.status=4), 1, 0)), 0) AS booked FROM taggingmaster where  taggingmaster.created_by IN(9303) AND taggingmaster.is_deleted=0  AND taggingmaster.id NOT IN( SELECT id from taggingmaster where appointment_date < "2026-09-06" AND status=2)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3714768886566162109375;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:10341;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9345720;}i:112;a:6:{i:0;s:184:"SELECT `banner`, `name`, `location_id`, `market_category` FROM `package_banners` WHERE ((`status`=1) AND (`type`=3)) AND (`start_date` <= '2026-10-06') AND (`end_date` >= '2026-10-06')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3721559047698974609375;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:10352;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9396472;}i:113;a:6:{i:0;s:184:"SELECT `banner`, `name`, `location_id`, `market_category` FROM `package_banners` WHERE ((`status`=1) AND (`type`=3)) AND (`start_date` <= '2026-10-06') AND (`end_date` >= '2026-10-06')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.37242603302001953125;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:10352;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9399168;}i:115;a:6:{i:0;s:43:"SELECT * FROM `sm_cp` WHERE `sm_cp_id`=9303";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3725249767303466796875;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:10356;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9400216;}i:116;a:6:{i:0;s:43:"SELECT * FROM `sm_cp` WHERE `sm_cp_id`=9303";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3727691173553466796875;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:10356;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9407480;}i:118;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=57847";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.373259067535400390625;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9456968;}i:119;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=57847";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3735859394073486328125;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9472392;}i:121;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:1791227129.3736560344696044921875;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9475968;}i:122;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:1791227129.37450504302978515625;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9561200;}i:124;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:1791227129.3750469684600830078125;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9530264;}i:125;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:1791227129.3753941059112548828125;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9532848;}}}";s:2:"db";s:27688:"a:1:{s:8:"messages";a:34:{i:74;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:1791227129.2824079990386962890625;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6365552;}i:75;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:1791227129.2833459377288818359375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6424152;}i:77;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:1791227129.28398609161376953125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6424464;}i:78;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:1791227129.2845211029052734375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6427048;}i:80;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='44683df68f648cabf642fc437348a80c') 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:1791227129.2870390415191650390625;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6703976;}i:81;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='44683df68f648cabf642fc437348a80c') 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:1791227129.292665958404541015625;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6713072;}i:83;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9303";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.294724941253662109375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6987248;}i:84;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9303";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.2958920001983642578125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6988872;}i:86;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:1791227129.2961819171905517578125;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:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7019368;}i:87;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:1791227129.2966139316558837890625;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:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7027976;}i:89;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:1791227129.296721935272216796875;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:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7030336;}i:90;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:1791227129.296987056732177734375;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:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7032544;}i:92;a:6:{i:0;s:216:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/tg_stats', 2, '[]', '2026-10-06 00:35:29', 9303, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.2971630096435546875;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:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7032608;}i:93;a:6:{i:0;s:216:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/tg_stats', 2, '[]', '2026-10-06 00:35:29', 9303, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.2985820770263671875;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:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7034000;}i:97;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='44683df68f648cabf642fc437348a80c') 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:1791227129.3121440410614013671875;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1871;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7661136;}i:98;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='44683df68f648cabf642fc437348a80c') 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:1791227129.317802906036376953125;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1871;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7668512;}i:100;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9303";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.3181049823760986328125;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1871;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7674464;}i:101;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9303";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1791227129.318646907806396484375;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1871;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7676088;}i:103;a:6:{i:0;s:66:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=9303) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.332643985748291015625;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:628;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:10297;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9331960;}i:104;a:6:{i:0;s:66:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=9303) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3330800533294677734375;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:628;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:10297;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9339584;}i:106;a:6:{i:0;s:344:"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 ((9303 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=9303) AND sm_cp1.is_deleted=0";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3333399295806884765625;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:639;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:10297;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9339528;}i:107;a:6:{i:0;s:344:"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 ((9303 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=9303) AND sm_cp1.is_deleted=0";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.347546100616455078125;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:639;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:10297;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9341496;}i:109;a:6:{i:0;s:642:"SELECT IFNULL(SUM(IF((taggingmaster.id!=''), 1, 0)), 0) AS total, IFNULL(SUM(IF((taggingmaster.status=0), 1, 0)), 0) AS appointment,IFNULL(SUM(IF((taggingmaster.status=1 OR taggingmaster.status=3), 1, 0)), 0) AS visited,IFNULL(SUM(IF((taggingmaster.status=2), 1, 0)), 0) AS notvisited,IFNULL(SUM(IF((taggingmaster.status=7), 1, 0)), 0) AS physical_visit,IFNULL(SUM(IF((taggingmaster.status=6 OR taggingmaster.status=4), 1, 0)), 0) AS booked FROM taggingmaster where  taggingmaster.created_by IN(9303) AND taggingmaster.is_deleted=0  AND taggingmaster.id NOT IN( SELECT id from taggingmaster where appointment_date < "2026-09-06" AND status=2)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3476541042327880859375;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:10341;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9342864;}i:110;a:6:{i:0;s:642:"SELECT IFNULL(SUM(IF((taggingmaster.id!=''), 1, 0)), 0) AS total, IFNULL(SUM(IF((taggingmaster.status=0), 1, 0)), 0) AS appointment,IFNULL(SUM(IF((taggingmaster.status=1 OR taggingmaster.status=3), 1, 0)), 0) AS visited,IFNULL(SUM(IF((taggingmaster.status=2), 1, 0)), 0) AS notvisited,IFNULL(SUM(IF((taggingmaster.status=7), 1, 0)), 0) AS physical_visit,IFNULL(SUM(IF((taggingmaster.status=6 OR taggingmaster.status=4), 1, 0)), 0) AS booked FROM taggingmaster where  taggingmaster.created_by IN(9303) AND taggingmaster.is_deleted=0  AND taggingmaster.id NOT IN( SELECT id from taggingmaster where appointment_date < "2026-09-06" AND status=2)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3714768886566162109375;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:10341;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9345720;}i:112;a:6:{i:0;s:184:"SELECT `banner`, `name`, `location_id`, `market_category` FROM `package_banners` WHERE ((`status`=1) AND (`type`=3)) AND (`start_date` <= '2026-10-06') AND (`end_date` >= '2026-10-06')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3721559047698974609375;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:10352;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9396472;}i:113;a:6:{i:0;s:184:"SELECT `banner`, `name`, `location_id`, `market_category` FROM `package_banners` WHERE ((`status`=1) AND (`type`=3)) AND (`start_date` <= '2026-10-06') AND (`end_date` >= '2026-10-06')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.37242603302001953125;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:10352;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9399168;}i:115;a:6:{i:0;s:43:"SELECT * FROM `sm_cp` WHERE `sm_cp_id`=9303";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3725249767303466796875;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:10356;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9400216;}i:116;a:6:{i:0;s:43:"SELECT * FROM `sm_cp` WHERE `sm_cp_id`=9303";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3727691173553466796875;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:10356;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9407480;}i:118;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=57847";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.373259067535400390625;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9456968;}i:119;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=57847";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791227129.3735859394073486328125;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9472392;}i:121;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:1791227129.3736560344696044921875;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9475968;}i:122;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:1791227129.37450504302978515625;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9561200;}i:124;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:1791227129.3750469684600830078125;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9530264;}i:125;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:1791227129.3753941059112548828125;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:10359;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/TaggingController.php";s:4:"line";i:1891;s:8:"function";s:14:"gettagstatsapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9532848;}}}";s:5:"event";s:7947:"a:42:{i:0;a:5:{s:4:"time";d:1791227129.27171993255615234375;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:1791227129.278881072998046875;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:1791227129.2823750972747802734375;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:1791227129.2927119731903076171875;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:1791227129.2927620410919189453125;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:1791227129.292828083038330078125;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:1791227129.29460906982421875;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:1791227129.2946250438690185546875;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:1791227129.2959620952606201171875;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:1791227129.2960460186004638671875;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:1791227129.29701995849609375;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:1791227129.29708003997802734375;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:1791227129.2970879077911376953125;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:1791227129.2986390590667724609375;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:1791227129.3108370304107666015625;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:1791227129.310844898223876953125;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:1791227129.3119089603424072265625;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:45:"app\modules\api\controllers\TaggingController";}i:17;a:5:{s:4:"time";d:1791227129.311954021453857421875;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:1791227129.3178369998931884765625;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:1791227129.317884922027587890625;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:1791227129.3179008960723876953125;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:1791227129.318027973175048828125;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:1791227129.31803607940673828125;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:1791227129.318687915802001953125;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:1791227129.3325290679931640625;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:1791227129.3325560092926025390625;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:1791227129.333097934722900390625;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:1791227129.3331449031829833984375;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:1791227129.3716499805450439453125;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:1791227129.372457981109619140625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:30;a:5:{s:4:"time";d:1791227129.372787952423095703125;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:31;a:5:{s:4:"time";d:1791227129.37283992767333984375;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:32;a:5:{s:4:"time";d:1791227129.3731899261474609375;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:33;a:5:{s:4:"time";d:1791227129.373611927032470703125;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:34;a:5:{s:4:"time";d:1791227129.3754670619964599609375;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:35;a:5:{s:4:"time";d:1791227129.3755071163177490234375;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:45:"app\modules\api\controllers\TaggingController";}i:36;a:5:{s:4:"time";d:1791227129.37551593780517578125;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:37;a:5:{s:4:"time";d:1791227129.375523090362548828125;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:38;a:5:{s:4:"time";d:1791227129.3755319118499755859375;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:39;a:5:{s:4:"time";d:1791227129.3755390644073486328125;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:40;a:5:{s:4:"time";d:1791227129.3761188983917236328125;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:41;a:5:{s:4:"time";d:1791227129.3761670589447021484375;s:4:"name";s:9:"afterSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:121:"a:3:{s:5:"start";d:1791227129.2463519573211669921875;s:3:"end";d:1791227129.3782329559326171875;s:6:"memory";i:11798224;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:12416:"a:3:{s:8:"messages";a:62:{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:1791227129.272056102752685546875;i:4;a:0:{}i:5;i:4905408;}i:7;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/<id:\w+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.272099018096923828125;i:4;a:0:{}i:5;i:4906160;}i:8;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.27213191986083984375;i:4;a:0:{}i:5;i:4906912;}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:1791227129.2721440792083740234375;i:4;a:0:{}i:5;i:4907984;}i:10;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.27217197418212890625;i:4;a:0:{}i:5;i:4908736;}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:1791227129.272183895111083984375;i:4;a:0:{}i:5;i:4909488;}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:1791227129.27219295501708984375;i:4;a:0:{}i:5;i:4910240;}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:1791227129.272202014923095703125;i:4;a:0:{}i:5;i:4910992;}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:1791227129.2722110748291015625;i:4;a:0:{}i:5;i:4911744;}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:1791227129.272222042083740234375;i:4;a:0:{}i:5;i:4912496;}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:1791227129.27223110198974609375;i:4;a:0:{}i:5;i:4913248;}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:1791227129.2722399234771728515625;i:4;a:0:{}i:5;i:4914640;}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:1791227129.2722489833831787109375;i:4;a:0:{}i:5;i:4915392;}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:1791227129.2722570896148681640625;i:4;a:0:{}i:5;i:4916144;}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:1791227129.272264957427978515625;i:4;a:0:{}i:5;i:4916896;}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:1791227129.272274017333984375;i:4;a:0:{}i:5;i:4917648;}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:1791227129.272285938262939453125;i:4;a:0:{}i:5;i:4918400;}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:1791227129.2722949981689453125;i:4;a:0:{}i:5;i:4919152;}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:1791227129.272303104400634765625;i:4;a:0:{}i:5;i:4919904;}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:1791227129.2723119258880615234375;i:4;a:0:{}i:5;i:4920656;}i:26;a:6:{i:0;a:3:{s:4:"rule";s:7:"mk_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:1791227129.27233600616455078125;i:4;a:0:{}i:5;i:4921408;}i:27;a:6:{i:0;a:3:{s:4:"rule";s:10:"mk_connect";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.272345066070556640625;i:4;a:0:{}i:5;i:4922160;}i:28;a:6:{i:0;a:3:{s:4:"rule";s:9:"pr_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:1791227129.2723529338836669921875;i:4;a:0:{}i:5;i:4922912;}i:29;a:6:{i:0;a:3:{s:4:"rule";s:11:"pr_bookmark";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.272366046905517578125;i:4;a:0:{}i:5;i:4923664;}i:30;a:6:{i:0;a:3:{s:4:"rule";s:7:"pr_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:1791227129.2723751068115234375;i:4;a:0:{}i:5;i:4924416;}i:31;a:6:{i:0;a:3:{s:4:"rule";s:11:"pr_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:1791227129.2723829746246337890625;i:4;a:0:{}i:5;i:4925168;}i:32;a:6:{i:0;a:3:{s:4:"rule";s:14:"pr_listbuilder";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2723920345306396484375;i:4;a:0:{}i:5;i:4925920;}i:33;a:6:{i:0;a:3:{s:4:"rule";s:15:"pr_bookmarklist";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2724049091339111328125;i:4;a:0:{}i:5;i:4927952;}i:34;a:6:{i:0;a:3:{s:4:"rule";s:12:"pr_amenities";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2724130153656005859375;i:4;a:0:{}i:5;i:4928704;}i:35;a:6:{i:0;a:3:{s:4:"rule";s:13:"pr_guidelines";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2724249362945556640625;i:4;a:0:{}i:5;i:4929456;}i:36;a:6:{i:0;a:3:{s:4:"rule";s:9:"pr_listsm";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2724330425262451171875;i:4;a:0:{}i:5;i:4930208;}i:37;a:6:{i:0;a:3:{s:4:"rule";s:10:"pr_builder";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2724540233612060546875;i:4;a:0:{}i:5;i:4930960;}i:38;a:6:{i:0;a:3:{s:4:"rule";s:14:"pr_viewwebsite";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2724659442901611328125;i:4;a:0:{}i:5;i:4931712;}i:39;a:6:{i:0;a:3:{s:4:"rule";s:9:"sm_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:1791227129.2724740505218505859375;i:4;a:0:{}i:5;i:4932464;}i:40;a:6:{i:0;a:3:{s:4:"rule";s:9:"sm_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:1791227129.2724819183349609375;i:4;a:0:{}i:5;i:4933216;}i:41;a:6:{i:0;a:3:{s:4:"rule";s:7:"sm_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:1791227129.272490978240966796875;i:4;a:0:{}i:5;i:4933968;}i:42;a:6:{i:0;a:3:{s:4:"rule";s:10:"sm_profile";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.27250194549560546875;i:4;a:0:{}i:5;i:4934720;}i:43;a:6:{i:0;a:3:{s:4:"rule";s:9:"sm_member";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.272510051727294921875;i:4;a:0:{}i:5;i:4935472;}i:44;a:6:{i:0;a:3:{s:4:"rule";s:10:"sm_manager";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2725179195404052734375;i:4;a:0:{}i:5;i:4936224;}i:45;a:6:{i:0;a:3:{s:4:"rule";s:11:"sm_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:1791227129.2725260257720947265625;i:4;a:0:{}i:5;i:4936976;}i:46;a:6:{i:0;a:3:{s:4:"rule";s:9:"sm_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:1791227129.272533893585205078125;i:4;a:0:{}i:5;i:4937728;}i:47;a:6:{i:0;a:3:{s:4:"rule";s:16:"sm_notifications";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2725429534912109375;i:4;a:0:{}i:5;i:4938480;}i:48;a:6:{i:0;a:3:{s:4:"rule";s:22:"sm_notification_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:1791227129.272552967071533203125;i:4;a:0:{}i:5;i:4939232;}i:49;a:6:{i:0;a:3:{s:4:"rule";s:21:"sm_notification_count";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2725679874420166015625;i:4;a:0:{}i:5;i:4939984;}i:50;a:6:{i:0;a:3:{s:4:"rule";s:19:"sm_readnotification";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2725780010223388671875;i:4;a:0:{}i:5;i:4940736;}i:51;a:6:{i:0;a:3:{s:4:"rule";s:14:"sm_listnetwork";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2725870609283447265625;i:4;a:0:{}i:5;i:4941488;}i:52;a:6:{i:0;a:3:{s:4:"rule";s:18:"sm_listnetworkname";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.272595882415771484375;i:4;a:0:{}i:5;i:4942240;}i:53;a:6:{i:0;a:3:{s:4:"rule";s:16:"sm_listapprovals";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.27260494232177734375;i:4;a:0:{}i:5;i:4942992;}i:54;a:6:{i:0;a:3:{s:4:"rule";s:16:"sm_updatenetwork";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.272613048553466796875;i:4;a:0:{}i:5;i:4943744;}i:55;a:6:{i:0;a:3:{s:4:"rule";s:23:"sm_projectnotifications";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2726271152496337890625;i:4;a:0:{}i:5;i:4944496;}i:56;a:6:{i:0;a:3:{s:4:"rule";s:10:"sm_package";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.272634983062744140625;i:4;a:0:{}i:5;i:4945248;}i:57;a:6:{i:0;a:3:{s:4:"rule";s:18:"sm_package_enquiry";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.27264499664306640625;i:4;a:0:{}i:5;i:4946000;}i:58;a:6:{i:0;a:3:{s:4:"rule";s:17:"sm_packagehistory";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.272654056549072265625;i:4;a:0:{}i:5;i:4946752;}i:59;a:6:{i:0;a:3:{s:4:"rule";s:9:"sm_orders";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2726619243621826171875;i:4;a:0:{}i:5;i:4947504;}i:60;a:6:{i:0;a:3:{s:4:"rule";s:14:"sm_orderdetail";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2726728916168212890625;i:4;a:0:{}i:5;i:4948256;}i:61;a:6:{i:0;a:3:{s:4:"rule";s:19:"sm_listnetworkusers";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2726910114288330078125;i:4;a:0:{}i:5;i:4949008;}i:62;a:6:{i:0;a:3:{s:4:"rule";s:9:"tg_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:1791227129.2727019786834716796875;i:4;a:0:{}i:5;i:4949760;}i:63;a:6:{i:0;a:3:{s:4:"rule";s:9:"tg_direct";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2727100849151611328125;i:4;a:0:{}i:5;i:4950512;}i:64;a:6:{i:0;a:3:{s:4:"rule";s:17:"tg_createmultiple";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791227129.2727200984954833984375;i:4;a:0:{}i:5;i:4951264;}i:65;a:6:{i:0;a:3:{s:4:"rule";s:9:"tg_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:1791227129.27272891998291015625;i:4;a:0:{}i:5;i:4957648;}i:66;a:6:{i:0;s:38:"Request parsed with URL rule: tg_stats";i:1;i:8;i:2;s:29:"yii\web\UrlRule::parseRequest";i:3;d:1791227129.272739887237548828125;i:4;a:0:{}i:5;i:4958912;}i:67;a:6:{i:0;a:3:{s:4:"rule";s:8:"tg_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:1791227129.2727429866790771484375;i:4;a:0:{}i:5;i:4959216;}}s:5:"route";s:17:"api/tagging/stats";s:6:"action";s:60:"app\modules\api\controllers\TaggingController::actionStats()";}";s:7:"request";s:2661:"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:"44683df68f648cabf642fc437348a80c";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:"43";}s:15:"responseHeaders";a:1:{s:12:"Content-Type";s:31:"application/json; charset=UTF-8";}s:5:"route";s:17:"api/tagging/stats";s:6:"action";s:60:"app\modules\api\controllers\TaggingController::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:"44683df68f648cabf642fc437348a80c";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:"43";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:"asP0-UKyauHEGQSgzF3aKQAAAAc";s:12:"REDIRECT_URL";s:21:"/backend/web/tg_stats";s:11:"REMOTE_ADDR";s:12:"152.58.2.102";s:11:"REMOTE_PORT";s:5:"45456";s:14:"REQUEST_METHOD";s:3:"GET";s:14:"REQUEST_SCHEME";s:5:"https";s:11:"REQUEST_URI";s:21:"/backend/web/tg_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:"asP0-UKyauHEGQSgzF3aKQAAAAc";s:8:"PHP_SELF";s:22:"/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1791227129.2398579120635986328125;s:12:"REQUEST_TIME";i:1791227129;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:"6ac3f4f941406";s:3:"url";s:48:"https://api.cpbroadcast.com/backend/web/tg_stats";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"152.58.2.102";s:4:"time";d:1791227129.2398579120635986328125;s:10:"statusCode";i:200;s:8:"sqlCount";i:17;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:11798224;s:14:"processingTime";d:0.1317050457000732421875;}s:10:"exceptions";a:0:{}}