Database

20 duplicated queries found.

Database Queries

Всего 118 записей.
TimeDurationTypeDuplicatedQuery
   
20:54:57.9330.6 msSELECT1
SELECT * FROM `shop_products` `prd` WHERE (`prd`.`site_id` = 91) AND (`prd`.`status` >= 3) AND (`prd`.`id`=64)

20:54:57.9342.5 msSHOW1
SHOW FULL COLUMNS FROM `shop_products`
20:54:57.9360.7 msSHOW1
SHOW CREATE TABLE `shop_products`
20:54:57.9371.1 msSELECT1
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:57.9450.7 msSELECT1
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.9461.7 msSHOW1
SHOW FULL COLUMNS FROM `q_information`
20:54:57.9480.5 msSHOW1
SHOW CREATE TABLE `q_information`
20:54:57.9491.0 msSELECT1
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:57.9500.3 msSELECT1
SELECT * FROM `q_contact` `c` WHERE `site_id`=91

20:54:57.9502.2 msSHOW1
SHOW FULL COLUMNS FROM `q_contact`
20:54:57.9530.4 msSHOW1
SHOW CREATE TABLE `q_contact`
20:54:57.9530.9 msSELECT1
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:57.9550.3 msSELECT1
SELECT * FROM `tool_keywords` WHERE ((`site_id`=91) AND (`text_type`=2)) AND (`parent_id`=64)

20:54:57.9600.5 msSELECT1
SELECT * FROM `shop_razdels` WHERE `id`=6

20:54:57.9611.9 msSHOW1
SHOW FULL COLUMNS FROM `shop_razdels`
20:54:57.9630.6 msSHOW1
SHOW CREATE TABLE `shop_razdels`
20:54:57.9640.8 msSELECT1
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.9650.3 msSELECT2
SELECT * FROM `shop_razdels` WHERE ((`lft` < 2) AND (`rgt` > 9)) AND (`tree`=91) ORDER BY `lft`

20:54:57.9690.5 msSELECT1
SELECT * FROM `shop_values` WHERE `product_id`=64

20:54:57.9701.0 msSHOW1
SHOW FULL COLUMNS FROM `shop_values`
20:54:57.9710.5 msSHOW1
SHOW CREATE TABLE `shop_values`
20:54:57.9710.9 msSELECT1
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:57.9720.3 msSELECT1
SELECT * FROM `shop_characteristics` WHERE `id`=1

20:54:57.9731.1 msSHOW1
SHOW FULL COLUMNS FROM `shop_characteristics`
20:54:57.9740.4 msSHOW1
SHOW CREATE TABLE `shop_characteristics`
20:54:57.9751.3 msSELECT1
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:57.9760.2 msSELECT1
SELECT * FROM `shop_brands` WHERE 0=1

20:54:57.9770.3 msSELECT1
SELECT * FROM `content_tag_assignments` `tga` WHERE (`tga`.`text_type`=2) AND (`parent_id`=64)

20:54:57.9770.1 msSELECT1
SELECT * FROM `content_tags` WHERE 0=1

20:54:57.9770.3 msSELECT1
SELECT * FROM `shop_action_assignment` WHERE (`text_type`=2) AND (`site_id`=91) AND (`parent_id`=64)

20:54:57.9780.2 msSELECT2
SELECT EXISTS(SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1))

20:54:57.9780.4 msSELECT1
SELECT * FROM `shop_properties` WHERE `id`=381

20:54:57.9791.4 msSHOW1
SHOW FULL COLUMNS FROM `shop_properties`
20:54:57.9800.4 msSHOW1
SHOW CREATE TABLE `shop_properties`
20:54:57.9811.0 msSELECT1
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.9820.4 msSELECT1
SELECT * FROM `shop_discount_assignment` WHERE (`text_type`=2) AND (`site_id`=91) AND (`parent_id`=64)

20:54:57.9820.2 msSELECT6
SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

20:54:57.9830.4 msSELECT1
SELECT * FROM `shop_discount_assignment` WHERE (`text_type`=1) AND (`site_id`=91) AND (`parent_id`=6)

20:54:57.9830.2 msSELECT6
SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

20:54:57.9830.1 msSELECT6
SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

20:54:57.9840.2 msSELECT1
SELECT * FROM `shop_action_assignment` WHERE (`text_type`=1) AND (`site_id`=91) AND (`parent_id`=6)

