SHOW FULL COLUMNS FROM `tp_region_list` [ RunTime:0.000689s ]
SELECT * FROM `tp_region_list` WHERE `pinyin` = 'www' AND `substation_status` = 1 LIMIT 1 [ RunTime:0.000177s ]
SELECT * FROM `tp_region_list` WHERE `regionCode` = 310100 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000131s ]
SHOW FULL COLUMNS FROM `tp_fields_setting` [ RunTime:0.000476s ]
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.000107s ]
SHOW FULL COLUMNS FROM `tp_biz_cases_pictures` [ RunTime:0.000432s ]
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` = '4' [ RunTime:0.000146s ]
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` = '4' ORDER BY `id` DESC LIMIT 0,40 [ RunTime:0.000137s ]
SHOW FULL COLUMNS FROM `tp_site_info` [ RunTime:0.000471s ]
SELECT * FROM `tp_site_info` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000129s ]
SELECT * FROM `tp_region_list` WHERE `parentId` = 0 ORDER BY `initial` ASC,`regionCode` ASC [ RunTime:0.000110s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'fengge' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000128s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'kongjian' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000125s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'huxing' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000097s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'baogongfangshi' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000107s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'gongzhuangkongjian' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000102s ]
SELECT regionStr as text,regionCode as value FROM `tp_region_list` WHERE `parentId` = 310100 LIMIT 9 [ RunTime:0.000095s ]
SHOW FULL COLUMNS FROM `tp_system_news_cate` [ RunTime:0.000447s ]
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.000116s ]
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.000097s ]
SELECT * FROM `tp_region_list` WHERE `substation_status` = 1 AND `recommond_status` = 1 ORDER BY `id` ASC LIMIT 30 [ RunTime:0.000110s ]
