Performance Profiling

Total processing time: 154 ms; Peak memory: 5.691 MB. Show Profiling Timeline

Всего 60 записей.

Time	Duration	Category	Info

21:05:41.077	2.0 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `q_information`
21:05:41.074	1.6 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=dbshop_91
21:05:41.146	1.6 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `content_pages`
21:05:41.099	1.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `shop_razdels`
21:05:41.082	1.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `q_contact`
21:05:41.089	1.2 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `shop_discounts`
21:05:41.098	1.1 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3)
21:05:41.080	1.0 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` = 'q_information' AND `kcu`.`TABLE_NAME` = 'q_information'
21:05:41.091	1.0 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` = 'shop_discounts' AND `kcu`.`TABLE_NAME` = 'shop_discounts'
21:05:41.084	1.0 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` = 'q_contact' AND `kcu`.`TABLE_NAME` = 'q_contact'
21:05:41.101	0.9 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` = 'shop_razdels' AND `kcu`.`TABLE_NAME` = 'shop_razdels'
21:05:41.148	0.9 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` = 'content_pages' AND `kcu`.`TABLE_NAME` = 'content_pages'
21:05:41.076	0.7 ms	yii\db\Command::query	SELECT `sit`.* FROM `q_information` `sit` LEFT JOIN `q_contact` `c` ON `sit`.`id` = `c`.`site_id` WHERE `sit`.`id`=91 LIMIT 1
21:05:41.145	0.6 ms	yii\db\Command::query	SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) ORDER BY `lft`
21:05:41.079	0.6 ms	yii\db\Command::query	SHOW CREATE TABLE `q_information`
21:05:41.090	0.5 ms	yii\db\Command::query	SHOW CREATE TABLE `shop_discounts`
21:05:41.148	0.5 ms	yii\db\Command::query	SHOW CREATE TABLE `content_pages`
21:05:41.179	0.4 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=40)
21:05:41.083	0.4 ms	yii\db\Command::query	SHOW CREATE TABLE `q_contact`
21:05:41.183	0.4 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=44)
21:05:41.175	0.4 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=32)
21:05:41.151	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=3)
21:05:41.198	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_discounts` WHERE `status` > 2 ORDER BY `sort`
21:05:41.180	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=42)
21:05:41.162	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=17)
21:05:41.153	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=4)
21:05:41.192	0.3 ms	yii\db\Command::query	SELECT * FROM `q_contact` WHERE `site_id`=91
21:05:41.186	0.3 ms	yii\db\Command::query	SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) AND (`pag`.`id`=4) ORDER BY `lft`
21:05:41.089	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_discounts` WHERE `status` > 2 ORDER BY `sort`
21:05:41.187	0.3 ms	yii\db\Command::query	SELECT * FROM `content_pages` WHERE ((`lft` < 2) AND (`rgt` > 3)) AND (`tree`=91) AND (`status` > 0) ORDER BY `lft`
21:05:41.086	0.3 ms	yii\db\Command::query	SELECT * FROM `q_contact` WHERE `site_id`=91
21:05:41.178	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=36)
21:05:41.190	0.3 ms	yii\db\Command::query	SELECT * FROM `content_pages` WHERE ((`lft` < 4) AND (`rgt` > 5)) AND (`tree`=91) AND (`status` > 0) ORDER BY `lft`
21:05:41.100	0.3 ms	yii\db\Command::query	SHOW CREATE TABLE `shop_razdels`
21:05:41.161	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=16)
21:05:41.081	0.3 ms	yii\db\Command::query	SELECT * FROM `q_contact` `c` WHERE `site_id`=91
21:05:41.185	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=53)
21:05:41.182	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=43)
21:05:41.189	0.3 ms	yii\db\Command::query	SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) AND (`pag`.`id`=10) ORDER BY `lft`
21:05:41.167	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=24)
21:05:41.195	0.2 ms	yii\db\Command::query	SELECT ST_AsText('\0\0\0\0\0\0\0�=wE�K@��\Z�B@') as point
21:05:41.154	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=6)
21:05:41.087	0.2 ms	yii\db\Command::query	SELECT * FROM `q_contact` WHERE `site_id`=91 LIMIT 1
21:05:41.169	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=26)
21:05:41.155	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=11)
21:05:41.160	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=15)
21:05:41.174	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=31)
21:05:41.166	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=23)
21:05:41.177	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=33)
21:05:41.165	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=19)
21:05:41.164	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=18)
21:05:41.156	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=12)
21:05:41.168	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=25)
21:05:41.170	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=27)
21:05:41.158	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=14)
21:05:41.171	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=28)
21:05:41.157	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=13)
21:05:41.172	0.2 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=29)
21:05:41.173	0.1 ms	yii\db\Command::query	SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=30)
21:05:41.196	0.1 ms	yii\db\Command::query	SELECT ST_AsText('\0\0\0\0\0\0\0�=wE�K@��\Z�B@') as point