SHOW FULL COLUMNS FROM `tp_region_list` [ RunTime:0.000624s ]
SELECT * FROM `tp_region_list` WHERE `pinyin` = 'www' AND `substation_status` = 1 LIMIT 1 [ RunTime:0.000188s ]
SELECT * FROM `tp_region_list` WHERE `regionCode` = 310100 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000135s ]
SHOW FULL COLUMNS FROM `tp_fields_setting` [ RunTime:0.000486s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'fengge' ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000122s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'kongjian' ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000114s ]
SHOW FULL COLUMNS FROM `tp_biz_cases_pictures` [ RunTime:0.000438s ]
SELECT COUNT(*) AS think_count FROM `tp_biz_cases_pictures` `pic` INNER JOIN `tp_biz_cases` `case` ON `pic`.`case_id`=`case`.`id` WHERE `pic`.`status` = '1' AND `pic`.`type` <> '1' AND `pic`.`type` = '5' [ RunTime:0.000140s ]
SELECT `pic`.`id`,`pic`.`url`,`pic`.`type`,`case`.`title` FROM `tp_biz_cases_pictures` `pic` INNER JOIN `tp_biz_cases` `case` ON `pic`.`case_id`=`case`.`id` WHERE `pic`.`status` = '1' AND `pic`.`type` <> '1' AND `pic`.`type` = '5' ORDER BY `id` DESC LIMIT 0,40 [ RunTime:0.000144s ]
SHOW FULL COLUMNS FROM `tp_site_info` [ RunTime:0.000468s ]
SELECT * FROM `tp_site_info` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000120s ]
SELECT * FROM `tp_region_list` WHERE `parentId` = 0 ORDER BY `initial` ASC,`regionCode` ASC [ RunTime:0.000119s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'fengge' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000136s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'kongjian' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000113s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'huxing' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000103s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'baogongfangshi' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000116s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'gongzhuangkongjian' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000097s ]
SELECT regionStr as text,regionCode as value FROM `tp_region_list` WHERE `parentId` = 310100 LIMIT 9 [ RunTime:0.000094s ]
SHOW FULL COLUMNS FROM `tp_system_news_cate` [ RunTime:0.000456s ]
SELECT `id`,`top_cate`,`cate_name` FROM `tp_system_news_cate` WHERE `top_cate` = 2 ORDER BY `sort` DESC,`id` ASC LIMIT 6 [ RunTime:0.000132s ]
SELECT `id`,`top_cate`,`cate_name` FROM `tp_system_news_cate` WHERE `top_cate` = 3 ORDER BY `sort` DESC,`id` ASC LIMIT 6 [ RunTime:0.000107s ]
SELECT `id`,`top_cate`,`cate_name` FROM `tp_system_news_cate` WHERE `top_cate` = 4 ORDER BY `sort` DESC,`id` ASC LIMIT 6 [ RunTime:0.000107s ]
SELECT * FROM `tp_region_list` WHERE `substation_status` = 1 AND `recommond_status` = 1 ORDER BY `id` ASC LIMIT 30 [ RunTime:0.000123s ]
