a:8:{s:6:"config";a:5:{s:10:"phpVersion";s:38:"7.0.33-47+ubuntu20.04.1+deb.sury.org+1";s:10:"yiiVersion";s:5:"2.0.7";s:11:"application";a:4:{s:3:"yii";s:5:"2.0.7";s:4:"name";s:14:"My Application";s:3:"env";s:3:"dev";s:5:"debug";b:1;}s:3:"php";a:4:{s:7:"version";s:38:"7.0.33-47+ubuntu20.04.1+deb.sury.org+1";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;}s:10:"extensions";a:35:{s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:53:"/var/www/html/gas4you/vendor/yiisoft/yii2-swiftmailer";}}s:24:"yiisoft/yii2-codeception";a:3:{s:4:"name";s:24:"yiisoft/yii2-codeception";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:16:"@yii/codeception";s:53:"/var/www/html/gas4you/vendor/yiisoft/yii2-codeception";}}s:22:"yiisoft/yii2-bootstrap";a:3:{s:4:"name";s:22:"yiisoft/yii2-bootstrap";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:14:"@yii/bootstrap";s:51:"/var/www/html/gas4you/vendor/yiisoft/yii2-bootstrap";}}s:18:"yiisoft/yii2-debug";a:3:{s:4:"name";s:18:"yiisoft/yii2-debug";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:47:"/var/www/html/gas4you/vendor/yiisoft/yii2-debug";}}s:16:"yiisoft/yii2-gii";a:3:{s:4:"name";s:16:"yiisoft/yii2-gii";s:7:"version";s:7:"2.0.4.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:45:"/var/www/html/gas4you/vendor/yiisoft/yii2-gii";}}s:18:"yiisoft/yii2-faker";a:3:{s:4:"name";s:18:"yiisoft/yii2-faker";s:7:"version";s:7:"2.0.3.0";s:5:"alias";a:1:{s:10:"@yii/faker";s:47:"/var/www/html/gas4you/vendor/yiisoft/yii2-faker";}}s:31:"kartik-v/yii2-widget-activeform";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-activeform";s:7:"version";s:7:"1.4.9.0";s:5:"alias";a:1:{s:12:"@kartik/form";s:60:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-activeform";}}s:26:"kartik-v/yii2-widget-alert";a:3:{s:4:"name";s:26:"kartik-v/yii2-widget-alert";s:7:"version";s:7:"1.1.1.0";s:5:"alias";a:1:{s:13:"@kartik/alert";s:55:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-alert";}}s:31:"kartik-v/yii2-widget-datepicker";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-datepicker";s:7:"version";s:7:"1.4.3.0";s:5:"alias";a:1:{s:12:"@kartik/date";s:60:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-datepicker";}}s:35:"kartik-v/yii2-widget-datetimepicker";a:3:{s:4:"name";s:35:"kartik-v/yii2-widget-datetimepicker";s:7:"version";s:7:"1.4.4.0";s:5:"alias";a:1:{s:16:"@kartik/datetime";s:64:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-datetimepicker";}}s:28:"kartik-v/yii2-widget-depdrop";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-depdrop";s:7:"version";s:7:"1.0.4.0";s:5:"alias";a:1:{s:15:"@kartik/depdrop";s:57:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-depdrop";}}s:30:"kartik-v/yii2-widget-fileinput";a:3:{s:4:"name";s:30:"kartik-v/yii2-widget-fileinput";s:7:"version";s:7:"1.0.6.0";s:5:"alias";a:1:{s:12:"@kartik/file";s:59:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-fileinput";}}s:26:"kartik-v/yii2-widget-growl";a:3:{s:4:"name";s:26:"kartik-v/yii2-widget-growl";s:7:"version";s:7:"1.1.1.0";s:5:"alias";a:1:{s:13:"@kartik/growl";s:55:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-growl";}}s:28:"kartik-v/yii2-widget-select2";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-select2";s:7:"version";s:7:"2.1.1.0";s:5:"alias";a:1:{s:15:"@kartik/select2";s:57:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-select2";}}s:32:"kartik-v/yii2-widget-switchinput";a:3:{s:4:"name";s:32:"kartik-v/yii2-widget-switchinput";s:7:"version";s:7:"1.3.1.0";s:5:"alias";a:1:{s:19:"@kartik/switchinput";s:61:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-switchinput";}}s:30:"kartik-v/yii2-widget-touchspin";a:3:{s:4:"name";s:30:"kartik-v/yii2-widget-touchspin";s:7:"version";s:7:"1.2.1.0";s:5:"alias";a:1:{s:17:"@kartik/touchspin";s:59:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-touchspin";}}s:30:"kartik-v/yii2-widget-typeahead";a:3:{s:4:"name";s:30:"kartik-v/yii2-widget-typeahead";s:7:"version";s:7:"1.0.1.0";s:5:"alias";a:1:{s:17:"@kartik/typeahead";s:59:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-typeahead";}}s:23:"kartik-v/yii2-popover-x";a:3:{s:4:"name";s:23:"kartik-v/yii2-popover-x";s:7:"version";s:7:"1.3.4.0";s:5:"alias";a:1:{s:15:"@kartik/popover";s:52:"/var/www/html/gas4you/vendor/kartik-v/yii2-popover-x";}}s:20:"kartik-v/yii2-slider";a:3:{s:4:"name";s:20:"kartik-v/yii2-slider";s:7:"version";s:7:"1.3.1.0";s:5:"alias";a:1:{s:14:"@kartik/slider";s:49:"/var/www/html/gas4you/vendor/kartik-v/yii2-slider";}}s:21:"kartik-v/yii2-widgets";a:3:{s:4:"name";s:21:"kartik-v/yii2-widgets";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:15:"@kartik/widgets";s:50:"/var/www/html/gas4you/vendor/kartik-v/yii2-widgets";}}s:20:"kartik-v/yii2-social";a:3:{s:4:"name";s:20:"kartik-v/yii2-social";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:14:"@kartik/social";s:49:"/var/www/html/gas4you/vendor/kartik-v/yii2-social";}}s:22:"kartik-v/yii2-editable";a:3:{s:4:"name";s:22:"kartik-v/yii2-editable";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:16:"@kartik/editable";s:51:"/var/www/html/gas4you/vendor/kartik-v/yii2-editable";}}s:18:"kartik-v/yii2-grid";a:3:{s:4:"name";s:18:"kartik-v/yii2-grid";s:7:"version";s:7:"3.1.1.0";s:5:"alias";a:1:{s:12:"@kartik/grid";s:47:"/var/www/html/gas4you/vendor/kartik-v/yii2-grid";}}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:54:"/var/www/html/gas4you/vendor/kartik-v/yii2-krajee-base";}}s:31:"kartik-v/yii2-widget-timepicker";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-timepicker";s:7:"version";s:7:"1.0.3.0";s:5:"alias";a:1:{s:12:"@kartik/time";s:60:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-timepicker";}}s:28:"kartik-v/yii2-widget-spinner";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-spinner";s:7:"version";s:7:"1.0.0.0";s:5:"alias";a:1:{s:15:"@kartik/spinner";s:57:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-spinner";}}s:28:"kartik-v/yii2-widget-sidenav";a:3:{s:4:"name";s:28:"kartik-v/yii2-widget-sidenav";s:7:"version";s:7:"1.0.0.0";s:5:"alias";a:1:{s:15:"@kartik/sidenav";s:57:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-sidenav";}}s:27:"kartik-v/yii2-widget-rating";a:3:{s:4:"name";s:27:"kartik-v/yii2-widget-rating";s:7:"version";s:7:"1.0.3.0";s:5:"alias";a:1:{s:14:"@kartik/rating";s:56:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-rating";}}s:31:"kartik-v/yii2-widget-rangeinput";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-rangeinput";s:7:"version";s:7:"1.0.1.0";s:5:"alias";a:1:{s:13:"@kartik/range";s:60:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-rangeinput";}}s:31:"kartik-v/yii2-widget-colorinput";a:3:{s:4:"name";s:31:"kartik-v/yii2-widget-colorinput";s:7:"version";s:7:"1.0.3.0";s:5:"alias";a:1:{s:13:"@kartik/color";s:60:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-colorinput";}}s:26:"kartik-v/yii2-widget-affix";a:3:{s:4:"name";s:26:"kartik-v/yii2-widget-affix";s:7:"version";s:7:"1.0.0.0";s:5:"alias";a:1:{s:13:"@kartik/affix";s:55:"/var/www/html/gas4you/vendor/kartik-v/yii2-widget-affix";}}s:21:"kartik-v/yii2-helpers";a:3:{s:4:"name";s:21:"kartik-v/yii2-helpers";s:7:"version";s:7:"1.3.6.0";s:5:"alias";a:1:{s:15:"@kartik/helpers";s:50:"/var/www/html/gas4you/vendor/kartik-v/yii2-helpers";}}s:25:"kartik-v/yii2-field-range";a:3:{s:4:"name";s:25:"kartik-v/yii2-field-range";s:7:"version";s:7:"1.3.2.0";s:5:"alias";a:1:{s:13:"@kartik/field";s:54:"/var/www/html/gas4you/vendor/kartik-v/yii2-field-range";}}s:28:"2amigos/yii2-ckeditor-widget";a:3:{s:4:"name";s:28:"2amigos/yii2-ckeditor-widget";s:7:"version";s:7:"2.1.0.0";s:5:"alias";a:1:{s:19:"@dosamigos/ckeditor";s:61:"/var/www/html/gas4you/vendor/2amigos/yii2-ckeditor-widget/src";}}s:18:"kartik-v/yii2-mpdf";a:3:{s:4:"name";s:18:"kartik-v/yii2-mpdf";s:7:"version";s:7:"1.0.2.0";s:5:"alias";a:1:{s:12:"@kartik/mpdf";s:47:"/var/www/html/gas4you/vendor/kartik-v/yii2-mpdf";}}}}s:7:"request";a:14:{s:7:"flashes";a:0:{}s:10:"statusCode";i:200;s:14:"requestHeaders";a:5:{s:10:"user-agent";s:13:"okhttp/4.12.0";s:15:"accept-encoding";s:4:"gzip";s:10:"connection";s:10:"Keep-Alive";s:4:"host";s:18:"admin.gas4u.com.ng";s:13:"authorization";s:39:"Bearer 9B4UsENBVGvfuyDobj8yhwGYvlN2I7Jk";}s:15:"responseHeaders";a:5:{s:10:"Set-Cookie";s:59:"PHPADMINSESSID=4qr999of7o9sbjpckq39nhq2p7; path=/; HttpOnly";s:7:"Expires";s:29:"Thu, 19 Nov 1981 08:52:00 GMT";s:13:"Cache-Control";s:35:"no-store, no-cache, must-revalidate";s:6:"Pragma";s:8:"no-cache";s:12:"Content-Type";s:31:"application/json; charset=UTF-8";}s:5:"route";s:19:"v3/vendor/dashboard";s:6:"action";s:66:"app\modules\api\v3\controllers\VendorController::actionDashboard()";s:12:"actionParams";a:0:{}s:11:"requestBody";a:3:{s:12:"Content Type";s:33:"application/x-www-form-urlencoded";s:3:"Raw";s:16:"start=0&limit=10";s:17:"Decoded to Params";a:2:{s:5:"start";s:1:"0";s:5:"limit";s:2:"10";}}s:6:"SERVER";a:37:{s:4:"USER";s:8:"www-data";s:4:"HOME";s:8:"/var/www";s:11:"SCRIPT_NAME";s:22:"/gas4you/web/index.php";s:11:"REQUEST_URI";s:32:"/gas4you/web/v3/vendor/dashboard";s:12:"QUERY_STRING";s:0:"";s:14:"REQUEST_METHOD";s:4:"POST";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:12:"REDIRECT_URL";s:32:"/gas4you/web/v3/vendor/dashboard";s:11:"REMOTE_PORT";s:5:"43595";s:15:"SCRIPT_FILENAME";s:35:"/var/www/html/gas4you/web/index.php";s:12:"SERVER_ADMIN";s:19:"webmaster@localhost";s:21:"CONTEXT_DOCUMENT_ROOT";s:13:"/var/www/html";s:14:"CONTEXT_PREFIX";s:0:"";s:14:"REQUEST_SCHEME";s:4:"http";s:13:"DOCUMENT_ROOT";s:13:"/var/www/html";s:11:"REMOTE_ADDR";s:13:"102.90.101.55";s:11:"SERVER_PORT";s:2:"80";s:11:"SERVER_ADDR";s:11:"172.31.3.64";s:11:"SERVER_NAME";s:18:"admin.gas4u.com.ng";s:15:"SERVER_SOFTWARE";s:22:"Apache/2.4.41 (Ubuntu)";s:16:"SERVER_SIGNATURE";s:79:"<address>Apache/2.4.41 (Ubuntu) Server at admin.gas4u.com.ng Port 80</address>
";s:4:"PATH";s:70:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin";s:15:"HTTP_USER_AGENT";s:13:"okhttp/4.12.0";s:20:"HTTP_ACCEPT_ENCODING";s:4:"gzip";s:15:"HTTP_CONNECTION";s:10:"Keep-Alive";s:9:"HTTP_HOST";s:18:"admin.gas4u.com.ng";s:14:"CONTENT_LENGTH";s:2:"16";s:12:"CONTENT_TYPE";s:33:"application/x-www-form-urlencoded";s:17:"proxy-nokeepalive";s:1:"1";s:18:"HTTP_AUTHORIZATION";s:39:"Bearer 9B4UsENBVGvfuyDobj8yhwGYvlN2I7Jk";s:15:"REDIRECT_STATUS";s:3:"200";s:27:"REDIRECT_HTTP_AUTHORIZATION";s:39:"Bearer 9B4UsENBVGvfuyDobj8yhwGYvlN2I7Jk";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:22:"/gas4you/web/index.php";s:18:"REQUEST_TIME_FLOAT";d:1787068826.01281;s:12:"REQUEST_TIME";i:1787068826;}s:3:"GET";a:0:{}s:4:"POST";a:2:{s:5:"start";s:1:"0";s:5:"limit";s:2:"10";}s:6:"COOKIE";a:0:{}s:5:"FILES";a:0:{}s:7:"SESSION";a:2:{s:7:"__flash";a:0:{}s:4:"__id";i:2149;}}s:3:"log";a:1:{s:8:"messages";a:39:{i:0;a:5:{i:0;s:33:"Bootstrap with yii\log\Dispatcher";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1787068826.0219769;i:4;a:0:{}}i:1;a:5:{i:0;s:21:"Loading module: debug";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1787068826.021997;i:4;a:0:{}}i:2;a:5:{i:0;s:44:"Bootstrap with yii\debug\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1787068826.0240209;i:4;a:0:{}}i:3;a:5:{i:0;s:19:"Loading module: gii";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1787068826.025692;i:4;a:0:{}}i:4;a:5:{i:0;s:42:"Bootstrap with yii\gii\Module::bootstrap()";i:1;i:8;i:2;s:31:"yii\base\Application::bootstrap";i:3;d:1787068826.0258529;i:4;a:0:{}}i:5;a:5:{i:0;s:55:"No matching URL rules. Using default URL parsing logic.";i:1;i:8;i:2;s:32:"yii\web\UrlManager::parseRequest";i:3;d:1787068826.0267329;i:4;a:0:{}}i:6;a:5:{i:0;s:38:"Route requested: 'v3/vendor/dashboard'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1787068826.0267479;i:4;a:0:{}}i:7;a:5:{i:0;s:18:"Loading module: v3";i:1;i:8;i:2;s:26:"yii\base\Module::getModule";i:3;d:1787068826.026758;i:4;a:0:{}}i:8;a:5:{i:0;s:33:"Route to run: v3/vendor/dashboard";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1787068826.055795;i:4;a:0:{}}i:9;a:5:{i:0;s:58:"Opening DB connection: mysql:host=localhost;dbname=gas4you";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1787068826.082175;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:12;a:5:{i:0;s:84:"SELECT * FROM `user_devices` WHERE `access_token`='9B4UsENBVGvfuyDobj8yhwGYvlN2I7Jk'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.082958;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:15;a:5:{i:0;s:37:"SHOW FULL COLUMNS FROM `user_devices`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0879259;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:18;a:5:{i:0;s:611:"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 = 'user_devices' AND kcu.table_name = 'user_devices'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0903251;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:21;a:5:{i:0;s:43:"SELECT * FROM `user_master` WHERE `id`=2149";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0940149;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:24;a:5:{i:0;s:36:"SHOW FULL COLUMNS FROM `user_master`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0945921;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:27;a:5:{i:0;s:609:"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 = 'user_master' AND kcu.table_name = 'user_master'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.097285;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:30;a:5:{i:0;s:15:"Session started";i:1;i:4;i:2;s:21:"yii\web\Session::open";i:3;d:1787068826.0996561;i:4;a:0:{}}i:31;a:5:{i:0;s:57:"User '2149' logged in from 102.90.101.55 with duration 0.";i:1;i:4;i:2;s:19:"yii\web\User::login";i:3;d:1787068826.099689;i:4;a:0:{}}i:32;a:5:{i:0;s:82:"Running action: app\modules\api\v3\controllers\VendorController::actionDashboard()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1787068826.099726;i:4;a:0:{}}i:33;a:5:{i:0;s:92:"SELECT `user_id` FROM `user_devices` WHERE `access_token`='9B4UsENBVGvfuyDobj8yhwGYvlN2I7Jk'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.100625;i:4;a:2:{i:0;a:5:{s:4:"file";s:48:"/var/www/html/gas4you/components/ApiFunction.php";s:4:"line";i:469;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2953;s:8:"function";s:15:"checkLoggeduser";s:5:"class";s:26:"app\components\ApiFunction";s:4:"type";s:2:"->";}}}i:36;a:5:{i:0;s:43:"SELECT * FROM `user_master` WHERE `id`=2149";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1039729;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2955;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:39;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786492800 AND 1786579199)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1049931;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:42;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786492800 AND 1786579199)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1072681;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:45;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786579200 AND 1786665599)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1077859;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:48;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786579200 AND 1786665599)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.108146;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:51;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786665600 AND 1786751999)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1084909;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:54;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786665600 AND 1786751999)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.108834;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:57;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786752000 AND 1786838399)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.10921;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:60;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786752000 AND 1786838399)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1095419;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:63;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786838400 AND 1786924799)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1098509;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:66;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786838400 AND 1786924799)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.110167;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:69;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786924800 AND 1787011199)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.110507;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:72;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786924800 AND 1787011199)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.110811;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:75;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1111131;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:78;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1114349;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:81;a:5:{i:0;s:138:"SELECT SUM(total_price) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1118841;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3006;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:84;a:5:{i:0;s:136:"SELECT SUM(vat_value) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1122041;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3012;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:87;a:5:{i:0;s:138:"SELECT SUM(total_price) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1767225600 AND 1798675200)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1139619;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3021;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:90;a:5:{i:0;s:532:"SELECT `O`.* FROM `order_detail` `O` LEFT JOIN `order_master` `M` ON `O`.`order_id` = `M`.`id` LEFT JOIN `user_master` `U` ON `M`.`user_id` = `U`.`id` LEFT JOIN `user_master` `R` ON `M`.`rider_id` = `R`.`id` LEFT JOIN `product_master` `P` ON `O`.`product_id` = `P`.`id` LEFT JOIN `brand_master` `B` ON `P`.`brand_id` = `B`.`id` WHERE (((NOT (`M`.`status` IN ('7', '8', '9', '10'))) AND (NOT (`rider_id` IS NULL))) AND (`M`.`vendor_id`=2149)) AND ((`B`.`is_active`='Y') AND (`B`.`is_deleted`='N')) ORDER BY `O`.`i_date` DESC LIMIT 11";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.115124;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3036;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}}}s:9:"profiling";a:3:{s:6:"memory";i:7859000;s:4:"time";d:0.10748887062072754;s:8:"messages";a:54:{i:10;a:5:{i:0;s:58:"Opening DB connection: mysql:host=localhost;dbname=gas4you";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1787068826.082207;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:11;a:5:{i:0;s:58:"Opening DB connection: mysql:host=localhost;dbname=gas4you";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1787068826.0829201;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:13;a:5:{i:0;s:84:"SELECT * FROM `user_devices` WHERE `access_token`='9B4UsENBVGvfuyDobj8yhwGYvlN2I7Jk'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0829849;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:14;a:5:{i:0;s:84:"SELECT * FROM `user_devices` WHERE `access_token`='9B4UsENBVGvfuyDobj8yhwGYvlN2I7Jk'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.086972;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:16;a:5:{i:0;s:37:"SHOW FULL COLUMNS FROM `user_devices`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.087966;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:17;a:5:{i:0;s:37:"SHOW FULL COLUMNS FROM `user_devices`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0893309;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:19;a:5:{i:0;s:611:"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 = 'user_devices' AND kcu.table_name = 'user_devices'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0903599;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:20;a:5:{i:0;s:611:"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 = 'user_devices' AND kcu.table_name = 'user_devices'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0914471;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:22;a:5:{i:0;s:43:"SELECT * FROM `user_master` WHERE `id`=2149";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0940499;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:23;a:5:{i:0;s:43:"SELECT * FROM `user_master` WHERE `id`=2149";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0945311;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:25;a:5:{i:0;s:36:"SHOW FULL COLUMNS FROM `user_master`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.094614;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:26;a:5:{i:0;s:36:"SHOW FULL COLUMNS FROM `user_master`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0968781;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:28;a:5:{i:0;s:609:"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 = 'user_master' AND kcu.table_name = 'user_master'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0973091;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:29;a:5:{i:0;s:609:"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 = 'user_master' AND kcu.table_name = 'user_master'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0982831;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:34;a:5:{i:0;s:92:"SELECT `user_id` FROM `user_devices` WHERE `access_token`='9B4UsENBVGvfuyDobj8yhwGYvlN2I7Jk'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1006501;i:4;a:2:{i:0;a:5:{s:4:"file";s:48:"/var/www/html/gas4you/components/ApiFunction.php";s:4:"line";i:469;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2953;s:8:"function";s:15:"checkLoggeduser";s:5:"class";s:26:"app\components\ApiFunction";s:4:"type";s:2:"->";}}}i:35;a:5:{i:0;s:92:"SELECT `user_id` FROM `user_devices` WHERE `access_token`='9B4UsENBVGvfuyDobj8yhwGYvlN2I7Jk'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.10379;i:4;a:2:{i:0;a:5:{s:4:"file";s:48:"/var/www/html/gas4you/components/ApiFunction.php";s:4:"line";i:469;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2953;s:8:"function";s:15:"checkLoggeduser";s:5:"class";s:26:"app\components\ApiFunction";s:4:"type";s:2:"->";}}}i:37;a:5:{i:0;s:43:"SELECT * FROM `user_master` WHERE `id`=2149";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1039951;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2955;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:38;a:5:{i:0;s:43:"SELECT * FROM `user_master` WHERE `id`=2149";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1043911;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2955;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:40;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786492800 AND 1786579199)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1050169;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:41;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786492800 AND 1786579199)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.107137;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:43;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786492800 AND 1786579199)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.10729;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:44;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786492800 AND 1786579199)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1076591;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:46;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786579200 AND 1786665599)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1078041;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:47;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786579200 AND 1786665599)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1080439;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:49;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786579200 AND 1786665599)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1081619;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:50;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786579200 AND 1786665599)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1083939;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:52;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786665600 AND 1786751999)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1085069;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:53;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786665600 AND 1786751999)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.108731;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:55;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786665600 AND 1786751999)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.108866;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:56;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786665600 AND 1786751999)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.109117;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:58;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786752000 AND 1786838399)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.109226;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:59;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786752000 AND 1786838399)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1094611;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:61;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786752000 AND 1786838399)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.109556;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:62;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786752000 AND 1786838399)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.109772;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:64;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786838400 AND 1786924799)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1098659;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:65;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786838400 AND 1786924799)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1100891;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:67;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786838400 AND 1786924799)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.110182;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:68;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786838400 AND 1786924799)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1104;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:70;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786924800 AND 1787011199)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.110522;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:71;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786924800 AND 1787011199)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.110734;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:73;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786924800 AND 1787011199)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1108251;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:74;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786924800 AND 1787011199)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1110339;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:76;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1111391;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:77;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1113579;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:79;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.111449;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:80;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1117809;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:82;a:5:{i:0;s:138:"SELECT SUM(total_price) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1118979;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3006;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:83;a:5:{i:0;s:138:"SELECT SUM(total_price) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.112124;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3006;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:85;a:5:{i:0;s:136:"SELECT SUM(vat_value) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1122179;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3012;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:86;a:5:{i:0;s:136:"SELECT SUM(vat_value) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.112416;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3012;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:88;a:5:{i:0;s:138:"SELECT SUM(total_price) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1767225600 AND 1798675200)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1139791;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3021;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:89;a:5:{i:0;s:138:"SELECT SUM(total_price) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1767225600 AND 1798675200)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.114222;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3021;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:91;a:5:{i:0;s:532:"SELECT `O`.* FROM `order_detail` `O` LEFT JOIN `order_master` `M` ON `O`.`order_id` = `M`.`id` LEFT JOIN `user_master` `U` ON `M`.`user_id` = `U`.`id` LEFT JOIN `user_master` `R` ON `M`.`rider_id` = `R`.`id` LEFT JOIN `product_master` `P` ON `O`.`product_id` = `P`.`id` LEFT JOIN `brand_master` `B` ON `P`.`brand_id` = `B`.`id` WHERE (((NOT (`M`.`status` IN ('7', '8', '9', '10'))) AND (NOT (`rider_id` IS NULL))) AND (`M`.`vendor_id`=2149)) AND ((`B`.`is_active`='Y') AND (`B`.`is_deleted`='N')) ORDER BY `O`.`i_date` DESC LIMIT 11";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1151431;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3036;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:92;a:5:{i:0;s:532:"SELECT `O`.* FROM `order_detail` `O` LEFT JOIN `order_master` `M` ON `O`.`order_id` = `M`.`id` LEFT JOIN `user_master` `U` ON `M`.`user_id` = `U`.`id` LEFT JOIN `user_master` `R` ON `M`.`rider_id` = `R`.`id` LEFT JOIN `product_master` `P` ON `O`.`product_id` = `P`.`id` LEFT JOIN `brand_master` `B` ON `P`.`brand_id` = `B`.`id` WHERE (((NOT (`M`.`status` IN ('7', '8', '9', '10'))) AND (NOT (`rider_id` IS NULL))) AND (`M`.`vendor_id`=2149)) AND ((`B`.`is_active`='Y') AND (`B`.`is_deleted`='N')) ORDER BY `O`.`i_date` DESC LIMIT 11";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1158221;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3036;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}}}s:2:"db";a:1:{s:8:"messages";a:52:{i:13;a:5:{i:0;s:84:"SELECT * FROM `user_devices` WHERE `access_token`='9B4UsENBVGvfuyDobj8yhwGYvlN2I7Jk'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0829849;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:14;a:5:{i:0;s:84:"SELECT * FROM `user_devices` WHERE `access_token`='9B4UsENBVGvfuyDobj8yhwGYvlN2I7Jk'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.086972;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:16;a:5:{i:0;s:37:"SHOW FULL COLUMNS FROM `user_devices`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.087966;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:17;a:5:{i:0;s:37:"SHOW FULL COLUMNS FROM `user_devices`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0893309;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:19;a:5:{i:0;s:611:"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 = 'user_devices' AND kcu.table_name = 'user_devices'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0903599;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:20;a:5:{i:0;s:611:"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 = 'user_devices' AND kcu.table_name = 'user_devices'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0914471;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:53;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:22;a:5:{i:0;s:43:"SELECT * FROM `user_master` WHERE `id`=2149";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0940499;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:23;a:5:{i:0;s:43:"SELECT * FROM `user_master` WHERE `id`=2149";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0945311;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:25;a:5:{i:0;s:36:"SHOW FULL COLUMNS FROM `user_master`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.094614;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:26;a:5:{i:0;s:36:"SHOW FULL COLUMNS FROM `user_master`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0968781;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:28;a:5:{i:0;s:609:"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 = 'user_master' AND kcu.table_name = 'user_master'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0973091;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:29;a:5:{i:0;s:609:"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 = 'user_master' AND kcu.table_name = 'user_master'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.0982831;i:4;a:1:{i:0;a:5:{s:4:"file";s:37:"/var/www/html/gas4you/models/User.php";s:4:"line";i:58;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:34;a:5:{i:0;s:92:"SELECT `user_id` FROM `user_devices` WHERE `access_token`='9B4UsENBVGvfuyDobj8yhwGYvlN2I7Jk'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1006501;i:4;a:2:{i:0;a:5:{s:4:"file";s:48:"/var/www/html/gas4you/components/ApiFunction.php";s:4:"line";i:469;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2953;s:8:"function";s:15:"checkLoggeduser";s:5:"class";s:26:"app\components\ApiFunction";s:4:"type";s:2:"->";}}}i:35;a:5:{i:0;s:92:"SELECT `user_id` FROM `user_devices` WHERE `access_token`='9B4UsENBVGvfuyDobj8yhwGYvlN2I7Jk'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.10379;i:4;a:2:{i:0;a:5:{s:4:"file";s:48:"/var/www/html/gas4you/components/ApiFunction.php";s:4:"line";i:469;s:8:"function";s:3:"one";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2953;s:8:"function";s:15:"checkLoggeduser";s:5:"class";s:26:"app\components\ApiFunction";s:4:"type";s:2:"->";}}}i:37;a:5:{i:0;s:43:"SELECT * FROM `user_master` WHERE `id`=2149";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1039951;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2955;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:38;a:5:{i:0;s:43:"SELECT * FROM `user_master` WHERE `id`=2149";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1043911;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2955;s:8:"function";s:7:"findOne";s:5:"class";s:23:"yii\db\BaseActiveRecord";s:4:"type";s:2:"::";}}}i:40;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786492800 AND 1786579199)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1050169;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:41;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786492800 AND 1786579199)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.107137;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:43;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786492800 AND 1786579199)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.10729;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:44;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786492800 AND 1786579199)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1076591;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:46;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786579200 AND 1786665599)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1078041;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:47;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786579200 AND 1786665599)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1080439;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:49;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786579200 AND 1786665599)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1081619;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:50;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786579200 AND 1786665599)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1083939;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:52;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786665600 AND 1786751999)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1085069;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:53;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786665600 AND 1786751999)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.108731;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:55;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786665600 AND 1786751999)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.108866;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:56;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786665600 AND 1786751999)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.109117;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:58;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786752000 AND 1786838399)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.109226;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:59;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786752000 AND 1786838399)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1094611;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:61;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786752000 AND 1786838399)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.109556;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:62;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786752000 AND 1786838399)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.109772;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:64;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786838400 AND 1786924799)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1098659;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:65;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786838400 AND 1786924799)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1100891;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:67;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786838400 AND 1786924799)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.110182;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:68;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786838400 AND 1786924799)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1104;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:70;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786924800 AND 1787011199)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.110522;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:71;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786924800 AND 1787011199)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.110734;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:73;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786924800 AND 1787011199)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1108251;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:74;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1786924800 AND 1787011199)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1110339;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:76;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1111391;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:77;a:5:{i:0;s:167:"SELECT SUM(total_price) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1113579;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2986;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:79;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.111449;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:80;a:5:{i:0;s:165:"SELECT SUM(vat_value) FROM `order_master` WHERE (((`vendor_id`=2149) AND (`status`='7')) OR (`delivery_method`='D')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1117809;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:2990;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:82;a:5:{i:0;s:138:"SELECT SUM(total_price) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1118979;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3006;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:83;a:5:{i:0;s:138:"SELECT SUM(total_price) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.112124;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3006;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:85;a:5:{i:0;s:136:"SELECT SUM(vat_value) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1122179;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3012;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:86;a:5:{i:0;s:136:"SELECT SUM(vat_value) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1787011200 AND 1787097599)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.112416;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3012;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:88;a:5:{i:0;s:138:"SELECT SUM(total_price) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1767225600 AND 1798675200)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1139791;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3021;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:89;a:5:{i:0;s:138:"SELECT SUM(total_price) FROM `order_master` WHERE ((`vendor_id`=2149) AND (`status`='7')) AND (`i_date` BETWEEN 1767225600 AND 1798675200)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.114222;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3021;s:8:"function";s:3:"sum";s:5:"class";s:12:"yii\db\Query";s:4:"type";s:2:"->";}}}i:91;a:5:{i:0;s:532:"SELECT `O`.* FROM `order_detail` `O` LEFT JOIN `order_master` `M` ON `O`.`order_id` = `M`.`id` LEFT JOIN `user_master` `U` ON `M`.`user_id` = `U`.`id` LEFT JOIN `user_master` `R` ON `M`.`rider_id` = `R`.`id` LEFT JOIN `product_master` `P` ON `O`.`product_id` = `P`.`id` LEFT JOIN `brand_master` `B` ON `P`.`brand_id` = `B`.`id` WHERE (((NOT (`M`.`status` IN ('7', '8', '9', '10'))) AND (NOT (`rider_id` IS NULL))) AND (`M`.`vendor_id`=2149)) AND ((`B`.`is_active`='Y') AND (`B`.`is_deleted`='N')) ORDER BY `O`.`i_date` DESC LIMIT 11";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1151431;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3036;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}i:92;a:5:{i:0;s:532:"SELECT `O`.* FROM `order_detail` `O` LEFT JOIN `order_master` `M` ON `O`.`order_id` = `M`.`id` LEFT JOIN `user_master` `U` ON `M`.`user_id` = `U`.`id` LEFT JOIN `user_master` `R` ON `M`.`rider_id` = `R`.`id` LEFT JOIN `product_master` `P` ON `O`.`product_id` = `P`.`id` LEFT JOIN `brand_master` `B` ON `P`.`brand_id` = `B`.`id` WHERE (((NOT (`M`.`status` IN ('7', '8', '9', '10'))) AND (NOT (`rider_id` IS NULL))) AND (`M`.`vendor_id`=2149)) AND ((`B`.`is_active`='Y') AND (`B`.`is_deleted`='N')) ORDER BY `O`.`i_date` DESC LIMIT 11";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1787068826.1158221;i:4;a:1:{i:0;a:5:{s:4:"file";s:69:"/var/www/html/gas4you/modules/api/v3/controllers/VendorController.php";s:4:"line";i:3036;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}}}}}s:6:"assets";a:0:{}s:4:"mail";a:0:{}s:7:"summary";a:9:{s:3:"tag";s:13:"6a84819a05ed3";s:3:"url";s:57:"http://admin.gas4u.com.ng/gas4you/web/v3/vendor/dashboard";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:13:"102.90.101.55";s:4:"time";i:1787068826;s:10:"statusCode";i:200;s:8:"sqlCount";i:26;s:9:"mailCount";i:0;}}