a:14:{s:6:"config";s:1630:"a:5:{s:10:"phpVersion";s:6:"8.0.30";s:10:"yiiVersion";s:8:"2.0.49.3";s:11:"application";a:8:{s:3:"yii";s:8:"2.0.49.3";s:4:"name";s:14:"My Application";s:7:"version";s:3:"1.0";s:8:"language";s:5:"en-US";s:14:"sourceLanguage";s:5:"en-US";s:7:"charset";s:5:"UTF-8";s:3:"env";s:3:"dev";s:5:"debug";b:1;}s:3:"php";a:5:{s:7:"version";s:6:"8.0.30";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:5:{s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/vendor/yiisoft/yii2-faker/src";}}s:26:"yiisoft/yii2-symfonymailer";a:3:{s:4:"name";s:26:"yiisoft/yii2-symfonymailer";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:18:"@yii/symfonymailer";s:84:"/home/webprjlw/public_html/api.cpbroadcast.com/vendor/yiisoft/yii2-symfonymailer/src";}}s:23:"yiisoft/yii2-bootstrap5";a:4:{s:4:"name";s:23:"yiisoft/yii2-bootstrap5";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap5";s:81:"/home/webprjlw/public_html/api.cpbroadcast.com/vendor/yiisoft/yii2-bootstrap5/src";}s:9:"bootstrap";s:40:"yii\bootstrap5\i18n\TranslationBootstrap";}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.2.6.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:74:"/home/webprjlw/public_html/api.cpbroadcast.com/vendor/yiisoft/yii2-gii/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.25.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/vendor/yiisoft/yii2-debug/src";}}}}";s:3:"log";s:16797:"a:1:{s:8:"messages";a:27:{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:1791237417.8642199039459228515625;i:4;a:0:{}i:5;i:2758448;}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:1791237417.8650701045989990234375;i:4;a:0:{}i:5;i:2934560;}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:1791237417.8650820255279541015625;i:4;a:0:{}i:5;i:2935360;}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:1791237417.87240695953369140625;i:4;a:0:{}i:5;i:4096984;}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:1791237417.8754460811614990234375;i:4;a:0:{}i:5;i:4662872;}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:1791237417.8756639957427978515625;i:4;a:0:{}i:5;i:4687736;}i:32;a:6:{i:0;s:35:"Route requested: 'api/project/list'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1791237417.877831935882568359375;i:4;a:0:{}i:5;i:4926640;}i:33;a:6:{i:0;s:19:"Loading module: api";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1791237417.87783908843994140625;i:4;a:0:{}i:5;i:4929544;}i:34;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:1791237417.893992900848388671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6284368;}i:35;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_cpbroadcast_smcp";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1791237417.8940660953521728515625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6287200;}i:40;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:1791237417.896850109100341796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6390560;}i:43;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='23e98278739d5ccf56e4b4775967b325') 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:1791237417.8999130725860595703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6672136;}i:46;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9341";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.9079520702362060546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6954912;}i:49;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:1791237417.90853404998779296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6987256;}i:52;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:1791237417.909069061279296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6996728;}i:55;a:6:{i:0;s:354:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/pr_list?type=7&sort_name=&sort_type=&page=1&page_count=15', 2, '{\"type\":\"7\",\"sort_name\":\"\",\"sort_type\":\"\",\"page\":\"1\",\"page_count\":\"15\"}', '2026-10-06 03:26:57', 9341, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.9095590114593505859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7001640;}i:58;a:6:{i:0;s:30:"Route to run: api/project/list";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1791237417.9136068820953369140625;i:4;a:0:{}i:5;i:7279192;}i:59;a:6:{i:0;s:75:"Running action: app\modules\api\controllers\ProjectController::actionList()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1791237417.9147770404815673828125;i:4;a:0:{}i:5;i:7480312;}i:60;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='23e98278739d5ccf56e4b4775967b325') 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:1791237417.9149420261383056640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:751;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7491472;}i:63;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9341";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.920269012451171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:751;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7504304;}i:66;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=34533";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.934791088104248046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9213584;}i:69;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:1791237417.93521404266357421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9232784;}i:72;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:1791237417.9364678859710693359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9285584;}i:75;a:6:{i:0;s:258:"SELECT `network`.* FROM `sm_cp_network` `network` LEFT JOIN `sm_cp` ON sm_cp.sm_cp_id = network.sm_cp_id WHERE (`network`.`status`=1) AND (`network`.`channelpartner_id`=34533) AND (`sm_cp`.`status`=1) AND (`sm_cp`.`staff_type`=1) AND (`sm_cp`.`is_deleted`=0)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.937139987945556640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2009;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2376;s:8:"function";s:9:"getsmofcp";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9310688;}i:78;a:6:{i:0;s:809:"SELECT COUNT(*) FROM `projects` LEFT JOIN (select MIN(base_price) as low_price,projects_id from flat WHERE status=1 group by projects_id ) m ON m.projects_id=projects.id LEFT JOIN (select MIN(total_charge) as total_low_price,projects_id from flat WHERE status=1 group by projects_id ) ml ON ml.projects_id=projects.id LEFT JOIN (select GROUP_CONCAT(flat_type_id) as flat_types,projects_id from flat WHERE status=1 GROUP by projects_id ) f ON f.projects_id=projects.id LEFT JOIN `location` `loc` ON projects.location_id = loc.id LEFT JOIN `builder` `b` ON projects.builder_id = b.id LEFT JOIN (select GROUP_CONCAT(property_type) as flat_property_types,projects_id from flat WHERE status=1 GROUP by projects_id ) fp ON fp.projects_id=projects.id WHERE projects.status=2 AND b.status=1 AND projects.id IN(-1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.9388411045074462890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2661;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9320096;}i:81;a:6:{i:0;s:1780:"SELECT `projects`.`id`, `projects`.`name`, `projects`.`offer`, `projects`.`site_address`, `projects`.`possession_date`, `projects`.`builder_id`, `projects`.`logo_name`, `projects`.`type`, `projects`.`flat_configuration`, `projects`.`project_segment`, `projects`.`created_on`, `m`.`low_price`, `ml`.`total_low_price`, `f`.`flat_types`, `fp`.`flat_property_types`, `projects`.`latlong`, `projects`.`whatsapp_brief`, `projects`.`location_id`, `loc`.`name` AS `location`, `projects`.`whatsapp_top`, `projects`.`whatsapp_middle`, `projects`.`whatsapp_bottom`, `projects`.`rera_no`, `projects`.`amenities`, `projects`.`connectivity`, `projects`.`tc`, `projects`.`api_show_price`, `projects`.`website_address`, `b`.`name` AS `builder_name`, `b`.`logo` AS `builder_logoval`, `projects`.`description_app`, `projects`.`signification_app`, `projects`.`project_description`, `projects`.`signification`, `projects`.`show_carpet` FROM `projects` LEFT JOIN (select MIN(base_price) as low_price,projects_id from flat WHERE status=1 group by projects_id ) m ON m.projects_id=projects.id LEFT JOIN (select MIN(total_charge) as total_low_price,projects_id from flat WHERE status=1 group by projects_id ) ml ON ml.projects_id=projects.id LEFT JOIN (select GROUP_CONCAT(flat_type_id) as flat_types,projects_id from flat WHERE status=1 GROUP by projects_id ) f ON f.projects_id=projects.id LEFT JOIN `location` `loc` ON projects.location_id = loc.id LEFT JOIN `builder` `b` ON projects.builder_id = b.id LEFT JOIN (select GROUP_CONCAT(property_type) as flat_property_types,projects_id from flat WHERE status=1 GROUP by projects_id ) fp ON fp.projects_id=projects.id WHERE projects.status=2 AND b.status=1 AND projects.id IN(-1) ORDER BY `projects`.`rank` DESC, `projects`.`created_on` DESC LIMIT 15";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.940001010894775390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2668;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9333528;}i:84;a:6:{i:0;s:102:"Access to debugger is denied due to IP address restriction. The requesting IP address is 152.58.29.229";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1791237417.941216945648193359375;i:4;a:0:{}i:5;i:9356632;}}}";s:9:"profiling";s:29691:"a:3:{s:6:"memory";i:11636872;s:4:"time";d:0.0907089710235595703125;s:8:"messages";a:32:{i:36;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_cpbroadcast_smcp";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1791237417.894074916839599609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6288704;}i:37;a:6:{i:0;s:76:"Opening DB connection: mysql:host=localhost;dbname=webprjlw_cpbroadcast_smcp";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1791237417.89505290985107421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6334288;}i:38;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:1791237417.89507198333740234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6334888;}i:39;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:1791237417.8962409496307373046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6393488;}i:41;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:1791237417.896872043609619140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6393800;}i:42;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:1791237417.8974421024322509765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6396384;}i:44;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='23e98278739d5ccf56e4b4775967b325') 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:1791237417.89993190765380859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6673312;}i:45;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='23e98278739d5ccf56e4b4775967b325') 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:1791237417.9059379100799560546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6682328;}i:47;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9341";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.9079799652099609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6956504;}i:48;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9341";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.908236980438232421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6958128;}i:50;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:1791237417.9085500240325927734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6988624;}i:51;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:1791237417.908976078033447265625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6997232;}i:53;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:1791237417.909081935882568359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6999592;}i:54;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:1791237417.909389972686767578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7001800;}i:56;a:6:{i:0;s:354:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/pr_list?type=7&sort_name=&sort_type=&page=1&page_count=15', 2, '{\"type\":\"7\",\"sort_name\":\"\",\"sort_type\":\"\",\"page\":\"1\",\"page_count\":\"15\"}', '2026-10-06 03:26:57', 9341, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.9095699787139892578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7001992;}i:57;a:6:{i:0;s:354:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/pr_list?type=7&sort_name=&sort_type=&page=1&page_count=15', 2, '{\"type\":\"7\",\"sort_name\":\"\",\"sort_type\":\"\",\"page\":\"1\",\"page_count\":\"15\"}', '2026-10-06 03:26:57', 9341, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.9106299877166748046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7003512;}i:61;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='23e98278739d5ccf56e4b4775967b325') 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:1791237417.91495609283447265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:751;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7492648;}i:62;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='23e98278739d5ccf56e4b4775967b325') 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:1791237417.9199559688568115234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:751;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7499944;}i:64;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9341";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.9202830791473388671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:751;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7505896;}i:65;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9341";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.920486927032470703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:751;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7513152;}i:67;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=34533";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.9348189830780029296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9215408;}i:68;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=34533";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.9351670742034912109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9230952;}i:70;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:1791237417.935225963592529296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9234528;}i:71;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:1791237417.9359569549560546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9319760;}i:73;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:1791237417.9364850521087646484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9288824;}i:74;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:1791237417.9367740154266357421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9291408;}i:76;a:6:{i:0;s:258:"SELECT `network`.* FROM `sm_cp_network` `network` LEFT JOIN `sm_cp` ON sm_cp.sm_cp_id = network.sm_cp_id WHERE (`network`.`status`=1) AND (`network`.`channelpartner_id`=34533) AND (`sm_cp`.`status`=1) AND (`sm_cp`.`staff_type`=1) AND (`sm_cp`.`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.9371559619903564453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2009;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2376;s:8:"function";s:9:"getsmofcp";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9312344;}i:77;a:6:{i:0;s:258:"SELECT `network`.* FROM `sm_cp_network` `network` LEFT JOIN `sm_cp` ON sm_cp.sm_cp_id = network.sm_cp_id WHERE (`network`.`status`=1) AND (`network`.`channelpartner_id`=34533) AND (`sm_cp`.`status`=1) AND (`sm_cp`.`staff_type`=1) AND (`sm_cp`.`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.93867206573486328125;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2009;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2376;s:8:"function";s:9:"getsmofcp";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9315440;}i:79;a:6:{i:0;s:809:"SELECT COUNT(*) FROM `projects` LEFT JOIN (select MIN(base_price) as low_price,projects_id from flat WHERE status=1 group by projects_id ) m ON m.projects_id=projects.id LEFT JOIN (select MIN(total_charge) as total_low_price,projects_id from flat WHERE status=1 group by projects_id ) ml ON ml.projects_id=projects.id LEFT JOIN (select GROUP_CONCAT(flat_type_id) as flat_types,projects_id from flat WHERE status=1 GROUP by projects_id ) f ON f.projects_id=projects.id LEFT JOIN `location` `loc` ON projects.location_id = loc.id LEFT JOIN `builder` `b` ON projects.builder_id = b.id LEFT JOIN (select GROUP_CONCAT(property_type) as flat_property_types,projects_id from flat WHERE status=1 GROUP by projects_id ) fp ON fp.projects_id=projects.id WHERE projects.status=2 AND b.status=1 AND projects.id IN(-1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.9388530254364013671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2661;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9323528;}i:80;a:6:{i:0;s:809:"SELECT COUNT(*) FROM `projects` LEFT JOIN (select MIN(base_price) as low_price,projects_id from flat WHERE status=1 group by projects_id ) m ON m.projects_id=projects.id LEFT JOIN (select MIN(total_charge) as total_low_price,projects_id from flat WHERE status=1 group by projects_id ) ml ON ml.projects_id=projects.id LEFT JOIN (select GROUP_CONCAT(flat_type_id) as flat_types,projects_id from flat WHERE status=1 GROUP by projects_id ) f ON f.projects_id=projects.id LEFT JOIN `location` `loc` ON projects.location_id = loc.id LEFT JOIN `builder` `b` ON projects.builder_id = b.id LEFT JOIN (select GROUP_CONCAT(property_type) as flat_property_types,projects_id from flat WHERE status=1 GROUP by projects_id ) fp ON fp.projects_id=projects.id WHERE projects.status=2 AND b.status=1 AND projects.id IN(-1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.9398899078369140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2661;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9325136;}i:82;a:6:{i:0;s:1780:"SELECT `projects`.`id`, `projects`.`name`, `projects`.`offer`, `projects`.`site_address`, `projects`.`possession_date`, `projects`.`builder_id`, `projects`.`logo_name`, `projects`.`type`, `projects`.`flat_configuration`, `projects`.`project_segment`, `projects`.`created_on`, `m`.`low_price`, `ml`.`total_low_price`, `f`.`flat_types`, `fp`.`flat_property_types`, `projects`.`latlong`, `projects`.`whatsapp_brief`, `projects`.`location_id`, `loc`.`name` AS `location`, `projects`.`whatsapp_top`, `projects`.`whatsapp_middle`, `projects`.`whatsapp_bottom`, `projects`.`rera_no`, `projects`.`amenities`, `projects`.`connectivity`, `projects`.`tc`, `projects`.`api_show_price`, `projects`.`website_address`, `b`.`name` AS `builder_name`, `b`.`logo` AS `builder_logoval`, `projects`.`description_app`, `projects`.`signification_app`, `projects`.`project_description`, `projects`.`signification`, `projects`.`show_carpet` FROM `projects` LEFT JOIN (select MIN(base_price) as low_price,projects_id from flat WHERE status=1 group by projects_id ) m ON m.projects_id=projects.id LEFT JOIN (select MIN(total_charge) as total_low_price,projects_id from flat WHERE status=1 group by projects_id ) ml ON ml.projects_id=projects.id LEFT JOIN (select GROUP_CONCAT(flat_type_id) as flat_types,projects_id from flat WHERE status=1 GROUP by projects_id ) f ON f.projects_id=projects.id LEFT JOIN `location` `loc` ON projects.location_id = loc.id LEFT JOIN `builder` `b` ON projects.builder_id = b.id LEFT JOIN (select GROUP_CONCAT(property_type) as flat_property_types,projects_id from flat WHERE status=1 GROUP by projects_id ) fp ON fp.projects_id=projects.id WHERE projects.status=2 AND b.status=1 AND projects.id IN(-1) ORDER BY `projects`.`rank` DESC, `projects`.`created_on` DESC LIMIT 15";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.94001007080078125;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2668;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9339008;}i:83;a:6:{i:0;s:1780:"SELECT `projects`.`id`, `projects`.`name`, `projects`.`offer`, `projects`.`site_address`, `projects`.`possession_date`, `projects`.`builder_id`, `projects`.`logo_name`, `projects`.`type`, `projects`.`flat_configuration`, `projects`.`project_segment`, `projects`.`created_on`, `m`.`low_price`, `ml`.`total_low_price`, `f`.`flat_types`, `fp`.`flat_property_types`, `projects`.`latlong`, `projects`.`whatsapp_brief`, `projects`.`location_id`, `loc`.`name` AS `location`, `projects`.`whatsapp_top`, `projects`.`whatsapp_middle`, `projects`.`whatsapp_bottom`, `projects`.`rera_no`, `projects`.`amenities`, `projects`.`connectivity`, `projects`.`tc`, `projects`.`api_show_price`, `projects`.`website_address`, `b`.`name` AS `builder_name`, `b`.`logo` AS `builder_logoval`, `projects`.`description_app`, `projects`.`signification_app`, `projects`.`project_description`, `projects`.`signification`, `projects`.`show_carpet` FROM `projects` LEFT JOIN (select MIN(base_price) as low_price,projects_id from flat WHERE status=1 group by projects_id ) m ON m.projects_id=projects.id LEFT JOIN (select MIN(total_charge) as total_low_price,projects_id from flat WHERE status=1 group by projects_id ) ml ON ml.projects_id=projects.id LEFT JOIN (select GROUP_CONCAT(flat_type_id) as flat_types,projects_id from flat WHERE status=1 GROUP by projects_id ) f ON f.projects_id=projects.id LEFT JOIN `location` `loc` ON projects.location_id = loc.id LEFT JOIN `builder` `b` ON projects.builder_id = b.id LEFT JOIN (select GROUP_CONCAT(property_type) as flat_property_types,projects_id from flat WHERE status=1 GROUP by projects_id ) fp ON fp.projects_id=projects.id WHERE projects.status=2 AND b.status=1 AND projects.id IN(-1) ORDER BY `projects`.`rank` DESC, `projects`.`created_on` DESC LIMIT 15";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.940577983856201171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2668;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9342048;}}}";s:2:"db";s:28338:"a:1:{s:8:"messages";a:30:{i:38;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:1791237417.89507198333740234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6334888;}i:39;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:1791237417.8962409496307373046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6393488;}i:41;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:1791237417.896872043609619140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6393800;}i:42;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:1791237417.8974421024322509765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6396384;}i:44;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='23e98278739d5ccf56e4b4775967b325') 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:1791237417.89993190765380859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6673312;}i:45;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='23e98278739d5ccf56e4b4775967b325') 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:1791237417.9059379100799560546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6682328;}i:47;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9341";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.9079799652099609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6956504;}i:48;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9341";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.908236980438232421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:48;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:6958128;}i:50;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:1791237417.9085500240325927734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6988624;}i:51;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:1791237417.908976078033447265625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6997232;}i:53;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:1791237417.909081935882568359375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:6999592;}i:54;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:1791237417.909389972686767578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:89;s:8:"function";s:4:"load";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:7001800;}i:56;a:6:{i:0;s:354:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/pr_list?type=7&sort_name=&sort_type=&page=1&page_count=15', 2, '{\"type\":\"7\",\"sort_name\":\"\",\"sort_type\":\"\",\"page\":\"1\",\"page_count\":\"15\"}', '2026-10-06 03:26:57', 9341, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.9095699787139892578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7001992;}i:57;a:6:{i:0;s:354:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/pr_list?type=7&sort_name=&sort_type=&page=1&page_count=15', 2, '{\"type\":\"7\",\"sort_name\":\"\",\"sort_type\":\"\",\"page\":\"1\",\"page_count\":\"15\"}', '2026-10-06 03:26:57', 9341, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.9106299877166748046875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/ApiModule.php";s:4:"line";i:90;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:7003512;}i:61;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='23e98278739d5ccf56e4b4775967b325') 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:1791237417.91495609283447265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:751;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7492648;}i:62;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='23e98278739d5ccf56e4b4775967b325') 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:1791237417.9199559688568115234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:126;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:751;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7499944;}i:64;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9341";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.9202830791473388671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:751;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7505896;}i:65;a:6:{i:0;s:53:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=9341";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1791237417.920486927032470703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:76:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/components/Common.php";s:4:"line";i:143;s:8:"function";s:4:"save";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:751;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7513152;}i:67;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=34533";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.9348189830780029296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9215408;}i:68;a:6:{i:0;s:47:"SELECT * FROM `channelpartner` WHERE `id`=34533";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.9351670742034912109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9230952;}i:70;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:1791237417.935225963592529296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9234528;}i:71;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:1791237417.9359569549560546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9319760;}i:73;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:1791237417.9364850521087646484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9288824;}i:74;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:1791237417.9367740154266357421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2353;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9291408;}i:76;a:6:{i:0;s:258:"SELECT `network`.* FROM `sm_cp_network` `network` LEFT JOIN `sm_cp` ON sm_cp.sm_cp_id = network.sm_cp_id WHERE (`network`.`status`=1) AND (`network`.`channelpartner_id`=34533) AND (`sm_cp`.`status`=1) AND (`sm_cp`.`staff_type`=1) AND (`sm_cp`.`is_deleted`=0)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.9371559619903564453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2009;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2376;s:8:"function";s:9:"getsmofcp";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9312344;}i:77;a:6:{i:0;s:258:"SELECT `network`.* FROM `sm_cp_network` `network` LEFT JOIN `sm_cp` ON sm_cp.sm_cp_id = network.sm_cp_id WHERE (`network`.`status`=1) AND (`network`.`channelpartner_id`=34533) AND (`sm_cp`.`status`=1) AND (`sm_cp`.`staff_type`=1) AND (`sm_cp`.`is_deleted`=0)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.93867206573486328125;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2009;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2376;s:8:"function";s:9:"getsmofcp";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9315440;}i:79;a:6:{i:0;s:809:"SELECT COUNT(*) FROM `projects` LEFT JOIN (select MIN(base_price) as low_price,projects_id from flat WHERE status=1 group by projects_id ) m ON m.projects_id=projects.id LEFT JOIN (select MIN(total_charge) as total_low_price,projects_id from flat WHERE status=1 group by projects_id ) ml ON ml.projects_id=projects.id LEFT JOIN (select GROUP_CONCAT(flat_type_id) as flat_types,projects_id from flat WHERE status=1 GROUP by projects_id ) f ON f.projects_id=projects.id LEFT JOIN `location` `loc` ON projects.location_id = loc.id LEFT JOIN `builder` `b` ON projects.builder_id = b.id LEFT JOIN (select GROUP_CONCAT(property_type) as flat_property_types,projects_id from flat WHERE status=1 GROUP by projects_id ) fp ON fp.projects_id=projects.id WHERE projects.status=2 AND b.status=1 AND projects.id IN(-1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.9388530254364013671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2661;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9323528;}i:80;a:6:{i:0;s:809:"SELECT COUNT(*) FROM `projects` LEFT JOIN (select MIN(base_price) as low_price,projects_id from flat WHERE status=1 group by projects_id ) m ON m.projects_id=projects.id LEFT JOIN (select MIN(total_charge) as total_low_price,projects_id from flat WHERE status=1 group by projects_id ) ml ON ml.projects_id=projects.id LEFT JOIN (select GROUP_CONCAT(flat_type_id) as flat_types,projects_id from flat WHERE status=1 GROUP by projects_id ) f ON f.projects_id=projects.id LEFT JOIN `location` `loc` ON projects.location_id = loc.id LEFT JOIN `builder` `b` ON projects.builder_id = b.id LEFT JOIN (select GROUP_CONCAT(property_type) as flat_property_types,projects_id from flat WHERE status=1 GROUP by projects_id ) fp ON fp.projects_id=projects.id WHERE projects.status=2 AND b.status=1 AND projects.id IN(-1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.9398899078369140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2661;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:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9325136;}i:82;a:6:{i:0;s:1780:"SELECT `projects`.`id`, `projects`.`name`, `projects`.`offer`, `projects`.`site_address`, `projects`.`possession_date`, `projects`.`builder_id`, `projects`.`logo_name`, `projects`.`type`, `projects`.`flat_configuration`, `projects`.`project_segment`, `projects`.`created_on`, `m`.`low_price`, `ml`.`total_low_price`, `f`.`flat_types`, `fp`.`flat_property_types`, `projects`.`latlong`, `projects`.`whatsapp_brief`, `projects`.`location_id`, `loc`.`name` AS `location`, `projects`.`whatsapp_top`, `projects`.`whatsapp_middle`, `projects`.`whatsapp_bottom`, `projects`.`rera_no`, `projects`.`amenities`, `projects`.`connectivity`, `projects`.`tc`, `projects`.`api_show_price`, `projects`.`website_address`, `b`.`name` AS `builder_name`, `b`.`logo` AS `builder_logoval`, `projects`.`description_app`, `projects`.`signification_app`, `projects`.`project_description`, `projects`.`signification`, `projects`.`show_carpet` FROM `projects` LEFT JOIN (select MIN(base_price) as low_price,projects_id from flat WHERE status=1 group by projects_id ) m ON m.projects_id=projects.id LEFT JOIN (select MIN(total_charge) as total_low_price,projects_id from flat WHERE status=1 group by projects_id ) ml ON ml.projects_id=projects.id LEFT JOIN (select GROUP_CONCAT(flat_type_id) as flat_types,projects_id from flat WHERE status=1 GROUP by projects_id ) f ON f.projects_id=projects.id LEFT JOIN `location` `loc` ON projects.location_id = loc.id LEFT JOIN `builder` `b` ON projects.builder_id = b.id LEFT JOIN (select GROUP_CONCAT(property_type) as flat_property_types,projects_id from flat WHERE status=1 GROUP by projects_id ) fp ON fp.projects_id=projects.id WHERE projects.status=2 AND b.status=1 AND projects.id IN(-1) ORDER BY `projects`.`rank` DESC, `projects`.`created_on` DESC LIMIT 15";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.94001007080078125;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2668;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9339008;}i:83;a:6:{i:0;s:1780:"SELECT `projects`.`id`, `projects`.`name`, `projects`.`offer`, `projects`.`site_address`, `projects`.`possession_date`, `projects`.`builder_id`, `projects`.`logo_name`, `projects`.`type`, `projects`.`flat_configuration`, `projects`.`project_segment`, `projects`.`created_on`, `m`.`low_price`, `ml`.`total_low_price`, `f`.`flat_types`, `fp`.`flat_property_types`, `projects`.`latlong`, `projects`.`whatsapp_brief`, `projects`.`location_id`, `loc`.`name` AS `location`, `projects`.`whatsapp_top`, `projects`.`whatsapp_middle`, `projects`.`whatsapp_bottom`, `projects`.`rera_no`, `projects`.`amenities`, `projects`.`connectivity`, `projects`.`tc`, `projects`.`api_show_price`, `projects`.`website_address`, `b`.`name` AS `builder_name`, `b`.`logo` AS `builder_logoval`, `projects`.`description_app`, `projects`.`signification_app`, `projects`.`project_description`, `projects`.`signification`, `projects`.`show_carpet` FROM `projects` LEFT JOIN (select MIN(base_price) as low_price,projects_id from flat WHERE status=1 group by projects_id ) m ON m.projects_id=projects.id LEFT JOIN (select MIN(total_charge) as total_low_price,projects_id from flat WHERE status=1 group by projects_id ) ml ON ml.projects_id=projects.id LEFT JOIN (select GROUP_CONCAT(flat_type_id) as flat_types,projects_id from flat WHERE status=1 GROUP by projects_id ) f ON f.projects_id=projects.id LEFT JOIN `location` `loc` ON projects.location_id = loc.id LEFT JOIN `builder` `b` ON projects.builder_id = b.id LEFT JOIN (select GROUP_CONCAT(property_type) as flat_property_types,projects_id from flat WHERE status=1 GROUP by projects_id ) fp ON fp.projects_id=projects.id WHERE projects.status=2 AND b.status=1 AND projects.id IN(-1) ORDER BY `projects`.`rank` DESC, `projects`.`created_on` DESC LIMIT 15";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1791237417.940577983856201171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:72:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:2668;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/modules/api/controllers/ProjectController.php";s:4:"line";i:773;s:8:"function";s:17:"getprojectlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9342048;}}}";s:5:"event";s:6865:"a:36:{i:0;a:5:{s:4:"time";d:1791237417.8771688938140869140625;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:1791237417.8911240100860595703125;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:1791237417.8950479030609130859375;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:1791237417.9059751033782958984375;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:1791237417.90602207183837890625;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:1791237417.9060840606689453125;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:1791237417.9078609943389892578125;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:1791237417.9078719615936279296875;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:1791237417.90830707550048828125;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:1791237417.908412933349609375;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:1791237417.9094250202178955078125;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:1791237417.9094860553741455078125;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:1791237417.909493923187255859375;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:1791237417.91067409515380859375;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:1791237417.913671016693115234375;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:1791237417.91368007659912109375;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:1791237417.9147551059722900390625;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:45:"app\modules\api\controllers\ProjectController";}i:17;a:5:{s:4:"time";d:1791237417.914805889129638671875;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:1791237417.9199979305267333984375;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:1791237417.920053005218505859375;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:1791237417.9200680255889892578125;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:1791237417.920207977294921875;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:1791237417.920216083526611328125;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:1791237417.920505046844482421875;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:1791237417.934360027313232421875;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:1791237417.934731006622314453125;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:1791237417.935185909271240234375;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:1791237417.9368460178375244140625;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:1791237417.93696308135986328125;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:1791237417.9406139850616455078125;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:45:"app\modules\api\controllers\ProjectController";}i:30;a:5:{s:4:"time";d:1791237417.9406230449676513671875;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:1791237417.94062900543212890625;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:1791237417.940637111663818359375;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:1791237417.9406440258026123046875;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:1791237417.9412300586700439453125;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:1791237417.9412820339202880859375;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:124:"a:3:{s:5:"start";d:1791237417.8522970676422119140625;s:3:"end";d:1791237417.9431669712066650390625;s:6:"memory";i:11636872;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:5247:"a:3:{s:8:"messages";a:26:{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:1791237417.877521038055419921875;i:4;a:0:{}i:5;i:4907128;}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:1791237417.877564907073974609375;i:4;a:0:{}i:5;i:4907880;}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:1791237417.8775980472564697265625;i:4;a:0:{}i:5;i:4908632;}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:1791237417.8776099681854248046875;i:4;a:0:{}i:5;i:4909704;}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:1791237417.87763690948486328125;i:4;a:0:{}i:5;i:4910456;}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:1791237417.8776490688323974609375;i:4;a:0:{}i:5;i:4911208;}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:1791237417.87765789031982421875;i:4;a:0:{}i:5;i:4911960;}i:13;a:6:{i:0;a:3:{s:4:"rule";s:11:"showcontact";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.877666950225830078125;i:4;a:0:{}i:5;i:4912712;}i:14;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_create";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.8776760101318359375;i:4;a:0:{}i:5;i:4913464;}i:15;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_detail";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.877686977386474609375;i:4;a:0:{}i:5;i:4914216;}i:16;a:6:{i:0;a:3:{s:4:"rule";s:8:"ld_stats";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.8776950836181640625;i:4;a:0:{}i:5;i:4914968;}i:17;a:6:{i:0;a:3:{s:4:"rule";s:7:"ld_list";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.8777039051055908203125;i:4;a:0:{}i:5;i:4916360;}i:18;a:6:{i:0;a:3:{s:4:"rule";s:11:"ld_listname";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.8777129650115966796875;i:4;a:0:{}i:5;i:4917112;}i:19;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_update";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.8777210712432861328125;i:4;a:0:{}i:5;i:4917864;}i:20;a:6:{i:0;a:3:{s:4:"rule";s:9:"ld_delete";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.877728939056396484375;i:4;a:0:{}i:5;i:4918616;}i:21;a:6:{i:0;a:3:{s:4:"rule";s:11:"ld_feedback";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.87773799896240234375;i:4;a:0:{}i:5;i:4919368;}i:22;a:6:{i:0;a:3:{s:4:"rule";s:10:"ld_monthly";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.8777520656585693359375;i:4;a:0:{}i:5;i:4920120;}i:23;a:6:{i:0;a:3:{s:4:"rule";s:8:"loc_list";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.87776088714599609375;i:4;a:0:{}i:5;i:4920872;}i:24;a:6:{i:0;a:3:{s:4:"rule";s:11:"locsub_list";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.877768993377685546875;i:4;a:0:{}i:5;i:4921624;}i:25;a:6:{i:0;a:3:{s:4:"rule";s:12:"locationlist";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.87777805328369140625;i:4;a:0:{}i:5;i:4922376;}i:26;a:6:{i:0;a:3:{s:4:"rule";s:7:"mk_list";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.8777859210968017578125;i:4;a:0:{}i:5;i:4923128;}i:27;a:6:{i:0;a:3:{s:4:"rule";s:10:"mk_connect";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.8777940273284912109375;i:4;a:0:{}i:5;i:4923880;}i:28;a:6:{i:0;a:3:{s:4:"rule";s:9:"pr_detail";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.8778018951416015625;i:4;a:0:{}i:5;i:4924632;}i:29;a:6:{i:0;a:3:{s:4:"rule";s:11:"pr_bookmark";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.8778131008148193359375;i:4;a:0:{}i:5;i:4925384;}i:30;a:6:{i:0;s:37:"Request parsed with URL rule: pr_list";i:1;i:8;i:2;s:29:"yii\web\UrlRule::parseRequest";i:3;d:1791237417.8778250217437744140625;i:4;a:0:{}i:5;i:4926640;}i:31;a:6:{i:0;a:3:{s:4:"rule";s:7:"pr_list";s:5:"match";b:1;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1791237417.8778278827667236328125;i:4;a:0:{}i:5;i:4926952;}}s:5:"route";s:16:"api/project/list";s:6:"action";s:59:"app\modules\api\controllers\ProjectController::actionList()";}";s:7:"request";s:3015:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:7:{s:15:"accept-encoding";s:4:"gzip";s:6:"apikey";s:32:"23e98278739d5ccf56e4b4775967b325";s:11:"channeltype";s:7:"Android";s:10:"connection";s:10:"Keep-Alive";s:4:"host";s:19:"api.cpbroadcast.com";s:10:"user-agent";s:13:"okhttp/4.10.0";s:7:"version";s:2:"43";}s:15:"responseHeaders";a:1:{s:12:"Content-Type";s:31:"application/json; charset=UTF-8";}s:5:"route";s:16:"api/project/list";s:6:"action";s:59:"app\modules\api\controllers\ProjectController::actionList()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:3:"GET";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:1;}s:11:"requestBody";a:0:{}s:6:"SERVER";a:43:{s:21:"CONTEXT_DOCUMENT_ROOT";s:46:"/home/webprjlw/public_html/api.cpbroadcast.com";s:14:"CONTEXT_PREFIX";s:0:"";s:13:"DOCUMENT_ROOT";s:46:"/home/webprjlw/public_html/api.cpbroadcast.com";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:5:"HTTPS";s:2:"on";s:20:"HTTP_ACCEPT_ENCODING";s:4:"gzip";s:11:"HTTP_APIKEY";s:32:"23e98278739d5ccf56e4b4775967b325";s:16:"HTTP_CHANNELTYPE";s:7:"Android";s:15:"HTTP_CONNECTION";s:10:"Keep-Alive";s:9:"HTTP_HOST";s:19:"api.cpbroadcast.com";s:15:"HTTP_USER_AGENT";s:13:"okhttp/4.10.0";s:12:"HTTP_VERSION";s:2:"43";s:4:"PATH";s:13:"/bin:/usr/bin";s:16:"PHP_INI_SCAN_DIR";s:67:"/opt/cpanel/ea-php80/root/etc:/opt/cpanel/ea-php80/root/etc/php.d:.";s:12:"QUERY_STRING";s:49:"type=7&sort_name=&sort_type=&page=1&page_count=15";s:14:"REDIRECT_HTTPS";s:2:"on";s:21:"REDIRECT_QUERY_STRING";s:49:"type=7&sort_name=&sort_type=&page=1&page_count=15";s:20:"REDIRECT_SSL_TLS_SNI";s:19:"api.cpbroadcast.com";s:15:"REDIRECT_STATUS";s:3:"200";s:18:"REDIRECT_UNIQUE_ID";s:27:"asQdKdXOwfboBFD8e0iFjgAAABM";s:12:"REDIRECT_URL";s:20:"/backend/web/pr_list";s:11:"REMOTE_ADDR";s:13:"152.58.29.229";s:11:"REMOTE_PORT";s:5:"39254";s:14:"REQUEST_METHOD";s:3:"GET";s:14:"REQUEST_SCHEME";s:5:"https";s:11:"REQUEST_URI";s:70:"/backend/web/pr_list?type=7&sort_name=&sort_type=&page=1&page_count=15";s:15:"SCRIPT_FILENAME";s:68:"/home/webprjlw/public_html/api.cpbroadcast.com/backend/web/index.php";s:11:"SCRIPT_NAME";s:22:"/backend/web/index.php";s:11:"SERVER_ADDR";s:13:"65.254.80.108";s:12:"SERVER_ADMIN";s:29:"webmaster@api.cpbroadcast.com";s:11:"SERVER_NAME";s:19:"api.cpbroadcast.com";s:11:"SERVER_PORT";s:3:"443";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:16:"SERVER_SIGNATURE";s:0:"";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:11:"SSL_TLS_SNI";s:19:"api.cpbroadcast.com";s:2:"TZ";s:12:"Asia/Kolkata";s:9:"UNIQUE_ID";s:27:"asQdKdXOwfboBFD8e0iFjgAAABM";s:8:"PHP_SELF";s:22:"/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1791237417.845983982086181640625;s:12:"REQUEST_TIME";i:1791237417;s:4:"argv";a:1:{i:0;s:49:"type=7&sort_name=&sort_type=&page=1&page_count=15";}s:4:"argc";i:1;}s:3:"GET";a:5:{s:4:"type";s:1:"7";s:9:"sort_name";s:0:"";s:9:"sort_type";s:0:"";s:4:"page";s:1:"1";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:"6ac41d29d5143";s:3:"url";s:97:"https://api.cpbroadcast.com/backend/web/pr_list?type=7&sort_name=&sort_type=&page=1&page_count=15";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:13:"152.58.29.229";s:4:"time";d:1791237417.845983982086181640625;s:10:"statusCode";i:200;s:8:"sqlCount";i:15;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:11636872;s:14:"processingTime";d:0.0907089710235595703125;}s:10:"exceptions";a:0:{}}