20:54:57.9840.1 msSELECT6
SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

20:54:57.9840.2 msSELECT6
SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

20:54:57.9840.1 msSELECT6
SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

20:54:57.9850.2 msSELECT6
SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

20:54:57.9850.1 msSELECT6
SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

20:54:57.9850.2 msSELECT2
SELECT EXISTS(SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1))

20:54:57.9860.5 msSELECT6
SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

20:54:57.9860.2 msSELECT6
SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

20:54:57.9860.1 msSELECT6
SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

20:54:57.9870.1 msSELECT6
SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

20:54:57.9890.5 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`status`=0) AND (`rzd`.`site_id`=91)

20:54:57.9910.5 msSELECT2
SELECT * FROM `shop_razdels` WHERE ((`lft` < 2) AND (`rgt` > 9)) AND (`tree`=91) ORDER BY `lft`

20:54:57.9920.6 msSELECT1
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:57.9940.4 msSELECT1
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.9960.4 msSELECT1
SELECT * FROM `shop_razdels` WHERE ((`lft` > 48) AND (`rgt` < 59) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:57.9970.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=3)

20:54:57.9980.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=14)

20:54:57.9990.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=11)

20:54:58.0010.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=4)

20:54:58.0020.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=32)

20:54:58.0030.3 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=33)

20:54:58.0040.4 msSELECT1
SELECT * FROM `shop_razdels` WHERE ((`lft` > 2) AND (`rgt` < 9) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0050.3 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=6)

20:54:58.0060.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=23)

20:54:58.0070.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=24)

20:54:58.0080.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=25)

20:54:58.0090.4 msSELECT1
SELECT * FROM `shop_razdels` WHERE ((`lft` > 10) AND (`rgt` < 17) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0100.3 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=12)

20:54:58.0120.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=26)

20:54:58.0130.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=27)

20:54:58.0140.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=28)

20:54:58.0140.3 msSELECT1
SELECT * FROM `shop_razdels` WHERE ((`lft` > 18) AND (`rgt` < 27) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0160.3 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=13)

20:54:58.0170.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=29)

20:54:58.0180.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=30)

20:54:58.0190.3 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=31)

20:54:58.0200.3 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=53)

20:54:58.0210.2 msSELECT1
SELECT * FROM `shop_razdels` WHERE ((`lft` > 36) AND (`rgt` < 37) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0210.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=15)

20:54:58.0220.3 msSELECT1
SELECT * FROM `shop_razdels` WHERE ((`lft` > 28) AND (`rgt` < 35) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0230.3 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=16)

20:54:58.0250.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=17)

20:54:58.0260.2 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=18)

20:54:58.0270.1 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=19)

20:54:58.0270.3 msSELECT1
SELECT * FROM `shop_razdels` WHERE ((`lft` > 3) AND (`rgt` < 4) AND (`depth` <= 3)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0280.3 msSELECT1
SELECT * FROM `shop_razdels` WHERE ((`lft` > 5) AND (`rgt` < 6) AND (`depth` <= 3)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0290.2 msSELECT1
SELECT * FROM `shop_razdels` WHERE ((`lft` > 7) AND (`rgt` < 8) AND (`depth` <= 3)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0290.5 msSELECT1
SELECT * FROM `shop_razdels` WHERE ((`lft` > 38) AND (`rgt` < 45) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0310.4 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=36)

20:54:58.0330.4 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=40)

20:54:58.0360.3 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=42)

20:54:58.0370.3 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=43)

20:54:58.0380.4 msSELECT1
SELECT * FROM `shop_razdels` WHERE ((`lft` > 46) AND (`rgt` < 47) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0390.4 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=44)

20:54:58.0400.8 msSELECT1
SELECT MAX(updated_at) FROM `shop_products` WHERE `site_id` = 91

20:54:58.0421.2 msSHOW1
SHOW FULL COLUMNS FROM `shop_related_assignments`
20:54:58.0430.6 msSHOW1
SHOW CREATE TABLE `shop_related_assignments`
20:54:58.0431.1 msSELECT1
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:58.0450.3 msSELECT1
SELECT * FROM `shop_related_assignments` WHERE `product_id`=64

20:54:58.0470.3 msSELECT1
SELECT * FROM `q_contact` WHERE `site_id`=91 LIMIT 1

20:54:58.0490.3 msSELECT2
SELECT * FROM `q_contact` WHERE `site_id`=91

