a:8:{s:6:"config";a:5:{s:10:"phpVersion";s:6:"5.6.31";s:10:"yiiVersion";s:5:"2.0.9";s:11:"application";a:4:{s:3:"yii";s:5:"2.0.9";s:4:"name";s:4:"IDTS";s:3:"env";s:3:"dev";s:5:"debug";b:1;}s:3:"php";a:4:{s:7:"version";s:6:"5.6.31";s:6:"xdebug";b:0;s:3:"apc";b:0;s:8:"memcache";b:0;}s:10:"extensions";a:30:{s:23:"nenad/yii2-widgets-base";a:3:{s:4:"name";s:23:"nenad/yii2-widgets-base";s:7:"version";s:7:"2.0.0.0";s:5:"alias";a:1:{s:6:"@nenad";s:67:"/home/idtscom/public_html/_protected/vendor/nenad/yii2-widgets-base";}}s:28:"nenad/yii2-password-strength";a:3:{s:4:"name";s:28:"nenad/yii2-password-strength";s:7:"version";s:7:"2.3.0.0";s:5:"alias";a:1:{s:23:"@nenad/passwordStrength";s:72:"/home/idtscom/public_html/_protected/vendor/nenad/yii2-password-strength";}}s:24:"yiisoft/yii2-swiftmailer";a:3:{s:4:"name";s:24:"yiisoft/yii2-swiftmailer";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:16:"@yii/swiftmailer";s:68:"/home/idtscom/public_html/_protected/vendor/yiisoft/yii2-swiftmailer";}}s:23:"mihaildev/yii2-ckeditor";a:3:{s:4:"name";s:23:"mihaildev/yii2-ckeditor";s:7:"version";s:7:"1.0.1.0";s:5:"alias";a:1:{s:19:"@mihaildev/ckeditor";s:67:"/home/idtscom/public_html/_protected/vendor/mihaildev/yii2-ckeditor";}}s:24:"yiisoft/yii2-codeception";a:3:{s:4:"name";s:24:"yiisoft/yii2-codeception";s:7:"version";s:7:"2.0.5.0";s:5:"alias";a:1:{s:16:"@yii/codeception";s:68:"/home/idtscom/public_html/_protected/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.6.0";s:5:"alias";a:1:{s:14:"@yii/bootstrap";s:66:"/home/idtscom/public_html/_protected/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.6.0";s:5:"alias";a:1:{s:10:"@yii/debug";s:62:"/home/idtscom/public_html/_protected/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.5.0";s:5:"alias";a:1:{s:8:"@yii/gii";s:60:"/home/idtscom/public_html/_protected/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:62:"/home/idtscom/public_html/_protected/vendor/yiisoft/yii2-faker";}}s:26:"wbraganca/yii2-dynamicform";a:3:{s:4:"name";s:26:"wbraganca/yii2-dynamicform";s:7:"version";s:11:"9999999-dev";s:5:"alias";a:1:{s:22:"@wbraganca/dynamicform";s:74:"/home/idtscom/public_html/_protected/vendor/wbraganca/yii2-dynamicform/src";}}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.5.0";s:5:"alias";a:1:{s:12:"@kartik/base";s:69:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-krajee-base";}}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:74:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-typeahead";}}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:74:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-touchspin";}}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.1.0";s:5:"alias";a:1:{s:12:"@kartik/time";s:75:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-timepicker";}}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:76:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-switchinput";}}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:72:"/home/idtscom/public_html/_protected/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:72:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-sidenav";}}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.0.8.0";s:5:"alias";a:1:{s:15:"@kartik/select2";s:72:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-select2";}}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.2.0";s:5:"alias";a:1:{s:14:"@kartik/rating";s:71:"/home/idtscom/public_html/_protected/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:75:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-rangeinput";}}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:70:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-growl";}}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.5.0";s:5:"alias";a:1:{s:12:"@kartik/file";s:74:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-fileinput";}}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:72:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-depdrop";}}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.2.0";s:5:"alias";a:1:{s:16:"@kartik/datetime";s:79:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-datetimepicker";}}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.0.0";s:5:"alias";a:1:{s:12:"@kartik/date";s:75:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-datepicker";}}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:75:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-colorinput";}}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.0.0";s:5:"alias";a:1:{s:13:"@kartik/alert";s:70:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-alert";}}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:70:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-affix";}}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.8.0";s:5:"alias";a:1:{s:12:"@kartik/form";s:75:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widget-activeform";}}s:21:"kartik-v/yii2-widgets";a:3:{s:4:"name";s:21:"kartik-v/yii2-widgets";s:7:"version";s:7:"3.4.0.0";s:5:"alias";a:1:{s:15:"@kartik/widgets";s:65:"/home/idtscom/public_html/_protected/vendor/kartik-v/yii2-widgets";}}}}s:7:"request";a:14:{s:7:"flashes";a:0:{}s:10:"statusCode";i:500;s:14:"requestHeaders";a:8:{s:6:"accept";s:63:"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8";s:14:"accept-charset";s:30:"ISO-8859-1,utf-8;q=0.7,*;q=0.7";s:15:"accept-encoding";s:4:"gzip";s:15:"accept-language";s:14:"en-us,en;q=0.5";s:10:"connection";s:10:"Keep-Alive";s:4:"host";s:15:"www.idts.com.my";s:7:"referer";s:67:"http://www.idts.com.my/index.php/product/listing?view=list&pid='0=A";s:10:"user-agent";s:109:"Mozilla/5.0 (Windows; U; Windows NT 5.1; pt-PT; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729)";}s:15:"responseHeaders";a:2:{s:12:"X-Powered-By";s:10:"PHP/5.6.31";s:12:"Content-Type";s:24:"text/html; charset=UTF-8";}s:5:"route";s:15:"product/listing";s:6:"action";s:55:"frontend\controllers\ProductController::actionListing()";s:12:"actionParams";a:2:{i:0;s:4:"list";i:1;s:4:"'0=A";}s:11:"requestBody";a:0:{}s:6:"SERVER";a:40:{s:21:"CONTEXT_DOCUMENT_ROOT";s:25:"/home/idtscom/public_html";s:14:"CONTEXT_PREFIX";s:0:"";s:13:"DOCUMENT_ROOT";s:25:"/home/idtscom/public_html";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:11:"HTTP_ACCEPT";s:63:"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8";s:19:"HTTP_ACCEPT_CHARSET";s:30:"ISO-8859-1,utf-8;q=0.7,*;q=0.7";s:20:"HTTP_ACCEPT_ENCODING";s:4:"gzip";s:20:"HTTP_ACCEPT_LANGUAGE";s:14:"en-us,en;q=0.5";s:15:"HTTP_CONNECTION";s:10:"Keep-Alive";s:9:"HTTP_HOST";s:15:"www.idts.com.my";s:12:"HTTP_REFERER";s:67:"http://www.idts.com.my/index.php/product/listing?view=list&pid='0=A";s:15:"HTTP_USER_AGENT";s:109:"Mozilla/5.0 (Windows; U; Windows NT 5.1; pt-PT; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729)";s:4:"PATH";s:13:"/bin:/usr/bin";s:9:"PATH_INFO";s:16:"/product/listing";s:15:"PATH_TRANSLATED";s:35:"/home/idtscom/public_html/index.php";s:12:"QUERY_STRING";s:20:"view=list&pid=%270=A";s:15:"REDIRECT_STATUS";s:3:"200";s:11:"REMOTE_ADDR";s:14:"35.201.133.158";s:11:"REMOTE_PORT";s:5:"51789";s:14:"REQUEST_METHOD";s:3:"GET";s:14:"REQUEST_SCHEME";s:4:"http";s:11:"REQUEST_URI";s:47:"/index.php/product/listing?view=list&pid=%270=A";s:15:"SCRIPT_FILENAME";s:35:"/home/idtscom/public_html/index.php";s:11:"SCRIPT_NAME";s:10:"/index.php";s:10:"SCRIPT_URI";s:48:"http://www.idts.com.my/index.php/product/listing";s:10:"SCRIPT_URL";s:26:"/index.php/product/listing";s:11:"SERVER_ADDR";s:11:"110.4.45.44";s:12:"SERVER_ADMIN";s:21:"webmaster@idts.com.my";s:11:"SERVER_NAME";s:15:"www.idts.com.my";s:11:"SERVER_PORT";s:2:"80";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:16:"SERVER_SIGNATURE";s:0:"";s:15:"SERVER_SOFTWARE";s:6:"Apache";s:2:"TZ";s:17:"Asia/Kuala_Lumpur";s:9:"UNIQUE_ID";s:27:"Wel@2dpF3sK1aC6D0i1bGAAAAcc";s:8:"PHP_SELF";s:26:"/index.php/product/listing";s:18:"REQUEST_TIME_FLOAT";d:1508474595.795566082000732421875;s:12:"REQUEST_TIME";i:1508474595;s:4:"argv";a:1:{i:0;s:18:"view=list&pid='0=A";}s:4:"argc";i:1;}s:3:"GET";a:2:{s:4:"view";s:4:"list";s:3:"pid";s:4:"'0=A";}s:4:"POST";a:0:{}s:6:"COOKIE";a:0:{}s:5:"FILES";a:0:{}s:7:"SESSION";a:0:{}}s:3:"log";a:1:{s:8:"messages";a:43:{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:1508474595.884995937347412109375;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:1508474595.8850409984588623046875;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:1508474595.9229819774627685546875;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:1508474595.9352390766143798828125;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:1508474595.9359409809112548828125;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:1508474595.954060077667236328125;i:4;a:0:{}}i:6;a:5:{i:0;s:34:"Route requested: 'product/listing'";i:1;i:8;i:2;s:34:"yii\web\Application::handleRequest";i:3;d:1508474595.9540998935699462890625;i:4;a:0:{}}i:7;a:5:{i:0;s:29:"Route to run: product/listing";i:1;i:8;i:2;s:30:"yii\base\Controller::runAction";i:3;d:1508474595.957971096038818359375;i:4;a:0:{}}i:8;a:5:{i:0;s:71:"Running action: frontend\controllers\ProductController::actionListing()";i:1;i:8;i:2;s:36:"yii\base\InlineAction::runWithParams";i:3;d:1508474595.9773509502410888671875;i:4;a:0:{}}i:9;a:5:{i:0;s:100:"Rendering view file: /home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474595.9801509380340576171875;i:4;a:1:{i:0;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:10;a:5:{i:0;s:70:"Opening DB connection: mysql:host=localhost:3306;dbname=idtscom_system";i:1;i:4;i:2;s:23:"yii\db\Connection::open";i:3;d:1508474596.176042079925537109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:33;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:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:19;s:8:"function";s:3:"one";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:13;a:5:{i:0;s:60:"SELECT * FROM `product_category` WHERE `category_id`='\'0=A'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.18603610992431640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:33;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:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:19;s:8:"function";s:3:"one";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:16;a:5:{i:0;s:60:"SELECT * FROM `product_category` WHERE `category_id` IS NULL";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.18869495391845703125;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:33;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:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:28;s:8:"function";s:3:"one";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:19;a:5:{i:0;s:99:"SELECT * FROM `product_category` WHERE (`status`=1) AND (`parent_id`='\'0=A') ORDER BY `sort_order`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.1914360523223876953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:22;a:5:{i:0;s:41:"SHOW FULL COLUMNS FROM `product_category`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.192758083343505859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:25;a:5:{i:0;s:619:"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 = 'product_category' AND kcu.table_name = 'product_category'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.305964946746826171875;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:28;a:5:{i:0;s:85:"SELECT * FROM `product_category_description` WHERE `category_id` IN (1, 3, 2, 38, 53)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.3093030452728271484375;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:31;a:5:{i:0;s:53:"SHOW FULL COLUMNS FROM `product_category_description`";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.3169109821319580078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:34;a:5:{i:0;s:643:"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 = 'product_category_description' AND kcu.table_name = 'product_category_description'";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.3183829784393310546875;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:37;a:5:{i:0;s:285:"SELECT `product`.* FROM `product` LEFT JOIN `product_to_category` `PToC` ON PToC.product_id =product.product_id LEFT JOIN `product_category` `Category` ON Category.category_id =PToC.category_id WHERE (`product`.`status`=1) AND (Category.category_id = '0=A or Category.parent_id = '0=A)";i:1;i:4;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.32237911224365234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/idtscom/public_html/_protected/common/models/product/ProductQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:53;s:8:"function";s:3:"all";s:5:"class";s:34:"common\models\product\ProductQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:40;a:5:{i:0;s:6368:"exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0=A)' at line 1' in /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/db/Command.php:900
Stack trace:
#0 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/db/Command.php(900): PDOStatement->execute()
#1 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/db/Command.php(362): yii\db\Command->queryInternal('<span class="st...', '<span class="ke...')
#2 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/db/Query.php(210): yii\db\Command->queryAll()
#3 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/db/ActiveQuery.php(133): yii\db\Query->all('<span class="ke...')
#4 /home/idtscom/public_html/_protected/common/models/product/ProductQuery.php(24): yii\db\ActiveQuery->all('<span class="ke...')
#5 /home/idtscom/public_html/_protected/frontend/views/product/product_listing.php(53): common\models\product\ProductQuery->all()
#6 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/View.php(325): require('/home/idtscom/p...')
#7 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/View.php(247): yii\base\View->renderPhpFile('<span class="st...', '[<span class="s...')
#8 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/View.php(149): yii\base\View->renderFile('<span class="st...', '[<span class="s...', Object(frontend\controllers\ProductController))
#9 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/Controller.php(378): yii\base\View->render('<span class="st...', '[<span class="s...', Object(frontend\controllers\ProductController))
#10 /home/idtscom/public_html/_protected/frontend/controllers/ProductController.php(114): yii\base\Controller->render('<span class="st...', '[<span class="s...')
#11 [internal function]: frontend\controllers\ProductController->actionListing('<span class="st...', '<span class="st...')
#12 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/InlineAction.php(55): call_user_func_array('[<span class="t...', '[<span class="s...')
#13 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/Controller.php(154): yii\base\InlineAction->runWithParams('[<span class="s...')
#14 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/Module.php(454): yii\base\Controller->runAction('<span class="st...', '[<span class="s...')
#15 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/web/Application.php(87): yii\base\Module->runAction('<span class="st...', '[<span class="s...')
#16 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/Application.php(375): yii\web\Application->handleRequest(Object(yii\web\Request))
#17 /home/idtscom/public_html/index.php(18): yii\base\Application->run()
#18 {main}

Next exception 'yii\db\Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0=A)' at line 1
The SQL being executed was: SELECT `product`.* FROM `product` LEFT JOIN `product_to_category` `PToC` ON PToC.product_id =product.product_id LEFT JOIN `product_category` `Category` ON Category.category_id =PToC.category_id WHERE (`product`.`status`=1) AND (Category.category_id = '0=A or Category.parent_id = '0=A)' in /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/db/Schema.php:633
Stack trace:
#0 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/db/Command.php(915): yii\db\Schema->convertException(Object(PDOException), 'SELECT `product...')
#1 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/db/Command.php(362): yii\db\Command->queryInternal('<span class="st...', '<span class="ke...')
#2 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/db/Query.php(210): yii\db\Command->queryAll()
#3 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/db/ActiveQuery.php(133): yii\db\Query->all('<span class="ke...')
#4 /home/idtscom/public_html/_protected/common/models/product/ProductQuery.php(24): yii\db\ActiveQuery->all('<span class="ke...')
#5 /home/idtscom/public_html/_protected/frontend/views/product/product_listing.php(53): common\models\product\ProductQuery->all()
#6 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/View.php(325): require('/home/idtscom/p...')
#7 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/View.php(247): yii\base\View->renderPhpFile('<span class="st...', '[<span class="s...')
#8 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/View.php(149): yii\base\View->renderFile('<span class="st...', '[<span class="s...', Object(frontend\controllers\ProductController))
#9 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/Controller.php(378): yii\base\View->render('<span class="st...', '[<span class="s...', Object(frontend\controllers\ProductController))
#10 /home/idtscom/public_html/_protected/frontend/controllers/ProductController.php(114): yii\base\Controller->render('<span class="st...', '[<span class="s...')
#11 [internal function]: frontend\controllers\ProductController->actionListing('<span class="st...', '<span class="st...')
#12 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/InlineAction.php(55): call_user_func_array('[<span class="t...', '[<span class="s...')
#13 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/Controller.php(154): yii\base\InlineAction->runWithParams('[<span class="s...')
#14 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/Module.php(454): yii\base\Controller->runAction('<span class="st...', '[<span class="s...')
#15 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/web/Application.php(87): yii\base\Module->runAction('<span class="st...', '[<span class="s...')
#16 /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/base/Application.php(375): yii\web\Application->handleRequest(Object(yii\web\Request))
#17 /home/idtscom/public_html/index.php(18): yii\base\Application->run()
#18 {main}
Additional Information:
Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0=A)' at line 1
)
";i:1;i:1;i:2;s:16:"yii\db\Exception";i:3;d:1508474596.3300259113311767578125;i:4;a:0:{}}i:41;a:5:{i:0;s:110:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/exception.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.332930088043212890625;i:4;a:0:{}}i:42;a:5:{i:0;s:118:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/previousException.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3339169025421142578125;i:4;a:0:{}}i:43;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.334515094757080078125;i:4;a:0:{}}i:44;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3354671001434326171875;i:4;a:0:{}}i:45;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3362009525299072265625;i:4;a:0:{}}i:46;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3510229587554931640625;i:4;a:0:{}}i:47;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.351646900177001953125;i:4;a:0:{}}i:48;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3520910739898681640625;i:4;a:0:{}}i:49;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3524188995361328125;i:4;a:0:{}}i:50;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.35280704498291015625;i:4;a:0:{}}i:51;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3532159328460693359375;i:4;a:0:{}}i:52;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3536789417266845703125;i:4;a:0:{}}i:53;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3541619777679443359375;i:4;a:0:{}}i:54;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.354629993438720703125;i:4;a:0:{}}i:55;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.354958057403564453125;i:4;a:0:{}}i:56;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3551769256591796875;i:4;a:0:{}}i:57;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3555400371551513671875;i:4;a:0:{}}i:58;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3560559749603271484375;i:4;a:0:{}}i:59;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.35651493072509765625;i:4;a:0:{}}i:60;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3569490909576416015625;i:4;a:0:{}}i:61;a:5:{i:0;s:114:"Rendering view file: /home/idtscom/public_html/_protected/vendor/yiisoft/yii2/views/errorHandler/callStackItem.php";i:1;i:8;i:2;s:25:"yii\base\View::renderFile";i:3;d:1508474596.3583219051361083984375;i:4;a:0:{}}i:62;a:5:{i:0;s:103:"Access to debugger is denied due to IP address restriction. The requesting IP address is 35.201.133.158";i:1;i:2;i:2;s:29:"yii\debug\Module::checkAccess";i:3;d:1508474596.3628590106964111328125;i:4;a:0:{}}}}s:9:"profiling";a:3:{s:6:"memory";i:5024608;s:4:"time";d:3.341682910919189453125;s:8:"messages";a:20:{i:11;a:5:{i:0;s:70:"Opening DB connection: mysql:host=localhost:3306;dbname=idtscom_system";i:1;i:80;i:2;s:23:"yii\db\Connection::open";i:3;d:1508474596.1761200428009033203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:33;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:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:19;s:8:"function";s:3:"one";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:12;a:5:{i:0;s:70:"Opening DB connection: mysql:host=localhost:3306;dbname=idtscom_system";i:1;i:96;i:2;s:23:"yii\db\Connection::open";i:3;d:1508474596.1858999729156494140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:33;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:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:19;s:8:"function";s:3:"one";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:14;a:5:{i:0;s:60:"SELECT * FROM `product_category` WHERE `category_id`='\'0=A'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.1861131191253662109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:33;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:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:19;s:8:"function";s:3:"one";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:15;a:5:{i:0;s:60:"SELECT * FROM `product_category` WHERE `category_id`='\'0=A'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.1865749359130859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:33;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:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:19;s:8:"function";s:3:"one";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:17;a:5:{i:0;s:60:"SELECT * FROM `product_category` WHERE `category_id` IS NULL";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.1887609958648681640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:33;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:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:28;s:8:"function";s:3:"one";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:18;a:5:{i:0;s:60:"SELECT * FROM `product_category` WHERE `category_id` IS NULL";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.191153049468994140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:33;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:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:28;s:8:"function";s:3:"one";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:20;a:5:{i:0;s:99:"SELECT * FROM `product_category` WHERE (`status`=1) AND (`parent_id`='\'0=A') ORDER BY `sort_order`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.191502094268798828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:21;a:5:{i:0;s:99:"SELECT * FROM `product_category` WHERE (`status`=1) AND (`parent_id`='\'0=A') ORDER BY `sort_order`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.1921379566192626953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:23;a:5:{i:0;s:41:"SHOW FULL COLUMNS FROM `product_category`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.1928389072418212890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:24;a:5:{i:0;s:41:"SHOW FULL COLUMNS FROM `product_category`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.291368961334228515625;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:26;a:5:{i:0;s:619:"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 = 'product_category' AND kcu.table_name = 'product_category'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.3060610294342041015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:27;a:5:{i:0;s:619:"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 = 'product_category' AND kcu.table_name = 'product_category'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.3078629970550537109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:29;a:5:{i:0;s:85:"SELECT * FROM `product_category_description` WHERE `category_id` IN (1, 3, 2, 38, 53)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.3093879222869873046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:30;a:5:{i:0;s:85:"SELECT * FROM `product_category_description` WHERE `category_id` IN (1, 3, 2, 38, 53)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.316770076751708984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:32;a:5:{i:0;s:53:"SHOW FULL COLUMNS FROM `product_category_description`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.316996097564697265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:33;a:5:{i:0;s:53:"SHOW FULL COLUMNS FROM `product_category_description`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.317923069000244140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:35;a:5:{i:0;s:643:"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 = 'product_category_description' AND kcu.table_name = 'product_category_description'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.31847095489501953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:36;a:5:{i:0;s:643:"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 = 'product_category_description' AND kcu.table_name = 'product_category_description'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.32054805755615234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:38;a:5:{i:0;s:285:"SELECT `product`.* FROM `product` LEFT JOIN `product_to_category` `PToC` ON PToC.product_id =product.product_id LEFT JOIN `product_category` `Category` ON Category.category_id =PToC.category_id WHERE (`product`.`status`=1) AND (Category.category_id = '0=A or Category.parent_id = '0=A)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.3224499225616455078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/idtscom/public_html/_protected/common/models/product/ProductQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:53;s:8:"function";s:3:"all";s:5:"class";s:34:"common\models\product\ProductQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:39;a:5:{i:0;s:285:"SELECT `product`.* FROM `product` LEFT JOIN `product_to_category` `PToC` ON PToC.product_id =product.product_id LEFT JOIN `product_category` `Category` ON Category.category_id =PToC.category_id WHERE (`product`.`status`=1) AND (Category.category_id = '0=A or Category.parent_id = '0=A)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.3293640613555908203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/idtscom/public_html/_protected/common/models/product/ProductQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:53;s:8:"function";s:3:"all";s:5:"class";s:34:"common\models\product\ProductQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}}}s:2:"db";a:1:{s:8:"messages";a:18:{i:14;a:5:{i:0;s:60:"SELECT * FROM `product_category` WHERE `category_id`='\'0=A'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.1861131191253662109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:33;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:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:19;s:8:"function";s:3:"one";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:15;a:5:{i:0;s:60:"SELECT * FROM `product_category` WHERE `category_id`='\'0=A'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.1865749359130859375;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:33;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:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:19;s:8:"function";s:3:"one";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:17;a:5:{i:0;s:60:"SELECT * FROM `product_category` WHERE `category_id` IS NULL";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.1887609958648681640625;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:33;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:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:28;s:8:"function";s:3:"one";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:18;a:5:{i:0;s:60:"SELECT * FROM `product_category` WHERE `category_id` IS NULL";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.191153049468994140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:33;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:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:28;s:8:"function";s:3:"one";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:20;a:5:{i:0;s:99:"SELECT * FROM `product_category` WHERE (`status`=1) AND (`parent_id`='\'0=A') ORDER BY `sort_order`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.191502094268798828125;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:21;a:5:{i:0;s:99:"SELECT * FROM `product_category` WHERE (`status`=1) AND (`parent_id`='\'0=A') ORDER BY `sort_order`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.1921379566192626953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:23;a:5:{i:0;s:41:"SHOW FULL COLUMNS FROM `product_category`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.1928389072418212890625;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:24;a:5:{i:0;s:41:"SHOW FULL COLUMNS FROM `product_category`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.291368961334228515625;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:26;a:5:{i:0;s:619:"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 = 'product_category' AND kcu.table_name = 'product_category'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.3060610294342041015625;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:27;a:5:{i:0;s:619:"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 = 'product_category' AND kcu.table_name = 'product_category'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.3078629970550537109375;i:4;a:3:{i:0;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:29;a:5:{i:0;s:85:"SELECT * FROM `product_category_description` WHERE `category_id` IN (1, 3, 2, 38, 53)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.3093879222869873046875;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:30;a:5:{i:0;s:85:"SELECT * FROM `product_category_description` WHERE `category_id` IN (1, 3, 2, 38, 53)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.316770076751708984375;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:32;a:5:{i:0;s:53:"SHOW FULL COLUMNS FROM `product_category_description`";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.316996097564697265625;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:33;a:5:{i:0;s:53:"SHOW FULL COLUMNS FROM `product_category_description`";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.317923069000244140625;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:35;a:5:{i:0;s:643:"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 = 'product_category_description' AND kcu.table_name = 'product_category_description'";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.31847095489501953125;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:36;a:5:{i:0;s:643:"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 = 'product_category_description' AND kcu.table_name = 'product_category_description'";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.32054805755615234375;i:4;a:3:{i:0;a:5:{s:4:"file";s:102:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryDescriptionQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:91:"/home/idtscom/public_html/_protected/common/models/productCategory/ProductCategoryQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:44;s:8:"function";s:3:"all";s:5:"class";s:50:"common\models\ProductCategory\ProductCategoryQuery";s:4:"type";s:2:"->";}}}i:38;a:5:{i:0;s:285:"SELECT `product`.* FROM `product` LEFT JOIN `product_to_category` `PToC` ON PToC.product_id =product.product_id LEFT JOIN `product_category` `Category` ON Category.category_id =PToC.category_id WHERE (`product`.`status`=1) AND (Category.category_id = '0=A or Category.parent_id = '0=A)";i:1;i:80;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.3224499225616455078125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/idtscom/public_html/_protected/common/models/product/ProductQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:53;s:8:"function";s:3:"all";s:5:"class";s:34:"common\models\product\ProductQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";s:4:"type";s:2:"->";}}}i:39;a:5:{i:0;s:285:"SELECT `product`.* FROM `product` LEFT JOIN `product_to_category` `PToC` ON PToC.product_id =product.product_id LEFT JOIN `product_category` `Category` ON Category.category_id =PToC.category_id WHERE (`product`.`status`=1) AND (Category.category_id = '0=A or Category.parent_id = '0=A)";i:1;i:96;i:2;s:21:"yii\db\Command::query";i:3;d:1508474596.3293640613555908203125;i:4;a:3:{i:0;a:5:{s:4:"file";s:75:"/home/idtscom/public_html/_protected/common/models/product/ProductQuery.php";s:4:"line";i:24;s:8:"function";s:3:"all";s:5:"class";s:18:"yii\db\ActiveQuery";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/views/product/product_listing.php";s:4:"line";i:53;s:8:"function";s:3:"all";s:5:"class";s:34:"common\models\product\ProductQuery";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:79:"/home/idtscom/public_html/_protected/frontend/controllers/ProductController.php";s:4:"line";i:114;s:8:"function";s:6:"render";s:5:"class";s:19:"yii\base\Controller";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:"59e97ee3e3664";s:3:"url";s:69:"http://www.idts.com.my/index.php/product/listing?view=list&pid=%270=A";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:14:"35.201.133.158";s:4:"time";i:1508474599;s:10:"statusCode";i:500;s:8:"sqlCount";i:9;s:9:"mailCount";i:0;}}