-
-
Save des1roer/f9d63384d41f0467d7c30def384ee4e8 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
a:11:{s:6:"config";a:5:{s:10:"phpVersion";s:8:"7.1.19-1";s:10:"yiiVersion";s:6:"2.0.15";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.15";s:4:"name";s:12:"sima-land.ru";s:7:"version";s:3:"1.0";s:8:"language";s:5:"ru-RU";s:14:"sourceLanguage";s:5:"en-US";s:7:"charset";s:5:"UTF-8";s:3:"env";s:3:"dev";s:5:"debug";b:1;}s:3:"php";a:5:{s:7:"version";s:8:"7.1.19-1";s:6:"xdebug";b:1;s:3:"apc";b:1;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:43:{s:22:"yiisoft/yii2-bootstrap";a:3:{s:4:"name";s:22:"yiisoft/yii2-bootstrap";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:14:"@yii/bootstrap";s:43:"/var/www/html/vendor/yiisoft/yii2-bootstrap";}}s:29:"2amigos/yii2-selectize-widget";a:3:{s:4:"name";s:29:"2amigos/yii2-selectize-widget";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:20:"@dosamigos/selectize";s:54:"/var/www/html/vendor/2amigos/yii2-selectize-widget/src";}}s:31:"alexandernst/yii2-device-detect";a:3:{s:4:"name";s:31:"alexandernst/yii2-device-detect";s:7:"version";s:8:"0.0.11.0";s:5:"alias";a:1:{s:26:"@alexandernst/devicedetect";s:52:"/var/www/html/vendor/alexandernst/yii2-device-detect";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:10:"@yii/debug";s:39:"/var/www/html/vendor/yiisoft/yii2-debug";}}s:27:"2amigos/yii2-chartjs-widget";a:3:{s:4:"name";s:27:"2amigos/yii2-chartjs-widget";s:7:"version";s:7:"2.0.1.0";s:5:"alias";a:1:{s:18:"@dosamigos/chartjs";s:52:"/var/www/html/vendor/2amigos/yii2-chartjs-widget/src";}}s:19:"bedezign/yii2-audit";a:4:{s:4:"name";s:19:"bedezign/yii2-audit";s:7:"version";s:8:"1.0.11.0";s:5:"alias";a:1:{s:20:"@bedezign/yii2/audit";s:44:"/var/www/html/vendor/bedezign/yii2-audit/src";}s:9:"bootstrap";s:29:"bedezign\yii2\audit\Bootstrap";}s:16:"index0h/yii2-log";a:3:{s:4:"name";s:16:"index0h/yii2-log";s:7:"version";s:7:"0.0.3.0";s:5:"alias";a:1:{s:12:"@index0h/log";s:41:"/var/www/html/vendor/index0h/yii2-log/src";}}s:33:"justinvoelker/yii2-separatedpager";a:3:{s:4:"name";s:33:"justinvoelker/yii2-separatedpager";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:29:"@justinvoelker/separatedpager";s:54:"/var/www/html/vendor/justinvoelker/yii2-separatedpager";}}s:25:"kartik-v/yii2-krajee-base";a:3:{s:4:"name";s:25:"kartik-v/yii2-krajee-base";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:12:"@kartik/base";s:46:"/var/www/html/vendor/kartik-v/yii2-krajee-base";}}s:24:"kartik-v/yii2-date-range";a:3:{s:4:"name";s:24:"kartik-v/yii2-date-range";s:7:"version";s:7:"1.6.3.0";s:5:"alias";a:1:{s:17:"@kartik/daterange";s:45:"/var/www/html/vendor/kartik-v/yii2-date-range";}}s:18:"kartik-v/yii2-grid";a:3:{s:4:"name";s:18:"kartik-v/yii2-grid";s:7:"version";s:7:"3.0.7.0";s:5:"alias";a:1:{s:12:"@kartik/grid";s:39:"/var/www/html/vendor/kartik-v/yii2-grid";}}s:18:"kartik-v/yii2-mpdf";a:3:{s:4:"name";s:18:"kartik-v/yii2-mpdf";s:7:"version";s:7:"1.0.5.0";s:5:"alias";a:1:{s:12:"@kartik/mpdf";s:43:"/var/www/html/vendor/kartik-v/yii2-mpdf/src";}}s:30:"kartik-v/yii2-widget-typeahead";a:3:{s:4:"name";s:30:"kartik-v/yii2-widget-typeahead";s:7:"version";s:7:"1.0.1.0";s:5:"alias";a:1:{s:17:"@kartik/typeahead";s:51:"/var/www/html/vendor/kartik-v/yii2-widget-typeahead";}}s:18:"mdmsoft/yii2-admin";a:3:{s:4:"name";s:18:"mdmsoft/yii2-admin";s:7:"version";s:7:"2.8.0.0";s:5:"alias";a:1:{s:10:"@mdm/admin";s:39:"/var/www/html/vendor/mdmsoft/yii2-admin";}}s:26:"moonlandsoft/yii2-phpexcel";a:3:{s:4:"name";s:26:"moonlandsoft/yii2-phpexcel";s:7:"version";s:7:"1.1.0.0";s:5:"alias";a:1:{s:18:"@moonland/phpexcel";s:47:"/var/www/html/vendor/moonlandsoft/yii2-phpexcel";}}s:22:"nkovacs/yii2-pagesizer";a:3:{s:4:"name";s:22:"nkovacs/yii2-pagesizer";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:18:"@nkovacs/pagesizer";s:43:"/var/www/html/vendor/nkovacs/yii2-pagesizer";}}s:24:"pahanini/yii2-neat-cache";a:3:{s:4:"name";s:24:"pahanini/yii2-neat-cache";s:7:"version";s:7:"0.0.4.0";s:5:"alias";a:1:{s:19:"@pahanini/neatcache";s:49:"/var/www/html/vendor/pahanini/yii2-neat-cache/src";}}s:22:"pahanini/yii2-rest-doc";a:3:{s:4:"name";s:22:"pahanini/yii2-rest-doc";s:7:"version";s:8:"0.0.10.0";s:5:"alias";a:1:{s:17:"@pahanini/restdoc";s:43:"/var/www/html/vendor/pahanini/yii2-rest-doc";}}s:23:"pastuhov/yii2-query-tag";a:3:{s:4:"name";s:23:"pastuhov/yii2-query-tag";s:7:"version";s:7:"1.2.0.0";s:5:"alias";a:1:{s:18:"@pastuhov/querytag";s:48:"/var/www/html/vendor/pastuhov/yii2-query-tag/src";}}s:18:"yiisoft/yii2-redis";a:3:{s:4:"name";s:18:"yiisoft/yii2-redis";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:10:"@yii/redis";s:39:"/var/www/html/vendor/yiisoft/yii2-redis";}}s:25:"pastuhov/yii2-redis-mutex";a:3:{s:4:"name";s:25:"pastuhov/yii2-redis-mutex";s:7:"version";s:7:"0.1.1.0";s:5:"alias";a:1:{s:24:"@pastuhov/yii2redismutex";s:50:"/var/www/html/vendor/pastuhov/yii2-redis-mutex/src";}}s:25:"pastuhov/yii2-yml-catalog";a:3:{s:4:"name";s:25:"pastuhov/yii2-yml-catalog";s:7:"version";s:7:"1.2.0.0";s:5:"alias";a:1:{s:20:"@pastuhov/ymlcatalog";s:50:"/var/www/html/vendor/pastuhov/yii2-yml-catalog/src";}}s:33:"sima-land/yii2-pg-stat-statements";a:3:{s:4:"name";s:33:"sima-land/yii2-pg-stat-statements";s:7:"version";s:7:"0.8.1.0";s:5:"alias";a:1:{s:26:"@simaland/pgstatstatements";s:58:"/var/www/html/vendor/sima-land/yii2-pg-stat-statements/src";}}s:23:"yiisoft/yii2-httpclient";a:3:{s:4:"name";s:23:"yiisoft/yii2-httpclient";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:15:"@yii/httpclient";s:44:"/var/www/html/vendor/yiisoft/yii2-httpclient";}}s:13:"sima/sypexgeo";a:3:{s:4:"name";s:13:"sima/sypexgeo";s:7:"version";s:7:"1.1.1.0";s:5:"alias";a:1:{s:14:"@sima/sypexgeo";s:38:"/var/www/html/vendor/sima/sypexgeo/src";}}s:18:"pahanini/yii2-curl";a:3:{s:4:"name";s:18:"pahanini/yii2-curl";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:14:"@pahanini/curl";s:39:"/var/www/html/vendor/pahanini/yii2-curl";}}s:24:"yiisoft/yii2-codeception";a:3:{s:4:"name";s:24:"yiisoft/yii2-codeception";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:16:"@yii/codeception";s:45:"/var/www/html/vendor/yiisoft/yii2-codeception";}}s:16:"yii2tech/crontab";a:3:{s:4:"name";s:16:"yii2tech/crontab";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:17:"@yii2tech/crontab";s:37:"/var/www/html/vendor/yii2tech/crontab";}}s:17:"yii2tech/csv-grid";a:3:{s:4:"name";s:17:"yii2tech/csv-grid";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:17:"@yii2tech/csvgrid";s:38:"/var/www/html/vendor/yii2tech/csv-grid";}}s:26:"yiisoft/yii2-elasticsearch";a:3:{s:4:"name";s:26:"yiisoft/yii2-elasticsearch";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:18:"@yii/elasticsearch";s:47:"/var/www/html/vendor/yiisoft/yii2-elasticsearch";}}s:16:"yiisoft/yii2-jui";a:3:{s:4:"name";s:16:"yiisoft/yii2-jui";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:8:"@yii/jui";s:37:"/var/www/html/vendor/yiisoft/yii2-jui";}}s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:45:"/var/www/html/vendor/yiisoft/yii2-swiftmailer";}}s:17:"yiisoft/yii2-twig";a:3:{s:4:"name";s:17:"yiisoft/yii2-twig";s:7:"version";s:7:"2.2.0.0";s:5:"alias";a:1:{s:9:"@yii/twig";s:38:"/var/www/html/vendor/yiisoft/yii2-twig";}}s:26:"zhelyabuzhsky/yii2-sitemap";a:3:{s:4:"name";s:26:"zhelyabuzhsky/yii2-sitemap";s:7:"version";s:7:"1.1.2.0";s:5:"alias";a:1:{s:22:"@zhelyabuzhsky/sitemap";s:51:"/var/www/html/vendor/zhelyabuzhsky/yii2-sitemap/src";}}s:32:"zhuravljov/yii2-datetime-widgets";a:3:{s:4:"name";s:32:"zhuravljov/yii2-datetime-widgets";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:19:"@zhuravljov/widgets";s:53:"/var/www/html/vendor/zhuravljov/yii2-datetime-widgets";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:10:"@yii/faker";s:39:"/var/www/html/vendor/yiisoft/yii2-faker";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:8:"@yii/gii";s:37:"/var/www/html/vendor/yiisoft/yii2-gii";}}s:20:"ofat/yii2-yashop-ses";a:3:{s:4:"name";s:20:"ofat/yii2-yashop-ses";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:11:"@yashop/ses";s:41:"/var/www/html/vendor/ofat/yii2-yashop-ses";}}s:22:"sima/robots-txt-parser";a:3:{s:4:"name";s:22:"sima/robots-txt-parser";s:7:"version";s:7:"1.2.1.0";s:5:"alias";a:1:{s:21:"@sima/robotstxtparser";s:47:"/var/www/html/vendor/sima/robots-txt-parser/src";}}s:19:"sima-land/yii2-amqp";a:3:{s:4:"name";s:19:"sima-land/yii2-amqp";s:7:"version";s:7:"0.3.0.0";s:5:"alias";a:1:{s:14:"@Simaland/Amqp";s:44:"/var/www/html/vendor/sima-land/yii2-amqp/src";}}s:23:"yiisoft/yii2-authclient";a:3:{s:4:"name";s:23:"yiisoft/yii2-authclient";s:7:"version";s:7:"2.2.3.0";s:5:"alias";a:1:{s:15:"@yii/authclient";s:48:"/var/www/html/vendor/yiisoft/yii2-authclient/src";}}s:22:"pastuhov/yii2-logstock";a:3:{s:4:"name";s:22:"pastuhov/yii2-logstock";s:7:"version";s:7:"5.0.0.0";s:5:"alias";a:1:{s:18:"@pastuhov/logstock";s:43:"/var/www/html/vendor/pastuhov/yii2-logstock";}}s:21:"yii2tech/file-storage";a:3:{s:4:"name";s:21:"yii2tech/file-storage";s:7:"version";s:7:"1.1.4.0";s:5:"alias";a:1:{s:21:"@yii2tech/filestorage";s:46:"/var/www/html/vendor/yii2tech/file-storage/src";}}}}s:7:"request";a:14:{s:7:"flashes";a:0:{}s:10:"statusCode";i:500;s:14:"requestHeaders";a:11:{s:12:"content-type";s:16:"application/json";s:13:"cache-control";s:8:"no-cache";s:13:"postman-token";s:36:"3ae29b51-e974-4057-afcc-707c3f588bff";s:13:"authorization";s:50:"Basic ZGVzMXJvZXJAZ21haWwuY29tOmNydW9ydnVsdDE0ODg=";s:10:"user-agent";s:20:"PostmanRuntime/7.6.0";s:6:"accept";s:3:"*/*";s:4:"host";s:21:"backend-sl.local:8020";s:6:"cookie";s:45:"NEWSIMALANDBACKEND=hl3uub4r4p60k52ug5g3sb8869";s:15:"accept-encoding";s:13:"gzip, deflate";s:14:"content-length";s:3:"127";s:10:"connection";s:10:"keep-alive";}s:15:"responseHeaders";a:5:{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:32:"Access-Control-Allow-Credentials";s:4:"true";s:12:"Content-Type";s:31:"application/json; charset=UTF-8";}s:5:"route";s:18:"api/v3/user/delete";s:6:"action";s:71:"common\modules\api\modules\v3\actions\DeleteWithValidationAction::run()";s:12:"actionParams";a:1:{i:0;s:6:"631860";}s:11:"requestBody";a:3:{s:12:"Content Type";s:16:"application/json";s:3:"Raw";s:127:"{ | |
"items": [ | |
{ | |
"item_sid": 100945 | |
}, | |
{ | |
"item_sid": 113884 | |
} | |
] | |
}";s:17:"Decoded to Params";a:1:{s:5:"items";a:2:{i:0;a:1:{s:8:"item_sid";i:100945;}i:1;a:1:{s:8:"item_sid";i:113884;}}}}s:6:"SERVER";a:37:{s:15:"REDIRECT_STATUS";s:3:"200";s:12:"CONTENT_TYPE";s:16:"application/json";s:18:"HTTP_CACHE_CONTROL";s:8:"no-cache";s:18:"HTTP_POSTMAN_TOKEN";s:36:"3ae29b51-e974-4057-afcc-707c3f588bff";s:15:"HTTP_USER_AGENT";s:20:"PostmanRuntime/7.6.0";s:11:"HTTP_ACCEPT";s:3:"*/*";s:9:"HTTP_HOST";s:21:"backend-sl.local:8020";s:11:"HTTP_COOKIE";s:45:"NEWSIMALANDBACKEND=hl3uub4r4p60k52ug5g3sb8869";s:20:"HTTP_ACCEPT_ENCODING";s:13:"gzip, deflate";s:14:"CONTENT_LENGTH";s:3:"127";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:4:"PATH";s:87:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/root/.composer/vendor/bin";s:16:"SERVER_SIGNATURE";s:0:"";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:11:"SERVER_NAME";s:16:"backend-sl.local";s:11:"SERVER_ADDR";s:10:"172.26.0.5";s:11:"SERVER_PORT";s:4:"8020";s:11:"REMOTE_ADDR";s:10:"172.26.0.1";s:13:"DOCUMENT_ROOT";s:25:"/var/www/html/backend/web";s:14:"REQUEST_SCHEME";s:4:"http";s:14:"CONTEXT_PREFIX";s:0:"";s:21:"CONTEXT_DOCUMENT_ROOT";s:25:"/var/www/html/backend/web";s:12:"SERVER_ADMIN";s:18:"[no address given]";s:15:"SCRIPT_FILENAME";s:35:"/var/www/html/backend/web/index.php";s:11:"REMOTE_PORT";s:5:"53980";s:12:"REDIRECT_URL";s:20:"/api/v3/user/631860/";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:6:"DELETE";s:12:"QUERY_STRING";s:0:"";s:11:"REQUEST_URI";s:20:"/api/v3/user/631860/";s:11:"SCRIPT_NAME";s:10:"/index.php";s:8:"PHP_SELF";s:10:"/index.php";s:13:"PHP_AUTH_USER";s:18:"des1roer@gmail.com";s:11:"PHP_AUTH_PW";s:13:"cruorvult1488";s:18:"REQUEST_TIME_FLOAT";d:1565238595.915;s:12:"REQUEST_TIME";i:1565238595;}s:3:"GET";a:1:{s:2:"id";s:6:"631860";}s:4:"POST";a:0:{}s:6:"COOKIE";a:1:{s:18:"NEWSIMALANDBACKEND";s:26:"hl3uub4r4p60k52ug5g3sb8869";}s:5:"FILES";a:0:{}s:7:"SESSION";a:2:{s:7:"__flash";a:0:{}s:4:"__id";i:631860;}}s:9:"profiling";a:3:{s:6:"memory";i:3955856;s:4:"time";d:0.07630085945129395;s:8:"messages";a:30:{i:14;a:6:{i:0;s:97:"Opening DB connection: pgsql:host=10.30.37.16;dbname=lebedev;application_name=lebedev-app-backend";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1565238595.923056;i:4;a:5:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;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:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2158536;}i:15;a:6:{i:0;s:97:"Opening DB connection: pgsql:host=10.30.37.16;dbname=lebedev;application_name=lebedev-app-backend";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1565238595.926497;i:4;a:5:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;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:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2161616;}i:16;a:6:{i:0;s:58:"SELECT * FROM "user" WHERE ("id"=631860) AND ("status"=10)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.926579;i:4;a:5:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;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:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2164112;}i:17;a:6:{i:0;s:58:"SELECT * FROM "user" WHERE ("id"=631860) AND ("status"=10)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.930996;i:4;a:5:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;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:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2182736;}i:21;a:6:{i:0;s:2524:"SELECT | |
d.nspname AS table_schema, | |
c.relname AS table_name, | |
a.attname AS column_name, | |
COALESCE(td.typname, tb.typname, t.typname) AS data_type, | |
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, | |
a.attlen AS character_maximum_length, | |
pg_catalog.col_description(c.oid, a.attnum) AS column_comment, | |
a.atttypmod AS modifier, | |
a.attnotnull = false AS is_nullable, | |
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, | |
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, | |
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char | |
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') | |
ELSE NULL | |
END AS enum_values, | |
CASE atttypid | |
WHEN 21 /*int2*/ THEN 16 | |
WHEN 23 /*int4*/ THEN 32 | |
WHEN 20 /*int8*/ THEN 64 | |
WHEN 1700 /*numeric*/ THEN | |
CASE WHEN atttypmod = -1 | |
THEN null | |
ELSE ((atttypmod - 4) >> 16) & 65535 | |
END | |
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ | |
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ | |
ELSE null | |
END AS numeric_precision, | |
CASE | |
WHEN atttypid IN (21, 23, 20) THEN 0 | |
WHEN atttypid IN (1700) THEN | |
CASE | |
WHEN atttypmod = -1 THEN null | |
ELSE (atttypmod - 4) & 65535 | |
END | |
ELSE null | |
END AS numeric_scale, | |
CAST( | |
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) | |
AS numeric | |
) AS size, | |
a.attnum = any (ct.conkey) as is_pkey, | |
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension | |
FROM | |
pg_class c | |
LEFT JOIN pg_attribute a ON a.attrelid = c.oid | |
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum | |
LEFT JOIN pg_type t ON a.atttypid = t.oid | |
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid | |
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid | |
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace | |
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' | |
WHERE | |
a.attnum > 0 AND t.typname != '' | |
AND c.relname = 'user' | |
AND d.nspname = 'web' | |
ORDER BY | |
a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.932833;i:4;a:7:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:5;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:6;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2346296;}i:22;a:6:{i:0;s:2524:"SELECT | |
d.nspname AS table_schema, | |
c.relname AS table_name, | |
a.attname AS column_name, | |
COALESCE(td.typname, tb.typname, t.typname) AS data_type, | |
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, | |
a.attlen AS character_maximum_length, | |
pg_catalog.col_description(c.oid, a.attnum) AS column_comment, | |
a.atttypmod AS modifier, | |
a.attnotnull = false AS is_nullable, | |
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, | |
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, | |
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char | |
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') | |
ELSE NULL | |
END AS enum_values, | |
CASE atttypid | |
WHEN 21 /*int2*/ THEN 16 | |
WHEN 23 /*int4*/ THEN 32 | |
WHEN 20 /*int8*/ THEN 64 | |
WHEN 1700 /*numeric*/ THEN | |
CASE WHEN atttypmod = -1 | |
THEN null | |
ELSE ((atttypmod - 4) >> 16) & 65535 | |
END | |
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ | |
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ | |
ELSE null | |
END AS numeric_precision, | |
CASE | |
WHEN atttypid IN (21, 23, 20) THEN 0 | |
WHEN atttypid IN (1700) THEN | |
CASE | |
WHEN atttypmod = -1 THEN null | |
ELSE (atttypmod - 4) & 65535 | |
END | |
ELSE null | |
END AS numeric_scale, | |
CAST( | |
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) | |
AS numeric | |
) AS size, | |
a.attnum = any (ct.conkey) as is_pkey, | |
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension | |
FROM | |
pg_class c | |
LEFT JOIN pg_attribute a ON a.attrelid = c.oid | |
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum | |
LEFT JOIN pg_type t ON a.atttypid = t.oid | |
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid | |
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid | |
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace | |
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' | |
WHERE | |
a.attnum > 0 AND t.typname != '' | |
AND c.relname = 'user' | |
AND d.nspname = 'web' | |
ORDER BY | |
a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.946235;i:4;a:7:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:5;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:6;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2466120;}i:24;a:6:{i:0;s:869:"select | |
ct.conname as constraint_name, | |
a.attname as column_name, | |
fc.relname as foreign_table_name, | |
fns.nspname as foreign_table_schema, | |
fa.attname as foreign_column_name | |
from | |
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s | |
FROM pg_constraint ct | |
) AS ct | |
inner join pg_class c on c.oid=ct.conrelid | |
inner join pg_namespace ns on c.relnamespace=ns.oid | |
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] | |
left join pg_class fc on fc.oid=ct.confrelid | |
left join pg_namespace fns on fc.relnamespace=fns.oid | |
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] | |
where | |
ct.contype='f' | |
and c.relname='user' | |
and ns.nspname='web' | |
order by | |
fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.94826;i:4;a:7:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:5;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:6;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2402696;}i:25;a:6:{i:0;s:869:"select | |
ct.conname as constraint_name, | |
a.attname as column_name, | |
fc.relname as foreign_table_name, | |
fns.nspname as foreign_table_schema, | |
fa.attname as foreign_column_name | |
from | |
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s | |
FROM pg_constraint ct | |
) AS ct | |
inner join pg_class c on c.oid=ct.conrelid | |
inner join pg_namespace ns on c.relnamespace=ns.oid | |
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] | |
left join pg_class fc on fc.oid=ct.confrelid | |
left join pg_namespace fns on fc.relnamespace=fns.oid | |
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] | |
where | |
ct.contype='f' | |
and c.relname='user' | |
and ns.nspname='web' | |
order by | |
fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.953542;i:4;a:7:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:5;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:6;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2410368;}i:35;a:6:{i:0;s:2531:"SELECT | |
d.nspname AS table_schema, | |
c.relname AS table_name, | |
a.attname AS column_name, | |
COALESCE(td.typname, tb.typname, t.typname) AS data_type, | |
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, | |
a.attlen AS character_maximum_length, | |
pg_catalog.col_description(c.oid, a.attnum) AS column_comment, | |
a.atttypmod AS modifier, | |
a.attnotnull = false AS is_nullable, | |
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, | |
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, | |
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char | |
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') | |
ELSE NULL | |
END AS enum_values, | |
CASE atttypid | |
WHEN 21 /*int2*/ THEN 16 | |
WHEN 23 /*int4*/ THEN 32 | |
WHEN 20 /*int8*/ THEN 64 | |
WHEN 1700 /*numeric*/ THEN | |
CASE WHEN atttypmod = -1 | |
THEN null | |
ELSE ((atttypmod - 4) >> 16) & 65535 | |
END | |
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ | |
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ | |
ELSE null | |
END AS numeric_precision, | |
CASE | |
WHEN atttypid IN (21, 23, 20) THEN 0 | |
WHEN atttypid IN (1700) THEN | |
CASE | |
WHEN atttypmod = -1 THEN null | |
ELSE (atttypmod - 4) & 65535 | |
END | |
ELSE null | |
END AS numeric_scale, | |
CAST( | |
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) | |
AS numeric | |
) AS size, | |
a.attnum = any (ct.conkey) as is_pkey, | |
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension | |
FROM | |
pg_class c | |
LEFT JOIN pg_attribute a ON a.attrelid = c.oid | |
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum | |
LEFT JOIN pg_type t ON a.atttypid = t.oid | |
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid | |
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid | |
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace | |
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' | |
WHERE | |
a.attnum > 0 AND t.typname != '' | |
AND c.relname = 'audit_entry' | |
AND d.nspname = 'web' | |
ORDER BY | |
a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.957601;i:4;a:3:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:54:"/var/www/html/vendor/bedezign/yii2-audit/src/Audit.php";s:4:"line";i:213;s:8:"function";s:14:"getTableSchema";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}}i:5;i:2743064;}i:36;a:6:{i:0;s:2531:"SELECT | |
d.nspname AS table_schema, | |
c.relname AS table_name, | |
a.attname AS column_name, | |
COALESCE(td.typname, tb.typname, t.typname) AS data_type, | |
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, | |
a.attlen AS character_maximum_length, | |
pg_catalog.col_description(c.oid, a.attnum) AS column_comment, | |
a.atttypmod AS modifier, | |
a.attnotnull = false AS is_nullable, | |
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, | |
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, | |
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char | |
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') | |
ELSE NULL | |
END AS enum_values, | |
CASE atttypid | |
WHEN 21 /*int2*/ THEN 16 | |
WHEN 23 /*int4*/ THEN 32 | |
WHEN 20 /*int8*/ THEN 64 | |
WHEN 1700 /*numeric*/ THEN | |
CASE WHEN atttypmod = -1 | |
THEN null | |
ELSE ((atttypmod - 4) >> 16) & 65535 | |
END | |
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ | |
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ | |
ELSE null | |
END AS numeric_precision, | |
CASE | |
WHEN atttypid IN (21, 23, 20) THEN 0 | |
WHEN atttypid IN (1700) THEN | |
CASE | |
WHEN atttypmod = -1 THEN null | |
ELSE (atttypmod - 4) & 65535 | |
END | |
ELSE null | |
END AS numeric_scale, | |
CAST( | |
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) | |
AS numeric | |
) AS size, | |
a.attnum = any (ct.conkey) as is_pkey, | |
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension | |
FROM | |
pg_class c | |
LEFT JOIN pg_attribute a ON a.attrelid = c.oid | |
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum | |
LEFT JOIN pg_type t ON a.atttypid = t.oid | |
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid | |
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid | |
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace | |
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' | |
WHERE | |
a.attnum > 0 AND t.typname != '' | |
AND c.relname = 'audit_entry' | |
AND d.nspname = 'web' | |
ORDER BY | |
a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.963291;i:4;a:3:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:54:"/var/www/html/vendor/bedezign/yii2-audit/src/Audit.php";s:4:"line";i:213;s:8:"function";s:14:"getTableSchema";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}}i:5;i:2760888;}i:38;a:6:{i:0;s:876:"select | |
ct.conname as constraint_name, | |
a.attname as column_name, | |
fc.relname as foreign_table_name, | |
fns.nspname as foreign_table_schema, | |
fa.attname as foreign_column_name | |
from | |
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s | |
FROM pg_constraint ct | |
) AS ct | |
inner join pg_class c on c.oid=ct.conrelid | |
inner join pg_namespace ns on c.relnamespace=ns.oid | |
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] | |
left join pg_class fc on fc.oid=ct.confrelid | |
left join pg_namespace fns on fc.relnamespace=fns.oid | |
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] | |
where | |
ct.contype='f' | |
and c.relname='audit_entry' | |
and ns.nspname='web' | |
order by | |
fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.963909;i:4;a:3:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:54:"/var/www/html/vendor/bedezign/yii2-audit/src/Audit.php";s:4:"line";i:213;s:8:"function";s:14:"getTableSchema";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}}i:5;i:2750112;}i:39;a:6:{i:0;s:876:"select | |
ct.conname as constraint_name, | |
a.attname as column_name, | |
fc.relname as foreign_table_name, | |
fns.nspname as foreign_table_schema, | |
fa.attname as foreign_column_name | |
from | |
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s | |
FROM pg_constraint ct | |
) AS ct | |
inner join pg_class c on c.oid=ct.conrelid | |
inner join pg_namespace ns on c.relnamespace=ns.oid | |
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] | |
left join pg_class fc on fc.oid=ct.confrelid | |
left join pg_namespace fns on fc.relnamespace=fns.oid | |
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] | |
where | |
ct.contype='f' | |
and c.relname='audit_entry' | |
and ns.nspname='web' | |
order by | |
fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.967722;i:4;a:3:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:54:"/var/www/html/vendor/bedezign/yii2-audit/src/Audit.php";s:4:"line";i:213;s:8:"function";s:14:"getTableSchema";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}}i:5;i:2752496;}i:55;a:6:{i:0;s:10:"Page Cache";i:1;i:80;i:2;s:41:"common\components\PageCache::beforeAction";i:3;d:1565238595.971007;i:4;a:1:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/PageCache.php";s:4:"line";i:38;s:8:"function";s:12:"beginProfile";s:5:"class";s:11:"yii\BaseYii";s:4:"type";s:2:"::";}}i:5;i:3066800;}i:56;a:6:{i:0;s:10:"Page Cache";i:1;i:96;i:2;s:41:"common\components\PageCache::beforeAction";i:3;d:1565238595.971024;i:4;a:1:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/PageCache.php";s:4:"line";i:40;s:8:"function";s:10:"endProfile";s:5:"class";s:11:"yii\BaseYii";s:4:"type";s:2:"::";}}i:5;i:3067928;}i:58;a:6:{i:0;s:56:"SELECT * FROM "auth_assignment" WHERE "user_id"='631860'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.97172;i:4;a:4:{i:0;a:5:{s:4:"file";s:46:"/var/www/html/backend/components/DbManager.php";s:4:"line";i:27;s:8:"function";s:14:"getAssignments";s:5:"class";s:18:"yii\rbac\DbManager";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/var/www/html/vendor/mdmsoft/yii2-admin/components/Helper.php";s:4:"line";i:119;s:8:"function";s:3:"can";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:68:"/var/www/html/vendor/mdmsoft/yii2-admin/components/AccessControl.php";s:4:"line";i:70;s:8:"function";s:10:"checkRoute";s:5:"class";s:27:"mdm\admin\components\Helper";s:4:"type";s:2:"::";}i:3;a:5:{s:4:"file";s:62:"/var/www/html/backend/modules/api/modules/v3/AccessControl.php";s:4:"line";i:39;s:8:"function";s:12:"beforeAction";s:5:"class";s:34:"mdm\admin\components\AccessControl";s:4:"type";s:2:"->";}}i:5;i:3129584;}i:59;a:6:{i:0;s:56:"SELECT * FROM "auth_assignment" WHERE "user_id"='631860'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.973176;i:4;a:4:{i:0;a:5:{s:4:"file";s:46:"/var/www/html/backend/components/DbManager.php";s:4:"line";i:27;s:8:"function";s:14:"getAssignments";s:5:"class";s:18:"yii\rbac\DbManager";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/var/www/html/vendor/mdmsoft/yii2-admin/components/Helper.php";s:4:"line";i:119;s:8:"function";s:3:"can";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:68:"/var/www/html/vendor/mdmsoft/yii2-admin/components/AccessControl.php";s:4:"line";i:70;s:8:"function";s:10:"checkRoute";s:5:"class";s:27:"mdm\admin\components\Helper";s:4:"type";s:2:"::";}i:3;a:5:{s:4:"file";s:62:"/var/www/html/backend/modules/api/modules/v3/AccessControl.php";s:4:"line";i:39;s:8:"function";s:12:"beforeAction";s:5:"class";s:34:"mdm\admin\components\AccessControl";s:4:"type";s:2:"->";}}i:5;i:3132936;}i:68;a:6:{i:0;s:38:"SELECT * FROM "user" WHERE "id"=631860";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.974651;i:4;a:5:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:236;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:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:70:"/var/www/html/common/modules/api/modules/v3/controllers/Controller.php";s:4:"line";i:258;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:3;a:5:{s:4:"file";s:75:"/var/www/html/backend/modules/api/modules/v3/controllers/UserController.php";s:4:"line";i:64;s:8:"function";s:9:"findModel";s:5:"class";s:52:"common\modules\api\modules\v3\controllers\Controller";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:82:"/var/www/html/common/modules/api/modules/v3/actions/DeleteWithValidationAction.php";s:4:"line";i:36;s:8:"function";s:9:"findModel";s:5:"class";s:15:"yii\rest\Action";s:4:"type";s:2:"->";}}i:5;i:3434184;}i:69;a:6:{i:0;s:38:"SELECT * FROM "user" WHERE "id"=631860";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.975799;i:4;a:5:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:236;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:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:70:"/var/www/html/common/modules/api/modules/v3/controllers/Controller.php";s:4:"line";i:258;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:3;a:5:{s:4:"file";s:75:"/var/www/html/backend/modules/api/modules/v3/controllers/UserController.php";s:4:"line";i:64;s:8:"function";s:9:"findModel";s:5:"class";s:52:"common\modules\api\modules\v3\controllers\Controller";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:82:"/var/www/html/common/modules/api/modules/v3/actions/DeleteWithValidationAction.php";s:4:"line";i:36;s:8:"function";s:9:"findModel";s:5:"class";s:15:"yii\rest\Action";s:4:"type";s:2:"->";}}i:5;i:3452096;}i:71;a:6:{i:0;s:91:"SELECT "settlement_osm_id" FROM "osm_setllement_conformity" WHERE "settlement_id"=359535254";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.979291;i:4;a:3:{i:0;a:5:{s:4:"file";s:67:"/var/www/html/common/components/behaviors/OsmSettlementBehavior.php";s:4:"line";i:46;s:8:"function";s:6:"scalar";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/common/models/UploadFileModel.php";s:4:"line";i:337;s:8:"function";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:82:"/var/www/html/common/modules/api/modules/v3/actions/DeleteWithValidationAction.php";s:4:"line";i:43;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:3624088;}i:72;a:6:{i:0;s:91:"SELECT "settlement_osm_id" FROM "osm_setllement_conformity" WHERE "settlement_id"=359535254";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.980381;i:4;a:3:{i:0;a:5:{s:4:"file";s:67:"/var/www/html/common/components/behaviors/OsmSettlementBehavior.php";s:4:"line";i:46;s:8:"function";s:6:"scalar";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/common/models/UploadFileModel.php";s:4:"line";i:337;s:8:"function";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:82:"/var/www/html/common/modules/api/modules/v3/actions/DeleteWithValidationAction.php";s:4:"line";i:43;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:3626136;}i:75;a:6:{i:0;s:139:"SELECT "b".* FROM "auth_assignment" "a", "auth_item" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='631860') AND ("b"."type"=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.983069;i:4;a:0:{}i:5;i:3742840;}i:76;a:6:{i:0;s:139:"SELECT "b".* FROM "auth_assignment" "a", "auth_item" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='631860') AND ("b"."type"=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.984681;i:4;a:0:{}i:5;i:3744728;}i:78;a:6:{i:0;s:139:"SELECT "b".* FROM "auth_assignment" "a", "auth_item" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='631860') AND ("b"."type"=2)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.98537;i:4;a:0:{}i:5;i:3754368;}i:79;a:6:{i:0;s:139:"SELECT "b".* FROM "auth_assignment" "a", "auth_item" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='631860') AND ("b"."type"=2)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.986429;i:4;a:0:{}i:5;i:3755488;}i:81;a:6:{i:0;s:31:"SELECT * FROM "auth_item_child"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.986802;i:4;a:0:{}i:5;i:3753248;}i:82;a:6:{i:0;s:31:"SELECT * FROM "auth_item_child"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.987696;i:4;a:0:{}i:5;i:3848648;}i:84;a:6:{i:0;s:66:"SELECT "item_name" FROM "auth_assignment" WHERE "user_id"='631860'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.988109;i:4;a:0:{}i:5;i:3785776;}i:85;a:6:{i:0;s:66:"SELECT "item_name" FROM "auth_assignment" WHERE "user_id"='631860'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.988828;i:4;a:0:{}i:5;i:3786680;}i:87;a:6:{i:0;s:60:"SELECT * FROM "auth_item" WHERE ("type"=2) AND ("name"='/*')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.989317;i:4;a:0:{}i:5;i:3789200;}i:88;a:6:{i:0;s:60:"SELECT * FROM "auth_item" WHERE ("type"=2) AND ("name"='/*')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.990128;i:4;a:0:{}i:5;i:3791048;}}}s:2:"db";a:1:{s:8:"messages";a:26:{i:16;a:6:{i:0;s:58:"SELECT * FROM "user" WHERE ("id"=631860) AND ("status"=10)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.926579;i:4;a:5:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;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:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2164112;}i:17;a:6:{i:0;s:58:"SELECT * FROM "user" WHERE ("id"=631860) AND ("status"=10)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.930996;i:4;a:5:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;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:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2182736;}i:21;a:6:{i:0;s:2524:"SELECT | |
d.nspname AS table_schema, | |
c.relname AS table_name, | |
a.attname AS column_name, | |
COALESCE(td.typname, tb.typname, t.typname) AS data_type, | |
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, | |
a.attlen AS character_maximum_length, | |
pg_catalog.col_description(c.oid, a.attnum) AS column_comment, | |
a.atttypmod AS modifier, | |
a.attnotnull = false AS is_nullable, | |
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, | |
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, | |
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char | |
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') | |
ELSE NULL | |
END AS enum_values, | |
CASE atttypid | |
WHEN 21 /*int2*/ THEN 16 | |
WHEN 23 /*int4*/ THEN 32 | |
WHEN 20 /*int8*/ THEN 64 | |
WHEN 1700 /*numeric*/ THEN | |
CASE WHEN atttypmod = -1 | |
THEN null | |
ELSE ((atttypmod - 4) >> 16) & 65535 | |
END | |
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ | |
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ | |
ELSE null | |
END AS numeric_precision, | |
CASE | |
WHEN atttypid IN (21, 23, 20) THEN 0 | |
WHEN atttypid IN (1700) THEN | |
CASE | |
WHEN atttypmod = -1 THEN null | |
ELSE (atttypmod - 4) & 65535 | |
END | |
ELSE null | |
END AS numeric_scale, | |
CAST( | |
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) | |
AS numeric | |
) AS size, | |
a.attnum = any (ct.conkey) as is_pkey, | |
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension | |
FROM | |
pg_class c | |
LEFT JOIN pg_attribute a ON a.attrelid = c.oid | |
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum | |
LEFT JOIN pg_type t ON a.atttypid = t.oid | |
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid | |
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid | |
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace | |
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' | |
WHERE | |
a.attnum > 0 AND t.typname != '' | |
AND c.relname = 'user' | |
AND d.nspname = 'web' | |
ORDER BY | |
a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.932833;i:4;a:7:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:5;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:6;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2346296;}i:22;a:6:{i:0;s:2524:"SELECT | |
d.nspname AS table_schema, | |
c.relname AS table_name, | |
a.attname AS column_name, | |
COALESCE(td.typname, tb.typname, t.typname) AS data_type, | |
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, | |
a.attlen AS character_maximum_length, | |
pg_catalog.col_description(c.oid, a.attnum) AS column_comment, | |
a.atttypmod AS modifier, | |
a.attnotnull = false AS is_nullable, | |
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, | |
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, | |
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char | |
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') | |
ELSE NULL | |
END AS enum_values, | |
CASE atttypid | |
WHEN 21 /*int2*/ THEN 16 | |
WHEN 23 /*int4*/ THEN 32 | |
WHEN 20 /*int8*/ THEN 64 | |
WHEN 1700 /*numeric*/ THEN | |
CASE WHEN atttypmod = -1 | |
THEN null | |
ELSE ((atttypmod - 4) >> 16) & 65535 | |
END | |
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ | |
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ | |
ELSE null | |
END AS numeric_precision, | |
CASE | |
WHEN atttypid IN (21, 23, 20) THEN 0 | |
WHEN atttypid IN (1700) THEN | |
CASE | |
WHEN atttypmod = -1 THEN null | |
ELSE (atttypmod - 4) & 65535 | |
END | |
ELSE null | |
END AS numeric_scale, | |
CAST( | |
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) | |
AS numeric | |
) AS size, | |
a.attnum = any (ct.conkey) as is_pkey, | |
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension | |
FROM | |
pg_class c | |
LEFT JOIN pg_attribute a ON a.attrelid = c.oid | |
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum | |
LEFT JOIN pg_type t ON a.atttypid = t.oid | |
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid | |
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid | |
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace | |
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' | |
WHERE | |
a.attnum > 0 AND t.typname != '' | |
AND c.relname = 'user' | |
AND d.nspname = 'web' | |
ORDER BY | |
a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.946235;i:4;a:7:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:5;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:6;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2466120;}i:24;a:6:{i:0;s:869:"select | |
ct.conname as constraint_name, | |
a.attname as column_name, | |
fc.relname as foreign_table_name, | |
fns.nspname as foreign_table_schema, | |
fa.attname as foreign_column_name | |
from | |
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s | |
FROM pg_constraint ct | |
) AS ct | |
inner join pg_class c on c.oid=ct.conrelid | |
inner join pg_namespace ns on c.relnamespace=ns.oid | |
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] | |
left join pg_class fc on fc.oid=ct.confrelid | |
left join pg_namespace fns on fc.relnamespace=fns.oid | |
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] | |
where | |
ct.contype='f' | |
and c.relname='user' | |
and ns.nspname='web' | |
order by | |
fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.94826;i:4;a:7:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:5;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:6;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2402696;}i:25;a:6:{i:0;s:869:"select | |
ct.conname as constraint_name, | |
a.attname as column_name, | |
fc.relname as foreign_table_name, | |
fns.nspname as foreign_table_schema, | |
fa.attname as foreign_column_name | |
from | |
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s | |
FROM pg_constraint ct | |
) AS ct | |
inner join pg_class c on c.oid=ct.conrelid | |
inner join pg_namespace ns on c.relnamespace=ns.oid | |
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] | |
left join pg_class fc on fc.oid=ct.confrelid | |
left join pg_namespace fns on fc.relnamespace=fns.oid | |
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] | |
where | |
ct.contype='f' | |
and c.relname='user' | |
and ns.nspname='web' | |
order by | |
fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.953542;i:4;a:7:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:5;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:6;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2410368;}i:35;a:6:{i:0;s:2531:"SELECT | |
d.nspname AS table_schema, | |
c.relname AS table_name, | |
a.attname AS column_name, | |
COALESCE(td.typname, tb.typname, t.typname) AS data_type, | |
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, | |
a.attlen AS character_maximum_length, | |
pg_catalog.col_description(c.oid, a.attnum) AS column_comment, | |
a.atttypmod AS modifier, | |
a.attnotnull = false AS is_nullable, | |
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, | |
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, | |
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char | |
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') | |
ELSE NULL | |
END AS enum_values, | |
CASE atttypid | |
WHEN 21 /*int2*/ THEN 16 | |
WHEN 23 /*int4*/ THEN 32 | |
WHEN 20 /*int8*/ THEN 64 | |
WHEN 1700 /*numeric*/ THEN | |
CASE WHEN atttypmod = -1 | |
THEN null | |
ELSE ((atttypmod - 4) >> 16) & 65535 | |
END | |
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ | |
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ | |
ELSE null | |
END AS numeric_precision, | |
CASE | |
WHEN atttypid IN (21, 23, 20) THEN 0 | |
WHEN atttypid IN (1700) THEN | |
CASE | |
WHEN atttypmod = -1 THEN null | |
ELSE (atttypmod - 4) & 65535 | |
END | |
ELSE null | |
END AS numeric_scale, | |
CAST( | |
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) | |
AS numeric | |
) AS size, | |
a.attnum = any (ct.conkey) as is_pkey, | |
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension | |
FROM | |
pg_class c | |
LEFT JOIN pg_attribute a ON a.attrelid = c.oid | |
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum | |
LEFT JOIN pg_type t ON a.atttypid = t.oid | |
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid | |
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid | |
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace | |
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' | |
WHERE | |
a.attnum > 0 AND t.typname != '' | |
AND c.relname = 'audit_entry' | |
AND d.nspname = 'web' | |
ORDER BY | |
a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.957601;i:4;a:3:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:54:"/var/www/html/vendor/bedezign/yii2-audit/src/Audit.php";s:4:"line";i:213;s:8:"function";s:14:"getTableSchema";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}}i:5;i:2743064;}i:36;a:6:{i:0;s:2531:"SELECT | |
d.nspname AS table_schema, | |
c.relname AS table_name, | |
a.attname AS column_name, | |
COALESCE(td.typname, tb.typname, t.typname) AS data_type, | |
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, | |
a.attlen AS character_maximum_length, | |
pg_catalog.col_description(c.oid, a.attnum) AS column_comment, | |
a.atttypmod AS modifier, | |
a.attnotnull = false AS is_nullable, | |
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, | |
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, | |
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char | |
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') | |
ELSE NULL | |
END AS enum_values, | |
CASE atttypid | |
WHEN 21 /*int2*/ THEN 16 | |
WHEN 23 /*int4*/ THEN 32 | |
WHEN 20 /*int8*/ THEN 64 | |
WHEN 1700 /*numeric*/ THEN | |
CASE WHEN atttypmod = -1 | |
THEN null | |
ELSE ((atttypmod - 4) >> 16) & 65535 | |
END | |
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ | |
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ | |
ELSE null | |
END AS numeric_precision, | |
CASE | |
WHEN atttypid IN (21, 23, 20) THEN 0 | |
WHEN atttypid IN (1700) THEN | |
CASE | |
WHEN atttypmod = -1 THEN null | |
ELSE (atttypmod - 4) & 65535 | |
END | |
ELSE null | |
END AS numeric_scale, | |
CAST( | |
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) | |
AS numeric | |
) AS size, | |
a.attnum = any (ct.conkey) as is_pkey, | |
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension | |
FROM | |
pg_class c | |
LEFT JOIN pg_attribute a ON a.attrelid = c.oid | |
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum | |
LEFT JOIN pg_type t ON a.atttypid = t.oid | |
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid | |
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid | |
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace | |
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' | |
WHERE | |
a.attnum > 0 AND t.typname != '' | |
AND c.relname = 'audit_entry' | |
AND d.nspname = 'web' | |
ORDER BY | |
a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.963291;i:4;a:3:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:54:"/var/www/html/vendor/bedezign/yii2-audit/src/Audit.php";s:4:"line";i:213;s:8:"function";s:14:"getTableSchema";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}}i:5;i:2760888;}i:38;a:6:{i:0;s:876:"select | |
ct.conname as constraint_name, | |
a.attname as column_name, | |
fc.relname as foreign_table_name, | |
fns.nspname as foreign_table_schema, | |
fa.attname as foreign_column_name | |
from | |
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s | |
FROM pg_constraint ct | |
) AS ct | |
inner join pg_class c on c.oid=ct.conrelid | |
inner join pg_namespace ns on c.relnamespace=ns.oid | |
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] | |
left join pg_class fc on fc.oid=ct.confrelid | |
left join pg_namespace fns on fc.relnamespace=fns.oid | |
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] | |
where | |
ct.contype='f' | |
and c.relname='audit_entry' | |
and ns.nspname='web' | |
order by | |
fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.963909;i:4;a:3:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:54:"/var/www/html/vendor/bedezign/yii2-audit/src/Audit.php";s:4:"line";i:213;s:8:"function";s:14:"getTableSchema";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}}i:5;i:2750112;}i:39;a:6:{i:0;s:876:"select | |
ct.conname as constraint_name, | |
a.attname as column_name, | |
fc.relname as foreign_table_name, | |
fns.nspname as foreign_table_schema, | |
fa.attname as foreign_column_name | |
from | |
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s | |
FROM pg_constraint ct | |
) AS ct | |
inner join pg_class c on c.oid=ct.conrelid | |
inner join pg_namespace ns on c.relnamespace=ns.oid | |
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] | |
left join pg_class fc on fc.oid=ct.confrelid | |
left join pg_namespace fns on fc.relnamespace=fns.oid | |
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] | |
where | |
ct.contype='f' | |
and c.relname='audit_entry' | |
and ns.nspname='web' | |
order by | |
fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.967722;i:4;a:3:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:54:"/var/www/html/vendor/bedezign/yii2-audit/src/Audit.php";s:4:"line";i:213;s:8:"function";s:14:"getTableSchema";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}}i:5;i:2752496;}i:58;a:6:{i:0;s:56:"SELECT * FROM "auth_assignment" WHERE "user_id"='631860'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.97172;i:4;a:4:{i:0;a:5:{s:4:"file";s:46:"/var/www/html/backend/components/DbManager.php";s:4:"line";i:27;s:8:"function";s:14:"getAssignments";s:5:"class";s:18:"yii\rbac\DbManager";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/var/www/html/vendor/mdmsoft/yii2-admin/components/Helper.php";s:4:"line";i:119;s:8:"function";s:3:"can";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:68:"/var/www/html/vendor/mdmsoft/yii2-admin/components/AccessControl.php";s:4:"line";i:70;s:8:"function";s:10:"checkRoute";s:5:"class";s:27:"mdm\admin\components\Helper";s:4:"type";s:2:"::";}i:3;a:5:{s:4:"file";s:62:"/var/www/html/backend/modules/api/modules/v3/AccessControl.php";s:4:"line";i:39;s:8:"function";s:12:"beforeAction";s:5:"class";s:34:"mdm\admin\components\AccessControl";s:4:"type";s:2:"->";}}i:5;i:3129584;}i:59;a:6:{i:0;s:56:"SELECT * FROM "auth_assignment" WHERE "user_id"='631860'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.973176;i:4;a:4:{i:0;a:5:{s:4:"file";s:46:"/var/www/html/backend/components/DbManager.php";s:4:"line";i:27;s:8:"function";s:14:"getAssignments";s:5:"class";s:18:"yii\rbac\DbManager";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/var/www/html/vendor/mdmsoft/yii2-admin/components/Helper.php";s:4:"line";i:119;s:8:"function";s:3:"can";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:68:"/var/www/html/vendor/mdmsoft/yii2-admin/components/AccessControl.php";s:4:"line";i:70;s:8:"function";s:10:"checkRoute";s:5:"class";s:27:"mdm\admin\components\Helper";s:4:"type";s:2:"::";}i:3;a:5:{s:4:"file";s:62:"/var/www/html/backend/modules/api/modules/v3/AccessControl.php";s:4:"line";i:39;s:8:"function";s:12:"beforeAction";s:5:"class";s:34:"mdm\admin\components\AccessControl";s:4:"type";s:2:"->";}}i:5;i:3132936;}i:68;a:6:{i:0;s:38:"SELECT * FROM "user" WHERE "id"=631860";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.974651;i:4;a:5:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:236;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:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:70:"/var/www/html/common/modules/api/modules/v3/controllers/Controller.php";s:4:"line";i:258;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:3;a:5:{s:4:"file";s:75:"/var/www/html/backend/modules/api/modules/v3/controllers/UserController.php";s:4:"line";i:64;s:8:"function";s:9:"findModel";s:5:"class";s:52:"common\modules\api\modules\v3\controllers\Controller";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:82:"/var/www/html/common/modules/api/modules/v3/actions/DeleteWithValidationAction.php";s:4:"line";i:36;s:8:"function";s:9:"findModel";s:5:"class";s:15:"yii\rest\Action";s:4:"type";s:2:"->";}}i:5;i:3434184;}i:69;a:6:{i:0;s:38:"SELECT * FROM "user" WHERE "id"=631860";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.975799;i:4;a:5:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:236;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:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:70:"/var/www/html/common/modules/api/modules/v3/controllers/Controller.php";s:4:"line";i:258;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:3;a:5:{s:4:"file";s:75:"/var/www/html/backend/modules/api/modules/v3/controllers/UserController.php";s:4:"line";i:64;s:8:"function";s:9:"findModel";s:5:"class";s:52:"common\modules\api\modules\v3\controllers\Controller";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:82:"/var/www/html/common/modules/api/modules/v3/actions/DeleteWithValidationAction.php";s:4:"line";i:36;s:8:"function";s:9:"findModel";s:5:"class";s:15:"yii\rest\Action";s:4:"type";s:2:"->";}}i:5;i:3452096;}i:71;a:6:{i:0;s:91:"SELECT "settlement_osm_id" FROM "osm_setllement_conformity" WHERE "settlement_id"=359535254";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.979291;i:4;a:3:{i:0;a:5:{s:4:"file";s:67:"/var/www/html/common/components/behaviors/OsmSettlementBehavior.php";s:4:"line";i:46;s:8:"function";s:6:"scalar";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/common/models/UploadFileModel.php";s:4:"line";i:337;s:8:"function";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:82:"/var/www/html/common/modules/api/modules/v3/actions/DeleteWithValidationAction.php";s:4:"line";i:43;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:3624088;}i:72;a:6:{i:0;s:91:"SELECT "settlement_osm_id" FROM "osm_setllement_conformity" WHERE "settlement_id"=359535254";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.980381;i:4;a:3:{i:0;a:5:{s:4:"file";s:67:"/var/www/html/common/components/behaviors/OsmSettlementBehavior.php";s:4:"line";i:46;s:8:"function";s:6:"scalar";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/common/models/UploadFileModel.php";s:4:"line";i:337;s:8:"function";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:82:"/var/www/html/common/modules/api/modules/v3/actions/DeleteWithValidationAction.php";s:4:"line";i:43;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:3626136;}i:75;a:6:{i:0;s:139:"SELECT "b".* FROM "auth_assignment" "a", "auth_item" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='631860') AND ("b"."type"=1)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.983069;i:4;a:0:{}i:5;i:3742840;}i:76;a:6:{i:0;s:139:"SELECT "b".* FROM "auth_assignment" "a", "auth_item" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='631860') AND ("b"."type"=1)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.984681;i:4;a:0:{}i:5;i:3744728;}i:78;a:6:{i:0;s:139:"SELECT "b".* FROM "auth_assignment" "a", "auth_item" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='631860') AND ("b"."type"=2)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.98537;i:4;a:0:{}i:5;i:3754368;}i:79;a:6:{i:0;s:139:"SELECT "b".* FROM "auth_assignment" "a", "auth_item" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='631860') AND ("b"."type"=2)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.986429;i:4;a:0:{}i:5;i:3755488;}i:81;a:6:{i:0;s:31:"SELECT * FROM "auth_item_child"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.986802;i:4;a:0:{}i:5;i:3753248;}i:82;a:6:{i:0;s:31:"SELECT * FROM "auth_item_child"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.987696;i:4;a:0:{}i:5;i:3848648;}i:84;a:6:{i:0;s:66:"SELECT "item_name" FROM "auth_assignment" WHERE "user_id"='631860'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.988109;i:4;a:0:{}i:5;i:3785776;}i:85;a:6:{i:0;s:66:"SELECT "item_name" FROM "auth_assignment" WHERE "user_id"='631860'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.988828;i:4;a:0:{}i:5;i:3786680;}i:87;a:6:{i:0;s:60:"SELECT * FROM "auth_item" WHERE ("type"=2) AND ("name"='/*')";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.989317;i:4;a:0:{}i:5;i:3789200;}i:88;a:6:{i:0;s:60:"SELECT * FROM "auth_item" WHERE ("type"=2) AND ("name"='/*')";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.990128;i:4;a:0:{}i:5;i:3791048;}}}s:6:"assets";a:0:{}s:4:"mail";a:0:{}s:8:"timeline";a:3:{s:5:"start";d:1565238595.916213;s:3:"end";d:1565238595.992568;s:6:"memory";i:3955856;}s:4:"user";a:4:{s:8:"identity";a:68:{s:2:"id";i:631860;s:4:"name";s:55:"test test test test test test test test test test test ";s:8:"auth_key";s:32:"5ey2G4yagIvhHr_Hjl_NAUGLi9UBKvyX";s:13:"password_hash";s:60:"$2y$13$QoIbkLNTjAnOgNJUTOn6B./xTPXHBdyqdhI8h1nRmBvPe4OJLDcrS";s:20:"password_reset_token";s:43:"uPfy1iNxZJ_fnjA9rOzKCb3kSg3KVxtm_1563875338";s:5:"email";s:18:"des1roer@gmail.com";s:5:"phone";s:11:"79617780298";s:13:"settlement_id";i:359535254;s:10:"manager_id";i:1910;s:6:"status";i:10;s:10:"birth_date";N;s:28:"is_subscribed_for_newsletter";i:1;s:29:"is_subscribed_on_order_status";N;s:10:"created_at";s:22:"2017-05-18 17:34:51+05";s:10:"updated_at";s:22:"2019-08-08 09:20:33+05";s:10:"google_cid";s:27:"GA1.2.1377152917.1563372473";s:11:"district_id";N;s:9:"rr_cookie";s:0:"";s:13:"rr_updated_at";s:29:"2017-12-08 16:13:15.304294+05";s:6:"source";N;s:2:"ip";s:13:"85.235.55.225";s:13:"last_visit_at";s:29:"2019-08-08 09:14:57.101165+05";s:12:"mobile_phone";s:12:"+79617780298";s:16:"is_checks_hidden";N;s:28:"is_able_to_download_preorder";N;s:13:"is_competitor";N;s:15:"is_perm_balance";i:0;s:21:"has_not_erasable_cart";N;s:9:"sort_type";N;s:9:"view_type";N;s:9:"row_limit";N;s:18:"is_infinity_scroll";N;s:25:"is_clear_cart_notice_sent";N;s:12:"delete_state";i:0;s:23:"delete_state_updated_at";N;s:12:"access_token";s:32:"2LfFWtJ5KLyrPK4535ycwk4AlPj8ngzJ";s:29:"has_no_order_sum_restrictions";i:0;s:10:"is_regular";b:1;s:9:"is_mature";i:1;s:14:"jwt_created_at";i:1565238043;s:16:"is_sliza_enabled";i:0;s:10:"token_push";s:2:"[]";s:13:"imported_from";N;s:15:"is_auto_created";b:0;s:26:"is_subscribed_for_delivery";i:0;s:9:"is_advert";b:0;s:19:"is_mobile_developer";b:0;s:22:"is_cloudparser_enabled";b:0;s:21:"is_subscribed_trigger";i:0;s:23:"has_notice_restrictions";i:0;s:11:"person_type";i:1;s:24:"selected_jp_organizer_id";N;s:11:"order_count";i:34;s:9:"order_sum";d:505242.49;s:22:"is_turboparser_enabled";b:0;s:17:"settlement_osm_id";i:359535254;s:11:"is_whatsapp";N;s:8:"is_viber";N;s:11:"is_telegram";N;s:21:"has_permanent_manager";i:0;s:15:"is_vote_counted";b:1;s:21:"push_messages_enabled";N;s:23:"is_password_md4_applied";b:1;s:17:"is_push_preffered";b:1;s:14:"photo_filename";s:27:"5b854c49302f52.99284397.png";s:10:"is_foreign";b:0;s:18:"contact_updated_at";N;s:11:"is_employee";b:0;}s:10:"attributes";a:68:{i:0;a:2:{s:9:"attribute";s:2:"id";s:5:"label";s:2:"Id";}i:1;a:2:{s:9:"attribute";s:4:"name";s:5:"label";s:6:"Имя";}i:2;a:2:{s:9:"attribute";s:8:"auth_key";s:5:"label";s:8:"Auth Key";}i:3;a:2:{s:9:"attribute";s:13:"password_hash";s:5:"label";s:13:"Password Hash";}i:4;a:2:{s:9:"attribute";s:20:"password_reset_token";s:5:"label";s:20:"Password Reset Token";}i:5;a:2:{s:9:"attribute";s:5:"email";s:5:"label";s:5:"Email";}i:6;a:2:{s:9:"attribute";s:5:"phone";s:5:"label";s:14:"Телефон";}i:7;a:2:{s:9:"attribute";s:13:"settlement_id";s:5:"label";s:13:"Settlement Id";}i:8;a:2:{s:9:"attribute";s:10:"manager_id";s:5:"label";s:10:"Manager Id";}i:9;a:2:{s:9:"attribute";s:6:"status";s:5:"label";s:6:"Status";}i:10;a:2:{s:9:"attribute";s:10:"birth_date";s:5:"label";s:10:"Birth Date";}i:11;a:2:{s:9:"attribute";s:28:"is_subscribed_for_newsletter";s:5:"label";s:28:"Is Subscribed For Newsletter";}i:12;a:2:{s:9:"attribute";s:29:"is_subscribed_on_order_status";s:5:"label";s:29:"Is Subscribed On Order Status";}i:13;a:2:{s:9:"attribute";s:10:"created_at";s:5:"label";s:10:"Created At";}i:14;a:2:{s:9:"attribute";s:10:"updated_at";s:5:"label";s:10:"Updated At";}i:15;a:2:{s:9:"attribute";s:10:"google_cid";s:5:"label";s:10:"Google Cid";}i:16;a:2:{s:9:"attribute";s:11:"district_id";s:5:"label";s:11:"District Id";}i:17;a:2:{s:9:"attribute";s:9:"rr_cookie";s:5:"label";s:9:"Rr Cookie";}i:18;a:2:{s:9:"attribute";s:13:"rr_updated_at";s:5:"label";s:13:"Rr Updated At";}i:19;a:2:{s:9:"attribute";s:6:"source";s:5:"label";s:6:"Source";}i:20;a:2:{s:9:"attribute";s:2:"ip";s:5:"label";s:2:"Ip";}i:21;a:2:{s:9:"attribute";s:13:"last_visit_at";s:5:"label";s:13:"Last Visit At";}i:22;a:2:{s:9:"attribute";s:12:"mobile_phone";s:5:"label";s:33:"Мобильный телефон";}i:23;a:2:{s:9:"attribute";s:16:"is_checks_hidden";s:5:"label";s:16:"Is Checks Hidden";}i:24;a:2:{s:9:"attribute";s:28:"is_able_to_download_preorder";s:5:"label";s:28:"Is Able To Download Preorder";}i:25;a:2:{s:9:"attribute";s:13:"is_competitor";s:5:"label";s:13:"Is Competitor";}i:26;a:2:{s:9:"attribute";s:15:"is_perm_balance";s:5:"label";s:15:"Is Perm Balance";}i:27;a:2:{s:9:"attribute";s:21:"has_not_erasable_cart";s:5:"label";s:21:"Has Not Erasable Cart";}i:28;a:2:{s:9:"attribute";s:9:"sort_type";s:5:"label";s:9:"Sort Type";}i:29;a:2:{s:9:"attribute";s:9:"view_type";s:5:"label";s:9:"View Type";}i:30;a:2:{s:9:"attribute";s:9:"row_limit";s:5:"label";s:9:"Row Limit";}i:31;a:2:{s:9:"attribute";s:18:"is_infinity_scroll";s:5:"label";s:18:"Is Infinity Scroll";}i:32;a:2:{s:9:"attribute";s:25:"is_clear_cart_notice_sent";s:5:"label";s:25:"Is Clear Cart Notice Sent";}i:33;a:2:{s:9:"attribute";s:12:"delete_state";s:5:"label";s:12:"Delete State";}i:34;a:2:{s:9:"attribute";s:23:"delete_state_updated_at";s:5:"label";s:23:"Delete State Updated At";}i:35;a:2:{s:9:"attribute";s:12:"access_token";s:5:"label";s:12:"Access Token";}i:36;a:2:{s:9:"attribute";s:29:"has_no_order_sum_restrictions";s:5:"label";s:29:"Has No Order Sum Restrictions";}i:37;a:2:{s:9:"attribute";s:10:"is_regular";s:5:"label";s:10:"Is Regular";}i:38;a:2:{s:9:"attribute";s:9:"is_mature";s:5:"label";s:9:"Is Mature";}i:39;a:2:{s:9:"attribute";s:14:"jwt_created_at";s:5:"label";s:14:"Jwt Created At";}i:40;a:2:{s:9:"attribute";s:16:"is_sliza_enabled";s:5:"label";s:16:"Is Sliza Enabled";}i:41;a:2:{s:9:"attribute";s:10:"token_push";s:5:"label";s:10:"Token Push";}i:42;a:2:{s:9:"attribute";s:13:"imported_from";s:5:"label";s:13:"Imported From";}i:43;a:2:{s:9:"attribute";s:15:"is_auto_created";s:5:"label";s:15:"Is Auto Created";}i:44;a:2:{s:9:"attribute";s:26:"is_subscribed_for_delivery";s:5:"label";s:26:"Is Subscribed For Delivery";}i:45;a:2:{s:9:"attribute";s:9:"is_advert";s:5:"label";s:60:"Является рекламным контрагентом";}i:46;a:2:{s:9:"attribute";s:19:"is_mobile_developer";s:5:"label";s:19:"Is Mobile Developer";}i:47;a:2:{s:9:"attribute";s:22:"is_cloudparser_enabled";s:5:"label";s:46:"Показывать виджет Сloudparser";}i:48;a:2:{s:9:"attribute";s:21:"is_subscribed_trigger";s:5:"label";s:21:"Is Subscribed Trigger";}i:49;a:2:{s:9:"attribute";s:23:"has_notice_restrictions";s:5:"label";s:23:"Has Notice Restrictions";}i:50;a:2:{s:9:"attribute";s:11:"person_type";s:5:"label";s:31:"Тип пользователя";}i:51;a:2:{s:9:"attribute";s:24:"selected_jp_organizer_id";s:5:"label";s:77:"Идентификатор выбранного организатора СП";}i:52;a:2:{s:9:"attribute";s:11:"order_count";s:5:"label";s:11:"Order Count";}i:53;a:2:{s:9:"attribute";s:9:"order_sum";s:5:"label";s:9:"Order Sum";}i:54;a:2:{s:9:"attribute";s:22:"is_turboparser_enabled";s:5:"label";s:22:"Is Turboparser Enabled";}i:55;a:2:{s:9:"attribute";s:17:"settlement_osm_id";s:5:"label";s:30:"Ид поселения ОСМ";}i:56;a:2:{s:9:"attribute";s:11:"is_whatsapp";s:5:"label";s:38:"Есть приложение WhatsApp";}i:57;a:2:{s:9:"attribute";s:8:"is_viber";s:5:"label";s:35:"Есть приложение Viber";}i:58;a:2:{s:9:"attribute";s:11:"is_telegram";s:5:"label";s:38:"Есть приложение Telegram";}i:59;a:2:{s:9:"attribute";s:21:"has_permanent_manager";s:5:"label";s:21:"Has Permanent Manager";}i:60;a:2:{s:9:"attribute";s:15:"is_vote_counted";s:5:"label";s:81:"Учитывать в конкурсе голоса от пользователя";}i:61;a:2:{s:9:"attribute";s:21:"push_messages_enabled";s:5:"label";s:48:"Отправлять push уведомелния";}i:62;a:2:{s:9:"attribute";s:23:"is_password_md4_applied";s:5:"label";s:23:"Is Password Md4 Applied";}i:63;a:2:{s:9:"attribute";s:17:"is_push_preffered";s:5:"label";s:17:"Is Push Preffered";}i:64;a:2:{s:9:"attribute";s:14:"photo_filename";s:5:"label";s:14:"Photo Filename";}i:65;a:2:{s:9:"attribute";s:10:"is_foreign";s:5:"label";s:10:"Is Foreign";}i:66;a:2:{s:9:"attribute";s:18:"contact_updated_at";s:5:"label";s:48:"Дата обновления контактов";}i:67;a:2:{s:9:"attribute";s:11:"is_employee";s:5:"label";s:49:"Является сотрудником Sima-land";}}s:13:"rolesProvider";O:26:"yii\data\ArrayDataProvider":12:{s:3:"key";N;s:9:"allModels";a:1:{s:5:"admin";a:7:{s:4:"type";i:1;s:4:"name";s:5:"admin";s:11:"description";s:13:"Administrator";s:8:"ruleName";N;s:4:"data";s:4:"null";s:9:"createdAt";N;s:9:"updatedAt";N;}}s:10:"modelClass";N;s:2:"id";s:4:"dp-2";s:32:"\00yii\data\BaseDataProvider\00_sort";N;s:38:"\00yii\data\BaseDataProvider\00_pagination";N;s:32:"\00yii\data\BaseDataProvider\00_keys";N;s:34:"\00yii\data\BaseDataProvider\00_models";N;s:38:"\00yii\data\BaseDataProvider\00_totalCount";N;s:27:"\00yii\base\Component\00_events";a:0:{}s:35:"\00yii\base\Component\00_eventWildcards";a:0:{}s:30:"\00yii\base\Component\00_behaviors";N;}s:19:"permissionsProvider";O:26:"yii\data\ArrayDataProvider":12:{s:3:"key";N;s:9:"allModels";a:1:{s:2:"/*";a:7:{s:4:"type";i:2;s:4:"name";s:2:"/*";s:11:"description";N;s:8:"ruleName";N;s:4:"data";s:4:"null";s:9:"createdAt";i:1463978668;s:9:"updatedAt";i:1463978668;}}s:10:"modelClass";N;s:2:"id";s:4:"dp-3";s:32:"\00yii\data\BaseDataProvider\00_sort";N;s:38:"\00yii\data\BaseDataProvider\00_pagination";N;s:32:"\00yii\data\BaseDataProvider\00_keys";N;s:34:"\00yii\data\BaseDataProvider\00_models";N;s:38:"\00yii\data\BaseDataProvider\00_totalCount";N;s:27:"\00yii\base\Component\00_events";a:0:{}s:35:"\00yii\base\Component\00_eventWildcards";a:0:{}s:30:"\00yii\base\Component\00_behaviors";N;}}s:6:"router";a:1:{s:8:"messages";a:9:{i:42;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:1565238595.968856;i:4;a:0:{}i:5;i:2777640;}i:43;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:1565238595.968875;i:4;a:0:{}i:5;i:2778432;}i:44;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:1565238595.96889;i:4;a:0:{}i:5;i:2779264;}i:45;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:1565238595.968904;i:4;a:0:{}i:5;i:2780048;}i:46;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:1565238595.968918;i:4;a:0:{}i:5;i:2780880;}i:47;a:6:{i:0;a:3:{s:4:"rule";s:56:"PUT api/v3/<controller:[a-z0-9\-]+>/<id:[_a-z\,0-9\-.]+>";s:5:"match";b:0;s:6:"parent";s:41:"common\modules\api\modules\v3\web\UrlRule";}i:1;i:8;i:2;s:38:"yii\web\CompositeUrlRule::parseRequest";i:3;d:1565238595.968949;i:4;a:1:{i:0;a:5:{s:4:"file";s:59:"/var/www/html/common/modules/api/modules/v3/web/UrlRule.php";s:4:"line";i:125;s:8:"function";s:12:"parseRequest";s:5:"class";s:24:"yii\web\CompositeUrlRule";s:4:"type";s:2:"->";}}i:5;i:2783232;}i:48;a:6:{i:0;s:82:"Request parsed with URL rule: api/v3/<controller:[a-z0-9\-]+>/<id:[_a-z\,0-9\-.]+>";i:1;i:8;i:2;s:29:"yii\web\UrlRule::parseRequest";i:3;d:1565238595.96898;i:4;a:1:{i:0;a:5:{s:4:"file";s:59:"/var/www/html/common/modules/api/modules/v3/web/UrlRule.php";s:4:"line";i:125;s:8:"function";s:12:"parseRequest";s:5:"class";s:24:"yii\web\CompositeUrlRule";s:4:"type";s:2:"->";}}i:5;i:2786592;}i:49;a:6:{i:0;a:3:{s:4:"rule";s:59:"DELETE api/v3/<controller:[a-z0-9\-]+>/<id:[_a-z\,0-9\-.]+>";s:5:"match";b:1;s:6:"parent";s:41:"common\modules\api\modules\v3\web\UrlRule";}i:1;i:8;i:2;s:38:"yii\web\CompositeUrlRule::parseRequest";i:3;d:1565238595.968994;i:4;a:1:{i:0;a:5:{s:4:"file";s:59:"/var/www/html/common/modules/api/modules/v3/web/UrlRule.php";s:4:"line";i:125;s:8:"function";s:12:"parseRequest";s:5:"class";s:24:"yii\web\CompositeUrlRule";s:4:"type";s:2:"->";}}i:5;i:2786904;}i:50;a:6:{i:0;a:3:{s:4:"rule";s:41:"common\modules\api\modules\v3\web\UrlRule";s:5:"match";b:1;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1565238595.969005;i:4;a:0:{}i:5;i:2786904;}}}s:3:"log";a:1:{s:8:"messages";a:51:{i:0;a:6:{i:0;s:57:"Bootstrap with bedezign\yii2\audit\Bootstrap::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1565238595.918818;i:4;a:0:{}i:5;i:1416400;}i:1;a:6:{i:0;s:51:"Opening redis DB connection: redis:6379, database=0";i:1;i:8;i:2;s:26:"yii\redis\Connection::open";i:3;d:1565238595.919459;i:4;a:0:{}i:5;i:1537696;}i:2;a:6:{i:0;s:31:"Executing Redis Command: SELECT";i:1;i:8;i:2;s:36:"yii\redis\Connection::executeCommand";i:3;d:1565238595.919805;i:4;a:0:{}i:5;i:1539880;}i:3;a:6:{i:0;s:28:"Executing Redis Command: GET";i:1;i:8;i:2;s:36:"yii\redis\Connection::executeCommand";i:3;d:1565238595.919937;i:4;a:0:{}i:5;i:1549768;}i:4;a:6:{i:0;s:48:"Bootstrap with common\components\RuntimeRedirect";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1565238595.92003;i:4;a:0:{}i:5;i:1549232;}i:5;a:6:{i:0;s:49:"Bootstrap with common\components\LanguageSelector";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1565238595.920073;i:4;a:0:{}i:5;i:1550360;}i:6;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:1565238595.920308;i:4;a:0:{}i:5;i:1571936;}i:7;a:6:{i:0;s:21:"Loading module: debug";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1565238595.92033;i:4;a:0:{}i:5;i:1572736;}i:8;a:6:{i:0;s:51:"Opening redis DB connection: redis:6379, database=1";i:1;i:8;i:2;s:26:"yii\redis\Connection::open";i:3;d:1565238595.921121;i:4;a:1:{i:0;a:5:{s:4:"file";s:52:"/var/www/html/common/components/redis/Connection.php";s:4:"line";i:31;s:8:"function";s:14:"executeCommand";s:5:"class";s:20:"yii\redis\Connection";s:4:"type";s:2:"->";}}i:5;i:1748728;}i:9;a:6:{i:0;s:31:"Executing Redis Command: SELECT";i:1;i:8;i:2;s:36:"yii\redis\Connection::executeCommand";i:3;d:1565238595.921475;i:4;a:2:{i:0;a:5:{s:4:"file";s:52:"/var/www/html/common/components/redis/Connection.php";s:4:"line";i:31;s:8:"function";s:14:"executeCommand";s:5:"class";s:20:"yii\redis\Connection";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:52:"/var/www/html/common/components/redis/Connection.php";s:4:"line";i:31;s:8:"function";s:14:"executeCommand";s:5:"class";s:20:"yii\redis\Connection";s:4:"type";s:2:"->";}}i:5;i:1752680;}i:10;a:6:{i:0;s:28:"Executing Redis Command: GET";i:1;i:8;i:2;s:36:"yii\redis\Connection::executeCommand";i:3;d:1565238595.921606;i:4;a:1:{i:0;a:5:{s:4:"file";s:52:"/var/www/html/common/components/redis/Connection.php";s:4:"line";i:31;s:8:"function";s:14:"executeCommand";s:5:"class";s:20:"yii\redis\Connection";s:4:"type";s:2:"->";}}i:5;i:1760504;}i:11;a:6:{i:0;s:15:"Session started";i:1;i:4;i:2;s:21:"yii\web\Session::open";i:3;d:1565238595.9217;i:4;a:0:{}i:5;i:1757520;}i:12;a:6:{i:0;s:58:"SELECT * FROM "user" WHERE ("id"=631860) AND ("status"=10)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.922976;i:4;a:5:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;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:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2151936;}i:13;a:6:{i:0;s:97:"Opening DB connection: pgsql:host=10.30.37.16;dbname=lebedev;application_name=lebedev-app-backend";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1565238595.923026;i:4;a:5:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;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:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2155904;}i:18;a:6:{i:0;s:28:"Executing Redis Command: get";i:1;i:8;i:2;s:36:"yii\redis\Connection::executeCommand";i:3;d:1565238595.932051;i:4;a:12:{i:0;a:5:{s:4:"file";s:52:"/var/www/html/common/components/redis/Connection.php";s:4:"line";i:31;s:8:"function";s:14:"executeCommand";s:5:"class";s:20:"yii\redis\Connection";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/html/common/components/Features.php";s:4:"line";i:117;s:8:"function";s:6:"__call";s:5:"class";s:20:"yii\redis\Connection";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:44:"/var/www/html/common/components/Features.php";s:4:"line";i:148;s:8:"function";s:20:"getFeaturesForServer";s:5:"class";s:26:"common\components\Features";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:51:"/var/www/html/common/components/CachePersistent.php";s:4:"line";i:41;s:8:"function";s:15:"getFeatureValue";s:5:"class";s:26:"common\components\Features";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:164;s:8:"function";s:5:"__get";s:5:"class";s:21:"yii\di\ServiceLocator";s:4:"type";s:2:"->";}i:5;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:148;s:8:"function";s:6:"getKey";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"::";}i:6;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:103;s:8:"function";s:11:"getCacheKey";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:7;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:8;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:9;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:10;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:11;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2262192;}i:19;a:6:{i:0;s:28:"Executing Redis Command: GET";i:1;i:8;i:2;s:36:"yii\redis\Connection::executeCommand";i:3;d:1565238595.932224;i:4;a:9:{i:0;a:5:{s:4:"file";s:52:"/var/www/html/common/components/redis/Connection.php";s:4:"line";i:31;s:8:"function";s:14:"executeCommand";s:5:"class";s:20:"yii\redis\Connection";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:164;s:8:"function";s:3:"get";s:5:"class";s:17:"yii\caching\Cache";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:148;s:8:"function";s:6:"getKey";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"::";}i:3;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:103;s:8:"function";s:11:"getCacheKey";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:5;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:6;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:7;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:8;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2262104;}i:20;a:6:{i:0;s:2524:"SELECT | |
d.nspname AS table_schema, | |
c.relname AS table_name, | |
a.attname AS column_name, | |
COALESCE(td.typname, tb.typname, t.typname) AS data_type, | |
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, | |
a.attlen AS character_maximum_length, | |
pg_catalog.col_description(c.oid, a.attnum) AS column_comment, | |
a.atttypmod AS modifier, | |
a.attnotnull = false AS is_nullable, | |
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, | |
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, | |
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char | |
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') | |
ELSE NULL | |
END AS enum_values, | |
CASE atttypid | |
WHEN 21 /*int2*/ THEN 16 | |
WHEN 23 /*int4*/ THEN 32 | |
WHEN 20 /*int8*/ THEN 64 | |
WHEN 1700 /*numeric*/ THEN | |
CASE WHEN atttypmod = -1 | |
THEN null | |
ELSE ((atttypmod - 4) >> 16) & 65535 | |
END | |
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ | |
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ | |
ELSE null | |
END AS numeric_precision, | |
CASE | |
WHEN atttypid IN (21, 23, 20) THEN 0 | |
WHEN atttypid IN (1700) THEN | |
CASE | |
WHEN atttypmod = -1 THEN null | |
ELSE (atttypmod - 4) & 65535 | |
END | |
ELSE null | |
END AS numeric_scale, | |
CAST( | |
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) | |
AS numeric | |
) AS size, | |
a.attnum = any (ct.conkey) as is_pkey, | |
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension | |
FROM | |
pg_class c | |
LEFT JOIN pg_attribute a ON a.attrelid = c.oid | |
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum | |
LEFT JOIN pg_type t ON a.atttypid = t.oid | |
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid | |
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid | |
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace | |
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' | |
WHERE | |
a.attnum > 0 AND t.typname != '' | |
AND c.relname = 'user' | |
AND d.nspname = 'web' | |
ORDER BY | |
a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.932771;i:4;a:7:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:5;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:6;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2335048;}i:23;a:6:{i:0;s:869:"select | |
ct.conname as constraint_name, | |
a.attname as column_name, | |
fc.relname as foreign_table_name, | |
fns.nspname as foreign_table_schema, | |
fa.attname as foreign_column_name | |
from | |
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s | |
FROM pg_constraint ct | |
) AS ct | |
inner join pg_class c on c.oid=ct.conrelid | |
inner join pg_namespace ns on c.relnamespace=ns.oid | |
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] | |
left join pg_class fc on fc.oid=ct.confrelid | |
left join pg_namespace fns on fc.relnamespace=fns.oid | |
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] | |
where | |
ct.contype='f' | |
and c.relname='user' | |
and ns.nspname='web' | |
order by | |
fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.948197;i:4;a:7:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:5;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:6;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2396440;}i:26;a:6:{i:0;s:125:"Unable to write cache file '/var/www/html/vendor/yiisoft/yii2/../../../cache/sc/schema12205823150056ab2a266435e83730bd.php': ";i:1;i:2;i:2;s:48:"common\components\caching\IncludeCache::setValue";i:3;d:1565238595.955038;i:4;a:7:{i:0;a:5:{s:4:"file";s:56:"/var/www/html/common/components/caching/IncludeCache.php";s:4:"line";i:111;s:8:"function";s:7:"warning";s:5:"class";s:11:"yii\BaseYii";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:107;s:8:"function";s:3:"set";s:5:"class";s:17:"yii\caching\Cache";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:227;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:3;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:233;s:8:"function";s:9:"useMaster";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:5;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1031;s:8:"function";s:3:"one";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:6;a:5:{s:4:"file";s:36:"/var/www/html/common/models/User.php";s:4:"line";i:1009;s:8:"function";s:7:"getUser";s:5:"class";s:18:"common\models\User";s:4:"type";s:2:"::";}}i:5;i:2663640;}i:27;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:1565238595.956057;i:4;a:0:{}i:5;i:2557864;}i:28;a:6:{i:0;s:28:"Executing Redis Command: GET";i:1;i:8;i:2;s:36:"yii\redis\Connection::executeCommand";i:3;d:1565238595.956248;i:4;a:1:{i:0;a:5:{s:4:"file";s:52:"/var/www/html/common/components/redis/Connection.php";s:4:"line";i:31;s:8:"function";s:14:"executeCommand";s:5:"class";s:20:"yii\redis\Connection";s:4:"type";s:2:"->";}}i:5;i:2578632;}i:29;a:6:{i:0;s:28:"Executing Redis Command: GET";i:1;i:8;i:2;s:36:"yii\redis\Connection::executeCommand";i:3;d:1565238595.956604;i:4;a:1:{i:0;a:5:{s:4:"file";s:52:"/var/www/html/common/components/redis/Connection.php";s:4:"line";i:31;s:8:"function";s:14:"executeCommand";s:5:"class";s:20:"yii\redis\Connection";s:4:"type";s:2:"->";}}i:5;i:2611856;}i:30;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1565238595.956742;i:4;a:0:{}i:5;i:2610512;}i:31;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:1565238595.95683;i:4;a:0:{}i:5;i:2616192;}i:32;a:6:{i:0;s:28:"Executing Redis Command: GET";i:1;i:8;i:2;s:36:"yii\redis\Connection::executeCommand";i:3;d:1565238595.956861;i:4;a:1:{i:0;a:5:{s:4:"file";s:52:"/var/www/html/common/components/redis/Connection.php";s:4:"line";i:31;s:8:"function";s:14:"executeCommand";s:5:"class";s:20:"yii\redis\Connection";s:4:"type";s:2:"->";}}i:5;i:2623776;}i:33;a:6:{i:0;s:21:"Loading module: audit";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1565238595.957073;i:4;a:0:{}i:5;i:2625728;}i:34;a:6:{i:0;s:2531:"SELECT | |
d.nspname AS table_schema, | |
c.relname AS table_name, | |
a.attname AS column_name, | |
COALESCE(td.typname, tb.typname, t.typname) AS data_type, | |
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, | |
a.attlen AS character_maximum_length, | |
pg_catalog.col_description(c.oid, a.attnum) AS column_comment, | |
a.atttypmod AS modifier, | |
a.attnotnull = false AS is_nullable, | |
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, | |
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, | |
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char | |
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') | |
ELSE NULL | |
END AS enum_values, | |
CASE atttypid | |
WHEN 21 /*int2*/ THEN 16 | |
WHEN 23 /*int4*/ THEN 32 | |
WHEN 20 /*int8*/ THEN 64 | |
WHEN 1700 /*numeric*/ THEN | |
CASE WHEN atttypmod = -1 | |
THEN null | |
ELSE ((atttypmod - 4) >> 16) & 65535 | |
END | |
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ | |
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ | |
ELSE null | |
END AS numeric_precision, | |
CASE | |
WHEN atttypid IN (21, 23, 20) THEN 0 | |
WHEN atttypid IN (1700) THEN | |
CASE | |
WHEN atttypmod = -1 THEN null | |
ELSE (atttypmod - 4) & 65535 | |
END | |
ELSE null | |
END AS numeric_scale, | |
CAST( | |
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) | |
AS numeric | |
) AS size, | |
a.attnum = any (ct.conkey) as is_pkey, | |
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension | |
FROM | |
pg_class c | |
LEFT JOIN pg_attribute a ON a.attrelid = c.oid | |
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum | |
LEFT JOIN pg_type t ON a.atttypid = t.oid | |
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid | |
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid | |
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace | |
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' | |
WHERE | |
a.attnum > 0 AND t.typname != '' | |
AND c.relname = 'audit_entry' | |
AND d.nspname = 'web' | |
ORDER BY | |
a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.957551;i:4;a:3:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:54:"/var/www/html/vendor/bedezign/yii2-audit/src/Audit.php";s:4:"line";i:213;s:8:"function";s:14:"getTableSchema";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}}i:5;i:2733320;}i:37;a:6:{i:0;s:876:"select | |
ct.conname as constraint_name, | |
a.attname as column_name, | |
fc.relname as foreign_table_name, | |
fns.nspname as foreign_table_schema, | |
fa.attname as foreign_column_name | |
from | |
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s | |
FROM pg_constraint ct | |
) AS ct | |
inner join pg_class c on c.oid=ct.conrelid | |
inner join pg_namespace ns on c.relnamespace=ns.oid | |
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] | |
left join pg_class fc on fc.oid=ct.confrelid | |
left join pg_namespace fns on fc.relnamespace=fns.oid | |
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] | |
where | |
ct.contype='f' | |
and c.relname='audit_entry' | |
and ns.nspname='web' | |
order by | |
fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.963863;i:4;a:3:{i:0;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:189;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:19:"yii\db\pgsql\Schema";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:105;s:8:"function";s:15:"loadTableSchema";s:5:"class";s:27:"common\components\db\Schema";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:54:"/var/www/html/vendor/bedezign/yii2-audit/src/Audit.php";s:4:"line";i:213;s:8:"function";s:14:"getTableSchema";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}}i:5;i:2745232;}i:40;a:6:{i:0;s:125:"Unable to write cache file '/var/www/html/vendor/yiisoft/yii2/../../../cache/sc/schema28bdc14233cd7e7e7cadd01d2cfcd99a.php': ";i:1;i:2;i:2;s:48:"common\components\caching\IncludeCache::setValue";i:3;d:1565238595.968361;i:4;a:3:{i:0;a:5:{s:4:"file";s:56:"/var/www/html/common/components/caching/IncludeCache.php";s:4:"line";i:111;s:8:"function";s:7:"warning";s:5:"class";s:11:"yii\BaseYii";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:45:"/var/www/html/common/components/db/Schema.php";s:4:"line";i:107;s:8:"function";s:3:"set";s:5:"class";s:17:"yii\caching\Cache";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:54:"/var/www/html/vendor/bedezign/yii2-audit/src/Audit.php";s:4:"line";i:213;s:8:"function";s:14:"getTableSchema";s:5:"class";s:17:"yii\db\Connection";s:4:"type";s:2:"->";}}i:5;i:2802880;}i:41;a:6:{i:0;s:40:"Bootstrap with bedezign\yii2\audit\Audit";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1565238595.968693;i:4;a:0:{}i:5;i:2775352;}i:51;a:6:{i:0;s:37:"Route requested: 'api/v3/user/delete'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1565238595.969017;i:4;a:0:{}i:5;i:2786216;}i:52;a:6:{i:0;s:19:"Loading module: api";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1565238595.969033;i:4;a:0:{}i:5;i:2787840;}i:53;a:6:{i:0;s:18:"Loading module: v3";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1565238595.969183;i:4;a:0:{}i:5;i:2799072;}i:54;a:6:{i:0;s:32:"Route to run: api/v3/user/delete";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1565238595.970015;i:4;a:0:{}i:5;i:2912648;}i:57;a:6:{i:0;s:56:"SELECT * FROM "auth_assignment" WHERE "user_id"='631860'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.971674;i:4;a:4:{i:0;a:5:{s:4:"file";s:46:"/var/www/html/backend/components/DbManager.php";s:4:"line";i:27;s:8:"function";s:14:"getAssignments";s:5:"class";s:18:"yii\rbac\DbManager";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/var/www/html/vendor/mdmsoft/yii2-admin/components/Helper.php";s:4:"line";i:119;s:8:"function";s:3:"can";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:68:"/var/www/html/vendor/mdmsoft/yii2-admin/components/AccessControl.php";s:4:"line";i:70;s:8:"function";s:10:"checkRoute";s:5:"class";s:27:"mdm\admin\components\Helper";s:4:"type";s:2:"::";}i:3;a:5:{s:4:"file";s:62:"/var/www/html/backend/modules/api/modules/v3/AccessControl.php";s:4:"line";i:39;s:8:"function";s:12:"beforeAction";s:5:"class";s:34:"mdm\admin\components\AccessControl";s:4:"type";s:2:"->";}}i:5;i:3126120;}i:60;a:6:{i:0;s:28:"Executing Redis Command: GET";i:1;i:8;i:2;s:36:"yii\redis\Connection::executeCommand";i:3;d:1565238595.973453;i:4;a:4:{i:0;a:5:{s:4:"file";s:52:"/var/www/html/common/components/redis/Connection.php";s:4:"line";i:31;s:8:"function";s:14:"executeCommand";s:5:"class";s:20:"yii\redis\Connection";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:61:"/var/www/html/vendor/mdmsoft/yii2-admin/components/Helper.php";s:4:"line";i:119;s:8:"function";s:3:"can";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:68:"/var/www/html/vendor/mdmsoft/yii2-admin/components/AccessControl.php";s:4:"line";i:70;s:8:"function";s:10:"checkRoute";s:5:"class";s:27:"mdm\admin\components\Helper";s:4:"type";s:2:"::";}i:3;a:5:{s:4:"file";s:62:"/var/www/html/backend/modules/api/modules/v3/AccessControl.php";s:4:"line";i:39;s:8:"function";s:12:"beforeAction";s:5:"class";s:34:"mdm\admin\components\AccessControl";s:4:"type";s:2:"->";}}i:5;i:3133328;}i:61;a:6:{i:0;s:30:"Checking permission: /api/v3/*";i:1;i:8;i:2;s:40:"yii\rbac\DbManager::checkAccessFromCache";i:3;d:1565238595.974106;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/vendor/mdmsoft/yii2-admin/components/Helper.php";s:4:"line";i:124;s:8:"function";s:3:"can";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:68:"/var/www/html/vendor/mdmsoft/yii2-admin/components/AccessControl.php";s:4:"line";i:70;s:8:"function";s:10:"checkRoute";s:5:"class";s:27:"mdm\admin\components\Helper";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:62:"/var/www/html/backend/modules/api/modules/v3/AccessControl.php";s:4:"line";i:39;s:8:"function";s:12:"beforeAction";s:5:"class";s:34:"mdm\admin\components\AccessControl";s:4:"type";s:2:"->";}}i:5;i:3384256;}i:62;a:6:{i:0;s:27:"Checking role: backend1CAPI";i:1;i:8;i:2;s:40:"yii\rbac\DbManager::checkAccessFromCache";i:3;d:1565238595.974129;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/vendor/mdmsoft/yii2-admin/components/Helper.php";s:4:"line";i:124;s:8:"function";s:3:"can";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:68:"/var/www/html/vendor/mdmsoft/yii2-admin/components/AccessControl.php";s:4:"line";i:70;s:8:"function";s:10:"checkRoute";s:5:"class";s:27:"mdm\admin\components\Helper";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:62:"/var/www/html/backend/modules/api/modules/v3/AccessControl.php";s:4:"line";i:39;s:8:"function";s:12:"beforeAction";s:5:"class";s:34:"mdm\admin\components\AccessControl";s:4:"type";s:2:"->";}}i:5;i:3386568;}i:63;a:6:{i:0;s:22:"Checking role: Solomon";i:1;i:8;i:2;s:40:"yii\rbac\DbManager::checkAccessFromCache";i:3;d:1565238595.974146;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/vendor/mdmsoft/yii2-admin/components/Helper.php";s:4:"line";i:124;s:8:"function";s:3:"can";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:68:"/var/www/html/vendor/mdmsoft/yii2-admin/components/AccessControl.php";s:4:"line";i:70;s:8:"function";s:10:"checkRoute";s:5:"class";s:27:"mdm\admin\components\Helper";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:62:"/var/www/html/backend/modules/api/modules/v3/AccessControl.php";s:4:"line";i:39;s:8:"function";s:12:"beforeAction";s:5:"class";s:34:"mdm\admin\components\AccessControl";s:4:"type";s:2:"->";}}i:5;i:3388496;}i:64;a:6:{i:0;s:23:"Checking permission: /*";i:1;i:8;i:2;s:40:"yii\rbac\DbManager::checkAccessFromCache";i:3;d:1565238595.974196;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/vendor/mdmsoft/yii2-admin/components/Helper.php";s:4:"line";i:128;s:8:"function";s:3:"can";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:68:"/var/www/html/vendor/mdmsoft/yii2-admin/components/AccessControl.php";s:4:"line";i:70;s:8:"function";s:10:"checkRoute";s:5:"class";s:27:"mdm\admin\components\Helper";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:62:"/var/www/html/backend/modules/api/modules/v3/AccessControl.php";s:4:"line";i:39;s:8:"function";s:12:"beforeAction";s:5:"class";s:34:"mdm\admin\components\AccessControl";s:4:"type";s:2:"->";}}i:5;i:3390008;}i:65;a:6:{i:0;s:20:"Checking role: admin";i:1;i:8;i:2;s:40:"yii\rbac\DbManager::checkAccessFromCache";i:3;d:1565238595.974213;i:4;a:3:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/vendor/mdmsoft/yii2-admin/components/Helper.php";s:4:"line";i:128;s:8:"function";s:3:"can";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:68:"/var/www/html/vendor/mdmsoft/yii2-admin/components/AccessControl.php";s:4:"line";i:70;s:8:"function";s:10:"checkRoute";s:5:"class";s:27:"mdm\admin\components\Helper";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:62:"/var/www/html/backend/modules/api/modules/v3/AccessControl.php";s:4:"line";i:39;s:8:"function";s:12:"beforeAction";s:5:"class";s:34:"mdm\admin\components\AccessControl";s:4:"type";s:2:"->";}}i:5;i:3397944;}i:66;a:6:{i:0;s:87:"Running action: common\modules\api\modules\v3\actions\DeleteWithValidationAction::run()";i:1;i:8;i:2;s:30:"yii\base\Action::runWithParams";i:3;d:1565238595.974294;i:4;a:0:{}i:5;i:3393824;}i:67;a:6:{i:0;s:38:"SELECT * FROM "user" WHERE "id"=631860";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.974613;i:4;a:5:{i:0;a:5:{s:4:"file";s:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:236;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:61:"/var/www/html/common/models/MasterSlaveQuerySwitcherTrait.php";s:4:"line";i:93;s:8:"function";s:12:"resolveQuery";s:5:"class";s:24:"common\queries\UserQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:70:"/var/www/html/common/modules/api/modules/v3/controllers/Controller.php";s:4:"line";i:258;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:3;a:5:{s:4:"file";s:75:"/var/www/html/backend/modules/api/modules/v3/controllers/UserController.php";s:4:"line";i:64;s:8:"function";s:9:"findModel";s:5:"class";s:52:"common\modules\api\modules\v3\controllers\Controller";s:4:"type";s:2:"->";}i:4;a:5:{s:4:"file";s:82:"/var/www/html/common/modules/api/modules/v3/actions/DeleteWithValidationAction.php";s:4:"line";i:36;s:8:"function";s:9:"findModel";s:5:"class";s:15:"yii\rest\Action";s:4:"type";s:2:"->";}}i:5;i:3430424;}i:70;a:6:{i:0;s:91:"SELECT "settlement_osm_id" FROM "osm_setllement_conformity" WHERE "settlement_id"=359535254";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.979251;i:4;a:3:{i:0;a:5:{s:4:"file";s:67:"/var/www/html/common/components/behaviors/OsmSettlementBehavior.php";s:4:"line";i:46;s:8:"function";s:6:"scalar";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:47:"/var/www/html/common/models/UploadFileModel.php";s:4:"line";i:337;s:8:"function";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:82:"/var/www/html/common/modules/api/modules/v3/actions/DeleteWithValidationAction.php";s:4:"line";i:43;s:8:"function";s:8:"validate";s:5:"class";s:14:"yii\base\Model";s:4:"type";s:2:"->";}}i:5;i:3620920;}i:73;a:6:{i:0;s:913:"yii\web\ServerErrorHttpException: Failed to delete the object for unknown reason. in /var/www/html/common/modules/api/modules/v3/actions/DeleteWithValidationAction.php:48 | |
Stack trace: | |
#0 [internal function]: common\modules\api\modules\v3\actions\DeleteWithValidationAction->run('631860') | |
#1 /var/www/html/vendor/yiisoft/yii2/base/Action.php(94): call_user_func_array(Array, Array) | |
#2 /var/www/html/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\Action->runWithParams(Array) | |
#3 /var/www/html/vendor/yiisoft/yii2/base/Module.php(528): yii\base\Controller->runAction('delete', Array) | |
#4 /var/www/html/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction('api/v3/user/del...', Array) | |
#5 /var/www/html/vendor/yiisoft/yii2/base/Application.php(386): yii\web\Application->handleRequest(Object(yii\web\Request)) | |
#6 /var/www/html/backend/web/index.php(18): yii\base\Application->run() | |
#7 {main}";i:1;i:1;i:2;s:25:"yii\web\HttpException:500";i:3;d:1565238595.982003;i:4;a:0:{}i:5;i:3626256;}i:74;a:6:{i:0;s:139:"SELECT "b".* FROM "auth_assignment" "a", "auth_item" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='631860') AND ("b"."type"=1)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.983033;i:4;a:0:{}i:5;i:3740776;}i:77;a:6:{i:0;s:139:"SELECT "b".* FROM "auth_assignment" "a", "auth_item" "b" WHERE ("a"."item_name"="b"."name") AND ("a"."user_id"='631860') AND ("b"."type"=2)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.985337;i:4;a:0:{}i:5;i:3752680;}i:80;a:6:{i:0;s:31:"SELECT * FROM "auth_item_child"";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.986775;i:4;a:0:{}i:5;i:3752568;}i:83;a:6:{i:0;s:66:"SELECT "item_name" FROM "auth_assignment" WHERE "user_id"='631860'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.98808;i:4;a:0:{}i:5;i:3784144;}i:86;a:6:{i:0;s:60:"SELECT * FROM "auth_item" WHERE ("type"=2) AND ("name"='/*')";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1565238595.989284;i:4;a:0:{}i:5;i:3787784;}i:89;a:6:{i:0;s:28:"Executing Redis Command: SET";i:1;i:8;i:2;s:36:"yii\redis\Connection::executeCommand";i:3;d:1565238595.991997;i:4;a:1:{i:0;a:5:{s:4:"file";s:52:"/var/www/html/common/components/redis/Connection.php";s:4:"line";i:31;s:8:"function";s:14:"executeCommand";s:5:"class";s:20:"yii\redis\Connection";s:4:"type";s:2:"->";}}i:5;i:3462584;}}}s:7:"summary";a:9:{s:3:"tag";s:13:"5d4ba543e96ff";s:3:"url";s:48:"http://backend-sl.local:8020/api/v3/user/631860/";s:4:"ajax";i:0;s:6:"method";s:6:"DELETE";s:2:"ip";s:10:"172.26.0.1";s:4:"time";d:1565238595.915;s:10:"statusCode";i:500;s:8:"sqlCount";i:13;s:9:"mailCount";i:0;}} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment