a:14:{s:6:"config";s:4442:"a:5:{s:10:"phpVersion";s:6:"7.4.29";s:10:"yiiVersion";s:6:"2.0.45";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.45";s:4:"name";s:14:"My Application";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:6:"7.4.29";s:6:"xdebug";b:1;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:18:{s:23:"yiisoft/yii2-bootstrap4";a:3:{s:4:"name";s:23:"yiisoft/yii2-bootstrap4";s:7:"version";s:8:"2.0.10.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap4";s:62:"/var/www/api.docscanner.yii/vendor/yiisoft/yii2-bootstrap4/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.19.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:57:"/var/www/api.docscanner.yii/vendor/yiisoft/yii2-debug/src";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:57:"/var/www/api.docscanner.yii/vendor/yiisoft/yii2-faker/src";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.2.4.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:55:"/var/www/api.docscanner.yii/vendor/yiisoft/yii2-gii/src";}}s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.1.3.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:63:"/var/www/api.docscanner.yii/vendor/yiisoft/yii2-swiftmailer/src";}}s:25:"kartik-v/yii2-krajee-base";a:3:{s:4:"name";s:25:"kartik-v/yii2-krajee-base";s:7:"version";s:7:"3.0.4.0";s:5:"alias";a:1:{s:12:"@kartik/base";s:64:"/var/www/api.docscanner.yii/vendor/kartik-v/yii2-krajee-base/src";}}s:25:"kartik-v/yii2-datecontrol";a:3:{s:4:"name";s:25:"kartik-v/yii2-datecontrol";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:19:"@kartik/datecontrol";s:64:"/var/www/api.docscanner.yii/vendor/kartik-v/yii2-datecontrol/src";}}s:31:"kartik-v/yii2-widget-activeform";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-activeform";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:12:"@kartik/form";s:70:"/var/www/api.docscanner.yii/vendor/kartik-v/yii2-widget-activeform/src";}}s:21:"kartik-v/yii2-helpers";a:3:{s:4:"name";s:21:"kartik-v/yii2-helpers";s:7:"version";s:7:"1.3.9.0";s:5:"alias";a:1:{s:15:"@kartik/helpers";s:60:"/var/www/api.docscanner.yii/vendor/kartik-v/yii2-helpers/src";}}s:25:"kartik-v/yii2-field-range";a:3:{s:4:"name";s:25:"kartik-v/yii2-field-range";s:7:"version";s:7:"1.3.5.0";s:5:"alias";a:1:{s:13:"@kartik/field";s:64:"/var/www/api.docscanner.yii/vendor/kartik-v/yii2-field-range/src";}}s:20:"kartik-v/yii2-dialog";a:3:{s:4:"name";s:20:"kartik-v/yii2-dialog";s:7:"version";s:7:"1.0.6.0";s:5:"alias";a:1:{s:14:"@kartik/dialog";s:59:"/var/www/api.docscanner.yii/vendor/kartik-v/yii2-dialog/src";}}s:18:"kartik-v/yii2-grid";a:3:{s:4:"name";s:18:"kartik-v/yii2-grid";s:7:"version";s:7:"3.2.7.0";s:5:"alias";a:1:{s:12:"@kartik/grid";s:57:"/var/www/api.docscanner.yii/vendor/kartik-v/yii2-grid/src";}}s:31:"kartik-v/yii2-widget-datepicker";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-datepicker";s:7:"version";s:7:"1.4.8.0";s:5:"alias";a:1:{s:12:"@kartik/date";s:70:"/var/www/api.docscanner.yii/vendor/kartik-v/yii2-widget-datepicker/src";}}s:35:"kartik-v/yii2-widget-datetimepicker";a:3:{s:4:"name";s:35:"kartik-v/yii2-widget-datetimepicker";s:7:"version";s:7:"1.5.1.0";s:5:"alias";a:1:{s:16:"@kartik/datetime";s:74:"/var/www/api.docscanner.yii/vendor/kartik-v/yii2-widget-datetimepicker/src";}}s:28:"kartik-v/yii2-widget-depdrop";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-depdrop";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:15:"@kartik/depdrop";s:67:"/var/www/api.docscanner.yii/vendor/kartik-v/yii2-widget-depdrop/src";}}s:30:"kartik-v/yii2-widget-fileinput";a:3:{s:4:"name";s:30:"kartik-v/yii2-widget-fileinput";s:7:"version";s:7:"1.1.0.0";s:5:"alias";a:1:{s:12:"@kartik/file";s:69:"/var/www/api.docscanner.yii/vendor/kartik-v/yii2-widget-fileinput/src";}}s:31:"kartik-v/yii2-widget-timepicker";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-timepicker";s:7:"version";s:7:"1.0.5.0";s:5:"alias";a:1:{s:12:"@kartik/time";s:70:"/var/www/api.docscanner.yii/vendor/kartik-v/yii2-widget-timepicker/src";}}s:28:"kartik-v/yii2-widget-select2";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-select2";s:7:"version";s:10:"dev-master";s:5:"alias";a:1:{s:15:"@kartik/select2";s:67:"/var/www/api.docscanner.yii/vendor/kartik-v/yii2-widget-select2/src";}}}}";s:7:"request";s:4539:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:400;s:14:"requestHeaders";a:14:{s:4:"host";s:28:"api.docscanner.prog-matik.ru";s:10:"user-agent";s:80:"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0";s:6:"accept";s:85:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8";s:15:"accept-language";s:35:"ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3";s:15:"accept-encoding";s:17:"gzip, deflate, br";s:6:"cookie";s:172:"_csrf=e9bd5c887aef3bdc10b3b4e93fbac192b3ac5f153c8fae2dd075cf4b2a209c73a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22r5AYy5hHeQa5F-JEZ8_jNbWRc8V6d9h8%22%3B%7D";s:25:"upgrade-insecure-requests";s:1:"1";s:14:"sec-fetch-dest";s:8:"document";s:14:"sec-fetch-mode";s:8:"navigate";s:14:"sec-fetch-site";s:10:"cross-site";s:13:"authorization";s:178:"Basic L0M9UlUvU1Q9Tm92b3NpYmlyc2theWEgT2JsYXN0L0w9Tm92b3NpYmlyc2svTz1wcm9nbWF0aWsgTExDL09VPUlUL0NOPWFwcC9lbWFpbEFkZHJlc3M9YXBwQGFwaS5kb2NzY2FubmVyLnByb2ctbWF0aWsucnU6cGFzc3dvcmQ=";s:3:"via";s:47:"1.1 api.docscanner.prog-matik.ru (Apache/2.4.7)";s:18:"x-forwarded-server";s:28:"api.docscanner.prog-matik.ru";s:10:"connection";s:10:"Keep-Alive";}s:15:"responseHeaders";a:5:{s:4:"Vary";s:6:"Accept";s:12:"Content-Type";s:30:"application/xml; charset=UTF-8";s:11:"X-Debug-Tag";s:13:"62b42cbe4b54d";s:16:"X-Debug-Duration";s:2:"92";s:12:"X-Debug-Link";s:37:"/debug/default/view?tag=62b42cbe4b54d";}s:5:"route";s:16:"v1/default/index";s:6:"action";s:59:"app\modules\v1\controllers\DefaultController::actionIndex()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:3:"GET";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:1;}s:11:"requestBody";a:0:{}s:6:"SERVER";a:46:{s:14:"REDIRECT_HTTPS";s:2:"on";s:20:"REDIRECT_SSL_TLS_SNI";s:28:"api.docscanner.prog-matik.ru";s:15:"REDIRECT_STATUS";s:3:"200";s:5:"HTTPS";s:2:"on";s:11:"SSL_TLS_SNI";s:28:"api.docscanner.prog-matik.ru";s:9:"HTTP_HOST";s:28:"api.docscanner.prog-matik.ru";s:15:"HTTP_USER_AGENT";s:80:"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0";s:11:"HTTP_ACCEPT";s:85:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8";s:20:"HTTP_ACCEPT_LANGUAGE";s:35:"ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3";s:20:"HTTP_ACCEPT_ENCODING";s:17:"gzip, deflate, br";s:11:"HTTP_COOKIE";s:172:"_csrf=e9bd5c887aef3bdc10b3b4e93fbac192b3ac5f153c8fae2dd075cf4b2a209c73a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22r5AYy5hHeQa5F-JEZ8_jNbWRc8V6d9h8%22%3B%7D";s:30:"HTTP_UPGRADE_INSECURE_REQUESTS";s:1:"1";s:19:"HTTP_SEC_FETCH_DEST";s:8:"document";s:19:"HTTP_SEC_FETCH_MODE";s:8:"navigate";s:19:"HTTP_SEC_FETCH_SITE";s:10:"cross-site";s:8:"HTTP_VIA";s:47:"1.1 api.docscanner.prog-matik.ru (Apache/2.4.7)";s:20:"HTTP_X_FORWARDED_FOR";s:11:"172.16.0.13";s:21:"HTTP_X_FORWARDED_HOST";s:28:"api.docscanner.prog-matik.ru";s:23:"HTTP_X_FORWARDED_SERVER";s:28:"api.docscanner.prog-matik.ru";s:15:"HTTP_CONNECTION";s:10:"Keep-Alive";s:4:"PATH";s:70:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin";s:16:"SERVER_SIGNATURE";s:90:"Apache/2.4.29 (Ubuntu) Server at api.docscanner.prog-matik.ru Port 443
";s:15:"SERVER_SOFTWARE";s:22:"Apache/2.4.29 (Ubuntu)";s:11:"SERVER_NAME";s:28:"api.docscanner.prog-matik.ru";s:11:"SERVER_ADDR";s:12:"172.16.0.206";s:11:"SERVER_PORT";s:3:"443";s:11:"REMOTE_ADDR";s:10:"172.16.0.1";s:13:"DOCUMENT_ROOT";s:31:"/var/www/api.docscanner.yii/web";s:14:"REQUEST_SCHEME";s:5:"https";s:14:"CONTEXT_PREFIX";s:0:"";s:21:"CONTEXT_DOCUMENT_ROOT";s:31:"/var/www/api.docscanner.yii/web";s:12:"SERVER_ADMIN";s:23:"webmaster@prog-matik.ru";s:15:"SCRIPT_FILENAME";s:41:"/var/www/api.docscanner.yii/web/index.php";s:11:"REMOTE_PORT";s:5:"46508";s:12:"REDIRECT_URL";s:3:"/v1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:3:"GET";s:12:"QUERY_STRING";s:0:"";s:11:"REQUEST_URI";s:3:"/v1";s:11:"SCRIPT_NAME";s:10:"/index.php";s:8:"PHP_SELF";s:10:"/index.php";s:13:"PHP_AUTH_USER";s:119:"/C=RU/ST=Novosibirskaya Oblast/L=Novosibirsk/O=progmatik LLC/OU=IT/CN=app/emailAddress=app@api.docscanner.prog-matik.ru";s:11:"PHP_AUTH_PW";s:8:"password";s:18:"REQUEST_TIME_FLOAT";d:1655975102.298731;s:12:"REQUEST_TIME";i:1655975102;}s:3:"GET";a:0:{}s:4:"POST";a:0:{}s:6:"COOKIE";a:1:{s:5:"_csrf";s:130:"e9bd5c887aef3bdc10b3b4e93fbac192b3ac5f153c8fae2dd075cf4b2a209c73a:2:{i:0;s:5:"_csrf";i:1;s:32:"r5AYy5hHeQa5F-JEZ8_jNbWRc8V6d9h8";}";}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}";s:6:"router";s:1458:"a:3:{s:8:"messages";a:7:{i:5;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:1655975102.310328;i:4;a:0:{}i:5;i:1319392;}i:6;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1655975102.310363;i:4;a:0:{}i:5;i:1320144;}i:7;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii//";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1655975102.31038;i:4;a:0:{}i:5;i:1320896;}i:8;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:1655975102.310394;i:4;a:0:{}i:5;i:1321648;}i:9;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug//";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1655975102.310415;i:4;a:0:{}i:5;i:1322720;}i:10;a:6:{i:0;a:3:{s:4:"rule";s:16:"yii\rest\UrlRule";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1655975102.310432;i:4;a:0:{}i:5;i:1323472;}i:11;a:6:{i:0;s:55:"No matching URL rules. Using default URL parsing logic.";i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1655975102.31044;i:4;a:0:{}i:5;i:1323848;}}s:5:"route";s:16:"v1/default/index";s:6:"action";s:59:"app\modules\v1\controllers\DefaultController::actionIndex()";}";s:3:"log";s:7708:"a:1:{s:8:"messages";a:14:{i:0;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:1655975102.304239;i:4;a:0:{}i:5;i:894864;}i:1;a:6:{i:0;s:21:"Loading module: debug";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1655975102.304284;i:4;a:0:{}i:5;i:896040;}i:2;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:1655975102.308454;i:4;a:0:{}i:5;i:1164112;}i:3;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1655975102.309584;i:4;a:0:{}i:5;i:1222640;}i:4;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:1655975102.309707;i:4;a:0:{}i:5;i:1293720;}i:12;a:6:{i:0;s:21:"Route requested: 'v1'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1655975102.310457;i:4;a:0:{}i:5;i:1323576;}i:13;a:6:{i:0;s:18:"Loading module: v1";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1655975102.310474;i:4;a:0:{}i:5;i:1325128;}i:14;a:6:{i:0;s:30:"Route to run: v1/default/index";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1655975102.33739;i:4;a:0:{}i:5;i:1363896;}i:15;a:6:{i:0;s:39:"Rate limit skipped: user not logged in.";i:1;i:4;i:2;s:37:"yii\filters\RateLimiter::beforeAction";i:3;d:1655975102.338149;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:24;s:8:"function";s:12:"beforeAction";s:5:"class";s:18:"yii\web\Controller";s:4:"type";s:2:"->";}}i:5;i:1399720;}i:16;a:6:{i:0;s:52:"SELECT * FROM "spr_users" ORDER BY "id" DESC LIMIT 1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.34104;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1739720;}i:17;a:6:{i:0;s:75:"Opening DB connection: pgsql:host=172.16.0.204;port=5432;dbname=doc_scanner";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1655975102.341128;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1743192;}i:22;a:6:{i:0;s:2815:"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,
(SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
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) OR attidentity != '' AS is_autoinc,
pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
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 NOT a.attisdropped
AND c.relname = 'spr_users'
AND d.nspname = 'public'
ORDER BY
a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.36505;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1760968;}i:25;a:6:{i:0;s:877:"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='spr_users'
and ns.nspname='public'
order by
fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.379739;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1781568;}i:28;a:6:{i:0;s:75:"Running action: app\modules\v1\controllers\DefaultController::actionIndex()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1655975102.38544;i:4;a:0:{}i:5;i:1876728;}}}";s:9:"profiling";s:11935:"a:3:{s:6:"memory";i:2010904;s:4:"time";d:0.09184789657592773;s:8:"messages";a:8:{i:18;a:6:{i:0;s:75:"Opening DB connection: pgsql:host=172.16.0.204;port=5432;dbname=doc_scanner";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1655975102.341148;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1744696;}i:19;a:6:{i:0;s:75:"Opening DB connection: pgsql:host=172.16.0.204;port=5432;dbname=doc_scanner";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1655975102.362183;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1746992;}i:20;a:6:{i:0;s:52:"SELECT * FROM "spr_users" ORDER BY "id" DESC LIMIT 1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.362255;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1747920;}i:21;a:6:{i:0;s:52:"SELECT * FROM "spr_users" ORDER BY "id" DESC LIMIT 1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.36425;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1751352;}i:23;a:6:{i:0;s:2815:"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,
(SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
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) OR attidentity != '' AS is_autoinc,
pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
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 NOT a.attisdropped
AND c.relname = 'spr_users'
AND d.nspname = 'public'
ORDER BY
a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.365134;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1772048;}i:24;a:6:{i:0;s:2815:"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,
(SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
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) OR attidentity != '' AS is_autoinc,
pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
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 NOT a.attisdropped
AND c.relname = 'spr_users'
AND d.nspname = 'public'
ORDER BY
a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.378717;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1796912;}i:26;a:6:{i:0;s:877:"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='spr_users'
and ns.nspname='public'
order by
fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.3798;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1786248;}i:27;a:6:{i:0;s:877:"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='spr_users'
and ns.nspname='public'
order by
fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.38362;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1790176;}}}";s:2:"db";s:10673:"a:1:{s:8:"messages";a:6:{i:20;a:6:{i:0;s:52:"SELECT * FROM "spr_users" ORDER BY "id" DESC LIMIT 1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.362255;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1747920;}i:21;a:6:{i:0;s:52:"SELECT * FROM "spr_users" ORDER BY "id" DESC LIMIT 1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.36425;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1751352;}i:23;a:6:{i:0;s:2815:"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,
(SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
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) OR attidentity != '' AS is_autoinc,
pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
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 NOT a.attisdropped
AND c.relname = 'spr_users'
AND d.nspname = 'public'
ORDER BY
a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.365134;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1772048;}i:24;a:6:{i:0;s:2815:"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,
(SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
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) OR attidentity != '' AS is_autoinc,
pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
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 NOT a.attisdropped
AND c.relname = 'spr_users'
AND d.nspname = 'public'
ORDER BY
a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.378717;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1796912;}i:26;a:6:{i:0;s:877:"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='spr_users'
and ns.nspname='public'
order by
fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.3798;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1786248;}i:27;a:6:{i:0;s:877:"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='spr_users'
and ns.nspname='public'
order by
fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1655975102.38362;i:4;a:2:{i:0;a:5:{s:4:"file";s:59:"/var/www/api.docscanner.yii/modules/v1/models/AuthModel.php";s:4:"line";i:153;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:69:"/var/www/api.docscanner.yii/modules/v1/controllers/BaseController.php";s:4:"line";i:30;s:8:"function";s:17:"checkDbConnection";s:5:"class";s:31:"app\modules\v1\models\AuthModel";s:4:"type";s:2:"::";}}i:5;i:1790176;}}}";s:5:"event";s:2687:"a:15:{i:0;a:5:{s:4:"time";d:1655975102.310057;s:4:"name";s:13:"beforeRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:1;a:5:{s:4:"time";d:1655975102.337496;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:2;a:5:{s:4:"time";d:1655975102.337522;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"app\modules\v1\ApiModule";}i:3;a:5:{s:4:"time";d:1655975102.338187;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:44:"app\modules\v1\controllers\DefaultController";}i:4;a:5:{s:4:"time";d:1655975102.339648;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:5;a:5:{s:4:"time";d:1655975102.362169;s:4:"name";s:9:"afterOpen";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\db\Connection";}i:6;a:5:{s:4:"time";d:1655975102.364787;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"app\models\SprUsers";}i:7;a:5:{s:4:"time";d:1655975102.384204;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"app\models\SprUsers";}i:8;a:5:{s:4:"time";d:1655975102.389861;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:44:"app\modules\v1\controllers\DefaultController";}i:9;a:5:{s:4:"time";d:1655975102.390194;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"app\modules\v1\ApiModule";}i:10;a:5:{s:4:"time";d:1655975102.390218;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:11;a:5:{s:4:"time";d:1655975102.390244;s:4:"name";s:12:"afterRequest";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:19:"yii\web\Application";}i:12;a:5:{s:4:"time";d:1655975102.390266;s:4:"name";s:10:"beforeSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:13;a:5:{s:4:"time";d:1655975102.392595;s:4:"name";s:12:"afterPrepare";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}i:14;a:5:{s:4:"time";d:1655975102.392733;s:4:"name";s:9:"afterSend";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\web\Response";}}";s:6:"assets";s:6:"a:0:{}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:91:"a:3:{s:5:"start";d:1655975102.301659;s:3:"end";d:1655975102.393618;s:6:"memory";i:2010904;}";s:4:"user";s:2:"N;";s:4:"dump";s:6:"a:0:{}";s:7:"summary";a:12:{s:3:"tag";s:13:"62b42cbe4b54d";s:3:"url";s:39:"https://api.docscanner.prog-matik.ru/v1";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:10:"172.16.0.1";s:4:"time";d:1655975102.298731;s:10:"statusCode";i:400;s:8:"sqlCount";i:3;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2010904;s:14:"processingTime";d:0.09184789657592773;}s:10:"exceptions";a:0:{}}