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:31414:"a:1:{s:8:"messages";a:42:{i:0;a:6:{i:0;s:68:"Bootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1792412712.1842000484466552734375;i:4;a:0:{}i:5;i:2768744;}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:1792412712.1851050853729248046875;i:4;a:0:{}i:5;i:2944888;}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:1792412712.18513393402099609375;i:4;a:0:{}i:5;i:2945688;}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:1792412712.204905986785888671875;i:4;a:0:{}i:5;i:4107440;}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:1792412712.208218097686767578125;i:4;a:0:{}i:5;i:4684408;}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:1792412712.2084629535675048828125;i:4;a:0:{}i:5;i:4709304;}i:19;a:6:{i:0;s:32:"Route requested: 'api/lead/list'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1792412712.211460113525390625;i:4;a:0:{}i:5;i:4938432;}i:20;a:6:{i:0;s:19:"Loading module: api";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1792412712.2114698886871337890625;i:4;a:0:{}i:5;i:4940056;}i:21;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:1792412712.22196197509765625;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:127;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:6298640;}i:22;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:1792412712.2220079898834228515625;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:127;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:6301456;}i:27;a:6:{i:0;s:766:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'sm_cp' AND `kcu`.`TABLE_NAME` = 'sm_cp'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2261741161346435546875;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:127;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:6404776;}i:30;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='00cc13c88446bf744c72b0d46bf5829c') 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:1792412712.229569911956787109375;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:127;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:6686400;}i:33;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=308";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.23626995086669921875;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:144;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:6970664;}i:36;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:1792412712.237265110015869140625;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:7003008;}i:39;a:6:{i:0;s:770:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'log_api' AND `kcu`.`TABLE_NAME` = 'log_api'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2381069660186767578125;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:7012480;}i:42;a:6:{i:0;s:387:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/ld_list?type=4&sort_name=followup_date&sort_type=desc&page=1&page_count=15', 2, '{\"type\":\"4\",\"sort_name\":\"followup_date\",\"sort_type\":\"desc\",\"page\":\"1\",\"page_count\":\"15\"}', '2026-10-19 17:55:12', 308, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.2387330532073974609375;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:7017456;}i:45;a:6:{i:0;s:27:"Route to run: api/lead/list";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1792412712.2428190708160400390625;i:4;a:0:{}i:5;i:7287016;}i:46;a:6:{i:0;s:72:"Running action: app\modules\api\controllers\LeadController::actionList()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1792412712.2440059185028076171875;i:4;a:0:{}i:5;i:7488152;}i:47;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='00cc13c88446bf744c72b0d46bf5829c') 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:1792412712.2442400455474853515625;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:127;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1152;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7499312;}i:50;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=308";i:1;i:4;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.2462189197540283203125;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:144;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1152;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7512336;}i:53;a:6:{i:0;s:82:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=308) AND (`is_deleted`=0) AND (`status`=1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.264112949371337890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:628;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10296;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9385448;}i:56;a:6:{i:0;s:402:"SELECT `sm_cp1`.`sm_cp_id` FROM `sm_cp` `sm_cp1` LEFT JOIN `sm_cp` `sm_cp2` ON sm_cp1.parent_id=sm_cp2.sm_cp_id AND sm_cp2.is_deleted=0 AND sm_cp2.status=1 LEFT JOIN `sm_cp` `sm_cp3` ON sm_cp2.parent_id=sm_cp3.sm_cp_id AND sm_cp3.is_deleted=0 AND sm_cp3.status=1 WHERE ((308 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=308) AND sm_cp1.is_deleted=0 AND sm_cp1.status=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2649719715118408203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:639;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10296;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9391968;}i:59;a:6:{i:0;s:418:"SELECT COUNT(*) FROM `leadmaster` LEFT JOIN (select count(t.id) as tag_count,t.lead_id from taggingmaster t group by t.lead_id ) tag ON tag.lead_id=leadmaster.id LEFT JOIN `sm_cp` `creator` ON leadmaster.created_by=creator.sm_cp_id LEFT JOIN `sm_cp` `modifier` ON leadmaster.modified_by=modifier.sm_cp_id WHERE leadmaster.created_by IN(308) AND leadmaster.is_deleted=0 AND DATE(leadmaster.created_on)="2026-10-19" ";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2667140960693359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10509;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9400400;}i:62;a:6:{i:0;s:1054:"SELECT `leadmaster`.`id`, `leadmaster`.`name`, `leadmaster`.`lead_id`, `leadmaster`.`email`, `leadmaster`.`flat_type_id`, `leadmaster`.`contact`, `leadmaster`.`budget`, `leadmaster`.`min_budget`, `leadmaster`.`max_budget`, `leadmaster`.`customer_type`, `leadmaster`.`followup_date`, `leadmaster`.`followup_time`, `leadmaster`.`status`, `leadmaster`.`tagging`, `tag`.`tag_count`, `leadmaster`.`created_on`, `leadmaster`.`modified_on`, `creator`.`name` AS `createdby`, `modifier`.`name` AS `modifiedby`, `leadmaster`.`carpet`, `leadmaster`.`location_id`, `leadmaster`.`flat_property_type`, `leadmaster`.`lead_type` FROM `leadmaster` LEFT JOIN (select count(t.id) as tag_count,t.lead_id from taggingmaster t group by t.lead_id ) tag ON tag.lead_id=leadmaster.id LEFT JOIN `sm_cp` `creator` ON leadmaster.created_by=creator.sm_cp_id LEFT JOIN `sm_cp` `modifier` ON leadmaster.modified_by=modifier.sm_cp_id WHERE leadmaster.created_by IN(308) AND leadmaster.is_deleted=0 AND DATE(leadmaster.created_on)="2026-10-19" ORDER BY `followup_date` DESC LIMIT 15";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2677059173583984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10516;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9412424;}i:65;a:6:{i:0;s:230:"SELECT `fd`.`id`, `fd`.`feedback`, `fd`.`created_on`, `sm`.`sm_cp_id`, `sm`.`name`, `sm`.`role` FROM `lead_feedback` `fd` LEFT JOIN `sm_cp` `sm` ON fd.created_by = sm.sm_cp_id WHERE fd.lead_id="356" ORDER BY `fd`.`id` DESC LIMIT 5";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2689530849456787109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10641;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9429976;}i:68;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `cp_customers_flats_spam`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.26955509185791015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9460536;}i:71;a:6:{i:0;s:802:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cp_customers_flats_spam' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_spam'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2702519893646240234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9472312;}i:74;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=308";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.270742893218994140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9476864;}i:77;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `cp_customers_flats_ignore`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2711238861083984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9502080;}i:80;a:6:{i:0;s:806:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cp_customers_flats_ignore' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_ignore'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2717020511627197265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9512584;}i:83;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=308";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2720921039581298828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9516944;}i:86;a:6:{i:0;s:322:"SELECT COUNT(*) FROM (SELECT `p`.`id` AS `pid` FROM `flat` `f` LEFT JOIN `projects` `p` ON f.projects_id=p.id LEFT JOIN `builder` `b` ON p.builder_id=b.id WHERE FIND_IN_SET("4",p.type) AND f.property_type=1 AND p.status=2 AND f.status=1 AND b.status=1 AND (f.base_price BETWEEN 8000000 AND 10000000) GROUP BY `p`.`id`) `c`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2723560333251953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7036;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10677;s:8:"function";s:15:"getrtmiprojects";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9522792;}i:89;a:6:{i:0;s:77:"SELECT `loc`.`name` FROM `location` `loc` WHERE loc.id IN(4) AND loc.status=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2733590602874755859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10563;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9526936;}i:92;a:6:{i:0;s:230:"SELECT `fd`.`id`, `fd`.`feedback`, `fd`.`created_on`, `sm`.`sm_cp_id`, `sm`.`name`, `sm`.`role` FROM `lead_feedback` `fd` LEFT JOIN `sm_cp` `sm` ON fd.created_by = sm.sm_cp_id WHERE fd.lead_id="358" ORDER BY `fd`.`id` DESC LIMIT 5";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2737538814544677734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10641;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9532904;}i:95;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=308";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.27412891387939453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9544000;}i:98;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=308";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.27441501617431640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9550112;}i:101;a:6:{i:0;s:49:"SELECT `near_locs` FROM `location` WHERE `id`='4'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2748029232025146484375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9577488;}i:104;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `location`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.27501201629638671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9586224;}i:107;a:6:{i:0;s:772:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'location' AND `kcu`.`TABLE_NAME` = 'location'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.275640010833740234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9600464;}i:110;a:6:{i:0;s:689:"SELECT COUNT(*) FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE sm_cp.post_block=0 AND cs.post_for=1 AND cs.type="2" AND cs.flat_type_id IN(2) AND cs.flat_property_type IN(1) AND cs.carpet BETWEEN -50 AND 50 AND cs.sm_cp_id NOT IN(308) AND sm_cp.is_deleted=0 AND sm_cp.status=1 AND cp.status=1 AND (cs.location_id IN (4) OR (cs.budget BETWEEN 6600000 AND 8600000 AND cs.location_id IN(3,4,8,15,16,18,19,21,22,23,29,48,50,51,79,80,116,117,118,119,131,132,134,135,142,171))) AND cs.status IN(1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.276103973388671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7980;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9604600;}i:113;a:6:{i:0;s:345:"SELECT COUNT(*) FROM (SELECT `p`.`id` AS `pid` FROM `flat` `f` LEFT JOIN `projects` `p` ON f.projects_id=p.id LEFT JOIN `builder` `b` ON p.builder_id=b.id WHERE FIND_IN_SET("4",p.type) AND f.property_type=1 AND p.status=2 AND f.status=1 AND b.status=1 AND p.location_id IN(4) AND (f.base_price BETWEEN 6600000 AND 8600000) GROUP BY `p`.`id`) `c`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.27793598175048828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7036;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10677;s:8:"function";s:15:"getrtmiprojects";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9608856;}i:116;a:6:{i:0;s:104:"Access to debugger is denied due to IP address restriction. The requesting IP address is 106.222.252.244";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1792412712.2800738811492919921875;i:4;a:0:{}i:5;i:9638104;}}}";s:9:"profiling";s:58990:"a:3:{s:6:"memory";i:12355240;s:4:"time";d:0.149217128753662109375;s:8:"messages";a:62:{i:23;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:1792412712.2220170497894287109375;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:127;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:6302960;}i:24;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:1792412712.2245280742645263671875;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:127;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:6348488;}i:25;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:1792412712.224584102630615234375;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:127;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:6349088;}i:26;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:1792412712.225429058074951171875;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:127;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:6407624;}i:28;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:1792412712.22620296478271484375;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:127;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:6408016;}i:29;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:1792412712.2269461154937744140625;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:127;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:6410600;}i:31;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='00cc13c88446bf744c72b0d46bf5829c') 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:1792412712.2295930385589599609375;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:127;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:6687576;}i:32;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='00cc13c88446bf744c72b0d46bf5829c') 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:1792412712.2339470386505126953125;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:127;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:6696816;}i:34;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=308";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.2363109588623046875;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:144;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:6972256;}i:35;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=308";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.236875057220458984375;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:144;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:6973880;}i:37;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:1792412712.237286090850830078125;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:7004376;}i:38;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:1792412712.237988948822021484375;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:7012984;}i:40;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:1792412712.2381229400634765625;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:7015344;}i:41;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:1792412712.238500118255615234375;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:7017552;}i:43;a:6:{i:0;s:387:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/ld_list?type=4&sort_name=followup_date&sort_type=desc&page=1&page_count=15', 2, '{\"type\":\"4\",\"sort_name\":\"followup_date\",\"sort_type\":\"desc\",\"page\":\"1\",\"page_count\":\"15\"}', '2026-10-19 17:55:12', 308, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.23875904083251953125;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:7017808;}i:44;a:6:{i:0;s:387:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/ld_list?type=4&sort_name=followup_date&sort_type=desc&page=1&page_count=15', 2, '{\"type\":\"4\",\"sort_name\":\"followup_date\",\"sort_type\":\"desc\",\"page\":\"1\",\"page_count\":\"15\"}', '2026-10-19 17:55:12', 308, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.239758014678955078125;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:7019392;}i:48;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='00cc13c88446bf744c72b0d46bf5829c') 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:1792412712.2442591190338134765625;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:127;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1152;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7500488;}i:49;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='00cc13c88446bf744c72b0d46bf5829c') 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:1792412712.2458450794219970703125;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:127;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1152;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7508008;}i:51;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=308";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.246243953704833984375;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:144;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1152;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7513928;}i:52;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=308";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.246479034423828125;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:144;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1152;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7515552;}i:54;a:6:{i:0;s:82:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=308) AND (`is_deleted`=0) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.26414394378662109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:628;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10296;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9387216;}i:55;a:6:{i:0;s:82:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=308) AND (`is_deleted`=0) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2646520137786865234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:628;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10296;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9395000;}i:57;a:6:{i:0;s:402:"SELECT `sm_cp1`.`sm_cp_id` FROM `sm_cp` `sm_cp1` LEFT JOIN `sm_cp` `sm_cp2` ON sm_cp1.parent_id=sm_cp2.sm_cp_id AND sm_cp2.is_deleted=0 AND sm_cp2.status=1 LEFT JOIN `sm_cp` `sm_cp3` ON sm_cp2.parent_id=sm_cp3.sm_cp_id AND sm_cp3.is_deleted=0 AND sm_cp3.status=1 WHERE ((308 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=308) AND sm_cp1.is_deleted=0 AND sm_cp1.status=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.26498699188232421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:639;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10296;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9394880;}i:58;a:6:{i:0;s:402:"SELECT `sm_cp1`.`sm_cp_id` FROM `sm_cp` `sm_cp1` LEFT JOIN `sm_cp` `sm_cp2` ON sm_cp1.parent_id=sm_cp2.sm_cp_id AND sm_cp2.is_deleted=0 AND sm_cp2.status=1 LEFT JOIN `sm_cp` `sm_cp3` ON sm_cp2.parent_id=sm_cp3.sm_cp_id AND sm_cp3.is_deleted=0 AND sm_cp3.status=1 WHERE ((308 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=308) AND sm_cp1.is_deleted=0 AND sm_cp1.status=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2664630413055419921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:639;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10296;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9396848;}i:60;a:6:{i:0;s:418:"SELECT COUNT(*) FROM `leadmaster` LEFT JOIN (select count(t.id) as tag_count,t.lead_id from taggingmaster t group by t.lead_id ) tag ON tag.lead_id=leadmaster.id LEFT JOIN `sm_cp` `creator` ON leadmaster.created_by=creator.sm_cp_id LEFT JOIN `sm_cp` `modifier` ON leadmaster.modified_by=modifier.sm_cp_id WHERE leadmaster.created_by IN(308) AND leadmaster.is_deleted=0 AND DATE(leadmaster.created_on)="2026-10-19" ";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2667300701141357421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10509;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9402936;}i:61;a:6:{i:0;s:418:"SELECT COUNT(*) FROM `leadmaster` LEFT JOIN (select count(t.id) as tag_count,t.lead_id from taggingmaster t group by t.lead_id ) tag ON tag.lead_id=leadmaster.id LEFT JOIN `sm_cp` `creator` ON leadmaster.created_by=creator.sm_cp_id LEFT JOIN `sm_cp` `modifier` ON leadmaster.modified_by=modifier.sm_cp_id WHERE leadmaster.created_by IN(308) AND leadmaster.is_deleted=0 AND DATE(leadmaster.created_on)="2026-10-19" ";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2675430774688720703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10509;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9404544;}i:63;a:6:{i:0;s:1054:"SELECT `leadmaster`.`id`, `leadmaster`.`name`, `leadmaster`.`lead_id`, `leadmaster`.`email`, `leadmaster`.`flat_type_id`, `leadmaster`.`contact`, `leadmaster`.`budget`, `leadmaster`.`min_budget`, `leadmaster`.`max_budget`, `leadmaster`.`customer_type`, `leadmaster`.`followup_date`, `leadmaster`.`followup_time`, `leadmaster`.`status`, `leadmaster`.`tagging`, `tag`.`tag_count`, `leadmaster`.`created_on`, `leadmaster`.`modified_on`, `creator`.`name` AS `createdby`, `modifier`.`name` AS `modifiedby`, `leadmaster`.`carpet`, `leadmaster`.`location_id`, `leadmaster`.`flat_property_type`, `leadmaster`.`lead_type` FROM `leadmaster` LEFT JOIN (select count(t.id) as tag_count,t.lead_id from taggingmaster t group by t.lead_id ) tag ON tag.lead_id=leadmaster.id LEFT JOIN `sm_cp` `creator` ON leadmaster.created_by=creator.sm_cp_id LEFT JOIN `sm_cp` `modifier` ON leadmaster.modified_by=modifier.sm_cp_id WHERE leadmaster.created_by IN(308) AND leadmaster.is_deleted=0 AND DATE(leadmaster.created_on)="2026-10-19" ORDER BY `followup_date` DESC LIMIT 15";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2677190303802490234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10516;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9416624;}i:64;a:6:{i:0;s:1054:"SELECT `leadmaster`.`id`, `leadmaster`.`name`, `leadmaster`.`lead_id`, `leadmaster`.`email`, `leadmaster`.`flat_type_id`, `leadmaster`.`contact`, `leadmaster`.`budget`, `leadmaster`.`min_budget`, `leadmaster`.`max_budget`, `leadmaster`.`customer_type`, `leadmaster`.`followup_date`, `leadmaster`.`followup_time`, `leadmaster`.`status`, `leadmaster`.`tagging`, `tag`.`tag_count`, `leadmaster`.`created_on`, `leadmaster`.`modified_on`, `creator`.`name` AS `createdby`, `modifier`.`name` AS `modifiedby`, `leadmaster`.`carpet`, `leadmaster`.`location_id`, `leadmaster`.`flat_property_type`, `leadmaster`.`lead_type` FROM `leadmaster` LEFT JOIN (select count(t.id) as tag_count,t.lead_id from taggingmaster t group by t.lead_id ) tag ON tag.lead_id=leadmaster.id LEFT JOIN `sm_cp` `creator` ON leadmaster.created_by=creator.sm_cp_id LEFT JOIN `sm_cp` `modifier` ON leadmaster.modified_by=modifier.sm_cp_id WHERE leadmaster.created_by IN(308) AND leadmaster.is_deleted=0 AND DATE(leadmaster.created_on)="2026-10-19" ORDER BY `followup_date` DESC LIMIT 15";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.26883697509765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10516;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9423280;}i:66;a:6:{i:0;s:230:"SELECT `fd`.`id`, `fd`.`feedback`, `fd`.`created_on`, `sm`.`sm_cp_id`, `sm`.`name`, `sm`.`role` FROM `lead_feedback` `fd` LEFT JOIN `sm_cp` `sm` ON fd.created_by = sm.sm_cp_id WHERE fd.lead_id="356" ORDER BY `fd`.`id` DESC LIMIT 5";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2689650058746337890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10641;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9432128;}i:67;a:6:{i:0;s:230:"SELECT `fd`.`id`, `fd`.`feedback`, `fd`.`created_on`, `sm`.`sm_cp_id`, `sm`.`name`, `sm`.`role` FROM `lead_feedback` `fd` LEFT JOIN `sm_cp` `sm` ON fd.created_by = sm.sm_cp_id WHERE fd.lead_id="356" ORDER BY `fd`.`id` DESC LIMIT 5";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.269278049468994140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10641;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9433880;}i:69;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `cp_customers_flats_spam`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.269587993621826171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9462688;}i:70;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `cp_customers_flats_spam`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2701089382171630859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9472032;}i:72;a:6:{i:0;s:802:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cp_customers_flats_spam' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_spam'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.270266056060791015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9475928;}i:73;a:6:{i:0;s:802:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cp_customers_flats_spam' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_spam'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2706229686737060546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9478888;}i:75;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=308";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2707550525665283203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9479096;}i:76;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=308";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2709209918975830078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9481416;}i:78;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `cp_customers_flats_ignore`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2711489200592041015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9504232;}i:79;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `cp_customers_flats_ignore`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.27159595489501953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9510640;}i:81;a:6:{i:0;s:806:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cp_customers_flats_ignore' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_ignore'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.27171611785888671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9516200;}i:82;a:6:{i:0;s:806:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cp_customers_flats_ignore' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_ignore'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2720088958740234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9519160;}i:84;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=308";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2721030712127685546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9519176;}i:85;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=308";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2722499370574951171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9521320;}i:87;a:6:{i:0;s:322:"SELECT COUNT(*) FROM (SELECT `p`.`id` AS `pid` FROM `flat` `f` LEFT JOIN `projects` `p` ON f.projects_id=p.id LEFT JOIN `builder` `b` ON p.builder_id=b.id WHERE FIND_IN_SET("4",p.type) AND f.property_type=1 AND p.status=2 AND f.status=1 AND b.status=1 AND (f.base_price BETWEEN 8000000 AND 10000000) GROUP BY `p`.`id`) `c`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.272366046905517578125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7036;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10677;s:8:"function";s:15:"getrtmiprojects";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9525576;}i:88;a:6:{i:0;s:322:"SELECT COUNT(*) FROM (SELECT `p`.`id` AS `pid` FROM `flat` `f` LEFT JOIN `projects` `p` ON f.projects_id=p.id LEFT JOIN `builder` `b` ON p.builder_id=b.id WHERE FIND_IN_SET("4",p.type) AND f.property_type=1 AND p.status=2 AND f.status=1 AND b.status=1 AND (f.base_price BETWEEN 8000000 AND 10000000) GROUP BY `p`.`id`) `c`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.27328205108642578125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7036;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10677;s:8:"function";s:15:"getrtmiprojects";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9527520;}i:90;a:6:{i:0;s:77:"SELECT `loc`.`name` FROM `location` `loc` WHERE loc.id IN(4) AND loc.status=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2733700275421142578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10563;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9528768;}i:91;a:6:{i:0;s:77:"SELECT `loc`.`name` FROM `location` `loc` WHERE loc.id IN(4) AND loc.status=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.273664951324462890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10563;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9531096;}i:93;a:6:{i:0;s:230:"SELECT `fd`.`id`, `fd`.`feedback`, `fd`.`created_on`, `sm`.`sm_cp_id`, `sm`.`name`, `sm`.`role` FROM `lead_feedback` `fd` LEFT JOIN `sm_cp` `sm` ON fd.created_by = sm.sm_cp_id WHERE fd.lead_id="358" ORDER BY `fd`.`id` DESC LIMIT 5";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2737638950347900390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10641;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9535056;}i:94;a:6:{i:0;s:230:"SELECT `fd`.`id`, `fd`.`feedback`, `fd`.`created_on`, `sm`.`sm_cp_id`, `sm`.`name`, `sm`.`role` FROM `lead_feedback` `fd` LEFT JOIN `sm_cp` `sm` ON fd.created_by = sm.sm_cp_id WHERE fd.lead_id="358" ORDER BY `fd`.`id` DESC LIMIT 5";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.27400493621826171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10641;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9536808;}i:96;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=308";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2741420269012451171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9546232;}i:97;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=308";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2743160724639892578125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9548472;}i:99;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=308";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.274425983428955078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9552344;}i:100;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=308";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.274549007415771484375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9554488;}i:102;a:6:{i:0;s:49:"SELECT `near_locs` FROM `location` WHERE `id`='4'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.274816036224365234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9579056;}i:103;a:6:{i:0;s:49:"SELECT `near_locs` FROM `location` WHERE `id`='4'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.274959087371826171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9581512;}i:105;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `location`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.275022983551025390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9588344;}i:106;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `location`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.275515079498291015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9602888;}i:108;a:6:{i:0;s:772:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'location' AND `kcu`.`TABLE_NAME` = 'location'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.275660991668701171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9604080;}i:109;a:6:{i:0;s:772:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'location' AND `kcu`.`TABLE_NAME` = 'location'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2759659290313720703125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9607040;}i:111;a:6:{i:0;s:689:"SELECT COUNT(*) FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE sm_cp.post_block=0 AND cs.post_for=1 AND cs.type="2" AND cs.flat_type_id IN(2) AND cs.flat_property_type IN(1) AND cs.carpet BETWEEN -50 AND 50 AND cs.sm_cp_id NOT IN(308) AND sm_cp.is_deleted=0 AND sm_cp.status=1 AND cp.status=1 AND (cs.location_id IN (4) OR (cs.budget BETWEEN 6600000 AND 8600000 AND cs.location_id IN(3,4,8,15,16,18,19,21,22,23,29,48,50,51,79,80,116,117,118,119,131,132,134,135,142,171))) AND cs.status IN(1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.276114940643310546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7980;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9608152;}i:112;a:6:{i:0;s:689:"SELECT COUNT(*) FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE sm_cp.post_block=0 AND cs.post_for=1 AND cs.type="2" AND cs.flat_type_id IN(2) AND cs.flat_property_type IN(1) AND cs.carpet BETWEEN -50 AND 50 AND cs.sm_cp_id NOT IN(308) AND sm_cp.is_deleted=0 AND sm_cp.status=1 AND cp.status=1 AND (cs.location_id IN (4) OR (cs.budget BETWEEN 6600000 AND 8600000 AND cs.location_id IN(3,4,8,15,16,18,19,21,22,23,29,48,50,51,79,80,116,117,118,119,131,132,134,135,142,171))) AND cs.status IN(1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2778499126434326171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7980;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9610096;}i:114;a:6:{i:0;s:345:"SELECT COUNT(*) FROM (SELECT `p`.`id` AS `pid` FROM `flat` `f` LEFT JOIN `projects` `p` ON f.projects_id=p.id LEFT JOIN `builder` `b` ON p.builder_id=b.id WHERE FIND_IN_SET("4",p.type) AND f.property_type=1 AND p.status=2 AND f.status=1 AND b.status=1 AND p.location_id IN(4) AND (f.base_price BETWEEN 6600000 AND 8600000) GROUP BY `p`.`id`) `c`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.277945995330810546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7036;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10677;s:8:"function";s:15:"getrtmiprojects";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9611640;}i:115;a:6:{i:0;s:345:"SELECT COUNT(*) FROM (SELECT `p`.`id` AS `pid` FROM `flat` `f` LEFT JOIN `projects` `p` ON f.projects_id=p.id LEFT JOIN `builder` `b` ON p.builder_id=b.id WHERE FIND_IN_SET("4",p.type) AND f.property_type=1 AND p.status=2 AND f.status=1 AND b.status=1 AND p.location_id IN(4) AND (f.base_price BETWEEN 6600000 AND 8600000) GROUP BY `p`.`id`) `c`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2792689800262451171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7036;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10677;s:8:"function";s:15:"getrtmiprojects";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9613584;}}}";s:2:"db";s:57647:"a:1:{s:8:"messages";a:60:{i:25;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:1792412712.224584102630615234375;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:127;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:6349088;}i:26;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:1792412712.225429058074951171875;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:127;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:6407624;}i:28;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:1792412712.22620296478271484375;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:127;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:6408016;}i:29;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:1792412712.2269461154937744140625;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:127;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:6410600;}i:31;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='00cc13c88446bf744c72b0d46bf5829c') 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:1792412712.2295930385589599609375;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:127;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:6687576;}i:32;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='00cc13c88446bf744c72b0d46bf5829c') 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:1792412712.2339470386505126953125;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:127;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:6696816;}i:34;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=308";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.2363109588623046875;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:144;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:6972256;}i:35;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=308";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.236875057220458984375;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:144;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:6973880;}i:37;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:1792412712.237286090850830078125;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:7004376;}i:38;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:1792412712.237988948822021484375;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:7012984;}i:40;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:1792412712.2381229400634765625;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:7015344;}i:41;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:1792412712.238500118255615234375;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:7017552;}i:43;a:6:{i:0;s:387:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/ld_list?type=4&sort_name=followup_date&sort_type=desc&page=1&page_count=15', 2, '{\"type\":\"4\",\"sort_name\":\"followup_date\",\"sort_type\":\"desc\",\"page\":\"1\",\"page_count\":\"15\"}', '2026-10-19 17:55:12', 308, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.23875904083251953125;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:7017808;}i:44;a:6:{i:0;s:387:"INSERT INTO `log_api` (`link`, `type`, `passed_params`, `created_on`, `sm_cp_id`, `headers`) VALUES ('/backend/web/ld_list?type=4&sort_name=followup_date&sort_type=desc&page=1&page_count=15', 2, '{\"type\":\"4\",\"sort_name\":\"followup_date\",\"sort_type\":\"desc\",\"page\":\"1\",\"page_count\":\"15\"}', '2026-10-19 17:55:12', 308, '{\"apk_type\":\"Android\",\"apk_version\":\"43\"}')";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.239758014678955078125;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:7019392;}i:48;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='00cc13c88446bf744c72b0d46bf5829c') 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:1792412712.2442591190338134765625;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:127;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1152;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7500488;}i:49;a:6:{i:0;s:131:"SELECT * FROM `sm_cp` WHERE (`apikey`='00cc13c88446bf744c72b0d46bf5829c') 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:1792412712.2458450794219970703125;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:127;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1152;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7508008;}i:51;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=308";i:1;i:80;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.246243953704833984375;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:144;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1152;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7513928;}i:52;a:6:{i:0;s:52:"UPDATE `sm_cp` SET `apk_type`=1 WHERE `sm_cp_id`=308";i:1;i:96;i:2;s:23:"yii\db\Command::execute";i:3;d:1792412712.246479034423828125;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:144;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1152;s:8:"function";s:13:"apikey_verify";s:5:"class";s:25:"backend\components\Common";s:4:"type";s:2:"->";}}i:5;i:7515552;}i:54;a:6:{i:0;s:82:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=308) AND (`is_deleted`=0) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.26414394378662109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:628;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10296;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9387216;}i:55;a:6:{i:0;s:82:"SELECT * FROM `sm_cp` WHERE (`sm_cp_id`=308) AND (`is_deleted`=0) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2646520137786865234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:628;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10296;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9395000;}i:57;a:6:{i:0;s:402:"SELECT `sm_cp1`.`sm_cp_id` FROM `sm_cp` `sm_cp1` LEFT JOIN `sm_cp` `sm_cp2` ON sm_cp1.parent_id=sm_cp2.sm_cp_id AND sm_cp2.is_deleted=0 AND sm_cp2.status=1 LEFT JOIN `sm_cp` `sm_cp3` ON sm_cp2.parent_id=sm_cp3.sm_cp_id AND sm_cp3.is_deleted=0 AND sm_cp3.status=1 WHERE ((308 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=308) AND sm_cp1.is_deleted=0 AND sm_cp1.status=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.26498699188232421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:639;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10296;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9394880;}i:58;a:6:{i:0;s:402:"SELECT `sm_cp1`.`sm_cp_id` FROM `sm_cp` `sm_cp1` LEFT JOIN `sm_cp` `sm_cp2` ON sm_cp1.parent_id=sm_cp2.sm_cp_id AND sm_cp2.is_deleted=0 AND sm_cp2.status=1 LEFT JOIN `sm_cp` `sm_cp3` ON sm_cp2.parent_id=sm_cp3.sm_cp_id AND sm_cp3.is_deleted=0 AND sm_cp3.status=1 WHERE ((308 in (sm_cp1.parent_id,sm_cp2.parent_id, sm_cp3.parent_id)) AND sm_cp1.sm_cp_id!=308) AND sm_cp1.is_deleted=0 AND sm_cp1.status=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2664630413055419921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:639;s:8:"function";s:8:"queryAll";s:5:"class";s:14:"yii\db\Command";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10296;s:8:"function";s:16:"getaccessmembers";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:100:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9396848;}i:60;a:6:{i:0;s:418:"SELECT COUNT(*) FROM `leadmaster` LEFT JOIN (select count(t.id) as tag_count,t.lead_id from taggingmaster t group by t.lead_id ) tag ON tag.lead_id=leadmaster.id LEFT JOIN `sm_cp` `creator` ON leadmaster.created_by=creator.sm_cp_id LEFT JOIN `sm_cp` `modifier` ON leadmaster.modified_by=modifier.sm_cp_id WHERE leadmaster.created_by IN(308) AND leadmaster.is_deleted=0 AND DATE(leadmaster.created_on)="2026-10-19" ";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2667300701141357421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10509;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9402936;}i:61;a:6:{i:0;s:418:"SELECT COUNT(*) FROM `leadmaster` LEFT JOIN (select count(t.id) as tag_count,t.lead_id from taggingmaster t group by t.lead_id ) tag ON tag.lead_id=leadmaster.id LEFT JOIN `sm_cp` `creator` ON leadmaster.created_by=creator.sm_cp_id LEFT JOIN `sm_cp` `modifier` ON leadmaster.modified_by=modifier.sm_cp_id WHERE leadmaster.created_by IN(308) AND leadmaster.is_deleted=0 AND DATE(leadmaster.created_on)="2026-10-19" ";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2675430774688720703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10509;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9404544;}i:63;a:6:{i:0;s:1054:"SELECT `leadmaster`.`id`, `leadmaster`.`name`, `leadmaster`.`lead_id`, `leadmaster`.`email`, `leadmaster`.`flat_type_id`, `leadmaster`.`contact`, `leadmaster`.`budget`, `leadmaster`.`min_budget`, `leadmaster`.`max_budget`, `leadmaster`.`customer_type`, `leadmaster`.`followup_date`, `leadmaster`.`followup_time`, `leadmaster`.`status`, `leadmaster`.`tagging`, `tag`.`tag_count`, `leadmaster`.`created_on`, `leadmaster`.`modified_on`, `creator`.`name` AS `createdby`, `modifier`.`name` AS `modifiedby`, `leadmaster`.`carpet`, `leadmaster`.`location_id`, `leadmaster`.`flat_property_type`, `leadmaster`.`lead_type` FROM `leadmaster` LEFT JOIN (select count(t.id) as tag_count,t.lead_id from taggingmaster t group by t.lead_id ) tag ON tag.lead_id=leadmaster.id LEFT JOIN `sm_cp` `creator` ON leadmaster.created_by=creator.sm_cp_id LEFT JOIN `sm_cp` `modifier` ON leadmaster.modified_by=modifier.sm_cp_id WHERE leadmaster.created_by IN(308) AND leadmaster.is_deleted=0 AND DATE(leadmaster.created_on)="2026-10-19" ORDER BY `followup_date` DESC LIMIT 15";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2677190303802490234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10516;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9416624;}i:64;a:6:{i:0;s:1054:"SELECT `leadmaster`.`id`, `leadmaster`.`name`, `leadmaster`.`lead_id`, `leadmaster`.`email`, `leadmaster`.`flat_type_id`, `leadmaster`.`contact`, `leadmaster`.`budget`, `leadmaster`.`min_budget`, `leadmaster`.`max_budget`, `leadmaster`.`customer_type`, `leadmaster`.`followup_date`, `leadmaster`.`followup_time`, `leadmaster`.`status`, `leadmaster`.`tagging`, `tag`.`tag_count`, `leadmaster`.`created_on`, `leadmaster`.`modified_on`, `creator`.`name` AS `createdby`, `modifier`.`name` AS `modifiedby`, `leadmaster`.`carpet`, `leadmaster`.`location_id`, `leadmaster`.`flat_property_type`, `leadmaster`.`lead_type` FROM `leadmaster` LEFT JOIN (select count(t.id) as tag_count,t.lead_id from taggingmaster t group by t.lead_id ) tag ON tag.lead_id=leadmaster.id LEFT JOIN `sm_cp` `creator` ON leadmaster.created_by=creator.sm_cp_id LEFT JOIN `sm_cp` `modifier` ON leadmaster.modified_by=modifier.sm_cp_id WHERE leadmaster.created_by IN(308) AND leadmaster.is_deleted=0 AND DATE(leadmaster.created_on)="2026-10-19" ORDER BY `followup_date` DESC LIMIT 15";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.26883697509765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10516;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9423280;}i:66;a:6:{i:0;s:230:"SELECT `fd`.`id`, `fd`.`feedback`, `fd`.`created_on`, `sm`.`sm_cp_id`, `sm`.`name`, `sm`.`role` FROM `lead_feedback` `fd` LEFT JOIN `sm_cp` `sm` ON fd.created_by = sm.sm_cp_id WHERE fd.lead_id="356" ORDER BY `fd`.`id` DESC LIMIT 5";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2689650058746337890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10641;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9432128;}i:67;a:6:{i:0;s:230:"SELECT `fd`.`id`, `fd`.`feedback`, `fd`.`created_on`, `sm`.`sm_cp_id`, `sm`.`name`, `sm`.`role` FROM `lead_feedback` `fd` LEFT JOIN `sm_cp` `sm` ON fd.created_by = sm.sm_cp_id WHERE fd.lead_id="356" ORDER BY `fd`.`id` DESC LIMIT 5";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.269278049468994140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10641;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9433880;}i:69;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `cp_customers_flats_spam`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.269587993621826171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9462688;}i:70;a:6:{i:0;s:48:"SHOW FULL COLUMNS FROM `cp_customers_flats_spam`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2701089382171630859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9472032;}i:72;a:6:{i:0;s:802:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cp_customers_flats_spam' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_spam'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.270266056060791015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9475928;}i:73;a:6:{i:0;s:802:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cp_customers_flats_spam' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_spam'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2706229686737060546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9478888;}i:75;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=308";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2707550525665283203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9479096;}i:76;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=308";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2709209918975830078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9481416;}i:78;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `cp_customers_flats_ignore`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2711489200592041015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9504232;}i:79;a:6:{i:0;s:50:"SHOW FULL COLUMNS FROM `cp_customers_flats_ignore`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.27159595489501953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9510640;}i:81;a:6:{i:0;s:806:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cp_customers_flats_ignore' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_ignore'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.27171611785888671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9516200;}i:82;a:6:{i:0;s:806:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'cp_customers_flats_ignore' AND `kcu`.`TABLE_NAME` = 'cp_customers_flats_ignore'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2720088958740234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9519160;}i:84;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=308";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2721030712127685546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9519176;}i:85;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=308";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2722499370574951171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9521320;}i:87;a:6:{i:0;s:322:"SELECT COUNT(*) FROM (SELECT `p`.`id` AS `pid` FROM `flat` `f` LEFT JOIN `projects` `p` ON f.projects_id=p.id LEFT JOIN `builder` `b` ON p.builder_id=b.id WHERE FIND_IN_SET("4",p.type) AND f.property_type=1 AND p.status=2 AND f.status=1 AND b.status=1 AND (f.base_price BETWEEN 8000000 AND 10000000) GROUP BY `p`.`id`) `c`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.272366046905517578125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7036;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10677;s:8:"function";s:15:"getrtmiprojects";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9525576;}i:88;a:6:{i:0;s:322:"SELECT COUNT(*) FROM (SELECT `p`.`id` AS `pid` FROM `flat` `f` LEFT JOIN `projects` `p` ON f.projects_id=p.id LEFT JOIN `builder` `b` ON p.builder_id=b.id WHERE FIND_IN_SET("4",p.type) AND f.property_type=1 AND p.status=2 AND f.status=1 AND b.status=1 AND (f.base_price BETWEEN 8000000 AND 10000000) GROUP BY `p`.`id`) `c`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.27328205108642578125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7036;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10677;s:8:"function";s:15:"getrtmiprojects";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9527520;}i:90;a:6:{i:0;s:77:"SELECT `loc`.`name` FROM `location` `loc` WHERE loc.id IN(4) AND loc.status=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2733700275421142578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10563;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9528768;}i:91;a:6:{i:0;s:77:"SELECT `loc`.`name` FROM `location` `loc` WHERE loc.id IN(4) AND loc.status=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.273664951324462890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10563;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9531096;}i:93;a:6:{i:0;s:230:"SELECT `fd`.`id`, `fd`.`feedback`, `fd`.`created_on`, `sm`.`sm_cp_id`, `sm`.`name`, `sm`.`role` FROM `lead_feedback` `fd` LEFT JOIN `sm_cp` `sm` ON fd.created_by = sm.sm_cp_id WHERE fd.lead_id="358" ORDER BY `fd`.`id` DESC LIMIT 5";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2737638950347900390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10641;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9535056;}i:94;a:6:{i:0;s:230:"SELECT `fd`.`id`, `fd`.`feedback`, `fd`.`created_on`, `sm`.`sm_cp_id`, `sm`.`name`, `sm`.`role` FROM `lead_feedback` `fd` LEFT JOIN `sm_cp` `sm` ON fd.created_by = sm.sm_cp_id WHERE fd.lead_id="358" ORDER BY `fd`.`id` DESC LIMIT 5";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.27400493621826171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10641;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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9536808;}i:96;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=308";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2741420269012451171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9546232;}i:97;a:6:{i:0;s:60:"SELECT * FROM `cp_customers_flats_spam` WHERE `sm_cp_id`=308";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2743160724639892578125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:424;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7882;s:8:"function";s:11:"getspampost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9548472;}i:99;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=308";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.274425983428955078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9552344;}i:100;a:6:{i:0;s:62:"SELECT * FROM `cp_customers_flats_ignore` WHERE `sm_cp_id`=308";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.274549007415771484375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:438;s:8:"function";s:7:"findAll";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7889;s:8:"function";s:13:"getignorepost";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9554488;}i:102;a:6:{i:0;s:49:"SELECT `near_locs` FROM `location` WHERE `id`='4'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.274816036224365234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9579056;}i:103;a:6:{i:0;s:49:"SELECT `near_locs` FROM `location` WHERE `id`='4'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.274959087371826171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9581512;}i:105;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `location`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.275022983551025390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9588344;}i:106;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `location`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.275515079498291015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9602888;}i:108;a:6:{i:0;s:772:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'location' AND `kcu`.`TABLE_NAME` = 'location'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.275660991668701171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9604080;}i:109;a:6:{i:0;s:772:"SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'location' AND `kcu`.`TABLE_NAME` = 'location'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2759659290313720703125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:394;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7903;s:8:"function";s:14:"get_nearby_loc";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9607040;}i:111;a:6:{i:0;s:689:"SELECT COUNT(*) FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE sm_cp.post_block=0 AND cs.post_for=1 AND cs.type="2" AND cs.flat_type_id IN(2) AND cs.flat_property_type IN(1) AND cs.carpet BETWEEN -50 AND 50 AND cs.sm_cp_id NOT IN(308) AND sm_cp.is_deleted=0 AND sm_cp.status=1 AND cp.status=1 AND (cs.location_id IN (4) OR (cs.budget BETWEEN 6600000 AND 8600000 AND cs.location_id IN(3,4,8,15,16,18,19,21,22,23,29,48,50,51,79,80,116,117,118,119,131,132,134,135,142,171))) AND cs.status IN(1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.276114940643310546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7980;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9608152;}i:112;a:6:{i:0;s:689:"SELECT COUNT(*) FROM `cp_customers_flats` `cs` LEFT JOIN `location` `l` ON cs.location_id=l.id LEFT JOIN `sm_cp` ON cs.sm_cp_id=sm_cp.sm_cp_id LEFT JOIN `channelpartner` `cp` ON sm_cp.channelpartner_id=cp.id LEFT JOIN `staff` `s` ON cs.verified_by=s.id WHERE sm_cp.post_block=0 AND cs.post_for=1 AND cs.type="2" AND cs.flat_type_id IN(2) AND cs.flat_property_type IN(1) AND cs.carpet BETWEEN -50 AND 50 AND cs.sm_cp_id NOT IN(308) AND sm_cp.is_deleted=0 AND sm_cp.status=1 AND cp.status=1 AND (cs.location_id IN (4) OR (cs.budget BETWEEN 6600000 AND 8600000 AND cs.location_id IN(3,4,8,15,16,18,19,21,22,23,29,48,50,51,79,80,116,117,118,119,131,132,134,135,142,171))) AND cs.status IN(1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2778499126434326171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7980;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10672;s:8:"function";s:12:"getpostcount";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9610096;}i:114;a:6:{i:0;s:345:"SELECT COUNT(*) FROM (SELECT `p`.`id` AS `pid` FROM `flat` `f` LEFT JOIN `projects` `p` ON f.projects_id=p.id LEFT JOIN `builder` `b` ON p.builder_id=b.id WHERE FIND_IN_SET("4",p.type) AND f.property_type=1 AND p.status=2 AND f.status=1 AND b.status=1 AND p.location_id IN(4) AND (f.base_price BETWEEN 6600000 AND 8600000) GROUP BY `p`.`id`) `c`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.277945995330810546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7036;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10677;s:8:"function";s:15:"getrtmiprojects";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9611640;}i:115;a:6:{i:0;s:345:"SELECT COUNT(*) FROM (SELECT `p`.`id` AS `pid` FROM `flat` `f` LEFT JOIN `projects` `p` ON f.projects_id=p.id LEFT JOIN `builder` `b` ON p.builder_id=b.id WHERE FIND_IN_SET("4",p.type) AND f.property_type=1 AND p.status=2 AND f.status=1 AND b.status=1 AND p.location_id IN(4) AND (f.base_price BETWEEN 6600000 AND 8600000) GROUP BY `p`.`id`) `c`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1792412712.2792689800262451171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:7036;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:75:"/home/webprjlw/public_html/devapi.cpbroadcast.com/backend/models/Common.php";s:4:"line";i:10677;s:8:"function";s:15:"getrtmiprojects";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/devapi.cpbroadcast.com/backend/modules/api/controllers/LeadController.php";s:4:"line";i:1177;s:8:"function";s:14:"getleadlistapi";s:5:"class";s:17:"app\models\Common";s:4:"type";s:2:"->";}}i:5;i:9613584;}}}";s:5:"event";s:7936:"a:42:{i:0;a:5:{s:4:"time";d:1792412712.2101390361785888671875;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:1792412712.2189409732818603515625;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:1792412712.2245171070098876953125;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:1792412712.2340240478515625;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:1792412712.234098911285400390625;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:1792412712.2342169284820556640625;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:1792412712.2361390590667724609375;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:1792412712.2361528873443603515625;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:1792412712.2369949817657470703125;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:1792412712.2370979785919189453125;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:1792412712.23855495452880859375;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:1792412712.238626956939697265625;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:1792412712.238636016845703125;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:1792412712.2398440837860107421875;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:1792412712.2428948879241943359375;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:1792412712.2429039478302001953125;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:1792412712.2439899444580078125;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"app\modules\api\controllers\LeadController";}i:17;a:5:{s:4:"time";d:1792412712.2440440654754638671875;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:1792412712.245893001556396484375;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:1792412712.2459518909454345703125;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:1792412712.245973110198974609375;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:1792412712.2461268901824951171875;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:1792412712.2461349964141845703125;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:1792412712.2465059757232666015625;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:1792412712.263967037200927734375;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:1792412712.2640130519866943359375;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:1792412712.2647120952606201171875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:27;a:5:{s:4:"time";d:1792412712.2647750377655029296875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:15:"app\models\SmCp";}i:28;a:5:{s:4:"time";d:1792412712.26949405670166015625;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:1792412712.27107906341552734375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:30;a:5:{s:4:"time";d:1792412712.2740459442138671875;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:31;a:5:{s:4:"time";d:1792412712.2743470668792724609375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:32;a:5:{s:4:"time";d:1792412712.2747380733489990234375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:33;a:5:{s:4:"time";d:1792412712.274982929229736328125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"app\models\Location";}i:34;a:5:{s:4:"time";d:1792412712.276010990142822265625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"app\models\Location";}i:35;a:5:{s:4:"time";d:1792412712.279347896575927734375;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"app\modules\api\controllers\LeadController";}i:36;a:5:{s:4:"time";d:1792412712.2793591022491455078125;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"app\modules\api\ApiModule";}i:37;a:5:{s:4:"time";d:1792412712.279365062713623046875;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:38;a:5:{s:4:"time";d:1792412712.27937602996826171875;s:4:"name";s:12:"afterRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:39;a:5:{s:4:"time";d:1792412712.2793829441070556640625;s:4:"name";s:10:"beforeSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:40;a:5:{s:4:"time";d:1792412712.280086994171142578125;s:4:"name";s:12:"afterPrepare";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:41;a:5:{s:4:"time";d:1792412712.280127048492431640625;s:4:"name";s:9:"afterSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:121:"a:3:{s:5:"start";d:1792412712.13313388824462890625;s:3:"end";d:1792412712.282721042633056640625;s:6:"memory";i:12355240;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:2706:"a:3:{s:8:"messages";a:13:{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:1792412712.2112319469451904296875;i:4;a:0:{}i:5;i:4928696;}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:1792412712.211288928985595703125;i:4;a:0:{}i:5;i:4929448;}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:1792412712.211327075958251953125;i:4;a:0:{}i:5;i:4930200;}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:1792412712.21133899688720703125;i:4;a:0:{}i:5;i:4931272;}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:1792412712.211371898651123046875;i:4;a:0:{}i:5;i:4932024;}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:1792412712.2113831043243408203125;i:4;a:0:{}i:5;i:4932776;}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:1792412712.211391925811767578125;i:4;a:0:{}i:5;i:4933528;}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:1792412712.21140003204345703125;i:4;a:0:{}i:5;i:4934280;}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:1792412712.2114078998565673828125;i:4;a:0:{}i:5;i:4935032;}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:1792412712.211429119110107421875;i:4;a:0:{}i:5;i:4935784;}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:1792412712.2114369869232177734375;i:4;a:0:{}i:5;i:4936536;}i:17;a:6:{i:0;s:37:"Request parsed with URL rule: ld_list";i:1;i:8;i:2;s:29:"yii\web\UrlRule::parseRequest";i:3;d:1792412712.2114489078521728515625;i:4;a:0:{}i:5;i:4938432;}i:18;a:6:{i:0;a:3:{s:4:"rule";s:7:"ld_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:1792412712.211452960968017578125;i:4;a:0:{}i:5;i:4938744;}}s:5:"route";s:13:"api/lead/list";s:6:"action";s:56:"app\modules\api\controllers\LeadController::actionList()";}";s:7:"request";s:3288:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:7:{s:10:"user-agent";s:13:"okhttp/4.10.0";s:15:"accept-encoding";s:4:"gzip";s:10:"connection";s:10:"Keep-Alive";s:4:"host";s:22:"devapi.cpbroadcast.com";s:7:"version";s:2:"43";s:11:"channeltype";s:7:"Android";s:6:"apikey";s:32:"00cc13c88446bf744c72b0d46bf5829c";}s:15:"responseHeaders";a:1:{s:12:"Content-Type";s:31:"application/json; charset=UTF-8";}s:5:"route";s:13:"api/lead/list";s:6:"action";s:56:"app\modules\api\controllers\LeadController::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:45:{s:4:"USER";s:8:"webprjlw";s:4:"HOME";s:14:"/home/webprjlw";s:11:"SCRIPT_NAME";s:22:"/backend/web/index.php";s:11:"REQUEST_URI";s:87:"/backend/web/ld_list?type=4&sort_name=followup_date&sort_type=desc&page=1&page_count=15";s:12:"QUERY_STRING";s:66:"type=4&sort_name=followup_date&sort_type=desc&page=1&page_count=15";s:14:"REQUEST_METHOD";s:3:"GET";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:21:"REDIRECT_QUERY_STRING";s:66:"type=4&sort_name=followup_date&sort_type=desc&page=1&page_count=15";s:12:"REDIRECT_URL";s:20:"/backend/web/ld_list";s:11:"REMOTE_PORT";s:5:"54570";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:15:"106.222.252.244";s:11:"SERVER_PORT";s:3:"443";s:11:"SERVER_ADDR";s:13:"65.254.80.108";s:11:"SERVER_NAME";s:22:"devapi.cpbroadcast.com";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:16:"SERVER_SIGNATURE";s:0:"";s:4:"PATH";s:180:"/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin";s:15:"HTTP_USER_AGENT";s:13:"okhttp/4.10.0";s:20:"HTTP_ACCEPT_ENCODING";s:4:"gzip";s:15:"HTTP_CONNECTION";s:10:"Keep-Alive";s:9:"HTTP_HOST";s:22:"devapi.cpbroadcast.com";s:12:"HTTP_VERSION";s:2:"43";s:16:"HTTP_CHANNELTYPE";s:7:"Android";s:11:"HTTP_APIKEY";s:32:"00cc13c88446bf744c72b0d46bf5829c";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:"atYMKFbgZsb18raZ3dNwVAAAABE";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:"atYMKFbgZsb18raZ3dNwVAAAABE";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:22:"/backend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1792412712.125400066375732421875;s:12:"REQUEST_TIME";i:1792412712;s:4:"argv";a:1:{i:0;s:66:"type=4&sort_name=followup_date&sort_type=desc&page=1&page_count=15";}s:4:"argc";i:1;}s:3:"GET";a:5:{s:4:"type";s:1:"4";s:9:"sort_name";s:13:"followup_date";s:9:"sort_type";s:4:"desc";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:"6ad60c2832218";s:3:"url";s:117:"https://devapi.cpbroadcast.com/backend/web/ld_list?type=4&sort_name=followup_date&sort_type=desc&page=1&page_count=15";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:15:"106.222.252.244";s:4:"time";d:1792412712.125400066375732421875;s:10:"statusCode";i:200;s:8:"sqlCount";i:30;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:12355240;s:14:"processingTime";d:0.149217128753662109375;}s:10:"exceptions";a:0:{}}