SHOW FULL COLUMNS FROM `tp_region_list` [ RunTime:0.000991s ]
SELECT * FROM `tp_region_list` WHERE `pinyin` = 'shanghai' AND `substation_status` = 1 LIMIT 1 [ RunTime:0.000400s ]
SELECT * FROM `tp_region_list` WHERE `parentId` = 310100 [ RunTime:0.002959s ]
SHOW FULL COLUMNS FROM `tp_fields_setting` [ RunTime:0.001035s ]
SELECT `id`,`text` FROM `tp_fields_setting` WHERE `type` = 'shoptag' [ RunTime:0.000241s ]
SHOW FULL COLUMNS FROM `tp_biz` [ RunTime:0.001155s ]
SHOW FULL COLUMNS FROM `tp_biz_region_service` [ RunTime:0.000988s ]
SELECT b.*,
(select count(*) from tp_biz_cases as ca where ca.bid = b.id) as case_count,
(select count(*) from tp_biz_construction as cons where cons.bid = b.id) as construction_count,
(select count(*) from tp_biz_designers as desi where desi.bid = b.id) as designer_count
FROM `tp_biz` `b` WHERE `b`.`id` IN (SELECT `bid` FROM `tp_biz_region_service` WHERE `regionCode` IN (310100,310101,310103,310104,310105,310106,310107,310108,310109,310110,310112,310113,310114,310115,310116,310117,310118,310119,310120)) ORDER BY `b`.`id` DESC LIMIT 10 [ RunTime:0.001459s ]
SHOW FULL COLUMNS FROM `tp_biz_promotion` [ RunTime:0.001000s ]
SELECT * FROM `tp_biz_promotion` WHERE `bid` = 225 AND `effect_time_start` < 1657214697 AND `effect_time_end` > 1657214697 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000271s ]
SELECT * FROM `tp_biz_promotion` WHERE `bid` = 224 AND `effect_time_start` < 1657214697 AND `effect_time_end` > 1657214697 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000264s ]
SELECT * FROM `tp_biz_promotion` WHERE `bid` = 223 AND `effect_time_start` < 1657214697 AND `effect_time_end` > 1657214697 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000261s ]
SELECT * FROM `tp_biz_promotion` WHERE `bid` = 222 AND `effect_time_start` < 1657214697 AND `effect_time_end` > 1657214697 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000250s ]
SELECT * FROM `tp_biz_promotion` WHERE `bid` = 221 AND `effect_time_start` < 1657214697 AND `effect_time_end` > 1657214697 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000283s ]
SELECT * FROM `tp_biz_promotion` WHERE `bid` = 220 AND `effect_time_start` < 1657214697 AND `effect_time_end` > 1657214697 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000270s ]
SELECT * FROM `tp_biz_promotion` WHERE `bid` = 219 AND `effect_time_start` < 1657214697 AND `effect_time_end` > 1657214697 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000244s ]
SELECT * FROM `tp_biz_promotion` WHERE `bid` = 218 AND `effect_time_start` < 1657214697 AND `effect_time_end` > 1657214697 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000267s ]
SELECT * FROM `tp_biz_promotion` WHERE `bid` = 217 AND `effect_time_start` < 1657214697 AND `effect_time_end` > 1657214697 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000260s ]
SELECT * FROM `tp_biz_promotion` WHERE `bid` = 145 AND `effect_time_start` < 1657214697 AND `effect_time_end` > 1657214697 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000267s ]
SHOW FULL COLUMNS FROM `tp_biz_cases_pictures` [ RunTime:0.000912s ]
SELECT `p`.`id`,p.url as picture,`c`.`title`,`c`.`type`,`c`.`huxing`,`c`.`fengge`,`c`.`mianji`,`c`.`gongzhuangkongjian` FROM `tp_biz_cases_pictures` `p` INNER JOIN `tp_biz_cases` `c` ON `c`.`id`=`p`.`case_id` WHERE `p`.`type` <> '1' AND `p`.`status` = '1' GROUP BY `p`.`case_id` ORDER BY `c`.`create_time` DESC,`p`.`id` DESC LIMIT 5 [ RunTime:0.000951s ]
SELECT `text` FROM `tp_fields_setting` WHERE `type` = 'fengge' AND `value` = 11 LIMIT 1 [ RunTime:0.000223s ]
SELECT `text` FROM `tp_fields_setting` WHERE `type` = 'huxing' AND `value` = 7 LIMIT 1 [ RunTime:0.000243s ]
SHOW FULL COLUMNS FROM `tp_system_news_cate` [ RunTime:0.000895s ]
SELECT * FROM `tp_system_news_cate` WHERE `status` = 1 AND `top_cate` = 1 ORDER BY `sort` DESC [ RunTime:0.000401s ]
SELECT * FROM `tp_system_news_cate` WHERE `status` = 1 AND `top_cate` = 2 ORDER BY `sort` DESC [ RunTime:0.000286s ]
SHOW FULL COLUMNS FROM `tp_system_news` [ RunTime:0.001000s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 5 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.005140s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 6 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.004842s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 7 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.004619s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 8 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.004406s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 9 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.003989s ]
SELECT * FROM `tp_system_news_cate` WHERE `status` = 1 AND `top_cate` = 3 ORDER BY `sort` DESC [ RunTime:0.000316s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 10 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.004647s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 11 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.004524s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 12 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.004525s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 13 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.004502s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 14 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.004271s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 15 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.004247s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 16 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.004483s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 17 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.003641s ]
SELECT * FROM `tp_system_news_cate` WHERE `status` = 1 AND `top_cate` = 4 ORDER BY `sort` DESC [ RunTime:0.000295s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 18 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.003717s ]
SELECT `id`,`picture`,`title`,`summary` FROM `tp_system_news` WHERE `status` = 1 AND `cate` = 19 ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.003643s ]
SHOW FULL COLUMNS FROM `tp_system_ads` [ RunTime:0.001189s ]
SELECT * FROM `tp_system_ads` WHERE `cate_id` = 1 AND `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000227s ]
SHOW FULL COLUMNS FROM `tp_site_info` [ RunTime:0.000832s ]
SELECT * FROM `tp_site_info` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000271s ]
SELECT * FROM `tp_region_list` WHERE `parentId` = 0 ORDER BY `initial` ASC,`regionCode` ASC [ RunTime:0.001913s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'fengge' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000234s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'kongjian' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000187s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'huxing' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000175s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'baogongfangshi' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000209s ]
SELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'gongzhuangkongjian' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000208s ]
SELECT regionStr as text,regionCode as value FROM `tp_region_list` WHERE `parentId` = 310100 LIMIT 9 [ RunTime:0.000752s ]
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.000229s ]
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.000195s ]
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.000207s ]
SELECT * FROM `tp_region_list` WHERE `substation_status` = 1 AND `recommond_status` = 1 ORDER BY `id` ASC LIMIT 30 [ RunTime:0.001846s ]