SHOW FULL COLUMNS FROM `zw_system_company` [ RunTime:0.000616s ]
SELECT `id`,`domain` FROM `zw_system_company` [ RunTime:0.000211s ]
SELECT `IsOpenCitySite` FROM `zw_system_company` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000256s ]
SHOW FULL COLUMNS FROM `zw_system_config` [ RunTime:0.001033s ]
SHOW FULL COLUMNS FROM `zw_cms_product` [ RunTime:0.000720s ]
SHOW FULL COLUMNS FROM `zw_cms_article` [ RunTime:0.000661s ]
SHOW FULL COLUMNS FROM `zw_cms_nav` [ RunTime:0.000736s ]
SHOW FULL COLUMNS FROM `zw_cms_cases` [ RunTime:0.000800s ]
SHOW FULL COLUMNS FROM `zw_cms_expand` [ RunTime:0.000586s ]
SHOW FULL COLUMNS FROM `zw_cms_banner` [ RunTime:0.000550s ]
SELECT `id`,`title`,`link`,`target` FROM `zw_cms_product` WHERE ( `status` = 1 AND `lang` = 'zh-cn' AND `company_id` = 17 AND ( `city_code` = 'ALL' OR `city_code` = '' OR `city_code` = 'guangzhou' OR ( FIND_IN_SET('guangzhou', `city_code`) ) ) AND `states` = 1 AND `model` = 'products' ) AND `zw_cms_product`.`delete_time` IS NULL ORDER BY `sort` ASC,`create_time` DESC LIMIT 10 [ RunTime:0.000357s ]
SELECT COUNT(*) AS think_count FROM `zw_cms_article` WHERE ( `status` = 1 AND `lang` = 'zh-cn' AND `company_id` = 17 AND ( `city_code` = 'ALL' OR `city_code` = '' OR `city_code` = 'guangzhou' OR ( FIND_IN_SET('guangzhou', `city_code`) ) ) AND ( `nav_id` IS NULL OR `nav_pid` IS NULL OR `nav_dpid` IS NULL ) AND `product_id` = 0 ) AND `zw_cms_article`.`delete_time` IS NULL [ RunTime:0.000435s ]
SELECT `id`,`title`,`subtitle`,`sketch`,`seo_title`,`seo_keyword`,`seo_content`,`image`,`create_time`,`update_time`,`delete_time`,`creator`,`modifier`,`nav_id`,`nav_pid`,`nav_dpid`,`browse`,`sort`,`status`,`publish_time`,`state`,`states`,`model`,`type`,`link`,`url_path`,`target`,`rand`,`product_id`,`label`,`lang`,`company_id`,`city_code` FROM `zw_cms_article` WHERE ( `status` = 1 AND `lang` = 'zh-cn' AND `company_id` = 17 AND ( `city_code` = 'ALL' OR `city_code` = '' OR `city_code` = 'guangzhou' OR ( FIND_IN_SET('guangzhou', `city_code`) ) ) AND ( `nav_id` IS NULL OR `nav_pid` IS NULL OR `nav_dpid` IS NULL ) AND `product_id` = 0 ) AND `zw_cms_article`.`delete_time` IS NULL ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,12 [ RunTime:0.000373s ]
