a:13:{s:6:"config";s:1915:"a:5:{s:10:"phpVersion";s:5:"7.3.0";s:10:"yiiVersion";s:6:"2.0.52";s:11:"application";a:8:{s:3:"yii";s:6:"2.0.52";s:4:"name";s:14:"My Application";s:7:"version";s:3:"1.0";s:8:"language";s:5:"en-US";s:14:"sourceLanguage";s:5:"en-US";s:7:"charset";s:5:"UTF-8";s:3:"env";s:3:"dev";s:5:"debug";b:1;}s:3:"php";a:5:{s:7:"version";s:5:"7.3.0";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;s:9:"memcached";b:0;}s:10:"extensions";a:7:{s:14:"sizeg/yii2-jwt";a:3:{s:4:"name";s:14:"sizeg/yii2-jwt";s:7:"version";s:7:"2.0.2.0";s:5:"alias";a:1:{s:10:"@sizeg/jwt";s:57:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt";}}s:23:"yiisoft/yii2-bootstrap4";a:3:{s:4:"name";s:23:"yiisoft/yii2-bootstrap4";s:7:"version";s:8:"2.0.12.0";s:5:"alias";a:1:{s:15:"@yii/bootstrap4";s:70:"/opt/lampp/htdocs/servicios.apirest/vendor/yiisoft/yii2-bootstrap4/src";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:65:"/opt/lampp/htdocs/servicios.apirest/vendor/yiisoft/yii2-faker/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.1.26.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:65:"/opt/lampp/htdocs/servicios.apirest/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.2.7.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:63:"/opt/lampp/htdocs/servicios.apirest/vendor/yiisoft/yii2-gii/src";}}s:23:"yiisoft/yii2-httpclient";a:3:{s:4:"name";s:23:"yiisoft/yii2-httpclient";s:7:"version";s:8:"2.0.16.0";s:5:"alias";a:1:{s:15:"@yii/httpclient";s:70:"/opt/lampp/htdocs/servicios.apirest/vendor/yiisoft/yii2-httpclient/src";}}s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.1.3.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:71:"/opt/lampp/htdocs/servicios.apirest/vendor/yiisoft/yii2-swiftmailer/src";}}}}";s:3:"log";s:56681:"a:1:{s:8:"messages";a:45:{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:1793224106.1347939968109130859375;i:4;a:0:{}i:5;i:2738232;}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:1793224106.134809017181396484375;i:4;a:0:{}i:5;i:2739408;}i:2;a:6:{i:0;s:44:"Bootstrap with yii\debug\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1793224106.1396820545196533203125;i:4;a:0:{}i:5;i:3490856;}i:3;a:6:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1793224106.1418840885162353515625;i:4;a:0:{}i:5;i:3877480;}i:4;a:6:{i:0;s:42:"Bootstrap with yii\gii\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1793224106.142096996307373046875;i:4;a:0:{}i:5;i:3902368;}i:12;a:6:{i:0;s:47:"Route requested: 'apiv1/sale/list-report-excel'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1793224106.1435410976409912109375;i:4;a:0:{}i:5;i:4282992;}i:13;a:6:{i:0;s:21:"Loading module: apiv1";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1793224106.14354801177978515625;i:4;a:0:{}i:5;i:4284624;}i:14;a:6:{i:0;s:42:"Route to run: apiv1/sale/list-report-excel";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1793224106.1466310024261474609375;i:4;a:0:{}i:5;i:4714904;}i:15;a:6:{i:0;s:68:"Opening DB connection: pgsql:host=2.24.217.134;dbname=0_iooxs_access";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1793224106.1576368808746337890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:91;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:79:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6370784;}i:18;a:6:{i:0;s:2796:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'cruge_user' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.165030956268310546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:91;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:79:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6509688;}i:21;a:6:{i:0;s:878:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='cruge_user' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.1746280193328857421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:91;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:79:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6560520;}i:24;a:6:{i:0;s:48:"SELECT * FROM "cruge_user" WHERE "iduser"='2702'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.1789739131927490234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:74:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUserQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:91;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6925536;}i:27;a:6:{i:0;s:64:"User '2702' logged in from 166.114.158.145. Session not enabled.";i:1;i:4;i:2;s:19:"yii\web\User::login";i:3;d:1793224106.182632923126220703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:7244160;}i:28;a:6:{i:0;s:65:"Rate limit skipped: "user" does not implement RateLimitInterface.";i:1;i:4;i:2;s:37:"yii\filters\RateLimiter::beforeAction";i:3;d:1793224106.1834089756011962890625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/BaseController.php";s:4:"line";i:26;s:8:"function";s:12:"beforeAction";s:5:"class";s:18:"yii\web\Controller";s:4:"type";s:2:"->";}}i:5;i:7315128;}i:29;a:6:{i:0;s:85:"Running action: app\modules\apiv1\controllers\SaleController::actionListReportExcel()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1793224106.183434963226318359375;i:4;a:0:{}i:5;i:7313976;}i:30;a:6:{i:0;s:71:"Opening DB connection: pgsql:host=2.24.217.134;dbname=dev_servicios_sb0";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1793224106.1847379207611083984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/SaleQuery.php";s:4:"line";i:23;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:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1635;s:8:"function";s:3:"all";s:5:"class";s:33:"app\modules\core\models\SaleQuery";s:4:"type";s:2:"->";}}i:5;i:7554304;}i:33;a:6:{i:0;s:154:"SELECT * FROM "sale" WHERE ("sale"."dateCreate" >= '2026-10-28 00:00:00') AND ("sale"."dateCreate" <= '2026-10-28 23:59:59') ORDER BY "sale"."number" DESC";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.1907069683074951171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/SaleQuery.php";s:4:"line";i:23;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:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1635;s:8:"function";s:3:"all";s:5:"class";s:33:"app\modules\core\models\SaleQuery";s:4:"type";s:2:"->";}}i:5;i:7558200;}i:36;a:6:{i:0;s:2790:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'sale' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.19266605377197265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/SaleQuery.php";s:4:"line";i:23;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:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1635;s:8:"function";s:3:"all";s:5:"class";s:33:"app\modules\core\models\SaleQuery";s:4:"type";s:2:"->";}}i:5;i:7572424;}i:39;a:6:{i:0;s:872:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='sale' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2011930942535400390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/SaleQuery.php";s:4:"line";i:23;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:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1635;s:8:"function";s:3:"all";s:5:"class";s:33:"app\modules\core\models\SaleQuery";s:4:"type";s:2:"->";}}i:5;i:7596632;}i:42;a:6:{i:0;s:96:"SELECT "iduser", "fullname", "name", "lastname", "surname" FROM "cruge_user" WHERE "iduser"=2702";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2050540447235107421875;i:4;a:3:{i:0;a:5:{s:4:"file";s:74:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUserQuery.php";s:4:"line";i:23;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:74:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/UserService.php";s:4:"line";i:253;s:8:"function";s:3:"all";s:5:"class";s:38:"app\modules\core\models\CrugeUserQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1638;s:8:"function";s:8:"getUsers";s:5:"class";s:38:"app\modules\apiv1\services\UserService";s:4:"type";s:2:"->";}}i:5;i:7691720;}i:45;a:6:{i:0;s:2801:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'ioSystemBranchUser' AND d.nspname = 'cfg' ORDER BY a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2061550617218017578125;i:4;a:3:{i:0;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:35;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:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1639;s:8:"function";s:13:"getSystemInfo";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7753976;}i:48;a:6:{i:0;s:883:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='ioSystemBranchUser' and ns.nspname='cfg' order by fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.20985889434814453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:35;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:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1639;s:8:"function";s:13:"getSystemInfo";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7766000;}i:51;a:6:{i:0;s:66:"SELECT * FROM "cfg"."ioSystemBranchUser" WHERE "iduserActive"=2702";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2115991115570068359375;i:4;a:3:{i:0;a:5:{s:4:"file";s:83:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemBranchUserQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:35;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7774080;}i:54;a:6:{i:0;s:2797:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'ioSystemBranch' AND d.nspname = 'cfg' ORDER BY a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.21302700042724609375;i:4;a:3:{i:0;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:40;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:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1639;s:8:"function";s:13:"getSystemInfo";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7875728;}i:57;a:6:{i:0;s:879:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='ioSystemBranch' and ns.nspname='cfg' order by fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.222238063812255859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:40;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:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1639;s:8:"function";s:13:"getSystemInfo";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7929864;}i:60;a:6:{i:0;s:51:"SELECT * FROM "cfg"."ioSystemBranch" WHERE "id"=301";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.224546909332275390625;i:4;a:3:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemBranchQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:40;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7948360;}i:63;a:6:{i:0;s:66:"SELECT * FROM "cfg"."ioSystemBranchUser" WHERE "iduserActive"=2702";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2259290218353271484375;i:4;a:3:{i:0;a:5:{s:4:"file";s:83:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemBranchUserQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:35;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:15;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7967032;}i:66;a:6:{i:0;s:51:"SELECT * FROM "cfg"."ioSystemBranch" WHERE "id"=301";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.22675800323486328125;i:4;a:3:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemBranchQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:40;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:15;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7980872;}i:69;a:6:{i:0;s:45:"SELECT * FROM "cfg"."ioSystem" WHERE "id"=236";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2305850982666015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:18;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:77;s:8:"function";s:13:"getLogoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:8062920;}i:72;a:6:{i:0;s:2791:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'ioSystem' AND d.nspname = 'cfg' ORDER BY a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.231669902801513671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:18;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:77;s:8:"function";s:13:"getLogoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:8078976;}i:75;a:6:{i:0;s:873:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='ioSystem' and ns.nspname='cfg' order by fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2382209300994873046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:18;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:77;s:8:"function";s:13:"getLogoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:8106016;}i:78;a:6:{i:0;s:52:"SELECT * FROM "salePaymentMethods" WHERE "idsale"=37";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5705239772796630859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1718;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:13685176;}i:81;a:6:{i:0;s:2804:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'salePaymentMethods' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5721409320831298828125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1718;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:13696664;}i:84;a:6:{i:0;s:886:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='salePaymentMethods' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5760009288787841796875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1718;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:13708760;}i:87;a:6:{i:0;s:62:"SELECT * FROM "paymentMethod" WHERE "codigoClasificadorSiat"=1";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.578649044036865234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1719;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:3:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1720;s:8:"function";s:12:"array_reduce";}}i:5;i:13760472;}i:88;a:6:{i:0;s:67:"Opening DB connection: pgsql:host=2.24.217.134;dbname=dev_servicios";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1793224106.578670024871826171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1719;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:3:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1720;s:8:"function";s:12:"array_reduce";}}i:5;i:13763280;}i:93;a:6:{i:0;s:2799:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'paymentMethod' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5850379467010498046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1719;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:3:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1720;s:8:"function";s:12:"array_reduce";}}i:5;i:13777368;}i:96;a:6:{i:0;s:881:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='paymentMethod' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5918300151824951171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1719;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:3:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1720;s:8:"function";s:12:"array_reduce";}}i:5;i:13787088;}i:99;a:6:{i:0;s:41:"SELECT * FROM "invoice" WHERE "idsale"=37";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.598454952239990234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1726;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14160152;}i:102;a:6:{i:0;s:2793:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'invoice' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5998380184173583984375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1726;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14185032;}i:105;a:6:{i:0;s:875:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='invoice' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.6055800914764404296875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1726;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14230360;}i:108;a:6:{i:0;s:39:"SELECT * FROM "customer" WHERE "id"=319";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.60797595977783203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CustomerQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1729;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14295032;}i:111;a:6:{i:0;s:2794:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'customer' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.609222888946533203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CustomerQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1729;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14307936;}i:114;a:6:{i:0;s:876:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='customer' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.6138889789581298828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CustomerQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1729;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14326728;}i:117;a:6:{i:0;s:104:"Access to debugger is denied due to IP address restriction. The requesting IP address is 166.114.158.145";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1793224106.64297199249267578125;i:4;a:0:{}i:5;i:16632656;}}}";s:9:"profiling";s:108137:"a:3:{s:6:"memory";i:17123832;s:4:"time";d:0.525745868682861328125;s:8:"messages";a:66:{i:16;a:6:{i:0;s:68:"Opening DB connection: pgsql:host=2.24.217.134;dbname=0_iooxs_access";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1793224106.157658100128173828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:91;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:79:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6372288;}i:17;a:6:{i:0;s:68:"Opening DB connection: pgsql:host=2.24.217.134;dbname=0_iooxs_access";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1793224106.164002895355224609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:91;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:79:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6375232;}i:19;a:6:{i:0;s:2796:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'cruge_user' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.165072917938232421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:91;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:79:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6520848;}i:20;a:6:{i:0;s:2796:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'cruge_user' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.1738529205322265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:91;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:79:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6559760;}i:22;a:6:{i:0;s:878:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='cruge_user' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.1746580600738525390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:91;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:79:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6565200;}i:23;a:6:{i:0;s:878:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='cruge_user' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.1765410900115966796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:91;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:79:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6567144;}i:25;a:6:{i:0;s:48:"SELECT * FROM "cruge_user" WHERE "iduser"='2702'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.1790049076080322265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:74:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUserQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:91;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6928760;}i:26;a:6:{i:0;s:48:"SELECT * FROM "cruge_user" WHERE "iduser"='2702'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.17992401123046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:74:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUserQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:91;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/servicios.apirest/vendor/sizeg/yii2-jwt/JwtHttpBearerAuth.php";s:4:"line";i:86;s:8:"function";s:18:"loginByAccessToken";s:5:"class";s:12:"yii\web\User";s:4:"type";s:2:"->";}}i:5;i:6933928;}i:31;a:6:{i:0;s:71:"Opening DB connection: pgsql:host=2.24.217.134;dbname=dev_servicios_sb0";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1793224106.1847479343414306640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/SaleQuery.php";s:4:"line";i:23;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:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1635;s:8:"function";s:3:"all";s:5:"class";s:33:"app\modules\core\models\SaleQuery";s:4:"type";s:2:"->";}}i:5;i:7555808;}i:32;a:6:{i:0;s:71:"Opening DB connection: pgsql:host=2.24.217.134;dbname=dev_servicios_sb0";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1793224106.190659046173095703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/SaleQuery.php";s:4:"line";i:23;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:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1635;s:8:"function";s:3:"all";s:5:"class";s:33:"app\modules\core\models\SaleQuery";s:4:"type";s:2:"->";}}i:5;i:7558120;}i:34;a:6:{i:0;s:154:"SELECT * FROM "sale" WHERE ("sale"."dateCreate" >= '2026-10-28 00:00:00') AND ("sale"."dateCreate" <= '2026-10-28 23:59:59') ORDER BY "sale"."number" DESC";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.19073009490966796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/SaleQuery.php";s:4:"line";i:23;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:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1635;s:8:"function";s:3:"all";s:5:"class";s:33:"app\modules\core\models\SaleQuery";s:4:"type";s:2:"->";}}i:5;i:7561144;}i:35;a:6:{i:0;s:154:"SELECT * FROM "sale" WHERE ("sale"."dateCreate" >= '2026-10-28 00:00:00') AND ("sale"."dateCreate" <= '2026-10-28 23:59:59') ORDER BY "sale"."number" DESC";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.1924641132354736328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/SaleQuery.php";s:4:"line";i:23;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:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1635;s:8:"function";s:3:"all";s:5:"class";s:33:"app\modules\core\models\SaleQuery";s:4:"type";s:2:"->";}}i:5;i:7566832;}i:37;a:6:{i:0;s:2790:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'sale' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.19268703460693359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/SaleQuery.php";s:4:"line";i:23;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:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1635;s:8:"function";s:3:"all";s:5:"class";s:33:"app\modules\core\models\SaleQuery";s:4:"type";s:2:"->";}}i:5;i:7583504;}i:38;a:6:{i:0;s:2790:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'sale' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.200623035430908203125;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/SaleQuery.php";s:4:"line";i:23;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:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1635;s:8:"function";s:3:"all";s:5:"class";s:33:"app\modules\core\models\SaleQuery";s:4:"type";s:2:"->";}}i:5;i:7631448;}i:40;a:6:{i:0;s:872:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='sale' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2012169361114501953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/SaleQuery.php";s:4:"line";i:23;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:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1635;s:8:"function";s:3:"all";s:5:"class";s:33:"app\modules\core\models\SaleQuery";s:4:"type";s:2:"->";}}i:5;i:7601312;}i:41;a:6:{i:0;s:872:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='sale' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2037169933319091796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/SaleQuery.php";s:4:"line";i:23;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:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1635;s:8:"function";s:3:"all";s:5:"class";s:33:"app\modules\core\models\SaleQuery";s:4:"type";s:2:"->";}}i:5;i:7604120;}i:43;a:6:{i:0;s:96:"SELECT "iduser", "fullname", "name", "lastname", "surname" FROM "cruge_user" WHERE "iduser"=2702";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2050769329071044921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:74:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUserQuery.php";s:4:"line";i:23;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:74:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/UserService.php";s:4:"line";i:253;s:8:"function";s:3:"all";s:5:"class";s:38:"app\modules\core\models\CrugeUserQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1638;s:8:"function";s:8:"getUsers";s:5:"class";s:38:"app\modules\apiv1\services\UserService";s:4:"type";s:2:"->";}}i:5;i:7695112;}i:44;a:6:{i:0;s:96:"SELECT "iduser", "fullname", "name", "lastname", "surname" FROM "cruge_user" WHERE "iduser"=2702";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.205482959747314453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:74:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CrugeUserQuery.php";s:4:"line";i:23;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:74:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/UserService.php";s:4:"line";i:253;s:8:"function";s:3:"all";s:5:"class";s:38:"app\modules\core\models\CrugeUserQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1638;s:8:"function";s:8:"getUsers";s:5:"class";s:38:"app\modules\apiv1\services\UserService";s:4:"type";s:2:"->";}}i:5;i:7698296;}i:46;a:6:{i:0;s:2801:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'ioSystemBranchUser' AND d.nspname = 'cfg' ORDER BY a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2061760425567626953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:35;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:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1639;s:8:"function";s:13:"getSystemInfo";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7765432;}i:47;a:6:{i:0;s:2801:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'ioSystemBranchUser' AND d.nspname = 'cfg' ORDER BY a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.209435939788818359375;i:4;a:3:{i:0;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:35;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:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1639;s:8:"function";s:13:"getSystemInfo";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7783688;}i:49;a:6:{i:0;s:883:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='ioSystemBranchUser' and ns.nspname='cfg' order by fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.20987796783447265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:35;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:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1639;s:8:"function";s:13:"getSystemInfo";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7771056;}i:50;a:6:{i:0;s:883:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='ioSystemBranchUser' and ns.nspname='cfg' order by fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2113630771636962890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:35;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:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1639;s:8:"function";s:13:"getSystemInfo";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7774880;}i:52;a:6:{i:0;s:66:"SELECT * FROM "cfg"."ioSystemBranchUser" WHERE "iduserActive"=2702";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.211618900299072265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:83:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemBranchUserQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:35;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7777376;}i:53;a:6:{i:0;s:66:"SELECT * FROM "cfg"."ioSystemBranchUser" WHERE "iduserActive"=2702";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.21232509613037109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:83:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemBranchUserQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:35;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7780752;}i:55;a:6:{i:0;s:2797:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'ioSystemBranch' AND d.nspname = 'cfg' ORDER BY a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2130520343780517578125;i:4;a:3:{i:0;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:40;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:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1639;s:8:"function";s:13:"getSystemInfo";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7887184;}i:56;a:6:{i:0;s:2797:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'ioSystemBranch' AND d.nspname = 'cfg' ORDER BY a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2214429378509521484375;i:4;a:3:{i:0;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:40;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:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1639;s:8:"function";s:13:"getSystemInfo";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:8030248;}i:58;a:6:{i:0;s:879:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='ioSystemBranch' and ns.nspname='cfg' order by fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2222731113433837890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:40;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:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1639;s:8:"function";s:13:"getSystemInfo";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7934920;}i:59;a:6:{i:0;s:879:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='ioSystemBranch' and ns.nspname='cfg' order by fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2241370677947998046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:40;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:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1639;s:8:"function";s:13:"getSystemInfo";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7939264;}i:61;a:6:{i:0;s:51:"SELECT * FROM "cfg"."ioSystemBranch" WHERE "id"=301";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.22457599639892578125;i:4;a:3:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemBranchQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:40;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7951592;}i:62;a:6:{i:0;s:51:"SELECT * FROM "cfg"."ioSystemBranch" WHERE "id"=301";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2255780696868896484375;i:4;a:3:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemBranchQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:40;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:71;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7969072;}i:64;a:6:{i:0;s:66:"SELECT * FROM "cfg"."ioSystemBranchUser" WHERE "iduserActive"=2702";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2259600162506103515625;i:4;a:3:{i:0;a:5:{s:4:"file";s:83:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemBranchUserQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:35;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:15;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7970328;}i:65;a:6:{i:0;s:66:"SELECT * FROM "cfg"."ioSystemBranchUser" WHERE "iduserActive"=2702";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.226500988006591796875;i:4;a:3:{i:0;a:5:{s:4:"file";s:83:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemBranchUserQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:35;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:15;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7979336;}i:67;a:6:{i:0;s:51:"SELECT * FROM "cfg"."ioSystemBranch" WHERE "id"=301";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2267758846282958984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemBranchQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:40;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:15;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:7984104;}i:68;a:6:{i:0;s:51:"SELECT * FROM "cfg"."ioSystemBranch" WHERE "id"=301";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2271358966827392578125;i:4;a:3:{i:0;a:5:{s:4:"file";s:79:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemBranchQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:40;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:15;s:8:"function";s:17:"getAccessIoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:8001584;}i:70;a:6:{i:0;s:45:"SELECT * FROM "cfg"."ioSystem" WHERE "id"=236";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.230609893798828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:18;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:77;s:8:"function";s:13:"getLogoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:8066144;}i:71;a:6:{i:0;s:45:"SELECT * FROM "cfg"."ioSystem" WHERE "id"=236";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2314560413360595703125;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:18;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:77;s:8:"function";s:13:"getLogoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:8073976;}i:73;a:6:{i:0;s:2791:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'ioSystem' AND d.nspname = 'cfg' ORDER BY a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.23169994354248046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:18;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:77;s:8:"function";s:13:"getLogoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:8090432;}i:74;a:6:{i:0;s:2791:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'ioSystem' AND d.nspname = 'cfg' ORDER BY a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2376730442047119140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:18;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:77;s:8:"function";s:13:"getLogoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:8154920;}i:76;a:6:{i:0;s:873:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='ioSystem' and ns.nspname='cfg' order by fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2382490634918212890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:18;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:77;s:8:"function";s:13:"getLogoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:8111072;}i:77;a:6:{i:0;s:873:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='ioSystem' and ns.nspname='cfg' order by fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.2402169704437255859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/IoSystemQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:18;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:76:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/services/SystemService.php";s:4:"line";i:77;s:8:"function";s:13:"getLogoBranch";s:5:"class";s:40:"app\modules\apiv1\services\SystemService";s:4:"type";s:2:"->";}}i:5;i:8113392;}i:79;a:6:{i:0;s:52:"SELECT * FROM "salePaymentMethods" WHERE "idsale"=37";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5705521106719970703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1718;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:13687664;}i:80;a:6:{i:0;s:52:"SELECT * FROM "salePaymentMethods" WHERE "idsale"=37";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.57196903228759765625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1718;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:13691072;}i:82;a:6:{i:0;s:2804:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'salePaymentMethods' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.572163105010986328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1718;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:13707368;}i:83;a:6:{i:0;s:2804:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'salePaymentMethods' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5755560398101806640625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1718;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:13732792;}i:85;a:6:{i:0;s:886:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='salePaymentMethods' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5760300159454345703125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1718;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:13713064;}i:86;a:6:{i:0;s:886:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='salePaymentMethods' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5779469013214111328125;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1718;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:13715512;}i:89;a:6:{i:0;s:67:"Opening DB connection: pgsql:host=2.24.217.134;dbname=dev_servicios";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1793224106.5786769390106201171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1719;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:3:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1720;s:8:"function";s:12:"array_reduce";}}i:5;i:13764784;}i:90;a:6:{i:0;s:67:"Opening DB connection: pgsql:host=2.24.217.134;dbname=dev_servicios";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1793224106.58382892608642578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1719;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:3:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1720;s:8:"function";s:12:"array_reduce";}}i:5;i:13767088;}i:91;a:6:{i:0;s:62:"SELECT * FROM "paymentMethod" WHERE "codigoClasificadorSiat"=1";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5838749408721923828125;i:4;a:2:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1719;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:3:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1720;s:8:"function";s:12:"array_reduce";}}i:5;i:13768880;}i:92;a:6:{i:0;s:62:"SELECT * FROM "paymentMethod" WHERE "codigoClasificadorSiat"=1";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5848369598388671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1719;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:3:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1720;s:8:"function";s:12:"array_reduce";}}i:5;i:13771440;}i:94;a:6:{i:0;s:2799:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'paymentMethod' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5850660800933837890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1719;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:3:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1720;s:8:"function";s:12:"array_reduce";}}i:5;i:13788448;}i:95;a:6:{i:0;s:2799:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'paymentMethod' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5915699005126953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1719;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:3:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1720;s:8:"function";s:12:"array_reduce";}}i:5;i:13802864;}i:97;a:6:{i:0;s:881:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='paymentMethod' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.591854095458984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1719;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:3:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1720;s:8:"function";s:12:"array_reduce";}}i:5;i:13791768;}i:98;a:6:{i:0;s:881:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='paymentMethod' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.593307018280029296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1719;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}i:1;a:3:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1720;s:8:"function";s:12:"array_reduce";}}i:5;i:13793712;}i:100;a:6:{i:0;s:41:"SELECT * FROM "invoice" WHERE "idsale"=37";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5984790325164794921875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1726;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14162616;}i:101;a:6:{i:0;s:41:"SELECT * FROM "invoice" WHERE "idsale"=37";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.5996730327606201171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1726;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14181360;}i:103;a:6:{i:0;s:2793:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'invoice' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.599855899810791015625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1726;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14195736;}i:104;a:6:{i:0;s:2793:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'invoice' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.6050510406494140625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1726;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14315240;}i:106;a:6:{i:0;s:875:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='invoice' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.6056020259857177734375;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1726;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14234664;}i:107;a:6:{i:0;s:875:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='invoice' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.6070349216461181640625;i:4;a:1:{i:0;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1726;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14236232;}i:109;a:6:{i:0;s:39:"SELECT * FROM "customer" WHERE "id"=319";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.60799503326416015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CustomerQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1729;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14297232;}i:110;a:6:{i:0;s:39:"SELECT * FROM "customer" WHERE "id"=319";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.609033107757568359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CustomerQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1729;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14302384;}i:112;a:6:{i:0;s:2794:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'customer' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.6092469692230224609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CustomerQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1729;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14319016;}i:113;a:6:{i:0;s:2794:"SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'customer' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.6133880615234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CustomerQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1729;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14362440;}i:115;a:6:{i:0;s:876:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='customer' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.613915920257568359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CustomerQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1729;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14331408;}i:116;a:6:{i:0;s:876:"select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='customer' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1793224106.615847110748291015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/servicios.apirest/modules/core/models/CustomerQuery.php";s:4:"line";i:32;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:80:"/opt/lampp/htdocs/servicios.apirest/modules/apiv1/controllers/SaleController.php";s:4:"line";i:1729;s:8:"function";s:5:"__get";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"->";}}i:5;i:14333352;}}}";s:5:"event";s:10086:"a:50:{i:0;a:5:{s:4:"time";d:1793224106.1434230804443359375;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:1793224106.14672088623046875;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:1793224106.154551982879638671875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:38:"app\modules\core\models\CrugeUserQuery";}i:3;a:5:{s:4:"time";d:1793224106.1639919281005859375;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:4;a:5:{s:4:"time";d:1793224106.1800749301910400390625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"app\modules\core\models\CrugeUser";}i:5;a:5:{s:4:"time";d:1793224106.1801249980926513671875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"app\modules\core\models\CrugeUser";}i:6;a:5:{s:4:"time";d:1793224106.180233001708984375;s:4:"name";s:11:"beforeLogin";s:5:"class";s:17:"yii\web\UserEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\User";}i:7;a:5:{s:4:"time";d:1793224106.1826550960540771484375;s:4:"name";s:10:"afterLogin";s:5:"class";s:17:"yii\web\UserEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:12:"yii\web\User";}i:8;a:5:{s:4:"time";d:1793224106.182673931121826171875;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:29:"app\modules\apiv1\Apiv1Module";}i:9;a:5:{s:4:"time";d:1793224106.183422088623046875;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:44:"app\modules\apiv1\controllers\SaleController";}i:10;a:5:{s:4:"time";d:1793224106.1843280792236328125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:33:"app\modules\core\models\SaleQuery";}i:11;a:5:{s:4:"time";d:1793224106.1906540393829345703125;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:12;a:5:{s:4:"time";d:1793224106.19260406494140625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:38:"app\modules\apiv1\models\entities\Sale";}i:13;a:5:{s:4:"time";d:1793224106.2039310932159423828125;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:38:"app\modules\apiv1\models\entities\Sale";}i:14;a:5:{s:4:"time";d:1793224106.2044799327850341796875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:38:"app\modules\core\models\CrugeUserQuery";}i:15;a:5:{s:4:"time";d:1793224106.2060849666595458984375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:47:"app\modules\core\models\IoSystemBranchUserQuery";}i:16;a:5:{s:4:"time";d:1793224106.2124330997467041015625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"app\modules\core\models\IoSystemBranchUser";}i:17;a:5:{s:4:"time";d:1793224106.2124640941619873046875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"app\modules\core\models\IoSystemBranchUser";}i:18;a:5:{s:4:"time";d:1793224106.212954998016357421875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:43:"app\modules\core\models\IoSystemBranchQuery";}i:19;a:5:{s:4:"time";d:1793224106.225719928741455078125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:48:"app\modules\apiv1\models\entities\IoSystemBranch";}i:20;a:5:{s:4:"time";d:1793224106.225799083709716796875;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:48:"app\modules\apiv1\models\entities\IoSystemBranch";}i:21;a:5:{s:4:"time";d:1793224106.2258141040802001953125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:47:"app\modules\core\models\IoSystemBranchUserQuery";}i:22;a:5:{s:4:"time";d:1793224106.2265961170196533203125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"app\modules\core\models\IoSystemBranchUser";}i:23;a:5:{s:4:"time";d:1793224106.2266199588775634765625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"app\modules\core\models\IoSystemBranchUser";}i:24;a:5:{s:4:"time";d:1793224106.2266309261322021484375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:43:"app\modules\core\models\IoSystemBranchQuery";}i:25;a:5:{s:4:"time";d:1793224106.2272551059722900390625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:48:"app\modules\apiv1\models\entities\IoSystemBranch";}i:26;a:5:{s:4:"time";d:1793224106.2273080348968505859375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:48:"app\modules\apiv1\models\entities\IoSystemBranch";}i:27;a:5:{s:4:"time";d:1793224106.2304470539093017578125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:37:"app\modules\core\models\IoSystemQuery";}i:28;a:5:{s:4:"time";d:1793224106.2316100597381591796875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"app\modules\apiv1\models\entities\IoSystem";}i:29;a:5:{s:4:"time";d:1793224106.240561008453369140625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"app\modules\apiv1\models\entities\IoSystem";}i:30;a:5:{s:4:"time";d:1793224106.5703880786895751953125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:31;a:5:{s:4:"time";d:1793224106.5720880031585693359375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:52:"app\modules\apiv1\models\entities\SalePaymentMethods";}i:32;a:5:{s:4:"time";d:1793224106.5781838893890380859375;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:52:"app\modules\apiv1\models\entities\SalePaymentMethods";}i:33;a:5:{s:4:"time";d:1793224106.5784800052642822265625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:18:"yii\db\ActiveQuery";}i:34;a:5:{s:4:"time";d:1793224106.5838220119476318359375;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:35;a:5:{s:4:"time";d:1793224106.5849540233612060546875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:47:"app\modules\apiv1\models\entities\PaymentMethod";}i:36;a:5:{s:4:"time";d:1793224106.5934689044952392578125;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:47:"app\modules\apiv1\models\entities\PaymentMethod";}i:37;a:5:{s:4:"time";d:1793224106.5983459949493408203125;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:38;a:5:{s:4:"time";d:1793224106.599791049957275390625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:41:"app\modules\apiv1\models\entities\Invoice";}i:39;a:5:{s:4:"time";d:1793224106.6071979999542236328125;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:41:"app\modules\apiv1\models\entities\Invoice";}i:40;a:5:{s:4:"time";d:1793224106.6078679561614990234375;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:37:"app\modules\core\models\CustomerQuery";}i:41;a:5:{s:4:"time";d:1793224106.6091740131378173828125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"app\modules\apiv1\models\entities\Customer";}i:42;a:5:{s:4:"time";d:1793224106.616095066070556640625;s:4:"name";s:9:"afterFind";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:42:"app\modules\apiv1\models\entities\Customer";}i:43;a:5:{s:4:"time";d:1793224106.642632961273193359375;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:44:"app\modules\apiv1\controllers\SaleController";}i:44;a:5:{s:4:"time";d:1793224106.642918109893798828125;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:29:"app\modules\apiv1\Apiv1Module";}i:45;a:5:{s:4:"time";d:1793224106.6429240703582763671875;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:46;a:5:{s:4:"time";d:1793224106.6429378986358642578125;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:47;a:5:{s:4:"time";d:1793224106.64294910430908203125;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:48;a:5:{s:4:"time";d:1793224106.642983913421630859375;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:49;a:5:{s:4:"time";d:1793224106.643208980560302734375;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:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:116:"a:3:{s:5:"start";d:1793224106.118937015533447265625;s:3:"end";d:1793224106.644805908203125;s:6:"memory";i:17123832;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:1575:"a:3:{s:8:"messages";a:7:{i:5;a:6:{i:0;a:3:{s:4:"rule";s:3:"gii";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1793224106.143505096435546875;i:4;a:0:{}i:5;i:4278456;}i:6;a:6:{i:0;a:3:{s:4:"rule";s:12:"gii/";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1793224106.143516063690185546875;i:4;a:0:{}i:5;i:4279208;}i:7;a:6:{i:0;a:3:{s:4:"rule";s:41:"gii//";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1793224106.1435201168060302734375;i:4;a:0:{}i:5;i:4279960;}i:8;a:6:{i:0;a:3:{s:4:"rule";s:5:"debug";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1793224106.1435239315032958984375;i:4;a:0:{}i:5;i:4280712;}i:9;a:6:{i:0;a:3:{s:4:"rule";s:43:"debug//";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1793224106.14352893829345703125;i:4;a:0:{}i:5;i:4281784;}i:10;a:6:{i:0;a:3:{s:4:"rule";s:5:"class";s:5:"match";b:0;s:6:"parent";N;}i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1793224106.1435310840606689453125;i:4;a:0:{}i:5;i:4282536;}i:11;a:6:{i:0;s:55:"No matching URL rules. Using default URL parsing logic.";i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1793224106.1435329914093017578125;i:4;a:0:{}i:5;i:4282912;}}s:5:"route";s:28:"apiv1/sale/list-report-excel";s:6:"action";s:69:"app\modules\apiv1\controllers\SaleController::actionListReportExcel()";}";s:7:"request";s:5647:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:17:{s:4:"host";s:27:"servicios.apirest.velooz.io";s:10:"connection";s:10:"keep-alive";s:14:"content-length";s:2:"31";s:18:"sec-ch-ua-platform";s:9:""Windows"";s:13:"authorization";s:327:"Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiIsImp0aSI6IlVOSVFVRS1KV1QtSURFTlRJRklFUiJ9.eyJpc3MiOiJodHRwczpcL1wvYXBpLmV4YW1wbGUuY29tIiwiYXVkIjoiaHR0cHM6XC9cL2Zyb250ZW5kLmV4YW1wbGUuY29tIiwianRpIjoiVU5JUVVFLUpXVC1JREVOVElGSUVSIiwiaWF0IjoxNzkzMjIzODIxLCJleHAiOjE3OTMzMTAyMjEsInVpZCI6MjcwMn0.GQkslSgKU8viU0eZ0qNCE-xuZZ4rVYErMtV-Bmp-h5Y";s:10:"user-agent";s:125:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/156.0.0.0 Safari/537.36 Edg/156.0.0.0";s:6:"accept";s:33:"application/json, text/plain, */*";s:9:"sec-ch-ua";s:65:""Not:A-Brand";v="8", "Chromium";v="156", "Microsoft Edge";v="156"";s:12:"content-type";s:16:"application/json";s:16:"sec-ch-ua-mobile";s:2:"?0";s:6:"origin";s:30:"https://servicios.io.velooz.io";s:14:"sec-fetch-site";s:9:"same-site";s:14:"sec-fetch-mode";s:4:"cors";s:14:"sec-fetch-dest";s:5:"empty";s:7:"referer";s:31:"https://servicios.io.velooz.io/";s:15:"accept-encoding";s:23:"gzip, deflate, br, zstd";s:15:"accept-language";s:60:"es-419,es;q=0.9,es-ES;q=0.8,en;q=0.7,en-GB;q=0.6,en-US;q=0.5";}s:15:"responseHeaders";a:10:{s:12:"X-Powered-By";s:9:"PHP/7.3.0";s:27:"Access-Control-Allow-Origin";s:30:"https://servicios.io.velooz.io";s:32:"Access-Control-Allow-Credentials";s:4:"true";s:29:"Access-Control-Expose-Headers";s:25:"X-Pagination-Current-Page";s:28:"Access-Control-Allow-Headers";s:45:"authorization, X-Requested-With, content-type";s:4:"Vary";s:6:"Accept";s:12:"Content-Type";s:65:"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";s:19:"Content-Disposition";s:55:"attachment; filename="ventas_productos_2026-10-28.xlsx"";s:13:"Cache-Control";s:9:"max-age=0";s:10:"Set-Cookie";s:204:"_csrf=5783fbfe4c594531a77ed140030e31ca38ab2266f4a1afb5b02fc2d578df2979a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22iRK78Ei6EvU4uD3KunrVsOTuwPHjCXlg%22%3B%7D; path=/; HttpOnly; SameSite=Lax";}s:5:"route";s:28:"apiv1/sale/list-report-excel";s:6:"action";s:69:"app\modules\apiv1\controllers\SaleController::actionListReportExcel()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:3:"PUT";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:1;}s:11:"requestBody";a:3:{s:12:"Content Type";s:16:"application/json";s:3:"Raw";s:31:"{"idstatus":[],"idpayments":[]}";s:7:"Decoded";a:2:{s:8:"idstatus";a:0:{}s:10:"idpayments";a:0:{}}}s:6:"SERVER";a:49:{s:18:"REDIRECT_UNIQUE_ID";s:27:"auJtqsVUnvGKTc82aB3yIgAAAAc";s:14:"REDIRECT_HTTPS";s:2:"on";s:20:"REDIRECT_SSL_TLS_SNI";s:27:"servicios.apirest.velooz.io";s:15:"REDIRECT_STATUS";s:3:"200";s:9:"UNIQUE_ID";s:27:"auJtqsVUnvGKTc82aB3yIgAAAAc";s:5:"HTTPS";s:2:"on";s:11:"SSL_TLS_SNI";s:27:"servicios.apirest.velooz.io";s:9:"HTTP_HOST";s:27:"servicios.apirest.velooz.io";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:14:"CONTENT_LENGTH";s:2:"31";s:23:"HTTP_SEC_CH_UA_PLATFORM";s:9:""Windows"";s:15:"HTTP_USER_AGENT";s:125:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/156.0.0.0 Safari/537.36 Edg/156.0.0.0";s:11:"HTTP_ACCEPT";s:33:"application/json, text/plain, */*";s:14:"HTTP_SEC_CH_UA";s:65:""Not:A-Brand";v="8", "Chromium";v="156", "Microsoft Edge";v="156"";s:12:"CONTENT_TYPE";s:16:"application/json";s:21:"HTTP_SEC_CH_UA_MOBILE";s:2:"?0";s:11:"HTTP_ORIGIN";s:30:"https://servicios.io.velooz.io";s:19:"HTTP_SEC_FETCH_SITE";s:9:"same-site";s:19:"HTTP_SEC_FETCH_MODE";s:4:"cors";s:19:"HTTP_SEC_FETCH_DEST";s:5:"empty";s:12:"HTTP_REFERER";s:31:"https://servicios.io.velooz.io/";s:20:"HTTP_ACCEPT_ENCODING";s:23:"gzip, deflate, br, zstd";s:20:"HTTP_ACCEPT_LANGUAGE";s:60:"es-419,es;q=0.9,es-ES;q=0.8,en;q=0.7,en-GB;q=0.6,en-US;q=0.5";s:4:"PATH";s:98:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin";s:15:"LD_LIBRARY_PATH";s:29:"/opt/lampp/lib:/opt/lampp/lib";s:16:"SERVER_SIGNATURE";s:0:"";s:15:"SERVER_SOFTWARE";s:77:"Apache/2.4.37 (Unix) OpenSSL/1.0.2q PHP/7.3.0 mod_perl/2.0.8-dev Perl/v5.16.3";s:11:"SERVER_NAME";s:27:"servicios.apirest.velooz.io";s:11:"SERVER_ADDR";s:12:"2.24.217.134";s:11:"SERVER_PORT";s:3:"443";s:11:"REMOTE_ADDR";s:15:"166.114.158.145";s:13:"DOCUMENT_ROOT";s:35:"/opt/lampp/htdocs/servicios.apirest";s:14:"REQUEST_SCHEME";s:5:"https";s:14:"CONTEXT_PREFIX";s:0:"";s:21:"CONTEXT_DOCUMENT_ROOT";s:35:"/opt/lampp/htdocs/servicios.apirest";s:12:"SERVER_ADMIN";s:15:"you@example.com";s:15:"SCRIPT_FILENAME";s:49:"/opt/lampp/htdocs/servicios.apirest/web/index.php";s:11:"REMOTE_PORT";s:5:"61266";s:12:"REDIRECT_URL";s:33:"/web/apiv1/sale/list-report-excel";s:21:"REDIRECT_QUERY_STRING";s:69:"page=1&pageSize=10&filter=2&start=2026-10-28&end=2026-10-28&customer=";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:3:"PUT";s:12:"QUERY_STRING";s:69:"page=1&pageSize=10&filter=2&start=2026-10-28&end=2026-10-28&customer=";s:11:"REQUEST_URI";s:103:"/web/apiv1/sale/list-report-excel?page=1&pageSize=10&filter=2&start=2026-10-28&end=2026-10-28&customer=";s:11:"SCRIPT_NAME";s:14:"/web/index.php";s:8:"PHP_SELF";s:14:"/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1793224106.1140000820159912109375;s:12:"REQUEST_TIME";i:1793224106;}s:3:"GET";a:6:{s:4:"page";s:1:"1";s:8:"pageSize";s:2:"10";s:6:"filter";s:1:"2";s:5:"start";s:10:"2026-10-28";s:3:"end";s:10:"2026-10-28";s:8:"customer";s:0:"";}s:4:"POST";a:0:{}s:6:"COOKIE";a:0:{}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}";s:4:"user";s:2397:"a:5:{s:2:"id";i:2702;s:8:"identity";a:22:{s:6:"iduser";s:4:"2702";s:7:"regdate";s:4:"null";s:7:"actdate";s:10:"1770126009";s:9:"logondate";s:10:"1770125978";s:8:"username";s:15:"'dev_servicios'";s:5:"email";s:23:"'dannielss.d@gmail.com'";s:8:"password";s:34:"'696b0709b9a2d7d9e2c25b71476ec255'";s:7:"authkey";s:4:"null";s:5:"state";s:1:"1";s:19:"totalsessioncounter";s:1:"0";s:21:"currentsessioncounter";s:1:"0";s:8:"temporal";s:5:"false";s:8:"fullname";s:17:"'SERVICIOS .. ..'";s:4:"name";s:11:"'SERVICIOS'";s:8:"lastname";s:4:"'..'";s:7:"surname";s:4:"'..'";s:13:"resetPassword";s:4:"true";s:5:"phone";s:2:"''";s:21:"recoveryTokenPassword";s:4:"null";s:4:"role";s:4:"null";s:6:"idrole";s:2:"63";s:10:"superAdmin";s:5:"false";}s:10:"attributes";a:22:{i:0;a:2:{s:9:"attribute";s:6:"iduser";s:5:"label";s:7:"ID User";}i:1;a:2:{s:9:"attribute";s:7:"regdate";s:5:"label";s:17:"Registration Date";}i:2;a:2:{s:9:"attribute";s:7:"actdate";s:5:"label";s:15:"Activation Date";}i:3;a:2:{s:9:"attribute";s:9:"logondate";s:5:"label";s:10:"Logon Date";}i:4;a:2:{s:9:"attribute";s:8:"username";s:5:"label";s:8:"Username";}i:5;a:2:{s:9:"attribute";s:5:"email";s:5:"label";s:5:"Email";}i:6;a:2:{s:9:"attribute";s:8:"password";s:5:"label";s:8:"Password";}i:7;a:2:{s:9:"attribute";s:7:"authkey";s:5:"label";s:8:"Auth Key";}i:8;a:2:{s:9:"attribute";s:5:"state";s:5:"label";s:5:"State";}i:9;a:2:{s:9:"attribute";s:19:"totalsessioncounter";s:5:"label";s:21:"Total Session Counter";}i:10;a:2:{s:9:"attribute";s:21:"currentsessioncounter";s:5:"label";s:23:"Current Session Counter";}i:11;a:2:{s:9:"attribute";s:8:"temporal";s:5:"label";s:8:"Temporal";}i:12;a:2:{s:9:"attribute";s:8:"fullname";s:5:"label";s:9:"Full Name";}i:13;a:2:{s:9:"attribute";s:4:"name";s:5:"label";s:4:"Name";}i:14;a:2:{s:9:"attribute";s:8:"lastname";s:5:"label";s:9:"Last Name";}i:15;a:2:{s:9:"attribute";s:7:"surname";s:5:"label";s:7:"Surname";}i:16;a:2:{s:9:"attribute";s:13:"resetPassword";s:5:"label";s:14:"Reset Password";}i:17;a:2:{s:9:"attribute";s:5:"phone";s:5:"label";s:5:"Phone";}i:18;a:2:{s:9:"attribute";s:21:"recoveryTokenPassword";s:5:"label";s:23:"Recovery Token Password";}i:19;a:2:{s:9:"attribute";s:4:"role";s:5:"label";s:4:"Role";}i:20;a:2:{s:9:"attribute";s:6:"idrole";s:5:"label";s:6:"idrole";}i:21;a:2:{s:9:"attribute";s:10:"superAdmin";s:5:"label";s:10:"superAdmin";}}s:13:"rolesProvider";N;s:19:"permissionsProvider";N;}";s:5:"asset";s:6:"a:0:{}";s:7:"summary";a:13:{s:3:"tag";s:13:"6ae26daa222bf";s:3:"url";s:138:"https://servicios.apirest.velooz.io/web/apiv1/sale/list-report-excel?page=1&pageSize=10&filter=2&start=2026-10-28&end=2026-10-28&customer=";s:4:"ajax";i:0;s:6:"method";s:3:"PUT";s:2:"ip";s:15:"166.114.158.145";s:4:"time";d:1793224106.1140000820159912109375;s:10:"statusCode";i:200;s:8:"sqlCount";i:0;s:21:"excessiveCallersCount";i:0;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:17123832;s:14:"processingTime";d:0.525745868682861328125;}s:10:"exceptions";a:0:{}}