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.003980s ]
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.002752s ]
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.002632s ]
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.002431s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.000786s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.000679s ]
SHOW FULL COLUMNS FROM `fc_article_categories` [ RunTime:0.000871s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.000648s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.000427s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000360s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.000438s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' AND `status` = 1 LIMIT 1 [ RunTime:0.000459s ]
SHOW FULL COLUMNS FROM `fc_articles` [ RunTime:0.000763s ]
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` = '4' [ RunTime:0.000786s ]
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` = '4' ORDER BY `a`.`published_at` DESC,`a`.`id` DESC LIMIT 0,9 [ RunTime:0.000771s ]
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.002751s ]
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.002738s ]
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.002467s ]
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.002428s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.000767s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.000957s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.000586s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.000376s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000408s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000323s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.000384s ]
SELECT * FROM `fc_article_categories` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000516s ]
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.002633s ]
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.002524s ]
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.002454s ]
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.002874s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.000772s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.000697s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.000484s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.000437s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000434s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000353s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.000401s ]
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.000701s ]
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.002610s ]
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.002471s ]
SHOW FULL COLUMNS FROM `fc_markets` [ RunTime:0.000817s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000445s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000524s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000424s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000350s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000411s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000471s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000452s ]
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.002579s ]
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.002420s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000553s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000432s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000389s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000381s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000364s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000369s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000407s ]
