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.002993s ]
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.003098s ]
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.003405s ]
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.002628s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.000819s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.001351s ]
SHOW FULL COLUMNS FROM `fc_article_categories` [ RunTime:0.001285s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.001362s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.000478s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000746s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000631s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.000433s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' AND `status` = 1 LIMIT 1 [ RunTime:0.000546s ]
SHOW FULL COLUMNS FROM `fc_articles` [ RunTime:0.000892s ]
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` = '3' [ RunTime:0.000824s ]
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` = '3' ORDER BY `a`.`published_at` DESC,`a`.`id` DESC LIMIT 0,9 [ RunTime:0.001485s ]
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.003177s ]
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.002853s ]
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.002851s ]
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.002754s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.000734s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.001180s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.000478s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.001097s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000447s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000439s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.000417s ]
SELECT * FROM `fc_article_categories` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000515s ]
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.002828s ]
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.002855s ]
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.002469s ]
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.002399s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.000683s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.000819s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.000581s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.000815s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000701s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.001352s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.001447s ]
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.001489s ]
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.002688s ]
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.002437s ]
SHOW FULL COLUMNS FROM `fc_markets` [ RunTime:0.000748s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000492s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000394s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000649s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000548s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000405s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000753s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000681s ]
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.002831s ]
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.002770s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000715s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000602s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000672s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000479s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000683s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000672s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000539s ]
