Database Queries

SELECT * FROM `lang` WHERE url = 'product'

SELECT * FROM `lang` WHERE `default` = 1

SHOW FULL COLUMNS FROM `lang`

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

SELECT * FROM `products` WHERE (`slug`='cehol-spigen-tough-armor-asd01989-dla-airpods-3-gunmetal-1197562') AND (`is_want_to_be_active`=1)

SHOW FULL COLUMNS FROM `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` = 'products' AND `kcu`.`TABLE_NAME` = 'products'

SELECT `discount_id` FROM `products_discounts` WHERE `product_id`=474

SELECT * FROM `discounts` WHERE (0=1) AND (started_at IS NULL OR started_at <= NOW()) AND (finished_at IS NULL OR finished_at >= NOW())

SELECT * FROM `products_variants` WHERE (`product_id`=474) AND (`is_filled_options`=1)

SHOW FULL COLUMNS FROM `products_variants`

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

SELECT * FROM `products_variants_value` WHERE `products_variants_id`=433 ORDER BY `products_variants_id`, `products_options_id`

SELECT * FROM `prices` WHERE `auth_item_name`=''

SHOW FULL COLUMNS FROM `prices`

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

SELECT MIN(value) FROM `products_variant_prices` WHERE (`price_id`=2) AND (`variant_id`=433)

SELECT * FROM `currencies` WHERE `is_default`=1

SHOW FULL COLUMNS FROM `currencies`

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

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `products` WHERE `id`=474

SELECT `discount_id` FROM `products_discounts` WHERE `product_id`=474

SELECT * FROM `discounts` WHERE (0=1) AND (started_at IS NULL OR started_at <= NOW()) AND (finished_at IS NULL OR finished_at >= NOW())

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `currencies` WHERE `is_default`=1

(SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `translate_source_message` `t1`, `translate_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='shop') AND (`t2`.`language`='ru-RU')) UNION ALL ( SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `translate_source_message` `t1`, `translate_message` `t2` WHERE ((`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='shop') AND (`t2`.`language`='ru')) AND (`t2`.`id` NOT IN (SELECT `id` FROM `translate_message` WHERE `language`='ru-RU')) )

SELECT * FROM `categories` ORDER BY `parent_id`

SHOW FULL COLUMNS FROM `categories`

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

SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='seo_title')

SELECT * FROM `product_langs` WHERE `product_id`=474

SHOW FULL COLUMNS FROM `product_langs`

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

SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='seo_description')

SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='seo_keywords')

SELECT * FROM `countries` WHERE (`id` IS NULL) AND (`exists_tax`=1)

SELECT `file_storage`.* FROM `file_storage` INNER JOIN `products_filestorage` ON products_filestorage.id_file = file_storage.id WHERE `products_filestorage`.`id_product`=474 ORDER BY `products_filestorage`.`id`

SHOW FULL COLUMNS FROM `file_storage`

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

SELECT * FROM `products_variants` WHERE `product_id`=474

SELECT MAX(amount_in_storage) FROM `products_variants` WHERE `product_id`=474

SELECT * FROM `products_variant_filestorage` WHERE `variant_id`=433

SELECT * FROM `file_storage` WHERE 0=1

SELECT * FROM `products_variants` WHERE `product_id`=474

SELECT * FROM `products_variant_filestorage` WHERE `variant_id`=433

SELECT * FROM `file_storage` WHERE 0=1

SELECT * FROM `products_variants` WHERE `product_id`=474

SELECT * FROM `products_variant_filestorage` WHERE `variant_id`=433

SELECT * FROM `file_storage` WHERE 0=1

SELECT * FROM `currencies` WHERE `is_default`=1

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

SHOW FULL COLUMNS FROM `units`

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

SELECT * FROM `unit_langs` WHERE `unit_id`=1

SHOW FULL COLUMNS FROM `unit_langs`

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

SELECT * FROM `reviews` WHERE `product_id`=474

SELECT * FROM `features_products` WHERE `product_id`=474

SELECT * FROM `products_discounts` WHERE `product_id`=474

SELECT * FROM `discounts` WHERE 0=1

SELECT * FROM `products_variants` WHERE `product_id`=474

SELECT * FROM `prices` WHERE `auth_item_name`=''

SELECT MIN(value) FROM `products_variant_prices` WHERE (`price_id`=2) AND (`variant_id`=433)

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

(SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `translate_source_message` `t1`, `translate_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='app') AND (`t2`.`language`='ru-RU')) UNION ALL ( SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `translate_source_message` `t1`, `translate_message` `t2` WHERE ((`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='app') AND (`t2`.`language`='ru')) AND (`t2`.`id` NOT IN (SELECT `id` FROM `translate_message` WHERE `language`='ru-RU')) )

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `categories` WHERE `id`=27

SELECT * FROM `category_langs` WHERE `category_id`=27

SHOW FULL COLUMNS FROM `category_langs`

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

SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE `entityModel`='webdoka\\yiiecommerce\\common\\models\\Product' ORDER BY `order`

SHOW FULL COLUMNS FROM `eav_attribute`

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

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

SHOW FULL COLUMNS FROM `eav_entity`

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

SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c67')

SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE (`entityModel`='webdoka\\yiiecommerce\\common\\models\\Product') AND (`name`='c67') ORDER BY `order`

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

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

SHOW FULL COLUMNS FROM `eav_attribute_type`

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

SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=67

SHOW FULL COLUMNS FROM `eav_attribute_rules`

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

SHOW FULL COLUMNS FROM `eav_attribute_value`

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

SELECT * FROM `eav_attribute_value` WHERE (`entityId`=474) AND (`attributeId`=67)

SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c67')

SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE (`entityModel`='webdoka\\yiiecommerce\\common\\models\\Product') AND (`name`='c67') ORDER BY `order`

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

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

SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=67

SELECT * FROM `eav_attribute_value` WHERE (`entityId`=474) AND (`attributeId`=67)

SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c68')

SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE (`entityModel`='webdoka\\yiiecommerce\\common\\models\\Product') AND (`name`='c68') ORDER BY `order`

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

SELECT * FROM `eav_attribute_type` WHERE `id`=7

SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=68

SELECT * FROM `eav_attribute_value` WHERE (`entityId`=474) AND (`attributeId`=68)

SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c68')

SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE (`entityModel`='webdoka\\yiiecommerce\\common\\models\\Product') AND (`name`='c68') ORDER BY `order`

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

SELECT * FROM `eav_attribute_type` WHERE `id`=7

SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=68

SELECT * FROM `eav_attribute_value` WHERE (`entityId`=474) AND (`attributeId`=68)

SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c69')

SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE (`entityModel`='webdoka\\yiiecommerce\\common\\models\\Product') AND (`name`='c69') ORDER BY `order`

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

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

SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=69

SELECT * FROM `eav_attribute_value` WHERE (`entityId`=474) AND (`attributeId`=69)

SELECT EXISTS(SELECT * FROM `eav_attribute` WHERE `name`='c69')

SELECT `eav_attribute`.* FROM `eav_attribute` LEFT JOIN `eav_entity` ON `eav_attribute`.`entityId` = `eav_entity`.`id` WHERE (`entityModel`='webdoka\\yiiecommerce\\common\\models\\Product') AND (`name`='c69') ORDER BY `order`

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

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

SELECT * FROM `eav_attribute_rules` WHERE `attributeId`=69

SELECT * FROM `eav_attribute_value` WHERE (`entityId`=474) AND (`attributeId`=69)

SELECT COUNT(*) FROM `reviews` WHERE (`deleted`='0') AND (`status`='1') AND (`deleted`='0') AND (`product_id`=474)

SHOW FULL COLUMNS FROM `reviews`

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

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `company_contacts`

SHOW FULL COLUMNS FROM `company_contacts`

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

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE id != 2

SELECT * FROM `currencies` WHERE `exchange_rate` IS NOT NULL

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `file_storage` WHERE `id`='2b752f3d7aab4c4f71ecc6d4226fc3e7-1653937858.8962'

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `menus` WHERE `code`='top_menu'

SHOW FULL COLUMNS FROM `menus`

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

SELECT * FROM `menu_items` WHERE `menu_id`=3

SHOW FULL COLUMNS FROM `menu_items`

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

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=6

SHOW FULL COLUMNS FROM `menu_item_langs`

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

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=7

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=8

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `top_banners` WHERE `status`=1 ORDER BY `sort` DESC

SHOW FULL COLUMNS FROM `top_banners`

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

SELECT * FROM `file_storage` WHERE `id`='c36a3007d51e8c79288c37fa3c53cc3b-1653651632.9782'

SELECT * FROM `file_storage` WHERE `id`='f05b3ccb0ea7fbbb14c4c073da54b67d-1654001571.0239'

SELECT * FROM `top_banner_langs` WHERE `top_banner_id`=8

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `manufacturer`

SHOW FULL COLUMNS FROM `manufacturer`

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

SELECT * FROM `file_storage` WHERE `id`='ab3f1d647cc645522e1a4eb12bb61598-1592550824.8948'

SELECT * FROM `file_storage` WHERE `id`='a416fbbcd135d6ecb55c2efd9ab2dcbb-1592550872.4732'

SELECT * FROM `file_storage` WHERE `id`='6c0b4eaeee5fbd396a094f33bf16cf29-1592550908.5516'

SELECT * FROM `file_storage` WHERE `id`='92f8835bb6d8aab017ebb17d434d428d-1592552095.2681'

SELECT * FROM `file_storage` WHERE `id`='0683a4e96e9b8ffb110cd7f69ad2a3c3-1592552167.2648'

SELECT * FROM `file_storage` WHERE `id`=''

SELECT * FROM `file_storage` WHERE `id`='99b0ab22b9506c6c4d17da1950649d6a-1586594818.2509'

SELECT * FROM `file_storage` WHERE `id`='1372586e304cb328af8ef43ccb54b6a5-1586594789.657'

SELECT * FROM `file_storage` WHERE `id`='60de62ed877be54e300168ed8e2aea64-1603624974.6457'

SELECT * FROM `company_contacts`

SELECT * FROM `company_contacts_langs` WHERE `company_contact_id`=1

SHOW FULL COLUMNS FROM `company_contacts_langs`

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

SELECT * FROM `company_contacts_social_networks`

SHOW FULL COLUMNS FROM `company_contacts_social_networks`

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

SELECT * FROM `file_storage` WHERE `id`='2b752f3d7aab4c4f71ecc6d4226fc3e7-1653937858.8962'

SELECT * FROM `menus` WHERE `code`='bottom_left_menu'

SELECT * FROM `menu_items` WHERE `menu_id`=2

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=3

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=4

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=5

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=14

SELECT * FROM `menu_langs` WHERE `menu_id`=2

SHOW FULL COLUMNS FROM `menu_langs`

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

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `menus` WHERE `code`='bottom_right_menu'

SELECT * FROM `menu_items` WHERE `menu_id`=4

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=10

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=11

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=12

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=13

SELECT * FROM `menu_langs` WHERE `menu_id`=4

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `company_contacts`

SELECT * FROM `company_contacts_langs` WHERE `company_contact_id`=1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1