20:54:58.0500.2 msSELECT2
SELECT ST_AsText('\0\0\0\0\0\0\0�=wE�K@���\Z�B@') as point

20:54:58.0510.2 msSELECT2
SELECT ST_AsText('\0\0\0\0\0\0\0�=wE�K@���\Z�B@') as point

20:54:58.0530.3 msSELECT2
SELECT * FROM `q_contact` WHERE `site_id`=91

20:54:58.0540.4 msSELECT1
SELECT * FROM `shop_discounts` WHERE `status` > 2 ORDER BY `sort`

20:54:58.0551.6 msSHOW1
SHOW FULL COLUMNS FROM `shop_discounts`
20:54:58.0560.4 msSHOW1
SHOW CREATE TABLE `shop_discounts`
20:54:58.0571.0 msSELECT1
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:58.0620.9 msSELECT1
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3)

20:54:58.0670.6 msSELECT1
SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) ORDER BY `lft`

20:54:58.0681.8 msSHOW1
SHOW FULL COLUMNS FROM `content_pages`
20:54:58.0700.5 msSHOW1
SHOW CREATE TABLE `content_pages`
20:54:58.0711.3 msSELECT1
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:58.0790.6 msSELECT1
SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) AND (`pag`.`id`=4) ORDER BY `lft`

20:54:58.0810.4 msSELECT1
SELECT * FROM `content_pages` WHERE ((`lft` < 2) AND (`rgt` > 3)) AND (`tree`=91) AND (`status` > 0) ORDER BY `lft`

20:54:58.0820.3 msSELECT1
SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) AND (`pag`.`id`=10) ORDER BY `lft`

20:54:58.0830.2 msSELECT1
SELECT * FROM `content_pages` WHERE ((`lft` < 4) AND (`rgt` > 5)) AND (`tree`=91) AND (`status` > 0) ORDER BY `lft`

Database Callers

Всего 34 записи.
CallerNo. of CallsTotal DurationQueries
297.2 ms
Time Duration Queries
20:54:57.9970.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=3)

20:54:57.9980.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=14)

20:54:57.9990.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=11)

20:54:58.0010.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=4)

20:54:58.0020.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=32)

20:54:58.0030.3 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=33)

20:54:58.0050.3 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=6)

20:54:58.0060.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=23)

20:54:58.0070.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=24)

20:54:58.0080.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=25)

20:54:58.0100.3 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=12)

20:54:58.0120.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=26)

20:54:58.0130.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=27)

20:54:58.0140.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=28)

20:54:58.0160.3 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=13)

20:54:58.0170.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=29)

20:54:58.0180.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=30)

20:54:58.0190.3 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=31)

20:54:58.0200.3 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=53)

20:54:58.0210.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=15)

20:54:58.0230.3 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=16)

20:54:58.0250.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=17)

20:54:58.0260.2 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=18)

20:54:58.0270.1 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=19)

20:54:58.0310.4 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=36)

20:54:58.0330.4 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=40)

20:54:58.0360.3 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=42)

20:54:58.0370.3 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=43)

20:54:58.0390.4 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=44)

