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:4583:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:9:{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:74:"text/html,application/xhtml+xml,application/xml;q=0.9,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:10:"connection";s:10:"keep-alive";s:7:"referer";s:58:"http://192.168.0.32/invent/index.php?r=items%2Findex&id=18";s:6:"cookie";s:404:"_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; PHPSESSID=948m12f2rnlrvl51s2joe9dstd; _csrf=b53f21b2bea4ff45f407c359a2d1c93980ea6c45f01950a3885dc6bb24170dd3a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22sPn6y19bfDijoWZ23AjD2mUXg3quyEr1%22%3B%7D";s:25:"upgrade-insecure-requests";s:1:"1";s:15:"accept-encoding";s:13:"gzip, deflate";}s:15:"responseHeaders";a:8:{s:7:"Expires";s:29:"Thu, 19 Nov 1981 08:52:00 GMT";s:13:"Cache-Control";s:35:"no-store, no-cache, must-revalidate";s:6:"Pragma";s:8:"no-cache";s:12:"Content-Type";s:24:"text/html; charset=UTF-8";s:11:"X-Debug-Tag";s:13:"5f3f7b75e3b65";s:16:"X-Debug-Duration";s:2:"46";s:12:"X-Debug-Link";s:60:"/invent/index.php?r=debug%2Fdefault%2Fview&tag=5f3f7b75e3b65";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=Sun, 20-Sep-2020 07:44:53 GMT; Max-Age=2592000; path=/; HttpOnly";}s:5:"route";s:12:"items/update";s:6:"action";s:47:"app\controllers\ItemsController::actionUpdate()";s:12:"actionParams";a:1:{s:2:"id";s:2:"18";}s:7:"general";a:5:{s:6:"method";s:3:"GET";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:0;}s:11:"requestBody";a:0:{}s:6:"SERVER";a:32:{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:74:"text/html,application/xhtml+xml,application/xml;q=0.9,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:15:"HTTP_CONNECTION";s:10:"keep-alive";s:12:"HTTP_REFERER";s:58:"http://192.168.0.32/invent/index.php?r=items%2Findex&id=18";s:11:"HTTP_COOKIE";s:404:"_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; PHPSESSID=948m12f2rnlrvl51s2joe9dstd; _csrf=b53f21b2bea4ff45f407c359a2d1c93980ea6c45f01950a3885dc6bb24170dd3a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22sPn6y19bfDijoWZ23AjD2mUXg3quyEr1%22%3B%7D";s:30:"HTTP_UPGRADE_INSECURE_REQUESTS";s:1:"1";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:"23676";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:22:"r=items%2Fupdate&id=18";s:11:"REQUEST_URI";s:40:"/invent/index.php?r=items%2Fupdate&id=18";s:11:"SCRIPT_NAME";s:17:"/invent/index.php";s:8:"PHP_SELF";s:17:"/invent/index.php";s:18:"REQUEST_TIME_FLOAT";d:1597995893.929;s:12:"REQUEST_TIME";i:1597995893;}s:3:"GET";a:2:{s:1:"r";s:12:"items/update";s:2:"id";s:2:"18";}s:4:"POST";a:0:{}s:6:"COOKIE";a:3:{s:9:"_identity";s:130:"00e9a6e2db4b91e2b975aacad149c39c64464700dcffa7796334299b74072f02a:2:{i:0;s:9:"_identity";i:1;s:28:"["100","test100key",2592000]";}";s:9:"PHPSESSID";s:26:"948m12f2rnlrvl51s2joe9dstd";s:5:"_csrf";s:130:"b53f21b2bea4ff45f407c359a2d1c93980ea6c45f01950a3885dc6bb24170dd3a:2:{i:0;s:5:"_csrf";i:1;s:32:"sPn6y19bfDijoWZ23AjD2mUXg3quyEr1";}";}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:305:"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:1597995893.932911;i:4;a:0:{}i:5;i:1266392;}}s:5:"route";s:12:"items/update";s:6:"action";s:47:"app\controllers\ItemsController::actionUpdate()";}";s:3:"log";s:24802:"a:1:{s:8:"messages";a:25:{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:1597995893.931003;i:4;a:0:{}i:5;i:862712;}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:1597995893.931031;i:4;a:0:{}i:5;i:863888;}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:1597995893.932007;i:4;a:0:{}i:5;i:1132608;}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:1597995893.932663;i:4;a:0:{}i:5;i:1246792;}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:1597995893.932767;i:4;a:0:{}i:5;i:1260040;}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:1597995893.932842;i:4;a:0:{}i:5;i:1265640;}i:7;a:6:{i:0;s:31:"Route requested: 'items/update'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1597995893.93293;i:4;a:0:{}i:5;i:1266448;}i:8;a:6:{i:0;s:26:"Route to run: items/update";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1597995893.933132;i:4;a:0:{}i:5;i:1280136;}i:9;a:6:{i:0;s:63:"Running action: app\controllers\ItemsController::actionUpdate()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1597995893.933384;i:4;a:0:{}i:5;i:1298808;}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:1597995893.933825;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1464776;}i:13;a:6:{i:0;s:2665:"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[], ',')
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
26 ELSE ((atttypmod - 4) >> 16) & 65535
28 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
29 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
31 END AS numeric_precision,
33 WHEN atttypid IN (21, 23, 20) THEN 0
34 WHEN atttypid IN (1700) THEN
36 WHEN atttypmod = -1 THEN null
37 ELSE (atttypmod - 4) & 65535
42 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
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
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'
57 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
58 AND c.relname = 'items'
59 AND d.nspname = 'public'
61 a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.941896;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1547880;}i:16;a:6:{i:0;s:873:"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
68 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
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]
80 and ns.nspname='public'
82 fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.948577;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1571896;}i:19;a:6:{i:0;s:37:"SELECT * FROM "items" WHERE "id"='18'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.951093;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1603672;}i:22;a:6:{i:0;s:65:"Rendering view file: /var/www/invent/basic/views/items/update.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1597995893.951951;i:4;a:1:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1613104;}i:23;a:6:{i:0;s:64:"Rendering view file: /var/www/invent/basic/views/items/_form.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1597995893.952096;i:4;a:2:{i:0;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1656880;}i:24;a:6:{i:0;s:37:"SELECT * FROM "types" ORDER BY "name"";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.952182;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1762272;}i:27;a:6:{i:0;s:2665:"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[], ',')
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
106 ELSE ((atttypmod - 4) >> 16) & 65535
108 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
109 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
111 END AS numeric_precision,
113 WHEN atttypid IN (21, 23, 20) THEN 0
114 WHEN atttypid IN (1700) THEN
116 WHEN atttypmod = -1 THEN null
117 ELSE (atttypmod - 4) & 65535
120 END AS numeric_scale,
122 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
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
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'
137 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
138 AND c.relname = 'types'
139 AND d.nspname = 'public'
141 a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.952896;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1779400;}i:30;a:6:{i:0;s:873:"select
142 ct.conname as constraint_name,
143 a.attname as column_name,
144 fc.relname as foreign_table_name,
145 fns.nspname as foreign_table_schema,
146 fa.attname as foreign_column_name
148 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
149 FROM pg_constraint ct
151 inner join pg_class c on c.oid=ct.conrelid
152 inner join pg_namespace ns on c.relnamespace=ns.oid
153 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
154 left join pg_class fc on fc.oid=ct.confrelid
155 left join pg_namespace fns on fc.relnamespace=fns.oid
156 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
159 and c.relname='types'
160 and ns.nspname='public'
162 fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.956217;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1787904;}i:33;a:6:{i:0;s:38:"SELECT * FROM "status" ORDER BY "name"";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.958471;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1809432;}i:36;a:6:{i:0;s:2666:"SELECT
163 d.nspname AS table_schema,
164 c.relname AS table_name,
165 a.attname AS column_name,
166 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
167 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
168 a.attlen AS character_maximum_length,
169 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
170 a.atttypmod AS modifier,
171 a.attnotnull = false AS is_nullable,
172 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
173 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
174 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
175 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
176 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
180 WHEN 21 /*int2*/ THEN 16
181 WHEN 23 /*int4*/ THEN 32
182 WHEN 20 /*int8*/ THEN 64
183 WHEN 1700 /*numeric*/ THEN
184 CASE WHEN atttypmod = -1
186 ELSE ((atttypmod - 4) >> 16) & 65535
188 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
189 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
191 END AS numeric_precision,
193 WHEN atttypid IN (21, 23, 20) THEN 0
194 WHEN atttypid IN (1700) THEN
196 WHEN atttypmod = -1 THEN null
197 ELSE (atttypmod - 4) & 65535
200 END AS numeric_scale,
202 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
205 a.attnum = any (ct.conkey) as is_pkey,
206 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
209 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
210 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
211 LEFT JOIN pg_type t ON a.atttypid = t.oid
212 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
213 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
214 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
215 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
217 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
218 AND c.relname = 'status'
219 AND d.nspname = 'public'
221 a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.959007;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1825008;}i:39;a:6:{i:0;s:874:"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
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
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]
239 and c.relname='status'
240 and ns.nspname='public'
242 fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.962359;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1833464;}i:42;a:6:{i:0;s:41:"SELECT * FROM "locations" ORDER BY "name"";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.964625;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1854016;}i:45;a:6:{i:0;s:2669:"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[], ',')
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
266 ELSE ((atttypmod - 4) >> 16) & 65535
268 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
269 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
271 END AS numeric_precision,
273 WHEN atttypid IN (21, 23, 20) THEN 0
274 WHEN atttypid IN (1700) THEN
276 WHEN atttypmod = -1 THEN null
277 ELSE (atttypmod - 4) & 65535
280 END AS numeric_scale,
282 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
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
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'
297 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
298 AND c.relname = 'locations'
299 AND d.nspname = 'public'
301 a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.965158;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1874552;}i:48;a:6:{i:0;s:877:"select
302 ct.conname as constraint_name,
303 a.attname as column_name,
304 fc.relname as foreign_table_name,
305 fns.nspname as foreign_table_schema,
306 fa.attname as foreign_column_name
308 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
309 FROM pg_constraint ct
311 inner join pg_class c on c.oid=ct.conrelid
312 inner join pg_namespace ns on c.relnamespace=ns.oid
313 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
314 left join pg_class fc on fc.oid=ct.confrelid
315 left join pg_namespace fns on fc.relnamespace=fns.oid
316 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
319 and c.relname='locations'
320 and ns.nspname='public'
322 fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.968489;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1883656;}i:51;a:6:{i:0;s:65:"Rendering view file: /var/www/invent/basic/views/layouts/main.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1597995893.974788;i:4;a:1:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:2049160;}}}";s:9:"profiling";s:44386:"a:3:{s:6:"memory";i:2253472;s:4:"time";d:0.04676389694213867;s:8:"messages";a:26:{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:1597995893.933851;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1466280;}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:1597995893.94184;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1468560;}i:14;a:6:{i:0;s:2665:"SELECT
323 d.nspname AS table_schema,
324 c.relname AS table_name,
325 a.attname AS column_name,
326 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
327 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
328 a.attlen AS character_maximum_length,
329 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
330 a.atttypmod AS modifier,
331 a.attnotnull = false AS is_nullable,
332 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
333 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
334 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
335 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
336 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
340 WHEN 21 /*int2*/ THEN 16
341 WHEN 23 /*int4*/ THEN 32
342 WHEN 20 /*int8*/ THEN 64
343 WHEN 1700 /*numeric*/ THEN
344 CASE WHEN atttypmod = -1
346 ELSE ((atttypmod - 4) >> 16) & 65535
348 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
349 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
351 END AS numeric_precision,
353 WHEN atttypid IN (21, 23, 20) THEN 0
354 WHEN atttypid IN (1700) THEN
356 WHEN atttypmod = -1 THEN null
357 ELSE (atttypmod - 4) & 65535
360 END AS numeric_scale,
362 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
365 a.attnum = any (ct.conkey) as is_pkey,
366 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
369 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
370 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
371 LEFT JOIN pg_type t ON a.atttypid = t.oid
372 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
373 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
374 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
375 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
377 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
378 AND c.relname = 'items'
379 AND d.nspname = 'public'
381 a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.941923;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1559048;}i:15;a:6:{i:0;s:2665:"SELECT
382 d.nspname AS table_schema,
383 c.relname AS table_name,
384 a.attname AS column_name,
385 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
386 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
387 a.attlen AS character_maximum_length,
388 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
389 a.atttypmod AS modifier,
390 a.attnotnull = false AS is_nullable,
391 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
392 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
393 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
394 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
395 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
399 WHEN 21 /*int2*/ THEN 16
400 WHEN 23 /*int4*/ THEN 32
401 WHEN 20 /*int8*/ THEN 64
402 WHEN 1700 /*numeric*/ THEN
403 CASE WHEN atttypmod = -1
405 ELSE ((atttypmod - 4) >> 16) & 65535
407 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
408 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
410 END AS numeric_precision,
412 WHEN atttypid IN (21, 23, 20) THEN 0
413 WHEN atttypid IN (1700) THEN
415 WHEN atttypmod = -1 THEN null
416 ELSE (atttypmod - 4) & 65535
419 END AS numeric_scale,
421 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
424 a.attnum = any (ct.conkey) as is_pkey,
425 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
428 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
429 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
430 LEFT JOIN pg_type t ON a.atttypid = t.oid
431 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
432 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
433 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
434 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
436 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
437 AND c.relname = 'items'
438 AND d.nspname = 'public'
440 a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.948296;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1584896;}i:17;a:6:{i:0;s:873:"select
441 ct.conname as constraint_name,
442 a.attname as column_name,
443 fc.relname as foreign_table_name,
444 fns.nspname as foreign_table_schema,
445 fa.attname as foreign_column_name
447 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
448 FROM pg_constraint ct
450 inner join pg_class c on c.oid=ct.conrelid
451 inner join pg_namespace ns on c.relnamespace=ns.oid
452 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
453 left join pg_class fc on fc.oid=ct.confrelid
454 left join pg_namespace fns on fc.relnamespace=fns.oid
455 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
458 and c.relname='items'
459 and ns.nspname='public'
461 fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.948598;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1577216;}i:18;a:6:{i:0;s:873:"select
462 ct.conname as constraint_name,
463 a.attname as column_name,
464 fc.relname as foreign_table_name,
465 fns.nspname as foreign_table_schema,
466 fa.attname as foreign_column_name
468 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
469 FROM pg_constraint ct
471 inner join pg_class c on c.oid=ct.conrelid
472 inner join pg_namespace ns on c.relnamespace=ns.oid
473 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
474 left join pg_class fc on fc.oid=ct.confrelid
475 left join pg_namespace fns on fc.relnamespace=fns.oid
476 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
479 and c.relname='items'
480 and ns.nspname='public'
482 fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.950787;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1581160;}i:20;a:6:{i:0;s:37:"SELECT * FROM "items" WHERE "id"='18'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.951113;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1606480;}i:21;a:6:{i:0;s:37:"SELECT * FROM "items" WHERE "id"='18'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.951642;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1610104;}i:25;a:6:{i:0;s:37:"SELECT * FROM "types" ORDER BY "name"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.952196;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1764656;}i:26;a:6:{i:0;s:37:"SELECT * FROM "types" ORDER BY "name"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.952777;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1771112;}i:28;a:6:{i:0;s:2665:"SELECT
483 d.nspname AS table_schema,
484 c.relname AS table_name,
485 a.attname AS column_name,
486 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
487 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
488 a.attlen AS character_maximum_length,
489 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
490 a.atttypmod AS modifier,
491 a.attnotnull = false AS is_nullable,
492 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
493 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
494 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
495 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
496 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
500 WHEN 21 /*int2*/ THEN 16
501 WHEN 23 /*int4*/ THEN 32
502 WHEN 20 /*int8*/ THEN 64
503 WHEN 1700 /*numeric*/ THEN
504 CASE WHEN atttypmod = -1
506 ELSE ((atttypmod - 4) >> 16) & 65535
508 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
509 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
511 END AS numeric_precision,
513 WHEN atttypid IN (21, 23, 20) THEN 0
514 WHEN atttypid IN (1700) THEN
516 WHEN atttypmod = -1 THEN null
517 ELSE (atttypmod - 4) & 65535
520 END AS numeric_scale,
522 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
525 a.attnum = any (ct.conkey) as is_pkey,
526 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
529 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
530 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
531 LEFT JOIN pg_type t ON a.atttypid = t.oid
532 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
533 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
534 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
535 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
537 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
538 AND c.relname = 'types'
539 AND d.nspname = 'public'
541 a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.952924;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1790856;}i:29;a:6:{i:0;s:2665:"SELECT
542 d.nspname AS table_schema,
543 c.relname AS table_name,
544 a.attname AS column_name,
545 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
546 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
547 a.attlen AS character_maximum_length,
548 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
549 a.atttypmod AS modifier,
550 a.attnotnull = false AS is_nullable,
551 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
552 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
553 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
554 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
555 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
559 WHEN 21 /*int2*/ THEN 16
560 WHEN 23 /*int4*/ THEN 32
561 WHEN 20 /*int8*/ THEN 64
562 WHEN 1700 /*numeric*/ THEN
563 CASE WHEN atttypmod = -1
565 ELSE ((atttypmod - 4) >> 16) & 65535
567 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
568 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
570 END AS numeric_precision,
572 WHEN atttypid IN (21, 23, 20) THEN 0
573 WHEN atttypid IN (1700) THEN
575 WHEN atttypmod = -1 THEN null
576 ELSE (atttypmod - 4) & 65535
579 END AS numeric_scale,
581 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
584 a.attnum = any (ct.conkey) as is_pkey,
585 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
588 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
589 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
590 LEFT JOIN pg_type t ON a.atttypid = t.oid
591 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
592 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
593 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
594 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
596 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
597 AND c.relname = 'types'
598 AND d.nspname = 'public'
600 a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.95599;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1797768;}i:31;a:6:{i:0;s:873:"select
601 ct.conname as constraint_name,
602 a.attname as column_name,
603 fc.relname as foreign_table_name,
604 fns.nspname as foreign_table_schema,
605 fa.attname as foreign_column_name
607 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
608 FROM pg_constraint ct
610 inner join pg_class c on c.oid=ct.conrelid
611 inner join pg_namespace ns on c.relnamespace=ns.oid
612 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
613 left join pg_class fc on fc.oid=ct.confrelid
614 left join pg_namespace fns on fc.relnamespace=fns.oid
615 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
618 and c.relname='types'
619 and ns.nspname='public'
621 fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.956238;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1792960;}i:32;a:6:{i:0;s:873:"select
622 ct.conname as constraint_name,
623 a.attname as column_name,
624 fc.relname as foreign_table_name,
625 fns.nspname as foreign_table_schema,
626 fa.attname as foreign_column_name
628 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
629 FROM pg_constraint ct
631 inner join pg_class c on c.oid=ct.conrelid
632 inner join pg_namespace ns on c.relnamespace=ns.oid
633 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
634 left join pg_class fc on fc.oid=ct.confrelid
635 left join pg_namespace fns on fc.relnamespace=fns.oid
636 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
639 and c.relname='types'
640 and ns.nspname='public'
642 fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.958139;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1795280;}i:34;a:6:{i:0;s:38:"SELECT * FROM "status" ORDER BY "name"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.958487;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1811816;}i:35;a:6:{i:0;s:38:"SELECT * FROM "status" ORDER BY "name"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.958855;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1816712;}i:37;a:6:{i:0;s:2666:"SELECT
643 d.nspname AS table_schema,
644 c.relname AS table_name,
645 a.attname AS column_name,
646 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
647 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
648 a.attlen AS character_maximum_length,
649 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
650 a.atttypmod AS modifier,
651 a.attnotnull = false AS is_nullable,
652 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
653 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
654 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
655 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
656 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
660 WHEN 21 /*int2*/ THEN 16
661 WHEN 23 /*int4*/ THEN 32
662 WHEN 20 /*int8*/ THEN 64
663 WHEN 1700 /*numeric*/ THEN
664 CASE WHEN atttypmod = -1
666 ELSE ((atttypmod - 4) >> 16) & 65535
668 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
669 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
671 END AS numeric_precision,
673 WHEN atttypid IN (21, 23, 20) THEN 0
674 WHEN atttypid IN (1700) THEN
676 WHEN atttypmod = -1 THEN null
677 ELSE (atttypmod - 4) & 65535
680 END AS numeric_scale,
682 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
685 a.attnum = any (ct.conkey) as is_pkey,
686 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
689 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
690 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
691 LEFT JOIN pg_type t ON a.atttypid = t.oid
692 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
693 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
694 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
695 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
697 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
698 AND c.relname = 'status'
699 AND d.nspname = 'public'
701 a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.959037;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1836464;}i:38;a:6:{i:0;s:2666:"SELECT
702 d.nspname AS table_schema,
703 c.relname AS table_name,
704 a.attname AS column_name,
705 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
706 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
707 a.attlen AS character_maximum_length,
708 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
709 a.atttypmod AS modifier,
710 a.attnotnull = false AS is_nullable,
711 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
712 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
713 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
714 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
715 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
719 WHEN 21 /*int2*/ THEN 16
720 WHEN 23 /*int4*/ THEN 32
721 WHEN 20 /*int8*/ THEN 64
722 WHEN 1700 /*numeric*/ THEN
723 CASE WHEN atttypmod = -1
725 ELSE ((atttypmod - 4) >> 16) & 65535
727 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
728 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
730 END AS numeric_precision,
732 WHEN atttypid IN (21, 23, 20) THEN 0
733 WHEN atttypid IN (1700) THEN
735 WHEN atttypmod = -1 THEN null
736 ELSE (atttypmod - 4) & 65535
739 END AS numeric_scale,
741 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
744 a.attnum = any (ct.conkey) as is_pkey,
745 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
748 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
749 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
750 LEFT JOIN pg_type t ON a.atttypid = t.oid
751 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
752 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
753 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
754 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
756 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
757 AND c.relname = 'status'
758 AND d.nspname = 'public'
760 a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.962135;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1843328;}i:40;a:6:{i:0;s:874:"select
761 ct.conname as constraint_name,
762 a.attname as column_name,
763 fc.relname as foreign_table_name,
764 fns.nspname as foreign_table_schema,
765 fa.attname as foreign_column_name
767 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
768 FROM pg_constraint ct
770 inner join pg_class c on c.oid=ct.conrelid
771 inner join pg_namespace ns on c.relnamespace=ns.oid
772 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
773 left join pg_class fc on fc.oid=ct.confrelid
774 left join pg_namespace fns on fc.relnamespace=fns.oid
775 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
778 and c.relname='status'
779 and ns.nspname='public'
781 fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.96238;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1838520;}i:41;a:6:{i:0;s:874:"select
782 ct.conname as constraint_name,
783 a.attname as column_name,
784 fc.relname as foreign_table_name,
785 fns.nspname as foreign_table_schema,
786 fa.attname as foreign_column_name
788 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
789 FROM pg_constraint ct
791 inner join pg_class c on c.oid=ct.conrelid
792 inner join pg_namespace ns on c.relnamespace=ns.oid
793 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
794 left join pg_class fc on fc.oid=ct.confrelid
795 left join pg_namespace fns on fc.relnamespace=fns.oid
796 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
799 and c.relname='status'
800 and ns.nspname='public'
802 fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.964303;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1840840;}i:43;a:6:{i:0;s:41:"SELECT * FROM "locations" ORDER BY "name"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.964641;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1856432;}i:44;a:6:{i:0;s:41:"SELECT * FROM "locations" ORDER BY "name"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.965012;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1866280;}i:46;a:6:{i:0;s:2669:"SELECT
803 d.nspname AS table_schema,
804 c.relname AS table_name,
805 a.attname AS column_name,
806 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
807 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
808 a.attlen AS character_maximum_length,
809 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
810 a.atttypmod AS modifier,
811 a.attnotnull = false AS is_nullable,
812 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
813 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
814 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
815 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
816 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
820 WHEN 21 /*int2*/ THEN 16
821 WHEN 23 /*int4*/ THEN 32
822 WHEN 20 /*int8*/ THEN 64
823 WHEN 1700 /*numeric*/ THEN
824 CASE WHEN atttypmod = -1
826 ELSE ((atttypmod - 4) >> 16) & 65535
828 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
829 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
831 END AS numeric_precision,
833 WHEN atttypid IN (21, 23, 20) THEN 0
834 WHEN atttypid IN (1700) THEN
836 WHEN atttypmod = -1 THEN null
837 ELSE (atttypmod - 4) & 65535
840 END AS numeric_scale,
842 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
845 a.attnum = any (ct.conkey) as is_pkey,
846 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
849 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
850 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
851 LEFT JOIN pg_type t ON a.atttypid = t.oid
852 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
853 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
854 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
855 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
857 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
858 AND c.relname = 'locations'
859 AND d.nspname = 'public'
861 a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.965186;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1886008;}i:47;a:6:{i:0;s:2669:"SELECT
862 d.nspname AS table_schema,
863 c.relname AS table_name,
864 a.attname AS column_name,
865 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
866 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
867 a.attlen AS character_maximum_length,
868 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
869 a.atttypmod AS modifier,
870 a.attnotnull = false AS is_nullable,
871 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
872 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
873 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
874 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
875 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
879 WHEN 21 /*int2*/ THEN 16
880 WHEN 23 /*int4*/ THEN 32
881 WHEN 20 /*int8*/ THEN 64
882 WHEN 1700 /*numeric*/ THEN
883 CASE WHEN atttypmod = -1
885 ELSE ((atttypmod - 4) >> 16) & 65535
887 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
888 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
890 END AS numeric_precision,
892 WHEN atttypid IN (21, 23, 20) THEN 0
893 WHEN atttypid IN (1700) THEN
895 WHEN atttypmod = -1 THEN null
896 ELSE (atttypmod - 4) & 65535
899 END AS numeric_scale,
901 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
904 a.attnum = any (ct.conkey) as is_pkey,
905 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
908 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
909 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
910 LEFT JOIN pg_type t ON a.atttypid = t.oid
911 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
912 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
913 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
914 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
916 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
917 AND c.relname = 'locations'
918 AND d.nspname = 'public'
920 a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.968275;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1894584;}i:49;a:6:{i:0;s:877:"select
921 ct.conname as constraint_name,
922 a.attname as column_name,
923 fc.relname as foreign_table_name,
924 fns.nspname as foreign_table_schema,
925 fa.attname as foreign_column_name
927 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
928 FROM pg_constraint ct
930 inner join pg_class c on c.oid=ct.conrelid
931 inner join pg_namespace ns on c.relnamespace=ns.oid
932 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
933 left join pg_class fc on fc.oid=ct.confrelid
934 left join pg_namespace fns on fc.relnamespace=fns.oid
935 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
938 and c.relname='locations'
939 and ns.nspname='public'
941 fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.968512;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1888712;}i:50;a:6:{i:0;s:877:"select
942 ct.conname as constraint_name,
943 a.attname as column_name,
944 fc.relname as foreign_table_name,
945 fns.nspname as foreign_table_schema,
946 fa.attname as foreign_column_name
948 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
949 FROM pg_constraint ct
951 inner join pg_class c on c.oid=ct.conrelid
952 inner join pg_namespace ns on c.relnamespace=ns.oid
953 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
954 left join pg_class fc on fc.oid=ct.confrelid
955 left join pg_namespace fns on fc.relnamespace=fns.oid
956 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
959 and c.relname='locations'
960 and ns.nspname='public'
962 fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.97041;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1891912;}}}";s:2:"db";s:43205:"a:1:{s:8:"messages";a:24:{i:14;a:6:{i:0;s:2665:"SELECT
963 d.nspname AS table_schema,
964 c.relname AS table_name,
965 a.attname AS column_name,
966 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
967 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
968 a.attlen AS character_maximum_length,
969 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
970 a.atttypmod AS modifier,
971 a.attnotnull = false AS is_nullable,
972 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
973 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
974 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
975 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
976 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
980 WHEN 21 /*int2*/ THEN 16
981 WHEN 23 /*int4*/ THEN 32
982 WHEN 20 /*int8*/ THEN 64
983 WHEN 1700 /*numeric*/ THEN
984 CASE WHEN atttypmod = -1
986 ELSE ((atttypmod - 4) >> 16) & 65535
988 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
989 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
991 END AS numeric_precision,
993 WHEN atttypid IN (21, 23, 20) THEN 0
994 WHEN atttypid IN (1700) THEN
996 WHEN atttypmod = -1 THEN null
997 ELSE (atttypmod - 4) & 65535
1000 END AS numeric_scale,
1002 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
1005 a.attnum = any (ct.conkey) as is_pkey,
1006 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
1009 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
1010 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
1011 LEFT JOIN pg_type t ON a.atttypid = t.oid
1012 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
1013 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
1014 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
1015 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
1017 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
1018 AND c.relname = 'items'
1019 AND d.nspname = 'public'
1021 a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.941923;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1559048;}i:15;a:6:{i:0;s:2665:"SELECT
1022 d.nspname AS table_schema,
1023 c.relname AS table_name,
1024 a.attname AS column_name,
1025 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
1026 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
1027 a.attlen AS character_maximum_length,
1028 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
1029 a.atttypmod AS modifier,
1030 a.attnotnull = false AS is_nullable,
1031 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
1032 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
1033 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
1034 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
1035 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
1039 WHEN 21 /*int2*/ THEN 16
1040 WHEN 23 /*int4*/ THEN 32
1041 WHEN 20 /*int8*/ THEN 64
1042 WHEN 1700 /*numeric*/ THEN
1043 CASE WHEN atttypmod = -1
1045 ELSE ((atttypmod - 4) >> 16) & 65535
1047 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
1048 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
1050 END AS numeric_precision,
1052 WHEN atttypid IN (21, 23, 20) THEN 0
1053 WHEN atttypid IN (1700) THEN
1055 WHEN atttypmod = -1 THEN null
1056 ELSE (atttypmod - 4) & 65535
1059 END AS numeric_scale,
1061 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
1064 a.attnum = any (ct.conkey) as is_pkey,
1065 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
1068 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
1069 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
1070 LEFT JOIN pg_type t ON a.atttypid = t.oid
1071 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
1072 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
1073 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
1074 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
1076 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
1077 AND c.relname = 'items'
1078 AND d.nspname = 'public'
1080 a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.948296;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1584896;}i:17;a:6:{i:0;s:873:"select
1081 ct.conname as constraint_name,
1082 a.attname as column_name,
1083 fc.relname as foreign_table_name,
1084 fns.nspname as foreign_table_schema,
1085 fa.attname as foreign_column_name
1087 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
1088 FROM pg_constraint ct
1090 inner join pg_class c on c.oid=ct.conrelid
1091 inner join pg_namespace ns on c.relnamespace=ns.oid
1092 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
1093 left join pg_class fc on fc.oid=ct.confrelid
1094 left join pg_namespace fns on fc.relnamespace=fns.oid
1095 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
1098 and c.relname='items'
1099 and ns.nspname='public'
1101 fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.948598;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1577216;}i:18;a:6:{i:0;s:873:"select
1102 ct.conname as constraint_name,
1103 a.attname as column_name,
1104 fc.relname as foreign_table_name,
1105 fns.nspname as foreign_table_schema,
1106 fa.attname as foreign_column_name
1108 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
1109 FROM pg_constraint ct
1111 inner join pg_class c on c.oid=ct.conrelid
1112 inner join pg_namespace ns on c.relnamespace=ns.oid
1113 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
1114 left join pg_class fc on fc.oid=ct.confrelid
1115 left join pg_namespace fns on fc.relnamespace=fns.oid
1116 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
1119 and c.relname='items'
1120 and ns.nspname='public'
1122 fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.950787;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1581160;}i:20;a:6:{i:0;s:37:"SELECT * FROM "items" WHERE "id"='18'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.951113;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1606480;}i:21;a:6:{i:0;s:37:"SELECT * FROM "items" WHERE "id"='18'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.951642;i:4;a:2:{i:0;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:121;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:1;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:87;s:8:"function";s:9:"findModel";s:5:"class";s:31:"app\controllers\ItemsController";s:4:"type";s:2:"->";}}i:5;i:1610104;}i:25;a:6:{i:0;s:37:"SELECT * FROM "types" ORDER BY "name"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.952196;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1764656;}i:26;a:6:{i:0;s:37:"SELECT * FROM "types" ORDER BY "name"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.952777;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1771112;}i:28;a:6:{i:0;s:2665:"SELECT
1123 d.nspname AS table_schema,
1124 c.relname AS table_name,
1125 a.attname AS column_name,
1126 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
1127 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
1128 a.attlen AS character_maximum_length,
1129 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
1130 a.atttypmod AS modifier,
1131 a.attnotnull = false AS is_nullable,
1132 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
1133 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
1134 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
1135 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
1136 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
1140 WHEN 21 /*int2*/ THEN 16
1141 WHEN 23 /*int4*/ THEN 32
1142 WHEN 20 /*int8*/ THEN 64
1143 WHEN 1700 /*numeric*/ THEN
1144 CASE WHEN atttypmod = -1
1146 ELSE ((atttypmod - 4) >> 16) & 65535
1148 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
1149 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
1151 END AS numeric_precision,
1153 WHEN atttypid IN (21, 23, 20) THEN 0
1154 WHEN atttypid IN (1700) THEN
1156 WHEN atttypmod = -1 THEN null
1157 ELSE (atttypmod - 4) & 65535
1160 END AS numeric_scale,
1162 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
1165 a.attnum = any (ct.conkey) as is_pkey,
1166 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
1169 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
1170 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
1171 LEFT JOIN pg_type t ON a.atttypid = t.oid
1172 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
1173 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
1174 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
1175 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
1177 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
1178 AND c.relname = 'types'
1179 AND d.nspname = 'public'
1181 a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.952924;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1790856;}i:29;a:6:{i:0;s:2665:"SELECT
1182 d.nspname AS table_schema,
1183 c.relname AS table_name,
1184 a.attname AS column_name,
1185 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
1186 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
1187 a.attlen AS character_maximum_length,
1188 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
1189 a.atttypmod AS modifier,
1190 a.attnotnull = false AS is_nullable,
1191 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
1192 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
1193 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
1194 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
1195 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
1199 WHEN 21 /*int2*/ THEN 16
1200 WHEN 23 /*int4*/ THEN 32
1201 WHEN 20 /*int8*/ THEN 64
1202 WHEN 1700 /*numeric*/ THEN
1203 CASE WHEN atttypmod = -1
1205 ELSE ((atttypmod - 4) >> 16) & 65535
1207 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
1208 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
1210 END AS numeric_precision,
1212 WHEN atttypid IN (21, 23, 20) THEN 0
1213 WHEN atttypid IN (1700) THEN
1215 WHEN atttypmod = -1 THEN null
1216 ELSE (atttypmod - 4) & 65535
1219 END AS numeric_scale,
1221 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
1224 a.attnum = any (ct.conkey) as is_pkey,
1225 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
1228 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
1229 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
1230 LEFT JOIN pg_type t ON a.atttypid = t.oid
1231 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
1232 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
1233 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
1234 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
1236 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
1237 AND c.relname = 'types'
1238 AND d.nspname = 'public'
1240 a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.95599;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1797768;}i:31;a:6:{i:0;s:873:"select
1241 ct.conname as constraint_name,
1242 a.attname as column_name,
1243 fc.relname as foreign_table_name,
1244 fns.nspname as foreign_table_schema,
1245 fa.attname as foreign_column_name
1247 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
1248 FROM pg_constraint ct
1250 inner join pg_class c on c.oid=ct.conrelid
1251 inner join pg_namespace ns on c.relnamespace=ns.oid
1252 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
1253 left join pg_class fc on fc.oid=ct.confrelid
1254 left join pg_namespace fns on fc.relnamespace=fns.oid
1255 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
1258 and c.relname='types'
1259 and ns.nspname='public'
1261 fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.956238;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1792960;}i:32;a:6:{i:0;s:873:"select
1262 ct.conname as constraint_name,
1263 a.attname as column_name,
1264 fc.relname as foreign_table_name,
1265 fns.nspname as foreign_table_schema,
1266 fa.attname as foreign_column_name
1268 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
1269 FROM pg_constraint ct
1271 inner join pg_class c on c.oid=ct.conrelid
1272 inner join pg_namespace ns on c.relnamespace=ns.oid
1273 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
1274 left join pg_class fc on fc.oid=ct.confrelid
1275 left join pg_namespace fns on fc.relnamespace=fns.oid
1276 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
1279 and c.relname='types'
1280 and ns.nspname='public'
1282 fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.958139;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:21;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1795280;}i:34;a:6:{i:0;s:38:"SELECT * FROM "status" ORDER BY "name"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.958487;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1811816;}i:35;a:6:{i:0;s:38:"SELECT * FROM "status" ORDER BY "name"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.958855;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1816712;}i:37;a:6:{i:0;s:2666:"SELECT
1283 d.nspname AS table_schema,
1284 c.relname AS table_name,
1285 a.attname AS column_name,
1286 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
1287 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
1288 a.attlen AS character_maximum_length,
1289 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
1290 a.atttypmod AS modifier,
1291 a.attnotnull = false AS is_nullable,
1292 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
1293 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
1294 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
1295 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
1296 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
1300 WHEN 21 /*int2*/ THEN 16
1301 WHEN 23 /*int4*/ THEN 32
1302 WHEN 20 /*int8*/ THEN 64
1303 WHEN 1700 /*numeric*/ THEN
1304 CASE WHEN atttypmod = -1
1306 ELSE ((atttypmod - 4) >> 16) & 65535
1308 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
1309 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
1311 END AS numeric_precision,
1313 WHEN atttypid IN (21, 23, 20) THEN 0
1314 WHEN atttypid IN (1700) THEN
1316 WHEN atttypmod = -1 THEN null
1317 ELSE (atttypmod - 4) & 65535
1320 END AS numeric_scale,
1322 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
1325 a.attnum = any (ct.conkey) as is_pkey,
1326 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
1329 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
1330 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
1331 LEFT JOIN pg_type t ON a.atttypid = t.oid
1332 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
1333 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
1334 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
1335 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
1337 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
1338 AND c.relname = 'status'
1339 AND d.nspname = 'public'
1341 a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.959037;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1836464;}i:38;a:6:{i:0;s:2666:"SELECT
1342 d.nspname AS table_schema,
1343 c.relname AS table_name,
1344 a.attname AS column_name,
1345 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
1346 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
1347 a.attlen AS character_maximum_length,
1348 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
1349 a.atttypmod AS modifier,
1350 a.attnotnull = false AS is_nullable,
1351 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
1352 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
1353 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
1354 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
1355 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
1359 WHEN 21 /*int2*/ THEN 16
1360 WHEN 23 /*int4*/ THEN 32
1361 WHEN 20 /*int8*/ THEN 64
1362 WHEN 1700 /*numeric*/ THEN
1363 CASE WHEN atttypmod = -1
1365 ELSE ((atttypmod - 4) >> 16) & 65535
1367 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
1368 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
1370 END AS numeric_precision,
1372 WHEN atttypid IN (21, 23, 20) THEN 0
1373 WHEN atttypid IN (1700) THEN
1375 WHEN atttypmod = -1 THEN null
1376 ELSE (atttypmod - 4) & 65535
1379 END AS numeric_scale,
1381 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
1384 a.attnum = any (ct.conkey) as is_pkey,
1385 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
1388 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
1389 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
1390 LEFT JOIN pg_type t ON a.atttypid = t.oid
1391 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
1392 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
1393 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
1394 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
1396 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
1397 AND c.relname = 'status'
1398 AND d.nspname = 'public'
1400 a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.962135;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1843328;}i:40;a:6:{i:0;s:874:"select
1401 ct.conname as constraint_name,
1402 a.attname as column_name,
1403 fc.relname as foreign_table_name,
1404 fns.nspname as foreign_table_schema,
1405 fa.attname as foreign_column_name
1407 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
1408 FROM pg_constraint ct
1410 inner join pg_class c on c.oid=ct.conrelid
1411 inner join pg_namespace ns on c.relnamespace=ns.oid
1412 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
1413 left join pg_class fc on fc.oid=ct.confrelid
1414 left join pg_namespace fns on fc.relnamespace=fns.oid
1415 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
1418 and c.relname='status'
1419 and ns.nspname='public'
1421 fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.96238;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1838520;}i:41;a:6:{i:0;s:874:"select
1422 ct.conname as constraint_name,
1423 a.attname as column_name,
1424 fc.relname as foreign_table_name,
1425 fns.nspname as foreign_table_schema,
1426 fa.attname as foreign_column_name
1428 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
1429 FROM pg_constraint ct
1431 inner join pg_class c on c.oid=ct.conrelid
1432 inner join pg_namespace ns on c.relnamespace=ns.oid
1433 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
1434 left join pg_class fc on fc.oid=ct.confrelid
1435 left join pg_namespace fns on fc.relnamespace=fns.oid
1436 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
1439 and c.relname='status'
1440 and ns.nspname='public'
1442 fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.964303;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1840840;}i:43;a:6:{i:0;s:41:"SELECT * FROM "locations" ORDER BY "name"";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.964641;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1856432;}i:44;a:6:{i:0;s:41:"SELECT * FROM "locations" ORDER BY "name"";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.965012;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1866280;}i:46;a:6:{i:0;s:2669:"SELECT
1443 d.nspname AS table_schema,
1444 c.relname AS table_name,
1445 a.attname AS column_name,
1446 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
1447 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
1448 a.attlen AS character_maximum_length,
1449 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
1450 a.atttypmod AS modifier,
1451 a.attnotnull = false AS is_nullable,
1452 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
1453 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
1454 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
1455 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
1456 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
1460 WHEN 21 /*int2*/ THEN 16
1461 WHEN 23 /*int4*/ THEN 32
1462 WHEN 20 /*int8*/ THEN 64
1463 WHEN 1700 /*numeric*/ THEN
1464 CASE WHEN atttypmod = -1
1466 ELSE ((atttypmod - 4) >> 16) & 65535
1468 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
1469 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
1471 END AS numeric_precision,
1473 WHEN atttypid IN (21, 23, 20) THEN 0
1474 WHEN atttypid IN (1700) THEN
1476 WHEN atttypmod = -1 THEN null
1477 ELSE (atttypmod - 4) & 65535
1480 END AS numeric_scale,
1482 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
1485 a.attnum = any (ct.conkey) as is_pkey,
1486 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
1489 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
1490 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
1491 LEFT JOIN pg_type t ON a.atttypid = t.oid
1492 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
1493 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
1494 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
1495 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
1497 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
1498 AND c.relname = 'locations'
1499 AND d.nspname = 'public'
1501 a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.965186;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1886008;}i:47;a:6:{i:0;s:2669:"SELECT
1502 d.nspname AS table_schema,
1503 c.relname AS table_name,
1504 a.attname AS column_name,
1505 COALESCE(td.typname, tb.typname, t.typname) AS data_type,
1506 COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
1507 a.attlen AS character_maximum_length,
1508 pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
1509 a.atttypmod AS modifier,
1510 a.attnotnull = false AS is_nullable,
1511 CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
1512 coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc,
1513 pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
1514 CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
1515 THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
1519 WHEN 21 /*int2*/ THEN 16
1520 WHEN 23 /*int4*/ THEN 32
1521 WHEN 20 /*int8*/ THEN 64
1522 WHEN 1700 /*numeric*/ THEN
1523 CASE WHEN atttypmod = -1
1525 ELSE ((atttypmod - 4) >> 16) & 65535
1527 WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
1528 WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
1530 END AS numeric_precision,
1532 WHEN atttypid IN (21, 23, 20) THEN 0
1533 WHEN atttypid IN (1700) THEN
1535 WHEN atttypmod = -1 THEN null
1536 ELSE (atttypmod - 4) & 65535
1539 END AS numeric_scale,
1541 information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
1544 a.attnum = any (ct.conkey) as is_pkey,
1545 COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
1548 LEFT JOIN pg_attribute a ON a.attrelid = c.oid
1549 LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
1550 LEFT JOIN pg_type t ON a.atttypid = t.oid
1551 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
1552 LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
1553 LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
1554 LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
1556 a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
1557 AND c.relname = 'locations'
1558 AND d.nspname = 'public'
1560 a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.968275;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1894584;}i:49;a:6:{i:0;s:877:"select
1561 ct.conname as constraint_name,
1562 a.attname as column_name,
1563 fc.relname as foreign_table_name,
1564 fns.nspname as foreign_table_schema,
1565 fa.attname as foreign_column_name
1567 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
1568 FROM pg_constraint ct
1570 inner join pg_class c on c.oid=ct.conrelid
1571 inner join pg_namespace ns on c.relnamespace=ns.oid
1572 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
1573 left join pg_class fc on fc.oid=ct.confrelid
1574 left join pg_namespace fns on fc.relnamespace=fns.oid
1575 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
1578 and c.relname='locations'
1579 and ns.nspname='public'
1581 fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.968512;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1888712;}i:50;a:6:{i:0;s:877:"select
1582 ct.conname as constraint_name,
1583 a.attname as column_name,
1584 fc.relname as foreign_table_name,
1585 fns.nspname as foreign_table_schema,
1586 fa.attname as foreign_column_name
1588 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
1589 FROM pg_constraint ct
1591 inner join pg_class c on c.oid=ct.conrelid
1592 inner join pg_namespace ns on c.relnamespace=ns.oid
1593 inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
1594 left join pg_class fc on fc.oid=ct.confrelid
1595 left join pg_namespace fns on fc.relnamespace=fns.oid
1596 left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
1599 and c.relname='locations'
1600 and ns.nspname='public'
1602 fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1597995893.97041;i:4;a:3:{i:0;a:5:{s:4:"file";s:43:"/var/www/invent/basic/views/items/_form.php";s:4:"line";i:28;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:44:"/var/www/invent/basic/views/items/update.php";s:4:"line";i:20;s:8:"function";s:6:"render";s:5:"class";s:13:"yii\base\View";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:53:"/var/www/invent/basic/controllers/ItemsController.php";s:4:"line";i:94;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}i:5;i:1891912;}}}";s:5:"event";s:21175:"a:121:{i:0;a:5:{s:4:"time";d:1597995893.932895;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:1597995893.933186;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:1597995893.933262;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:31:"app\controllers\ItemsController";}i:3;a:5:{s:4:"time";d:1597995893.933634;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:4;a:5:{s:4:"time";d:1597995893.941836;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:5;a:5:{s:4:"time";d:1597995893.951813;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:"app\models\Items";}i:6;a:5:{s:4:"time";d:1597995893.951848;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"app\models\Items";}i:7;a:5:{s:4:"time";d:1597995893.951947;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:8;a:5:{s:4:"time";d:1597995893.952092;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:9;a:5:{s:4:"time";d:1597995893.952138;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:10;a:5:{s:4:"time";d:1597995893.95286;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:"app\models\Types";}i:11;a:5:{s:4:"time";d:1597995893.958276;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:"app\models\Types";}i:12;a:5:{s:4:"time";d:1597995893.958291;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:"app\models\Types";}i:13;a:5:{s:4:"time";d:1597995893.958301;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:"app\models\Types";}i:14;a:5:{s:4:"time";d:1597995893.958309;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:"app\models\Types";}i:15;a:5:{s:4:"time";d:1597995893.958317;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:"app\models\Types";}i:16;a:5:{s:4:"time";d:1597995893.958324;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:"app\models\Types";}i:17;a:5:{s:4:"time";d:1597995893.958332;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:"app\models\Types";}i:18;a:5:{s:4:"time";d:1597995893.958339;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:"app\models\Types";}i:19;a:5:{s:4:"time";d:1597995893.958348;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"app\models\Types";}i:20;a:5:{s:4:"time";d:1597995893.958351;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"app\models\Types";}i:21;a:5:{s:4:"time";d:1597995893.958354;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"app\models\Types";}i:22;a:5:{s:4:"time";d:1597995893.958357;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"app\models\Types";}i:23;a:5:{s:4:"time";d:1597995893.95836;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"app\models\Types";}i:24;a:5:{s:4:"time";d:1597995893.958363;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"app\models\Types";}i:25;a:5:{s:4:"time";d:1597995893.958366;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"app\models\Types";}i:26;a:5:{s:4:"time";d:1597995893.958369;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"app\models\Types";}i:27;a:5:{s:4:"time";d:1597995893.958372;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:16:"app\models\Types";}i:28;a:5:{s:4:"time";d:1597995893.958432;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:29;a:5:{s:4:"time";d:1597995893.958971;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Status";}i:30;a:5:{s:4:"time";d:1597995893.96447;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Status";}i:31;a:5:{s:4:"time";d:1597995893.964485;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Status";}i:32;a:5:{s:4:"time";d:1597995893.964495;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Status";}i:33;a:5:{s:4:"time";d:1597995893.964504;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Status";}i:34;a:5:{s:4:"time";d:1597995893.964511;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Status";}i:35;a:5:{s:4:"time";d:1597995893.96452;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Status";}i:36;a:5:{s:4:"time";d:1597995893.964523;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Status";}i:37;a:5:{s:4:"time";d:1597995893.964526;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Status";}i:38;a:5:{s:4:"time";d:1597995893.964529;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Status";}i:39;a:5:{s:4:"time";d:1597995893.964532;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Status";}i:40;a:5:{s:4:"time";d:1597995893.964535;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\models\Status";}i:41;a:5:{s:4:"time";d:1597995893.964585;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:42;a:5:{s:4:"time";d:1597995893.965123;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:43;a:5:{s:4:"time";d:1597995893.970598;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:44;a:5:{s:4:"time";d:1597995893.970614;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:45;a:5:{s:4:"time";d:1597995893.970624;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:46;a:5:{s:4:"time";d:1597995893.970633;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:47;a:5:{s:4:"time";d:1597995893.970641;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:48;a:5:{s:4:"time";d:1597995893.970649;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:49;a:5:{s:4:"time";d:1597995893.970657;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:50;a:5:{s:4:"time";d:1597995893.970665;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:51;a:5:{s:4:"time";d:1597995893.970673;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:52;a:5:{s:4:"time";d:1597995893.970681;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:53;a:5:{s:4:"time";d:1597995893.970688;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:54;a:5:{s:4:"time";d:1597995893.970696;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:55;a:5:{s:4:"time";d:1597995893.970703;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:56;a:5:{s:4:"time";d:1597995893.970711;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:57;a:5:{s:4:"time";d:1597995893.970718;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:58;a:5:{s:4:"time";d:1597995893.970727;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:59;a:5:{s:4:"time";d:1597995893.97073;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:60;a:5:{s:4:"time";d:1597995893.970733;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:61;a:5:{s:4:"time";d:1597995893.970736;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:62;a:5:{s:4:"time";d:1597995893.970739;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:63;a:5:{s:4:"time";d:1597995893.970742;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:64;a:5:{s:4:"time";d:1597995893.970745;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:65;a:5:{s:4:"time";d:1597995893.970749;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:66;a:5:{s:4:"time";d:1597995893.970752;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:67;a:5:{s:4:"time";d:1597995893.970755;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:68;a:5:{s:4:"time";d:1597995893.970758;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:69;a:5:{s:4:"time";d:1597995893.970761;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:70;a:5:{s:4:"time";d:1597995893.970764;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:71;a:5:{s:4:"time";d:1597995893.970767;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:72;a:5:{s:4:"time";d:1597995893.97077;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:73;a:5:{s:4:"time";d:1597995893.970773;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"app\models\Locations";}i:74;a:5:{s:4:"time";d:1597995893.970839;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:75;a:5:{s:4:"time";d:1597995893.971292;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:76;a:5:{s:4:"time";d:1597995893.971305;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:77;a:5:{s:4:"time";d:1597995893.971311;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:78;a:5:{s:4:"time";d:1597995893.971317;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:79;a:5:{s:4:"time";d:1597995893.971322;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:80;a:5:{s:4:"time";d:1597995893.971327;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:81;a:5:{s:4:"time";d:1597995893.971332;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:82;a:5:{s:4:"time";d:1597995893.971338;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:83;a:5:{s:4:"time";d:1597995893.971342;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:84;a:5:{s:4:"time";d:1597995893.971348;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:85;a:5:{s:4:"time";d:1597995893.971354;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:86;a:5:{s:4:"time";d:1597995893.971359;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:87;a:5:{s:4:"time";d:1597995893.971364;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:88;a:5:{s:4:"time";d:1597995893.971369;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:89;a:5:{s:4:"time";d:1597995893.971374;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:90;a:5:{s:4:"time";d:1597995893.973618;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\jui\DatePicker";}i:91;a:5:{s:4:"time";d:1597995893.973631;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\jui\DatePicker";}i:92;a:5:{s:4:"time";d:1597995893.97386;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\jui\DatePicker";}i:93;a:5:{s:4:"time";d:1597995893.97459;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:94;a:5:{s:4:"time";d:1597995893.974729;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:22:"yii\widgets\ActiveForm";}i:95;a:5:{s:4:"time";d:1597995893.974747;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:96;a:5:{s:4:"time";d:1597995893.974757;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:97;a:5:{s:4:"time";d:1597995893.974786;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:98;a:5:{s:4:"time";d:1597995893.974869;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:99;a:5:{s:4:"time";d:1597995893.974918;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:100;a:5:{s:4:"time";d:1597995893.974974;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"yii\bootstrap\NavBar";}i:101;a:5:{s:4:"time";d:1597995893.975095;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\bootstrap\Nav";}i:102;a:5:{s:4:"time";d:1597995893.975111;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\bootstrap\Nav";}i:103;a:5:{s:4:"time";d:1597995893.975155;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\bootstrap\Nav";}i:104;a:5:{s:4:"time";d:1597995893.975163;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"yii\bootstrap\NavBar";}i:105;a:5:{s:4:"time";d:1597995893.975199;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:20:"yii\bootstrap\NavBar";}i:106;a:5:{s:4:"time";d:1597995893.97522;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"yii\widgets\Breadcrumbs";}i:107;a:5:{s:4:"time";d:1597995893.975224;s:4:"name";s:9:"beforeRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"yii\widgets\Breadcrumbs";}i:108;a:5:{s:4:"time";d:1597995893.975255;s:4:"name";s:8:"afterRun";s:5:"class";s:20:"yii\base\WidgetEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:23:"yii\widgets\Breadcrumbs";}i:109;a:5:{s:4:"time";d:1597995893.975281;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:17:"app\widgets\Alert";}i:110;a:5:{s:4:"time";d:1597995893.975286;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:"app\widgets\Alert";}i:111;a:5:{s:4:"time";d:1597995893.975295;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:"app\widgets\Alert";}i:112;a:5:{s:4:"time";d:1597995893.975418;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:113;a:5:{s:4:"time";d:1597995893.9755;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:114;a:5:{s:4:"time";d:1597995893.975604;s:4:"name";s:11:"afterRender";s:5:"class";s:18:"yii\base\ViewEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\View";}i:115;a:5:{s:4:"time";d:1597995893.975614;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:31:"app\controllers\ItemsController";}i:116;a:5:{s:4:"time";d:1597995893.975619;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:117;a:5:{s:4:"time";d:1597995893.975626;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:118;a:5:{s:4:"time";d:1597995893.97563;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:119;a:5:{s:4:"time";d:1597995893.975689;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:120;a:5:{s:4:"time";d:1597995893.976608;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:3653:"a:9:{s:30:"yii\validators\ValidationAsset";a:9:{s:10:"sourcePath";s:48:"/var/www/invent/basic/vendor/yiisoft/yii2/assets";s:2:"js";a:1:{i:0;s:17:"yii.validation.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:31:"yii\jui\DatePickerLanguageAsset";a:11:{s:10:"sourcePath";s:50:"/var/www/invent/basic/vendor/bower-asset/jquery-ui";s:12:"autoGenerate";b:1;s:8:"language";s:2:"ru";s:7:"depends";a:1:{i:0;s:16:"yii\jui\JuiAsset";}s:8:"basePath";s:41:"/var/www/invent/basic/web/assets/93a9ea71";s:7:"baseUrl";s:23:"/invent/assets/93a9ea71";s:2:"js";a:1:{i:0;s:24:"ui/i18n/datepicker-ru.js";}s:3:"css";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:16:"yii\jui\JuiAsset";a:9:{s:10:"sourcePath";s:50:"/var/www/invent/basic/vendor/bower-asset/jquery-ui";s:2:"js";a:1:{i:0;s:12:"jquery-ui.js";}s:3:"css";a:1:{i:0;s:13:"jquery-ui.css";}s:7:"depends";a:1:{i:0;s:19:"yii\web\JqueryAsset";}s:8:"basePath";s:41:"/var/www/invent/basic/web/assets/93a9ea71";s:7:"baseUrl";s:23:"/invent/assets/93a9ea71";s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:27:"yii\widgets\ActiveFormAsset";a:9:{s:10:"sourcePath";s:48:"/var/www/invent/basic/vendor/yiisoft/yii2/assets";s:2:"js";a:1:{i:0;s:17:"yii.activeForm.js";}s:7:"depends";a:1:{i:0;s:16:"yii\web\YiiAsset";}s:8:"basePath";s: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:"app\assets\AppAsset";a:9:{s:8:"basePath";s:25:"/var/www/invent/basic/web";s:7:"baseUrl";s:7:"/invent";s:3:"css";a:1:{i:0;s:12:"css/site.css";}s:2:"js";a:0:{}s:7:"depends";a:2:{i:0;s:16:"yii\web\YiiAsset";i:1;s:28:"yii\bootstrap\BootstrapAsset";}s:10:"sourcePath";N;s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:28:"yii\bootstrap\BootstrapAsset";a:9:{s:10:"sourcePath";s:55:"/var/www/invent/basic/vendor/bower-asset/bootstrap/dist";s:3:"css";a:1:{i:0;s:17:"css/bootstrap.css";}s:8:"basePath";s:41:"/var/www/invent/basic/web/assets/511a52a0";s:7:"baseUrl";s:23:"/invent/assets/511a52a0";s:7:"depends";a:0:{}s:2:"js";a:0:{}s:9:"jsOptions";a:0:{}s:10:"cssOptions";a:0:{}s:14:"publishOptions";a:0:{}}s:34:"yii\bootstrap\BootstrapPluginAsset";a:9:{s:10:"sourcePath";s:55:"/var/www/invent/basic/vendor/bower-asset/bootstrap/dist";s:2:"js";a:1:{i:0;s:15:"js/bootstrap.js";}s:7:"depends";a:2:{i:0;s:19:"yii\web\JqueryAsset";i:1;s:28:"yii\bootstrap\BootstrapAsset";}s:8:"basePath";s:41:"/var/www/invent/basic/web/assets/511a52a0";s:7:"baseUrl";s:23:"/invent/assets/511a52a0";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:1597995893.930269;s:3:"end";d:1597995893.977617;s:6:"memory";i:2253472;}";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:"5f3f7b75e3b65";s:3:"url";s:59:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=18";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1597995893.929;s:10:"statusCode";i:200;s:8:"sqlCount";i:12;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2253472;s:14:"processingTime";d:0.04676389694213867;}s:10:"exceptions";a:0:{}}