Performance Profiling

Total processing time: 114 ms; Peak memory: 4.519 MB. Show Profiling Timeline

Всего 61 запись.
TimeDurationCategoryInfo
  
21:05:48.8471.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `q_contact`
21:05:48.9181.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `content_pages`
21:05:48.8721.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `shop_razdels`
21:05:48.9201.1 msyii\db\Command::querySELECT `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:48.8531.0 msyii\db\Command::querySHOW FULL COLUMNS FROM `q_information`
21:05:48.8511.0 msyii\db\Command::querySELECT * FROM `q_contact` WHERE `id`=91
21:05:48.8460.9 msyii\db\Connection::openOpening DB connection: mysql:host=localhost;dbname=dbshop_91
21:05:48.8650.9 msyii\db\Command::querySHOW FULL COLUMNS FROM `shop_discounts`
21:05:48.8500.9 msyii\db\Command::querySELECT `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:48.8710.8 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3)
21:05:48.8550.7 msyii\db\Command::querySELECT `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:48.8730.7 msyii\db\Command::querySELECT `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:48.8660.6 msyii\db\Command::querySELECT `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:48.9170.6 msyii\db\Command::querySELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) ORDER BY `lft`
21:05:48.9190.6 msyii\db\Command::querySHOW CREATE TABLE `content_pages`
21:05:48.9230.4 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=3)
21:05:48.8490.4 msyii\db\Command::querySHOW CREATE TABLE `q_contact`
21:05:48.8530.3 msyii\db\Command::querySELECT `sit`.* FROM `q_information` `sit` LEFT JOIN `q_contact` `c` ON `sit`.`id` = `c`.`site_id` WHERE `sit`.`id`=91 LIMIT 1
21:05:48.9510.3 msyii\db\Command::querySELECT * FROM `content_pages` WHERE ((`lft` < 2) AND (`rgt` > 3)) AND (`tree`=91) AND (`status` > 0) ORDER BY `lft`
21:05:48.8550.3 msyii\db\Command::querySHOW CREATE TABLE `q_information`
21:05:48.8730.3 msyii\db\Command::querySHOW CREATE TABLE `shop_razdels`
21:05:48.8650.2 msyii\db\Command::querySELECT * FROM `shop_discounts` WHERE `status` > 2 ORDER BY `sort`
21:05:48.8660.2 msyii\db\Command::querySHOW CREATE TABLE `shop_discounts`
21:05:48.9240.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=4)
21:05:48.9270.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=12)
21:05:48.9310.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=16)
21:05:48.9260.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=11)
21:05:48.9250.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=6)
21:05:48.9410.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=30)
21:05:48.8580.2 msyii\db\Command::querySELECT * FROM `q_contact` WHERE `site_id`=91 LIMIT 1
21:05:48.8620.2 msyii\db\Command::querySELECT * FROM `q_contact` WHERE `site_id`=91
21:05:48.9470.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=43)
21:05:48.8590.2 msyii\db\Command::querySELECT * FROM `q_contact` WHERE `site_id`=91
21:05:48.8560.2 msyii\db\Command::querySELECT * FROM `q_contact` `c` WHERE `site_id`=91
21:05:48.9400.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=29)
21:05:48.9500.2 msyii\db\Command::querySELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) AND (`pag`.`id`=4) ORDER BY `lft`
21:05:48.9350.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=24)
21:05:48.9390.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=28)
21:05:48.9520.2 msyii\db\Command::querySELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) AND (`pag`.`id`=10) ORDER BY `lft`
21:05:48.9320.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=17)
21:05:48.9440.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=33)
21:05:48.9280.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=13)
21:05:48.8570.2 msyii\db\Command::querySELECT ST_X('\0\0\0\0\0\0\0�=wE�K@���\Z�B@') as lat, ST_Y('\0\0\0\0\0\0\0�=wE�K@���\Z�B@') as lon
21:05:48.9360.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=25)
21:05:48.9300.2 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=15)
21:05:48.9290.1 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=14)
21:05:48.9330.1 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=18)
21:05:48.9440.1 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=36)
21:05:48.9380.1 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=27)
21:05:48.9520.1 msyii\db\Command::querySELECT * FROM `content_pages` WHERE ((`lft` < 4) AND (`rgt` > 5)) AND (`tree`=91) AND (`status` > 0) ORDER BY `lft`
21:05:48.9340.1 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=23)
21:05:48.9370.1 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=26)
21:05:48.9450.1 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=40)
21:05:48.9340.1 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=19)
21:05:48.9460.1 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=42)
21:05:48.9490.1 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=53)
21:05:48.9420.1 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=31)
21:05:48.9480.1 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=44)
21:05:48.9430.1 msyii\db\Command::querySELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=32)
21:05:48.8630.1 msyii\db\Command::querySELECT ST_AsText('\0\0\0\0\0\0\0�=wE�K@���\Z�B@') as point
21:05:48.8630.1 msyii\db\Command::querySELECT ST_AsText('\0\0\0\0\0\0\0�=wE�K@���\Z�B@') as point