Database

SELECT * FROM `shop_products` `prd` WHERE (`prd`.`site_id` = 91) AND (`prd`.`status` >= 3) AND (`prd`.`id`=192)

SHOW FULL COLUMNS FROM `shop_products`

SHOW CREATE TABLE `shop_products`

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'

SELECT `sit`.* FROM `q_information` `sit` LEFT JOIN `q_contact` `c` ON `sit`.`id` = `c`.`site_id` WHERE `sit`.`id`=91 LIMIT 1

SHOW FULL COLUMNS FROM `q_information`

SHOW CREATE TABLE `q_information`

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'

SELECT * FROM `q_contact` `c` WHERE `site_id`=91

SHOW FULL COLUMNS FROM `q_contact`

SHOW CREATE TABLE `q_contact`

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'

SELECT * FROM `tool_keywords` WHERE ((`site_id`=91) AND (`text_type`=2)) AND (`parent_id`=192)

SELECT * FROM `shop_razdels` WHERE `id`=6

SHOW FULL COLUMNS FROM `shop_razdels`

SHOW CREATE TABLE `shop_razdels`

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'

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

SELECT * FROM `shop_values` WHERE `product_id`=192

SELECT * FROM `shop_brands` WHERE `id`=1

SHOW FULL COLUMNS FROM `shop_brands`

SHOW CREATE TABLE `shop_brands`

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_brands' AND `kcu`.`TABLE_NAME` = 'shop_brands'

SELECT * FROM `content_tag_assignments` `tga` WHERE (`tga`.`text_type`=2) AND (`parent_id`=192)

SELECT * FROM `content_tags` WHERE 0=1

SELECT * FROM `shop_action_assignment` WHERE (`text_type`=2) AND (`site_id`=91) AND (`parent_id`=192)

SELECT EXISTS(SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1))

SELECT * FROM `shop_properties` WHERE `id`=490

SHOW FULL COLUMNS FROM `shop_properties`

SHOW CREATE TABLE `shop_properties`

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'

SELECT * FROM `shop_discount_assignment` WHERE (`text_type`=2) AND (`site_id`=91) AND (`parent_id`=192)

SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

SELECT * FROM `shop_discount_assignment` WHERE (`text_type`=1) AND (`site_id`=91) AND (`parent_id`=6)

SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

SELECT * FROM `shop_action_assignment` WHERE (`text_type`=1) AND (`site_id`=91) AND (`parent_id`=6)

SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

SELECT EXISTS(SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1))

SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

SELECT * FROM `shop_discounts` WHERE (`status` > 2) AND (0=1)

SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

SELECT * FROM `shop_actions` WHERE (`status` > 2) AND (0=1)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`status`=0) AND (`rzd`.`site_id`=91)

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

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)))

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`status` IN (5, 6)) ORDER BY `lft`

SELECT * FROM `shop_razdels` WHERE ((`lft` > 48) AND (`rgt` < 59) AND (`depth` <= 2)) AND (`tree`=91) ORDER BY `lft`

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=3)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=14)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=11)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=4)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=32)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=33)

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

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=6)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=23)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=24)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=25)

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

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=12)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=26)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=27)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=28)

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

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=13)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=29)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=30)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=31)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=53)

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

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=15)

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

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=16)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=17)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=18)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=19)

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

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

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

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

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=36)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=40)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=42)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=43)

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

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=44)

SELECT MAX(updated_at) FROM `shop_products` WHERE `site_id` = 91

SHOW FULL COLUMNS FROM `shop_related_assignments`

SHOW CREATE TABLE `shop_related_assignments`

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'

SELECT * FROM `shop_related_assignments` WHERE `product_id`=192

SELECT * FROM `q_contact` WHERE `site_id`=91 LIMIT 1

SELECT * FROM `q_contact` WHERE `site_id`=91

SELECT ST_AsText('\0\0\0\0

\0\0\0�=wE�K@���\Z�B@') as point

SELECT ST_AsText('\0\0\0\0

\0\0\0�=wE�K@���\Z�B@') as point

SELECT * FROM `q_contact` WHERE `site_id`=91

SELECT * FROM `shop_discounts` WHERE `status` > 2 ORDER BY `sort`

SHOW FULL COLUMNS FROM `shop_discounts`

SHOW CREATE TABLE `shop_discounts`

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'

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3)

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

SHOW FULL COLUMNS FROM `content_pages`

SHOW CREATE TABLE `content_pages`

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'

SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) AND (`pag`.`id`=4) ORDER BY `lft`

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

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

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