# | Time | Since previous | Level | Category | Message |
---|---|---|---|---|---|
1 | 08:51:44.937 | < 0ms > | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
2 | 08:51:44.937 | trace | yii\base\Module::getModule | Loading module: debug | |
3 | 08:51:44.938 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() | |
4 | 08:51:44.938 | trace | yii\base\Application::bootstrap | Bootstrap with common\components\maintenance\Maintenance::bootstrap() | |
5 | 08:51:44.938 | info | yii\web\Session::open | Session started | |
6 | 08:51:44.939 | trace | yii\web\Application::handleRequest | Route requested: 'vtour/scene' | |
7 | 08:51:44.939 | trace | yii\base\Controller::runAction | Route to run: vtour/scene | |
8 | 08:51:44.939 | trace | yii\base\InlineAction::runWithParams | Running action: frontend\controllers\VtourController::actionScene() | |
9 | 08:51:44.939 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;port=3306;dbname=tiencuong_db | |
10 | 08:51:44.940 | info | yii\db\Command::query | SELECT * FROM `scene` WHERE `slug`='sv01' | |
11 | 08:51:44.940 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `scene` | |
12 | 08:51:44.941 | 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 | 08:51:44.941 | info | yii\db\Command::query | SELECT * FROM `point` WHERE (`construction_id` IS NULL) AND (`scene_id`=21) | |
14 | 08:51:44.942 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `point` | |
15 | 08:51:44.942 | 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 | 08:51:44.943 | 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 | 08:51:44.944 | 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 | 08:51:44.944 | 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 | 08:51:44.944 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='201') AND (`product_id`='225') | |
20 | 08:51:44.945 | 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 | 08:51:44.945 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `product` | |
22 | 08:51:44.946 | 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 | 08:51:44.946 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=21 | |
24 | 08:51:44.946 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `category` | |
25 | 08:51:44.947 | 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 | 08:51:44.947 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=292 | |
27 | 08:51:44.948 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `product_image_map` | |
28 | 08:51:44.949 | 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 | 08:51:44.949 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='202') AND (`product_id`='292') | |
30 | 08:51:44.950 | 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 | 08:51:44.950 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=21 | |
32 | 08:51:44.950 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=378 | |
33 | 08:51:44.952 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='203') AND (`product_id`='378') | |
34 | 08:51:44.952 | 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 | 08:51:44.953 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=44 | |
36 | 08:51:44.953 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=233 | |
37 | 08:51:44.954 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='204') AND (`product_id`='233') | |
38 | 08:51:44.954 | 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 | 08:51:44.955 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=16 | |
40 | 08:51:44.955 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=2 | |
41 | 08:51:44.956 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='205') AND (`product_id`='2') | |
42 | 08:51:44.957 | 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 | 08:51:44.957 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=44 | |
44 | 08:51:44.957 | info | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=235 | |
45 | 08:51:44.958 | info | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='206') AND (`product_id`='235') | |
46 | 08:51:44.959 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `code`='cat_brand' | |
47 | 08:51:44.959 | 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 | 08:51:44.960 | info | yii\db\Command::query | SELECT * FROM `category` WHERE `code`='tag_gach' | |
49 | 08:51:44.961 | info | yii\db\Command::query | SELECT * FROM `category` WHERE (`parent_id`=9) AND (`author`=0) ORDER BY `id` | |
50 | 08:51:44.961 | 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 | 08:51:44.962 | 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 | 08:51:44.962 | 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 | 08:51:44.962 | 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 | 08:51:44.963 | < 0ms > | trace | yii\base\View::renderFile | Rendering view file: /var/www/vth/frontend/views/vtour/scene.php |