Total processing time: 167 ms; Peak memory: 6.526 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
20:54:57.934 | 2.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_products` |
20:54:57.950 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `q_contact` |
20:54:57.961 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_razdels` |
20:54:58.068 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `content_pages` |
20:54:57.946 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `q_information` |
20:54:58.055 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_discounts` |
20:54:57.931 | 1.6 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=dbshop_91 |
20:54:57.979 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_properties` |
20:54:58.071 | 1.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` = 'content_pages' AND `kcu`.`TABLE_NAME` = 'content_pages' |
20:54:57.975 | 1.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` = 'shop_characteristics' AND `kcu`.`TABLE_NAME` = 'shop_characteristics' |
20:54:58.042 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_related_assignments` |
20:54:57.937 | 1.1 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_products' AND `kcu`.`TABLE_NAME` = 'shop_products' |
20:54:58.043 | 1.1 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_related_assignments' AND `kcu`.`TABLE_NAME` = 'shop_related_assignments' |
20:54:57.973 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_characteristics` |
20:54:57.949 | 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' |
20:54:58.057 | 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' |
20:54:57.970 | 1.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `shop_values` |
20:54:57.981 | 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_properties' AND `kcu`.`TABLE_NAME` = 'shop_properties' |
20:54:57.953 | 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` = 'q_contact' AND `kcu`.`TABLE_NAME` = 'q_contact' |
20:54:58.062 | 0.9 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) |
20:54:57.971 | 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_values' AND `kcu`.`TABLE_NAME` = 'shop_values' |
20:54:58.040 | 0.8 ms | yii\db\Command::query | SELECT MAX(updated_at) FROM `shop_products` WHERE `site_id` = 91 |
20:54:57.964 | 0.8 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' |
20:54:57.945 | 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 |
20:54:57.936 | 0.7 ms | yii\db\Command::query | SHOW CREATE TABLE `shop_products` |
20:54:58.067 | 0.6 ms | yii\db\Command::query | SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) ORDER BY `lft` |
20:54:57.933 | 0.6 ms | yii\db\Command::query | SELECT * FROM `shop_products` `prd` WHERE (`prd`.`site_id` = 91) AND (`prd`.`status` >= 3) AND (`prd`.`id`=64) |
20:54:57.963 | 0.6 ms | yii\db\Command::query | SHOW CREATE TABLE `shop_razdels` |
20:54:58.079 | 0.6 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` |
20:54:58.043 | 0.6 ms | yii\db\Command::query | SHOW CREATE TABLE `shop_related_assignments` |
20:54:57.992 | 0.6 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND ((`depth`=1) OR ((`lft` > 2) AND (`rgt` < 9) AND (`depth`=2)) OR ((`lft` > 1) AND (`rgt` < 60) AND (`depth`=1))) |
20:54:58.029 | 0.5 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE ((`lft` > 38) AND (`rgt` < 45) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft` |
20:54:57.948 | 0.5 ms | yii\db\Command::query | SHOW CREATE TABLE `q_information` |
20:54:57.989 | 0.5 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`status`=0) AND (`rzd`.`site_id`=91) |
20:54:57.986 | 0.5 ms | yii\db\Command::query | SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1) |
20:54:57.969 | 0.5 ms | yii\db\Command::query | SELECT * FROM `shop_values` WHERE `product_id`=64 |
20:54:57.991 | 0.5 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE ((`lft` < 2) AND (`rgt` > 9)) AND (`tree`=91) ORDER BY `lft` |
20:54:58.070 | 0.5 ms | yii\db\Command::query | SHOW CREATE TABLE `content_pages` |
20:54:57.971 | 0.5 ms | yii\db\Command::query | SHOW CREATE TABLE `shop_values` |
20:54:57.960 | 0.5 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE `id`=6 |
20:54:57.953 | 0.4 ms | yii\db\Command::query | SHOW CREATE TABLE `q_contact` |
20:54:57.978 | 0.4 ms | yii\db\Command::query | SELECT * FROM `shop_properties` WHERE `id`=381 |
20:54:58.004 | 0.4 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE ((`lft` > 2) AND (`rgt` < 9) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft` |
20:54:58.039 | 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) |
20:54:58.056 | 0.4 ms | yii\db\Command::query | SHOW CREATE TABLE `shop_discounts` |
20:54:58.031 | 0.4 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=36) |
20:54:58.054 | 0.4 ms | yii\db\Command::query | SELECT * FROM `shop_discounts` WHERE `status` > 2 ORDER BY `sort` |
20:54:58.033 | 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) |
20:54:57.983 | 0.4 ms | yii\db\Command::query | SELECT * FROM `shop_discount_assignment` WHERE (`text_type`=1) AND (`site_id`=91) AND (`parent_id`=6) |
20:54:57.994 | 0.4 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`status` IN (5, 6)) ORDER BY `lft` |
20:54:57.996 | 0.4 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE ((`lft` > 48) AND (`rgt` < 59) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft` |
20:54:57.974 | 0.4 ms | yii\db\Command::query | SHOW CREATE TABLE `shop_characteristics` |
20:54:57.982 | 0.4 ms | yii\db\Command::query | SELECT * FROM `shop_discount_assignment` WHERE (`text_type`=2) AND (`site_id`=91) AND (`parent_id`=64) |
20:54:58.009 | 0.4 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE ((`lft` > 10) AND (`rgt` < 17) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft` |
20:54:57.980 | 0.4 ms | yii\db\Command::query | SHOW CREATE TABLE `shop_properties` |
20:54:58.038 | 0.4 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE ((`lft` > 46) AND (`rgt` < 47) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft` |
20:54:58.081 | 0.4 ms | yii\db\Command::query | SELECT * FROM `content_pages` WHERE ((`lft` < 2) AND (`rgt` > 3)) AND (`tree`=91) AND (`status` > 0) ORDER BY `lft` |
20:54:57.965 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE ((`lft` < 2) AND (`rgt` > 9)) AND (`tree`=91) ORDER BY `lft` |
20:54:58.047 | 0.3 ms | yii\db\Command::query | SELECT * FROM `q_contact` WHERE `site_id`=91 LIMIT 1 |
20:54:58.014 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE ((`lft` > 18) AND (`rgt` < 27) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft` |
20:54:58.027 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE ((`lft` > 3) AND (`rgt` < 4) AND (`depth` <= 3)) AND (`tree`=91) ORDER BY `lft` |
20:54:58.028 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE ((`lft` > 5) AND (`rgt` < 6) AND (`depth` <= 3)) AND (`tree`=91) ORDER BY `lft` |
20:54:57.950 | 0.3 ms | yii\db\Command::query | SELECT * FROM `q_contact` `c` WHERE `site_id`=91 |
20:54:57.977 | 0.3 ms | yii\db\Command::query | SELECT * FROM `content_tag_assignments` `tga` WHERE (`tga`.`text_type`=2) AND (`parent_id`=64) |
20:54:58.019 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=31) |
20:54:57.972 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_characteristics` WHERE `id`=1 |
20:54:58.049 | 0.3 ms | yii\db\Command::query | SELECT * FROM `q_contact` WHERE `site_id`=91 |
20:54:58.036 | 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) |
20:54:58.022 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE ((`lft` > 28) AND (`rgt` < 35) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft` |
20:54:58.053 | 0.3 ms | yii\db\Command::query | SELECT * FROM `q_contact` WHERE `site_id`=91 |
20:54:58.023 | 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) |
20:54:58.016 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=13) |
20:54:58.082 | 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` |
20:54:57.955 | 0.3 ms | yii\db\Command::query | SELECT * FROM `tool_keywords` WHERE ((`site_id`=91) AND (`text_type`=2)) AND (`parent_id`=64) |
20:54:58.045 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_related_assignments` WHERE `product_id`=64 |
20:54:57.977 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_action_assignment` WHERE (`text_type`=2) AND (`site_id`=91) AND (`parent_id`=64) |
20:54:58.020 | 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) |
20:54:58.005 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=6) |
20:54:58.037 | 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) |
20:54:58.003 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=33) |
20:54:58.010 | 0.3 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=12) |
20:54:58.012 | 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) |
20:54:58.006 | 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) |
20:54:57.976 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_brands` WHERE 0=1 |
20:54:58.013 | 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) |
20:54:58.017 | 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) |
20:54:58.029 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE ((`lft` > 7) AND (`rgt` < 8) AND (`depth` <= 3)) AND (`tree`=91) ORDER BY `lft` |
20:54:58.051 | 0.2 ms | yii\db\Command::query | SELECT ST_AsText('\0\0\0\0\0\0\0�=wE�K@���\Z�B@') as point |
20:54:58.021 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` WHERE ((`lft` > 36) AND (`rgt` < 37) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft` |
20:54:58.002 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=32) |
20:54:58.007 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=24) |
20:54:58.083 | 0.2 ms | yii\db\Command::query | SELECT * FROM `content_pages` WHERE ((`lft` < 4) AND (`rgt` > 5)) AND (`tree`=91) AND (`status` > 0) ORDER BY `lft` |
20:54:57.998 | 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) |
20:54:58.025 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=17) |
20:54:58.008 | 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) |
20:54:57.985 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1) |
20:54:57.997 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=3) |
20:54:58.014 | 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) |
20:54:57.999 | 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) |
20:54:57.985 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)) |
20:54:58.018 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=30) |
20:54:57.982 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1) |
20:54:58.021 | 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) |
20:54:57.984 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1) |
20:54:58.001 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=4) |
20:54:58.026 | 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) |
20:54:57.984 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_action_assignment` WHERE (`text_type`=1) AND (`site_id`=91) AND (`parent_id`=6) |
20:54:58.050 | 0.2 ms | yii\db\Command::query | SELECT ST_AsText('\0\0\0\0\0\0\0�=wE�K@���\Z�B@') as point |
20:54:57.983 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1) |
20:54:57.978 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)) |
20:54:57.986 | 0.2 ms | yii\db\Command::query | SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1) |
20:54:58.027 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=19) |
20:54:57.985 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1) |
20:54:57.977 | 0.1 ms | yii\db\Command::query | SELECT * FROM `content_tags` WHERE 0=1 |
20:54:57.987 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1) |
20:54:57.983 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1) |
20:54:57.984 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1) |
20:54:57.986 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1) |
20:54:57.984 | 0.1 ms | yii\db\Command::query | SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1) |