a:13:{s:6:"config";s:1880:"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:52:"/opt/lampp/htdocs/prod.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:65:"/opt/lampp/htdocs/prod.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:60:"/opt/lampp/htdocs/prod.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:60:"/opt/lampp/htdocs/prod.apirest/vendor/yiisoft/yii2-debug/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:65:"/opt/lampp/htdocs/prod.apirest/vendor/yiisoft/yii2-httpclient/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:58:"/opt/lampp/htdocs/prod.apirest/vendor/yiisoft/yii2-gii/src";}}s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.1.3.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:66:"/opt/lampp/htdocs/prod.apirest/vendor/yiisoft/yii2-swiftmailer/src";}}}}";s:3:"log";s:29808:"a:1:{s:8:"messages";a:41:{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:1784578183.9169390201568603515625;i:4;a:0:{}i:5;i:2726128;}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:1784578183.9169559478759765625;i:4;a:0:{}i:5;i:2727304;}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:1784578183.921576976776123046875;i:4;a:0:{}i:5;i:3478288;}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:1784578183.923656940460205078125;i:4;a:0:{}i:5;i:3864784;}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:1784578183.9238779544830322265625;i:4;a:0:{}i:5;i:3889624;}i:12;a:6:{i:0;s:41:"Route requested: 'apiv1/report/dashboard'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1784578183.9253580570220947265625;i:4;a:0:{}i:5;i:4267816;}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:1784578183.925364017486572265625;i:4;a:0:{}i:5;i:4269448;}i:14;a:6:{i:0;s:36:"Route to run: apiv1/report/dashboard";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1784578183.9270451068878173828125;i:4;a:0:{}i:5;i:4477968;}i:15;a:6:{i:0;s:68:"Opening DB connection: pgsql:host=147.93.69.62;dbname=0_iooxs_access";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1784578183.937529087066650390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:64:"/opt/lampp/htdocs/prod.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:74:"/opt/lampp/htdocs/prod.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:6134424;}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:1784578183.946692943572998046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:64:"/opt/lampp/htdocs/prod.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:74:"/opt/lampp/htdocs/prod.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:6273328;}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:1784578183.964744091033935546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:64:"/opt/lampp/htdocs/prod.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:74:"/opt/lampp/htdocs/prod.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:6324128;}i:24;a:6:{i:0;s:48:"SELECT * FROM "cruge_user" WHERE "iduser"='3247'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578183.969995975494384765625;i:4;a:3:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/prod.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:64:"/opt/lampp/htdocs/prod.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:74:"/opt/lampp/htdocs/prod.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:6688888;}i:27;a:6:{i:0;s:63:"User '3247' logged in from 200.105.212.59. Session not enabled.";i:1;i:4;i:2;s:19:"yii\web\User::login";i:3;d:1784578183.97325801849365234375;i:4;a:1:{i:0;a:5:{s:4:"file";s:74:"/opt/lampp/htdocs/prod.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:7007440;}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:1784578183.9738900661468505859375;i:4;a:1:{i:0;a:5:{s:4:"file";s:75:"/opt/lampp/htdocs/prod.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:7078408;}i:29;a:6:{i:0;s:81:"Running action: app\modules\apiv1\controllers\ReportController::actionDashboard()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1784578183.9739398956298828125;i:4;a:0:{}i:5;i:7077256;}i:30;a:6:{i:0;s:263:"SELECT "idproduct", COUNT(idproduct) AS "totalSales" FROM "productStock" INNER JOIN "document" "doc" ON "productStock"."iddocument" = "doc"."id" WHERE (NOT ("doc"."idsale" IS NULL)) AND ("doc"."idstatus"=40) GROUP BY "idproduct" ORDER BY "totalSales" DESC LIMIT 8";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578183.9755051136016845703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7359272;}i:31;a:6:{i:0;s:72:"Opening DB connection: pgsql:host=147.93.69.62;dbname=farmacia_eitan_sb0";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1784578183.9755229949951171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7362736;}i:36;a:6:{i:0;s:2798:"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 = 'productStock' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578183.994412899017333984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7379960;}i:39;a:6:{i:0;s:880:"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='productStock' 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:1784578184.001368045806884765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7403032;}i:42;a:6:{i:0;s:143:"SELECT * FROM "cfg"."viewProduct" WHERE ("id" IN (6420, 5141, 4831, 3612, 6272, 5752, 5255, 6155)) AND ("cfg"."viewProduct"."recycleBin"=FALSE)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0054819583892822265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7538656;}i:45;a:6:{i:0;s:120:"SELECT "idvendor", COUNT(*) AS "purchaseCount" FROM "purchase" GROUP BY "idvendor" ORDER BY "purchaseCount" DESC LIMIT 8";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.032289028167724609375;i:4;a:3:{i:0;a:5:{s:4:"file";s:68:"/opt/lampp/htdocs/prod.apirest/modules/core/models/PurchaseQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:424;s:8:"function";s:3:"all";s:5:"class";s:37:"app\modules\core\models\PurchaseQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:240;s:8:"function";s:22:"countPurchasesByVendor";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7598232;}i:48;a:6:{i:0;s:65:"SELECT * FROM "vendor" WHERE "id" IN (11, 7, 8, 6, 13, 4, 14, 27)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0364329814910888671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:66:"/opt/lampp/htdocs/prod.apirest/modules/core/models/VendorQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:438;s:8:"function";s:3:"all";s:5:"class";s:35:"app\modules\core\models\VendorQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:240;s:8:"function";s:22:"countPurchasesByVendor";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7658256;}i:49;a:6:{i:0;s:68:"Opening DB connection: pgsql:host=147.93.69.62;dbname=farmacia_eitan";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1784578184.0364520549774169921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:66:"/opt/lampp/htdocs/prod.apirest/modules/core/models/VendorQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:438;s:8:"function";s:3:"all";s:5:"class";s:35:"app\modules\core\models\VendorQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:240;s:8:"function";s:22:"countPurchasesByVendor";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7662080;}i:54;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-20'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.04761791229248046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7728976;}i:57;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-21'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0509469509124755859375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7734512;}i:60;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-22'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0519640445709228515625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7739608;}i:63;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-23'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0529959201812744140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7744736;}i:66;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-24'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0543959140777587890625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7755496;}i:69;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-25'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0552670955657958984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7760624;}i:72;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-26'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0580260753631591796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7765752;}i:75;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-20'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.062015056610107421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7771376;}i:78;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-21'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.06258392333984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7776920;}i:81;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-22'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0630691051483154296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7782008;}i:84;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-23'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0634529590606689453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7787136;}i:87;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-24'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.06388092041015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7792264;}i:90;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-25'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0644071102142333984375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7797392;}i:93;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-26'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0648429393768310546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7803800;}i:96;a:6:{i:0;s:109:"SELECT "id", SUM(stock) AS "totalStock" FROM "cfg"."productStore" GROUP BY "id" ORDER BY "totalStock" LIMIT 8";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0656969547271728515625;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/opt/lampp/htdocs/prod.apirest/modules/core/models/ProductStoreQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:334;s:8:"function";s:3:"all";s:5:"class";s:41:"app\modules\core\models\ProductStoreQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:243;s:8:"function";s:8:"minStock";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7871784;}i:99;a:6:{i:0;s:163:"SELECT * FROM "cfg"."viewProduct" WHERE ("id" IN (5511, 6158, 5039, 4323, 4466, 4349, 4718, 5686)) AND ("idstatus"=10) AND ("cfg"."viewProduct"."recycleBin"=FALSE)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.070373058319091796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:346;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:243;s:8:"function";s:8:"minStock";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7888400;}i:102;a:6:{i:0;s:98:"SELECT * FROM "cfg"."productBranch" WHERE "id" IN (4323, 4349, 4466, 4718, 5039, 5511, 5686, 6158)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0727241039276123046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/prod.apirest/modules/core/models/ProductBranchQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:346;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:243;s:8:"function";s:8:"minStock";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7978024;}i:105;a:6:{i:0;s:103:"Access to debugger is denied due to IP address restriction. The requesting IP address is 200.105.212.59";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1784578184.0779221057891845703125;i:4;a:0:{}i:5;i:8146200;}}}";s:9:"profiling";s:54440:"a:3:{s:6:"memory";i:8183704;s:4:"time";d:0.1834719181060791015625;s:8:"messages";a:58:{i:16;a:6:{i:0;s:68:"Opening DB connection: pgsql:host=147.93.69.62;dbname=0_iooxs_access";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1784578183.937550067901611328125;i:4;a:2:{i:0;a:5:{s:4:"file";s:64:"/opt/lampp/htdocs/prod.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:74:"/opt/lampp/htdocs/prod.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:6135928;}i:17;a:6:{i:0;s:68:"Opening DB connection: pgsql:host=147.93.69.62;dbname=0_iooxs_access";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1784578183.94579601287841796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:64:"/opt/lampp/htdocs/prod.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:74:"/opt/lampp/htdocs/prod.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:6138872;}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:1784578183.9467270374298095703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:64:"/opt/lampp/htdocs/prod.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:74:"/opt/lampp/htdocs/prod.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:6284488;}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:1784578183.963882923126220703125;i:4;a:2:{i:0;a:5:{s:4:"file";s:64:"/opt/lampp/htdocs/prod.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:74:"/opt/lampp/htdocs/prod.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:6323400;}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:1784578183.964788913726806640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:64:"/opt/lampp/htdocs/prod.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:74:"/opt/lampp/htdocs/prod.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:6328808;}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:1784578183.9672069549560546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:64:"/opt/lampp/htdocs/prod.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:74:"/opt/lampp/htdocs/prod.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:6330752;}i:25;a:6:{i:0;s:48:"SELECT * FROM "cruge_user" WHERE "iduser"='3247'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578183.97002696990966796875;i:4;a:3:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/prod.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:64:"/opt/lampp/htdocs/prod.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:74:"/opt/lampp/htdocs/prod.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:6692112;}i:26;a:6:{i:0;s:48:"SELECT * FROM "cruge_user" WHERE "iduser"='3247'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578183.97072696685791015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:69:"/opt/lampp/htdocs/prod.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:64:"/opt/lampp/htdocs/prod.apirest/modules/core/models/CrugeUser.php";s:4:"line";i:98;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:74:"/opt/lampp/htdocs/prod.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:6697304;}i:32;a:6:{i:0;s:72:"Opening DB connection: pgsql:host=147.93.69.62;dbname=farmacia_eitan_sb0";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1784578183.9755289554595947265625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7364240;}i:33;a:6:{i:0;s:72:"Opening DB connection: pgsql:host=147.93.69.62;dbname=farmacia_eitan_sb0";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1784578183.98340511322021484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7367832;}i:34;a:6:{i:0;s:263:"SELECT "idproduct", COUNT(idproduct) AS "totalSales" FROM "productStock" INNER JOIN "document" "doc" ON "productStock"."iddocument" = "doc"."id" WHERE (NOT ("doc"."idsale" IS NULL)) AND ("doc"."idstatus"=40) GROUP BY "idproduct" ORDER BY "totalSales" DESC LIMIT 8";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578183.9834449291229248046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7369688;}i:35;a:6:{i:0;s:263:"SELECT "idproduct", COUNT(idproduct) AS "totalSales" FROM "productStock" INNER JOIN "document" "doc" ON "productStock"."iddocument" = "doc"."id" WHERE (NOT ("doc"."idsale" IS NULL)) AND ("doc"."idstatus"=40) GROUP BY "idproduct" ORDER BY "totalSales" DESC LIMIT 8";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578183.994184017181396484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7374792;}i:37;a:6:{i:0;s:2798:"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 = 'productStock' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578183.99444103240966796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7391040;}i:38;a:6:{i:0;s:2798:"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 = 'productStock' AND d.nspname = 'public' ORDER BY a.attnum;";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0007851123809814453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7436120;}i:40;a:6:{i:0;s:880:"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='productStock' 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:1784578184.0013959407806396484375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7407712;}i:41;a:6:{i:0;s:880:"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='productStock' 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:1784578184.00407505035400390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7411112;}i:43;a:6:{i:0;s:143:"SELECT * FROM "cfg"."viewProduct" WHERE ("id" IN (6420, 5141, 4831, 3612, 6272, 5752, 5255, 6155)) AND ("cfg"."viewProduct"."recycleBin"=FALSE)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.00551605224609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7540456;}i:44;a:6:{i:0;s:143:"SELECT * FROM "cfg"."viewProduct" WHERE ("id" IN (6420, 5141, 4831, 3612, 6272, 5752, 5255, 6155)) AND ("cfg"."viewProduct"."recycleBin"=FALSE)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.031002044677734375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:396;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:239;s:8:"function";s:18:"topSellingProducts";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7558736;}i:46;a:6:{i:0;s:120:"SELECT "idvendor", COUNT(*) AS "purchaseCount" FROM "purchase" GROUP BY "idvendor" ORDER BY "purchaseCount" DESC LIMIT 8";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.032321929931640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:68:"/opt/lampp/htdocs/prod.apirest/modules/core/models/PurchaseQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:424;s:8:"function";s:3:"all";s:5:"class";s:37:"app\modules\core\models\PurchaseQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:240;s:8:"function";s:22:"countPurchasesByVendor";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7600888;}i:47;a:6:{i:0;s:120:"SELECT "idvendor", COUNT(*) AS "purchaseCount" FROM "purchase" GROUP BY "idvendor" ORDER BY "purchaseCount" DESC LIMIT 8";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.03584003448486328125;i:4;a:3:{i:0;a:5:{s:4:"file";s:68:"/opt/lampp/htdocs/prod.apirest/modules/core/models/PurchaseQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:424;s:8:"function";s:3:"all";s:5:"class";s:37:"app\modules\core\models\PurchaseQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:240;s:8:"function";s:22:"countPurchasesByVendor";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7606296;}i:50;a:6:{i:0;s:68:"Opening DB connection: pgsql:host=147.93.69.62;dbname=farmacia_eitan";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1784578184.03645801544189453125;i:4;a:3:{i:0;a:5:{s:4:"file";s:66:"/opt/lampp/htdocs/prod.apirest/modules/core/models/VendorQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:438;s:8:"function";s:3:"all";s:5:"class";s:35:"app\modules\core\models\VendorQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:240;s:8:"function";s:22:"countPurchasesByVendor";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7663960;}i:51;a:6:{i:0;s:68:"Opening DB connection: pgsql:host=147.93.69.62;dbname=farmacia_eitan";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1784578184.0459499359130859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:66:"/opt/lampp/htdocs/prod.apirest/modules/core/models/VendorQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:438;s:8:"function";s:3:"all";s:5:"class";s:35:"app\modules\core\models\VendorQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:240;s:8:"function";s:22:"countPurchasesByVendor";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7666640;}i:52;a:6:{i:0;s:65:"SELECT * FROM "vendor" WHERE "id" IN (11, 7, 8, 6, 13, 4, 14, 27)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0459849834442138671875;i:4;a:3:{i:0;a:5:{s:4:"file";s:66:"/opt/lampp/htdocs/prod.apirest/modules/core/models/VendorQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:438;s:8:"function";s:3:"all";s:5:"class";s:35:"app\modules\core\models\VendorQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:240;s:8:"function";s:22:"countPurchasesByVendor";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7666720;}i:53;a:6:{i:0;s:65:"SELECT * FROM "vendor" WHERE "id" IN (11, 7, 8, 6, 13, 4, 14, 27)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.047048091888427734375;i:4;a:3:{i:0;a:5:{s:4:"file";s:66:"/opt/lampp/htdocs/prod.apirest/modules/core/models/VendorQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:438;s:8:"function";s:3:"all";s:5:"class";s:35:"app\modules\core\models\VendorQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:240;s:8:"function";s:22:"countPurchasesByVendor";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7678736;}i:55;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-20'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.047637939453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7731896;}i:56;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-20'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.050116062164306640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7733536;}i:58;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-21'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0509660243988037109375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7737432;}i:59;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-21'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0517070293426513671875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7739040;}i:61;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-22'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.05197906494140625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7742528;}i:62;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-22'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0527589321136474609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7744136;}i:64;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-23'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0530109405517578125;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7747656;}i:65;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-23'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.053863048553466796875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7754896;}i:67;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-24'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.05440807342529296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7758416;}i:68;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-24'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0551240444183349609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7760024;}i:70;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-25'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.055282115936279296875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7763544;}i:71;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-25'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.056468963623046875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7765152;}i:73;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-26'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0580389499664306640625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7768672;}i:74;a:6:{i:0;s:74:"SELECT SUM("montoTotal") FROM "sale" WHERE DATE("dateCreate")='2026-07-26'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0605070590972900390625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:90;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:241;s:8:"function";s:11:"salesByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7770280;}i:76;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-20'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.062036037445068359375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7774296;}i:77;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-20'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0624330043792724609375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7775944;}i:79;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-21'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0625998973846435546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7779840;}i:80;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-21'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.06295108795166015625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7781448;}i:82;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-22'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0630791187286376953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7784928;}i:83;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-22'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0633308887481689453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7786536;}i:85;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-23'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.06346607208251953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7790056;}i:86;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-23'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.063724040985107421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7791664;}i:88;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-24'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0638949871063232421875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7795184;}i:89;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-24'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0642769336700439453125;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7796792;}i:91;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-25'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0644190311431884765625;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7800312;}i:92;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-25'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0646998882293701171875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7801920;}i:94;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-26'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.064855098724365234375;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7806720;}i:95;a:6:{i:0;s:78:"SELECT SUM("montoTotal") FROM "purchase" WHERE DATE("dateCreate")='2026-07-26'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0651481151580810546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:246;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:242;s:8:"function";s:14:"purchaseByDate";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7808328;}i:97;a:6:{i:0;s:109:"SELECT "id", SUM(stock) AS "totalStock" FROM "cfg"."productStore" GROUP BY "id" ORDER BY "totalStock" LIMIT 8";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.0657069683074951171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/opt/lampp/htdocs/prod.apirest/modules/core/models/ProductStoreQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:334;s:8:"function";s:3:"all";s:5:"class";s:41:"app\modules\core\models\ProductStoreQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:243;s:8:"function";s:8:"minStock";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7874408;}i:98;a:6:{i:0;s:109:"SELECT "id", SUM(stock) AS "totalStock" FROM "cfg"."productStore" GROUP BY "id" ORDER BY "totalStock" LIMIT 8";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.07013607025146484375;i:4;a:3:{i:0;a:5:{s:4:"file";s:72:"/opt/lampp/htdocs/prod.apirest/modules/core/models/ProductStoreQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:334;s:8:"function";s:3:"all";s:5:"class";s:41:"app\modules\core\models\ProductStoreQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:243;s:8:"function";s:8:"minStock";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7880064;}i:100;a:6:{i:0;s:163:"SELECT * FROM "cfg"."viewProduct" WHERE ("id" IN (5511, 6158, 5039, 4323, 4466, 4349, 4718, 5686)) AND ("idstatus"=10) AND ("cfg"."viewProduct"."recycleBin"=FALSE)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.070396900177001953125;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:346;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:243;s:8:"function";s:8:"minStock";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7890016;}i:101;a:6:{i:0;s:163:"SELECT * FROM "cfg"."viewProduct" WHERE ("id" IN (5511, 6158, 5039, 4323, 4466, 4349, 4718, 5686)) AND ("idstatus"=10) AND ("cfg"."viewProduct"."recycleBin"=FALSE)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.072227001190185546875;i:4;a:2:{i:0;a:5:{s:4:"file";s:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:346;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:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:243;s:8:"function";s:8:"minStock";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7907968;}i:103;a:6:{i:0;s:98:"SELECT * FROM "cfg"."productBranch" WHERE "id" IN (4323, 4349, 4466, 4718, 5039, 5511, 5686, 6158)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.072741985321044921875;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/prod.apirest/modules/core/models/ProductBranchQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:346;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:243;s:8:"function";s:8:"minStock";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7979920;}i:104;a:6:{i:0;s:98:"SELECT * FROM "cfg"."productBranch" WHERE "id" IN (4323, 4349, 4466, 4718, 5039, 5511, 5686, 6158)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1784578184.075890064239501953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:73:"/opt/lampp/htdocs/prod.apirest/modules/core/models/ProductBranchQuery.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:71:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/services/ReportService.php";s:4:"line";i:346;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:77:"/opt/lampp/htdocs/prod.apirest/modules/apiv1/controllers/ReportController.php";s:4:"line";i:243;s:8:"function";s:8:"minStock";s:5:"class";s:40:"app\modules\apiv1\services\ReportService";s:4:"type";s:2:"::";}}i:5;i:7996528;}}}";s:5:"event";s:8649:"a:44:{i:0;a:5:{s:4:"time";d:1784578183.9252688884735107421875;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:1784578183.92716503143310546875;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:1784578183.93476390838623046875;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:1784578183.945786952972412109375;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:1784578183.9708530902862548828125;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:1784578183.970922946929931640625;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:1784578183.9710190296173095703125;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:1784578183.97327709197998046875;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:1784578183.9732949733734130859375;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:1784578183.9739229679107666015625;s:4:"name";s:12:"beforeAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:46:"app\modules\apiv1\controllers\ReportController";}i:10;a:5:{s:4:"time";d:1784578183.974690914154052734375;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:11;a:5:{s:4:"time";d:1784578183.974761962890625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:46:"app\modules\apiv1\models\entities\ProductStock";}i:12;a:5:{s:4:"time";d:1784578183.9749400615692138671875;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:13;a:5:{s:4:"time";d:1784578183.983398914337158203125;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:14;a:5:{s:4:"time";d:1784578184.004887104034423828125;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:39:"app\modules\core\models\BaseActiveQuery";}i:15;a:5:{s:4:"time";d:1784578184.0049378871917724609375;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:16;a:5:{s:4:"time";d:1784578184.0321509838104248046875;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\PurchaseQuery";}i:17;a:5:{s:4:"time";d:1784578184.0362899303436279296875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:35:"app\modules\core\models\VendorQuery";}i:18;a:5:{s:4:"time";d:1784578184.0459449291229248046875;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:19;a:5:{s:4:"time";d:1784578184.0475089550018310546875;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:20;a:5:{s:4:"time";d:1784578184.050846099853515625;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:21;a:5:{s:4:"time";d:1784578184.0518779754638671875;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:22;a:5:{s:4:"time";d:1784578184.0529510974884033203125;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:23;a:5:{s:4:"time";d:1784578184.054357051849365234375;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:24;a:5:{s:4:"time";d:1784578184.055222988128662109375;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:25;a:5:{s:4:"time";d:1784578184.057981967926025390625;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:26;a:5:{s:4:"time";d:1784578184.061952114105224609375;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\PurchaseQuery";}i:27;a:5:{s:4:"time";d:1784578184.0625369548797607421875;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\PurchaseQuery";}i:28;a:5:{s:4:"time";d:1784578184.0630309581756591796875;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\PurchaseQuery";}i:29;a:5:{s:4:"time";d:1784578184.0634100437164306640625;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\PurchaseQuery";}i:30;a:5:{s:4:"time";d:1784578184.063829898834228515625;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\PurchaseQuery";}i:31;a:5:{s:4:"time";d:1784578184.0643699169158935546875;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\PurchaseQuery";}i:32;a:5:{s:4:"time";d:1784578184.064795970916748046875;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\PurchaseQuery";}i:33;a:5:{s:4:"time";d:1784578184.0656459331512451171875;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\core\models\ProductStoreQuery";}i:34;a:5:{s:4:"time";d:1784578184.070269107818603515625;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:39:"app\modules\core\models\BaseActiveQuery";}i:35;a:5:{s:4:"time";d:1784578184.0723750591278076171875;s:4:"name";s:4:"init";s:5:"class";s:14:"yii\base\Event";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:35:"app\modules\core\models\ViewProduct";}i:36;a:5:{s:4:"time";d:1784578184.07264804840087890625;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\ProductBranchQuery";}i:37;a:5:{s:4:"time";d:1784578184.076179027557373046875;s:4:"name";s:11:"afterAction";s:5:"class";s:20:"yii\base\ActionEvent";s:8:"isStatic";s:1:"0";s:11:"senderClass";s:46:"app\modules\apiv1\controllers\ReportController";}i:38;a:5:{s:4:"time";d:1784578184.07697391510009765625;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:39;a:5:{s:4:"time";d:1784578184.076982021331787109375;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:40;a:5:{s:4:"time";d:1784578184.07699108123779296875;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:41;a:5:{s:4:"time";d:1784578184.0769989490509033203125;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:42;a:5:{s:4:"time";d:1784578184.0779359340667724609375;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:43;a:5:{s:4:"time";d:1784578184.0781040191650390625;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:118:"a:3:{s:5:"start";d:1784578183.89649200439453125;s:3:"end";d:1784578184.0801260471343994140625;s:6:"memory";i:8183704;}";s:4:"dump";s:6:"a:0:{}";s:6:"router";s:1567:"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:1784578183.925324916839599609375;i:4;a:0:{}i:5;i:4263280;}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:1784578183.92533397674560546875;i:4;a:0:{}i:5;i:4264032;}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:1784578183.9253389835357666015625;i:4;a:0:{}i:5;i:4264784;}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:1784578183.925342082977294921875;i:4;a:0:{}i:5;i:4265536;}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:1784578183.925345897674560546875;i:4;a:0:{}i:5;i:4266608;}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:1784578183.9253489971160888671875;i:4;a:0:{}i:5;i:4267360;}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:1784578183.9253509044647216796875;i:4;a:0:{}i:5;i:4267736;}}s:5:"route";s:22:"apiv1/report/dashboard";s:6:"action";s:65:"app\modules\apiv1\controllers\ReportController::actionDashboard()";}";s:7:"request";s:4918:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:15:{s:4:"host";s:22:"prod.apirest.velooz.io";s:10:"connection";s:10:"keep-alive";s:18:"sec-ch-ua-platform";s:9:""Windows"";s:13:"authorization";s:327:"Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiIsImp0aSI6IlVOSVFVRS1KV1QtSURFTlRJRklFUiJ9.eyJpc3MiOiJodHRwczpcL1wvYXBpLmV4YW1wbGUuY29tIiwiYXVkIjoiaHR0cHM6XC9cL2Zyb250ZW5kLmV4YW1wbGUuY29tIiwianRpIjoiVU5JUVVFLUpXVC1JREVOVElGSUVSIiwiaWF0IjoxNzg0NTc4MTgwLCJleHAiOjE3ODQ2NjQ1ODAsInVpZCI6MzI0N30.r1GSvYcCqZtl5hoVXmCoBiCh1_egIagNJ1QV9NkN4PU";s:10:"user-agent";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36";s:6:"accept";s:33:"application/json, text/plain, */*";s:9:"sec-ch-ua";s:64:""Not;A=Brand";v="8", "Chromium";v="150", "Google Chrome";v="150"";s:16:"sec-ch-ua-mobile";s:2:"?0";s:6:"origin";s:31:"https://temp.farmacia.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:32:"https://temp.farmacia.velooz.io/";s:15:"accept-encoding";s:23:"gzip, deflate, br, zstd";s:15:"accept-language";s:14:"es-ES,es;q=0.9";}s:15:"responseHeaders";a:8:{s:12:"X-Powered-By";s:9:"PHP/7.3.0";s:27:"Access-Control-Allow-Origin";s:31:"https://temp.farmacia.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:31:"application/json; charset=UTF-8";s:10:"Set-Cookie";s:204:"_csrf=461c432bf667984b70de49fe6aff6515344bd3e6c9424e72c098c34e2ffd8fa0a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22eIzJKdVapB-67whq-hPGHIAoTp6vQuaj%22%3B%7D; path=/; HttpOnly; SameSite=Lax";}s:5:"route";s:22:"apiv1/report/dashboard";s:6:"action";s:65:"app\modules\apiv1\controllers\ReportController::actionDashboard()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:3:"GET";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:1;}s:11:"requestBody";a:0:{}s:6:"SERVER";a:47:{s:18:"REDIRECT_UNIQUE_ID";s:27:"al6Ah3V8ryJ7AgkVbek1yAAAAA4";s:14:"REDIRECT_HTTPS";s:2:"on";s:20:"REDIRECT_SSL_TLS_SNI";s:22:"prod.apirest.velooz.io";s:15:"REDIRECT_STATUS";s:3:"200";s:9:"UNIQUE_ID";s:27:"al6Ah3V8ryJ7AgkVbek1yAAAAA4";s:5:"HTTPS";s:2:"on";s:11:"SSL_TLS_SNI";s:22:"prod.apirest.velooz.io";s:9:"HTTP_HOST";s:22:"prod.apirest.velooz.io";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:23:"HTTP_SEC_CH_UA_PLATFORM";s:9:""Windows"";s:15:"HTTP_USER_AGENT";s:111:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36";s:11:"HTTP_ACCEPT";s:33:"application/json, text/plain, */*";s:14:"HTTP_SEC_CH_UA";s:64:""Not;A=Brand";v="8", "Chromium";v="150", "Google Chrome";v="150"";s:21:"HTTP_SEC_CH_UA_MOBILE";s:2:"?0";s:11:"HTTP_ORIGIN";s:31:"https://temp.farmacia.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:32:"https://temp.farmacia.velooz.io/";s:20:"HTTP_ACCEPT_ENCODING";s:23:"gzip, deflate, br, zstd";s:20:"HTTP_ACCEPT_LANGUAGE";s:14:"es-ES,es;q=0.9";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:22:"prod.apirest.velooz.io";s:11:"SERVER_ADDR";s:12:"147.93.69.62";s:11:"SERVER_PORT";s:3:"443";s:11:"REMOTE_ADDR";s:14:"200.105.212.59";s:13:"DOCUMENT_ROOT";s:30:"/opt/lampp/htdocs/prod.apirest";s:14:"REQUEST_SCHEME";s:5:"https";s:14:"CONTEXT_PREFIX";s:0:"";s:21:"CONTEXT_DOCUMENT_ROOT";s:30:"/opt/lampp/htdocs/prod.apirest";s:12:"SERVER_ADMIN";s:15:"you@example.com";s:15:"SCRIPT_FILENAME";s:44:"/opt/lampp/htdocs/prod.apirest/web/index.php";s:11:"REMOTE_PORT";s:4:"2023";s:12:"REDIRECT_URL";s:27:"/web/apiv1/report/dashboard";s:21:"REDIRECT_QUERY_STRING";s:56:"date=2026-07-20&type=week&month=undefined&year=undefined";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:3:"GET";s:12:"QUERY_STRING";s:56:"date=2026-07-20&type=week&month=undefined&year=undefined";s:11:"REQUEST_URI";s:84:"/web/apiv1/report/dashboard?date=2026-07-20&type=week&month=undefined&year=undefined";s:11:"SCRIPT_NAME";s:14:"/web/index.php";s:8:"PHP_SELF";s:14:"/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1784578183.8840000629425048828125;s:12:"REQUEST_TIME";i:1784578183;}s:3:"GET";a:4:{s:4:"date";s:10:"2026-07-20";s:4:"type";s:4:"week";s:5:"month";s:9:"undefined";s:4:"year";s:9:"undefined";}s:4:"POST";a:0:{}s:6:"COOKIE";a:0:{}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}";s:4:"user";s:2404:"a:5:{s:2:"id";i:3247;s:8:"identity";a:22:{s:6:"iduser";s:4:"3247";s:7:"regdate";s:4:"null";s:7:"actdate";s:10:"1773956842";s:9:"logondate";s:4:"null";s:8:"username";s:25:"'farmacia_eitan_virginia'";s:5:"email";s:20:"'khitadoc@gmail.com'";s:8:"password";s:34:"'456e6c6ca021ea4cf737698b84febac8'";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:20:"'VIRGINIA ALANOCA '";s:4:"name";s:18:"'VIRGINIA ALANOCA'";s:8:"lastname";s:2:"''";s:7:"surname";s:2:"''";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:3:"156";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:"6a5e8087e10cf";s:3:"url";s:114:"https://prod.apirest.velooz.io/web/apiv1/report/dashboard?date=2026-07-20&type=week&month=undefined&year=undefined";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:14:"200.105.212.59";s:4:"time";d:1784578183.8840000629425048828125;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:8183704;s:14:"processingTime";d:0.1834719181060791015625;}s:10:"exceptions";a:0:{}}