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:12264:"a:1:{s:8:"messages";a:25:{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:1787752329.3335540294647216796875;i:4;a:0:{}i:5;i:2766592;}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:1787752329.33461093902587890625;i:4;a:0:{}i:5;i:2942736;}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:1787752329.3346469402313232421875;i:4;a:0:{}i:5;i:2943536;}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:1787752329.3432118892669677734375;i:4;a:0:{}i:5;i:4105288;}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:1787752329.3469040393829345703125;i:4;a:0:{}i:5;i:4669352;}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:1787752329.3471400737762451171875;i:4;a:0:{}i:5;i:4694248;}i:78;a:6:{i:0;s:41:"Route requested: 'api/cpconnect/postdata'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1787752329.3504660129547119140625;i:4;a:0:{}i:5;i:4975992;}i:79;a:6:{i:0;s:19:"Loading module: api";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1787752329.3504769802093505859375;i:4;a:0:{}i:5;i:4977624;}i:80;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:1787752329.3701000213623046875;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6377704;}i:81;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:1787752329.3701379299163818359375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6380520;}i:86;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:1787752329.3736488819122314453125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6481208;}i:89;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='8898180250') 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:1787752329.3770101070404052734375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6823976;}i:92;a:6:{i:0;s:51:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=17";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.3821580410003662109375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7041168;}i:95;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:1787752329.3828089237213134765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7073512;}i:98;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:1787752329.383470058441162109375;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7082984;}i:101;a:6:{i:0;s:600:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/post_create', 1, '{\"address\":\"Tagore Nagar, Vikhroli East, Mumbai, Maharashtra 400083, India\",\"budget\":\"6500000\",\"carpet\":\"400\",\"description\":\"1 bhk in Vikhroli\",\"flat_property_type\":\"1\",\"flat_type_id\":\"1\",\"landmark\":\"\",\"latitude\":\"19.1176258\",\"location_id\":\"4\",\"location_subtype_id\":\"1\",\"longitude\":\"72.9327686\",\"title\":\"looking for 1bhk\",\"type\":\"1\"}', '2026-08-26 19:22:09', 17, '{\"apk_type\":\"Android\",\"apk_version\":\"40\"}')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.38397693634033203125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7088152;}i:104;a:6:{i:0;s:36:"Route to run: api/cpconnect/postdata";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1787752329.39315891265869140625;i:4;a:0:{}i:5;i:7654144;}i:105;a:6:{i:0;s:81:"Running action: app\modules\api\controllers\CpconnectController::actionPostdata()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1787752329.3945500850677490234375;i:4;a:0:{}i:5;i:7855280;}i:106;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='8898180250') 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:1787752329.394732952117919921875;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:86;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7866408;}i:109;a:6:{i:0;s:51:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=17";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.39571094512939453125;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:86;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7879536;}i:112;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:1787752329.409924983978271484375;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9543272;}i:115;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:1787752329.4104340076446533203125;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9561736;}i:118;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:1787752329.41168308258056640625;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9613336;}i:121;a:6:{i:0;s:251:"SELECT COUNT(*) FROM (SELECT id FROM cp_customers_flats WHERE location_id='4' AND type='1' AND budget BETWEEN 5500000 AND 7500000 AND flat_property_type='1' AND flat_type_id='1' AND carpet BETWEEN 350 AND 450 AND sm_cp_id='17' AND status IN(0,1) ) `c`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787752329.41359996795654296875;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:179;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9636944;}i:124;a:6:{i:0;s:100:"Access to debugger is denied due to IP address restriction. The requesting IP address is 49.43.27.82";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1787752329.4158771038055419921875;i:4;a:0:{}i:5;i:9631864;}}}";s:9:"profiling";s:20586:"a:3:{s:6:"memory";i:11914648;s:4:"time";d:0.099151134490966796875;s:8:"messages";a:28:{i:82;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:1787752329.370151042938232421875;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6382024;}i:83;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:1787752329.371860027313232421875;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6427552;}i:84;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:1787752329.37189006805419921875;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6428152;}i:85;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:1787752329.3728659152984619140625;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6480856;}i:87;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:1787752329.373672962188720703125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6484448;}i:88;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:1787752329.37425708770751953125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6487032;}i:90;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='8898180250') 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:1787752329.377029895782470703125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6825152;}i:91;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='8898180250') 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:1787752329.37983608245849609375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6834200;}i:93;a:6:{i:0;s:51:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=17";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.382175922393798828125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7042760;}i:94;a:6:{i:0;s:51:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=17";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.3824470043182373046875;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7044384;}i:96;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:1787752329.3828399181365966796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7074880;}i:97;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:1787752329.38335895538330078125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7083488;}i:99;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:1787752329.3834888935089111328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7085848;}i:100;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:1787752329.3837831020355224609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7088056;}i:102;a:6:{i:0;s:600:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/post_create', 1, '{\"address\":\"Tagore Nagar, Vikhroli East, Mumbai, Maharashtra 400083, India\",\"budget\":\"6500000\",\"carpet\":\"400\",\"description\":\"1 bhk in Vikhroli\",\"flat_property_type\":\"1\",\"flat_type_id\":\"1\",\"landmark\":\"\",\"latitude\":\"19.1176258\",\"location_id\":\"4\",\"location_subtype_id\":\"1\",\"longitude\":\"72.9327686\",\"title\":\"looking for 1bhk\",\"type\":\"1\"}', '2026-08-26 19:22:09', 17, '{\"apk_type\":\"Android\",\"apk_version\":\"40\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.3839900493621826171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7088504;}i:103;a:6:{i:0;s:600:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/post_create', 1, '{\"address\":\"Tagore Nagar, Vikhroli East, Mumbai, Maharashtra 400083, India\",\"budget\":\"6500000\",\"carpet\":\"400\",\"description\":\"1 bhk in Vikhroli\",\"flat_property_type\":\"1\",\"flat_type_id\":\"1\",\"landmark\":\"\",\"latitude\":\"19.1176258\",\"location_id\":\"4\",\"location_subtype_id\":\"1\",\"longitude\":\"72.9327686\",\"title\":\"looking for 1bhk\",\"type\":\"1\"}', '2026-08-26 19:22:09', 17, '{\"apk_type\":\"Android\",\"apk_version\":\"40\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.3869190216064453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7090280;}i:107;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='8898180250') 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:1787752329.3947470188140869140625;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:86;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7867584;}i:108;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='8898180250') 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:1787752329.395412921905517578125;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:86;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7875176;}i:110;a:6:{i:0;s:51:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=17";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.3957240581512451171875;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:86;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7881128;}i:111;a:6:{i:0;s:51:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=17";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.3958919048309326171875;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:86;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7882752;}i:113;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:1787752329.4099419116973876953125;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9544720;}i:114;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:1787752329.410377025604248046875;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9560280;}i:116;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:1787752329.4104459285736083984375;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9563104;}i:117;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:1787752329.41114902496337890625;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9647888;}i:119;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:1787752329.4117000102996826171875;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9616200;}i:120;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:1787752329.4119870662689208984375;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9618408;}i:122;a:6:{i:0;s:251:"SELECT COUNT(*) FROM (SELECT id FROM cp_customers_flats WHERE location_id='4' AND type='1' AND budget BETWEEN 5500000 AND 7500000 AND flat_property_type='1' AND flat_type_id='1' AND carpet BETWEEN 350 AND 450 AND sm_cp_id='17' AND status IN(0,1) ) `c`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787752329.4136149883270263671875;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:179;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9638784;}i:123;a:6:{i:0;s:251:"SELECT COUNT(*) FROM (SELECT id FROM cp_customers_flats WHERE location_id='4' AND type='1' AND budget BETWEEN 5500000 AND 7500000 AND flat_property_type='1' AND flat_type_id='1' AND carpet BETWEEN 350 AND 450 AND sm_cp_id='17' AND status IN(0,1) ) `c`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787752329.4154961109161376953125;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:179;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9640016;}}}";s:2:"db";s:19245:"a:1:{s:8:"messages";a:26:{i:84;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:1787752329.37189006805419921875;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6428152;}i:85;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:1787752329.3728659152984619140625;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6480856;}i:87;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:1787752329.373672962188720703125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6484448;}i:88;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:1787752329.37425708770751953125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6487032;}i:90;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='8898180250') 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:1787752329.377029895782470703125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6825152;}i:91;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='8898180250') 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:1787752329.37983608245849609375;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6834200;}i:93;a:6:{i:0;s:51:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=17";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.382175922393798828125;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7042760;}i:94;a:6:{i:0;s:51:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=17";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.3824470043182373046875;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:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7044384;}i:96;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:1787752329.3828399181365966796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7074880;}i:97;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:1787752329.38335895538330078125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7083488;}i:99;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:1787752329.3834888935089111328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7085848;}i:100;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:1787752329.3837831020355224609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7088056;}i:102;a:6:{i:0;s:600:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/post_create', 1, '{\"address\":\"Tagore Nagar, Vikhroli East, Mumbai, Maharashtra 400083, India\",\"budget\":\"6500000\",\"carpet\":\"400\",\"description\":\"1 bhk in Vikhroli\",\"flat_property_type\":\"1\",\"flat_type_id\":\"1\",\"landmark\":\"\",\"latitude\":\"19.1176258\",\"location_id\":\"4\",\"location_subtype_id\":\"1\",\"longitude\":\"72.9327686\",\"title\":\"looking for 1bhk\",\"type\":\"1\"}', '2026-08-26 19:22:09', 17, '{\"apk_type\":\"Android\",\"apk_version\":\"40\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.3839900493621826171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7088504;}i:103;a:6:{i:0;s:600:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/post_create', 1, '{\"address\":\"Tagore Nagar, Vikhroli East, Mumbai, Maharashtra 400083, India\",\"budget\":\"6500000\",\"carpet\":\"400\",\"description\":\"1 bhk in Vikhroli\",\"flat_property_type\":\"1\",\"flat_type_id\":\"1\",\"landmark\":\"\",\"latitude\":\"19.1176258\",\"location_id\":\"4\",\"location_subtype_id\":\"1\",\"longitude\":\"72.9327686\",\"title\":\"looking for 1bhk\",\"type\":\"1\"}', '2026-08-26 19:22:09', 17, '{\"apk_type\":\"Android\",\"apk_version\":\"40\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.3869190216064453125;i:4;a:1:{i:0;a:5:{s:4:"file";s:83:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7090280;}i:107;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='8898180250') 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:1787752329.3947470188140869140625;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:86;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7867584;}i:108;a:6:{i:0;s:109:"SELECT * FROM `sm_cp` WHERE (`apikey`='8898180250') 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:1787752329.395412921905517578125;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:86;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7875176;}i:110;a:6:{i:0;s:51:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=17";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.3957240581512451171875;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:86;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7881128;}i:111;a:6:{i:0;s:51:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=17";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1787752329.3958919048309326171875;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:86;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7882752;}i:113;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:1787752329.4099419116973876953125;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9544720;}i:114;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:1787752329.410377025604248046875;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9560280;}i:116;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:1787752329.4104459285736083984375;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9563104;}i:117;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:1787752329.41114902496337890625;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9647888;}i:119;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:1787752329.4117000102996826171875;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9616200;}i:120;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:1787752329.4119870662689208984375;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:95;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:9618408;}i:122;a:6:{i:0;s:251:"SELECT COUNT(*) FROM (SELECT id FROM cp_customers_flats WHERE location_id='4' AND type='1' AND budget BETWEEN 5500000 AND 7500000 AND flat_property_type='1' AND flat_type_id='1' AND carpet BETWEEN 350 AND 450 AND sm_cp_id='17' AND status IN(0,1) ) `c`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787752329.4136149883270263671875;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:179;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9638784;}i:123;a:6:{i:0;s:251:"SELECT COUNT(*) FROM (SELECT id FROM cp_customers_flats WHERE location_id='4' AND type='1' AND budget BETWEEN 5500000 AND 7500000 AND flat_property_type='1' AND flat_type_id='1' AND carpet BETWEEN 350 AND 450 AND sm_cp_id='17' AND status IN(0,1) ) `c`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787752329.4154961109161376953125;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:179;s:8:"function";s:5:"count";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}i:5;i:9640016;}}}";s:5:"event";s:6869:"a:36:{i:0;a:5:{s:4:"time";d:1787752329.348926067352294921875;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:1787752329.3668220043182373046875;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:1787752329.3718550205230712890625;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:1787752329.3798720836639404296875;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:1787752329.37992191314697265625;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:1787752329.3799989223480224609375;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:1787752329.38206195831298828125;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:1787752329.382072925567626953125;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:1787752329.3825619220733642578125;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:1787752329.3826611042022705078125;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:1787752329.3838291168212890625;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:1787752329.3838961124420166015625;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:1787752329.383903980255126953125;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:1787752329.386992931365966796875;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:1787752329.39324092864990234375;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:1787752329.393249034881591796875;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:1787752329.3945369720458984375;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:1787752329.3945910930633544921875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:18;a:5:{s:4:"time";d:1787752329.39544200897216796875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:19;a:5:{s:4:"time";d:1787752329.3954999446868896484375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:20;a:5:{s:4:"time";d:1787752329.395514011383056640625;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:21;a:5:{s:4:"time";d:1787752329.39564990997314453125;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:22;a:5:{s:4:"time";d:1787752329.395657062530517578125;s:4:"name";s:12:"beforeUpdate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:23;a:5:{s:4:"time";d:1787752329.395915985107421875;s:4:"name";s:11:"afterUpdate";s:5:"class";s:21:"yii\db\AfterSaveEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:24;a:5:{s:4:"time";d:1787752329.4095270633697509765625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Common";}i:25;a:5:{s:4:"time";d:1787752329.4098660945892333984375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:26;a:5:{s:4:"time";d:1787752329.4104039669036865234375;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:27;a:5:{s:4:"time";d:1787752329.412064075469970703125;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:28;a:5:{s:4:"time";d:1787752329.4135038852691650390625;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:1787752329.4155409336090087890625;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:30;a:5:{s:4:"time";d:1787752329.4155490398406982421875;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:31;a:5:{s:4:"time";d:1787752329.415554046630859375;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:32;a:5:{s:4:"time";d:1787752329.415563106536865234375;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:33;a:5:{s:4:"time";d:1787752329.4155690670013427734375;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:34;a:5:{s:4:"time";d:1787752329.4158871173858642578125;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:35;a:5:{s:4:"time";d:1787752329.4159390926361083984375;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:123:"a:3:{s:5:"start";d:1787752329.3187339305877685546875;s:3:"end";d:1787752329.418016910552978515625;s:6:"memory";i:11914648;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:14365:"a:3:{s:8:"messages";a:72:{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:1787752329.34963703155517578125;i:4;a:0:{}i:5;i:4915264;}i:7;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1787752329.349708080291748046875;i:4;a:0:{}i:5;i:4916016;}i:8;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii//";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1787752329.349750041961669921875;i:4;a:0:{}i:5;i:4916768;}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:1787752329.34976291656494140625;i:4;a:0:{}i:5;i:4917840;}i:10;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug//";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1787752329.349791049957275390625;i:4;a:0:{}i:5;i:4918592;}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:1787752329.34980297088623046875;i:4;a:0:{}i:5;i:4919344;}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:1787752329.349812030792236328125;i:4;a:0:{}i:5;i:4920096;}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:1787752329.3498210906982421875;i:4;a:0:{}i:5;i:4920848;}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:1787752329.3498289585113525390625;i:4;a:0:{}i:5;i:4921600;}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:1787752329.3498439788818359375;i:4;a:0:{}i:5;i:4922352;}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:1787752329.349853038787841796875;i:4;a:0:{}i:5;i:4923104;}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:1787752329.34986209869384765625;i:4;a:0:{}i:5;i:4924496;}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:1787752329.3498699665069580078125;i:4;a:0:{}i:5;i:4925248;}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:1787752329.3498780727386474609375;i:4;a:0:{}i:5;i:4926000;}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:1787752329.3498859405517578125;i:4;a:0:{}i:5;i:4926752;}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:1787752329.349895000457763671875;i:4;a:0:{}i:5;i:4927504;}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:1787752329.34990596771240234375;i:4;a:0:{}i:5;i:4928256;}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:1787752329.349915027618408203125;i:4;a:0:{}i:5;i:4929008;}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:1787752329.3499228954315185546875;i:4;a:0:{}i:5;i:4929760;}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:1787752329.3499400615692138671875;i:4;a:0:{}i:5;i:4930512;}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:1787752329.349948883056640625;i:4;a:0:{}i:5;i:4931264;}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:1787752329.349956989288330078125;i:4;a:0:{}i:5;i:4932016;}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:1787752329.34996509552001953125;i:4;a:0:{}i:5;i:4932768;}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:1787752329.3499801158905029296875;i:4;a:0:{}i:5;i:4933520;}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:1787752329.3499889373779296875;i:4;a:0:{}i:5;i:4934272;}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:1787752329.349997997283935546875;i:4;a:0:{}i:5;i:4935024;}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:1787752329.35000705718994140625;i:4;a:0:{}i:5;i:4935776;}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:1787752329.3500149250030517578125;i:4;a:0:{}i:5;i:4937808;}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:1787752329.3500239849090576171875;i:4;a:0:{}i:5;i:4938560;}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:1787752329.350038051605224609375;i:4;a:0:{}i:5;i:4939312;}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:1787752329.3500459194183349609375;i:4;a:0:{}i:5;i:4940064;}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:1787752329.3500559329986572265625;i:4;a:0:{}i:5;i:4940816;}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:1787752329.3500640392303466796875;i:4;a:0:{}i:5;i:4941568;}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:1787752329.35007190704345703125;i:4;a:0:{}i:5;i:4942320;}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:1787752329.350080966949462890625;i:4;a:0:{}i:5;i:4943072;}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:1787752329.35008907318115234375;i:4;a:0:{}i:5;i:4943824;}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:1787752329.350100040435791015625;i:4;a:0:{}i:5;i:4944576;}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:1787752329.3501110076904296875;i:4;a:0:{}i:5;i:4945328;}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:1787752329.350119113922119140625;i:4;a:0:{}i:5;i:4946080;}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:1787752329.3501269817352294921875;i:4;a:0:{}i:5;i:4946832;}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:1787752329.3501360416412353515625;i:4;a:0:{}i:5;i:4947584;}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:1787752329.3501460552215576171875;i:4;a:0:{}i:5;i:4948336;}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:1787752329.3501551151275634765625;i:4;a:0:{}i:5;i:4949088;}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:1787752329.3501670360565185546875;i:4;a:0:{}i:5;i:4949840;}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:1787752329.3501760959625244140625;i:4;a:0:{}i:5;i:4950592;}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:1787752329.3501880168914794921875;i:4;a:0:{}i:5;i:4951344;}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:1787752329.3501970767974853515625;i:4;a:0:{}i:5;i:4952096;}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:1787752329.350205898284912109375;i:4;a:0:{}i:5;i:4952848;}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:1787752329.350215911865234375;i:4;a:0:{}i:5;i:4953600;}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:1787752329.3502418994903564453125;i:4;a:0:{}i:5;i:4954352;}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:1787752329.3502519130706787109375;i:4;a:0:{}i:5;i:4955104;}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:1787752329.3502600193023681640625;i:4;a:0:{}i:5;i:4955856;}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:1787752329.350267887115478515625;i:4;a:0:{}i:5;i:4956608;}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:1787752329.350276947021484375;i:4;a:0:{}i:5;i:4957360;}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:1787752329.350286006927490234375;i:4;a:0:{}i:5;i:4958112;}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:1787752329.3502941131591796875;i:4;a:0:{}i:5;i:4958864;}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:1787752329.350306034088134765625;i:4;a:0:{}i:5;i:4959616;}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:1787752329.35031795501708984375;i:4;a:0:{}i:5;i:4960368;}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:1787752329.350326061248779296875;i:4;a:0:{}i:5;i:4961120;}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:1787752329.3503339290618896484375;i:4;a:0:{}i:5;i:4967504;}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:1787752329.3503420352935791015625;i:4;a:0:{}i:5;i:4968256;}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:1787752329.350349903106689453125;i:4;a:0:{}i:5;i:4969008;}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:1787752329.35035800933837890625;i:4;a:0:{}i:5;i:4969760;}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:1787752329.350368976593017578125;i:4;a:0:{}i:5;i:4970512;}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:1787752329.350387096405029296875;i:4;a:0:{}i:5;i:4971264;}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:1787752329.3503949642181396484375;i:4;a:0:{}i:5;i:4972016;}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:1787752329.3504040241241455078125;i:4;a:0:{}i:5;i:4972768;}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:1787752329.350411891937255859375;i:4;a:0:{}i:5;i:4973520;}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:1787752329.3504199981689453125;i:4;a:0:{}i:5;i:4974272;}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:1787752329.350428104400634765625;i:4;a:0:{}i:5;i:4975024;}i:76;a:6:{i:0;s:41:"Request parsed with URL rule: post_create";i:1;i:8;i:2;s:29:"yii\web\UrlRule::parseRequest";i:3;d:1787752329.3504478931427001953125;i:4;a:0:{}i:5;i:4976304;}i:77;a:6:{i:0;a:3:{s:4:"rule";s:11:"post_create";s:5:"match";b:1;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1787752329.35046100616455078125;i:4;a:0:{}i:5;i:4976608;}}s:5:"route";s:22:"api/cpconnect/postdata";s:6:"action";s:65:"app\modules\api\controllers\CpconnectController::actionPostdata()";}";s:7:"request";s:3885:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:9:{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:14:"content-length";s:3:"333";s:12:"content-type";s:31:"application/json; charset=UTF-8";s:7:"version";s:2:"40";s:11:"channeltype";s:7:"Android";s:6:"apikey";s:10:"8898180250";}s:15:"responseHeaders";a:1:{s:12:"Content-Type";s:31:"application/json; charset=UTF-8";}s:5:"route";s:22:"api/cpconnect/postdata";s:6:"action";s:65:"app\modules\api\controllers\CpconnectController::actionPostdata()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:4:"POST";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:1;}s:11:"requestBody";a:3:{s:12:"Content Type";s:31:"application/json; charset=UTF-8";s:3:"Raw";s:333:"{"address":"Tagore Nagar, Vikhroli East, Mumbai, Maharashtra 400083, India","budget":"6500000","carpet":"400","description":"1 bhk in Vikhroli","flat_property_type":"1","flat_type_id":"1","landmark":"","latitude":"19.1176258","location_id":"4","location_subtype_id":"1","longitude":"72.9327686","title":"looking for 1bhk","type":"1"}";s:7:"Decoded";a:13:{s:7:"address";s:62:"Tagore Nagar, Vikhroli East, Mumbai, Maharashtra 400083, India";s:6:"budget";s:7:"6500000";s:6:"carpet";s:3:"400";s:11:"description";s:17:"1 bhk in Vikhroli";s:18:"flat_property_type";s:1:"1";s:12:"flat_type_id";s:1:"1";s:8:"landmark";s:0:"";s:8:"latitude";s:10:"19.1176258";s:11:"location_id";s:1:"4";s:19:"location_subtype_id";s:1:"1";s:9:"longitude";s:10:"72.9327686";s:5:"title";s:16:"looking for 1bhk";s:4:"type";s:1:"1";}}s:6:"SERVER";a:46:{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:24:"/backend/web/post_create";s:12:"QUERY_STRING";s:0:"";s:14:"REQUEST_METHOD";s:4:"POST";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:12:"REDIRECT_URL";s:24:"/backend/web/post_create";s:11:"REMOTE_PORT";s:5:"36383";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.27.82";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:14:"CONTENT_LENGTH";s:3:"333";s:12:"CONTENT_TYPE";s:31:"application/json; charset=UTF-8";s:12:"HTTP_VERSION";s:2:"40";s:16:"HTTP_CHANNELTYPE";s:7:"Android";s:11:"HTTP_APIKEY";s:10:"8898180250";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:"ao7viZoWU5g_uEwxBuQOJwAAABI";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:"ao7viZoWU5g_uEwxBuQOJwAAABI";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:22:"/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1787752329.3062140941619873046875;s:12:"REQUEST_TIME";i:1787752329;s:4:"argv";a:0:{}s:4:"argc";i:0;}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:0:{}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}";s:4:"user";s:2:"N;";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:13:{s:3:"tag";s:13:"6a8eef8953e64";s:3:"url";s:54:"https://devapi.cpbroadcast.com/backend/web/post_create";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:11:"49.43.27.82";s:4:"time";d:1787752329.3062140941619873046875;s:10:"statusCode";i:200;s:8:"sqlCount";i:13;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:11914648;s:14:"processingTime";d:0.099151134490966796875;}s:10:"exceptions";a:0:{}}