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.003102s ]
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.002807s ]
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.003250s ]
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.014347s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.001483s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.001319s ]
SHOW FULL COLUMNS FROM `fc_article_categories` [ RunTime:0.001479s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.001069s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.000910s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000855s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000920s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.001123s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' AND `status` = 1 LIMIT 1 [ RunTime:0.000905s ]
SHOW FULL COLUMNS FROM `fc_articles` [ RunTime:0.001450s ]
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.001042s ]
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.001314s ]
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.003970s ]
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.003037s ]
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.002752s ]
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.003489s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.001011s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.000976s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.000585s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.000416s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000464s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000547s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.000350s ]
SELECT * FROM `fc_article_categories` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000591s ]
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.003410s ]
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.002813s ]
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.002948s ]
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.002855s ]
SHOW COLUMNS FROM `fc_article_related_products` [ RunTime:0.000795s ]
SHOW COLUMNS FROM `fc_articles` [ RunTime:0.000990s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'buying-guide' LIMIT 1 [ RunTime:0.000575s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'material-guide' LIMIT 1 [ RunTime:0.000544s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'oem-odm-guide' LIMIT 1 [ RunTime:0.000678s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'product-knowledge' LIMIT 1 [ RunTime:0.000484s ]
SELECT * FROM `fc_article_categories` WHERE `slug` = 'company-news' LIMIT 1 [ RunTime:0.000398s ]
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.000797s ]
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.002789s ]
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.002495s ]
SHOW FULL COLUMNS FROM `fc_markets` [ RunTime:0.000798s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000436s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000373s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000331s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000455s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000633s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000496s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000536s ]
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.003061s ]
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.004464s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'north-america' LIMIT 1 [ RunTime:0.000371s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'south-america' LIMIT 1 [ RunTime:0.000451s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'europe' LIMIT 1 [ RunTime:0.000393s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'asia' LIMIT 1 [ RunTime:0.000372s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'middle-east' LIMIT 1 [ RunTime:0.000467s ]
SELECT * FROM `fc_markets` WHERE `slug` = 'africa' LIMIT 1 [ RunTime:0.000397s ]
SELECT `name`,`slug` FROM `fc_markets` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000573s ]
