SHOW FULL COLUMNS FROM `zw_system_company` [ RunTime:0.000731s ]
SELECT `id`,`domain` FROM `zw_system_company` [ RunTime:0.000188s ]
SELECT `IsOpenCitySite` FROM `zw_system_company` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000212s ]
SHOW FULL COLUMNS FROM `zw_system_config` [ RunTime:0.000728s ]
SHOW FULL COLUMNS FROM `zw_cms_product` [ RunTime:0.000917s ]
SHOW FULL COLUMNS FROM `zw_cms_article` [ RunTime:0.000692s ]
SHOW FULL COLUMNS FROM `zw_cms_nav` [ RunTime:0.000603s ]
SHOW FULL COLUMNS FROM `zw_cms_cases` [ RunTime:0.000804s ]
SHOW FULL COLUMNS FROM `zw_cms_expand` [ RunTime:0.000837s ]
SHOW FULL COLUMNS FROM `zw_cms_banner` [ RunTime:0.000593s ]
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.000715s ]
SELECT COUNT(*) AS think_count FROM `zw_cms_cases` 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` = 3 OR `nav_pid` = 3 OR `nav_dpid` = 3 ) ) AND `zw_cms_cases`.`delete_time` IS NULL [ RunTime:0.000363s ]
SELECT `id`,`title`,`subtitle`,`model`,`nav_id`,`nav_pid`,`nav_dpid`,`link`,`url_path`,`status`,`state`,`states`,`info`,`sketch`,`seo_title`,`seo_keyword`,`seo_content`,`image`,`photo`,`file`,`create_time`,`update_time`,`delete_time`,`browse`,`target`,`sort`,`rand`,`lang`,`company_id`,`city_code` FROM `zw_cms_cases` 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` = 3 OR `nav_pid` = 3 OR `nav_dpid` = 3 ) ) AND `zw_cms_cases`.`delete_time` IS NULL ORDER BY `sort` ASC,`create_time` DESC LIMIT 0,12 [ RunTime:0.000581s ]
SELECT title as nav_title FROM `zw_cms_nav` 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 `id` = 3 ) AND `zw_cms_nav`.`delete_time` IS NULL [ RunTime:0.000279s ]
