# | Time | Since previous | Level | Category | Message |
---|---|---|---|---|---|
1 | 19:25:42.441 | < 0ms > | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
2 | 19:25:42.441 | trace | yii\base\Module::getModule | Loading module: debug | |
3 | 19:25:42.442 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() | |
4 | 19:25:42.442 | trace | yii\base\Application::bootstrap | Bootstrap with common\components\maintenance\Maintenance::bootstrap() | |
5 | 19:25:42.442 | info | yii\web\Session::open | Session started | |
6 | 19:25:42.443 | trace | yii\web\Application::handleRequest | Route requested: 'vtour/scene' | |
7 | 19:25:42.443 | trace | yii\base\Controller::runAction | Route to run: vtour/scene | |
8 | 19:25:42.443 | trace | yii\base\InlineAction::runWithParams | Running action: frontend\controllers\VtourController::actionScene() | |
9 | 19:25:42.444 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;port=3306;dbname=tiencuong_db | |
10 | 19:25:42.445 | info | yii\db\Command::query | SELECT * FROM `scene` WHERE `slug`='kb05' | |
11 | 19:25:42.445 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `scene` | |
12 | 19:25:42.446 | 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' | |
13 | 19:25:42.446 | info | yii\db\Command::query | SELECT * FROM `point` WHERE (`construction_id` IS NULL) AND (`scene_id`=16) | |
14 | 19:25:42.447 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `point` | |
15 | 19:25:42.448 | 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' | |
16 | 19:25:42.449 | info | yii\db\Command::query | SELECT * FROM `point` WHERE ((`scene_id`=16) AND (`construction_id` IS NULL)) AND (`status`=1) ORDER BY `id` DESC | |
17 | 19:25:42.450 | 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`=16)) AND (NOT (`default_product`='NULL')) AND (`status`=1) | |
18 | 19:25:42.451 | 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`='1' | |
19 | 19:25:42.451 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `product` | |
20 | 19:25:42.452 | 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' | |
21 | 19:25:42.453 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=16 | |
22 | 19:25:42.453 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `category` | |
23 | 19:25:42.454 | 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' | |
24 | 19:25:42.454 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=1 | |
25 | 19:25:42.456 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='110') AND (`product_id`='1') | |
26 | 19:25:42.457 | 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`='295' | |
27 | 19:25:42.458 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=47 | |
28 | 19:25:42.458 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=295 | |
29 | 19:25:42.460 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `product_image_map` | |
30 | 19:25:42.460 | 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_image_map' AND `kcu`.`TABLE_NAME` = 'product_image_map' | |
31 | 19:25:42.461 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='111') AND (`product_id`='295') | |
32 | 19:25:42.462 | 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`='145' | |
33 | 19:25:42.462 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=36 | |
34 | 19:25:42.463 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=145 | |
35 | 19:25:42.465 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='112') AND (`product_id`='145') | |
36 | 19:25:42.466 | 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`='295' | |
37 | 19:25:42.466 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=47 | |
38 | 19:25:42.466 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=295 | |
39 | 19:25:42.469 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='113') AND (`product_id`='295') | |
40 | 19:25:42.470 | 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`='1' | |
41 | 19:25:42.470 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=16 | |
42 | 19:25:42.470 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=1 | |
43 | 19:25:42.472 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='114') AND (`product_id`='1') | |
44 | 19:25:42.473 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `code`='cat_brand' | |
45 | 19:25:42.474 | 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 | |
46 | 19:25:42.475 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `code`='tag_gach' | |
47 | 19:25:42.476 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`parent_id`=9) AND (`author`=0) ORDER BY `id` | |
48 | 19:25:42.476 | 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 | |
49 | 19:25:42.477 | 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 | |
50 | 19:25:42.477 | 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 | |
51 | 19:25:42.478 | 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 | |
52 | 19:25:42.478 | < 0ms > | trace | yii\base\View::renderFile | Rendering view file: /var/www/vth/frontend/views/vtour/scene.php |