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:3572:"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:"57215";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:1547997389.991794109344482421875;s:12:"REQUEST_TIME";i:1547997389;}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:5656:"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:1547997390.0557119846343994140625;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:1547997390.07431697845458984375;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:1547997390.0743401050567626953125;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:1547997390.1003930568695068359375;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:1547997390.100740909576416015625;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:1547997390.103662014007568359375;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:1547997390.1050279140472412109375;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:1547997390.110980987548828125;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:1547997390.11888408660888671875;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:1547997390.1195240020751953125;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:1547997390.1206920146942138671875;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:1547997390.1214199066162109375;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:1547997390.122024059295654296875;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:1547997390.1225130558013916015625;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:1547997390.12296390533447265625;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:1547997390.1234760284423828125;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:1547997390.1239340305328369140625;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:1547997390.1243469715118408203125;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:1547997390.1247599124908447265625;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:1547997390.125176906585693359375;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:1547997390.126658916473388671875;i:4;a:0:{}i:5;i:7702216;}}}";s:9:"profiling";s:10628:"a:3:{s:6:"memory";i:8042728;s:4:"time";d:0.1277599334716796875;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:1547997390.074345111846923828125;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:1547997390.0748269557952880859375;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:1547997390.0748479366302490234375;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:1547997390.07547092437744140625;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:1547997390.1004009246826171875;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:1547997390.1006948947906494140625;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:1547997390.10076999664306640625;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:1547997390.102365970611572265625;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:1547997390.1036779880523681640625;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:1547997390.104424953460693359375;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:1547997390.105041980743408203125;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:1547997390.10933208465576171875;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:1547997390.11100101470947265625;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:1547997390.1156699657440185546875;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:1547997390.1189019680023193359375;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:1547997390.1194341182708740234375;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:1547997390.1195371150970458984375;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:1547997390.12020111083984375;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:1547997390.120707988739013671875;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:1547997390.1210610866546630859375;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:1547997390.1214339733123779296875;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:1547997390.121717929840087890625;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:1547997390.122045993804931640625;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:1547997390.1222259998321533203125;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:1547997390.1225268840789794921875;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:1547997390.1226799488067626953125;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:1547997390.1229779720306396484375;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:1547997390.1231710910797119140625;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:1547997390.1234910488128662109375;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:1547997390.12366390228271484375;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:1547997390.1239490509033203125;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:1547997390.124084949493408203125;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:1547997390.1243610382080078125;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:1547997390.124494075775146484375;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:1547997390.12477397918701171875;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:1547997390.124907016754150390625;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:1547997390.1251919269561767578125;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:1547997390.1253540515899658203125;i:4;a:0:{}i:5;i:7771496;}}}";s:2:"db";s:9822:"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:1547997390.0748479366302490234375;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:1547997390.07547092437744140625;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:1547997390.10076999664306640625;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:1547997390.102365970611572265625;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:1547997390.1036779880523681640625;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:1547997390.104424953460693359375;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:1547997390.105041980743408203125;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:1547997390.10933208465576171875;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:1547997390.11100101470947265625;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:1547997390.1156699657440185546875;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:1547997390.1189019680023193359375;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:1547997390.1194341182708740234375;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:1547997390.1195371150970458984375;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:1547997390.12020111083984375;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:1547997390.120707988739013671875;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:1547997390.1210610866546630859375;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:1547997390.1214339733123779296875;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:1547997390.121717929840087890625;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:1547997390.122045993804931640625;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:1547997390.1222259998321533203125;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:1547997390.1225268840789794921875;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:1547997390.1226799488067626953125;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:1547997390.1229779720306396484375;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:1547997390.1231710910797119140625;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:1547997390.1234910488128662109375;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:1547997390.12366390228271484375;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:1547997390.1239490509033203125;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:1547997390.124084949493408203125;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:1547997390.1243610382080078125;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:1547997390.124494075775146484375;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:1547997390.12477397918701171875;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:1547997390.124907016754150390625;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:1547997390.1251919269561767578125;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:1547997390.1253540515899658203125;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:123:"a:3:{s:5:"start";d:1547997390.0058109760284423828125;s:3:"end";d:1547997390.1339008808135986328125;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:"5c4490ce0f0f4";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:1547997389.991794109344482421875;s:10:"statusCode";i:200;s:8:"sqlCount";i:17;s:9:"mailCount";i:0;}s:10:"exceptions";a:0:{}}