a:14:{s:6:"config";s:1645:"a:5:{s:10:"phpVersion";s:6:"8.0.30";s:10:"yiiVersion";s:8:"2.0.49.3";s:11:"application";a:8:{s:3:"yii";s:8:"2.0.49.3";s:4:"name";s:14:"My Application";s:7:"version";s:3:"1.0";s:8:"language";s:5:"en-US";s:14:"sourceLanguage";s:5:"en-US";s:7:"charset";s:5:"UTF-8";s:3:"env";s:3:"dev";s:5:"debug";b:1;}s:3:"php";a:5:{s:7:"version";s:6:"8.0.30";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:5:{s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/vendor/yiisoft/yii2-faker/src";}}s:26:"yiisoft/yii2-symfonymailer";a:3:{s:4:"name";s:26:"yiisoft/yii2-symfonymailer";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:18:"@yii/symfonymailer";s:87:"/home/webprjlw/public_html/devapi.cpbroadcast.com/vendor/yiisoft/yii2-symfonymailer/src";}}s:23:"yiisoft/yii2-bootstrap5";a:4:{s:4:"name";s:23:"yiisoft/yii2-bootstrap5";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap5";s:84:"/home/webprjlw/public_html/devapi.cpbroadcast.com/vendor/yiisoft/yii2-bootstrap5/src";}s:9:"bootstrap";s:40:"yii\bootstrap5\i18n\TranslationBootstrap";}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.2.6.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:77:"/home/webprjlw/public_html/devapi.cpbroadcast.com/vendor/yiisoft/yii2-gii/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.25.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/vendor/yiisoft/yii2-debug/src";}}}}";s:3:"log";s:30244:"a:1:{s:8:"messages";a:42:{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:1780566781.197144031524658203125;i:4;a:0:{}i:5;i:2767504;}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:1780566781.197989940643310546875;i:4;a:0:{}i:5;i:2943648;}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:1780566781.1980040073394775390625;i:4;a:0:{}i:5;i:2944448;}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:1780566781.2051589488983154296875;i:4;a:0:{}i:5;i:4106200;}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:1780566781.20786190032958984375;i:4;a:0:{}i:5;i:4670264;}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:1780566781.2080729007720947265625;i:4;a:0:{}i:5;i:4695160;}i:81;a:6:{i:0;s:46:"Route requested: 'api/cpconnect/mypostresults'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1780566781.2098789215087890625;i:4;a:0:{}i:5;i:4977848;}i:82;a:6:{i:0;s:19:"Loading module: api";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1780566781.2098848819732666015625;i:4;a:0:{}i:5;i:4979480;}i:83;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:1780566781.217617034912109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6333440;}i:84;a:6:{i:0;s:64:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_smcp";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1780566781.217647075653076171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6336256;}i:89;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:1780566781.219338893890380859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6432648;}i:92;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='9082068334') 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:1780566781.22190093994140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6713560;}i:95;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=214";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.2243850231170654296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6995720;}i:98;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:1780566781.225677967071533203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7028064;}i:101;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:1780566781.2262508869171142578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7037536;}i:104;a:6:{i:0;s:394:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/post_mypostresults?id=113&searchBy=4&sort_name=&sort_type=&page=2&page_count=15', 2, '{\"id\":\"113\",\"searchBy\":\"4\",\"sort_name\":\"\",\"sort_type\":\"\",\"page\":\"2\",\"page_count\":\"15\"}', '2026-06-04 15:23:01', 214, '{\"apk_type\":\"Android\",\"apk_version\":\"32\"}')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.22675800323486328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7042512;}i:107;a:6:{i:0;s:41:"Route to run: api/cpconnect/mypostresults";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1780566781.2379550933837890625;i:4;a:0:{}i:5;i:7613032;}i:108;a:6:{i:0;s:86:"Running action: app\modules\api\controllers\CpconnectController::actionMypostresults()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1780566781.2391109466552734375;i:4;a:0:{}i:5;i:7814920;}i:109;a:6:{i:0;s:50:"SELECT * FROM `cp_customers_flats` WHERE id="113" ";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.250174999237060546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9412128;}i:112;a:6:{i:0;s:43:"SHOW FULL COLUMNS FROM `cp_customers_flats`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.250832080841064453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9423816;}i:115;a:6:{i:0;s:792:"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` = 'cp_customers_flats' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2516410350799560546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9448984;}i:118;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='9082068334') 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:1780566781.252151966094970703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1431;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:9452440;}i:121;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=214";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.252974987030029296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1431;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:9465232;}i:124;a:6:{i:0;s:46:"SELECT * FROM `channelpartner` WHERE `id`=2301";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.253469944000244140625;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9507120;}i:127;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:1780566781.2537910938262939453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9525240;}i:130;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:1780566781.2548611164093017578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9578344;}i:133;a:6:{i:0;s:36:"SELECT * FROM `package` WHERE `id`=7";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2554149627685546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9602120;}i:136;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `package`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2556540966033935546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9613624;}i:139;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` = 'package' AND `kcu`.`TABLE_NAME` = 'package'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2562830448150634765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9627448;}i:142;a:6:{i:0;s:65:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=214) AND (`is_deleted`=0)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2566630840301513671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:605;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7183;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9630680;}i:145;a:6:{i:0;s:47:"SELECT `near_locs` FROM `location` WHERE `id`=4";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.25708103179931640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9658512;}i:148;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `location`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2572610378265380859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9667888;}i:151;a:6:{i:0;s:772:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'location' AND `kcu`.`TABLE_NAME` = 'location'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2577800750732421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9682120;}i:154;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `cp_customers_flats_spam`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.258184909820556640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9704664;}i:157;a:6:{i:0;s:802:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'cp_customers_flats_spam' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_spam'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2586529254913330078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9716440;}i:160;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=214";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2589690685272216796875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9720960;}i:163;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `cp_customers_flats_ignore`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2592380046844482421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9746176;}i:166;a:6:{i:0;s:806:"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` = 'cp_customers_flats_ignore' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_ignore'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.259654998779296875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9756680;}i:169;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=214";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2599489688873291015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9761040;}i:172;a:6:{i:0;s:546:"SELECT COUNT(*) FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id AND l.status=1 LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id AND sm_cp.is_deleted=0 LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE cs.status IN(1) AND cs.post_for IN(1) AND cs.sm_cp_id NOT IN(214) AND cs.type IN(2) AND cs.flat_type_id IN(1) AND cs.flat_property_type IN(1) AND (cs.carpet BETWEEN 380 AND 480) AND (cs.budget BETWEEN 6500000 AND 8500000) AND (cs.location_id IN (4))";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.26014995574951171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7387;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9768880;}i:175;a:6:{i:0;s:1159:"SELECT `cs`.`id`, `cs`.`post_id`, `cs`.`title`, `cs`.`description`, `cs`.`type`, `cs`.`budget`, `cs`.`flat_type_id`, `cs`.`flat_property_type`, `cs`.`carpet`, `cs`.`created_on`, `cs`.`modified_on`, `cs`.`status`, `cs`.`location_id`, `l`.`name` AS `location_name`, `sm_cp`.`name` AS `cp_name`, `cp`.`company_name` AS `cp_company_name`, `sm_cp`.`contact` AS `cp_contact`, `s`.`name` AS `verifiedby`, `cs`.`sm_cp_id`, `cs`.`post_for`, `cs`.`deposit`, `cs`.`monthly_rent`, `cs`.`landmark`, `cs`.`rental_type` FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id AND l.status=1 LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id AND sm_cp.is_deleted=0 LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE cs.status IN(1) AND cs.post_for IN(1) AND cs.sm_cp_id NOT IN(214) AND cs.type IN(2) AND cs.flat_type_id IN(1) AND cs.flat_property_type IN(1) AND (cs.carpet BETWEEN 380 AND 480) AND (cs.budget BETWEEN 6500000 AND 8500000) AND (cs.location_id IN (4)) ORDER BY DATE(cs.created_on) = CURDATE() DESC, FIELD(sm_cp.package_id, 8, 7, 6), `cs`.`modified_on` DESC LIMIT 15 OFFSET 15";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2607080936431884765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7394;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9783392;}i:178;a:6:{i:0;s:100:"Access to debugger is denied due to IP address restriction. The requesting IP address is 49.43.26.47";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1780566781.262216091156005859375;i:4;a:0:{}i:5;i:9799992;}}}";s:9:"profiling";s:56595:"a:3:{s:6:"memory";i:11705120;s:4:"time";d:0.0762579441070556640625;s:8:"messages";a:62:{i:85;a:6:{i:0;s:64:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_smcp";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1780566781.2176549434661865234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6337760;}i:86;a:6:{i:0;s:64:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_smcp";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1780566781.2180919647216796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6383288;}i:87;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:1780566781.2181160449981689453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6383888;}i:88;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:1780566781.2188479900360107421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6426760;}i:90;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:1780566781.2193601131439208984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6435888;}i:91;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:1780566781.21975994110107421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6438472;}i:93;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='9082068334') 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:1780566781.2219219207763671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6714736;}i:94;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='9082068334') 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:1780566781.222548007965087890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6722544;}i:96;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=214";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.2244050502777099609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6997312;}i:97;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=214";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.225205898284912109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6998936;}i:99;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:1780566781.225697040557861328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7029432;}i:100;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:1780566781.226149082183837890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7038040;}i:102;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:1780566781.22626590728759765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7040400;}i:103;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:1780566781.2265579700469970703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7042608;}i:105;a:6:{i:0;s:394:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/post_mypostresults?id=113&searchBy=4&sort_name=&sort_type=&page=2&page_count=15', 2, '{\"id\":\"113\",\"searchBy\":\"4\",\"sort_name\":\"\",\"sort_type\":\"\",\"page\":\"2\",\"page_count\":\"15\"}', '2026-06-04 15:23:01', 214, '{\"apk_type\":\"Android\",\"apk_version\":\"32\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.2267849445343017578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7042864;}i:106;a:6:{i:0;s:394:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/post_mypostresults?id=113&searchBy=4&sort_name=&sort_type=&page=2&page_count=15', 2, '{\"id\":\"113\",\"searchBy\":\"4\",\"sort_name\":\"\",\"sort_type\":\"\",\"page\":\"2\",\"page_count\":\"15\"}', '2026-06-04 15:23:01', 214, '{\"apk_type\":\"Android\",\"apk_version\":\"32\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.2328259944915771484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7044448;}i:110;a:6:{i:0;s:50:"SELECT * FROM `cp_customers_flats` WHERE id="113" ";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.250195026397705078125;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9413528;}i:111;a:6:{i:0;s:50:"SELECT * FROM `cp_customers_flats` WHERE id="113" ";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.250752925872802734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9419720;}i:113;a:6:{i:0;s:43:"SHOW FULL COLUMNS FROM `cp_customers_flats`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2508471012115478515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9425208;}i:114;a:6:{i:0;s:43:"SHOW FULL COLUMNS FROM `cp_customers_flats`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2514131069183349609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9466360;}i:116;a:6:{i:0;s:792:"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` = 'cp_customers_flats' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.251655101776123046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9451848;}i:117;a:6:{i:0;s:792:"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` = 'cp_customers_flats' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.251943111419677734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9454056;}i:119;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='9082068334') 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:1780566781.2521650791168212890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1431;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:9453616;}i:120;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='9082068334') 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:1780566781.252686977386474609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1431;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:9460296;}i:122;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=214";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.252986907958984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1431;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:9466824;}i:123;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=214";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.2531559467315673828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1431;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:9468448;}i:125;a:6:{i:0;s:46:"SELECT * FROM `channelpartner` WHERE `id`=2301";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2535030841827392578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9508568;}i:126;a:6:{i:0;s:46:"SELECT * FROM `channelpartner` WHERE `id`=2301";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2537410259246826171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9523784;}i:128;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:1780566781.2538020610809326171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9526608;}i:129;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:1780566781.254435062408447265625;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9609728;}i:131;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:1780566781.2548758983612060546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9581208;}i:132;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:1780566781.2551739215850830078125;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9583416;}i:134;a:6:{i:0;s:36:"SELECT * FROM `package` WHERE `id`=7";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2554290294647216796875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9604296;}i:135;a:6:{i:0;s:36:"SELECT * FROM `package` WHERE `id`=7";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2556159496307373046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9607928;}i:137;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `package`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2556641101837158203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9615744;}i:138;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `package`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2561900615692138671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9629376;}i:140;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` = 'package' AND `kcu`.`TABLE_NAME` = 'package'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2562940120697021484375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9631064;}i:141;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` = 'package' AND `kcu`.`TABLE_NAME` = 'package'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.25654506683349609375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9634024;}i:143;a:6:{i:0;s:65:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=214) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2566730976104736328125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:605;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7183;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9632664;}i:144;a:6:{i:0;s:65:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=214) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.256865024566650390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:605;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7183;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9639672;}i:146;a:6:{i:0;s:47:"SELECT `near_locs` FROM `location` WHERE `id`=4";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.257093906402587890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9660720;}i:147;a:6:{i:0;s:47:"SELECT `near_locs` FROM `location` WHERE `id`=4";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2572269439697265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9663176;}i:149;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `location`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2572700977325439453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9670008;}i:150;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `location`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2576749324798583984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9684544;}i:152;a:6:{i:0;s:772:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'location' AND `kcu`.`TABLE_NAME` = 'location'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.257791042327880859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9685736;}i:153;a:6:{i:0;s:772:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'location' AND `kcu`.`TABLE_NAME` = 'location'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2580249309539794921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9688696;}i:155;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `cp_customers_flats_spam`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2581970691680908203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9706816;}i:156;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `cp_customers_flats_spam`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2585771083831787109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9716160;}i:158;a:6:{i:0;s:802:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'cp_customers_flats_spam' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_spam'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2586638927459716796875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9720056;}i:159;a:6:{i:0;s:802:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'cp_customers_flats_spam' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_spam'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.258903026580810546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9723016;}i:161;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=214";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2589790821075439453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9722552;}i:162;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=214";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.259110927581787109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9724872;}i:164;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `cp_customers_flats_ignore`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2592489719390869140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9748328;}i:165;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `cp_customers_flats_ignore`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2595970630645751953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9754736;}i:167;a:6:{i:0;s:806:"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` = 'cp_customers_flats_ignore' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_ignore'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.259665966033935546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9760296;}i:168;a:6:{i:0;s:806:"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` = 'cp_customers_flats_ignore' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_ignore'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2598960399627685546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9763256;}i:170;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=214";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2599570751190185546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9762632;}i:171;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=214";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2600638866424560546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9764776;}i:173;a:6:{i:0;s:546:"SELECT COUNT(*) FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id AND l.status=1 LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id AND sm_cp.is_deleted=0 LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE cs.status IN(1) AND cs.post_for IN(1) AND cs.sm_cp_id NOT IN(214) AND cs.type IN(2) AND cs.flat_type_id IN(1) AND cs.flat_property_type IN(1) AND (cs.carpet BETWEEN 380 AND 480) AND (cs.budget BETWEEN 6500000 AND 8500000) AND (cs.location_id IN (4))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.260159015655517578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7387;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9771800;}i:174;a:6:{i:0;s:546:"SELECT COUNT(*) FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id AND l.status=1 LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id AND sm_cp.is_deleted=0 LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE cs.status IN(1) AND cs.post_for IN(1) AND cs.sm_cp_id NOT IN(214) AND cs.type IN(2) AND cs.flat_type_id IN(1) AND cs.flat_property_type IN(1) AND (cs.carpet BETWEEN 380 AND 480) AND (cs.budget BETWEEN 6500000 AND 8500000) AND (cs.location_id IN (4))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2605459690093994140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7387;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9773408;}i:176;a:6:{i:0;s:1159:"SELECT `cs`.`id`, `cs`.`post_id`, `cs`.`title`, `cs`.`description`, `cs`.`type`, `cs`.`budget`, `cs`.`flat_type_id`, `cs`.`flat_property_type`, `cs`.`carpet`, `cs`.`created_on`, `cs`.`modified_on`, `cs`.`status`, `cs`.`location_id`, `l`.`name` AS `location_name`, `sm_cp`.`name` AS `cp_name`, `cp`.`company_name` AS `cp_company_name`, `sm_cp`.`contact` AS `cp_contact`, `s`.`name` AS `verifiedby`, `cs`.`sm_cp_id`, `cs`.`post_for`, `cs`.`deposit`, `cs`.`monthly_rent`, `cs`.`landmark`, `cs`.`rental_type` FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id AND l.status=1 LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id AND sm_cp.is_deleted=0 LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE cs.status IN(1) AND cs.post_for IN(1) AND cs.sm_cp_id NOT IN(214) AND cs.type IN(2) AND cs.flat_type_id IN(1) AND cs.flat_property_type IN(1) AND (cs.carpet BETWEEN 380 AND 480) AND (cs.budget BETWEEN 6500000 AND 8500000) AND (cs.location_id IN (4)) ORDER BY DATE(cs.created_on) = CURDATE() DESC, FIELD(sm_cp.package_id, 8, 7, 6), `cs`.`modified_on` DESC LIMIT 15 OFFSET 15";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2607181072235107421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7394;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9787592;}i:177;a:6:{i:0;s:1159:"SELECT `cs`.`id`, `cs`.`post_id`, `cs`.`title`, `cs`.`description`, `cs`.`type`, `cs`.`budget`, `cs`.`flat_type_id`, `cs`.`flat_property_type`, `cs`.`carpet`, `cs`.`created_on`, `cs`.`modified_on`, `cs`.`status`, `cs`.`location_id`, `l`.`name` AS `location_name`, `sm_cp`.`name` AS `cp_name`, `cp`.`company_name` AS `cp_company_name`, `sm_cp`.`contact` AS `cp_contact`, `s`.`name` AS `verifiedby`, `cs`.`sm_cp_id`, `cs`.`post_for`, `cs`.`deposit`, `cs`.`monthly_rent`, `cs`.`landmark`, `cs`.`rental_type` FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id AND l.status=1 LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id AND sm_cp.is_deleted=0 LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE cs.status IN(1) AND cs.post_for IN(1) AND cs.sm_cp_id NOT IN(214) AND cs.type IN(2) AND cs.flat_type_id IN(1) AND cs.flat_property_type IN(1) AND (cs.carpet BETWEEN 380 AND 480) AND (cs.budget BETWEEN 6500000 AND 8500000) AND (cs.location_id IN (4)) ORDER BY DATE(cs.created_on) = CURDATE() DESC, FIELD(sm_cp.package_id, 8, 7, 6), `cs`.`modified_on` DESC LIMIT 15 OFFSET 15";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2616550922393798828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7394;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9789920;}}}";s:2:"db";s:55254:"a:1:{s:8:"messages";a:60:{i:87;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:1780566781.2181160449981689453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6383888;}i:88;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:1780566781.2188479900360107421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6426760;}i:90;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:1780566781.2193601131439208984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6435888;}i:91;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:1780566781.21975994110107421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6438472;}i:93;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='9082068334') 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:1780566781.2219219207763671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6714736;}i:94;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='9082068334') 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:1780566781.222548007965087890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6722544;}i:96;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=214";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.2244050502777099609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6997312;}i:97;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=214";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.225205898284912109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:47;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6998936;}i:99;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:1780566781.225697040557861328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7029432;}i:100;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:1780566781.226149082183837890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7038040;}i:102;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:1780566781.22626590728759765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7040400;}i:103;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:1780566781.2265579700469970703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:72;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7042608;}i:105;a:6:{i:0;s:394:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/post_mypostresults?id=113&searchBy=4&sort_name=&sort_type=&page=2&page_count=15', 2, '{\"id\":\"113\",\"searchBy\":\"4\",\"sort_name\":\"\",\"sort_type\":\"\",\"page\":\"2\",\"page_count\":\"15\"}', '2026-06-04 15:23:01', 214, '{\"apk_type\":\"Android\",\"apk_version\":\"32\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.2267849445343017578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7042864;}i:106;a:6:{i:0;s:394:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/post_mypostresults?id=113&searchBy=4&sort_name=&sort_type=&page=2&page_count=15', 2, '{\"id\":\"113\",\"searchBy\":\"4\",\"sort_name\":\"\",\"sort_type\":\"\",\"page\":\"2\",\"page_count\":\"15\"}', '2026-06-04 15:23:01', 214, '{\"apk_type\":\"Android\",\"apk_version\":\"32\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.2328259944915771484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:73;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7044448;}i:110;a:6:{i:0;s:50:"SELECT * FROM `cp_customers_flats` WHERE id="113" ";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.250195026397705078125;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9413528;}i:111;a:6:{i:0;s:50:"SELECT * FROM `cp_customers_flats` WHERE id="113" ";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.250752925872802734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9419720;}i:113;a:6:{i:0;s:43:"SHOW FULL COLUMNS FROM `cp_customers_flats`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2508471012115478515625;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9425208;}i:114;a:6:{i:0;s:43:"SHOW FULL COLUMNS FROM `cp_customers_flats`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2514131069183349609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9466360;}i:116;a:6:{i:0;s:792:"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` = 'cp_customers_flats' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.251655101776123046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9451848;}i:117;a:6:{i:0;s:792:"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` = 'cp_customers_flats' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.251943111419677734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1427;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9454056;}i:119;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='9082068334') 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:1780566781.2521650791168212890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1431;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:9453616;}i:120;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='9082068334') 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:1780566781.252686977386474609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1431;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:9460296;}i:122;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=214";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.252986907958984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1431;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:9466824;}i:123;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=214";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1780566781.2531559467315673828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:79:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/components/Common.php";s:4:"line";i: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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1431;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:9468448;}i:125;a:6:{i:0;s:46:"SELECT * FROM `channelpartner` WHERE `id`=2301";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2535030841827392578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9508568;}i:126;a:6:{i:0;s:46:"SELECT * FROM `channelpartner` WHERE `id`=2301";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2537410259246826171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9523784;}i:128;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:1780566781.2538020610809326171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9526608;}i:129;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:1780566781.254435062408447265625;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9609728;}i:131;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:1780566781.2548758983612060546875;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9581208;}i:132;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:1780566781.2551739215850830078125;i:4;a:1:{i:0;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1451;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9583416;}i:134;a:6:{i:0;s:36:"SELECT * FROM `package` WHERE `id`=7";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2554290294647216796875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9604296;}i:135;a:6:{i:0;s:36:"SELECT * FROM `package` WHERE `id`=7";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2556159496307373046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9607928;}i:137;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `package`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2556641101837158203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9615744;}i:138;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `package`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2561900615692138671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9629376;}i:140;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` = 'package' AND `kcu`.`TABLE_NAME` = 'package'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2562940120697021484375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9631064;}i:141;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` = 'package' AND `kcu`.`TABLE_NAME` = 'package'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.25654506683349609375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:203;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7166;s:8:"function";s:10:"getpackage";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9634024;}i:143;a:6:{i:0;s:65:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=214) AND (`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2566730976104736328125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:605;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7183;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9632664;}i:144;a:6:{i:0;s:65:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=214) AND (`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.256865024566650390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:605;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7183;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:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9639672;}i:146;a:6:{i:0;s:47:"SELECT `near_locs` FROM `location` WHERE `id`=4";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.257093906402587890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9660720;}i:147;a:6:{i:0;s:47:"SELECT `near_locs` FROM `location` WHERE `id`=4";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2572269439697265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9663176;}i:149;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `location`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2572700977325439453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9670008;}i:150;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `location`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2576749324798583984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9684544;}i:152;a:6:{i:0;s:772:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'location' AND `kcu`.`TABLE_NAME` = 'location'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.257791042327880859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9685736;}i:153;a:6:{i:0;s:772:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'location' AND `kcu`.`TABLE_NAME` = 'location'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2580249309539794921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:371;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7267;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9688696;}i:155;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `cp_customers_flats_spam`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2581970691680908203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9706816;}i:156;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `cp_customers_flats_spam`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2585771083831787109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9716160;}i:158;a:6:{i:0;s:802:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'cp_customers_flats_spam' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_spam'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2586638927459716796875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9720056;}i:159;a:6:{i:0;s:802:"SELECT
    `kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
    `kcu`.`COLUMN_NAME` AS `column_name`,
    `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
    `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
    (
        `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
        (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
    ) AND
    `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
    `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'cp_customers_flats_spam' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_spam'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.258903026580810546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9723016;}i:161;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=214";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2589790821075439453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9722552;}i:162;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=214";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.259110927581787109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:401;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7333;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9724872;}i:164;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `cp_customers_flats_ignore`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2592489719390869140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9748328;}i:165;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `cp_customers_flats_ignore`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2595970630645751953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9754736;}i:167;a:6:{i:0;s:806:"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` = 'cp_customers_flats_ignore' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_ignore'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.259665966033935546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9760296;}i:168;a:6:{i:0;s:806:"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` = 'cp_customers_flats_ignore' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_ignore'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2598960399627685546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9763256;}i:170;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=214";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2599570751190185546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9762632;}i:171;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=214";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2600638866424560546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:415;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7350;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9764776;}i:173;a:6:{i:0;s:546:"SELECT COUNT(*) FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id AND l.status=1 LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id AND sm_cp.is_deleted=0 LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE cs.status IN(1) AND cs.post_for IN(1) AND cs.sm_cp_id NOT IN(214) AND cs.type IN(2) AND cs.flat_type_id IN(1) AND cs.flat_property_type IN(1) AND (cs.carpet BETWEEN 380 AND 480) AND (cs.budget BETWEEN 6500000 AND 8500000) AND (cs.location_id IN (4))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.260159015655517578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7387;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9771800;}i:174;a:6:{i:0;s:546:"SELECT COUNT(*) FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id AND l.status=1 LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id AND sm_cp.is_deleted=0 LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE cs.status IN(1) AND cs.post_for IN(1) AND cs.sm_cp_id NOT IN(214) AND cs.type IN(2) AND cs.flat_type_id IN(1) AND cs.flat_property_type IN(1) AND (cs.carpet BETWEEN 380 AND 480) AND (cs.budget BETWEEN 6500000 AND 8500000) AND (cs.location_id IN (4))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2605459690093994140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7387;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9773408;}i:176;a:6:{i:0;s:1159:"SELECT `cs`.`id`, `cs`.`post_id`, `cs`.`title`, `cs`.`description`, `cs`.`type`, `cs`.`budget`, `cs`.`flat_type_id`, `cs`.`flat_property_type`, `cs`.`carpet`, `cs`.`created_on`, `cs`.`modified_on`, `cs`.`status`, `cs`.`location_id`, `l`.`name` AS `location_name`, `sm_cp`.`name` AS `cp_name`, `cp`.`company_name` AS `cp_company_name`, `sm_cp`.`contact` AS `cp_contact`, `s`.`name` AS `verifiedby`, `cs`.`sm_cp_id`, `cs`.`post_for`, `cs`.`deposit`, `cs`.`monthly_rent`, `cs`.`landmark`, `cs`.`rental_type` FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id AND l.status=1 LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id AND sm_cp.is_deleted=0 LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE cs.status IN(1) AND cs.post_for IN(1) AND cs.sm_cp_id NOT IN(214) AND cs.type IN(2) AND cs.flat_type_id IN(1) AND cs.flat_property_type IN(1) AND (cs.carpet BETWEEN 380 AND 480) AND (cs.budget BETWEEN 6500000 AND 8500000) AND (cs.location_id IN (4)) ORDER BY DATE(cs.created_on) = CURDATE() DESC, FIELD(sm_cp.package_id, 8, 7, 6), `cs`.`modified_on` DESC LIMIT 15 OFFSET 15";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2607181072235107421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7394;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9787592;}i:177;a:6:{i:0;s:1159:"SELECT `cs`.`id`, `cs`.`post_id`, `cs`.`title`, `cs`.`description`, `cs`.`type`, `cs`.`budget`, `cs`.`flat_type_id`, `cs`.`flat_property_type`, `cs`.`carpet`, `cs`.`created_on`, `cs`.`modified_on`, `cs`.`status`, `cs`.`location_id`, `l`.`name` AS `location_name`, `sm_cp`.`name` AS `cp_name`, `cp`.`company_name` AS `cp_company_name`, `sm_cp`.`contact` AS `cp_contact`, `s`.`name` AS `verifiedby`, `cs`.`sm_cp_id`, `cs`.`post_for`, `cs`.`deposit`, `cs`.`monthly_rent`, `cs`.`landmark`, `cs`.`rental_type` FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id AND l.status=1 LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id AND sm_cp.is_deleted=0 LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE cs.status IN(1) AND cs.post_for IN(1) AND cs.sm_cp_id NOT IN(214) AND cs.type IN(2) AND cs.flat_type_id IN(1) AND cs.flat_property_type IN(1) AND (cs.carpet BETWEEN 380 AND 480) AND (cs.budget BETWEEN 6500000 AND 8500000) AND (cs.location_id IN (4)) ORDER BY DATE(cs.created_on) = CURDATE() DESC, FIELD(sm_cp.package_id, 8, 7, 6), `cs`.`modified_on` DESC LIMIT 15 OFFSET 15";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1780566781.2616550922393798828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7394;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:105:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/CpconnectController.php";s:4:"line";i:1559;s:8:"function";s:13:"getmypostlist";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9789920;}}}";s:5:"event";s:9244:"a:49:{i:0;a:5:{s:4:"time";d:1780566781.209412097930908203125;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:1780566781.215262889862060546875;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:1780566781.2180860042572021484375;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:1780566781.2225849628448486328125;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:1780566781.222632884979248046875;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:1780566781.2227001190185546875;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:1780566781.2243020534515380859375;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:1780566781.2243139743804931640625;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:1780566781.225430011749267578125;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:1780566781.2255470752716064453125;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:1780566781.226605892181396484375;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:1780566781.22667598724365234375;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:1780566781.226685047149658203125;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:1780566781.2328860759735107421875;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:1780566781.2380158901214599609375;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:1780566781.2380249500274658203125;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:1780566781.2390921115875244140625;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:47:"app\modules\api\controllers\CpconnectController";}i:17;a:5:{s:4:"time";d:1780566781.25;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:18;a:5:{s:4:"time";d:1780566781.2501170635223388671875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:19;a:5:{s:4:"time";d:1780566781.2507960796356201171875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:27:"app\models\CpCustomersFlats";}i:20;a:5:{s:4:"time";d:1780566781.251987934112548828125;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:27:"app\models\CpCustomersFlats";}i:21;a:5:{s:4:"time";d:1780566781.25201702117919921875;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:22;a:5:{s:4:"time";d:1780566781.252706050872802734375;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:23;a:5:{s:4:"time";d:1780566781.252746105194091796875;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:24;a:5:{s:4:"time";d:1780566781.2527630329132080078125;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:25;a:5:{s:4:"time";d:1780566781.252912998199462890625;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:26;a:5:{s:4:"time";d:1780566781.25292205810546875;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:27;a:5:{s:4:"time";d:1780566781.2531731128692626953125;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:28;a:5:{s:4:"time";d:1780566781.25341510772705078125;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:1780566781.253758907318115234375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\models\Channelpartner";}i:30;a:5:{s:4:"time";d:1780566781.2552430629730224609375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\models\Channelpartner";}i:31;a:5:{s:4:"time";d:1780566781.255363941192626953125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:32;a:5:{s:4:"time";d:1780566781.255631923675537109375;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:"app\models\Package";}i:33;a:5:{s:4:"time";d:1780566781.256575107574462890625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"app\models\Package";}i:34;a:5:{s:4:"time";d:1780566781.256618022918701171875;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:35;a:5:{s:4:"time";d:1780566781.2568800449371337890625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:36;a:5:{s:4:"time";d:1780566781.25691890716552734375;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:37;a:5:{s:4:"time";d:1780566781.2570230960845947265625;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:38;a:5:{s:4:"time";d:1780566781.2572410106658935546875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"app\models\Location";}i:39;a:5:{s:4:"time";d:1780566781.25804805755615234375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"app\models\Location";}i:40;a:5:{s:4:"time";d:1780566781.2581489086151123046875;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:41;a:5:{s:4:"time";d:1780566781.2592051029205322265625;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:42;a:5:{s:4:"time";d:1780566781.2616961002349853515625;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:47:"app\modules\api\controllers\CpconnectController";}i:43;a:5:{s:4:"time";d:1780566781.2617061138153076171875;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:44;a:5:{s:4:"time";d:1780566781.26171207427978515625;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:45;a:5:{s:4:"time";d:1780566781.2617208957672119140625;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:46;a:5:{s:4:"time";d:1780566781.2617280483245849609375;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:47;a:5:{s:4:"time";d:1780566781.2622280120849609375;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:48;a:5:{s:4:"time";d:1780566781.2622549533843994140625;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:119:"a:3:{s:5:"start";d:1780566781.18778705596923828125;s:3:"end";d:1780566781.2643299102783203125;s:6:"memory";i:11705120;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:15002:"a:3:{s:8:"messages";a:75:{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:1780566781.2096340656280517578125;i:4;a:0:{}i:5;i:4914544;}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:1780566781.2096450328826904296875;i:4;a:0:{}i:5;i:4915296;}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:1780566781.20964908599853515625;i:4;a:0:{}i:5;i:4916048;}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:1780566781.2096540927886962890625;i:4;a:0:{}i:5;i:4917120;}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:1780566781.2096579074859619140625;i:4;a:0:{}i:5;i:4917872;}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:1780566781.209661006927490234375;i:4;a:0:{}i:5;i:4918624;}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:1780566781.2096641063690185546875;i:4;a:0:{}i:5;i:4919376;}i:13;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_create";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780566781.2096669673919677734375;i:4;a:0:{}i:5;i:4920128;}i:14;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_detail";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780566781.20967006683349609375;i:4;a:0:{}i:5;i:4920880;}i:15;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:1780566781.2096729278564453125;i:4;a:0:{}i:5;i:4921632;}i:16;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:1780566781.2096760272979736328125;i:4;a:0:{}i:5;i:4922384;}i:17;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:1780566781.2096788883209228515625;i:4;a:0:{}i:5;i:4923776;}i:18;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:1780566781.209681987762451171875;i:4;a:0:{}i:5;i:4924528;}i:19;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:1780566781.2096850872039794921875;i:4;a:0:{}i:5;i:4925280;}i:20;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:1780566781.2096879482269287109375;i:4;a:0:{}i:5;i:4926032;}i:21;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:1780566781.20969104766845703125;i:4;a:0:{}i:5;i:4926784;}i:22;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:1780566781.20969390869140625;i:4;a:0:{}i:5;i:4927536;}i:23;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:1780566781.2096970081329345703125;i:4;a:0:{}i:5;i:4928288;}i:24;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:1780566781.2096989154815673828125;i:4;a:0:{}i:5;i:4929040;}i:25;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:1780566781.209702968597412109375;i:4;a:0:{}i:5;i:4929792;}i:26;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:1780566781.2097060680389404296875;i:4;a:0:{}i:5;i:4930544;}i:27;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:1780566781.2097079753875732421875;i:4;a:0:{}i:5;i:4931296;}i:28;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:1780566781.2097110748291015625;i:4;a:0:{}i:5;i:4932048;}i:29;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:1780566781.20971393585205078125;i:4;a:0:{}i:5;i:4932800;}i:30;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:1780566781.2097170352935791015625;i:4;a:0:{}i:5;i:4933552;}i:31;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:1780566781.2097198963165283203125;i:4;a:0:{}i:5;i:4934304;}i:32;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:1780566781.209722995758056640625;i:4;a:0:{}i:5;i:4935056;}i:33;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:1780566781.2097260951995849609375;i:4;a:0:{}i:5;i:4937088;}i:34;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:1780566781.2097280025482177734375;i:4;a:0:{}i:5;i:4937840;}i:35;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:1780566781.20973110198974609375;i:4;a:0:{}i:5;i:4938592;}i:36;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:1780566781.2097339630126953125;i:4;a:0:{}i:5;i:4939344;}i:37;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:1780566781.2097370624542236328125;i:4;a:0:{}i:5;i:4940096;}i:38;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:1780566781.2097399234771728515625;i:4;a:0:{}i:5;i:4940848;}i:39;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:1780566781.209743022918701171875;i:4;a:0:{}i:5;i:4941600;}i:40;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:1780566781.209744930267333984375;i:4;a:0:{}i:5;i:4942352;}i:41;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:1780566781.2097480297088623046875;i:4;a:0:{}i:5;i:4943104;}i:42;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:1780566781.2097508907318115234375;i:4;a:0:{}i:5;i:4943856;}i:43;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:1780566781.20975494384765625;i:4;a:0:{}i:5;i:4944608;}i:44;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:1780566781.2097570896148681640625;i:4;a:0:{}i:5;i:4945360;}i:45;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:1780566781.2097599506378173828125;i:4;a:0:{}i:5;i:4946112;}i:46;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:1780566781.209763050079345703125;i:4;a:0:{}i:5;i:4946864;}i:47;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:1780566781.2097771167755126953125;i:4;a:0:{}i:5;i:4947616;}i:48;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:1780566781.2097799777984619140625;i:4;a:0:{}i:5;i:4948368;}i:49;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:1780566781.209783077239990234375;i:4;a:0:{}i:5;i:4949120;}i:50;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:1780566781.209785938262939453125;i:4;a:0:{}i:5;i:4949872;}i:51;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:1780566781.2097890377044677734375;i:4;a:0:{}i:5;i:4950624;}i:52;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:1780566781.2097909450531005859375;i:4;a:0:{}i:5;i:4951376;}i:53;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:1780566781.20979404449462890625;i:4;a:0:{}i:5;i:4952128;}i:54;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:1780566781.209796905517578125;i:4;a:0:{}i:5;i:4952880;}i:55;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:1780566781.2098000049591064453125;i:4;a:0:{}i:5;i:4953632;}i:56;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:1780566781.209803104400634765625;i:4;a:0:{}i:5;i:4954384;}i:57;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:1780566781.209805011749267578125;i:4;a:0:{}i:5;i:4955136;}i:58;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:1780566781.2098081111907958984375;i:4;a:0:{}i:5;i:4955888;}i:59;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:1780566781.2098100185394287109375;i:4;a:0:{}i:5;i:4956640;}i:60;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:1780566781.20981311798095703125;i:4;a:0:{}i:5;i:4957392;}i:61;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:1780566781.20981597900390625;i:4;a:0:{}i:5;i:4958144;}i:62;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:1780566781.2098178863525390625;i:4;a:0:{}i:5;i:4958896;}i:63;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:1780566781.2098209857940673828125;i:4;a:0:{}i:5;i:4959648;}i:64;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:1780566781.209824085235595703125;i:4;a:0:{}i:5;i:4960400;}i:65;a:6:{i:0;a:3:{s:4:"rule";s:8:"tg_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:1780566781.209826946258544921875;i:4;a:0:{}i:5;i:4966784;}i:66;a:6:{i:0;a:3:{s:4:"rule";s:9:"tg_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:1780566781.2098300457000732421875;i:4;a:0:{}i:5;i:4967536;}i:67;a:6:{i:0;a:3:{s:4:"rule";s:9:"tg_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:1780566781.2098319530487060546875;i:4;a:0:{}i:5;i:4968288;}i:68;a:6:{i:0;a:3:{s:4:"rule";s:7:"tg_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:1780566781.209835052490234375;i:4;a:0:{}i:5;i:4969040;}i:69;a:6:{i:0;a:3:{s:4:"rule";s:10:"tg_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:1780566781.2098391056060791015625;i:4;a:0:{}i:5;i:4969792;}i:70;a:6:{i:0;a:3:{s:4:"rule";s:15:"tg_updatestatus";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780566781.2098419666290283203125;i:4;a:0:{}i:5;i:4970544;}i:71;a:6:{i:0;a:3:{s:4:"rule";s:10:"tg_addfeed";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780566781.209845066070556640625;i:4;a:0:{}i:5;i:4971296;}i:72;a:6:{i:0;a:3:{s:4:"rule";s:11:"tg_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:1780566781.209847927093505859375;i:4;a:0:{}i:5;i:4972048;}i:73;a:6:{i:0;a:3:{s:4:"rule";s:9:"tk_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:1780566781.2098500728607177734375;i:4;a:0:{}i:5;i:4972800;}i:74;a:6:{i:0;a:3:{s:4:"rule";s:9:"tk_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:1780566781.2098529338836669921875;i:4;a:0:{}i:5;i:4973552;}i:75;a:6:{i:0;a:3:{s:4:"rule";s:7:"tk_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:1780566781.20985507965087890625;i:4;a:0:{}i:5;i:4974304;}i:76;a:6:{i:0;a:3:{s:4:"rule";s:11:"post_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:1780566781.209857940673828125;i:4;a:0:{}i:5;i:4975056;}i:77;a:6:{i:0;a:3:{s:4:"rule";s:15:"post_mypostlist";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780566781.2098610401153564453125;i:4;a:0:{}i:5;i:4975808;}i:78;a:6:{i:0;a:3:{s:4:"rule";s:17:"post_mypostdetail";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780566781.2098639011383056640625;i:4;a:0:{}i:5;i:4976560;}i:79;a:6:{i:0;s:48:"Request parsed with URL rule: post_mypostresults";i:1;i:8;i:2;s:29:"yii\web\UrlRule::parseRequest";i:3;d:1780566781.209868907928466796875;i:4;a:0:{}i:5;i:4977848;}i:80;a:6:{i:0;a:3:{s:4:"rule";s:18:"post_mypostresults";s:5:"match";b:1;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1780566781.2098729610443115234375;i:4;a:0:{}i:5;i:4978144;}}s:5:"route";s:27:"api/cpconnect/mypostresults";s:6:"action";s:70:"app\modules\api\controllers\CpconnectController::actionMypostresults()";}";s:7:"request";s:3291:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:7:{s:10:"user-agent";s:13:"okhttp/4.10.0";s:15:"accept-encoding";s:4:"gzip";s:10:"connection";s:10:"Keep-Alive";s:4:"host";s:22:"devapi.cpbroadcast.com";s:7:"version";s:2:"32";s:11:"channeltype";s:7:"Android";s:6:"apikey";s:10:"9082068334";}s:15:"responseHeaders";a:1:{s:12:"Content-Type";s:31:"application/json; charset=UTF-8";}s:5:"route";s:27:"api/cpconnect/mypostresults";s:6:"action";s:70:"app\modules\api\controllers\CpconnectController::actionMypostresults()";s:12:"actionParams";a:1:{s:2:"id";s:3:"113";}s:7:"general";a:5:{s:6:"method";s:3:"GET";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:1;}s:11:"requestBody";a:0:{}s:6:"SERVER";a:45:{s:4:"USER";s:8:"webprjlw";s:4:"HOME";s:14:"/home/webprjlw";s:11:"SCRIPT_NAME";s:22:"/backend/web/index.php";s:11:"REQUEST_URI";s:92:"/backend/web/post_mypostresults?id=113&searchBy=4&sort_name=&sort_type=&page=2&page_count=15";s:12:"QUERY_STRING";s:60:"id=113&searchBy=4&sort_name=&sort_type=&page=2&page_count=15";s:14:"REQUEST_METHOD";s:3:"GET";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:21:"REDIRECT_QUERY_STRING";s:60:"id=113&searchBy=4&sort_name=&sort_type=&page=2&page_count=15";s:12:"REDIRECT_URL";s:31:"/backend/web/post_mypostresults";s:11:"REMOTE_PORT";s:5:"47438";s:15:"SCRIPT_FILENAME";s:71:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/web/index.php";s:12:"SERVER_ADMIN";s:32:"webmaster@devapi.cpbroadcast.com";s:21:"CONTEXT_DOCUMENT_ROOT";s:49:"/home/webprjlw/public_html/devapi.cpbroadcast.com";s:14:"CONTEXT_PREFIX";s:0:"";s:14:"REQUEST_SCHEME";s:5:"https";s:13:"DOCUMENT_ROOT";s:49:"/home/webprjlw/public_html/devapi.cpbroadcast.com";s:11:"REMOTE_ADDR";s:11:"49.43.26.47";s:11:"SERVER_PORT";s:3:"443";s:11:"SERVER_ADDR";s:13:"65.254.80.108";s:11:"SERVER_NAME";s:22:"devapi.cpbroadcast.com";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:16:"SERVER_SIGNATURE";s:0:"";s:4:"PATH";s:180:"/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin";s:15:"HTTP_USER_AGENT";s:13:"okhttp/4.10.0";s:20:"HTTP_ACCEPT_ENCODING";s:4:"gzip";s:15:"HTTP_CONNECTION";s:10:"Keep-Alive";s:9:"HTTP_HOST";s:22:"devapi.cpbroadcast.com";s:12:"HTTP_VERSION";s:2:"32";s:16:"HTTP_CHANNELTYPE";s:7:"Android";s:11:"HTTP_APIKEY";s:10:"9082068334";s:17:"proxy-nokeepalive";s:1:"1";s:11:"SSL_TLS_SNI";s:22:"devapi.cpbroadcast.com";s:5:"HTTPS";s:2:"on";s:9:"UNIQUE_ID";s:27:"aiFK_QbiXJSSBzjZ1n6QfwAAAAQ";s:15:"REDIRECT_STATUS";s:3:"200";s:20:"REDIRECT_SSL_TLS_SNI";s:22:"devapi.cpbroadcast.com";s:14:"REDIRECT_HTTPS";s:2:"on";s:18:"REDIRECT_UNIQUE_ID";s:27:"aiFK_QbiXJSSBzjZ1n6QfwAAAAQ";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:22:"/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1780566781.1820180416107177734375;s:12:"REQUEST_TIME";i:1780566781;s:4:"argv";a:1:{i:0;s:60:"id=113&searchBy=4&sort_name=&sort_type=&page=2&page_count=15";}s:4:"argc";i:1;}s:3:"GET";a:6:{s:2:"id";s:3:"113";s:8:"searchBy";s:1:"4";s:9:"sort_name";s:0:"";s:9:"sort_type";s:0:"";s:4:"page";s:1:"2";s:10:"page_count";s:2:"15";}s:4:"POST";a:0:{}s:6:"COOKIE";a:0:{}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}";s:4:"user";s:2:"N;";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:13:{s:3:"tag";s:13:"6a214afd322d0";s:3:"url";s:122:"https://devapi.cpbroadcast.com/backend/web/post_mypostresults?id=113&searchBy=4&sort_name=&sort_type=&page=2&page_count=15";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:11:"49.43.26.47";s:4:"time";d:1780566781.1820180416107177734375;s:10:"statusCode";i:200;s:8:"sqlCount";i:30;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:11705120;s:14:"processingTime";d:0.0762579441070556640625;}s:10:"exceptions";a:0:{}}