a:13:{s:6:"config";s:1870:"a:5:{s:10:"phpVersion";s:5:"7.4.3";s:10:"yiiVersion";s:8:"2.0.15.1";s:11:"application";a:8:{s:3:"yii";s:8:"2.0.15.1";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:4:"prod";s:5:"debug";b:1;}s:3:"php";a:5:{s:7:"version";s:5:"7.4.3";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:7:{s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.0.7.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:53:"/mnt/www/law_firm/crm/vendor/yiisoft/yii2-swiftmailer";}}s:22:"yiisoft/yii2-bootstrap";a:3:{s:4:"name";s:22:"yiisoft/yii2-bootstrap";s:7:"version";s:7:"2.0.8.0";s:5:"alias";a:1:{s:14:"@yii/bootstrap";s:55:"/mnt/www/law_firm/crm/vendor/yiisoft/yii2-bootstrap/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.0.14.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:51:"/mnt/www/law_firm/crm/vendor/yiisoft/yii2-debug/src";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.0.7.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:49:"/mnt/www/law_firm/crm/vendor/yiisoft/yii2-gii/src";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:47:"/mnt/www/law_firm/crm/vendor/yiisoft/yii2-faker";}}s:25:"kartik-v/yii2-krajee-base";a:3:{s:4:"name";s:25:"kartik-v/yii2-krajee-base";s:7:"version";s:7:"2.0.3.0";s:5:"alias";a:1:{s:12:"@kartik/base";s:58:"/mnt/www/law_firm/crm/vendor/kartik-v/yii2-krajee-base/src";}}s:30:"kartik-v/yii2-widget-fileinput";a:3:{s:4:"name";s:30:"kartik-v/yii2-widget-fileinput";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:12:"@kartik/file";s:63:"/mnt/www/law_firm/crm/vendor/kartik-v/yii2-widget-fileinput/src";}}}}";s:7:"request";s:4842:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:9:{s:4:"host";s:24:"lfzb.crm.fashengsuan.com";s:10:"connection";s:10:"keep-alive";s:25:"upgrade-insecure-requests";s:1:"1";s:10:"user-agent";s:117:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36";s:6:"accept";s:135:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7";s:7:"referer";s:32:"http://lfzb.crm.fashengsuan.com/";s:15:"accept-encoding";s:13:"gzip, deflate";s:15:"accept-language";s:14:"zh-CN,zh;q=0.9";s:6:"cookie";s:387:"PHPSESSID=bdc4bf919941347c8993467cfbc9f1d1; _identity=95cdf69418931d3f7af5d3840d514896b4bfc3ee50e126ac813675f71bb1c50fa%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A13%3A%22%5B4%2Cnull%2C7200%5D%22%3B%7D; _csrf=6b3114aea821a27132c89534cfa92d04822c72358f5de90a76207044ad767c65a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22gy642yb9im6AChQGhbOYwXaC-R757gMN%22%3B%7D";}s:15:"responseHeaders";a:6:{s:12:"X-Powered-By";s:9:"PHP/7.4.3";s:7:"Expires";s:29:"Thu, 19 Nov 1981 08:52:00 GMT";s:13:"Cache-Control";s:35:"no-store, no-cache, must-revalidate";s:6:"Pragma";s:8:"no-cache";s:12:"Content-Type";s:24:"text/html; charset=UTF-8";s:10:"Set-Cookie";s:240:"_identity=95cdf69418931d3f7af5d3840d514896b4bfc3ee50e126ac813675f71bb1c50fa%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A13%3A%22%5B4%2Cnull%2C7200%5D%22%3B%7D; expires=Wed, 27-May-2026 03:17:05 GMT; Max-Age=7200; path=/; HttpOnly";}s:5:"route";s:13:"company/track";s:6:"action";s:52:"backend\controllers\CompanyController::actionTrack()";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:0;}s:11:"requestBody";a:0:{}s:6:"SERVER";a:37:{s:18:"REDIRECT_UNIQUE_ID";s:27:"ahZGEVtQgcKBSvMut-PuYAAAAAE";s:15:"REDIRECT_STATUS";s:3:"200";s:9:"UNIQUE_ID";s:27:"ahZGEVtQgcKBSvMut-PuYAAAAAE";s:9:"HTTP_HOST";s:24:"lfzb.crm.fashengsuan.com";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:30:"HTTP_UPGRADE_INSECURE_REQUESTS";s:1:"1";s:15:"HTTP_USER_AGENT";s:117:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36";s:11:"HTTP_ACCEPT";s:135:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7";s:12:"HTTP_REFERER";s:32:"http://lfzb.crm.fashengsuan.com/";s:20:"HTTP_ACCEPT_ENCODING";s:13:"gzip, deflate";s:20:"HTTP_ACCEPT_LANGUAGE";s:14:"zh-CN,zh;q=0.9";s:11:"HTTP_COOKIE";s:387:"PHPSESSID=bdc4bf919941347c8993467cfbc9f1d1; _identity=95cdf69418931d3f7af5d3840d514896b4bfc3ee50e126ac813675f71bb1c50fa%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A13%3A%22%5B4%2Cnull%2C7200%5D%22%3B%7D; _csrf=6b3114aea821a27132c89534cfa92d04822c72358f5de90a76207044ad767c65a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22gy642yb9im6AChQGhbOYwXaC-R757gMN%22%3B%7D";s:4:"PATH";s:98:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin";s:15:"LD_LIBRARY_PATH";s:29:"/opt/lampp/lib:/opt/lampp/lib";s:16:"SERVER_SIGNATURE";s:0:"";s:15:"SERVER_SOFTWARE";s:77:"Apache/2.4.41 (Unix) OpenSSL/1.1.1d PHP/7.4.3 mod_perl/2.0.8-dev Perl/v5.16.3";s:11:"SERVER_NAME";s:24:"lfzb.crm.fashengsuan.com";s:11:"SERVER_ADDR";s:14:"172.28.124.110";s:11:"SERVER_PORT";s:2:"80";s:11:"REMOTE_ADDR";s:12:"60.16.87.251";s:13:"DOCUMENT_ROOT";s:43:"/opt/lampp/htdocs/law_firm/crm/backend/web/";s:14:"REQUEST_SCHEME";s:4:"http";s:14:"CONTEXT_PREFIX";s:0:"";s:21:"CONTEXT_DOCUMENT_ROOT";s:43:"/opt/lampp/htdocs/law_firm/crm/backend/web/";s:12:"SERVER_ADMIN";s:15:"you@example.com";s:15:"SCRIPT_FILENAME";s:52:"/opt/lampp/htdocs/law_firm/crm/backend/web/index.php";s:11:"REMOTE_PORT";s:5:"57926";s:12:"REDIRECT_URL";s:14:"/company/track";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:3:"GET";s:12:"QUERY_STRING";s:0:"";s:11:"REQUEST_URI";s:14:"/company/track";s:11:"SCRIPT_NAME";s:10:"/index.php";s:8:"PHP_SELF";s:10:"/index.php";s:18:"REQUEST_TIME_FLOAT";d:1779844625.7149999141693115234375;s:12:"REQUEST_TIME";i:1779844625;}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:3:{s:9:"PHPSESSID";s:32:"bdc4bf919941347c8993467cfbc9f1d1";s:9:"_identity";s:115:"95cdf69418931d3f7af5d3840d514896b4bfc3ee50e126ac813675f71bb1c50fa:2:{i:0;s:9:"_identity";i:1;s:13:"[4,null,7200]";}";s:5:"_csrf";s:130:"6b3114aea821a27132c89534cfa92d04822c72358f5de90a76207044ad767c65a:2:{i:0;s:5:"_csrf";i:1;s:32:"gy642yb9im6AChQGhbOYwXaC-R757gMN";}";}s:5:"FILES";a:0:{}s:7:"SESSION";a:4:{s:7:"__flash";a:0:{}s:11:"runningtime";s:13:"1779844625754";s:6:"ticket";s:32:"b61efdd12c34d3dc9cc20a856cc9f805";s:4:"__id";i:4;}}";s:3:"log";s:27007:"a:1:{s:8:"messages";a:46:{i:0;a:6:{i:0;s:21:"Loading module: debug";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1779844625.72227191925048828125;i:4;a:0:{}i:5;i:2069400;}i:1;a:6:{i:0;s:15:"Session started";i:1;i:4;i:2;s:21:"yii\web\Session::open";i:3;d:1779844625.7270529270172119140625;i:4;a:0:{}i:5;i:3138264;}i:2;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_user`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.732798099517822265625;i:4;a:0:{}i:5;i:4541696;}i:3;a:6:{i:0;s:100:"Opening DB connection: mysql:host=rm-m5eggw222w7d29vv648810.mariadb.rds.aliyuncs.com;dbname=fawulfzb";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1779844625.7328090667724609375;i:4;a:0:{}i:5;i:4542288;}i:8;a:6:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_user' AND kcu.table_name = 'crm_user'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.736637115478515625;i:4;a:0:{}i:5;i:4628464;}i:11;a:6:{i:0;s:56:"SELECT * FROM `crm_user` WHERE (`id`=4) AND (`status`=1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7388179302215576171875;i:4;a:0:{}i:5;i:4949552;}i:14;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:1779844625.741754055023193359375;i:4;a:0:{}i:5;i:5335912;}i:15;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1779844625.7433130741119384765625;i:4;a:0:{}i:5;i:5659216;}i:16;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:1779844625.74347209930419921875;i:4;a:0:{}i:5;i:5683368;}i:17;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:1779844625.7435119152069091796875;i:4;a:0:{}i:5;i:5688000;}i:18;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:1779844625.74351596832275390625;i:4;a:0:{}i:5;i:5688456;}i:19;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:1779844625.7435419559478759765625;i:4;a:0:{}i:5;i:5692144;}i:31;a:6:{i:0;s:32:"Route requested: 'company/track'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1779844625.743753910064697265625;i:4;a:0:{}i:5;i:5727400;}i:32;a:6:{i:0;s:91:"SELECT `roleid`, `status`, `username`, `name`, `id`, `agentID` FROM `crm_user` WHERE `id`=4";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7462790012359619140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:43;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6160512;}i:35;a:6:{i:0;s:47:"SELECT `role_type` FROM `crm_role` WHERE `id`=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.74697589874267578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6195528;}i:38;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_role`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.74746608734130859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6203096;}i:41;a:6:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_role' AND kcu.table_name = 'crm_role'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.74845600128173828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6215768;}i:44;a:6:{i:0;s:80:"SELECT `active_area`, `active_area_section` FROM `crm_active_area` WHERE `uid`=4";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7492420673370361328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6244472;}i:47;a:6:{i:0;s:40:"SHOW FULL COLUMNS FROM `crm_active_area`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.74975109100341796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6252456;}i:50;a:6:{i:0;s:617:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_active_area' AND kcu.table_name = 'crm_active_area'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.750751972198486328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6273576;}i:53;a:6:{i:0;s:55:"SELECT `uid` FROM `crm_active_area` WHERE `site`='lfzb'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.75140094757080078125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:55;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6278472;}i:56;a:6:{i:0;s:47:"SELECT * FROM `crm_diy_config` WHERE `status`=2";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7521059513092041015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:62;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6307400;}i:59;a:6:{i:0;s:27:"Route to run: company/track";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1779844625.7527658939361572265625;i:4;a:0:{}i:5;i:6315992;}i:60;a:6:{i:0;s:68:"Running action: backend\controllers\CompanyController::actionTrack()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1779844625.7551200389862060546875;i:4;a:0:{}i:5;i:6716448;}i:61;a:6:{i:0;s:37:"SELECT * FROM `fawulfzb`.`crm_levels`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7593190670013427734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7436752;}i:64;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_levels`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.759851932525634765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7447032;}i:67;a:6:{i:0;s:607:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_levels' AND kcu.table_name = 'crm_levels'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.76076602935791015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7463272;}i:70;a:6:{i:0;s:129:"SELECT `uid`, `uname` FROM `crm_active_area` WHERE ((`uid` IN (1, 2, 3, 5, 4, 7, 8)) AND (`t_user_status`=1)) AND (`site`='lfzb')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7618811130523681640625;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1437;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7509808;}i:73;a:6:{i:0;s:85:"SELECT `roleid`, `status`, `username`, `name`, `agentID` FROM `crm_user` WHERE `id`=4";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7625401020050048828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1442;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7512000;}i:76;a:6:{i:0;s:47:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_company`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.764254093170166015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1491;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7718872;}i:79;a:6:{i:0;s:609:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_company' AND kcu.table_name = 'crm_company'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7653429508209228515625;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1491;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7739544;}i:82;a:6:{i:0;s:1594:"SELECT COUNT(*) FROM (SELECT c.id, c.comp_name,c.telephone, c.trace_uid, c.apply_time, c.trace_time, c.industry_id, c.apply_uid,
            d.time,
            e.add_time as comment_at,
            ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) AND (`d`.`time` > 0) GROUP BY `c`.`id` ORDER BY CASE WHEN ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d.time), NOW()))) = 0 THEN 1 ELSE 0 END ASC, `abs_time` DESC, `c`.`trace_time` DESC, `c`.`id` DESC) `c`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7665259838104248046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1521;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7782376;}i:85;a:6:{i:0;s:74:"Rendering view file: /mnt/www/law_firm/crm/backend/views/company/track.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1779844625.7685348987579345703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:7879896;}i:86;a:6:{i:0;s:1408:"SELECT COUNT(*) FROM (SELECT `c`.`id`, `c`.`comp_name`, `c`.`telephone`, `c`.`trace_uid`, `c`.`apply_time`, `c`.`trace_time`, `c`.`industry_id`, `c`.`apply_uid`, `d`.`time`, `e`.`add_time` AS `comment_at`, ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) GROUP BY `c`.`id`) `c`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.774609088897705078125;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9293384;}i:89;a:6:{i:0;s:1562:"SELECT `c`.`id`, `c`.`comp_name`, `c`.`telephone`, `c`.`trace_uid`, `c`.`apply_time`, `c`.`trace_time`, `c`.`industry_id`, `c`.`apply_uid`, `d`.`time`, `e`.`add_time` AS `comment_at`, ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) GROUP BY `c`.`id` ORDER BY CASE WHEN ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d.time), NOW()))) = 0 THEN 1 ELSE 0 END ASC, `abs_time` DESC, `c`.`trace_time` DESC, `c`.`id` DESC LIMIT 10";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.776072978973388671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9299912;}i:92;a:6:{i:0;s:62:"SELECT * FROM `fawulfzb`.`crm_company_level` `l` WHERE `cid`=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7772920131683349609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9306488;}i:95;a:6:{i:0;s:53:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_company_level`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7778379917144775390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9314840;}i:98;a:6:{i:0;s:621:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_company_level' AND kcu.table_name = 'crm_company_level'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.778728008270263671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9327400;}i:101;a:6:{i:0;s:37:"SELECT * FROM `crm_user` WHERE `id`=2";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7794320583343505859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:173;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:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9325944;}i:104;a:6:{i:0;s:117:"SELECT * FROM `crm_comment` WHERE (`company_id`=1) AND (`add_uid`=2) AND (`action_sign` IN (1, 4)) ORDER BY `id` DESC";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.78011608123779296875;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:209;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9357920;}i:107;a:6:{i:0;s:105:"SELECT COUNT(*) FROM `crm_comment` WHERE (`company_id`=1) AND (`add_uid`=2) AND (`action_sign` IN (1, 4))";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7807369232177734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:211;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:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9366048;}i:110;a:6:{i:0;s:73:"Rendering view file: /mnt/www/law_firm/crm/backend/views/layouts/main.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1779844625.782002925872802734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9378200;}i:111;a:6:{i:0;s:101:"Access to debugger is denied due to IP address restriction. The requesting IP address is 60.16.87.251";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1779844625.7821180820465087890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:52:"/mnt/www/law_firm/crm/backend/views/layouts/main.php";s:4:"line";i:25;s:8:"function";s:7:"endBody";s:5:"class";s:12:"yii\web\View";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9437864;}i:112;a:6:{i:0;s:101:"Access to debugger is denied due to IP address restriction. The requesting IP address is 60.16.87.251";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1779844625.7821400165557861328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:52:"/mnt/www/law_firm/crm/backend/views/layouts/main.php";s:4:"line";i:25;s:8:"function";s:7:"endBody";s:5:"class";s:12:"yii\web\View";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9439496;}i:113;a:6:{i:0;s:101:"Access to debugger is denied due to IP address restriction. The requesting IP address is 60.16.87.251";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1779844625.7824900150299072265625;i:4;a:0:{}i:5;i:9382376;}i:114;a:6:{i:0;s:101:"Access to debugger is denied due to IP address restriction. The requesting IP address is 60.16.87.251";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1779844625.782496929168701171875;i:4;a:0:{}i:5;i:9382880;}}}";s:9:"profiling";s:45326:"a:3:{s:6:"memory";i:9479776;s:4:"time";d:0.065885066986083984375;s:8:"messages";a:58:{i:4;a:6:{i:0;s:100:"Opening DB connection: mysql:host=rm-m5eggw222w7d29vv648810.mariadb.rds.aliyuncs.com;dbname=fawulfzb";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1779844625.73281097412109375;i:4;a:0:{}i:5;i:4542664;}i:5;a:6:{i:0;s:100:"Opening DB connection: mysql:host=rm-m5eggw222w7d29vv648810.mariadb.rds.aliyuncs.com;dbname=fawulfzb";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1779844625.7352039813995361328125;i:4;a:0:{}i:5;i:4591648;}i:6;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.735210895538330078125;i:4;a:0:{}i:5;i:4592640;}i:7;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.736341953277587890625;i:4;a:0:{}i:5;i:4606744;}i:9;a:6:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_user' AND kcu.table_name = 'crm_user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7366468906402587890625;i:4;a:0:{}i:5;i:4630760;}i:10;a:6:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_user' AND kcu.table_name = 'crm_user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7373139858245849609375;i:4;a:0:{}i:5;i:4632136;}i:12;a:6:{i:0;s:56:"SELECT * FROM `crm_user` WHERE (`id`=4) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7388288974761962890625;i:4;a:0:{}i:5;i:4950392;}i:13;a:6:{i:0;s:56:"SELECT * FROM `crm_user` WHERE (`id`=4) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7394440174102783203125;i:4;a:0:{}i:5;i:4953056;}i:33;a:6:{i:0;s:91:"SELECT `roleid`, `status`, `username`, `name`, `id`, `agentID` FROM `crm_user` WHERE `id`=4";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7462980747222900390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:43;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6163712;}i:34;a:6:{i:0;s:91:"SELECT `roleid`, `status`, `username`, `name`, `id`, `agentID` FROM `crm_user` WHERE `id`=4";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7467670440673828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:43;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6166280;}i:36;a:6:{i:0;s:47:"SELECT `role_type` FROM `crm_role` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7469899654388427734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6197360;}i:37;a:6:{i:0;s:47:"SELECT `role_type` FROM `crm_role` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7474329471588134765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6199400;}i:39;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_role`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.747476100921630859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6204840;}i:40;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_role`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.748402118682861328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6211376;}i:42;a:6:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_role' AND kcu.table_name = 'crm_role'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.748466968536376953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6218496;}i:43;a:6:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_role' AND kcu.table_name = 'crm_role'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7490460872650146484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6221000;}i:45;a:6:{i:0;s:80:"SELECT `active_area`, `active_area_section` FROM `crm_active_area` WHERE `uid`=4";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7492549419403076171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6246376;}i:46;a:6:{i:0;s:80:"SELECT `active_area`, `active_area_section` FROM `crm_active_area` WHERE `uid`=4";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.749720096588134765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6248888;}i:48;a:6:{i:0;s:40:"SHOW FULL COLUMNS FROM `crm_active_area`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.749761104583740234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6254224;}i:49;a:6:{i:0;s:40:"SHOW FULL COLUMNS FROM `crm_active_area`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.750647068023681640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6278240;}i:51;a:6:{i:0;s:617:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_active_area' AND kcu.table_name = 'crm_active_area'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.750762939453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6276304;}i:52;a:6:{i:0;s:617:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_active_area' AND kcu.table_name = 'crm_active_area'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.751307010650634765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6278808;}i:54;a:6:{i:0;s:55:"SELECT `uid` FROM `crm_active_area` WHERE `site`='lfzb'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.751411914825439453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:55;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6280304;}i:55;a:6:{i:0;s:55:"SELECT `uid` FROM `crm_active_area` WHERE `site`='lfzb'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.751967906951904296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:55;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6284760;}i:57;a:6:{i:0;s:47:"SELECT * FROM `crm_diy_config` WHERE `status`=2";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7521169185638427734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:62;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6309232;}i:58;a:6:{i:0;s:47:"SELECT * FROM `crm_diy_config` WHERE `status`=2";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7525699138641357421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:62;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6313208;}i:62;a:6:{i:0;s:37:"SELECT * FROM `fawulfzb`.`crm_levels`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7593319416046142578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7438120;}i:63;a:6:{i:0;s:37:"SELECT * FROM `fawulfzb`.`crm_levels`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.759810924530029296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7441512;}i:65;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_levels`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7598628997802734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7454056;}i:66;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_levels`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7607209682464599609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7458160;}i:68;a:6:{i:0;s:607:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_levels' AND kcu.table_name = 'crm_levels'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.760776042938232421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7465624;}i:69;a:6:{i:0;s:607:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_levels' AND kcu.table_name = 'crm_levels'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7613570690155029296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7467752;}i:71;a:6:{i:0;s:129:"SELECT `uid`, `uname` FROM `crm_active_area` WHERE ((`uid` IN (1, 2, 3, 5, 4, 7, 8)) AND (`t_user_status`=1)) AND (`site`='lfzb')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.76189708709716796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1437;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7509048;}i:72;a:6:{i:0;s:129:"SELECT `uid`, `uname` FROM `crm_active_area` WHERE ((`uid` IN (1, 2, 3, 5, 4, 7, 8)) AND (`t_user_status`=1)) AND (`site`='lfzb')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7624709606170654296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1437;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7513536;}i:74;a:6:{i:0;s:85:"SELECT `roleid`, `status`, `username`, `name`, `agentID` FROM `crm_user` WHERE `id`=4";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7625501155853271484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1442;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7513544;}i:75;a:6:{i:0;s:85:"SELECT `roleid`, `status`, `username`, `name`, `agentID` FROM `crm_user` WHERE `id`=4";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7629909515380859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1442;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7515640;}i:77;a:6:{i:0;s:47:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_company`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7642710208892822265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1491;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7720640;}i:78;a:6:{i:0;s:47:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_company`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7652289867401123046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1491;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7744160;}i:80;a:6:{i:0;s:609:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_company' AND kcu.table_name = 'crm_company'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7653560638427734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1491;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7742272;}i:81;a:6:{i:0;s:609:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_company' AND kcu.table_name = 'crm_company'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7659790515899658203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1491;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7744776;}i:83;a:6:{i:0;s:1594:"SELECT COUNT(*) FROM (SELECT c.id, c.comp_name,c.telephone, c.trace_uid, c.apply_time, c.trace_time, c.industry_id, c.apply_uid,
            d.time,
            e.add_time as comment_at,
            ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) AND (`d`.`time` > 0) GROUP BY `c`.`id` ORDER BY CASE WHEN ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d.time), NOW()))) = 0 THEN 1 ELSE 0 END ASC, `abs_time` DESC, `c`.`trace_time` DESC, `c`.`id` DESC) `c`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7665450572967529296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1521;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7783640;}i:84;a:6:{i:0;s:1594:"SELECT COUNT(*) FROM (SELECT c.id, c.comp_name,c.telephone, c.trace_uid, c.apply_time, c.trace_time, c.industry_id, c.apply_uid,
            d.time,
            e.add_time as comment_at,
            ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) AND (`d`.`time` > 0) GROUP BY `c`.`id` ORDER BY CASE WHEN ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d.time), NOW()))) = 0 THEN 1 ELSE 0 END ASC, `abs_time` DESC, `c`.`trace_time` DESC, `c`.`id` DESC) `c`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7678070068359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1521;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7787080;}i:87;a:6:{i:0;s:1408:"SELECT COUNT(*) FROM (SELECT `c`.`id`, `c`.`comp_name`, `c`.`telephone`, `c`.`trace_uid`, `c`.`apply_time`, `c`.`trace_time`, `c`.`industry_id`, `c`.`apply_uid`, `d`.`time`, `e`.`add_time` AS `comment_at`, ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) GROUP BY `c`.`id`) `c`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7746369838714599609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9294400;}i:88;a:6:{i:0;s:1408:"SELECT COUNT(*) FROM (SELECT `c`.`id`, `c`.`comp_name`, `c`.`telephone`, `c`.`trace_uid`, `c`.`apply_time`, `c`.`trace_time`, `c`.`industry_id`, `c`.`apply_uid`, `d`.`time`, `e`.`add_time` AS `comment_at`, ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) GROUP BY `c`.`id`) `c`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.775866985321044921875;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9297544;}i:90;a:6:{i:0;s:1562:"SELECT `c`.`id`, `c`.`comp_name`, `c`.`telephone`, `c`.`trace_uid`, `c`.`apply_time`, `c`.`trace_time`, `c`.`industry_id`, `c`.`apply_uid`, `d`.`time`, `e`.`add_time` AS `comment_at`, ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) GROUP BY `c`.`id` ORDER BY CASE WHEN ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d.time), NOW()))) = 0 THEN 1 ELSE 0 END ASC, `abs_time` DESC, `c`.`trace_time` DESC, `c`.`id` DESC LIMIT 10";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.776092052459716796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9301440;}i:91;a:6:{i:0;s:1562:"SELECT `c`.`id`, `c`.`comp_name`, `c`.`telephone`, `c`.`trace_uid`, `c`.`apply_time`, `c`.`trace_time`, `c`.`industry_id`, `c`.`apply_uid`, `d`.`time`, `e`.`add_time` AS `comment_at`, ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) GROUP BY `c`.`id` ORDER BY CASE WHEN ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d.time), NOW()))) = 0 THEN 1 ELSE 0 END ASC, `abs_time` DESC, `c`.`trace_time` DESC, `c`.`id` DESC LIMIT 10";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.777163028717041015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9307024;}i:93;a:6:{i:0;s:62:"SELECT * FROM `fawulfzb`.`crm_company_level` `l` WHERE `cid`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.777307033538818359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9308360;}i:94;a:6:{i:0;s:62:"SELECT * FROM `fawulfzb`.`crm_company_level` `l` WHERE `cid`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7777919769287109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9311088;}i:96;a:6:{i:0;s:53:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_company_level`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.777851104736328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9316616;}i:97;a:6:{i:0;s:53:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_company_level`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7786691188812255859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9323032;}i:99;a:6:{i:0;s:621:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_company_level' AND kcu.table_name = 'crm_company_level'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7787420749664306640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9330128;}i:100;a:6:{i:0;s:621:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_company_level' AND kcu.table_name = 'crm_company_level'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7792809009552001953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9332760;}i:102;a:6:{i:0;s:37:"SELECT * FROM `crm_user` WHERE `id`=2";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7794458866119384765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:173;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:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9328144;}i:103;a:6:{i:0;s:37:"SELECT * FROM `crm_user` WHERE `id`=2";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7798960208892822265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:173;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:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9332024;}i:105;a:6:{i:0;s:117:"SELECT * FROM `crm_comment` WHERE (`company_id`=1) AND (`add_uid`=2) AND (`action_sign` IN (1, 4)) ORDER BY `id` DESC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7801349163055419921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:209;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9359520;}i:106;a:6:{i:0;s:117:"SELECT * FROM `crm_comment` WHERE (`company_id`=1) AND (`add_uid`=2) AND (`action_sign` IN (1, 4)) ORDER BY `id` DESC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.78067302703857421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:209;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9363792;}i:108;a:6:{i:0;s:105:"SELECT COUNT(*) FROM `crm_comment` WHERE (`company_id`=1) AND (`add_uid`=2) AND (`action_sign` IN (1, 4))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7807500362396240234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:211;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:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9367616;}i:109;a:6:{i:0;s:105:"SELECT COUNT(*) FROM `crm_comment` WHERE (`company_id`=1) AND (`add_uid`=2) AND (`action_sign` IN (1, 4))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7812249660491943359375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:211;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:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9369728;}}}";s:2:"db";s:44809:"a:1:{s:8:"messages";a:56:{i:6;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_user`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.735210895538330078125;i:4;a:0:{}i:5;i:4592640;}i:7;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_user`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.736341953277587890625;i:4;a:0:{}i:5;i:4606744;}i:9;a:6:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_user' AND kcu.table_name = 'crm_user'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7366468906402587890625;i:4;a:0:{}i:5;i:4630760;}i:10;a:6:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_user' AND kcu.table_name = 'crm_user'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7373139858245849609375;i:4;a:0:{}i:5;i:4632136;}i:12;a:6:{i:0;s:56:"SELECT * FROM `crm_user` WHERE (`id`=4) AND (`status`=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7388288974761962890625;i:4;a:0:{}i:5;i:4950392;}i:13;a:6:{i:0;s:56:"SELECT * FROM `crm_user` WHERE (`id`=4) AND (`status`=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7394440174102783203125;i:4;a:0:{}i:5;i:4953056;}i:33;a:6:{i:0;s:91:"SELECT `roleid`, `status`, `username`, `name`, `id`, `agentID` FROM `crm_user` WHERE `id`=4";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7462980747222900390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:43;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6163712;}i:34;a:6:{i:0;s:91:"SELECT `roleid`, `status`, `username`, `name`, `id`, `agentID` FROM `crm_user` WHERE `id`=4";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7467670440673828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:43;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6166280;}i:36;a:6:{i:0;s:47:"SELECT `role_type` FROM `crm_role` WHERE `id`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7469899654388427734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6197360;}i:37;a:6:{i:0;s:47:"SELECT `role_type` FROM `crm_role` WHERE `id`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7474329471588134765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6199400;}i:39;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_role`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.747476100921630859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6204840;}i:40;a:6:{i:0;s:33:"SHOW FULL COLUMNS FROM `crm_role`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.748402118682861328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6211376;}i:42;a:6:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_role' AND kcu.table_name = 'crm_role'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.748466968536376953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6218496;}i:43;a:6:{i:0;s:603:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_role' AND kcu.table_name = 'crm_role'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7490460872650146484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:47;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6221000;}i:45;a:6:{i:0;s:80:"SELECT `active_area`, `active_area_section` FROM `crm_active_area` WHERE `uid`=4";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7492549419403076171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6246376;}i:46;a:6:{i:0;s:80:"SELECT `active_area`, `active_area_section` FROM `crm_active_area` WHERE `uid`=4";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.749720096588134765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6248888;}i:48;a:6:{i:0;s:40:"SHOW FULL COLUMNS FROM `crm_active_area`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.749761104583740234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6254224;}i:49;a:6:{i:0;s:40:"SHOW FULL COLUMNS FROM `crm_active_area`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.750647068023681640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6278240;}i:51;a:6:{i:0;s:617:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_active_area' AND kcu.table_name = 'crm_active_area'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.750762939453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6276304;}i:52;a:6:{i:0;s:617:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_active_area' AND kcu.table_name = 'crm_active_area'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.751307010650634765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:50;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6278808;}i:54;a:6:{i:0;s:55:"SELECT `uid` FROM `crm_active_area` WHERE `site`='lfzb'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.751411914825439453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:55;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6280304;}i:55;a:6:{i:0;s:55:"SELECT `uid` FROM `crm_active_area` WHERE `site`='lfzb'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.751967906951904296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:55;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6284760;}i:57;a:6:{i:0;s:47:"SELECT * FROM `crm_diy_config` WHERE `status`=2";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7521169185638427734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:62;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6309232;}i:58;a:6:{i:0;s:47:"SELECT * FROM `crm_diy_config` WHERE `status`=2";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7525699138641357421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:60:"/mnt/www/law_firm/crm/backend/controllers/BaseController.php";s:4:"line";i:62;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:63;s:8:"function";s:11:"__construct";s:5:"class";s:34:"backend\controllers\BaseController";s:4:"type";s:2:"->";}}i:5;i:6313208;}i:62;a:6:{i:0;s:37:"SELECT * FROM `fawulfzb`.`crm_levels`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7593319416046142578125;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7438120;}i:63;a:6:{i:0;s:37:"SELECT * FROM `fawulfzb`.`crm_levels`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.759810924530029296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7441512;}i:65;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_levels`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7598628997802734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7454056;}i:66;a:6:{i:0;s:46:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_levels`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7607209682464599609375;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7458160;}i:68;a:6:{i:0;s:607:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_levels' AND kcu.table_name = 'crm_levels'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.760776042938232421875;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7465624;}i:69;a:6:{i:0;s:607:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_levels' AND kcu.table_name = 'crm_levels'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7613570690155029296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1427;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7467752;}i:71;a:6:{i:0;s:129:"SELECT `uid`, `uname` FROM `crm_active_area` WHERE ((`uid` IN (1, 2, 3, 5, 4, 7, 8)) AND (`t_user_status`=1)) AND (`site`='lfzb')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.76189708709716796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1437;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7509048;}i:72;a:6:{i:0;s:129:"SELECT `uid`, `uname` FROM `crm_active_area` WHERE ((`uid` IN (1, 2, 3, 5, 4, 7, 8)) AND (`t_user_status`=1)) AND (`site`='lfzb')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7624709606170654296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1437;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7513536;}i:74;a:6:{i:0;s:85:"SELECT `roleid`, `status`, `username`, `name`, `agentID` FROM `crm_user` WHERE `id`=4";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7625501155853271484375;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1442;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7513544;}i:75;a:6:{i:0;s:85:"SELECT `roleid`, `status`, `username`, `name`, `agentID` FROM `crm_user` WHERE `id`=4";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7629909515380859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1442;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}i:5;i:7515640;}i:77;a:6:{i:0;s:47:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_company`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7642710208892822265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1491;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7720640;}i:78;a:6:{i:0;s:47:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_company`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7652289867401123046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1491;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7744160;}i:80;a:6:{i:0;s:609:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_company' AND kcu.table_name = 'crm_company'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7653560638427734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1491;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7742272;}i:81;a:6:{i:0;s:609:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_company' AND kcu.table_name = 'crm_company'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7659790515899658203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1491;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7744776;}i:83;a:6:{i:0;s:1594:"SELECT COUNT(*) FROM (SELECT c.id, c.comp_name,c.telephone, c.trace_uid, c.apply_time, c.trace_time, c.industry_id, c.apply_uid,
            d.time,
            e.add_time as comment_at,
            ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) AND (`d`.`time` > 0) GROUP BY `c`.`id` ORDER BY CASE WHEN ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d.time), NOW()))) = 0 THEN 1 ELSE 0 END ASC, `abs_time` DESC, `c`.`trace_time` DESC, `c`.`id` DESC) `c`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7665450572967529296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1521;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7783640;}i:84;a:6:{i:0;s:1594:"SELECT COUNT(*) FROM (SELECT c.id, c.comp_name,c.telephone, c.trace_uid, c.apply_time, c.trace_time, c.industry_id, c.apply_uid,
            d.time,
            e.add_time as comment_at,
            ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) AND (`d`.`time` > 0) GROUP BY `c`.`id` ORDER BY CASE WHEN ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d.time), NOW()))) = 0 THEN 1 ELSE 0 END ASC, `abs_time` DESC, `c`.`trace_time` DESC, `c`.`id` DESC) `c`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7678070068359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:54:"/mnt/www/law_firm/crm/backend/models/CompanySearch.php";s:4:"line";i:1521;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:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1448;s:8:"function";s:12:"track_counts";s:5:"class";s:28:"backend\models\CompanySearch";s:4:"type";s:2:"->";}}i:5;i:7787080;}i:87;a:6:{i:0;s:1408:"SELECT COUNT(*) FROM (SELECT `c`.`id`, `c`.`comp_name`, `c`.`telephone`, `c`.`trace_uid`, `c`.`apply_time`, `c`.`trace_time`, `c`.`industry_id`, `c`.`apply_uid`, `d`.`time`, `e`.`add_time` AS `comment_at`, ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) GROUP BY `c`.`id`) `c`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7746369838714599609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9294400;}i:88;a:6:{i:0;s:1408:"SELECT COUNT(*) FROM (SELECT `c`.`id`, `c`.`comp_name`, `c`.`telephone`, `c`.`trace_uid`, `c`.`apply_time`, `c`.`trace_time`, `c`.`industry_id`, `c`.`apply_uid`, `d`.`time`, `e`.`add_time` AS `comment_at`, ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) GROUP BY `c`.`id`) `c`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.775866985321044921875;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9297544;}i:90;a:6:{i:0;s:1562:"SELECT `c`.`id`, `c`.`comp_name`, `c`.`telephone`, `c`.`trace_uid`, `c`.`apply_time`, `c`.`trace_time`, `c`.`industry_id`, `c`.`apply_uid`, `d`.`time`, `e`.`add_time` AS `comment_at`, ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) GROUP BY `c`.`id` ORDER BY CASE WHEN ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d.time), NOW()))) = 0 THEN 1 ELSE 0 END ASC, `abs_time` DESC, `c`.`trace_time` DESC, `c`.`id` DESC LIMIT 10";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.776092052459716796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9301440;}i:91;a:6:{i:0;s:1562:"SELECT `c`.`id`, `c`.`comp_name`, `c`.`telephone`, `c`.`trace_uid`, `c`.`apply_time`, `c`.`trace_time`, `c`.`industry_id`, `c`.`apply_uid`, `d`.`time`, `e`.`add_time` AS `comment_at`, ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(e.add_time), NOW()))) AS abs_time FROM `fawulfzb`.`crm_company` `c` LEFT JOIN `fawulfzb`.`crm_company_level` `l` ON `c`.`id` = `l`.`cid` LEFT JOIN (SELECT `d1`.`cid`, `d1`.`time` FROM `crm_company_remark_remind` `d1` WHERE (`d1`.`status`=0) AND (`d1`.`time` < 1779844625) AND (d1.time = (SELECT d2.time FROM crm_company_remark_remind d2 
                WHERE d2.status = 0 AND d2.uid = d1.uid AND d2.cid = d1.cid and d2.time< 1779844625
                ORDER BY ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d2.time), NOW()))) ASC LIMIT 1)) AND (d1.id > (SELECT d3.id    FROM crm_company_remark_remind d3 
                WHERE d3.status = 1 AND d3.uid = d1.uid AND d3.cid = d1.cid and d3.time< 1779844625
                ORDER BY d3.id desc LIMIT 1))) `d` ON d.cid = c.id LEFT JOIN (SELECT `t1`.`id`, MAX(t1.add_time) as add_time, `t1`.`company_id`, `t1`.`add_uid` FROM `crm_comment` `t1` WHERE `t1`.`action_sign` IN (1, 4) GROUP BY `company_id`) `e` ON e.company_id = c.id and e.add_uid = c.trace_uid WHERE (`c`.`is_del`=1) AND (`c`.`is_black`=1) AND (`c`.`is_old`=0) AND (`c`.`trace_uid` IN (1, 2, 3, 5, 4, 7, 8)) GROUP BY `c`.`id` ORDER BY CASE WHEN ABS(TIMESTAMPDIFF(SECOND, NOW(), IFNULL(FROM_UNIXTIME(d.time), NOW()))) = 0 THEN 1 ELSE 0 END ASC, `abs_time` DESC, `c`.`trace_time` DESC, `c`.`id` DESC LIMIT 10";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.777163028717041015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9307024;}i:93;a:6:{i:0;s:62:"SELECT * FROM `fawulfzb`.`crm_company_level` `l` WHERE `cid`=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.777307033538818359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9308360;}i:94;a:6:{i:0;s:62:"SELECT * FROM `fawulfzb`.`crm_company_level` `l` WHERE `cid`=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7777919769287109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9311088;}i:96;a:6:{i:0;s:53:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_company_level`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.777851104736328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9316616;}i:97;a:6:{i:0;s:53:"SHOW FULL COLUMNS FROM `fawulfzb`.`crm_company_level`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7786691188812255859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9323032;}i:99;a:6:{i:0;s:621:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_company_level' AND kcu.table_name = 'crm_company_level'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7787420749664306640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9330128;}i:100;a:6:{i:0;s:621:"SELECT
    kcu.constraint_name,
    kcu.column_name,
    kcu.referenced_table_name,
    kcu.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 = 'crm_company_level' AND kcu.table_name = 'crm_company_level'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7792809009552001953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9332760;}i:102;a:6:{i:0;s:37:"SELECT * FROM `crm_user` WHERE `id`=2";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7794458866119384765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:173;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:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9328144;}i:103;a:6:{i:0;s:37:"SELECT * FROM `crm_user` WHERE `id`=2";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7798960208892822265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:173;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:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9332024;}i:105;a:6:{i:0;s:117:"SELECT * FROM `crm_comment` WHERE (`company_id`=1) AND (`add_uid`=2) AND (`action_sign` IN (1, 4)) ORDER BY `id` DESC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7801349163055419921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:209;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9359520;}i:106;a:6:{i:0;s:117:"SELECT * FROM `crm_comment` WHERE (`company_id`=1) AND (`add_uid`=2) AND (`action_sign` IN (1, 4)) ORDER BY `id` DESC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.78067302703857421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:209;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9363792;}i:108;a:6:{i:0;s:105:"SELECT COUNT(*) FROM `crm_comment` WHERE (`company_id`=1) AND (`add_uid`=2) AND (`action_sign` IN (1, 4))";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7807500362396240234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:211;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:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9367616;}i:109;a:6:{i:0;s:105:"SELECT COUNT(*) FROM `crm_comment` WHERE (`company_id`=1) AND (`add_uid`=2) AND (`action_sign` IN (1, 4))";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1779844625.7812249660491943359375;i:4;a:3:{i:0;a:5:{s:4:"file";s:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:211;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:53:"/mnt/www/law_firm/crm/backend/views/company/track.php";s:4:"line";i:263;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:63:"/mnt/www/law_firm/crm/backend/controllers/CompanyController.php";s:4:"line";i:1459;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:9369728;}}}";s:5:"event";s:14277:"a:76:{i:0;a:5:{s:4:"time";d:1779844625.731093883514404296875;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:1;a:5:{s:4:"time";d:1779844625.735198974609375;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:2;a:5:{s:4:"time";d:1779844625.7394659519195556640625;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:"backend\models\User";}i:3;a:5:{s:4:"time";d:1779844625.7394959926605224609375;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:"backend\models\User";}i:4;a:5:{s:4:"time";d:1779844625.741671085357666015625;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:"backend\models\User";}i:5;a:5:{s:4:"time";d:1779844625.7435810565948486328125;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:6;a:5:{s:4:"time";d:1779844625.7462100982666015625;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:7;a:5:{s:4:"time";d:1779844625.7468221187591552734375;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:"backend\models\User";}i:8;a:5:{s:4:"time";d:1779844625.746841907501220703125;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:"backend\models\User";}i:9;a:5:{s:4:"time";d:1779844625.7469298839569091796875;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:10;a:5:{s:4:"time";d:1779844625.74744701385498046875;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:"backend\models\Role";}i:11;a:5:{s:4:"time";d:1779844625.7490670680999755859375;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:"backend\models\Role";}i:12;a:5:{s:4:"time";d:1779844625.74919605255126953125;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:13;a:5:{s:4:"time";d:1779844625.74973392486572265625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"backend\models\ActiveArea";}i:14;a:5:{s:4:"time";d:1779844625.7513320446014404296875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"backend\models\ActiveArea";}i:15;a:5:{s:4:"time";d:1779844625.7513558864593505859375;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:16;a:5:{s:4:"time";d:1779844625.7520720958709716796875;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:17;a:5:{s:4:"time";d:1779844625.752809047698974609375;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:18;a:5:{s:4:"time";d:1779844625.7528169155120849609375;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:37:"backend\controllers\CompanyController";}i:19;a:5:{s:4:"time";d:1779844625.7578179836273193359375;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:20;a:5:{s:4:"time";d:1779844625.7592799663543701171875;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:21;a:5:{s:4:"time";d:1779844625.7598268985748291015625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"backend\models\Levels";}i:22;a:5:{s:4:"time";d:1779844625.761383056640625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"backend\models\Levels";}i:23;a:5:{s:4:"time";d:1779844625.761395931243896484375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"backend\models\Levels";}i:24;a:5:{s:4:"time";d:1779844625.7614040374755859375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"backend\models\Levels";}i:25;a:5:{s:4:"time";d:1779844625.761413097381591796875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"backend\models\Levels";}i:26;a:5:{s:4:"time";d:1779844625.761416912078857421875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"backend\models\Levels";}i:27;a:5:{s:4:"time";d:1779844625.7614190578460693359375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"backend\models\Levels";}i:28;a:5:{s:4:"time";d:1779844625.7614219188690185546875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"backend\models\Levels";}i:29;a:5:{s:4:"time";d:1779844625.7614319324493408203125;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:1779844625.7624900341033935546875;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:1779844625.7630069255828857421875;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:"backend\models\User";}i:32;a:5:{s:4:"time";d:1779844625.7630259990692138671875;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:"backend\models\User";}i:33;a:5:{s:4:"time";d:1779844625.7630519866943359375;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:34;a:5:{s:4:"time";d:1779844625.7631819248199462890625;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:28:"backend\models\CompanySearch";}i:35;a:5:{s:4:"time";d:1779844625.7660329341888427734375;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:28:"backend\models\CompanySearch";}i:36;a:5:{s:4:"time";d:1779844625.7661750316619873046875;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:37;a:5:{s:4:"time";d:1779844625.7685310840606689453125;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:38;a:5:{s:4:"time";d:1779844625.7700850963592529296875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:39;a:5:{s:4:"time";d:1779844625.7701370716094970703125;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:40;a:5:{s:4:"time";d:1779844625.7719628810882568359375;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:41;a:5:{s:4:"time";d:1779844625.772777080535888671875;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:"yii\grid\GridView";}i:42;a:5:{s:4:"time";d:1779844625.7743189334869384765625;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\grid\GridView";}i:43;a:5:{s:4:"time";d:1779844625.774446964263916015625;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:44;a:5:{s:4:"time";d:1779844625.7759211063385009765625;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:45;a:5:{s:4:"time";d:1779844625.7772319316864013671875;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:46;a:5:{s:4:"time";d:1779844625.7778160572052001953125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:27:"backend\models\CompanyLevel";}i:47;a:5:{s:4:"time";d:1779844625.7793140411376953125;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:27:"backend\models\CompanyLevel";}i:48;a:5:{s:4:"time";d:1779844625.77933502197265625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:28:"backend\models\CompanySearch";}i:49;a:5:{s:4:"time";d:1779844625.77939510345458984375;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:50;a:5:{s:4:"time";d:1779844625.7800579071044921875;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:51;a:5:{s:4:"time";d:1779844625.78069210052490234375;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:52;a:5:{s:4:"time";d:1779844625.7817571163177490234375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:30:"backend\components\GoLinkPager";}i:53;a:5:{s:4:"time";d:1779844625.78176403045654296875;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:30:"backend\components\GoLinkPager";}i:54;a:5:{s:4:"time";d:1779844625.7817709445953369140625;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:30:"backend\components\GoLinkPager";}i:55;a:5:{s:4:"time";d:1779844625.7817859649658203125;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\grid\GridView";}i:56;a:5:{s:4:"time";d:1779844625.781797885894775390625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:57;a:5:{s:4:"time";d:1779844625.781816959381103515625;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:58;a:5:{s:4:"time";d:1779844625.781877994537353515625;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:59;a:5:{s:4:"time";d:1779844625.78188610076904296875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:60;a:5:{s:4:"time";d:1779844625.781898975372314453125;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:61;a:5:{s:4:"time";d:1779844625.781919956207275390625;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:62;a:5:{s:4:"time";d:1779844625.7819271087646484375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:63;a:5:{s:4:"time";d:1779844625.781938076019287109375;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:64;a:5:{s:4:"time";d:1779844625.7819569110870361328125;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:65;a:5:{s:4:"time";d:1779844625.782000064849853515625;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:66;a:5:{s:4:"time";d:1779844625.78207111358642578125;s:4:"name";s:9:"beginPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:67;a:5:{s:4:"time";d:1779844625.7820880413055419921875;s:4:"name";s:9:"beginBody";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:68;a:5:{s:4:"time";d:1779844625.782145977020263671875;s:4:"name";s:7:"endBody";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:69;a:5:{s:4:"time";d:1779844625.78225994110107421875;s:4:"name";s:7:"endPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:70;a:5:{s:4:"time";d:1779844625.7823679447174072265625;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:37:"backend\controllers\CompanyController";}i:71;a:5:{s:4:"time";d:1779844625.782372951507568359375;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:72;a:5:{s:4:"time";d:1779844625.7823810577392578125;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:73;a:5:{s:4:"time";d:1779844625.7823870182037353515625;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:74;a:5:{s:4:"time";d:1779844625.7825019359588623046875;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:75;a:5:{s:4:"time";d:1779844625.7826039791107177734375;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:6:"assets";s:3468:"a:8:{s:23:"backend\assets\AppAsset";a:9:{s:8:"basePath";s:42:"/opt/lampp/htdocs/law_firm/crm/backend/web";s:7:"baseUrl";s:0:"";s:3:"css";a:8:{i:0;s:18:"main/css/icons.css";i:1;s:52:"template/vendors/mdi/css/materialdesignicons.min.css";i:2;s:44:"template/vendors/base/vendor.bundle.base.css";i:3;s:30:"main/css/ht-style/ty-style.css";i:4;s:26:"main/css/ht-style/main.css";i:5;s:22:"template/css/style.css";i:6;s:37:"main/css/bootstrap-datetimepicker.css";i:7;s:26:"main/css/bootstrap.min.css";}s:2:"js";a:5:{i:0;s:27:"main/js/jquery-1.8.3.min.js";i:1;s:24:"main/js/bootstrap.min.js";i:2;s:30:"main/js/moment-with-locales.js";i:3;s:35:"main/js/bootstrap-datetimepicker.js";i:4;s:35:"public/libs/node-waves/waves.min.js";}s:7:"depends";a:1:{i:0;s:16:"yii\web\YiiAsset";}s:10:"sourcePath";N;s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:16:"yii\web\YiiAsset";a:9:{s:10:"sourcePath";s:48:"/mnt/www/law_firm/crm/vendor/yiisoft/yii2/assets";s:2:"js";a:1:{i:0;s:6:"yii.js";}s:7:"depends";a:1:{i:0;s:19:"yii\web\JqueryAsset";}s:8:"basePath";s:49:"/mnt/www/law_firm/crm/backend/web/assets/9c9cb3fc";s:7:"baseUrl";s:16:"/assets/9c9cb3fc";s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:19:"yii\web\JqueryAsset";a:9:{s:10:"sourcePath";s:52:"/mnt/www/law_firm/crm/vendor/bower-asset/jquery/dist";s:2:"js";a:1:{i:0;s:9:"jquery.js";}s:8:"basePath";s:49:"/mnt/www/law_firm/crm/backend/web/assets/c65721f8";s:7:"baseUrl";s:16:"/assets/c65721f8";s:7:"depends";a:0:{}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:43:"/public/plugins/select2/css/select2.min.css";a:9:{s:10:"sourcePath";N;s:8:"basePath";N;s:7:"baseUrl";s:0:"";s:7:"depends";a:1:{i:0;s:23:"backend\assets\AppAsset";}s:2:"js";a:0:{}s:3:"css";a:1:{i:0;s:42:"public/plugins/select2/css/select2.min.css";}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:1:{i:0;s:23:"backend\assets\AppAsset";}s:14:"publishOptions";a:0:{}}s:41:"/public/plugins/select2/js/select2.min.js";a:9:{s:10:"sourcePath";N;s:8:"basePath";N;s:7:"baseUrl";s:0:"";s:7:"depends";a:1:{i:0;s:23:"backend\assets\AppAsset";}s:2:"js";a:1:{i:0;s:40:"public/plugins/select2/js/select2.min.js";}s:3:"css";a:0:{}s:9:"jsOptions";a:1:{i:0;s:23:"backend\assets\AppAsset";}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:21:"/public/js/echarts.js";a:9:{s:10:"sourcePath";N;s:8:"basePath";N;s:7:"baseUrl";s:0:"";s:7:"depends";a:1:{i:0;s:23:"backend\assets\AppAsset";}s:2:"js";a:1:{i:0;s:20:"public/js/echarts.js";}s:3:"css";a:0:{}s:9:"jsOptions";a:1:{i:0;s:23:"backend\assets\AppAsset";}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:27:"yii\widgets\ActiveFormAsset";a:9:{s:10:"sourcePath";s:48:"/mnt/www/law_firm/crm/vendor/yiisoft/yii2/assets";s:2:"js";a:1:{i:0;s:17:"yii.activeForm.js";}s:7:"depends";a:1:{i:0;s:16:"yii\web\YiiAsset";}s:8:"basePath";s:49:"/mnt/www/law_firm/crm/backend/web/assets/9c9cb3fc";s:7:"baseUrl";s:16:"/assets/9c9cb3fc";s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:22:"yii\grid\GridViewAsset";a:9:{s:10:"sourcePath";s:48:"/mnt/www/law_firm/crm/vendor/yiisoft/yii2/assets";s:2:"js";a:1:{i:0;s:15:"yii.gridView.js";}s:7:"depends";a:1:{i:0;s:16:"yii\web\YiiAsset";}s:8:"basePath";s:49:"/mnt/www/law_firm/crm/backend/web/assets/9c9cb3fc";s:7:"baseUrl";s:16:"/assets/9c9cb3fc";s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:118:"a:3:{s:5:"start";d:1779844625.7176330089569091796875;s:3:"end";d:1779844625.78376007080078125;s:6:"memory";i:9479776;}";s:4:"user";s:1314:"a:5:{s:2:"id";i:4;s:8:"identity";a:12:{s:2:"id";s:1:"4";s:8:"username";s:10:"'NO.07761'";s:8:"password";s:34:"'e10adc3949ba59abbe56e057f20f883e'";s:7:"agentID";s:2:"''";s:6:"status";s:1:"1";s:4:"name";s:8:"'李敏'";s:10:"entry_date";s:12:"'1620230400'";s:9:"quit_time";s:1:"0";s:11:"create_time";s:10:"1768983519";s:6:"roleid";s:1:"1";s:9:"la_roleid";s:1:"0";s:6:"is_del";s:1:"1";}s:10:"attributes";a:12:{i:0;a:2:{s:9:"attribute";s:2:"id";s:5:"label";s:2:"ID";}i:1;a:2:{s:9:"attribute";s:8:"username";s:5:"label";s:6:"账号";}i:2;a:2:{s:9:"attribute";s:8:"password";s:5:"label";s:6:"密码";}i:3;a:2:{s:9:"attribute";s:7:"agentID";s:5:"label";s:8:"Agent Id";}i:4;a:2:{s:9:"attribute";s:6:"status";s:5:"label";s:22:"状态 1在职 2离职";}i:5;a:2:{s:9:"attribute";s:4:"name";s:5:"label";s:6:"姓名";}i:6;a:2:{s:9:"attribute";s:10:"entry_date";s:5:"label";s:12:"入职日期";}i:7;a:2:{s:9:"attribute";s:9:"quit_time";s:5:"label";s:12:"离职时间";}i:8;a:2:{s:9:"attribute";s:11:"create_time";s:5:"label";s:12:"创建时间";}i:9;a:2:{s:9:"attribute";s:6:"roleid";s:5:"label";s:8:"角色id";}i:10;a:2:{s:9:"attribute";s:9:"la_roleid";s:5:"label";s:9:"La Roleid";}i:11;a:2:{s:9:"attribute";s:6:"is_del";s:5:"label";s:32:"是否删除 1未删除 2 删除";}}s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:6:"router";s:2287:"a:1:{s:8:"messages";a:11:{i:20;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:1779844625.7437179088592529296875;i:4;a:0:{}i:5;i:5720512;}i:21;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/<id:\w+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1779844625.7437260150909423828125;i:4;a:0:{}i:5;i:5721264;}i:22;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1779844625.743730068206787109375;i:4;a:0:{}i:5;i:5722016;}i:23;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:1779844625.743732929229736328125;i:4;a:0:{}i:5;i:5722768;}i:24;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1779844625.7437360286712646484375;i:4;a:0:{}i:5;i:5723520;}i:25;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:1779844625.7437379360198974609375;i:4;a:0:{}i:5;i:5724272;}i:26;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/<id:\w+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1779844625.743740081787109375;i:4;a:0:{}i:5;i:5725024;}i:27;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1779844625.7437419891357421875;i:4;a:0:{}i:5;i:5725776;}i:28;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:1779844625.7437450885772705078125;i:4;a:0:{}i:5;i:5726528;}i:29;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug/<controller:[\w\-]+>/<action:[\w\-]+>";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1779844625.7437469959259033203125;i:4;a:0:{}i:5;i:5727280;}i:30;a:6:{i:0;s:55:"No matching URL rules. Using default URL parsing logic.";i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1779844625.7437489032745361328125;i:4;a:0:{}i:5;i:5727656;}}}";s:7:"summary";a:10:{s:3:"tag";s:13:"6a164611b5860";s:3:"url";s:45:"http://lfzb.crm.fashengsuan.com/company/track";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"60.16.87.251";s:4:"time";d:1779844625.7149999141693115234375;s:10:"statusCode";i:200;s:8:"sqlCount";i:28;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}}s:10:"exceptions";a:0:{}}