685fb632eb719: GET https://3d.tiencuongceramic.com/vtour/scene/kb01 at 2025-06-28 04:30:26 pm by 14.224.191.18
Performance Profiling
Total processing time: 36 ms; Peak memory: 3.219 MB. Show Profiling Timeline
Total 57 items.
| Time | Duration | Category | Info |
|---|---|---|---|
| 16:30:26.972 | 1.2 ms | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=54 |
| 16:30:26.975 | 1.2 ms | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=165 |
| 16:30:26.978 | 1.0 ms | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=140 |
| 16:30:26.980 | 1.0 ms | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=14 |
| 16:30:26.982 | 1.0 ms | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=54 |
| 16:30:26.985 | 1.0 ms | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=14 |
| 16:30:26.987 | 1.0 ms | yii\db\Command::query | SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=165 |
| 16:30:26.989 | 0.6 ms | 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 |
| 16:30:26.974 | 0.5 ms | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='75') AND (`product_id`='54') |
| 16:30:26.977 | 0.4 ms | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='76') AND (`product_id`='165') |
| 16:30:26.979 | 0.4 ms | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='77') AND (`product_id`='140') |
| 16:30:26.988 | 0.4 ms | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='123') AND (`product_id`='165') |
| 16:30:26.984 | 0.4 ms | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='83') AND (`product_id`='54') |
| 16:30:26.986 | 0.4 ms | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='122') AND (`product_id`='14') |
| 16:30:26.981 | 0.4 ms | yii\db\Command::query | SELECT * FROM `point_product` WHERE (`point_id`='79') AND (`product_id`='14') |
| 16:30:26.962 | 0.4 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;port=3306;dbname=tiencuong_db |
| 16:30:26.967 | 0.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `point` |
| 16:30:26.970 | 0.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `product` |
| 16:30:26.963 | 0.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `user` |
| 16:30:26.967 | 0.4 ms | yii\db\Command::query | SELECT * FROM `point` WHERE (`construction_id` IS NULL) AND (`scene_id`=15) |
| 16:30:26.969 | 0.3 ms | yii\db\Command::query | SELECT * FROM `point` WHERE ((`scene_id`=15) AND (`construction_id` IS NULL)) AND (`status`=1) ORDER BY `id` DESC |
| 16:30:26.991 | 0.3 ms | 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 |
| 16:30:26.971 | 0.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `category` |
| 16:30:26.966 | 0.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `scene` |
| 16:30:26.963 | 0.3 ms | 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` = 'user' AND `kcu`.`TABLE_NAME` = 'user' |
| 16:30:26.965 | 0.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `user_profile` |
| 16:30:26.991 | 0.3 ms | 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 |
| 16:30:26.969 | 0.2 ms | 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`=15)) AND (NOT (`default_product`='NULL')) AND (`status`=1) |
| 16:30:26.962 | 0.2 ms | yii\db\Command::query | SELECT * FROM `user` WHERE (`status`=2) AND (`id`=1) |
| 16:30:26.965 | 0.2 ms | 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` = 'user_profile' AND `kcu`.`TABLE_NAME` = 'user_profile' |
| 16:30:26.973 | 0.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `product_image_map` |
| 16:30:26.990 | 0.2 ms | yii\db\Command::query | SELECT * FROM `category` WHERE `code`='tag_gach' |
| 16:30:26.990 | 0.2 ms | yii\db\Command::query | SELECT * FROM `category` WHERE (`parent_id`=9) AND (`author`=0) ORDER BY `id` |
| 16:30:26.992 | 0.2 ms | 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 |
| 16:30:26.968 | 0.2 ms | 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:30:26.971 | 0.2 ms | 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' |
| 16:30:26.967 | 0.2 ms | 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:30:26.972 | 0.2 ms | 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' |
| 16:30:26.989 | 0.2 ms | yii\db\Command::query | SELECT * FROM `category` WHERE `code`='cat_brand' |
| 16:30:26.974 | 0.2 ms | 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' |
| 16:30:26.992 | 0.2 ms | 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 |
| 16:30:26.966 | 0.2 ms | yii\db\Command::query | SELECT * FROM `scene` WHERE `slug`='kb01' |
| 16:30:26.977 | 0.2 ms | 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`='140' |
| 16:30:26.970 | 0.2 ms | 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`='54' |
| 16:30:26.984 | 0.2 ms | 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`='14' |
| 16:30:26.975 | 0.2 ms | 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`='165' |
| 16:30:26.986 | 0.2 ms | 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`='165' |
| 16:30:26.980 | 0.2 ms | 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`='14' |
| 16:30:26.982 | 0.1 ms | 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`='54' |
| 16:30:26.964 | 0.1 ms | yii\db\Command::query | SELECT * FROM `user_profile` WHERE `user_id`=1 |
| 16:30:26.971 | 0.1 ms | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=21 |
| 16:30:26.980 | 0.1 ms | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=16 |
| 16:30:26.985 | 0.1 ms | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=16 |
| 16:30:26.987 | 0.1 ms | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=18 |
| 16:30:26.975 | 0.1 ms | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=18 |
| 16:30:26.982 | 0.1 ms | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=21 |
| 16:30:26.978 | 0.1 ms | yii\db\Command::query | SELECT * FROM `category` WHERE `id`=22 |