SHOW FULL COLUMNS FROM `cms_admin` [ RunTime:0.004585s ]
SELECT COUNT(*) AS think_count FROM `cms_admin` [ RunTime:0.001100s ]
CREATE TABLE IF NOT EXISTS `cms_nav` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`platform` varchar(20) NOT NULL DEFAULT 'pc',
`title` varchar(100) NOT NULL,
`url` varchar(500) NOT NULL DEFAULT '/',
`sort` int DEFAULT 0,
`status` tinyint DEFAULT 1,
`create_time` int DEFAULT 0,
`update_time` int DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 [ RunTime:0.004683s ]
SHOW FULL COLUMNS FROM `cms_setting` [ RunTime:0.003582s ]
SELECT * FROM `cms_setting` WHERE `key` = 'site_name' LIMIT 1 [ RunTime:0.003952s ]
SELECT * FROM `cms_setting` WHERE `key` = 'site_title' LIMIT 1 [ RunTime:0.002400s ]
SELECT * FROM `cms_setting` WHERE `key` = 'keywords' LIMIT 1 [ RunTime:0.001598s ]
SELECT * FROM `cms_setting` WHERE `key` = 'description' LIMIT 1 [ RunTime:0.001623s ]
SELECT * FROM `cms_setting` WHERE `key` = 'logo' LIMIT 1 [ RunTime:0.001446s ]
SELECT * FROM `cms_setting` WHERE `key` = 'footer_logo' LIMIT 1 [ RunTime:0.001925s ]
SELECT * FROM `cms_setting` WHERE `key` = 'favicon' LIMIT 1 [ RunTime:0.002351s ]
SELECT * FROM `cms_setting` WHERE `key` = 'phone' LIMIT 1 [ RunTime:0.002497s ]
SELECT * FROM `cms_setting` WHERE `key` = 'phone_label' LIMIT 1 [ RunTime:0.003018s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile' LIMIT 1 [ RunTime:0.002184s ]
SELECT * FROM `cms_setting` WHERE `key` = 'contact_name' LIMIT 1 [ RunTime:0.003572s ]
SELECT * FROM `cms_setting` WHERE `key` = 'address' LIMIT 1 [ RunTime:0.002433s ]
SELECT * FROM `cms_setting` WHERE `key` = 'icp' LIMIT 1 [ RunTime:0.001293s ]
SELECT * FROM `cms_setting` WHERE `key` = 'wechat_qr' LIMIT 1 [ RunTime:0.002395s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_qr' LIMIT 1 [ RunTime:0.001289s ]
SELECT * FROM `cms_setting` WHERE `key` = 'footer_wechat_label' LIMIT 1 [ RunTime:0.001964s ]
SELECT * FROM `cms_setting` WHERE `key` = 'footer_mobile_label' LIMIT 1 [ RunTime:0.002304s ]
SELECT * FROM `cms_setting` WHERE `key` = 'toolbar_phone_label' LIMIT 1 [ RunTime:0.003409s ]
SELECT * FROM `cms_setting` WHERE `key` = 'toolbar_top_label' LIMIT 1 [ RunTime:0.001729s ]
SELECT * FROM `cms_setting` WHERE `key` = 'footer_label_mobile' LIMIT 1 [ RunTime:0.001598s ]
SELECT * FROM `cms_setting` WHERE `key` = 'footer_label_phone' LIMIT 1 [ RunTime:0.002186s ]
SELECT * FROM `cms_setting` WHERE `key` = 'footer_label_address' LIMIT 1 [ RunTime:0.002161s ]
SELECT * FROM `cms_setting` WHERE `key` = 'home_product_limit' LIMIT 1 [ RunTime:0.001194s ]
SELECT * FROM `cms_setting` WHERE `key` = 'home_case_limit' LIMIT 1 [ RunTime:0.001380s ]
SELECT * FROM `cms_setting` WHERE `key` = 'home_news_limit' LIMIT 1 [ RunTime:0.000759s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sec_nav_title' LIMIT 1 [ RunTime:0.000617s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sec_nav_subtitle' LIMIT 1 [ RunTime:0.001334s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sec_case_title' LIMIT 1 [ RunTime:0.001153s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sec_case_subtitle' LIMIT 1 [ RunTime:0.000845s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sec_news_title' LIMIT 1 [ RunTime:0.001157s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sec_news_subtitle' LIMIT 1 [ RunTime:0.001767s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sec_news_top_label' LIMIT 1 [ RunTime:0.000817s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sec_news_more_label' LIMIT 1 [ RunTime:0.000741s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sec_news_side_title' LIMIT 1 [ RunTime:0.000723s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sec_news_side_subtitle' LIMIT 1 [ RunTime:0.002389s ]
SELECT * FROM `cms_setting` WHERE `key` = 'stat_label_exp' LIMIT 1 [ RunTime:0.001255s ]
SELECT * FROM `cms_setting` WHERE `key` = 'stat_label_stock' LIMIT 1 [ RunTime:0.000755s ]
SELECT * FROM `cms_setting` WHERE `key` = 'stat_label_std' LIMIT 1 [ RunTime:0.000742s ]
SELECT * FROM `cms_setting` WHERE `key` = 'product_phone_prefix' LIMIT 1 [ RunTime:0.002181s ]
SELECT * FROM `cms_setting` WHERE `key` = 'page_about_title' LIMIT 1 [ RunTime:0.000636s ]
SELECT * FROM `cms_setting` WHERE `key` = 'page_about_subtitle' LIMIT 1 [ RunTime:0.000733s ]
SELECT * FROM `cms_setting` WHERE `key` = 'page_product_title' LIMIT 1 [ RunTime:0.001097s ]
SELECT * FROM `cms_setting` WHERE `key` = 'page_product_subtitle' LIMIT 1 [ RunTime:0.001169s ]
SELECT * FROM `cms_setting` WHERE `key` = 'page_news_title' LIMIT 1 [ RunTime:0.000915s ]
SELECT * FROM `cms_setting` WHERE `key` = 'page_news_subtitle' LIMIT 1 [ RunTime:0.001146s ]
SELECT * FROM `cms_setting` WHERE `key` = 'page_case_title' LIMIT 1 [ RunTime:0.003143s ]
SELECT * FROM `cms_setting` WHERE `key` = 'page_case_subtitle' LIMIT 1 [ RunTime:0.000857s ]
SELECT * FROM `cms_setting` WHERE `key` = 'page_case_detail_sub' LIMIT 1 [ RunTime:0.001280s ]
SELECT * FROM `cms_setting` WHERE `key` = 'page_faq_title' LIMIT 1 [ RunTime:0.000785s ]
SELECT * FROM `cms_setting` WHERE `key` = 'page_faq_subtitle' LIMIT 1 [ RunTime:0.001206s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sec_faq_title' LIMIT 1 [ RunTime:0.000904s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sec_faq_subtitle' LIMIT 1 [ RunTime:0.001006s ]
SELECT * FROM `cms_setting` WHERE `key` = 'page_product_detail_sub' LIMIT 1 [ RunTime:0.000952s ]
SELECT * FROM `cms_setting` WHERE `key` = 'page_news_detail_sub' LIMIT 1 [ RunTime:0.001252s ]
SELECT * FROM `cms_setting` WHERE `key` = 'product_cta_text' LIMIT 1 [ RunTime:0.000965s ]
SELECT * FROM `cms_setting` WHERE `key` = 'product_detail_heading' LIMIT 1 [ RunTime:0.001130s ]
SELECT * FROM `cms_setting` WHERE `key` = 'product_list_all' LIMIT 1 [ RunTime:0.001881s ]
SELECT * FROM `cms_setting` WHERE `key` = 'about_title' LIMIT 1 [ RunTime:0.000812s ]
SELECT * FROM `cms_setting` WHERE `key` = 'about_subtitle' LIMIT 1 [ RunTime:0.000644s ]
SELECT * FROM `cms_setting` WHERE `key` = 'about_image' LIMIT 1 [ RunTime:0.001952s ]
SELECT * FROM `cms_setting` WHERE `key` = 'about_content' LIMIT 1 [ RunTime:0.002125s ]
SELECT * FROM `cms_setting` WHERE `key` = 'stat_years' LIMIT 1 [ RunTime:0.001345s ]
SELECT * FROM `cms_setting` WHERE `key` = 'stat_stock' LIMIT 1 [ RunTime:0.001300s ]
SELECT * FROM `cms_setting` WHERE `key` = 'stat_standard' LIMIT 1 [ RunTime:0.000916s ]
SELECT * FROM `cms_setting` WHERE `key` = 'advantage1' LIMIT 1 [ RunTime:0.001577s ]
SELECT * FROM `cms_setting` WHERE `key` = 'advantage2' LIMIT 1 [ RunTime:0.001382s ]
SELECT * FROM `cms_setting` WHERE `key` = 'advantage3' LIMIT 1 [ RunTime:0.001472s ]
SELECT * FROM `cms_setting` WHERE `key` = 'slogan' LIMIT 1 [ RunTime:0.001074s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_sec_product_title' LIMIT 1 [ RunTime:0.001390s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_sec_product_sub' LIMIT 1 [ RunTime:0.000997s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_sec_case_title' LIMIT 1 [ RunTime:0.000610s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_sec_case_sub' LIMIT 1 [ RunTime:0.001158s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_sec_news_title' LIMIT 1 [ RunTime:0.000802s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_sec_news_sub' LIMIT 1 [ RunTime:0.001001s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_sec_about_title' LIMIT 1 [ RunTime:0.001194s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_sec_about_sub' LIMIT 1 [ RunTime:0.000839s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_wechat_promo' LIMIT 1 [ RunTime:0.000740s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_btn_products' LIMIT 1 [ RunTime:0.000760s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_btn_call' LIMIT 1 [ RunTime:0.000719s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_tel_promo' LIMIT 1 [ RunTime:0.001679s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_wx_btn' LIMIT 1 [ RunTime:0.001041s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_footer_home' LIMIT 1 [ RunTime:0.000699s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_footer_call' LIMIT 1 [ RunTime:0.001190s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_footer_sms' LIMIT 1 [ RunTime:0.000776s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_footer_wx' LIMIT 1 [ RunTime:0.000670s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_contact_title' LIMIT 1 [ RunTime:0.000657s ]
SELECT * FROM `cms_setting` WHERE `key` = 'mobile_contact_sub' LIMIT 1 [ RunTime:0.000642s ]
SELECT * FROM `cms_setting` WHERE `key` = 'wx_popup_tip1' LIMIT 1 [ RunTime:0.001228s ]
SELECT * FROM `cms_setting` WHERE `key` = 'wx_popup_tip2' LIMIT 1 [ RunTime:0.000780s ]
SELECT * FROM `cms_setting` WHERE `key` = 'wx_popup_open' LIMIT 1 [ RunTime:0.001022s ]
SELECT * FROM `cms_setting` WHERE `key` = 'site_url' LIMIT 1 [ RunTime:0.000732s ]
SELECT * FROM `cms_setting` WHERE `key` = 'baidu_verify' LIMIT 1 [ RunTime:0.001041s ]
SELECT * FROM `cms_setting` WHERE `key` = 'bing_verify' LIMIT 1 [ RunTime:0.001459s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sogou_verify' LIMIT 1 [ RunTime:0.001048s ]
SELECT * FROM `cms_setting` WHERE `key` = 'verify_360' LIMIT 1 [ RunTime:0.000799s ]
SELECT * FROM `cms_setting` WHERE `key` = 'seo_suffix' LIMIT 1 [ RunTime:0.001296s ]
SELECT * FROM `cms_setting` WHERE `key` = 'geo_lat' LIMIT 1 [ RunTime:0.000847s ]
SELECT * FROM `cms_setting` WHERE `key` = 'geo_lng' LIMIT 1 [ RunTime:0.001106s ]
SELECT * FROM `cms_setting` WHERE `key` = 'opening_hours' LIMIT 1 [ RunTime:0.001604s ]
SELECT * FROM `cms_setting` WHERE `key` = 'area_served' LIMIT 1 [ RunTime:0.000775s ]
SELECT * FROM `cms_setting` WHERE `key` = 'business_type' LIMIT 1 [ RunTime:0.000795s ]
SHOW FULL COLUMNS FROM `cms_nav` [ RunTime:0.002442s ]
SELECT COUNT(*) AS think_count FROM `cms_nav` [ RunTime:0.000939s ]
SHOW TABLES LIKE 'faq' [ RunTime:0.001108s ]
CREATE TABLE IF NOT EXISTS `cms_faq` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`question` varchar(300) NOT NULL,
`answer` text NOT NULL,
`sort` int NOT NULL DEFAULT 0,
`status` tinyint NOT NULL DEFAULT 1,
`create_time` int NOT NULL DEFAULT 0,
`update_time` int NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 [ RunTime:0.004366s ]
SHOW TABLES LIKE 'cms_product' [ RunTime:0.001768s ]
SHOW TABLES LIKE 'cms_product' [ RunTime:0.001023s ]
SHOW COLUMNS FROM `cms_product` LIKE 'seo_title' [ RunTime:0.001886s ]
SHOW TABLES LIKE 'cms_product' [ RunTime:0.000524s ]
SHOW COLUMNS FROM `cms_product` LIKE 'seo_description' [ RunTime:0.001371s ]
SHOW TABLES LIKE 'cms_product' [ RunTime:0.000898s ]
SHOW COLUMNS FROM `cms_product` LIKE 'seo_keywords' [ RunTime:0.001576s ]
SHOW TABLES LIKE 'cms_news' [ RunTime:0.001347s ]
SHOW TABLES LIKE 'cms_news' [ RunTime:0.000662s ]
SHOW COLUMNS FROM `cms_news` LIKE 'seo_title' [ RunTime:0.001753s ]
SHOW TABLES LIKE 'cms_news' [ RunTime:0.000725s ]
SHOW COLUMNS FROM `cms_news` LIKE 'seo_description' [ RunTime:0.001480s ]
SHOW TABLES LIKE 'cms_news' [ RunTime:0.000920s ]
SHOW COLUMNS FROM `cms_news` LIKE 'seo_keywords' [ RunTime:0.001416s ]
SHOW TABLES LIKE 'cms_case' [ RunTime:0.000944s ]
SHOW TABLES LIKE 'cms_case' [ RunTime:0.002100s ]
SHOW TABLES LIKE 'cms_case' [ RunTime:0.000833s ]
SHOW COLUMNS FROM `cms_case` LIKE 'seo_title' [ RunTime:0.002122s ]
SHOW TABLES LIKE 'cms_case' [ RunTime:0.000779s ]
SHOW COLUMNS FROM `cms_case` LIKE 'seo_description' [ RunTime:0.001904s ]
SHOW TABLES LIKE 'cms_case' [ RunTime:0.000583s ]
SHOW COLUMNS FROM `cms_case` LIKE 'seo_keywords' [ RunTime:0.002351s ]
SHOW TABLES LIKE 'cms_case' [ RunTime:0.001727s ]
SHOW COLUMNS FROM `cms_case` LIKE 'content' [ RunTime:0.002446s ]
SHOW TABLES LIKE 'cms_case' [ RunTime:0.001061s ]
SHOW COLUMNS FROM `cms_case` LIKE 'views' [ RunTime:0.001523s ]
SHOW TABLES LIKE 'cms_case' [ RunTime:0.000738s ]
SHOW COLUMNS FROM `cms_case` LIKE 'summary' [ RunTime:0.001566s ]
UPDATE `cms_case` SET `content` = `description` WHERE (`content` IS NULL OR `content` = '') AND `description` <> '' [ RunTime:0.004161s ]
UPDATE `cms_case` SET `summary` = LEFT(`description`, 160) WHERE (`summary` IS NULL OR `summary` = '') AND `description` <> '' [ RunTime:0.005844s ]
SHOW FULL COLUMNS FROM `cms_faq` [ RunTime:0.001266s ]
SELECT COUNT(*) AS think_count FROM `cms_faq` [ RunTime:0.000653s ]
SELECT COUNT(*) AS think_count FROM `cms_nav` WHERE `url` = '/faq' [ RunTime:0.001094s ]
SELECT * FROM `cms_setting` ORDER BY `sort` ASC [ RunTime:0.002183s ]
SELECT COUNT(*) AS think_count FROM `cms_admin` [ RunTime:0.001821s ]
SELECT * FROM `cms_setting` WHERE `key` = 'site_url' LIMIT 1 [ RunTime:0.001425s ]
SELECT * FROM `cms_setting` WHERE `key` = 'baidu_verify' LIMIT 1 [ RunTime:0.001345s ]
SELECT * FROM `cms_setting` WHERE `key` = 'bing_verify' LIMIT 1 [ RunTime:0.001667s ]
SELECT * FROM `cms_setting` WHERE `key` = 'sogou_verify' LIMIT 1 [ RunTime:0.002667s ]
SELECT * FROM `cms_setting` WHERE `key` = 'verify_360' LIMIT 1 [ RunTime:0.001871s ]
SELECT * FROM `cms_setting` WHERE `key` = 'seo_suffix' LIMIT 1 [ RunTime:0.001490s ]
SHOW FULL COLUMNS FROM `cms_category` [ RunTime:0.002481s ]
SELECT * FROM `cms_category` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001687s ]
SHOW FULL COLUMNS FROM `cms_banner` [ RunTime:0.001952s ]
SELECT * FROM `cms_banner` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002175s ]
SELECT * FROM `cms_nav` WHERE `platform` = 'pc' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001245s ]
SELECT * FROM `cms_nav` WHERE `platform` = 'mobile' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001980s ]
SHOW FULL COLUMNS FROM `cms_product` [ RunTime:0.002415s ]
SELECT `id` FROM `cms_category` WHERE `parent_id` = 46 [ RunTime:0.001518s ]
SELECT COUNT(*) AS think_count FROM `cms_product` WHERE `status` = 1 AND `category_id` = 46 [ RunTime:0.001230s ]
SELECT * FROM `cms_product` WHERE `status` = 1 AND `category_id` = 46 ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,12 [ RunTime:0.001628s ]
SELECT * FROM `cms_category` WHERE `id` = 46 LIMIT 1 [ RunTime:0.001856s ]
