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:3185:"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:"59260";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:1547979716.6838169097900390625;s:12:"REQUEST_TIME";i:1547979716;}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:5514:"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:1547979716.7668609619140625;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:1547979716.766890048980712890625;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:1547979716.7926509380340576171875;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:1547979716.79304790496826171875;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:1547979716.7945349216461181640625;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:1547979716.795597076416015625;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:1547979716.7976610660552978515625;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:1547979716.801167011260986328125;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:1547979716.8016169071197509765625;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:1547979716.80300807952880859375;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:1547979716.803740024566650390625;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:1547979716.8042600154876708984375;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:1547979716.8047459125518798828125;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:1547979716.805210113525390625;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:1547979716.805636882781982421875;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:1547979716.8060700893402099609375;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:1547979716.8138749599456787109375;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:1547979716.8144180774688720703125;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:1547979716.814918041229248046875;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:1547979716.8165509700775146484375;i:4;a:0:{}i:5;i:7476536;}}}";s:9:"profiling";s:10641:"a:3:{s:6:"memory";i:7815552;s:4:"time";d:0.1273000240325927734375;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:1547979716.7669010162353515625;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:1547979716.7674338817596435546875;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:1547979716.767465114593505859375;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:1547979716.7680170536041259765625;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:1547979716.79265689849853515625;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:1547979716.7929871082305908203125;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:1547979716.793076992034912109375;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:1547979716.793301105499267578125;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:1547979716.79455089569091796875;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:1547979716.7949860095977783203125;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:1547979716.795609951019287109375;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:1547979716.7961089611053466796875;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:1547979716.79767894744873046875;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:1547979716.798017024993896484375;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:1547979716.801188945770263671875;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:1547979716.801536083221435546875;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:1547979716.8016300201416015625;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:1547979716.8024799823760986328125;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:1547979716.8030259609222412109375;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:1547979716.803391933441162109375;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:1547979716.8037550449371337890625;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:1547979716.8039200305938720703125;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:1547979716.804275035858154296875;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:1547979716.8044769763946533203125;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:1547979716.80476093292236328125;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:1547979716.8049190044403076171875;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:1547979716.805223941802978515625;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:1547979716.8053619861602783203125;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:1547979716.8056509494781494140625;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:1547979716.8057858943939208984375;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:1547979716.8060929775238037109375;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:1547979716.8134191036224365234375;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:1547979716.8138968944549560546875;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:1547979716.8140900135040283203125;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:1547979716.81443309783935546875;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:1547979716.8146231174468994140625;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:1547979716.8149330615997314453125;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:1547979716.8151400089263916015625;i:4;a:0:{}i:5;i:7543736;}}}";s:2:"db";s:9833:"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:1547979716.767465114593505859375;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:1547979716.7680170536041259765625;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:1547979716.793076992034912109375;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:1547979716.793301105499267578125;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:1547979716.79455089569091796875;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:1547979716.7949860095977783203125;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:1547979716.795609951019287109375;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:1547979716.7961089611053466796875;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:1547979716.79767894744873046875;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:1547979716.798017024993896484375;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:1547979716.801188945770263671875;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:1547979716.801536083221435546875;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:1547979716.8016300201416015625;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:1547979716.8024799823760986328125;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:1547979716.8030259609222412109375;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:1547979716.803391933441162109375;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:1547979716.8037550449371337890625;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:1547979716.8039200305938720703125;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:1547979716.804275035858154296875;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:1547979716.8044769763946533203125;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:1547979716.80476093292236328125;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:1547979716.8049190044403076171875;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:1547979716.805223941802978515625;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:1547979716.8053619861602783203125;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:1547979716.8056509494781494140625;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:1547979716.8057858943939208984375;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:1547979716.8060929775238037109375;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:1547979716.8134191036224365234375;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:1547979716.8138968944549560546875;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:1547979716.8140900135040283203125;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:1547979716.81443309783935546875;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:1547979716.8146231174468994140625;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:1547979716.8149330615997314453125;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:1547979716.8151400089263916015625;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:122:"a:3:{s:5:"start";d:1547979716.697866916656494140625;s:3:"end";d:1547979716.8255159854888916015625;s:6:"memory";i:7846784;}";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:"5c444bc4b82a1";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:1547979716.6838169097900390625;s:10:"statusCode";i:200;s:8:"sqlCount";i:17;s:9:"mailCount";i:0;}s:10:"exceptions";a:0:{}}