# | Time | Since previous | Level | Category | Message |
---|---|---|---|---|---|
1 | 02:03:27.781 | < 0ms > | trace | yii\base\Application::bootstrap | Bootstrap with dektrium\rbac\Bootstrap::bootstrap() |
2 | 02:03:27.781 | trace | yii\base\Module::getModule | Loading module: rbac | |
3 | 02:03:27.781 | trace | yii\base\Application::bootstrap | Bootstrap with dektrium\user\Bootstrap::bootstrap() | |
4 | 02:03:27.782 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher | |
5 | 02:03:27.782 | trace | yii\base\Module::getModule | Loading module: admin | |
6 | 02:03:27.782 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\admin\Module::bootstrap() | |
7 | 02:03:27.782 | trace | yii\base\Module::getModule | Loading module: debug | |
8 | 02:03:27.782 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() | |
9 | 02:03:27.782 | trace | yii\base\Module::getModule | Loading module: gii | |
10 | 02:03:27.782 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() | |
11 | 02:03:27.783 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=max3 | |
12 | 02:03:27.783 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE url = 'en' | |
13 | 02:03:27.784 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `lang` | |
14 | 02:03:27.784 | 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 | 02:03:27.784 | trace | yii\web\Application::handleRequest | Route requested: 'shop/product/index' | |
16 | 02:03:27.784 | trace | yii\base\Module::getModule | Loading module: shop | |
17 | 02:03:27.784 | trace | yii\base\Controller::runAction | Route to run: shop/product/index | |
18 | 02:03:27.785 | trace | yii\base\InlineAction::runWithParams | Running action: webdoka\yiiecommerce\frontend\controllers\ProductController::actionIndex() | |
19 | 02:03:27.785 | info | yii\db\Command::query | SELECT * FROM `products` WHERE (`slug`='vinilovyj-proigryvatel-alive-audio-glam-aqua') AND (`is_want_to_be_active`=1) | |
20 | 02:03:27.785 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `products` | |
21 | 02:03:27.786 | 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 | 02:03:27.786 | info | yii\db\Command::query | SELECT `discount_id` FROM `products_discounts` WHERE `product_id`=503 | |
23 | 02:03:27.786 | 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 | 02:03:27.787 | info | yii\db\Command::query | SELECT * FROM `products_variants` WHERE (`product_id`=503) AND (`is_filled_options`=1) | |
25 | 02:03:27.787 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `products_variants` | |
26 | 02:03:27.787 | 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 | 02:03:27.787 | info | yii\db\Command::query | SELECT * FROM `products_variants_value` WHERE `products_variants_id`=462 ORDER BY `products_variants_id`, `products_options_id` | |
28 | 02:03:27.788 | info | yii\db\Command::query | SELECT * FROM `prices` WHERE `auth_item_name`='' | |
29 | 02:03:27.788 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `prices` | |
30 | 02:03:27.788 | 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 | 02:03:27.788 | info | yii\db\Command::query | SELECT MIN(value) FROM `products_variant_prices` WHERE (`price_id`=2) AND (`variant_id`=462) | |
32 | 02:03:27.789 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
33 | 02:03:27.789 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `currencies` | |
34 | 02:03:27.789 | 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 | 02:03:27.789 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
36 | 02:03:27.790 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
37 | 02:03:27.790 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
38 | 02:03:27.790 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
39 | 02:03:27.790 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
40 | 02:03:27.790 | info | yii\db\Command::query | SELECT * FROM `products` WHERE `id`=503 | |
41 | 02:03:27.791 | info | yii\db\Command::query | SELECT `discount_id` FROM `products_discounts` WHERE `product_id`=503 | |
42 | 02:03:27.791 | 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 | 02:03:27.791 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
44 | 02:03:27.791 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
45 | 02:03:27.791 | 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 | 02:03:27.794 | info | yii\web\Session::open | Session started | |
47 | 02:03:27.794 | info | yii\db\Command::query | SELECT * FROM `categories` ORDER BY `parent_id` | |
48 | 02:03:27.794 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `categories` | |
49 | 02:03:27.794 | 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 | 02:03:27.795 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/index.php | |
51 | 02:03:27.795 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='seo_title') | |
52 | 02:03:27.796 | info | yii\db\Command::query | SELECT * FROM `product_langs` WHERE `product_id`=503 | |
53 | 02:03:27.796 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `product_langs` | |
54 | 02:03:27.796 | 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 | 02:03:27.797 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='seo_description') | |
56 | 02:03:27.797 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='seo_keywords') | |
57 | 02:03:27.797 | info | yii\db\Command::query | SELECT * FROM `countries` WHERE (`id` IS NULL) AND (`exists_tax`=1) | |
58 | 02:03:27.797 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/_product.php | |
59 | 02:03:27.797 | 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`=503 ORDER BY `products_filestorage`.`id` | |
60 | 02:03:27.798 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `file_storage` | |
61 | 02:03:27.798 | 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 | 02:03:27.799 | info | yii\db\Command::query | SELECT * FROM `products_variants` WHERE `product_id`=503 | |
63 | 02:03:27.799 | info | yii\db\Command::query | SELECT MAX(amount_in_storage) FROM `products_variants` WHERE `product_id`=503 | |
64 | 02:03:27.799 | info | yii\db\Command::query | SELECT * FROM `products_variant_filestorage` WHERE `variant_id`=462 | |
65 | 02:03:27.799 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE 0=1 | |
66 | 02:03:27.800 | info | yii\db\Command::query | SELECT * FROM `products_variants` WHERE `product_id`=503 | |
67 | 02:03:27.800 | info | yii\db\Command::query | SELECT * FROM `products_variant_filestorage` WHERE `variant_id`=462 | |
68 | 02:03:27.800 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE 0=1 | |
69 | 02:03:27.801 | info | yii\db\Command::query | SELECT * FROM `products_variants` WHERE `product_id`=503 | |
70 | 02:03:27.801 | info | yii\db\Command::query | SELECT * FROM `products_variant_filestorage` WHERE `variant_id`=462 | |
71 | 02:03:27.801 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE 0=1 | |
72 | 02:03:27.801 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
73 | 02:03:27.803 | info | yii\db\Command::query | SELECT * FROM `units` WHERE `id`=1 | |
74 | 02:03:27.804 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `units` | |
75 | 02:03:27.804 | 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 | 02:03:27.804 | info | yii\db\Command::query | SELECT * FROM `unit_langs` WHERE `unit_id`=1 | |
77 | 02:03:27.804 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `unit_langs` | |
78 | 02:03:27.805 | 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 | 02:03:27.805 | info | yii\db\Command::query | SELECT * FROM `reviews` WHERE `product_id`=503 | |
80 | 02:03:27.805 | info | yii\db\Command::query | SELECT * FROM `features_products` WHERE `product_id`=503 | |
81 | 02:03:27.805 | info | yii\db\Command::query | SELECT * FROM `products_discounts` WHERE `product_id`=503 | |
82 | 02:03:27.806 | info | yii\db\Command::query | SELECT * FROM `discounts` WHERE 0=1 | |
83 | 02:03:27.806 | info | yii\db\Command::query | SELECT * FROM `products_variants` WHERE `product_id`=503 | |
84 | 02:03:27.806 | info | yii\db\Command::query | SELECT * FROM `prices` WHERE `auth_item_name`='' | |
85 | 02:03:27.806 | info | yii\db\Command::query | SELECT MIN(value) FROM `products_variant_prices` WHERE (`price_id`=2) AND (`variant_id`=462) | |
86 | 02:03:27.807 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
87 | 02:03:27.807 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
88 | 02:03:27.807 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/sendProductLinkForm.php | |
89 | 02:03:27.807 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
90 | 02:03:27.807 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
91 | 02:03:27.808 | 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 | 02:03:27.812 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
93 | 02:03:27.812 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/_details.php | |
94 | 02:03:27.812 | info | yii\db\Command::query | SELECT * FROM `categories` WHERE `id`=73 | |
95 | 02:03:27.812 | info | yii\db\Command::query | SELECT * FROM `category_langs` WHERE `category_id`=73 | |
96 | 02:03:27.813 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `category_langs` | |
97 | 02:03:27.813 | 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 | 02:03:27.813 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/tabs/_description.php | |
99 | 02:03:27.813 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/tabs/_attributes.php | |
100 | 02:03:27.814 | 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 | 02:03:27.814 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `eav_attribute` | |
102 | 02:03:27.814 | 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 | 02:03:27.814 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
104 | 02:03:27.815 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `eav_entity` | |
105 | 02:03:27.815 | 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 | 02:03:27.815 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c67') | |
107 | 02:03:27.815 | 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 | 02:03:27.816 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
109 | 02:03:27.816 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_type` WHERE `id`=1 | |
110 | 02:03:27.816 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `eav_attribute_type` | |
111 | 02:03:27.816 | 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 | 02:03:27.817 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=67 | |
113 | 02:03:27.817 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `eav_attribute_rules` | |
114 | 02:03:27.817 | 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 | 02:03:27.818 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `eav_attribute_value` | |
116 | 02:03:27.818 | 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 | 02:03:27.818 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_value` WHERE (`entityId`=503) AND (`attributeId`=67) | |
118 | 02:03:27.818 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c67') | |
119 | 02:03:27.819 | 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 | 02:03:27.819 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
121 | 02:03:27.819 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_type` WHERE `id`=1 | |
122 | 02:03:27.819 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=67 | |
123 | 02:03:27.820 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_value` WHERE (`entityId`=503) AND (`attributeId`=67) | |
124 | 02:03:27.820 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c68') | |
125 | 02:03:27.820 | 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 | 02:03:27.820 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
127 | 02:03:27.820 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_type` WHERE `id`=7 | |
128 | 02:03:27.821 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=68 | |
129 | 02:03:27.821 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_value` WHERE (`entityId`=503) AND (`attributeId`=68) | |
130 | 02:03:27.821 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c68') | |
131 | 02:03:27.821 | 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 | 02:03:27.822 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
133 | 02:03:27.822 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_type` WHERE `id`=7 | |
134 | 02:03:27.822 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=68 | |
135 | 02:03:27.822 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_value` WHERE (`entityId`=503) AND (`attributeId`=68) | |
136 | 02:03:27.823 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c69') | |
137 | 02:03:27.823 | 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 | 02:03:27.823 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
139 | 02:03:27.823 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_type` WHERE `id`=1 | |
140 | 02:03:27.824 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=69 | |
141 | 02:03:27.824 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_value` WHERE (`entityId`=503) AND (`attributeId`=69) | |
142 | 02:03:27.824 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c69') | |
143 | 02:03:27.824 | 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 | 02:03:27.825 | info | yii\db\Command::query | SELECT * FROM `eav_entity` WHERE `id`=1 | |
145 | 02:03:27.825 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_type` WHERE `id`=1 | |
146 | 02:03:27.825 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=69 | |
147 | 02:03:27.825 | info | yii\db\Command::query | SELECT * FROM `eav_attribute_value` WHERE (`entityId`=503) AND (`attributeId`=69) | |
148 | 02:03:27.826 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/tabs/_reviews.php | |
149 | 02:03:27.826 | info | yii\db\Command::query | SELECT COUNT(*) FROM `reviews` WHERE (`deleted`='0') AND (`status`='1') AND (`deleted`='0') AND (`product_id`=503) | |
150 | 02:03:27.826 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `reviews` | |
151 | 02:03:27.826 | 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 | 02:03:27.827 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/views/product/tabs/_review-form.php | |
153 | 02:03:27.827 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
154 | 02:03:27.827 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
155 | 02:03:27.827 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/widgets/views/file-upload/upload.php | |
156 | 02:03:27.827 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/widgets/views/file-upload/download.php | |
157 | 02:03:27.828 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/widgets/views/file-upload/form.php | |
158 | 02:03:27.828 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/widgets/views/file-upload/gallery.php | |
159 | 02:03:27.850 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/views/layouts/main.php | |
160 | 02:03:27.851 | info | yii\db\Command::query | SELECT * FROM `company_contacts` | |
161 | 02:03:27.851 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `company_contacts` | |
162 | 02:03:27.851 | 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 | 02:03:27.852 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
164 | 02:03:27.852 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE id != 9 | |
165 | 02:03:27.852 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `exchange_rate` IS NOT NULL | |
166 | 02:03:27.852 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
167 | 02:03:27.853 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='2b752f3d7aab4c4f71ecc6d4226fc3e7-1653937858.8962' | |
168 | 02:03:27.853 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
169 | 02:03:27.853 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
170 | 02:03:27.853 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/widgets/views/carttop.php | |
171 | 02:03:27.853 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
172 | 02:03:27.854 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
173 | 02:03:27.854 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
174 | 02:03:27.855 | info | yii\db\Command::query | SELECT * FROM `currencies` WHERE `is_default`=1 | |
175 | 02:03:27.855 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
176 | 02:03:27.855 | info | yii\db\Command::query | SELECT * FROM `menus` WHERE `code`='top_menu' | |
177 | 02:03:27.855 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `menus` | |
178 | 02:03:27.856 | 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 | 02:03:27.856 | info | yii\db\Command::query | SELECT * FROM `menu_items` WHERE `menu_id`=3 | |
180 | 02:03:27.856 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `menu_items` | |
181 | 02:03:27.857 | 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 | 02:03:27.857 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=6 | |
183 | 02:03:27.857 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `menu_item_langs` | |
184 | 02:03:27.857 | 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 | 02:03:27.858 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=7 | |
186 | 02:03:27.858 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=8 | |
187 | 02:03:27.858 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/widgets/views/menu/topMenu.php | |
188 | 02:03:27.859 | info | yii\db\Command::query | SELECT * FROM `top_banners` WHERE `status`=1 ORDER BY `sort` DESC | |
189 | 02:03:27.859 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `top_banners` | |
190 | 02:03:27.859 | 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 | 02:03:27.859 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='c36a3007d51e8c79288c37fa3c53cc3b-1653651632.9782' | |
192 | 02:03:27.860 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/widgets/views/topBanner.php | |
193 | 02:03:27.860 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='f05b3ccb0ea7fbbb14c4c073da54b67d-1654001571.0239' | |
194 | 02:03:27.860 | info | yii\db\Command::query | SELECT * FROM `top_banner_langs` WHERE `top_banner_id`=8 | |
195 | 02:03:27.860 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
196 | 02:03:27.860 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
197 | 02:03:27.861 | info | yii\db\Command::query | SELECT * FROM `manufacturer` | |
198 | 02:03:27.861 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `manufacturer` | |
199 | 02:03:27.861 | 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 | 02:03:27.861 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='ab3f1d647cc645522e1a4eb12bb61598-1592550824.8948' | |
201 | 02:03:27.862 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='a416fbbcd135d6ecb55c2efd9ab2dcbb-1592550872.4732' | |
202 | 02:03:27.862 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='6c0b4eaeee5fbd396a094f33bf16cf29-1592550908.5516' | |
203 | 02:03:27.862 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='92f8835bb6d8aab017ebb17d434d428d-1592552095.2681' | |
204 | 02:03:27.862 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='0683a4e96e9b8ffb110cd7f69ad2a3c3-1592552167.2648' | |
205 | 02:03:27.863 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='' | |
206 | 02:03:27.863 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='99b0ab22b9506c6c4d17da1950649d6a-1586594818.2509' | |
207 | 02:03:27.863 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='1372586e304cb328af8ef43ccb54b6a5-1586594789.657' | |
208 | 02:03:27.863 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='60de62ed877be54e300168ed8e2aea64-1603624974.6457' | |
209 | 02:03:27.863 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/vendor/webdoka/yii-ecommerce/frontend/widgets/views/brands.php | |
210 | 02:03:27.863 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/views/layouts/_footer.php | |
211 | 02:03:27.863 | info | yii\db\Command::query | SELECT * FROM `company_contacts` | |
212 | 02:03:27.864 | info | yii\db\Command::query | SELECT * FROM `company_contacts_langs` WHERE `company_contact_id`=1 | |
213 | 02:03:27.864 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `company_contacts_langs` | |
214 | 02:03:27.864 | 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 | 02:03:27.864 | info | yii\db\Command::query | SELECT * FROM `company_contacts_social_networks` | |
216 | 02:03:27.865 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `company_contacts_social_networks` | |
217 | 02:03:27.865 | 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 | 02:03:27.865 | info | yii\db\Command::query | SELECT * FROM `file_storage` WHERE `id`='2b752f3d7aab4c4f71ecc6d4226fc3e7-1653937858.8962' | |
219 | 02:03:27.865 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/widgets/views/companyContacts.php | |
220 | 02:03:27.866 | info | yii\db\Command::query | SELECT * FROM `menus` WHERE `code`='bottom_left_menu' | |
221 | 02:03:27.866 | info | yii\db\Command::query | SELECT * FROM `menu_items` WHERE `menu_id`=2 | |
222 | 02:03:27.866 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=3 | |
223 | 02:03:27.866 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=4 | |
224 | 02:03:27.866 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=5 | |
225 | 02:03:27.867 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=14 | |
226 | 02:03:27.867 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/widgets/views/menu/bottomMenu.php | |
227 | 02:03:27.867 | info | yii\db\Command::query | SELECT * FROM `menu_langs` WHERE `menu_id`=2 | |
228 | 02:03:27.867 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `menu_langs` | |
229 | 02:03:27.867 | 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 | 02:03:27.868 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
231 | 02:03:27.868 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
232 | 02:03:27.868 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
233 | 02:03:27.868 | info | yii\db\Command::query | SELECT * FROM `menus` WHERE `code`='bottom_right_menu' | |
234 | 02:03:27.869 | info | yii\db\Command::query | SELECT * FROM `menu_items` WHERE `menu_id`=4 | |
235 | 02:03:27.869 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=10 | |
236 | 02:03:27.869 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=11 | |
237 | 02:03:27.869 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=12 | |
238 | 02:03:27.869 | info | yii\db\Command::query | SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=13 | |
239 | 02:03:27.870 | trace | yii\base\View::renderFile | Rendering view file: /home/mmb/max3/widgets/views/menu/bottomMenu.php | |
240 | 02:03:27.870 | info | yii\db\Command::query | SELECT * FROM `menu_langs` WHERE `menu_id`=4 | |
241 | 02:03:27.870 | info | yii\db\Command::query | SELECT * FROM `company_contacts` | |
242 | 02:03:27.870 | info | yii\db\Command::query | SELECT * FROM `company_contacts_langs` WHERE `company_contact_id`=1 | |
243 | 02:03:27.870 | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 | |
244 | 02:03:27.871 | < 0ms > | info | yii\db\Command::query | SELECT * FROM `lang` WHERE `default` = 1 |