a:12:{s:6:"config";s:1905:"a:5:{s:10:"phpVersion";s:6:"5.6.20";s:10:"yiiVersion";s:8:"2.0.15.1";s:11:"application";a:8:{s:3:"yii";s:8:"2.0.15.1";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:4:"prod";s:5:"debug";b:0;}s:3:"php";a:5:{s:7:"version";s:6:"5.6.20";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:22:"yiisoft/yii2-bootstrap";a:3:{s:4:"name";s:22:"yiisoft/yii2-bootstrap";s:7:"version";s:7:"2.0.8.0";s:5:"alias";a:1:{s:14:"@yii/bootstrap";s:61:"/home/.sites/132/site12/web/vendor/yiisoft/yii2-bootstrap/src";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:8:"2.0.13.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:53:"/home/.sites/132/site12/web/vendor/yiisoft/yii2-debug";}}s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.0.7.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:59:"/home/.sites/132/site12/web/vendor/yiisoft/yii2-swiftmailer";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.0.7.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:55:"/home/.sites/132/site12/web/vendor/yiisoft/yii2-gii/src";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:53:"/home/.sites/132/site12/web/vendor/yiisoft/yii2-faker";}}s:25:"kartik-v/yii2-krajee-base";a:3:{s:4:"name";s:25:"kartik-v/yii2-krajee-base";s:7:"version";s:7:"1.8.9.0";s:5:"alias";a:1:{s:12:"@kartik/base";s:60:"/home/.sites/132/site12/web/vendor/kartik-v/yii2-krajee-base";}}s:31:"kartik-v/yii2-widget-datepicker";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-datepicker";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:12:"@kartik/date";s:66:"/home/.sites/132/site12/web/vendor/kartik-v/yii2-widget-datepicker";}}}}";s:7:"request";s:3187:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:10:{s:14:"content-length";s:2:"17";s:12:"content-type";s:16:"application/json";s:6:"accept";s:33:"application/json, text/plain, */*";s:15:"accept-encoding";s:13:"gzip, deflate";s:15:"accept-language";s:17:"es-ES,en-US;q=0.9";s:10:"connection";s:10:"keep-alive";s:4:"host";s:14:"b.trackcms.com";s:6:"origin";s:7:"file://";s:10:"user-agent";s:154:"Mozilla/5.0 (Linux; Android 6.0.1; SM-G532M Build/MMB29T; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/64.0.3282.137 Mobile Safari/537.36";s:16:"x-requested-with";s:27:"condition.monitoring.system";}s:15:"responseHeaders";a:5:{s:12:"X-Powered-By";s:10:"PHP/5.6.20";s:27:"Access-Control-Allow-Origin";s:7:"file://";s:32:"Access-Control-Allow-Credentials";s:4:"true";s:22:"Access-Control-Max-Age";s:5:"86400";s:12:"Content-Type";s:24:"text/html; charset=UTF-8";}s:5:"route";s:22:"cmsapp/getunitstatuses";s:6:"action";s:62:"frontend\controllers\CmsappController::actionGetunitstatuses()";s:12:"actionParams";a:0:{}s:7:"general";a:5:{s:6:"method";s:4:"POST";s:6:"isAjax";b:0;s:6:"isPjax";b:0;s:7:"isFlash";b:0;s:18:"isSecureConnection";b:0;}s:11:"requestBody";a:3:{s:12:"Content Type";s:16:"application/json";s:3:"Raw";s:17:"{"unitId":"7669"}";s:17:"Decoded to Params";a:0:{}}s:6:"SERVER";a:34:{s:14:"CONTENT_LENGTH";s:2:"17";s:12:"CONTENT_TYPE";s:16:"application/json";s:13:"DOCUMENT_ROOT";s:27:"/home/.sites/132/site12/web";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:11:"HTTP_ACCEPT";s:33:"application/json, text/plain, */*";s:20:"HTTP_ACCEPT_ENCODING";s:13:"gzip, deflate";s:20:"HTTP_ACCEPT_LANGUAGE";s:17:"es-ES,en-US;q=0.9";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:9:"HTTP_HOST";s:14:"b.trackcms.com";s:11:"HTTP_ORIGIN";s:7:"file://";s:15:"HTTP_USER_AGENT";s:154:"Mozilla/5.0 (Linux; Android 6.0.1; SM-G532M Build/MMB29T; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/64.0.3282.137 Mobile Safari/537.36";s:21:"HTTP_X_REQUESTED_WITH";s:27:"condition.monitoring.system";s:4:"PATH";s:4:"/bin";s:5:"PHPRC";s:26:"/home/sites/b.trackcms.com";s:12:"QUERY_STRING";s:26:"r=cmsapp%2Fgetunitstatuses";s:15:"REDIRECT_STATUS";s:3:"200";s:11:"REMOTE_ADDR";s:14:"187.189.201.26";s:11:"REMOTE_PORT";s:5:"25246";s:14:"REQUEST_METHOD";s:4:"POST";s:11:"REQUEST_URI";s:50:"/frontend/web/index.php?r=cmsapp%2Fgetunitstatuses";s:15:"SCRIPT_FILENAME";s:50:"/home/.sites/132/site12/web/frontend/web/index.php";s:11:"SCRIPT_NAME";s:23:"/frontend/web/index.php";s:10:"SCRIPT_URI";s:44:"http://b.trackcms.com/frontend/web/index.php";s:10:"SCRIPT_URL";s:23:"/frontend/web/index.php";s:11:"SERVER_ADDR";s:15:"216.230.227.190";s:12:"SERVER_ADMIN";s:5:"admin";s:11:"SERVER_NAME";s:14:"b.trackcms.com";s:11:"SERVER_PORT";s:2:"80";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:16:"SERVER_SIGNATURE";s:59:"
Apache Server at b.trackcms.com Port 80 ";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:8:"PHP_SELF";s:23:"/frontend/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1547979975.303225994110107421875;s:12:"REQUEST_TIME";i:1547979975;}s:3:"GET";a:1:{s:1:"r";s:22:"cmsapp/getunitstatuses";}s:4:"POST";a:0:{}s:6:"COOKIE";a:0:{}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}";s:3:"log";s:5519:"a:1:{s:8:"messages";a:20:{i:0;a:6:{i:0;s:913:"SELECT D.TerminalId, US.CommunicationStatus, TZ.Diff, D.ReportDate, US.TransmissionMedia, US.EngineStatus, US.BatteryAlimentation, US.Celerity, D.Latitude, D.Longitude, D.Speed FROM zapata.tbl_unit U JOIN zapata.tbl_device D ON U.DeviceId=D.Id JOIN fleetsys.tbl_operation_group O ON U.OperationGroupId=O.Id JOIN fleetsys.tbl_time_zone_enum TZ ON O.TimeZoneId=TZ.Id JOIN fleetsys.tbl_unit_statuses US ON U.Id=US.UnitId WHERE U.Id = 7669";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.383408069610595703125;i:4;a:0:{}i:5;i:5115768;}i:1;a:6:{i:0;s:57:"Opening DB connection: mysql:host=localhost;dbname=avatar";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1547979975.383429050445556640625;i:4;a:0:{}i:5;i:5119368;}i:6;a:6:{i:0;s:59:"Opening DB connection: mysql:host=localhost;dbname=fleetsys";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1547979975.40962696075439453125;i:4;a:0:{}i:5;i:7098904;}i:9;a:6:{i:0;s:54:"SELECT * FROM `tbl_active_alarm` WHERE `UnitId`='7669'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4099910259246826171875;i:4;a:0:{}i:5;i:7110080;}i:12;a:6:{i:0;s:55:"SELECT * FROM `tbl_unit_variable` WHERE `UnitId`='7669'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.411468029022216796875;i:4;a:0:{}i:5;i:7182416;}i:15;a:6:{i:0;s:42:"SHOW FULL COLUMNS FROM `tbl_unit_variable`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4128010272979736328125;i:4;a:0:{}i:5;i:7223024;}i:18;a:6:{i:0;s:621:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'tbl_unit_variable' AND kcu.table_name = 'tbl_unit_variable'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4149210453033447265625;i:4;a:0:{}i:5;i:7284888;}i:21;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='276'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4183299541473388671875;i:4;a:0:{}i:5;i:7418088;}i:24;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `tbl_spn`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4187300205230712890625;i:4;a:0:{}i:5;i:7426824;}i:27;a:6:{i:0;s:601:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'tbl_spn' AND kcu.table_name = 'tbl_spn'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.419783115386962890625;i:4;a:0:{}i:5;i:7450032;}i:30;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='280'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4203948974609375;i:4;a:0:{}i:5;i:7456160;}i:33;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='283'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4208700656890869140625;i:4;a:0:{}i:5;i:7466344;}i:36;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='286'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4212749004364013671875;i:4;a:0:{}i:5;i:7476264;}i:39;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='291'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.42173290252685546875;i:4;a:0:{}i:5;i:7486184;}i:42;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='292'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.42214107513427734375;i:4;a:0:{}i:5;i:7496104;}i:45;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='332'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4226310253143310546875;i:4;a:0:{}i:5;i:7506016;}i:48;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='498'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4231140613555908203125;i:4;a:0:{}i:5;i:7515936;}i:51;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='499'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.42354488372802734375;i:4;a:0:{}i:5;i:7525864;}i:54;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='500'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4239490032196044921875;i:4;a:0:{}i:5;i:7535856;}i:57;a:6:{i:0;s:103:"Access to debugger is denied due to IP address restriction. The requesting IP address is 187.189.201.26";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1547979975.4253680706024169921875;i:4;a:0:{}i:5;i:7476536;}}}";s:9:"profiling";s:10638:"a:3:{s:6:"memory";i:7815536;s:4:"time";d:0.1162579059600830078125;s:8:"messages";a:38:{i:2;a:6:{i:0;s:57:"Opening DB connection: mysql:host=localhost;dbname=avatar";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1547979975.3834331035614013671875;i:4;a:0:{}i:5;i:5120592;}i:3;a:6:{i:0;s:57:"Opening DB connection: mysql:host=localhost;dbname=avatar";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1547979975.384068965911865234375;i:4;a:0:{}i:5;i:5130552;}i:4;a:6:{i:0;s:913:"SELECT D.TerminalId, US.CommunicationStatus, TZ.Diff, D.ReportDate, US.TransmissionMedia, US.EngineStatus, US.BatteryAlimentation, US.Celerity, D.Latitude, D.Longitude, D.Speed FROM zapata.tbl_unit U JOIN zapata.tbl_device D ON U.DeviceId=D.Id JOIN fleetsys.tbl_operation_group O ON U.OperationGroupId=O.Id JOIN fleetsys.tbl_time_zone_enum TZ ON O.TimeZoneId=TZ.Id JOIN fleetsys.tbl_unit_statuses US ON U.Id=US.UnitId WHERE U.Id = 7669";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.3841140270233154296875;i:4;a:0:{}i:5;i:5134160;}i:5;a:6:{i:0;s:913:"SELECT D.TerminalId, US.CommunicationStatus, TZ.Diff, D.ReportDate, US.TransmissionMedia, US.EngineStatus, US.BatteryAlimentation, US.Celerity, D.Latitude, D.Longitude, D.Speed FROM zapata.tbl_unit U JOIN zapata.tbl_device D ON U.DeviceId=D.Id JOIN fleetsys.tbl_operation_group O ON U.OperationGroupId=O.Id JOIN fleetsys.tbl_time_zone_enum TZ ON O.TimeZoneId=TZ.Id JOIN fleetsys.tbl_unit_statuses US ON U.Id=US.UnitId WHERE U.Id = 7669";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.38520908355712890625;i:4;a:0:{}i:5;i:5139240;}i:7;a:6:{i:0;s:59:"Opening DB connection: mysql:host=localhost;dbname=fleetsys";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1547979975.4096319675445556640625;i:4;a:0:{}i:5;i:7100064;}i:8;a:6:{i:0;s:59:"Opening DB connection: mysql:host=localhost;dbname=fleetsys";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1547979975.4099218845367431640625;i:4;a:0:{}i:5;i:7109024;}i:10;a:6:{i:0;s:54:"SELECT * FROM `tbl_active_alarm` WHERE `UnitId`='7669'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.410015106201171875;i:4;a:0:{}i:5;i:7112176;}i:11;a:6:{i:0;s:54:"SELECT * FROM `tbl_active_alarm` WHERE `UnitId`='7669'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4102399349212646484375;i:4;a:0:{}i:5;i:7114224;}i:13;a:6:{i:0;s:55:"SELECT * FROM `tbl_unit_variable` WHERE `UnitId`='7669'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4114840030670166015625;i:4;a:0:{}i:5;i:7184376;}i:14;a:6:{i:0;s:55:"SELECT * FROM `tbl_unit_variable` WHERE `UnitId`='7669'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4121510982513427734375;i:4;a:0:{}i:5;i:7203760;}i:16;a:6:{i:0;s:42:"SHOW FULL COLUMNS FROM `tbl_unit_variable`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4128139019012451171875;i:4;a:0:{}i:5;i:7225000;}i:17;a:6:{i:0;s:42:"SHOW FULL COLUMNS FROM `tbl_unit_variable`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.413322925567626953125;i:4;a:0:{}i:5;i:7242696;}i:19;a:6:{i:0;s:621:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'tbl_unit_variable' AND kcu.table_name = 'tbl_unit_variable'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.41493701934814453125;i:4;a:0:{}i:5;i:7287816;}i:20;a:6:{i:0;s:621:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'tbl_unit_variable' AND kcu.table_name = 'tbl_unit_variable'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4152610301971435546875;i:4;a:0:{}i:5;i:7292792;}i:22;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='276'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.418344974517822265625;i:4;a:0:{}i:5;i:7420016;}i:23;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='276'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.418653964996337890625;i:4;a:0:{}i:5;i:7425968;}i:25;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `tbl_spn`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4187428951263427734375;i:4;a:0:{}i:5;i:7428824;}i:26;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `tbl_spn`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.419313907623291015625;i:4;a:0:{}i:5;i:7464816;}i:28;a:6:{i:0;s:601:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'tbl_spn' AND kcu.table_name = 'tbl_spn'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4198000431060791015625;i:4;a:0:{}i:5;i:7452944;}i:29;a:6:{i:0;s:601:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'tbl_spn' AND kcu.table_name = 'tbl_spn'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.420075893402099609375;i:4;a:0:{}i:5;i:7457928;}i:31;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='280'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.42041110992431640625;i:4;a:0:{}i:5;i:7458088;}i:32;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='280'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.42057895660400390625;i:4;a:0:{}i:5;i:7464032;}i:34;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='283'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4208838939666748046875;i:4;a:0:{}i:5;i:7468272;}i:35;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='283'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.42101001739501953125;i:4;a:0:{}i:5;i:7474208;}i:37;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='286'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.421288967132568359375;i:4;a:0:{}i:5;i:7478192;}i:38;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='286'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.421473026275634765625;i:4;a:0:{}i:5;i:7484128;}i:40;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='291'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4217469692230224609375;i:4;a:0:{}i:5;i:7488112;}i:41;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='291'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4218719005584716796875;i:4;a:0:{}i:5;i:7494048;}i:43;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='292'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.422154903411865234375;i:4;a:0:{}i:5;i:7498032;}i:44;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='292'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4223439693450927734375;i:4;a:0:{}i:5;i:7503960;}i:46;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='332'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.422646045684814453125;i:4;a:0:{}i:5;i:7507944;}i:47;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='332'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4228498935699462890625;i:4;a:0:{}i:5;i:7513888;}i:49;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='498'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4231278896331787109375;i:4;a:0:{}i:5;i:7517864;}i:50;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='498'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4232780933380126953125;i:4;a:0:{}i:5;i:7523800;}i:52;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='499'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4235589504241943359375;i:4;a:0:{}i:5;i:7527792;}i:53;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='499'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4236850738525390625;i:4;a:0:{}i:5;i:7533752;}i:55;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='500'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.423964023590087890625;i:4;a:0:{}i:5;i:7537784;}i:56;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='500'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.424087047576904296875;i:4;a:0:{}i:5;i:7543736;}}}";s:2:"db";s:9826:"a:1:{s:8:"messages";a:34:{i:4;a:6:{i:0;s:913:"SELECT D.TerminalId, US.CommunicationStatus, TZ.Diff, D.ReportDate, US.TransmissionMedia, US.EngineStatus, US.BatteryAlimentation, US.Celerity, D.Latitude, D.Longitude, D.Speed FROM zapata.tbl_unit U JOIN zapata.tbl_device D ON U.DeviceId=D.Id JOIN fleetsys.tbl_operation_group O ON U.OperationGroupId=O.Id JOIN fleetsys.tbl_time_zone_enum TZ ON O.TimeZoneId=TZ.Id JOIN fleetsys.tbl_unit_statuses US ON U.Id=US.UnitId WHERE U.Id = 7669";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.3841140270233154296875;i:4;a:0:{}i:5;i:5134160;}i:5;a:6:{i:0;s:913:"SELECT D.TerminalId, US.CommunicationStatus, TZ.Diff, D.ReportDate, US.TransmissionMedia, US.EngineStatus, US.BatteryAlimentation, US.Celerity, D.Latitude, D.Longitude, D.Speed FROM zapata.tbl_unit U JOIN zapata.tbl_device D ON U.DeviceId=D.Id JOIN fleetsys.tbl_operation_group O ON U.OperationGroupId=O.Id JOIN fleetsys.tbl_time_zone_enum TZ ON O.TimeZoneId=TZ.Id JOIN fleetsys.tbl_unit_statuses US ON U.Id=US.UnitId WHERE U.Id = 7669";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.38520908355712890625;i:4;a:0:{}i:5;i:5139240;}i:10;a:6:{i:0;s:54:"SELECT * FROM `tbl_active_alarm` WHERE `UnitId`='7669'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.410015106201171875;i:4;a:0:{}i:5;i:7112176;}i:11;a:6:{i:0;s:54:"SELECT * FROM `tbl_active_alarm` WHERE `UnitId`='7669'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4102399349212646484375;i:4;a:0:{}i:5;i:7114224;}i:13;a:6:{i:0;s:55:"SELECT * FROM `tbl_unit_variable` WHERE `UnitId`='7669'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4114840030670166015625;i:4;a:0:{}i:5;i:7184376;}i:14;a:6:{i:0;s:55:"SELECT * FROM `tbl_unit_variable` WHERE `UnitId`='7669'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4121510982513427734375;i:4;a:0:{}i:5;i:7203760;}i:16;a:6:{i:0;s:42:"SHOW FULL COLUMNS FROM `tbl_unit_variable`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4128139019012451171875;i:4;a:0:{}i:5;i:7225000;}i:17;a:6:{i:0;s:42:"SHOW FULL COLUMNS FROM `tbl_unit_variable`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.413322925567626953125;i:4;a:0:{}i:5;i:7242696;}i:19;a:6:{i:0;s:621:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'tbl_unit_variable' AND kcu.table_name = 'tbl_unit_variable'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.41493701934814453125;i:4;a:0:{}i:5;i:7287816;}i:20;a:6:{i:0;s:621:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'tbl_unit_variable' AND kcu.table_name = 'tbl_unit_variable'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4152610301971435546875;i:4;a:0:{}i:5;i:7292792;}i:22;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='276'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.418344974517822265625;i:4;a:0:{}i:5;i:7420016;}i:23;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='276'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.418653964996337890625;i:4;a:0:{}i:5;i:7425968;}i:25;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `tbl_spn`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4187428951263427734375;i:4;a:0:{}i:5;i:7428824;}i:26;a:6:{i:0;s:32:"SHOW FULL COLUMNS FROM `tbl_spn`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.419313907623291015625;i:4;a:0:{}i:5;i:7464816;}i:28;a:6:{i:0;s:601:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'tbl_spn' AND kcu.table_name = 'tbl_spn'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4198000431060791015625;i:4;a:0:{}i:5;i:7452944;}i:29;a:6:{i:0;s:601:"SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'tbl_spn' AND kcu.table_name = 'tbl_spn'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.420075893402099609375;i:4;a:0:{}i:5;i:7457928;}i:31;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='280'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.42041110992431640625;i:4;a:0:{}i:5;i:7458088;}i:32;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='280'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.42057895660400390625;i:4;a:0:{}i:5;i:7464032;}i:34;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='283'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4208838939666748046875;i:4;a:0:{}i:5;i:7468272;}i:35;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='283'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.42101001739501953125;i:4;a:0:{}i:5;i:7474208;}i:37;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='286'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.421288967132568359375;i:4;a:0:{}i:5;i:7478192;}i:38;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='286'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.421473026275634765625;i:4;a:0:{}i:5;i:7484128;}i:40;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='291'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4217469692230224609375;i:4;a:0:{}i:5;i:7488112;}i:41;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='291'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4218719005584716796875;i:4;a:0:{}i:5;i:7494048;}i:43;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='292'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.422154903411865234375;i:4;a:0:{}i:5;i:7498032;}i:44;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='292'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4223439693450927734375;i:4;a:0:{}i:5;i:7503960;}i:46;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='332'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.422646045684814453125;i:4;a:0:{}i:5;i:7507944;}i:47;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='332'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4228498935699462890625;i:4;a:0:{}i:5;i:7513888;}i:49;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='498'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4231278896331787109375;i:4;a:0:{}i:5;i:7517864;}i:50;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='498'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4232780933380126953125;i:4;a:0:{}i:5;i:7523800;}i:52;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='499'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4235589504241943359375;i:4;a:0:{}i:5;i:7527792;}i:53;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='499'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.4236850738525390625;i:4;a:0:{}i:5;i:7533752;}i:55;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='500'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.423964023590087890625;i:4;a:0:{}i:5;i:7537784;}i:56;a:6:{i:0;s:40:"SELECT * FROM `tbl_spn` WHERE `Id`='500'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1547979975.424087047576904296875;i:4;a:0:{}i:5;i:7543736;}}}";s:6:"assets";s:6:"a:0:{}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:121:"a:3:{s:5:"start";d:1547979975.3174231052398681640625;s:3:"end";d:1547979975.43402194976806640625;s:6:"memory";i:7846720;}";s:4:"user";s:2:"N;";s:6:"router";s:27:"a:1:{s:8:"messages";a:0:{}}";s:7:"summary";a:9:{s:3:"tag";s:13:"5c444cc75aa4c";s:3:"url";s:71:"http://b.trackcms.com/frontend/web/index.php?r=cmsapp%2Fgetunitstatuses";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:14:"187.189.201.26";s:4:"time";d:1547979975.303225994110107421875;s:10:"statusCode";i:200;s:8:"sqlCount";i:17;s:9:"mailCount";i:0;}s:10:"exceptions";a:0:{}}