113.7 ms
Time Duration Queries
20:54:57.9960.4 ms
SELECT * FROM `shop_razdels` WHERE ((`lft` > 48) AND (`rgt` < 59) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0040.4 ms
SELECT * FROM `shop_razdels` WHERE ((`lft` > 2) AND (`rgt` < 9) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0090.4 ms
SELECT * FROM `shop_razdels` WHERE ((`lft` > 10) AND (`rgt` < 17) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0140.3 ms
SELECT * FROM `shop_razdels` WHERE ((`lft` > 18) AND (`rgt` < 27) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0210.2 ms
SELECT * FROM `shop_razdels` WHERE ((`lft` > 36) AND (`rgt` < 37) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0220.3 ms
SELECT * FROM `shop_razdels` WHERE ((`lft` > 28) AND (`rgt` < 35) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0270.3 ms
SELECT * FROM `shop_razdels` WHERE ((`lft` > 3) AND (`rgt` < 4) AND (`depth` <= 3)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0280.3 ms
SELECT * FROM `shop_razdels` WHERE ((`lft` > 5) AND (`rgt` < 6) AND (`depth` <= 3)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0290.2 ms
SELECT * FROM `shop_razdels` WHERE ((`lft` > 7) AND (`rgt` < 8) AND (`depth` <= 3)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0290.5 ms
SELECT * FROM `shop_razdels` WHERE ((`lft` > 38) AND (`rgt` < 45) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

20:54:58.0380.4 ms
SELECT * FROM `shop_razdels` WHERE ((`lft` > 46) AND (`rgt` < 47) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

87.8 ms
Time Duration Queries
20:54:57.9450.7 ms
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.9461.7 ms
SHOW FULL COLUMNS FROM `q_information`
20:54:57.9480.5 ms
SHOW CREATE TABLE `q_information`
20:54:57.9491.0 ms
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:57.9500.3 ms
SELECT * FROM `q_contact` `c` WHERE `site_id`=91

20:54:57.9502.2 ms
SHOW FULL COLUMNS FROM `q_contact`
20:54:57.9530.4 ms
SHOW CREATE TABLE `q_contact`
20:54:57.9530.9 ms
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'

44.9 ms
Time Duration Queries
20:54:57.9330.6 ms
SELECT * FROM `shop_products` `prd` WHERE (`prd`.`site_id` = 91) AND (`prd`.`status` >= 3) AND (`prd`.`id`=64)

20:54:57.9342.5 ms
SHOW FULL COLUMNS FROM `shop_products`
20:54:57.9360.7 ms
SHOW CREATE TABLE `shop_products`
20:54:57.9371.1 ms
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'

43.8 ms
Time Duration Queries
20:54:57.9600.5 ms
SELECT * FROM `shop_razdels` WHERE `id`=6

20:54:57.9611.9 ms
SHOW FULL COLUMNS FROM `shop_razdels`
20:54:57.9630.6 ms
SHOW CREATE TABLE `shop_razdels`
20:54:57.9640.8 ms
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'

42.8 ms
Time Duration Queries
20:54:57.9690.5 ms
SELECT * FROM `shop_values` WHERE `product_id`=64

20:54:57.9701.0 ms
SHOW FULL COLUMNS FROM `shop_values`
20:54:57.9710.5 ms
SHOW CREATE TABLE `shop_values`
20:54:57.9710.9 ms
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'

43.0 ms
Time Duration Queries
20:54:57.9720.3 ms
SELECT * FROM `shop_characteristics` WHERE `id`=1

20:54:57.9731.1 ms
SHOW FULL COLUMNS FROM `shop_characteristics`
20:54:57.9740.4 ms
SHOW CREATE TABLE `shop_characteristics`
20:54:57.9751.3 ms
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'

43.1 ms
Time Duration Queries
20:54:57.9780.4 ms
SELECT * FROM `shop_properties` WHERE `id`=381

20:54:57.9791.4 ms
SHOW FULL COLUMNS FROM `shop_properties`
20:54:57.9800.4 ms
SHOW CREATE TABLE `shop_properties`
20:54:57.9811.0 ms
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'

41.2 ms
Time Duration Queries
20:54:57.9820.4 ms
SELECT * FROM `shop_discount_assignment` WHERE (`text_type`=2) AND (`site_id`=91) AND (`parent_id`=64)

20:54:57.9820.2 ms
SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

20:54:57.9840.2 ms
SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

20:54:57.9860.5 ms
SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

40.8 ms
Time Duration Queries
20:54:57.9830.4 ms
SELECT * FROM `shop_discount_assignment` WHERE (`text_type`=1) AND (`site_id`=91) AND (`parent_id`=6)

20:54:57.9830.2 ms
SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

20:54:57.9840.1 ms
SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

20:54:57.9860.2 ms
SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

40.5 ms
Time Duration Queries
20:54:57.9840.2 ms
SELECT * FROM `shop_action_assignment` WHERE (`text_type`=1) AND (`site_id`=91) AND (`parent_id`=6)

20:54:57.9840.1 ms
SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

20:54:57.9850.1 ms
SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

20:54:57.9870.1 ms
SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

43.1 ms
Time Duration Queries
20:54:58.0421.2 ms
SHOW FULL COLUMNS FROM `shop_related_assignments`
20:54:58.0430.6 ms
SHOW CREATE TABLE `shop_related_assignments`
20:54:58.0431.1 ms
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:58.0450.3 ms
SELECT * FROM `shop_related_assignments` WHERE `product_id`=64

43.4 ms
Time Duration Queries
20:54:58.0540.4 ms
SELECT * FROM `shop_discounts` WHERE `status` > 2 ORDER BY `sort`

20:54:58.0551.6 ms
SHOW FULL COLUMNS FROM `shop_discounts`
20:54:58.0560.4 ms
SHOW CREATE TABLE `shop_discounts`
20:54:58.0571.0 ms
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'

44.2 ms
Time Duration Queries
20:54:58.0670.6 ms
SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) ORDER BY `lft`

20:54:58.0681.8 ms
SHOW FULL COLUMNS FROM `content_pages`
20:54:58.0700.5 ms
SHOW CREATE TABLE `content_pages`
20:54:58.0711.3 ms
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'

30.4 ms
Time Duration Queries
20:54:57.9830.1 ms
SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

20:54:57.9850.2 ms
SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

20:54:57.9860.1 ms
SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

20.4 ms
Time Duration Queries
20:54:57.9770.3 ms
SELECT * FROM `content_tag_assignments` `tga` WHERE (`tga`.`text_type`=2) AND (`parent_id`=64)

20:54:57.9770.1 ms
SELECT * FROM `content_tags` WHERE 0=1

20.4 ms
Time Duration Queries
20:54:57.9770.3 ms
SELECT * FROM `shop_action_assignment` WHERE (`text_type`=2) AND (`site_id`=91) AND (`parent_id`=64)

20:54:57.9780.2 ms
SELECT EXISTS(SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1))

20.8 ms
Time Duration Queries
20:54:58.0790.6 ms
SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) AND (`pag`.`id`=4) ORDER BY `lft`

20:54:58.0820.3 ms
SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) AND (`pag`.`id`=10) ORDER BY `lft`

20.6 ms
Time Duration Queries
20:54:58.0810.4 ms
SELECT * FROM `content_pages` WHERE ((`lft` < 2) AND (`rgt` > 3)) AND (`tree`=91) AND (`status` > 0) ORDER BY `lft`

20:54:58.0830.2 ms
SELECT * FROM `content_pages` WHERE ((`lft` < 4) AND (`rgt` > 5)) AND (`tree`=91) AND (`status` > 0) ORDER BY `lft`

10.3 ms
Time Duration Queries
20:54:57.9550.3 ms
SELECT * FROM `tool_keywords` WHERE ((`site_id`=91) AND (`text_type`=2)) AND (`parent_id`=64)

10.3 ms
Time Duration Queries
20:54:57.9650.3 ms
SELECT * FROM `shop_razdels` WHERE ((`lft` < 2) AND (`rgt` > 9)) AND (`tree`=91) ORDER BY `lft`

10.2 ms
Time Duration Queries
20:54:57.9760.2 ms
SELECT * FROM `shop_brands` WHERE 0=1

10.2 ms
Time Duration Queries
20:54:57.9850.2 ms
SELECT EXISTS(SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1))

10.5 ms
Time Duration Queries
20:54:57.9890.5 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`status`=0) AND (`rzd`.`site_id`=91)

10.5 ms
Time Duration Queries
20:54:57.9910.5 ms
SELECT * FROM `shop_razdels` WHERE ((`lft` < 2) AND (`rgt` > 9)) AND (`tree`=91) ORDER BY `lft`

10.6 ms
Time Duration Queries
20:54:57.9920.6 ms
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)))

10.4 ms
Time Duration Queries
20:54:57.9940.4 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`status` IN (5, 6)) ORDER BY `lft`

10.8 ms
Time Duration Queries
20:54:58.0400.8 ms
SELECT MAX(updated_at) FROM `shop_products` WHERE `site_id` = 91

10.3 ms
Time Duration Queries
20:54:58.0470.3 ms
SELECT * FROM `q_contact` WHERE `site_id`=91 LIMIT 1

10.3 ms
Time Duration Queries
20:54:58.0490.3 ms
SELECT * FROM `q_contact` WHERE `site_id`=91

10.2 ms
Time Duration Queries
20:54:58.0500.2 ms
SELECT ST_AsText('\0\0\0\0\0\0\0�=wE�K@���\Z�B@') as point

10.2 ms
Time Duration Queries
20:54:58.0510.2 ms
SELECT ST_AsText('\0\0\0\0\0\0\0�=wE�K@���\Z�B@') as point

10.3 ms
Time Duration Queries
20:54:58.0530.3 ms
SELECT * FROM `q_contact` WHERE `site_id`=91

10.9 ms
Time Duration Queries
20:54:58.0620.9 ms
SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3)