runtime/debug/5f3e27c5776a7.data

   1 a:14:{s:6:"config";s:1604:"a:5:{s:10:"phpVersion";s:5:"7.4.8";s:10:"yiiVersion";s:6:"2.0.36";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.36";s:4:"name";s:9:"Inventory";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:5:"7.4.8";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:6:{s:22:"yiisoft/yii2-bootstrap";a:3:{s:4:"name";s:22:"yiisoft/yii2-bootstrap";s:7:"version";s:8:"2.0.10.0";s:5:"alias";a:1:{s:14:"@yii/bootstrap";s:55:"/var/www/invent/basic/vendor/yiisoft/yii2-bootstrap/src";}}s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.1.2.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:57:"/var/www/invent/basic/vendor/yiisoft/yii2-swiftmailer/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.13.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:51:"/var/www/invent/basic/vendor/yiisoft/yii2-debug/src";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.1.4.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:49:"/var/www/invent/basic/vendor/yiisoft/yii2-gii/src";}}s:16:"yiisoft/yii2-jui";a:3:{s:4:"name";s:16:"yiisoft/yii2-jui";s:7:"version";s:7:"2.0.0.0";s:5:"alias";a:1:{s:8:"@yii/jui";s:56:"/var/www/invent/basic/vendor/yiisoft/yii2-jui-master/src";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:47:"/var/www/invent/basic/vendor/yiisoft/yii2-faker";}}}}";s:7:"request";s:5151:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:13:{s:4:"host";s:12:"192.168.0.32";s:10:"user-agent";s:78:"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:79.0) Gecko/20100101 Firefox/79.0";s:6:"accept";s:22:"text/html, */*; q=0.01";s:15:"accept-language";s:35:"ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3";s:12:"x-csrf-token";s:88:"nWMKOIcCpyeqx_1bt0dSpXIfQOG4sD1lWXAmaa9BHfPuM2QO_jOeRcyDlDHYEAiXQV4qpYrdaD0-Q1cc1gRvwg==";s:12:"content-type";s:48:"application/x-www-form-urlencoded; charset=UTF-8";s:6:"x-pjax";s:4:"true";s:16:"x-pjax-container";s:3:"#p0";s:16:"x-requested-with";s:14:"XMLHttpRequest";s:10:"connection";s:10:"keep-alive";s:7:"referer";s:65:"http://192.168.0.32/invent/index.php?r=regions%2Findex&sort=-name";s:6:"cookie";s:404:"PHPSESSID=j66jmlovhl2qi8tg6uct07qk1n; _csrf=b53f21b2bea4ff45f407c359a2d1c93980ea6c45f01950a3885dc6bb24170dd3a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22sPn6y19bfDijoWZ23AjD2mUXg3quyEr1%22%3B%7D; _identity=00e9a6e2db4b91e2b975aacad149c39c64464700dcffa7796334299b74072f02a%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A28%3A%22%5B%22100%22%2C%22test100key%22%2C2592000%5D%22%3B%7D";s:15:"accept-encoding";s:13:"gzip, deflate";}s:15:"responseHeaders";a:9:{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:10:"X-Pjax-Url";s:57:"/invent/index.php?r=regions%2Findex&sort=name&_pjax=%23p0";s:12:"Content-Type";s:24:"text/html; charset=UTF-8";s:11:"X-Debug-Tag";s:13:"5f3e27c5776a7";s:16:"X-Debug-Duration";s:5:"1,399";s:12:"X-Debug-Link";s:60:"/invent/index.php?r=debug%2Fdefault%2Fview&tag=5f3e27c5776a7";s:10:"Set-Cookie";s:266:"_identity=00e9a6e2db4b91e2b975aacad149c39c64464700dcffa7796334299b74072f02a%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A28%3A%22%5B%22100%22%2C%22test100key%22%2C2592000%5D%22%3B%7D; expires=Sat, 19-Sep-2020 07:35:33 GMT; Max-Age=2592000; path=/; HttpOnly";}s:5:"route";s:13:"regions/index";s:6:"action";s:48:"app\controllers\RegionsController::actionIndex()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:3:"GET";s:6:"isAjax";b:1;s:6:"isPjax";b:1;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:0;}s:11:"requestBody";a:0:{}s:6:"SERVER";a:36:{s:9:"HTTP_HOST";s:12:"192.168.0.32";s:15:"HTTP_USER_AGENT";s:78:"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:79.0) Gecko/20100101 Firefox/79.0";s:11:"HTTP_ACCEPT";s:22:"text/html, */*; q=0.01";s:20:"HTTP_ACCEPT_LANGUAGE";s:35:"ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3";s:17:"HTTP_X_CSRF_TOKEN";s:88:"nWMKOIcCpyeqx_1bt0dSpXIfQOG4sD1lWXAmaa9BHfPuM2QO_jOeRcyDlDHYEAiXQV4qpYrdaD0-Q1cc1gRvwg==";s:12:"CONTENT_TYPE";s:48:"application/x-www-form-urlencoded; charset=UTF-8";s:11:"HTTP_X_PJAX";s:4:"true";s:21:"HTTP_X_PJAX_CONTAINER";s:3:"#p0";s:21:"HTTP_X_REQUESTED_WITH";s:14:"XMLHttpRequest";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:12:"HTTP_REFERER";s:65:"http://192.168.0.32/invent/index.php?r=regions%2Findex&sort=-name";s:11:"HTTP_COOKIE";s:404:"PHPSESSID=j66jmlovhl2qi8tg6uct07qk1n; _csrf=b53f21b2bea4ff45f407c359a2d1c93980ea6c45f01950a3885dc6bb24170dd3a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22sPn6y19bfDijoWZ23AjD2mUXg3quyEr1%22%3B%7D; _identity=00e9a6e2db4b91e2b975aacad149c39c64464700dcffa7796334299b74072f02a%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A28%3A%22%5B%22100%22%2C%22test100key%22%2C2592000%5D%22%3B%7D";s:20:"HTTP_ACCEPT_ENCODING";s:13:"gzip, deflate";s:4:"PATH";s:60:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin";s:16:"SERVER_SIGNATURE";s:73:"<address>Apache/2.4.25 (Debian) Server at 192.168.0.32 Port 80</address>
   2 ";s:15:"SERVER_SOFTWARE";s:22:"Apache/2.4.25 (Debian)";s:11:"SERVER_NAME";s:12:"192.168.0.32";s:11:"SERVER_ADDR";s:12:"192.168.0.32";s:11:"SERVER_PORT";s:2:"80";s:11:"REMOTE_ADDR";s:12:"192.168.0.68";s:13:"DOCUMENT_ROOT";s:13:"/var/www/html";s:14:"REQUEST_SCHEME";s:4:"http";s:14:"CONTEXT_PREFIX";s:7:"/invent";s:21:"CONTEXT_DOCUMENT_ROOT";s:25:"/var/www/invent/basic/web";s:12:"SERVER_ADMIN";s:19:"webmaster@localhost";s:15:"SCRIPT_FILENAME";s:35:"/var/www/invent/basic/web/index.php";s:11:"REMOTE_PORT";s:5:"59979";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:39:"r=regions%2Findex&sort=name&_pjax=%23p0";s:11:"REQUEST_URI";s:57:"/invent/index.php?r=regions%2Findex&sort=name&_pjax=%23p0";s:11:"SCRIPT_NAME";s:17:"/invent/index.php";s:8:"PHP_SELF";s:17:"/invent/index.php";s:18:"REQUEST_TIME_FLOAT";d:1597908932.113;s:12:"REQUEST_TIME";i:1597908932;}s:3:"GET";a:3:{s:1:"r";s:13:"regions/index";s:4:"sort";s:4:"name";s:5:"_pjax";s:3:"#p0";}s:4:"POST";a:0:{}s:6:"COOKIE";a:3:{s:9:"PHPSESSID";s:26:"j66jmlovhl2qi8tg6uct07qk1n";s:5:"_csrf";s:130:"b53f21b2bea4ff45f407c359a2d1c93980ea6c45f01950a3885dc6bb24170dd3a:2:{i:0;s:5:"_csrf";i:1;s:32:"sPn6y19bfDijoWZ23AjD2mUXg3quyEr1";}";s:9:"_identity";s:130:"00e9a6e2db4b91e2b975aacad149c39c64464700dcffa7796334299b74072f02a:2:{i:0;s:9:"_identity";i:1;s:28:"["100","test100key",2592000]";}";}s:5:"FILES";a:0:{}s:7:"SESSION";a:2:{s:7:"__flash";a:0:{}s:4:"__id";s:3:"100";}}";s:6:"router";s:307:"a:3:{s:8:"messages";a:1:{i:6;a:6:{i:0;s:56:"Pretty URL not enabled. Using default URL parsing logic.";i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1597908933.489309;i:4;a:0:{}i:5;i:1269832;}}s:5:"route";s:13:"regions/index";s:6:"action";s:48:"app\controllers\RegionsController::actionIndex()";}";s:3:"log";s:7867:"a:1:{s:8:"messages";a:15:{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:1597908932.116162;i:4;a:0:{}i:5;i:866152;}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:1597908932.116189;i:4;a:0:{}i:5;i:867328;}i:2;a:6:{i:0;s:15:"Session started";i:1;i:4;i:2;s:21:"yii\web\Session::open";i:3;d:1597908933.488344;i:4;a:0:{}i:5;i:1136048;}i:3;a:6:{i:0;s:44:"Bootstrap with yii\debug\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1597908933.489087;i:4;a:0:{}i:5;i:1250232;}i:4;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1597908933.489188;i:4;a:0:{}i:5;i:1263480;}i:5;a:6:{i:0;s:42:"Bootstrap with yii\gii\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1597908933.489253;i:4;a:0:{}i:5;i:1269080;}i:7;a:6:{i:0;s:32:"Route requested: 'regions/index'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1597908933.489324;i:4;a:0:{}i:5;i:1269896;}i:8;a:6:{i:0;s:27:"Route to run: regions/index";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1597908933.489675;i:4;a:0:{}i:5;i:1283592;}i:9;a:6:{i:0;s:64:"Running action: app\controllers\RegionsController::actionIndex()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1597908933.489843;i:4;a:0:{}i:5;i:1303384;}i:10;a:6:{i:0;s:57:"Opening DB connection: pgsql:host=localhost;dbname=invent";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1597908933.490543;i:4;a:2:{i:0;a:5:{s:4:"file";s:46:"/var/www/invent/basic/models/RegionsSearch.php";s:4:"line";i:53;s:8:"function";s:7:"setSort";s:5:"class";s:27:"yii\data\ActiveDataProvider";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:39;s:8:"function";s:6:"search";s:5:"class";s:24:"app\models\RegionsSearch";s:4:"type";s:2:"->";}}i:5;i:1564128;}i:13;a:6:{i:0;s:2667:"SELECT
   3     d.nspname AS table_schema,
   4     c.relname AS table_name,
   5     a.attname AS column_name,
   6     COALESCE(td.typname, tb.typname, t.typname) AS data_type,
   7     COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
   8     a.attlen AS character_maximum_length,
   9     pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
  10     a.atttypmod AS modifier,
  11     a.attnotnull = false AS is_nullable,
  12     CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
  13     coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false)  AS is_autoinc,
  14     pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
  15     CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
  16         THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
  17         ELSE NULL
  18     END AS enum_values,
  19     CASE atttypid
  20          WHEN 21 /*int2*/ THEN 16
  21          WHEN 23 /*int4*/ THEN 32
  22          WHEN 20 /*int8*/ THEN 64
  23          WHEN 1700 /*numeric*/ THEN
  24               CASE WHEN atttypmod = -1
  25                THEN null
  26                ELSE ((atttypmod - 4) >> 16) & 65535
  27                END
  28          WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
  29          WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
  30          ELSE null
  31       END   AS numeric_precision,
  32       CASE
  33         WHEN atttypid IN (21, 23, 20) THEN 0
  34         WHEN atttypid IN (1700) THEN
  35         CASE
  36             WHEN atttypmod = -1 THEN null
  37             ELSE (atttypmod - 4) & 65535
  38         END
  39            ELSE null
  40       END AS numeric_scale,
  41     CAST(
  42              information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
  43              AS numeric
  44     ) AS size,
  45     a.attnum = any (ct.conkey) as is_pkey,
  46     COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
  47 FROM
  48     pg_class c
  49     LEFT JOIN pg_attribute a ON a.attrelid = c.oid
  50     LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
  51     LEFT JOIN pg_type t ON a.atttypid = t.oid
  52     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
  53     LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
  54     LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
  55     LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
  56 WHERE
  57     a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
  58     AND c.relname = 'regions'
  59     AND d.nspname = 'public'
  60 ORDER BY
  61     a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.499683;i:4;a:2:{i:0;a:5:{s:4:"file";s:46:"/var/www/invent/basic/models/RegionsSearch.php";s:4:"line";i:53;s:8:"function";s:7:"setSort";s:5:"class";s:27:"yii\data\ActiveDataProvider";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:39;s:8:"function";s:6:"search";s:5:"class";s:24:"app\models\RegionsSearch";s:4:"type";s:2:"->";}}i:5;i:1581704;}i:16;a:6:{i:0;s:875:"select
  62     ct.conname as constraint_name,
  63     a.attname as column_name,
  64     fc.relname as foreign_table_name,
  65     fns.nspname as foreign_table_schema,
  66     fa.attname as foreign_column_name
  67 from
  68     (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
  69        FROM pg_constraint ct
  70     ) AS ct
  71     inner join pg_class c on c.oid=ct.conrelid
  72     inner join pg_namespace ns on c.relnamespace=ns.oid
  73     inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
  74     left join pg_class fc on fc.oid=ct.confrelid
  75     left join pg_namespace fns on fc.relnamespace=fns.oid
  76     left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
  77 where
  78     ct.contype='f'
  79     and c.relname='regions'
  80     and ns.nspname='public'
  81 order by
  82     fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.508327;i:4;a:2:{i:0;a:5:{s:4:"file";s:46:"/var/www/invent/basic/models/RegionsSearch.php";s:4:"line";i:53;s:8:"function";s:7:"setSort";s:5:"class";s:27:"yii\data\ActiveDataProvider";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:39;s:8:"function";s:6:"search";s:5:"class";s:24:"app\models\RegionsSearch";s:4:"type";s:2:"->";}}i:5;i:1595184;}i:19;a:6:{i:0;s:66:"Rendering view file: /var/www/invent/basic/views/regions/index.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1597908933.510576;i:4;a:1:{i:0;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:43;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1643080;}i:20;a:6:{i:0;s:30:"SELECT COUNT(*) FROM "regions"";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.511184;i:4;a:2:{i:0;a:5:{s:4:"file";s:45:"/var/www/invent/basic/views/regions/index.php";s:4:"line";i:28;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:43;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1966776;}i:23;a:6:{i:0;s:48:"SELECT * FROM "regions" ORDER BY "name" LIMIT 20";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.511754;i:4;a:2:{i:0;a:5:{s:4:"file";s:45:"/var/www/invent/basic/views/regions/index.php";s:4:"line";i:28;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:43;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1969440;}}}";s:9:"profiling";s:12291:"a:3:{s:6:"memory";i:2004032;s:4:"time";d:1.3986060619354248;s:8:"messages";a:10:{i:11;a:6:{i:0;s:57:"Opening DB connection: pgsql:host=localhost;dbname=invent";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1597908933.490564;i:4;a:2:{i:0;a:5:{s:4:"file";s:46:"/var/www/invent/basic/models/RegionsSearch.php";s:4:"line";i:53;s:8:"function";s:7:"setSort";s:5:"class";s:27:"yii\data\ActiveDataProvider";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:39;s:8:"function";s:6:"search";s:5:"class";s:24:"app\models\RegionsSearch";s:4:"type";s:2:"->";}}i:5;i:1565632;}i:12;a:6:{i:0;s:57:"Opening DB connection: pgsql:host=localhost;dbname=invent";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1597908933.499438;i:4;a:2:{i:0;a:5:{s:4:"file";s:46:"/var/www/invent/basic/models/RegionsSearch.php";s:4:"line";i:53;s:8:"function";s:7:"setSort";s:5:"class";s:27:"yii\data\ActiveDataProvider";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:39;s:8:"function";s:6:"search";s:5:"class";s:24:"app\models\RegionsSearch";s:4:"type";s:2:"->";}}i:5;i:1567912;}i:14;a:6:{i:0;s:2667:"SELECT
  83     d.nspname AS table_schema,
  84     c.relname AS table_name,
  85     a.attname AS column_name,
  86     COALESCE(td.typname, tb.typname, t.typname) AS data_type,
  87     COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
  88     a.attlen AS character_maximum_length,
  89     pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
  90     a.atttypmod AS modifier,
  91     a.attnotnull = false AS is_nullable,
  92     CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
  93     coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false)  AS is_autoinc,
  94     pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
  95     CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
  96         THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
  97         ELSE NULL
  98     END AS enum_values,
  99     CASE atttypid
 100          WHEN 21 /*int2*/ THEN 16
 101          WHEN 23 /*int4*/ THEN 32
 102          WHEN 20 /*int8*/ THEN 64
 103          WHEN 1700 /*numeric*/ THEN
 104               CASE WHEN atttypmod = -1
 105                THEN null
 106                ELSE ((atttypmod - 4) >> 16) & 65535
 107                END
 108          WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
 109          WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
 110          ELSE null
 111       END   AS numeric_precision,
 112       CASE
 113         WHEN atttypid IN (21, 23, 20) THEN 0
 114         WHEN atttypid IN (1700) THEN
 115         CASE
 116             WHEN atttypmod = -1 THEN null
 117             ELSE (atttypmod - 4) & 65535
 118         END
 119            ELSE null
 120       END AS numeric_scale,
 121     CAST(
 122              information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
 123              AS numeric
 124     ) AS size,
 125     a.attnum = any (ct.conkey) as is_pkey,
 126     COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
 127 FROM
 128     pg_class c
 129     LEFT JOIN pg_attribute a ON a.attrelid = c.oid
 130     LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
 131     LEFT JOIN pg_type t ON a.atttypid = t.oid
 132     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
 133     LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
 134     LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
 135     LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
 136 WHERE
 137     a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
 138     AND c.relname = 'regions'
 139     AND d.nspname = 'public'
 140 ORDER BY
 141     a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.499746;i:4;a:2:{i:0;a:5:{s:4:"file";s:46:"/var/www/invent/basic/models/RegionsSearch.php";s:4:"line";i:53;s:8:"function";s:7:"setSort";s:5:"class";s:27:"yii\data\ActiveDataProvider";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:39;s:8:"function";s:6:"search";s:5:"class";s:24:"app\models\RegionsSearch";s:4:"type";s:2:"->";}}i:5;i:1592872;}i:15;a:6:{i:0;s:2667:"SELECT
 142     d.nspname AS table_schema,
 143     c.relname AS table_name,
 144     a.attname AS column_name,
 145     COALESCE(td.typname, tb.typname, t.typname) AS data_type,
 146     COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
 147     a.attlen AS character_maximum_length,
 148     pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
 149     a.atttypmod AS modifier,
 150     a.attnotnull = false AS is_nullable,
 151     CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
 152     coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false)  AS is_autoinc,
 153     pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
 154     CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
 155         THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
 156         ELSE NULL
 157     END AS enum_values,
 158     CASE atttypid
 159          WHEN 21 /*int2*/ THEN 16
 160          WHEN 23 /*int4*/ THEN 32
 161          WHEN 20 /*int8*/ THEN 64
 162          WHEN 1700 /*numeric*/ THEN
 163               CASE WHEN atttypmod = -1
 164                THEN null
 165                ELSE ((atttypmod - 4) >> 16) & 65535
 166                END
 167          WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
 168          WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
 169          ELSE null
 170       END   AS numeric_precision,
 171       CASE
 172         WHEN atttypid IN (21, 23, 20) THEN 0
 173         WHEN atttypid IN (1700) THEN
 174         CASE
 175             WHEN atttypmod = -1 THEN null
 176             ELSE (atttypmod - 4) & 65535
 177         END
 178            ELSE null
 179       END AS numeric_scale,
 180     CAST(
 181              information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
 182              AS numeric
 183     ) AS size,
 184     a.attnum = any (ct.conkey) as is_pkey,
 185     COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
 186 FROM
 187     pg_class c
 188     LEFT JOIN pg_attribute a ON a.attrelid = c.oid
 189     LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
 190     LEFT JOIN pg_type t ON a.atttypid = t.oid
 191     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
 192     LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
 193     LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
 194     LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
 195 WHERE
 196     a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
 197     AND c.relname = 'regions'
 198     AND d.nspname = 'public'
 199 ORDER BY
 200     a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.508038;i:4;a:2:{i:0;a:5:{s:4:"file";s:46:"/var/www/invent/basic/models/RegionsSearch.php";s:4:"line";i:53;s:8:"function";s:7:"setSort";s:5:"class";s:27:"yii\data\ActiveDataProvider";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:39;s:8:"function";s:6:"search";s:5:"class";s:24:"app\models\RegionsSearch";s:4:"type";s:2:"->";}}i:5;i:1599448;}i:17;a:6:{i:0;s:875:"select
 201     ct.conname as constraint_name,
 202     a.attname as column_name,
 203     fc.relname as foreign_table_name,
 204     fns.nspname as foreign_table_schema,
 205     fa.attname as foreign_column_name
 206 from
 207     (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
 208        FROM pg_constraint ct
 209     ) AS ct
 210     inner join pg_class c on c.oid=ct.conrelid
 211     inner join pg_namespace ns on c.relnamespace=ns.oid
 212     inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
 213     left join pg_class fc on fc.oid=ct.confrelid
 214     left join pg_namespace fns on fc.relnamespace=fns.oid
 215     left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
 216 where
 217     ct.contype='f'
 218     and c.relname='regions'
 219     and ns.nspname='public'
 220 order by
 221     fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.508344;i:4;a:2:{i:0;a:5:{s:4:"file";s:46:"/var/www/invent/basic/models/RegionsSearch.php";s:4:"line";i:53;s:8:"function";s:7:"setSort";s:5:"class";s:27:"yii\data\ActiveDataProvider";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:39;s:8:"function";s:6:"search";s:5:"class";s:24:"app\models\RegionsSearch";s:4:"type";s:2:"->";}}i:5;i:1600504;}i:18;a:6:{i:0;s:875:"select
 222     ct.conname as constraint_name,
 223     a.attname as column_name,
 224     fc.relname as foreign_table_name,
 225     fns.nspname as foreign_table_schema,
 226     fa.attname as foreign_column_name
 227 from
 228     (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
 229        FROM pg_constraint ct
 230     ) AS ct
 231     inner join pg_class c on c.oid=ct.conrelid
 232     inner join pg_namespace ns on c.relnamespace=ns.oid
 233     inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
 234     left join pg_class fc on fc.oid=ct.confrelid
 235     left join pg_namespace fns on fc.relnamespace=fns.oid
 236     left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
 237 where
 238     ct.contype='f'
 239     and c.relname='regions'
 240     and ns.nspname='public'
 241 order by
 242     fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.510115;i:4;a:2:{i:0;a:5:{s:4:"file";s:46:"/var/www/invent/basic/models/RegionsSearch.php";s:4:"line";i:53;s:8:"function";s:7:"setSort";s:5:"class";s:27:"yii\data\ActiveDataProvider";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:39;s:8:"function";s:6:"search";s:5:"class";s:24:"app\models\RegionsSearch";s:4:"type";s:2:"->";}}i:5;i:1602448;}i:21;a:6:{i:0;s:30:"SELECT COUNT(*) FROM "regions"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.511204;i:4;a:2:{i:0;a:5:{s:4:"file";s:45:"/var/www/invent/basic/views/regions/index.php";s:4:"line";i:28;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:43;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1968760;}i:22;a:6:{i:0;s:30:"SELECT COUNT(*) FROM "regions"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.511566;i:4;a:2:{i:0;a:5:{s:4:"file";s:45:"/var/www/invent/basic/views/regions/index.php";s:4:"line";i:28;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:43;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1970328;}i:24;a:6:{i:0;s:48:"SELECT * FROM "regions" ORDER BY "name" LIMIT 20";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.511769;i:4;a:2:{i:0;a:5:{s:4:"file";s:45:"/var/www/invent/basic/views/regions/index.php";s:4:"line";i:28;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:43;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1971496;}i:25;a:6:{i:0;s:48:"SELECT * FROM "regions" ORDER BY "name" LIMIT 20";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.512208;i:4;a:2:{i:0;a:5:{s:4:"file";s:45:"/var/www/invent/basic/views/regions/index.php";s:4:"line";i:28;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:43;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1975848;}}}";s:2:"db";s:11133:"a:1:{s:8:"messages";a:8:{i:14;a:6:{i:0;s:2667:"SELECT
 243     d.nspname AS table_schema,
 244     c.relname AS table_name,
 245     a.attname AS column_name,
 246     COALESCE(td.typname, tb.typname, t.typname) AS data_type,
 247     COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
 248     a.attlen AS character_maximum_length,
 249     pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
 250     a.atttypmod AS modifier,
 251     a.attnotnull = false AS is_nullable,
 252     CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
 253     coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false)  AS is_autoinc,
 254     pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
 255     CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
 256         THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
 257         ELSE NULL
 258     END AS enum_values,
 259     CASE atttypid
 260          WHEN 21 /*int2*/ THEN 16
 261          WHEN 23 /*int4*/ THEN 32
 262          WHEN 20 /*int8*/ THEN 64
 263          WHEN 1700 /*numeric*/ THEN
 264               CASE WHEN atttypmod = -1
 265                THEN null
 266                ELSE ((atttypmod - 4) >> 16) & 65535
 267                END
 268          WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
 269          WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
 270          ELSE null
 271       END   AS numeric_precision,
 272       CASE
 273         WHEN atttypid IN (21, 23, 20) THEN 0
 274         WHEN atttypid IN (1700) THEN
 275         CASE
 276             WHEN atttypmod = -1 THEN null
 277             ELSE (atttypmod - 4) & 65535
 278         END
 279            ELSE null
 280       END AS numeric_scale,
 281     CAST(
 282              information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
 283              AS numeric
 284     ) AS size,
 285     a.attnum = any (ct.conkey) as is_pkey,
 286     COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
 287 FROM
 288     pg_class c
 289     LEFT JOIN pg_attribute a ON a.attrelid = c.oid
 290     LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
 291     LEFT JOIN pg_type t ON a.atttypid = t.oid
 292     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
 293     LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
 294     LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
 295     LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
 296 WHERE
 297     a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
 298     AND c.relname = 'regions'
 299     AND d.nspname = 'public'
 300 ORDER BY
 301     a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.499746;i:4;a:2:{i:0;a:5:{s:4:"file";s:46:"/var/www/invent/basic/models/RegionsSearch.php";s:4:"line";i:53;s:8:"function";s:7:"setSort";s:5:"class";s:27:"yii\data\ActiveDataProvider";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:39;s:8:"function";s:6:"search";s:5:"class";s:24:"app\models\RegionsSearch";s:4:"type";s:2:"->";}}i:5;i:1592872;}i:15;a:6:{i:0;s:2667:"SELECT
 302     d.nspname AS table_schema,
 303     c.relname AS table_name,
 304     a.attname AS column_name,
 305     COALESCE(td.typname, tb.typname, t.typname) AS data_type,
 306     COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
 307     a.attlen AS character_maximum_length,
 308     pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
 309     a.atttypmod AS modifier,
 310     a.attnotnull = false AS is_nullable,
 311     CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
 312     coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false)  AS is_autoinc,
 313     pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
 314     CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
 315         THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
 316         ELSE NULL
 317     END AS enum_values,
 318     CASE atttypid
 319          WHEN 21 /*int2*/ THEN 16
 320          WHEN 23 /*int4*/ THEN 32
 321          WHEN 20 /*int8*/ THEN 64
 322          WHEN 1700 /*numeric*/ THEN
 323               CASE WHEN atttypmod = -1
 324                THEN null
 325                ELSE ((atttypmod - 4) >> 16) & 65535
 326                END
 327          WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
 328          WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
 329          ELSE null
 330       END   AS numeric_precision,
 331       CASE
 332         WHEN atttypid IN (21, 23, 20) THEN 0
 333         WHEN atttypid IN (1700) THEN
 334         CASE
 335             WHEN atttypmod = -1 THEN null
 336             ELSE (atttypmod - 4) & 65535
 337         END
 338            ELSE null
 339       END AS numeric_scale,
 340     CAST(
 341              information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
 342              AS numeric
 343     ) AS size,
 344     a.attnum = any (ct.conkey) as is_pkey,
 345     COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
 346 FROM
 347     pg_class c
 348     LEFT JOIN pg_attribute a ON a.attrelid = c.oid
 349     LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
 350     LEFT JOIN pg_type t ON a.atttypid = t.oid
 351     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
 352     LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
 353     LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
 354     LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
 355 WHERE
 356     a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
 357     AND c.relname = 'regions'
 358     AND d.nspname = 'public'
 359 ORDER BY
 360     a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.508038;i:4;a:2:{i:0;a:5:{s:4:"file";s:46:"/var/www/invent/basic/models/RegionsSearch.php";s:4:"line";i:53;s:8:"function";s:7:"setSort";s:5:"class";s:27:"yii\data\ActiveDataProvider";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:39;s:8:"function";s:6:"search";s:5:"class";s:24:"app\models\RegionsSearch";s:4:"type";s:2:"->";}}i:5;i:1599448;}i:17;a:6:{i:0;s:875:"select
 361     ct.conname as constraint_name,
 362     a.attname as column_name,
 363     fc.relname as foreign_table_name,
 364     fns.nspname as foreign_table_schema,
 365     fa.attname as foreign_column_name
 366 from
 367     (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
 368        FROM pg_constraint ct
 369     ) AS ct
 370     inner join pg_class c on c.oid=ct.conrelid
 371     inner join pg_namespace ns on c.relnamespace=ns.oid
 372     inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
 373     left join pg_class fc on fc.oid=ct.confrelid
 374     left join pg_namespace fns on fc.relnamespace=fns.oid
 375     left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
 376 where
 377     ct.contype='f'
 378     and c.relname='regions'
 379     and ns.nspname='public'
 380 order by
 381     fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.508344;i:4;a:2:{i:0;a:5:{s:4:"file";s:46:"/var/www/invent/basic/models/RegionsSearch.php";s:4:"line";i:53;s:8:"function";s:7:"setSort";s:5:"class";s:27:"yii\data\ActiveDataProvider";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:39;s:8:"function";s:6:"search";s:5:"class";s:24:"app\models\RegionsSearch";s:4:"type";s:2:"->";}}i:5;i:1600504;}i:18;a:6:{i:0;s:875:"select
 382     ct.conname as constraint_name,
 383     a.attname as column_name,
 384     fc.relname as foreign_table_name,
 385     fns.nspname as foreign_table_schema,
 386     fa.attname as foreign_column_name
 387 from
 388     (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
 389        FROM pg_constraint ct
 390     ) AS ct
 391     inner join pg_class c on c.oid=ct.conrelid
 392     inner join pg_namespace ns on c.relnamespace=ns.oid
 393     inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
 394     left join pg_class fc on fc.oid=ct.confrelid
 395     left join pg_namespace fns on fc.relnamespace=fns.oid
 396     left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
 397 where
 398     ct.contype='f'
 399     and c.relname='regions'
 400     and ns.nspname='public'
 401 order by
 402     fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.510115;i:4;a:2:{i:0;a:5:{s:4:"file";s:46:"/var/www/invent/basic/models/RegionsSearch.php";s:4:"line";i:53;s:8:"function";s:7:"setSort";s:5:"class";s:27:"yii\data\ActiveDataProvider";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:39;s:8:"function";s:6:"search";s:5:"class";s:24:"app\models\RegionsSearch";s:4:"type";s:2:"->";}}i:5;i:1602448;}i:21;a:6:{i:0;s:30:"SELECT COUNT(*) FROM "regions"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.511204;i:4;a:2:{i:0;a:5:{s:4:"file";s:45:"/var/www/invent/basic/views/regions/index.php";s:4:"line";i:28;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:43;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1968760;}i:22;a:6:{i:0;s:30:"SELECT COUNT(*) FROM "regions"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.511566;i:4;a:2:{i:0;a:5:{s:4:"file";s:45:"/var/www/invent/basic/views/regions/index.php";s:4:"line";i:28;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:43;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1970328;}i:24;a:6:{i:0;s:48:"SELECT * FROM "regions" ORDER BY "name" LIMIT 20";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.511769;i:4;a:2:{i:0;a:5:{s:4:"file";s:45:"/var/www/invent/basic/views/regions/index.php";s:4:"line";i:28;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:43;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1971496;}i:25;a:6:{i:0;s:48:"SELECT * FROM "regions" ORDER BY "name" LIMIT 20";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597908933.512208;i:4;a:2:{i:0;a:5:{s:4:"file";s:45:"/var/www/invent/basic/views/regions/index.php";s:4:"line";i:28;s:8:"function";s:6:"widget";s:5:"class";s:15:"yii\base\Widget";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:55:"/var/www/invent/basic/controllers/RegionsController.php";s:4:"line";i:43;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1975848;}}}";s:5:"event";s:6592:"a:38:{i:0;a:5:{s:4:"time";d:1597908933.489295;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:1597908933.48972;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:1597908933.489779;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"app\controllers\RegionsController";}i:3;a:5:{s:4:"time";d:1597908933.490019;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"app\models\RegionsSearch";}i:4;a:5:{s:4:"time";d:1597908933.490201;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:1597908933.490308;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:"app\models\Regions";}i:6;a:5:{s:4:"time";d:1597908933.499426;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:7;a:5:{s:4:"time";d:1597908933.510354;s:4:"name";s:18:"missingTranslation";s:5:"class";s:32:"yii\i18n\MissingTranslationEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"yii\i18n\PhpMessageSource";}i:8;a:5:{s:4:"time";d:1597908933.510365;s:4:"name";s:18:"missingTranslation";s:5:"class";s:32:"yii\i18n\MissingTranslationEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:25:"yii\i18n\PhpMessageSource";}i:9;a:5:{s:4:"time";d:1597908933.51039;s:4:"name";s:14:"beforeValidate";s:5:"class";s:19:"yii\base\ModelEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"app\models\RegionsSearch";}i:10;a:5:{s:4:"time";d:1597908933.510513;s:4:"name";s:13:"afterValidate";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:24:"app\models\RegionsSearch";}i:11;a:5:{s:4:"time";d:1597908933.510573;s:4:"name";s:12:"beforeRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:12;a:5:{s:4:"time";d:1597908933.510708;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\widgets\Pjax";}i:13;a:5:{s:4:"time";d:1597908933.510723;s:4:"name";s:9:"beginPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:14;a:5:{s:4:"time";d:1597908933.510727;s:4:"name";s:9:"beginBody";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:15;a:5:{s:4:"time";d:1597908933.510764;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\grid\GridView";}i:16;a:5:{s:4:"time";d:1597908933.510888;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\grid\GridView";}i:17;a:5:{s:4:"time";d:1597908933.512477;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:"app\models\Regions";}i:18;a:5:{s:4:"time";d:1597908933.512503;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:"app\models\Regions";}i:19;a:5:{s:4:"time";d:1597908933.512513;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:"app\models\Regions";}i:20;a:5:{s:4:"time";d:1597908933.512521;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:"app\models\Regions";}i:21;a:5:{s:4:"time";d:1597908933.512528;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:"app\models\Regions";}i:22;a:5:{s:4:"time";d:1597908933.512536;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"app\models\Regions";}i:23;a:5:{s:4:"time";d:1597908933.512538;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"app\models\Regions";}i:24;a:5:{s:4:"time";d:1597908933.512541;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"app\models\Regions";}i:25;a:5:{s:4:"time";d:1597908933.512543;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"app\models\Regions";}i:26;a:5:{s:4:"time";d:1597908933.512546;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"app\models\Regions";}i:27;a:5:{s:4:"time";d:1597908933.512992;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"yii\widgets\LinkPager";}i:28;a:5:{s:4:"time";d:1597908933.513018;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"yii\widgets\LinkPager";}i:29;a:5:{s:4:"time";d:1597908933.513024;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:21:"yii\widgets\LinkPager";}i:30;a:5:{s:4:"time";d:1597908933.513037;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"yii\grid\GridView";}i:31;a:5:{s:4:"time";d:1597908933.513058;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"yii\widgets\Pjax";}i:32;a:5:{s:4:"time";d:1597908933.513118;s:4:"name";s:7:"endBody";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:33;a:5:{s:4:"time";d:1597908933.513149;s:4:"name";s:7:"endPage";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:34;a:5:{s:4:"time";d:1597908933.513185;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:35;a:5:{s:4:"time";d:1597908933.513189;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:36;a:5:{s:4:"time";d:1597908933.513236;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:37;a:5:{s:4:"time";d:1597908933.513287;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:1156:"a:3:{s:22:"yii\grid\GridViewAsset";a:9:{s:10:"sourcePath";s:48:"/var/www/invent/basic/vendor/yiisoft/yii2/assets";s:2:"js";a:1:{i:0;s:15:"yii.gridView.js";}s:7:"depends";a:1:{i:0;s:16:"yii\web\YiiAsset";}s:8:"basePath";s:41:"/var/www/invent/basic/web/assets/dc7fe084";s:7:"baseUrl";s:23:"/invent/assets/dc7fe084";s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:16:"yii\web\YiiAsset";a:9:{s:10:"sourcePath";s:48:"/var/www/invent/basic/vendor/yiisoft/yii2/assets";s:2:"js";a:1:{i:0;s:6:"yii.js";}s:7:"depends";a:1:{i:0;s:19:"yii\web\JqueryAsset";}s:8:"basePath";s:41:"/var/www/invent/basic/web/assets/dc7fe084";s:7:"baseUrl";s:23:"/invent/assets/dc7fe084";s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:19:"yii\web\JqueryAsset";a:9:{s:10:"sourcePath";s:52:"/var/www/invent/basic/vendor/bower-asset/jquery/dist";s:2:"js";a:1:{i:0;s:9:"jquery.js";}s:8:"basePath";s:41:"/var/www/invent/basic/web/assets/a4014a78";s:7:"baseUrl";s:23:"/invent/assets/a4014a78";s:7:"depends";a:0:{}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:91:"a:3:{s:5:"start";d:1597908932.114996;s:3:"end";d:1597908933.513767;s:6:"memory";i:2004032;}";s:4:"user";s:269:"a:5:{s:2:"id";s:3:"100";s:8:"identity";a:5:{s:2:"id";s:5:"'100'";s:8:"username";s:7:"'admin'";s:8:"password";s:7:"'admin'";s:7:"authKey";s:12:"'test100key'";s:11:"accessToken";s:11:"'100-token'";}s:10:"attributes";N;s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:4:"dump";s:6:"a:0:{}";s:7:"summary";a:12:{s:3:"tag";s:13:"5f3e27c5776a7";s:3:"url";s:76:"http://192.168.0.32/invent/index.php?r=regions%2Findex&sort=name&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1597908932.113;s:10:"statusCode";i:200;s:8:"sqlCount";i:4;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2004032;s:14:"processingTime";d:1.3986060619354248;}s:10:"exceptions";a:0:{}}