# | Time | Since previous | Level | Category | Message |
---|---|---|---|---|---|
1 | 23:33:49.318 | < 0ms > | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
2 | 23:33:49.318 | trace | yii\base\Module::getModule | Loading module: debug | |
3 | 23:33:49.319 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() | |
4 | 23:33:49.319 | trace | yii\base\Application::bootstrap | Bootstrap with common\components\maintenance\Maintenance::bootstrap() | |
5 | 23:33:49.320 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;port=3306;dbname=tiencuong_db | |
6 | 23:33:49.320 | info | yii\db\Command::query | SELECT * FROM `key_storage_item` WHERE `key`='frontend.maintenance' | |
7 | 23:33:49.321 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `key_storage_item` | |
8 | 23:33:49.321 | 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` = 'key_storage_item' AND `kcu`.`TABLE_NAME` = 'key_storage_item' | |
9 | 23:33:49.322 | info | yii\web\Session::open | Session started | |
10 | 23:33:49.322 | trace | yii\web\Application::handleRequest | Route requested: 'vtour/scene' | |
11 | 23:33:49.322 | trace | yii\base\Controller::runAction | Route to run: vtour/scene | |
12 | 23:33:49.322 | trace | yii\base\InlineAction::runWithParams | Running action: frontend\controllers\VtourController::actionScene() | |
13 | 23:33:49.323 | info | yii\db\Command::query | SELECT * FROM `scene` WHERE `slug`='pt02' | |
14 | 23:33:49.323 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `scene` | |
15 | 23:33:49.323 | 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` = 'scene' AND `kcu`.`TABLE_NAME` = 'scene' | |
16 | 23:33:49.324 | info | yii\db\Command::query | SELECT * FROM `point` WHERE (`construction_id` IS NULL) AND (`scene_id`=4) | |
17 | 23:33:49.324 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `point` | |
18 | 23:33:49.325 | 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` = 'point' AND `kcu`.`TABLE_NAME` = 'point' | |
19 | 23:33:49.325 | info | yii\db\Command::query | SELECT * FROM `point` WHERE ((`scene_id`=4) AND (`construction_id` IS NULL)) AND (`status`=1) ORDER BY `id` DESC | |
20 | 23:33:49.326 | info | yii\db\Command::query | SELECT `id`, `default_product`, `paving_id`, `target_object_id`, `scene_id`, `type`, `area`, `width_default`, `height_default`, `offset_x`, `offset_y`, `rotate` FROM `point` WHERE ((`construction_id` IS NULL) AND (`scene_id`=4)) AND (NOT (`default_product`='NULL')) AND (`status`=1) | |
21 | 23:33:49.326 | info | yii\db\Command::query | SELECT `id`, `name`, `image_path`, `brand_id`, `image_map`, `sub_image`, `status`, `path`, `price`, `discount`, `color`, `code`, `tag`, `roughness`, `metallic`, `size`, `type`, `image_uv`, `size_uv`, `image_map_padding` FROM `product` WHERE `id`='4' | |
22 | 23:33:49.326 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `product` | |
23 | 23:33:49.327 | 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' AND `kcu`.`TABLE_NAME` = 'product' | |
24 | 23:33:49.327 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=16 | |
25 | 23:33:49.327 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `category` | |
26 | 23:33:49.328 | 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' AND `kcu`.`TABLE_NAME` = 'category' | |
27 | 23:33:49.328 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=4 | |
28 | 23:33:49.330 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='195') AND (`product_id`='4') | |
29 | 23:33:49.330 | info | yii\db\Command::query | SELECT `id`, `name`, `image_path`, `brand_id`, `image_map`, `sub_image`, `status`, `path`, `price`, `discount`, `color`, `code`, `tag`, `roughness`, `metallic`, `size`, `type`, `image_uv`, `size_uv`, `image_map_padding` FROM `product` WHERE `id`='2' | |
30 | 23:33:49.331 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=16 | |
31 | 23:33:49.331 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=2 | |
32 | 23:33:49.332 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='196') AND (`product_id`='2') | |
33 | 23:33:49.333 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `code`='cat_brand' | |
34 | 23:33:49.333 | info | yii\db\Command::query | SELECT `category`.* FROM `category` LEFT JOIN `order_by` ON category.id = order_by.target_id and order_by.target = 'category' and order_by.user_id = 0 WHERE `parent_id`=5 ORDER BY `order_by` DESC | |
35 | 23:33:49.334 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `code`='tag_gach' | |
36 | 23:33:49.334 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`parent_id`=9) AND (`author`=0) ORDER BY `id` | |
37 | 23:33:49.335 | info | yii\db\Command::query | SELECT `category`.`id`, `name` FROM `category` LEFT JOIN `order_by` ON category.id = order_by.target_id and order_by.target = 'category' and order_by.user_id = 0 WHERE `parent_id`=10 ORDER BY `order_by` DESC | |
38 | 23:33:49.335 | info | yii\db\Command::query | SELECT `category`.`id`, `name` FROM `category` LEFT JOIN `order_by` ON category.id = order_by.target_id and order_by.target = 'category' and order_by.user_id = 0 WHERE `parent_id`=11 ORDER BY `order_by` DESC | |
39 | 23:33:49.336 | info | yii\db\Command::query | SELECT `category`.`id`, `name` FROM `category` LEFT JOIN `order_by` ON category.id = order_by.target_id and order_by.target = 'category' and order_by.user_id = 0 WHERE `parent_id`=12 ORDER BY `order_by` DESC | |
40 | 23:33:49.336 | info | yii\db\Command::query | SELECT `category`.`id`, `name` FROM `category` LEFT JOIN `order_by` ON category.id = order_by.target_id and order_by.target = 'category' and order_by.user_id = 0 WHERE `parent_id`=37 ORDER BY `order_by` DESC | |
41 | 23:33:49.336 | < 0ms > | trace | yii\base\View::renderFile | Rendering view file: /var/www/vth/frontend/views/vtour/scene.php |