SHOW FULL COLUMNS FROM `site_comm_menu` [ RunTime:0.001382s ]
SELECT `id`,`cname`,`name`,`color_value` FROM `site_comm_menu` WHERE ( `delete_time` = 0 AND `status` = 1 AND `type` = 1 ) ORDER BY `sort` [ RunTime:0.000703s ]
SELECT `id`,`cname`,`name`,`path_url`,`path_type`,`group_name`,`cate_name`,`is_focus`,`css`,`icon_emoji`,`color_value`,`tips` FROM `site_comm_menu` WHERE ( `delete_time` = 0 AND `status` = 1 AND `type` = 2 ) ORDER BY `group_name`,`sort` [ RunTime:0.000749s ]
SHOW FULL COLUMNS FROM `site_comm_page_param` [ RunTime:0.001261s ]
SELECT `cname`,`value`,`name` FROM `site_comm_page_param` ORDER BY `name`,`id` [ RunTime:0.000632s ]
SHOW FULL COLUMNS FROM `supo_conf_enum` [ RunTime:0.001387s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '122' LIMIT 1 [ RunTime:0.000894s ]
SELECT `id`,`enum_title`,`enum_code`,`enum_name`,`enum_type`,`cat_name`,`pid`,`sort`,`is_hide`,`extra_css`,`extra_color`,`extra_img`,`extra_attr_1`,`extra_attr_2`,`extra_attr_3`,`extra_attr_4` FROM `supo_conf_enum` WHERE ( `delete_time` = 0 AND `enum_type` = 2 AND `status` = 1 AND `is_hide` = 0 AND `pid` = 'A01240307922344042936822' ) ORDER BY `enum_code` [ RunTime:0.000900s ]
SHOW FULL COLUMNS FROM `zata_comm_china_region` [ RunTime:0.001495s ]
SELECT `sn_code`,`cname`,`short_cname`,`map_cover`,`group_code` FROM `zata_comm_china_region` WHERE ( `delete_time` = 0 AND `level` = 1 AND `status` = 1 ) ORDER BY `sn_code` [ RunTime:0.000869s ]
SHOW FULL COLUMNS FROM `pora_mark_class` [ RunTime:0.001284s ]
SELECT `class_code`,`cname` FROM `pora_mark_class` WHERE ( `delete_time` = 0 AND `level` = 2 AND `status` = 1 ) [ RunTime:0.000913s ]
SHOW FULL COLUMNS FROM `data_comm_china_ip` [ RunTime:0.001606s ]
SELECT * FROM `data_comm_china_ip` WHERE ( `delete_time` = 0 AND `ip_sum` = 3628718080 ) LIMIT 1 [ RunTime:0.000747s ]
SELECT `sn_code` FROM `zata_comm_china_region` WHERE ( `delete_time` = 0 AND `full_cname` = '' ) LIMIT 1 [ RunTime:0.084283s ]
SHOW FULL COLUMNS FROM `comu_comm_club` [ RunTime:0.001931s ]
SELECT * FROM `comu_comm_club` WHERE ( `delete_time` = 0 AND `sn` = 100492403 ) LIMIT 1 [ RunTime:0.001354s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '301' LIMIT 1 [ RunTime:0.000743s ]
SELECT `id`,`enum_title`,`enum_code`,`enum_name`,`enum_type`,`cat_name`,`pid`,`sort`,`is_hide`,`extra_css`,`extra_color`,`extra_img`,`extra_attr_1`,`extra_attr_2`,`extra_attr_3`,`extra_attr_4` FROM `supo_conf_enum` WHERE ( `delete_time` = 0 AND `enum_type` = 2 AND `status` = 1 AND `is_hide` = 0 AND `pid` = 'A00001224733116152450230' ) ORDER BY `enum_code` [ RunTime:0.000943s ]
SHOW FULL COLUMNS FROM `pora_comm_client_access` [ RunTime:0.001427s ]
SELECT main_client_id, COUNT(*) AS counter FROM `pora_comm_client_access` WHERE ( `delete_time` = 0 AND `status` = 1 AND `main_client_type_name` = '@club' AND `main_client_id` = 'A01175677163918066736463' AND `vice_client_type_name` = '@topic' ) GROUP BY `main_client_id` [ RunTime:0.001796s ]
SHOW FULL COLUMNS FROM `pora_comm_tag_access` [ RunTime:0.001267s ]
SELECT `id`,`client_id`,`tag_id`,`sign_date`,`access_notice_id` FROM `pora_comm_tag_access` WHERE ( `delete_time` = 0 AND `client_type_name` = '@club' AND `client_id` = 'A01175677163918066736463' ) ORDER BY `sign_date` DESC [ RunTime:0.000669s ]
SELECT COUNT(*) AS think_count FROM `comu_comm_club` WHERE ( `delete_time` = 0 AND `id` = 'A01175677163918066736463' ) [ RunTime:0.000575s ]
SELECT COUNT(*) AS think_count FROM `pora_comm_client_access` `access` INNER JOIN `comu_comm_topic` `topic` ON `access`.`vice_client_id`=`topic`.`id` WHERE ( `access`.`delete_time` = '0' AND `access`.`status` = '1' AND `access`.`main_client_type_name` = '@club' AND `access`.`main_client_id` = 'A01175677163918066736463' AND `access`.`vice_client_type_name` = '@topic' AND `topic`.`delete_time` = '0' AND `topic`.`status` = '1' ) [ RunTime:0.000656s ]
SELECT `topic`.* FROM `pora_comm_client_access` `access` INNER JOIN `comu_comm_topic` `topic` ON `access`.`vice_client_id`=`topic`.`id` WHERE ( `access`.`delete_time` = '0' AND `access`.`status` = '1' AND `access`.`main_client_type_name` = '@club' AND `access`.`main_client_id` = 'A01175677163918066736463' AND `access`.`vice_client_type_name` = '@topic' AND `topic`.`delete_time` = '0' AND `topic`.`status` = '1' ) ORDER BY `topic`.`create_time` DESC,`topic`.`exp_index` DESC,`topic`.`update_time` DESC,`topic`.`sn` LIMIT 0,10 [ RunTime:0.000875s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '303' LIMIT 1 [ RunTime:0.000682s ]
SELECT `id`,`enum_title`,`enum_code`,`enum_name`,`enum_type`,`cat_name`,`pid`,`sort`,`is_hide`,`extra_css`,`extra_color`,`extra_img`,`extra_attr_1`,`extra_attr_2`,`extra_attr_3`,`extra_attr_4` FROM `supo_conf_enum` WHERE ( `delete_time` = 0 AND `enum_type` = 2 AND `status` = 1 AND `is_hide` = 0 AND `pid` = 'A00007442776384447225863' ) ORDER BY `enum_code` [ RunTime:0.000968s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '304' LIMIT 1 [ RunTime:0.000729s ]
SELECT `id`,`enum_title`,`enum_code`,`enum_name`,`enum_type`,`cat_name`,`pid`,`sort`,`is_hide`,`extra_css`,`extra_color`,`extra_img`,`extra_attr_1`,`extra_attr_2`,`extra_attr_3`,`extra_attr_4` FROM `supo_conf_enum` WHERE ( `delete_time` = 0 AND `enum_type` = 2 AND `status` = 1 AND `is_hide` = 0 AND `pid` = 'A00007457527438463262474' ) ORDER BY `enum_code` [ RunTime:0.000941s ]
SHOW FULL COLUMNS FROM `pora_comm_content` [ RunTime:0.001374s ]
SELECT `id`,`access_client_id`,`content` FROM `pora_comm_content` WHERE ( `delete_time` = 0 AND `type_code` = '230110' AND `access_client_type` = '@topic' AND `access_client_id` = 'A00001100000001000159399' ) ORDER BY `access_client_id`,`recom_index` DESC,`create_time`,`id` [ RunTime:0.012665s ]
SHOW FULL COLUMNS FROM `site_mber_member` [ RunTime:0.001633s ]
SELECT * FROM `site_mber_member` WHERE ( `delete_time` = 0 AND `id` = 'A01175956086356403307486' ) [ RunTime:0.000718s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '310' LIMIT 1 [ RunTime:0.000814s ]
SELECT `id`,`enum_title`,`enum_code`,`enum_name`,`enum_type`,`cat_name`,`pid`,`sort`,`is_hide`,`extra_css`,`extra_color`,`extra_img`,`extra_attr_1`,`extra_attr_2`,`extra_attr_3`,`extra_attr_4` FROM `supo_conf_enum` WHERE ( `delete_time` = 0 AND `enum_type` = 2 AND `status` = 1 AND `is_hide` = 0 AND `pid` = 'A01229419164948039789864' ) ORDER BY `enum_code` [ RunTime:0.000926s ]
SELECT access.vice_client_id as topic_id,`club`.`id`,`club`.`sn`,`club`.`cname`,`club`.`cover_path`,`club`.`theme_color` FROM `pora_comm_client_access` `access` INNER JOIN `comu_comm_club` `club` ON `access`.`main_client_id`=`club`.`id` WHERE ( `access`.`delete_time` = '0' AND `access`.`status` = '1' AND `access`.`vice_client_type_name` = '@topic' AND `access`.`vice_client_id` = 'A00001100000001000159399' AND `access`.`main_client_type_name` = '@club' AND `access`.`access_type_code` = '220221' AND `club`.`delete_time` = '0' AND `club`.`status` = '1' ) [ RunTime:0.001105s ]
SELECT `id`,`client_id`,`tag_id`,`sign_date`,`access_notice_id` FROM `pora_comm_tag_access` WHERE ( `delete_time` = 0 AND `client_type_name` = '@topic' AND `client_id` = 'A00001100000001000159399' ) ORDER BY `sign_date` DESC [ RunTime:0.000599s ]
SELECT COUNT(*) AS think_count FROM `comu_comm_club` WHERE ( `delete_time` = 0 AND `id` = 'A01175677163918066736463' ) [ RunTime:0.000534s ]
SELECT COUNT(*) AS think_count FROM `pora_comm_client_access` `access` INNER JOIN `site_mber_member` `member` ON `access`.`vice_client_id`=`member`.`id` WHERE ( `access`.`delete_time` = '0' AND `access`.`status` = '1' AND `access`.`main_client_type_name` = '@club' AND `access`.`vice_client_type_name` = '@member' AND `access_type_code` = '220222' AND `member`.`delete_time` = '0' AND `member`.`status` = '1' ) [ RunTime:0.001025s ]
SELECT `member`.* FROM `pora_comm_client_access` `access` INNER JOIN `site_mber_member` `member` ON `access`.`vice_client_id`=`member`.`id` WHERE ( `access`.`delete_time` = '0' AND `access`.`status` = '1' AND `access`.`main_client_type_name` = '@club' AND `access`.`vice_client_type_name` = '@member' AND `access_type_code` = '220222' AND `member`.`delete_time` = '0' AND `member`.`status` = '1' ) ORDER BY `access`.`create_time`,`access`.`access_refer_time` DESC,`access`.`id` LIMIT 0,8 [ RunTime:0.000813s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '310' LIMIT 1 [ RunTime:0.000840s ]
SELECT `id`,`enum_title`,`enum_code`,`enum_name`,`enum_type`,`cat_name`,`pid`,`sort`,`is_hide`,`extra_css`,`extra_color`,`extra_img`,`extra_attr_1`,`extra_attr_2`,`extra_attr_3`,`extra_attr_4` FROM `supo_conf_enum` WHERE ( `delete_time` = 0 AND `enum_type` = 2 AND `status` = 1 AND `is_hide` = 0 AND `pid` = 'A01229419164948039789864' ) ORDER BY `enum_code` [ RunTime:0.000894s ]
SELECT * FROM `comu_comm_club` WHERE ( `delete_time` = 0 AND `status` = 1 AND `id` <> 'A01175677163918066736463' ) ORDER BY `visit_count` DESC,`recom_index` DESC LIMIT 0,4 [ RunTime:0.001851s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '301' LIMIT 1 [ RunTime:0.000762s ]
SELECT `id`,`enum_title`,`enum_code`,`enum_name`,`enum_type`,`cat_name`,`pid`,`sort`,`is_hide`,`extra_css`,`extra_color`,`extra_img`,`extra_attr_1`,`extra_attr_2`,`extra_attr_3`,`extra_attr_4` FROM `supo_conf_enum` WHERE ( `delete_time` = 0 AND `enum_type` = 2 AND `status` = 1 AND `is_hide` = 0 AND `pid` = 'A00001224733116152450230' ) ORDER BY `enum_code` [ RunTime:0.000935s ]
SELECT main_client_id, COUNT(*) AS counter FROM `pora_comm_client_access` WHERE ( `delete_time` = 0 AND `status` = 1 AND `main_client_type_name` = '@club' AND `main_client_id` IN ('A00009006117519010078275','A00001000000001000000003','A00001000000001000000001','A00001000000001000000002') AND `vice_client_type_name` = '@topic' ) GROUP BY `main_client_id` [ RunTime:0.001630s ]
SELECT `id`,`client_id`,`tag_id`,`sign_date`,`access_notice_id` FROM `pora_comm_tag_access` WHERE ( `delete_time` = 0 AND `client_type_name` = '@club' AND `client_id` IN ('A00009006117519010078275','A00001000000001000000003','A00001000000001000000001','A00001000000001000000002') ) ORDER BY `sign_date` DESC [ RunTime:0.000752s ]
SHOW FULL COLUMNS FROM `comu_comm_topic` [ RunTime:0.001555s ]
SELECT * FROM `comu_comm_topic` WHERE ( `delete_time` = 0 AND `status` = 1 ) ORDER BY `visit_count` DESC,`message_count` DESC LIMIT 0,8 [ RunTime:0.003177s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '303' LIMIT 1 [ RunTime:0.000739s ]
SELECT `id`,`enum_title`,`enum_code`,`enum_name`,`enum_type`,`cat_name`,`pid`,`sort`,`is_hide`,`extra_css`,`extra_color`,`extra_img`,`extra_attr_1`,`extra_attr_2`,`extra_attr_3`,`extra_attr_4` FROM `supo_conf_enum` WHERE ( `delete_time` = 0 AND `enum_type` = 2 AND `status` = 1 AND `is_hide` = 0 AND `pid` = 'A00007442776384447225863' ) ORDER BY `enum_code` [ RunTime:0.000931s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '304' LIMIT 1 [ RunTime:0.000694s ]
SELECT `id`,`enum_title`,`enum_code`,`enum_name`,`enum_type`,`cat_name`,`pid`,`sort`,`is_hide`,`extra_css`,`extra_color`,`extra_img`,`extra_attr_1`,`extra_attr_2`,`extra_attr_3`,`extra_attr_4` FROM `supo_conf_enum` WHERE ( `delete_time` = 0 AND `enum_type` = 2 AND `status` = 1 AND `is_hide` = 0 AND `pid` = 'A00007457527438463262474' ) ORDER BY `enum_code` [ RunTime:0.000879s ]
SELECT `id`,`access_client_id`,`content` FROM `pora_comm_content` WHERE ( `delete_time` = 0 AND `type_code` = '230110' AND `access_client_type` = '@topic' AND `access_client_id` IN ('A01246559329341487667329','A01239654636320158986936','A01229871599703050253199','A01239620674661314596274','A01230068568627757430968','A01244666322285417133922','A01230068830699294263030','A01230068988786827316388') ) ORDER BY `access_client_id`,`recom_index` DESC,`create_time`,`id` [ RunTime:0.012462s ]
SELECT * FROM `site_mber_member` WHERE ( `delete_time` = 0 AND `id` IN ('A01175949922677601931922','A01175956051672321417851','A01175956034366441629534','A00001000000001000000001','A00001000000001000000001','A01175955835285227838435','A01175956076991298997976','A01175956068059655206268') ) [ RunTime:0.000886s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '310' LIMIT 1 [ RunTime:0.000859s ]
SELECT `id`,`enum_title`,`enum_code`,`enum_name`,`enum_type`,`cat_name`,`pid`,`sort`,`is_hide`,`extra_css`,`extra_color`,`extra_img`,`extra_attr_1`,`extra_attr_2`,`extra_attr_3`,`extra_attr_4` FROM `supo_conf_enum` WHERE ( `delete_time` = 0 AND `enum_type` = 2 AND `status` = 1 AND `is_hide` = 0 AND `pid` = 'A01229419164948039789864' ) ORDER BY `enum_code` [ RunTime:0.001036s ]
SELECT access.vice_client_id as topic_id,`club`.`id`,`club`.`sn`,`club`.`cname`,`club`.`cover_path`,`club`.`theme_color` FROM `pora_comm_client_access` `access` INNER JOIN `comu_comm_club` `club` ON `access`.`main_client_id`=`club`.`id` WHERE ( `access`.`delete_time` = '0' AND `access`.`status` = '1' AND `access`.`vice_client_type_name` = '@topic' AND `access`.`vice_client_id` IN ('A01246559329341487667329','A01239654636320158986936','A01229871599703050253199','A01239620674661314596274','A01230068568627757430968','A01244666322285417133922','A01230068830699294263030','A01230068988786827316388') AND `access`.`main_client_type_name` = '@club' AND `access`.`access_type_code` = '220221' AND `club`.`delete_time` = '0' AND `club`.`status` = '1' ) [ RunTime:0.001013s ]
SELECT `id`,`client_id`,`tag_id`,`sign_date`,`access_notice_id` FROM `pora_comm_tag_access` WHERE ( `delete_time` = 0 AND `client_type_name` = '@topic' AND `client_id` IN ('A01246559329341487667329','A01239654636320158986936','A01229871599703050253199','A01239620674661314596274','A01230068568627757430968','A01244666322285417133922','A01230068830699294263030','A01230068988786827316388') ) ORDER BY `sign_date` DESC [ RunTime:0.000792s ]