CREATE TABLE IF NOT EXISTS `fc_article_categories` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(160) NOT NULL,
`slug` VARCHAR(180) NOT NULL,
`description` TEXT 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_article_category_slug` (`slug`),
KEY `idx_article_category_status_sort` (`status`, `sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.003557s ]
CREATE TABLE IF NOT EXISTS `fc_articles` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`category_id` BIGINT UNSIGNED NULL,
`title` VARCHAR(255) NOT NULL,
`slug` VARCHAR(220) NOT NULL,
`cover_image` VARCHAR(500) NULL,
`excerpt` TEXT NULL,
`content` MEDIUMTEXT NULL,
`seo_title` VARCHAR(255) NULL,
`seo_description` VARCHAR(500) NULL,
`seo_keywords` VARCHAR(500) NULL,
`canonical_url` VARCHAR(500) NULL,
`status` VARCHAR(30) NOT NULL DEFAULT 'draft',
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`view_count` INT UNSIGNED NOT NULL DEFAULT 0,
`published_at` DATETIME NULL,
`created_at` DATETIME NULL,
`updated_at` DATETIME NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_article_slug` (`slug`),
KEY `idx_article_category_status` (`category_id`, `status`),
KEY `idx_article_status_published` (`status`, `published_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.003237s ]
CREATE TABLE IF NOT EXISTS `fc_article_related_products` (
`article_id` BIGINT UNSIGNED NOT NULL,
`product_id` BIGINT UNSIGNED NOT NULL,
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`created_at` DATETIME NULL,
PRIMARY KEY (`article_id`, `product_id`),
KEY `idx_article_related_product` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002633s ]
CREATE TABLE IF NOT EXISTS `fc_article_related_pages` (
`article_id` BIGINT UNSIGNED NOT NULL,
`page_id` BIGINT UNSIGNED NOT NULL,
PRIMARY KEY (`article_id`, `page_id`),
KEY `idx_article_related_page` (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002454s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.000887s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.001088s ]
SHOW FULL COLUMNS FROM `fc_article_categories` [ RunTime:0.001263s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.000559s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.001118s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000660s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000479s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.000451s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' AND `status` = 1 LIMIT 1 [ RunTime:0.000799s ]
SHOW FULL COLUMNS FROM `fc_articles` [ RunTime:0.000873s ]
SELECT COUNT(`a`.`id`) AS think_count FROM `fc_articles` `a` LEFT JOIN `fc_article_categories` `c` ON `c`.`id`=`a`.`category_id` WHERE `a`.`status` = 'published' AND ( (a.published_at IS NULL OR a.published_at <= NOW()) ) AND `a`.`category_id` = '2' [ RunTime:0.001035s ]
SELECT `a`.`id`,`a`.`title`,`a`.`slug`,`a`.`cover_image`,`a`.`excerpt`,`a`.`published_at`,c.name AS category_name,c.slug AS category_slug FROM `fc_articles` `a` LEFT JOIN `fc_article_categories` `c` ON `c`.`id`=`a`.`category_id` WHERE `a`.`status` = 'published' AND ( (a.published_at IS NULL OR a.published_at <= NOW()) ) AND `a`.`category_id` = '2' ORDER BY `a`.`published_at` DESC,`a`.`id` DESC LIMIT 0,9 [ RunTime:0.001031s ]
CREATE TABLE IF NOT EXISTS `fc_article_categories` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(160) NOT NULL,
`slug` VARCHAR(180) NOT NULL,
`description` TEXT 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_article_category_slug` (`slug`),
KEY `idx_article_category_status_sort` (`status`, `sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.003111s ]
CREATE TABLE IF NOT EXISTS `fc_articles` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`category_id` BIGINT UNSIGNED NULL,
`title` VARCHAR(255) NOT NULL,
`slug` VARCHAR(220) NOT NULL,
`cover_image` VARCHAR(500) NULL,
`excerpt` TEXT NULL,
`content` MEDIUMTEXT NULL,
`seo_title` VARCHAR(255) NULL,
`seo_description` VARCHAR(500) NULL,
`seo_keywords` VARCHAR(500) NULL,
`canonical_url` VARCHAR(500) NULL,
`status` VARCHAR(30) NOT NULL DEFAULT 'draft',
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`view_count` INT UNSIGNED NOT NULL DEFAULT 0,
`published_at` DATETIME NULL,
`created_at` DATETIME NULL,
`updated_at` DATETIME NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_article_slug` (`slug`),
KEY `idx_article_category_status` (`category_id`, `status`),
KEY `idx_article_status_published` (`status`, `published_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002834s ]
CREATE TABLE IF NOT EXISTS `fc_article_related_products` (
`article_id` BIGINT UNSIGNED NOT NULL,
`product_id` BIGINT UNSIGNED NOT NULL,
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`created_at` DATETIME NULL,
PRIMARY KEY (`article_id`, `product_id`),
KEY `idx_article_related_product` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.003799s ]
CREATE TABLE IF NOT EXISTS `fc_article_related_pages` (
`article_id` BIGINT UNSIGNED NOT NULL,
`page_id` BIGINT UNSIGNED NOT NULL,
PRIMARY KEY (`article_id`, `page_id`),
KEY `idx_article_related_page` (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002651s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.000763s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.001092s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.000680s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.000990s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000902s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000710s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.000504s ]
SELECT * FROM `fc_article_categories` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000527s ]
CREATE TABLE IF NOT EXISTS `fc_article_categories` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(160) NOT NULL,
`slug` VARCHAR(180) NOT NULL,
`description` TEXT 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_article_category_slug` (`slug`),
KEY `idx_article_category_status_sort` (`status`, `sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002891s ]
CREATE TABLE IF NOT EXISTS `fc_articles` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`category_id` BIGINT UNSIGNED NULL,
`title` VARCHAR(255) NOT NULL,
`slug` VARCHAR(220) NOT NULL,
`cover_image` VARCHAR(500) NULL,
`excerpt` TEXT NULL,
`content` MEDIUMTEXT NULL,
`seo_title` VARCHAR(255) NULL,
`seo_description` VARCHAR(500) NULL,
`seo_keywords` VARCHAR(500) NULL,
`canonical_url` VARCHAR(500) NULL,
`status` VARCHAR(30) NOT NULL DEFAULT 'draft',
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`view_count` INT UNSIGNED NOT NULL DEFAULT 0,
`published_at` DATETIME NULL,
`created_at` DATETIME NULL,
`updated_at` DATETIME NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_article_slug` (`slug`),
KEY `idx_article_category_status` (`category_id`, `status`),
KEY `idx_article_status_published` (`status`, `published_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.002772s ]
CREATE TABLE IF NOT EXISTS `fc_article_related_products` (
`article_id` BIGINT UNSIGNED NOT NULL,
`product_id` BIGINT UNSIGNED NOT NULL,
`sort` INT UNSIGNED NOT NULL DEFAULT 100,
`created_at` DATETIME NULL,
PRIMARY KEY (`article_id`, `product_id`),
KEY `idx_article_related_product` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.003427s ]
CREATE TABLE IF NOT EXISTS `fc_article_related_pages` (
`article_id` BIGINT UNSIGNED NOT NULL,
`page_id` BIGINT UNSIGNED NOT NULL,
PRIMARY KEY (`article_id`, `page_id`),
KEY `idx_article_related_page` (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci [ RunTime:0.003342s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.001229s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.001823s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.001338s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.001246s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000953s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000879s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.000823s ]
SELECT `a`.`id`,`a`.`title`,`a`.`slug`,`a`.`cover_image`,`a`.`excerpt`,`a`.`published_at`,c.name AS category_name,c.slug AS category_slug FROM `fc_articles` `a` LEFT JOIN `fc_article_categories` `c` ON `c`.`id`=`a`.`category_id` WHERE `a`.`status` = 'published' AND ( (a.published_at IS NULL OR a.published_at <= NOW()) ) ORDER BY `a`.`published_at` DESC,`a`.`id` DESC LIMIT 5 [ RunTime:0.001211s ]
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.002970s ]
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.002873s ]
SHOW FULL COLUMNS FROM `fc_markets` [ RunTime:0.001328s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000670s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000579s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000496s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000517s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000486s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000592s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001058s ]
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.003164s ]
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.003150s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.001289s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000625s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000501s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000606s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000396s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000898s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000512s ]
