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:3573:"a:15:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:11:{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:6:"cookie";s:44:"advanced-frontend=0stsceov01ndq1d7d8j6ghnr35";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:8:{s:12:"X-Powered-By";s:10:"PHP/5.6.20";s:7:"Expires";s:29:"Thu, 19 Nov 1981 08:52:00 GMT";s:13:"Cache-Control";s:62:"no-store, no-cache, must-revalidate, post-check=0, pre-check=0";s:6:"Pragma";s:8:"no-cache";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:35:{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:11:"HTTP_COOKIE";s:44:"advanced-frontend=0stsceov01ndq1d7d8j6ghnr35";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:"29036";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:1547998192.8442409038543701171875;s:12:"REQUEST_TIME";i:1547998192;}s:3:"GET";a:1:{s:1:"r";s:22:"cmsapp/getunitstatuses";}s:4:"POST";a:0:{}s:6:"COOKIE";a:1:{s:17:"advanced-frontend";s:26:"0stsceov01ndq1d7d8j6ghnr35";}s:5:"FILES";a:0:{}s:7:"SESSION";a:1:{s:7:"__flash";a:0:{}}}";s:3:"log";s:5661:"a:1:{s:8:"messages";a:21:{i:0;a:6:{i:0;s:15:"Session started";i:1;i:4;i:2;s:21:"yii\web\Session::open";i:3;d:1547998192.9122660160064697265625;i:4;a:0:{}i:5;i:4052784;}i:1;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:1547998192.9321019649505615234375;i:4;a:0:{}i:5;i:5341784;}i:2;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:1547998192.9321310520172119140625;i:4;a:0:{}i:5;i:5345184;}i:7;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:1547998192.983829975128173828125;i:4;a:0:{}i:5;i:7324616;}i:10;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:1547998192.9844110012054443359375;i:4;a:0:{}i:5;i:7335808;}i:13;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:1547998193.0015280246734619140625;i:4;a:0:{}i:5;i:7408152;}i:16;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:1547998193.0119531154632568359375;i:4;a:0:{}i:5;i:7448744;}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:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547998193.118175983428955078125;i:4;a:0:{}i:5;i:7510608;}i:22;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:1547998193.164463043212890625;i:4;a:0:{}i:5;i:7645816;}i:25;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:1547998193.1774480342864990234375;i:4;a:0:{}i:5;i:7654568;}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:4;i:2;s:21:"yii\db\Command::query";i:3;d:1547998193.25730609893798828125;i:4;a:0:{}i:5;i:7677776;}i:31;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:1547998193.312931060791015625;i:4;a:0:{}i:5;i:7683912;}i:34;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:1547998193.324717998504638671875;i:4;a:0:{}i:5;i:7694096;}i:37;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:1547998193.3622620105743408203125;i:4;a:0:{}i:5;i:7704016;}i:40;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:1547998193.40421199798583984375;i:4;a:0:{}i:5;i:7713936;}i:43;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:1547998193.4291450977325439453125;i:4;a:0:{}i:5;i:7723856;}i:46;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:1547998193.478250980377197265625;i:4;a:0:{}i:5;i:7733768;}i:49;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:1547998193.5426399707794189453125;i:4;a:0:{}i:5;i:7743688;}i:52;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:1547998193.583014965057373046875;i:4;a:0:{}i:5;i:7753616;}i:55;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:1547998193.6192920207977294921875;i:4;a:0:{}i:5;i:7763608;}i:58;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:1547998193.65596294403076171875;i:4;a:0:{}i:5;i:7702216;}}}";s:9:"profiling";s:10625:"a:3:{s:6:"memory";i:8042728;s:4:"time";d:0.80436801910400390625;s:8:"messages";a:38:{i:3;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:1547998192.932137012481689453125;i:4;a:0:{}i:5;i:5346384;}i:4;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:1547998192.9325768947601318359375;i:4;a:0:{}i:5;i:5356344;}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:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547998192.932611942291259765625;i:4;a:0:{}i:5;i:5359952;}i:6;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:1547998192.958322048187255859375;i:4;a:0:{}i:5;i:5365040;}i:8;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:1547998192.9838349819183349609375;i:4;a:0:{}i:5;i:7325776;}i:9;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:1547998192.9843599796295166015625;i:4;a:0:{}i:5;i:7334816;}i:11;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:1547998192.9844419956207275390625;i:4;a:0:{}i:5;i:7337928;}i:12;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:1547998193.00014209747314453125;i:4;a:0:{}i:5;i:7339992;}i:14;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:1547998193.001554012298583984375;i:4;a:0:{}i:5;i:7410112;}i:15;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:1547998193.011302947998046875;i:4;a:0:{}i:5;i:7429496;}i:17;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:1547998193.0119678974151611328125;i:4;a:0:{}i:5;i:7450848;}i:18;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:1547998193.11614894866943359375;i:4;a:0:{}i:5;i:7468416;}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:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547998193.118216991424560546875;i:4;a:0:{}i:5;i:7513536;}i:21;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:1547998193.1601569652557373046875;i:4;a:0:{}i:5;i:7518512;}i:23;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:1547998193.1645009517669677734375;i:4;a:0:{}i:5;i:7647744;}i:24;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:1547998193.17731189727783203125;i:4;a:0:{}i:5;i:7653688;}i:26;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:1547998193.177464008331298828125;i:4;a:0:{}i:5;i:7656568;}i:27;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:1547998193.25668811798095703125;i:4;a:0:{}i:5;i:7692568;}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:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547998193.2573359012603759765625;i:4;a:0:{}i:5;i:7680688;}i:30;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:1547998193.3123519420623779296875;i:4;a:0:{}i:5;i:7685672;}i:32;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:1547998193.3129580020904541015625;i:4;a:0:{}i:5;i:7685840;}i:33;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:1547998193.324325084686279296875;i:4;a:0:{}i:5;i:7692040;}i:35;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:1547998193.324736118316650390625;i:4;a:0:{}i:5;i:7696024;}i:36;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:1547998193.3617401123046875;i:4;a:0:{}i:5;i:7701960;}i:38;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:1547998193.362286090850830078125;i:4;a:0:{}i:5;i:7705944;}i:39;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:1547998193.403645992279052734375;i:4;a:0:{}i:5;i:7711880;}i:41;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:1547998193.4042389392852783203125;i:4;a:0:{}i:5;i:7715864;}i:42;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:1547998193.4286758899688720703125;i:4;a:0:{}i:5;i:7721800;}i:44;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:1547998193.4291679859161376953125;i:4;a:0:{}i:5;i:7725784;}i:45;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:1547998193.4776909351348876953125;i:4;a:0:{}i:5;i:7731712;}i:47;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:1547998193.4782769680023193359375;i:4;a:0:{}i:5;i:7735696;}i:48;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:1547998193.5421240329742431640625;i:4;a:0:{}i:5;i:7741640;}i:50;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:1547998193.542665958404541015625;i:4;a:0:{}i:5;i:7745616;}i:51;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:1547998193.58251094818115234375;i:4;a:0:{}i:5;i:7751552;}i:53;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:1547998193.5830399990081787109375;i:4;a:0:{}i:5;i:7755544;}i:54;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:1547998193.6188600063323974609375;i:4;a:0:{}i:5;i:7761488;}i:56;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:1547998193.6193139553070068359375;i:4;a:0:{}i:5;i:7765536;}i:57;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:1547998193.6544189453125;i:4;a:0:{}i:5;i:7771496;}}}";s:2:"db";s:9815:"a:1:{s:8:"messages";a:34:{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:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547998192.932611942291259765625;i:4;a:0:{}i:5;i:5359952;}i:6;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:1547998192.958322048187255859375;i:4;a:0:{}i:5;i:5365040;}i:11;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:1547998192.9844419956207275390625;i:4;a:0:{}i:5;i:7337928;}i:12;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:1547998193.00014209747314453125;i:4;a:0:{}i:5;i:7339992;}i:14;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:1547998193.001554012298583984375;i:4;a:0:{}i:5;i:7410112;}i:15;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:1547998193.011302947998046875;i:4;a:0:{}i:5;i:7429496;}i:17;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:1547998193.0119678974151611328125;i:4;a:0:{}i:5;i:7450848;}i:18;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:1547998193.11614894866943359375;i:4;a:0:{}i:5;i:7468416;}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:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547998193.118216991424560546875;i:4;a:0:{}i:5;i:7513536;}i:21;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:1547998193.1601569652557373046875;i:4;a:0:{}i:5;i:7518512;}i:23;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:1547998193.1645009517669677734375;i:4;a:0:{}i:5;i:7647744;}i:24;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:1547998193.17731189727783203125;i:4;a:0:{}i:5;i:7653688;}i:26;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:1547998193.177464008331298828125;i:4;a:0:{}i:5;i:7656568;}i:27;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:1547998193.25668811798095703125;i:4;a:0:{}i:5;i:7692568;}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:80;i:2;s:21:"yii\db\Command::query";i:3;d:1547998193.2573359012603759765625;i:4;a:0:{}i:5;i:7680688;}i:30;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:1547998193.3123519420623779296875;i:4;a:0:{}i:5;i:7685672;}i:32;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:1547998193.3129580020904541015625;i:4;a:0:{}i:5;i:7685840;}i:33;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:1547998193.324325084686279296875;i:4;a:0:{}i:5;i:7692040;}i:35;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:1547998193.324736118316650390625;i:4;a:0:{}i:5;i:7696024;}i:36;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:1547998193.3617401123046875;i:4;a:0:{}i:5;i:7701960;}i:38;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:1547998193.362286090850830078125;i:4;a:0:{}i:5;i:7705944;}i:39;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:1547998193.403645992279052734375;i:4;a:0:{}i:5;i:7711880;}i:41;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:1547998193.4042389392852783203125;i:4;a:0:{}i:5;i:7715864;}i:42;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:1547998193.4286758899688720703125;i:4;a:0:{}i:5;i:7721800;}i:44;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:1547998193.4291679859161376953125;i:4;a:0:{}i:5;i:7725784;}i:45;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:1547998193.4776909351348876953125;i:4;a:0:{}i:5;i:7731712;}i:47;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:1547998193.4782769680023193359375;i:4;a:0:{}i:5;i:7735696;}i:48;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:1547998193.5421240329742431640625;i:4;a:0:{}i:5;i:7741640;}i:50;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:1547998193.542665958404541015625;i:4;a:0:{}i:5;i:7745616;}i:51;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:1547998193.58251094818115234375;i:4;a:0:{}i:5;i:7751552;}i:53;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:1547998193.5830399990081787109375;i:4;a:0:{}i:5;i:7755544;}i:54;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:1547998193.6188600063323974609375;i:4;a:0:{}i:5;i:7761488;}i:56;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:1547998193.6193139553070068359375;i:4;a:0:{}i:5;i:7765536;}i:57;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:1547998193.6544189453125;i:4;a:0:{}i:5;i:7771496;}}}";s:6:"assets";s:6:"a:0:{}";s:4:"mail";s:6:"a:0:{}";s:8:"timeline";s:120:"a:3:{s:5:"start";d:1547998192.8590679168701171875;s:3:"end";d:1547998193.6637771129608154296875;s:6:"memory";i:8042728;}";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:"5c4493f0e0574";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:1547998192.8442409038543701171875;s:10:"statusCode";i:200;s:8:"sqlCount";i:17;s:9:"mailCount";i:0;}s:10:"exceptions";a:0:{}}