SHOW FULL COLUMNS FROM `fc_attributes` [ RunTime:0.001699s ]
SELECT `id` FROM `fc_attributes` WHERE `attr_group` = 'finish' AND `slug` = 'mirror-polish' AND `status` = 1 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.001059s ]
SELECT `id` FROM `fc_attributes` WHERE `attr_group` = 'application' AND `slug` = 'hotel-restaurant' AND `status` = 1 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.001068s ]
SHOW FULL COLUMNS FROM `fc_products` [ RunTime:0.002209s ]
SELECT COUNT(DISTINCT `p`.`id`) AS think_count FROM `fc_products` `p` LEFT JOIN `fc_product_types` `pt` ON `pt`.`id`=`p`.`product_type_id` LEFT JOIN `fc_flatware_set_types` `fst` ON `fst`.`id`=`p`.`flatware_set_type_id` INNER JOIN `fc_product_attributes` `pa_topic` ON `pa_topic`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_topic` ON `a_topic`.`id`=`pa_topic`.`attribute_id` INNER JOIN `fc_product_attributes` `pa_filter_finish` ON `pa_filter_finish`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_filter_finish` ON `a_filter_finish`.`id`=`pa_filter_finish`.`attribute_id` INNER JOIN `fc_product_attributes` `pa_filter_application` ON `pa_filter_application`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_filter_application` ON `a_filter_application`.`id`=`pa_filter_application`.`attribute_id` WHERE `p`.`status` = 'published' AND `p`.`delete_time` IS NULL AND `a_topic`.`attr_group` = 'material' AND `a_topic`.`slug` = '18-0-stainless-steel' AND `a_topic`.`status` = '1' AND `a_topic`.`delete_time` IS NULL AND `a_filter_finish`.`attr_group` = 'finish' AND `a_filter_finish`.`slug` = 'mirror-polish' AND `a_filter_finish`.`status` = '1' AND `a_filter_finish`.`delete_time` IS NULL AND `a_filter_application`.`attr_group` = 'application' AND `a_filter_application`.`slug` = 'hotel-restaurant' AND `a_filter_application`.`status` = '1' AND `a_filter_application`.`delete_time` IS NULL [ RunTime:0.002935s ]
SELECT `p`.`id`,`p`.`product_kind`,`p`.`name`,`p`.`slug`,`p`.`sku`,`p`.`main_image`,`p`.`spec_summary`,pt.name AS product_type_name,fst.name AS set_type_name FROM `fc_products` `p` LEFT JOIN `fc_product_types` `pt` ON `pt`.`id`=`p`.`product_type_id` LEFT JOIN `fc_flatware_set_types` `fst` ON `fst`.`id`=`p`.`flatware_set_type_id` INNER JOIN `fc_product_attributes` `pa_topic` ON `pa_topic`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_topic` ON `a_topic`.`id`=`pa_topic`.`attribute_id` INNER JOIN `fc_product_attributes` `pa_filter_finish` ON `pa_filter_finish`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_filter_finish` ON `a_filter_finish`.`id`=`pa_filter_finish`.`attribute_id` INNER JOIN `fc_product_attributes` `pa_filter_application` ON `pa_filter_application`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_filter_application` ON `a_filter_application`.`id`=`pa_filter_application`.`attribute_id` WHERE `p`.`status` = 'published' AND `p`.`delete_time` IS NULL AND `a_topic`.`attr_group` = 'material' AND `a_topic`.`slug` = '18-0-stainless-steel' AND `a_topic`.`status` = '1' AND `a_topic`.`delete_time` IS NULL AND `a_filter_finish`.`attr_group` = 'finish' AND `a_filter_finish`.`slug` = 'mirror-polish' AND `a_filter_finish`.`status` = '1' AND `a_filter_finish`.`delete_time` IS NULL AND `a_filter_application`.`attr_group` = 'application' AND `a_filter_application`.`slug` = 'hotel-restaurant' AND `a_filter_application`.`status` = '1' AND `a_filter_application`.`delete_time` IS NULL GROUP BY `p`.`id` ORDER BY `p`.`is_recommended` DESC,`p`.`sort` ASC,`p`.`id` DESC LIMIT 0,20 [ RunTime:0.001924s ]
SELECT `id` FROM `fc_attributes` WHERE `attr_group` = 'material' AND `slug` = '18-0-stainless-steel' AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000595s ]
SHOW FULL COLUMNS FROM `fc_product_attributes` [ RunTime:0.000793s ]
SELECT `pa`.`product_id`,`a`.`attr_group`,`a`.`name` FROM `fc_product_attributes` `pa` INNER JOIN `fc_attributes` `a` ON `a`.`id`=`pa`.`attribute_id` WHERE `pa`.`product_id` IN ('87','85','76','71','53','42','38','37','36','35','33','26') AND `a`.`attr_group` IN ('finish','material','application') AND `a`.`status` = '1' AND `a`.`delete_time` IS NULL ORDER BY `a`.`sort` ASC,`a`.`id` ASC [ RunTime:0.001078s ]
SHOW FULL COLUMNS FROM `fc_product_images` [ RunTime:0.001118s ]
SELECT * FROM `fc_product_images` WHERE `product_id` IN ('87','85','76','71','53','42','38','37','36','35','33','26') AND `type` IN ('main','set','gallery') ORDER BY FIELD(type, 'main', 'set', 'gallery'),`sort` ASC,`id` ASC [ RunTime:0.001066s ]
SELECT pt.name, pt.slug, COUNT(DISTINCT p.id) AS product_count FROM `fc_products` `p` INNER JOIN `fc_product_attributes` `pa_topic` ON `pa_topic`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_topic` ON `a_topic`.`id`=`pa_topic`.`attribute_id` INNER JOIN `fc_product_types` `pt` ON `pt`.`id`=`p`.`product_type_id` WHERE `p`.`product_kind` = 'single' AND `p`.`status` = 'published' AND `p`.`delete_time` IS NULL AND `a_topic`.`attr_group` = 'material' AND `a_topic`.`slug` = '18-0-stainless-steel' AND `a_topic`.`status` = '1' AND `a_topic`.`delete_time` IS NULL AND `pt`.`status` = '1' AND `pt`.`delete_time` IS NULL GROUP BY `pt`.`id` ORDER BY `pt`.`sort` ASC,`pt`.`id` ASC [ RunTime:0.001394s ]
SELECT fst.name, fst.slug, COUNT(DISTINCT p.id) AS product_count FROM `fc_products` `p` INNER JOIN `fc_product_attributes` `pa_topic` ON `pa_topic`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_topic` ON `a_topic`.`id`=`pa_topic`.`attribute_id` INNER JOIN `fc_flatware_set_types` `fst` ON `fst`.`id`=`p`.`flatware_set_type_id` WHERE `p`.`product_kind` = 'set' AND `p`.`status` = 'published' AND `p`.`delete_time` IS NULL AND `a_topic`.`attr_group` = 'material' AND `a_topic`.`slug` = '18-0-stainless-steel' AND `a_topic`.`status` = '1' AND `a_topic`.`delete_time` IS NULL AND `fst`.`status` = '1' AND `fst`.`delete_time` IS NULL GROUP BY `fst`.`id` ORDER BY `fst`.`sort` ASC,`fst`.`id` ASC [ RunTime:0.001341s ]
SELECT a_filter.name, a_filter.slug, COUNT(DISTINCT p.id) AS product_count FROM `fc_products` `p` INNER JOIN `fc_product_attributes` `pa_topic` ON `pa_topic`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_topic` ON `a_topic`.`id`=`pa_topic`.`attribute_id` INNER JOIN `fc_product_attributes` `pa_filter` ON `pa_filter`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_filter` ON `a_filter`.`id`=`pa_filter`.`attribute_id` WHERE `p`.`status` = 'published' AND `p`.`delete_time` IS NULL AND `a_topic`.`attr_group` = 'material' AND `a_topic`.`slug` = '18-0-stainless-steel' AND `a_topic`.`status` = '1' AND `a_topic`.`delete_time` IS NULL AND `a_filter`.`attr_group` = 'finish' AND `a_filter`.`status` = '1' AND `a_filter`.`delete_time` IS NULL GROUP BY `a_filter`.`id` ORDER BY `a_filter`.`sort` ASC,`a_filter`.`id` ASC [ RunTime:0.001513s ]
SELECT a_filter.name, a_filter.slug, COUNT(DISTINCT p.id) AS product_count FROM `fc_products` `p` INNER JOIN `fc_product_attributes` `pa_topic` ON `pa_topic`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_topic` ON `a_topic`.`id`=`pa_topic`.`attribute_id` INNER JOIN `fc_product_attributes` `pa_filter` ON `pa_filter`.`product_id`=`p`.`id` INNER JOIN `fc_attributes` `a_filter` ON `a_filter`.`id`=`pa_filter`.`attribute_id` WHERE `p`.`status` = 'published' AND `p`.`delete_time` IS NULL AND `a_topic`.`attr_group` = 'material' AND `a_topic`.`slug` = '18-0-stainless-steel' AND `a_topic`.`status` = '1' AND `a_topic`.`delete_time` IS NULL AND `a_filter`.`attr_group` = 'application' AND `a_filter`.`status` = '1' AND `a_filter`.`delete_time` IS NULL GROUP BY `a_filter`.`id` ORDER BY `a_filter`.`sort` ASC,`a_filter`.`id` ASC [ RunTime:0.001496s ]
SHOW FULL COLUMNS FROM `fc_pages` [ RunTime:0.001286s ]
SELECT * FROM `fc_pages` WHERE `status` = 1 AND `delete_time` IS NULL AND `url` = '/18-0-stainless-steel-cutlery' LIMIT 1 [ RunTime:0.000829s ]
CREATE TABLE IF NOT EXISTS `fc_markets` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(120) NOT NULL,
`slug` VARCHAR(160) NOT NULL,
`description` TEXT NULL,
`image` VARCHAR(500) NULL,
`seo_title` VARCHAR(255) NULL,
`seo_description` VARCHAR(500) NULL,
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`status` TINYINT UNSIGNED NOT NULL DEFAULT 1,
`created_at` DATETIME NULL,
`updated_at` DATETIME NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_fc_markets_slug` (`slug`),
KEY `idx_fc_markets_status_sort` (`status`, `sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.005001s ]
CREATE TABLE IF NOT EXISTS `fc_product_markets` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`product_id` BIGINT UNSIGNED NOT NULL,
`market_id` BIGINT UNSIGNED NOT NULL,
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`created_at` DATETIME NULL,
`updated_at` DATETIME NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_fc_product_markets_product_market` (`product_id`, `market_id`),
KEY `idx_fc_product_markets_market_sort` (`market_id`, `sort`),
KEY `idx_fc_product_markets_product` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002719s ]
SHOW FULL COLUMNS FROM `fc_markets` [ RunTime:0.001001s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000523s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000444s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000398s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000407s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000404s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000416s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000428s ]
CREATE TABLE IF NOT EXISTS `fc_markets` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(120) NOT NULL,
`slug` VARCHAR(160) NOT NULL,
`description` TEXT NULL,
`image` VARCHAR(500) NULL,
`seo_title` VARCHAR(255) NULL,
`seo_description` VARCHAR(500) NULL,
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`status` TINYINT UNSIGNED NOT NULL DEFAULT 1,
`created_at` DATETIME NULL,
`updated_at` DATETIME NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_fc_markets_slug` (`slug`),
KEY `idx_fc_markets_status_sort` (`status`, `sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002837s ]
CREATE TABLE IF NOT EXISTS `fc_product_markets` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`product_id` BIGINT UNSIGNED NOT NULL,
`market_id` BIGINT UNSIGNED NOT NULL,
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`created_at` DATETIME NULL,
`updated_at` DATETIME NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_fc_product_markets_product_market` (`product_id`, `market_id`),
KEY `idx_fc_product_markets_market_sort` (`market_id`, `sort`),
KEY `idx_fc_product_markets_product` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.003659s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000692s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000585s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000542s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000522s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000595s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000571s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000656s ]
