Performance Profiling

Total processing time: 61 ms; Peak memory: 2.911 MB. Show Profiling Timeline

Total 45 items.

Time	Duration	Category	Info

16:46:02.478	6.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` = 'scene' AND `kcu`.`TABLE_NAME` = 'scene'
16:46:02.491	1.6 ms	yii\db\Command::query	SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=292
16:46:02.527	1.4 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:46:02.506	1.2 ms	yii\db\Command::query	SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=378
16:46:02.511	1.0 ms	yii\db\Command::query	SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=233
16:46:02.515	1.0 ms	yii\db\Command::query	SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=2
16:46:02.519	1.0 ms	yii\db\Command::query	SELECT `src`, `rows`, `cols` FROM `product_image_map` WHERE `product_id`=235
16:46:02.525	0.9 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:46:02.490	0.7 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:46:02.493	0.6 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:46:02.523	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:46:02.526	0.5 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:46:02.527	0.5 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:46:02.505	0.5 ms	yii\db\Command::query	SELECT * FROM `point_product` WHERE (`point_id`='202') AND (`product_id`='292')
16:46:02.510	0.5 ms	yii\db\Command::query	SELECT * FROM `point_product` WHERE (`point_id`='203') AND (`product_id`='378')
16:46:02.488	0.4 ms	yii\db\Command::query	SELECT * FROM `point_product` WHERE (`point_id`='201') AND (`product_id`='225')
16:46:02.522	0.4 ms	yii\db\Command::query	SELECT * FROM `point_product` WHERE (`point_id`='206') AND (`product_id`='235')
16:46:02.514	0.4 ms	yii\db\Command::query	SELECT * FROM `point_product` WHERE (`point_id`='204') AND (`product_id`='233')
16:46:02.518	0.4 ms	yii\db\Command::query	SELECT * FROM `point_product` WHERE (`point_id`='205') AND (`product_id`='2')
16:46:02.476	0.4 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;port=3306;dbname=tiencuong_db
16:46:02.488	0.4 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `product`
16:46:02.484	0.4 ms	yii\db\Command::query	SELECT * FROM `point` WHERE (`construction_id` IS NULL) AND (`scene_id`=21)
16:46:02.485	0.4 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `point`
16:46:02.477	0.4 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `scene`
16:46:02.486	0.3 ms	yii\db\Command::query	SELECT * FROM `point` WHERE ((`scene_id`=21) AND (`construction_id` IS NULL)) AND (`status`=1) ORDER BY `id` DESC
16:46:02.490	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `category`
16:46:02.487	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`=21)) AND (NOT (`default_product`='NULL')) AND (`status`=1)
16:46:02.485	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:46:02.477	0.2 ms	yii\db\Command::query	SELECT * FROM `scene` WHERE `slug`='sv01'
16:46:02.524	0.2 ms	yii\db\Command::query	SELECT * FROM `category` WHERE (`parent_id`=9) AND (`author`=0) ORDER BY `id`
16:46:02.489	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:46:02.493	0.2 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `product_image_map`
16:46:02.524	0.2 ms	yii\db\Command::query	SELECT * FROM `category` WHERE `code`='tag_gach'
16:46:02.523	0.2 ms	yii\db\Command::query	SELECT * FROM `category` WHERE `code`='cat_brand'
16:46:02.487	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`='225'
16:46:02.506	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`='378'
16:46:02.511	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`='233'
16:46:02.519	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`='235'
16:46:02.515	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`='2'
16:46:02.488	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`='292'
16:46:02.489	0.1 ms	yii\db\Command::query	SELECT * FROM `category` WHERE `id`=21
16:46:02.511	0.1 ms	yii\db\Command::query	SELECT * FROM `category` WHERE `id`=44
16:46:02.506	0.1 ms	yii\db\Command::query	SELECT * FROM `category` WHERE `id`=21
16:46:02.519	0.1 ms	yii\db\Command::query	SELECT * FROM `category` WHERE `id`=44
16:46:02.515	0.1 ms	yii\db\Command::query	SELECT * FROM `category` WHERE `id`=16