# | Time | Since previous | Level | Category | Message |
---|---|---|---|---|---|
1 | 14:23:12.313 | < 0ms > | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
2 | 14:23:12.313 | trace | yii\base\Module::getModule | Loading module: debug | |
3 | 14:23:12.313 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() | |
4 | 14:23:12.314 | trace | yii\base\Application::bootstrap | Bootstrap with common\components\maintenance\Maintenance::bootstrap() | |
5 | 14:23:12.314 | info | yii\web\Session::open | Session started | |
6 | 14:23:12.314 | trace | yii\web\Application::handleRequest | Route requested: 'vtour/scene' | |
7 | 14:23:12.314 | trace | yii\base\Controller::runAction | Route to run: vtour/scene | |
8 | 14:23:12.314 | trace | yii\base\InlineAction::runWithParams | Running action: frontend\controllers\VtourController::actionScene() | |
9 | 14:23:12.315 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;port=3306;dbname=tiencuong_db | |
10 | 14:23:12.315 | info | yii\db\Command::query | SELECT * FROM `scene` WHERE `slug`='sv01' | |
11 | 14:23:12.316 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `scene` | |
12 | 14:23:12.316 | 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 | 14:23:12.317 | info | yii\db\Command::query | SELECT * FROM `point` WHERE (`construction_id` IS NULL) AND (`scene_id`=21) | |
14 | 14:23:12.317 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `point` | |
15 | 14:23:12.318 | 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 | 14:23:12.318 | info | yii\db\Command::query | SELECT * FROM `point` WHERE ((`scene_id`=21) AND (`construction_id` IS NULL)) AND (`status`=1) ORDER BY `id` DESC | |
17 | 14:23:12.319 | 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`=21)) AND (NOT (`default_product`='NULL')) AND (`status`=1) | |
18 | 14:23:12.320 | 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`='225' | |
19 | 14:23:12.320 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='201') AND (`product_id`='225') | |
20 | 14:23:12.321 | 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`='292' | |
21 | 14:23:12.321 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `product` | |
22 | 14:23:12.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` = 'product' AND `kcu`.`TABLE_NAME` = 'product' | |
23 | 14:23:12.322 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=21 | |
24 | 14:23:12.322 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `category` | |
25 | 14:23:12.322 | 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' | |
26 | 14:23:12.323 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=292 | |
27 | 14:23:12.324 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `product_image_map` | |
28 | 14:23:12.324 | 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' | |
29 | 14:23:12.328 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='202') AND (`product_id`='292') | |
30 | 14:23:12.328 | 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`='378' | |
31 | 14:23:12.329 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=21 | |
32 | 14:23:12.329 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=378 | |
33 | 14:23:12.331 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='203') AND (`product_id`='378') | |
34 | 14:23:12.331 | 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`='233' | |
35 | 14:23:12.332 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=44 | |
36 | 14:23:12.332 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=233 | |
37 | 14:23:12.334 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='204') AND (`product_id`='233') | |
38 | 14:23:12.334 | 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' | |
39 | 14:23:12.335 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=16 | |
40 | 14:23:12.335 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=2 | |
41 | 14:23:12.336 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='205') AND (`product_id`='2') | |
42 | 14:23:12.337 | 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`='235' | |
43 | 14:23:12.337 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=44 | |
44 | 14:23:12.337 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=235 | |
45 | 14:23:12.340 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='206') AND (`product_id`='235') | |
46 | 14:23:12.340 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `code`='cat_brand' | |
47 | 14:23:12.341 | 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 | |
48 | 14:23:12.342 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `code`='tag_gach' | |
49 | 14:23:12.342 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`parent_id`=9) AND (`author`=0) ORDER BY `id` | |
50 | 14:23:12.342 | 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 | |
51 | 14:23:12.343 | 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 | |
52 | 14:23:12.343 | 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 | |
53 | 14:23:12.343 | 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 | |
54 | 14:23:12.344 | < 0ms > | trace | yii\base\View::renderFile | Rendering view file: /var/www/vth/frontend/views/vtour/scene.php |