# | Time | Since previous | Level | Category | Message |
---|---|---|---|---|---|
1 | 05:41:27.094 | < 0ms > | trace | yii\base\Application::bootstrap | Bootstrap with dektrium\rbac\Bootstrap::bootstrap() |
2 | 05:41:27.094 | trace | yii\base\Module::getModule | Loading module: rbac | |
3 | 05:41:27.094 | trace | yii\base\Application::bootstrap | Bootstrap with dektrium\user\Bootstrap::bootstrap() | |
4 | 05:41:27.094 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher | |
5 | 05:41:27.094 | trace | yii\base\Module::getModule | Loading module: admin | |
6 | 05:41:27.094 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\admin\Module::bootstrap() | |
7 | 05:41:27.094 | trace | yii\base\Module::getModule | Loading module: debug | |
8 | 05:41:27.095 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() | |
9 | 05:41:27.095 | trace | yii\base\Module::getModule | Loading module: gii | |
10 | 05:41:27.095 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() | |
11 | 05:41:27.096 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=max3 | |
12 | 05:41:27.096 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE url = 'en' | |
13 | 05:41:27.097 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `lang` | |
14 | 05:41:27.097 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'lang' AND `kcu`.`TABLE_NAME` = 'lang' | |
15 | 05:41:27.097 | trace | yii\web\Application::handleRequest | Route requested: 'shop/product/index' | |
16 | 05:41:27.097 | trace | yii\base\Module::getModule | Loading module: shop | |
17 | 05:41:27.098 | trace | yii\base\Controller::runAction | Route to run: shop/product/index | |
18 | 05:41:27.098 | trace | yii\base\InlineAction::runWithParams | Running action: webdoka\yiiecommerce\frontend\controllers\ProductController::actionIndex() | |
19 | 05:41:27.098 | info | yii\db\Command::query | SELECT * FROM `products` WHERE (`slug`='besprovodnye-nausniki-philips-tah5205-black') AND (`is_want_to_be_active`=1) | |
20 | 05:41:27.098 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `products` | |
21 | 05:41:27.099 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'products' AND `kcu`.`TABLE_NAME` = 'products' | |
22 | 05:41:27.099 | info | yii\db\Command::query | SELECT `discount_id` FROM `products_discounts` WHERE `product_id`=347 | |
23 | 05:41:27.100 | info | yii\db\Command::query | SELECT * FROM `discounts` WHERE (0=1) AND (started_at IS NULL OR started_at <= NOW()) AND (finished_at IS NULL OR finished_at >= NOW()) | |
24 | 05:41:27.100 | info | yii\db\Command::query | SELECT * FROM `products_variants` WHERE (`product_id`=347) AND (`is_filled_options`=1) | |
25 | 05:41:27.100 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `products_variants` | |
26 | 05:41:27.100 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'products_variants' AND `kcu`.`TABLE_NAME` = 'products_variants' | |
27 | 05:41:27.101 | info | yii\db\Command::query | SELECT * FROM `products_variants_value` WHERE `products_variants_id`=307 ORDER BY `products_variants_id`, `products_options_id` | |
28 | 05:41:27.101 | info | yii\db\Command::query | SELECT * FROM `prices` WHERE `auth_item_name`='' | |
29 | 05:41:27.101 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `prices` | |
30 | 05:41:27.101 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'prices' AND `kcu`.`TABLE_NAME` = 'prices' | |
31 | 05:41:27.102 | info | yii\db\Command::query | SELECT MIN(value) FROM `products_variant_prices` WHERE (`price_id`=2) AND (`variant_id`=307) | |
32 | 05:41:27.102 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
33 | 05:41:27.102 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `currencies` | |
34 | 05:41:27.102 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'currencies' AND `kcu`.`TABLE_NAME` = 'currencies' | |
35 | 05:41:27.103 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
36 | 05:41:27.103 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
37 | 05:41:27.103 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
38 | 05:41:27.103 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
39 | 05:41:27.103 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
40 | 05:41:27.103 | info | yii\db\Command::query | SELECT * FROM `products` WHERE `id`=347 | |
41 | 05:41:27.104 | info | yii\db\Command::query | SELECT `discount_id` FROM `products_discounts` WHERE `product_id`=347 | |
42 | 05:41:27.104 | info | yii\db\Command::query | SELECT * FROM `discounts` WHERE (0=1) AND (started_at IS NULL OR started_at <= NOW()) AND (finished_at IS NULL OR finished_at >= NOW()) | |
43 | 05:41:27.104 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
44 | 05:41:27.104 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
45 | 05:41:27.105 | info | yii\db\Command::query | (SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `translate_source_message` `t1`, `translate_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='shop') AND (`t2`.`language`='en_EN')) UNION ALL ( SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `translate_source_message` `t1`, `translate_message` `t2` WHERE ((`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='shop') AND (`t2`.`language`='en')) AND (`t2`.`id` NOT IN (SELECT `id` FROM `translate_message` WHERE `language`='en_EN')) ) | |
46 | 05:41:27.107 | info | yii\web\Session::open | Session started | |
47 | 05:41:27.107 | info | yii\db\Command::query | SELECT * FROM `categories` ORDER BY `parent_id` | |
48 | 05:41:27.107 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `categories` | |
49 | 05:41:27.107 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'categories' AND `kcu`.`TABLE_NAME` = 'categories' | |
50 | 05:41:27.108 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/index.php | |
51 | 05:41:27.109 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='seo_title') | |
52 | 05:41:27.109 | info | yii\db\Command::query | SELECT * FROM `product_langs` WHERE `product_id`=347 | |
53 | 05:41:27.109 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `product_langs` | |
54 | 05:41:27.110 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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_langs' AND `kcu`.`TABLE_NAME` = 'product_langs' | |
55 | 05:41:27.110 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='seo_description') | |
56 | 05:41:27.110 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='seo_keywords') | |
57 | 05:41:27.110 | info | yii\db\Command::query | SELECT * FROM `countries` WHERE (`id` IS NULL) AND (`exists_tax`=1) | |
58 | 05:41:27.110 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/_product.php | |
59 | 05:41:27.111 | info | yii\db\Command::query | SELECT `file_storage`.* FROM `file_storage` INNER JOIN `products_filestorage` ON products_filestorage.id_file = file_storage.id WHERE `products_filestorage`.`id_product`=347 ORDER BY `products_filestorage`.`id` | |
60 | 05:41:27.111 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `file_storage` | |
61 | 05:41:27.111 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'file_storage' AND `kcu`.`TABLE_NAME` = 'file_storage' | |
62 | 05:41:27.112 | info | yii\db\Command::query | SELECT * FROM `products_variants` WHERE `product_id`=347 | |
63 | 05:41:27.112 | info | yii\db\Command::query | SELECT MAX(amount_in_storage) FROM `products_variants` WHERE `product_id`=347 | |
64 | 05:41:27.113 | info | yii\db\Command::query | SELECT * FROM `products_variant_filestorage` WHERE `variant_id`=307 | |
65 | 05:41:27.113 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE 0=1 | |
66 | 05:41:27.113 | info | yii\db\Command::query | SELECT * FROM `products_variants` WHERE `product_id`=347 | |
67 | 05:41:27.113 | info | yii\db\Command::query | SELECT * FROM `products_variant_filestorage` WHERE `variant_id`=307 | |
68 | 05:41:27.113 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE 0=1 | |
69 | 05:41:27.114 | info | yii\db\Command::query | SELECT * FROM `products_variants` WHERE `product_id`=347 | |
70 | 05:41:27.114 | info | yii\db\Command::query | SELECT * FROM `products_variant_filestorage` WHERE `variant_id`=307 | |
71 | 05:41:27.114 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE 0=1 | |
72 | 05:41:27.115 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
73 | 05:41:27.115 | info | yii\db\Command::query | SELECT * FROM `units` WHERE `id`=1 | |
74 | 05:41:27.115 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `units` | |
75 | 05:41:27.115 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'units' AND `kcu`.`TABLE_NAME` = 'units' | |
76 | 05:41:27.116 | info | yii\db\Command::query | SELECT * FROM `unit_langs` WHERE `unit_id`=1 | |
77 | 05:41:27.116 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `unit_langs` | |
78 | 05:41:27.116 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'unit_langs' AND `kcu`.`TABLE_NAME` = 'unit_langs' | |
79 | 05:41:27.117 | info | yii\db\Command::query | SELECT * FROM `reviews` WHERE `product_id`=347 | |
80 | 05:41:27.117 | info | yii\db\Command::query | SELECT * FROM `features_products` WHERE `product_id`=347 | |
81 | 05:41:27.117 | info | yii\db\Command::query | SELECT * FROM `products_discounts` WHERE `product_id`=347 | |
82 | 05:41:27.117 | info | yii\db\Command::query | SELECT * FROM `discounts` WHERE 0=1 | |
83 | 05:41:27.117 | info | yii\db\Command::query | SELECT * FROM `products_variants` WHERE `product_id`=347 | |
84 | 05:41:27.118 | info | yii\db\Command::query | SELECT * FROM `prices` WHERE `auth_item_name`='' | |
85 | 05:41:27.118 | info | yii\db\Command::query | SELECT MIN(value) FROM `products_variant_prices` WHERE (`price_id`=2) AND (`variant_id`=307) | |
86 | 05:41:27.118 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
87 | 05:41:27.118 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
88 | 05:41:27.119 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/sendProductLinkForm.php | |
89 | 05:41:27.119 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
90 | 05:41:27.119 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
91 | 05:41:27.120 | info | yii\db\Command::query | (SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `translate_source_message` `t1`, `translate_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='app') AND (`t2`.`language`='en_EN')) UNION ALL ( SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `translate_source_message` `t1`, `translate_message` `t2` WHERE ((`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='app') AND (`t2`.`language`='en')) AND (`t2`.`id` NOT IN (SELECT `id` FROM `translate_message` WHERE `language`='en_EN')) ) | |
92 | 05:41:27.125 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
93 | 05:41:27.126 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/_details.php | |
94 | 05:41:27.126 | info | yii\db\Command::query | SELECT * FROM `categories` WHERE `id`=42 | |
95 | 05:41:27.126 | info | yii\db\Command::query | SELECT * FROM `category_langs` WHERE `category_id`=42 | |
96 | 05:41:27.127 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `category_langs` | |
97 | 05:41:27.127 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'category_langs' AND `kcu`.`TABLE_NAME` = 'category_langs' | |
98 | 05:41:27.128 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/tabs/_description.php | |
99 | 05:41:27.128 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/tabs/_attributes.php | |
100 | 05:41:27.128 | info | yii\db\Command::query | SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE `entityModel`='webdoka\\yiiecommerce\\common\\models\\Product' ORDER BY `order` | |
101 | 05:41:27.129 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `eav_attribute` | |
102 | 05:41:27.129 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'eav_attribute' AND `kcu`.`TABLE_NAME` = 'eav_attribute' | |
103 | 05:41:27.130 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
104 | 05:41:27.130 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `eav_entity` | |
105 | 05:41:27.130 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'eav_entity' AND `kcu`.`TABLE_NAME` = 'eav_entity' | |
106 | 05:41:27.131 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c67') | |
107 | 05:41:27.131 | info | yii\db\Command::query | SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE (`entityModel`='webdoka\\yiiecommerce\\common\\models\\Product') AND (`name`='c67') ORDER BY `order` | |
108 | 05:41:27.131 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
109 | 05:41:27.132 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_type` WHERE `id`=1 | |
110 | 05:41:27.132 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `eav_attribute_type` | |
111 | 05:41:27.132 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'eav_attribute_type' AND `kcu`.`TABLE_NAME` = 'eav_attribute_type' | |
112 | 05:41:27.133 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=67 | |
113 | 05:41:27.133 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `eav_attribute_rules` | |
114 | 05:41:27.133 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'eav_attribute_rules' AND `kcu`.`TABLE_NAME` = 'eav_attribute_rules' | |
115 | 05:41:27.134 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `eav_attribute_value` | |
116 | 05:41:27.134 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'eav_attribute_value' AND `kcu`.`TABLE_NAME` = 'eav_attribute_value' | |
117 | 05:41:27.134 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_value` WHERE (`entityId`=347) AND (`attributeId`=67) | |
118 | 05:41:27.135 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c67') | |
119 | 05:41:27.135 | info | yii\db\Command::query | SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE (`entityModel`='webdoka\\yiiecommerce\\common\\models\\Product') AND (`name`='c67') ORDER BY `order` | |
120 | 05:41:27.135 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
121 | 05:41:27.136 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_type` WHERE `id`=1 | |
122 | 05:41:27.136 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=67 | |
123 | 05:41:27.136 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_value` WHERE (`entityId`=347) AND (`attributeId`=67) | |
124 | 05:41:27.137 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c68') | |
125 | 05:41:27.137 | info | yii\db\Command::query | SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE (`entityModel`='webdoka\\yiiecommerce\\common\\models\\Product') AND (`name`='c68') ORDER BY `order` | |
126 | 05:41:27.137 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
127 | 05:41:27.138 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_type` WHERE `id`=7 | |
128 | 05:41:27.138 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=68 | |
129 | 05:41:27.138 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_value` WHERE (`entityId`=347) AND (`attributeId`=68) | |
130 | 05:41:27.139 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c68') | |
131 | 05:41:27.139 | info | yii\db\Command::query | SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE (`entityModel`='webdoka\\yiiecommerce\\common\\models\\Product') AND (`name`='c68') ORDER BY `order` | |
132 | 05:41:27.139 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
133 | 05:41:27.140 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_type` WHERE `id`=7 | |
134 | 05:41:27.140 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=68 | |
135 | 05:41:27.140 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_value` WHERE (`entityId`=347) AND (`attributeId`=68) | |
136 | 05:41:27.140 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c69') | |
137 | 05:41:27.141 | info | yii\db\Command::query | SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE (`entityModel`='webdoka\\yiiecommerce\\common\\models\\Product') AND (`name`='c69') ORDER BY `order` | |
138 | 05:41:27.141 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
139 | 05:41:27.141 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_type` WHERE `id`=1 | |
140 | 05:41:27.142 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=69 | |
141 | 05:41:27.142 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_value` WHERE (`entityId`=347) AND (`attributeId`=69) | |
142 | 05:41:27.142 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c69') | |
143 | 05:41:27.143 | info | yii\db\Command::query | SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE (`entityModel`='webdoka\\yiiecommerce\\common\\models\\Product') AND (`name`='c69') ORDER BY `order` | |
144 | 05:41:27.143 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
145 | 05:41:27.143 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_type` WHERE `id`=1 | |
146 | 05:41:27.144 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=69 | |
147 | 05:41:27.144 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_value` WHERE (`entityId`=347) AND (`attributeId`=69) | |
148 | 05:41:27.144 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/tabs/_reviews.php | |
149 | 05:41:27.144 | info | yii\db\Command::query | SELECT COUNT(*) FROM `reviews` WHERE (`deleted`='0') AND (`status`='1') AND (`deleted`='0') AND (`product_id`=347) | |
150 | 05:41:27.145 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `reviews` | |
151 | 05:41:27.145 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'reviews' AND `kcu`.`TABLE_NAME` = 'reviews' | |
152 | 05:41:27.145 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/tabs/_review-form.php | |
153 | 05:41:27.146 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
154 | 05:41:27.146 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
155 | 05:41:27.146 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/widgets/views/file-upload/upload.php | |
156 | 05:41:27.147 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/widgets/views/file-upload/download.php | |
157 | 05:41:27.147 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/widgets/views/file-upload/form.php | |
158 | 05:41:27.147 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/widgets/views/file-upload/gallery.php | |
159 | 05:41:27.170 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/views/layouts/main.php | |
160 | 05:41:27.170 | info | yii\db\Command::query | SELECT * FROM `company_contacts` | |
161 | 05:41:27.170 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `company_contacts` | |
162 | 05:41:27.171 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'company_contacts' AND `kcu`.`TABLE_NAME` = 'company_contacts' | |
163 | 05:41:27.171 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
164 | 05:41:27.171 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE id != 9 | |
165 | 05:41:27.171 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `exchange_rate` IS NOT NULL | |
166 | 05:41:27.172 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
167 | 05:41:27.172 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='2b752f3d7aab4c4f71ecc6d4226fc3e7-1653937858.8962' | |
168 | 05:41:27.172 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
169 | 05:41:27.172 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
170 | 05:41:27.173 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/widgets/views/carttop.php | |
171 | 05:41:27.173 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
172 | 05:41:27.173 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
173 | 05:41:27.173 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
174 | 05:41:27.173 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
175 | 05:41:27.174 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
176 | 05:41:27.174 | info | yii\db\Command::query | SELECT * FROM `menus` WHERE `code`='top_menu' | |
177 | 05:41:27.174 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `menus` | |
178 | 05:41:27.174 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'menus' AND `kcu`.`TABLE_NAME` = 'menus' | |
179 | 05:41:27.175 | info | yii\db\Command::query | SELECT * FROM `menu_items` WHERE `menu_id`=3 | |
180 | 05:41:27.175 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `menu_items` | |
181 | 05:41:27.175 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'menu_items' AND `kcu`.`TABLE_NAME` = 'menu_items' | |
182 | 05:41:27.175 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=6 | |
183 | 05:41:27.175 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `menu_item_langs` | |
184 | 05:41:27.176 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'menu_item_langs' AND `kcu`.`TABLE_NAME` = 'menu_item_langs' | |
185 | 05:41:27.176 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=7 | |
186 | 05:41:27.176 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=8 | |
187 | 05:41:27.176 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/widgets/views/menu/topMenu.php | |
188 | 05:41:27.177 | info | yii\db\Command::query | SELECT * FROM `top_banners` WHERE `status`=1 ORDER BY `sort` DESC | |
189 | 05:41:27.177 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `top_banners` | |
190 | 05:41:27.177 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'top_banners' AND `kcu`.`TABLE_NAME` = 'top_banners' | |
191 | 05:41:27.177 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='c36a3007d51e8c79288c37fa3c53cc3b-1653651632.9782' | |
192 | 05:41:27.178 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/widgets/views/topBanner.php | |
193 | 05:41:27.178 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='f05b3ccb0ea7fbbb14c4c073da54b67d-1654001571.0239' | |
194 | 05:41:27.178 | info | yii\db\Command::query | SELECT * FROM `top_banner_langs` WHERE `top_banner_id`=8 | |
195 | 05:41:27.178 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
196 | 05:41:27.178 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
197 | 05:41:27.179 | info | yii\db\Command::query | SELECT * FROM `manufacturer` | |
198 | 05:41:27.179 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `manufacturer` | |
199 | 05:41:27.179 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'manufacturer' AND `kcu`.`TABLE_NAME` = 'manufacturer' | |
200 | 05:41:27.179 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='ab3f1d647cc645522e1a4eb12bb61598-1592550824.8948' | |
201 | 05:41:27.180 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='a416fbbcd135d6ecb55c2efd9ab2dcbb-1592550872.4732' | |
202 | 05:41:27.180 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='6c0b4eaeee5fbd396a094f33bf16cf29-1592550908.5516' | |
203 | 05:41:27.180 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='92f8835bb6d8aab017ebb17d434d428d-1592552095.2681' | |
204 | 05:41:27.180 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='0683a4e96e9b8ffb110cd7f69ad2a3c3-1592552167.2648' | |
205 | 05:41:27.180 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='' | |
206 | 05:41:27.181 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='99b0ab22b9506c6c4d17da1950649d6a-1586594818.2509' | |
207 | 05:41:27.181 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='1372586e304cb328af8ef43ccb54b6a5-1586594789.657' | |
208 | 05:41:27.181 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='60de62ed877be54e300168ed8e2aea64-1603624974.6457' | |
209 | 05:41:27.181 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/widgets/views/brands.php | |
210 | 05:41:27.181 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/views/layouts/_footer.php | |
211 | 05:41:27.181 | info | yii\db\Command::query | SELECT * FROM `company_contacts` | |
212 | 05:41:27.182 | info | yii\db\Command::query | SELECT * FROM `company_contacts_langs` WHERE `company_contact_id`=1 | |
213 | 05:41:27.182 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `company_contacts_langs` | |
214 | 05:41:27.182 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'company_contacts_langs' AND `kcu`.`TABLE_NAME` = 'company_contacts_langs' | |
215 | 05:41:27.182 | info | yii\db\Command::query | SELECT * FROM `company_contacts_social_networks` | |
216 | 05:41:27.183 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `company_contacts_social_networks` | |
217 | 05:41:27.183 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'company_contacts_social_networks' AND `kcu`.`TABLE_NAME` = 'company_contacts_social_networks' | |
218 | 05:41:27.183 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='2b752f3d7aab4c4f71ecc6d4226fc3e7-1653937858.8962' | |
219 | 05:41:27.183 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/widgets/views/companyContacts.php | |
220 | 05:41:27.183 | info | yii\db\Command::query | SELECT * FROM `menus` WHERE `code`='bottom_left_menu' | |
221 | 05:41:27.184 | info | yii\db\Command::query | SELECT * FROM `menu_items` WHERE `menu_id`=2 | |
222 | 05:41:27.184 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=3 | |
223 | 05:41:27.184 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=4 | |
224 | 05:41:27.184 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=5 | |
225 | 05:41:27.185 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=14 | |
226 | 05:41:27.185 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/widgets/views/menu/bottomMenu.php | |
227 | 05:41:27.185 | info | yii\db\Command::query | SELECT * FROM `menu_langs` WHERE `menu_id`=2 | |
228 | 05:41:27.185 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `menu_langs` | |
229 | 05:41:27.185 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'menu_langs' AND `kcu`.`TABLE_NAME` = 'menu_langs' | |
230 | 05:41:27.186 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
231 | 05:41:27.186 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
232 | 05:41:27.186 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
233 | 05:41:27.186 | info | yii\db\Command::query | SELECT * FROM `menus` WHERE `code`='bottom_right_menu' | |
234 | 05:41:27.187 | info | yii\db\Command::query | SELECT * FROM `menu_items` WHERE `menu_id`=4 | |
235 | 05:41:27.187 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=10 | |
236 | 05:41:27.187 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=11 | |
237 | 05:41:27.187 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=12 | |
238 | 05:41:27.187 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=13 | |
239 | 05:41:27.188 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/widgets/views/menu/bottomMenu.php | |
240 | 05:41:27.188 | info | yii\db\Command::query | SELECT * FROM `menu_langs` WHERE `menu_id`=4 | |
241 | 05:41:27.188 | info | yii\db\Command::query | SELECT * FROM `company_contacts` | |
242 | 05:41:27.188 | info | yii\db\Command::query | SELECT * FROM `company_contacts_langs` WHERE `company_contact_id`=1 | |
243 | 05:41:27.189 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
244 | 05:41:27.189 | < 0ms > | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 |