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.003656s ]
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.002858s ]
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.002602s ]
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.002446s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.000671s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.000583s ]
SHOW FULL COLUMNS FROM `fc_article_categories` [ RunTime:0.000810s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.000549s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.000495s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000553s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000424s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.000366s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' AND `status` = 1 LIMIT 1 [ RunTime:0.000467s ]
SHOW FULL COLUMNS FROM `fc_articles` [ RunTime:0.000837s ]
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.000756s ]
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.000751s ]
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.002646s ]
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.004114s ]
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.002410s ]
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.002324s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.000751s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.000797s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.000487s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.000473s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000430s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000402s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.000428s ]
SELECT * FROM `fc_article_categories` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000488s ]
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.002463s ]
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.002425s ]
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.002442s ]
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.002591s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.000755s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.000782s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.000499s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.000419s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000417s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000400s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.000426s ]
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.000711s ]
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.002707s ]
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.002380s ]
SHOW FULL COLUMNS FROM `fc_markets` [ RunTime:0.000793s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000693s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000373s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000335s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000321s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000338s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000317s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000438s ]
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.002468s ]
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.002347s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000367s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000385s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000359s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000339s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000412s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000837s ]
