SHOW FULL COLUMNS FROM `site_comm_menu` [ RunTime:0.003915s ]
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.001041s ]
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.000937s ]
SHOW FULL COLUMNS FROM `site_comm_page_param` [ RunTime:0.001470s ]
SELECT `cname`,`value`,`name` FROM `site_comm_page_param` ORDER BY `name`,`id` [ RunTime:0.000805s ]
SHOW FULL COLUMNS FROM `supo_conf_enum` [ RunTime:0.002656s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '122' LIMIT 1 [ RunTime:0.001394s ]
SELECT `id`,`id_hash`,`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.001302s ]
SHOW FULL COLUMNS FROM `zata_comm_china_region` [ RunTime:0.001891s ]
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.001194s ]
SHOW FULL COLUMNS FROM `pora_mark_class` [ RunTime:0.001650s ]
SELECT `class_code`,`cname` FROM `pora_mark_class` WHERE ( `delete_time` = 0 AND `level` = 2 AND `status` = 1 ) [ RunTime:0.001057s ]
SHOW FULL COLUMNS FROM `data_comm_china_ip` [ RunTime:0.005272s ]
SELECT * FROM `data_comm_china_ip` WHERE ( `delete_time` = 0 AND `ip_sum` = 3628718336 ) LIMIT 1 [ RunTime:0.000837s ]
SELECT `sn_code` FROM `zata_comm_china_region` WHERE ( `delete_time` = 0 AND `full_cname` = 'Arkansas Pulaski' ) LIMIT 1 [ RunTime:0.121577s ]
SELECT `sn_code`,`cname` FROM `zata_comm_china_region` WHERE ( `delete_time` = 0 AND `cname` = 'Arkansas' ) LIMIT 1 [ RunTime:0.126363s ]
SELECT `sn_code`,`cname`,`short_cname`,`full_cname`,`map_cover` FROM `zata_comm_china_region` WHERE ( `delete_time` = 0 AND `sn_code` = '000000000000' ) LIMIT 1 [ RunTime:0.000989s ]
SHOW FULL COLUMNS FROM `pora_farm_farm` [ RunTime:0.002271s ]
SELECT * FROM `pora_farm_farm` WHERE ( `delete_time` = 0 AND `sn` = 135538502 ) LIMIT 1 [ RunTime:0.001144s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '206' LIMIT 1 [ RunTime:0.002065s ]
SELECT `id`,`id_hash`,`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` = 'A00008564277234479432672' ) ORDER BY `enum_code` [ RunTime:0.001451s ]
SHOW FULL COLUMNS FROM `zata_comm_country` [ RunTime:0.002025s ]
SELECT `code`,`cname`,`full_cname`,`flag_cover` FROM `zata_comm_country` WHERE ( `delete_time` = 0 AND `code` = 'CHN' ) [ RunTime:0.000909s ]
SELECT `sn_code`,`cname`,`short_cname`,`full_cname`,`ename`,`level`,`pinyin`,`cate_code`,`map_cover`,`content_feature`,`longitude`,`latitude`,`type`,`signature`,`altitude` FROM `zata_comm_china_region` WHERE ( `delete_time` = 0 AND `sn_code` IN ('210000000000','210300000000','210323000000') ) ORDER BY `sn_code` DESC [ RunTime:0.001041s ]
SHOW FULL COLUMNS FROM `pora_comm_pavilion` [ RunTime:0.003146s ]
SELECT * FROM `pora_comm_pavilion` WHERE ( `delete_time` = 0 AND `status` = 1 AND `type_code` = '202101' AND `com_region_code` IN ('CHN210323000000','CHN210300000000','CHN210000000000','CHN000000000000') ) ORDER BY `com_region_code` DESC [ RunTime:0.006258s ]
SHOW FULL COLUMNS FROM `pora_comm_entity` [ RunTime:0.009835s ]
SELECT `id`,`cname`,`contact_person`,`contact_phone`,`type_code`,`cover_path` FROM `pora_comm_entity` WHERE ( `delete_time` = 0 AND `id` = 'A01214254439615687642639' ) [ RunTime:0.002324s ]
SHOW FULL COLUMNS FROM `pora_farm_farmer` [ RunTime:0.008126s ]
SELECT `mid`,`farm_id`,`team_role_code` FROM `pora_farm_farmer` WHERE ( `delete_time` = 0 AND `status` = 1 AND `farm_id` = 'A01225726801674076481201' AND `mid` <> '' ) ORDER BY `farm_id`,`team_role_code`,`create_time` [ RunTime:0.000960s ]
SHOW FULL COLUMNS FROM `pora_comm_tag_access` [ RunTime:0.001678s ]
SELECT `id`,`client_id`,`tag_id`,`sign_date`,`access_notice_id` FROM `pora_comm_tag_access` WHERE ( `delete_time` = 0 AND `client_type_name` = '@farm' AND `client_id` = 'A01225726801674076481201' ) ORDER BY `sign_date` DESC [ RunTime:0.000775s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '220' LIMIT 1 [ RunTime:0.001089s ]
SELECT `id`,`id_hash`,`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` = 'A01225878420350196467520' ) ORDER BY `enum_code` [ RunTime:0.001339s ]
SELECT COUNT(*) AS think_count FROM `pora_farm_farm` WHERE ( `delete_time` = 0 AND `id` = 'A01225726801674076481201' ) [ RunTime:0.000755s ]
SHOW FULL COLUMNS FROM `pora_comm_client_access` [ RunTime:0.001382s ]
SELECT `access`.`access_type_code`,`access`.`access_refer_time`,`mark`.* FROM `pora_comm_client_access` `access` INNER JOIN `pora_mark_mark` `mark` ON `access`.`main_client_id`=`mark`.`id` WHERE ( `access`.`delete_time` = '0' AND `access`.`status` = '1' AND `access`.`main_client_type_name` = '@mark' AND `access`.`vice_client_type_name` = '@farm' AND `access`.`vice_client_id` = 'A01225726801674076481201' AND `mark`.`delete_time` = '0' AND `mark`.`status` = '1' ) ORDER BY `create_time` DESC LIMIT 0,8 [ RunTime:0.000989s ]
SELECT `code`,`cname`,`full_cname`,`flag_cover` FROM `zata_comm_country` WHERE ( `delete_time` = 0 AND `code` = 'CHN' ) [ RunTime:0.000706s ]
SELECT `sn_code`,`cname`,`short_cname`,`full_cname`,`ename`,`level`,`pinyin`,`cate_code`,`map_cover`,`content_feature`,`longitude`,`latitude`,`type`,`signature`,`altitude` FROM `zata_comm_china_region` WHERE ( `delete_time` = 0 AND `sn_code` IN ('210000000000','210300000000','210323000000') ) ORDER BY `sn_code` DESC [ RunTime:0.000792s ]
SELECT * FROM `pora_comm_pavilion` WHERE ( `delete_time` = 0 AND `status` = 1 AND `com_region_code` IN ('CHN210323000000','CHN210300000000','CHN210000000000','CHN000000000000') ) ORDER BY `com_region_code` DESC [ RunTime:0.003373s ]
SELECT * FROM `pora_comm_pavilion` WHERE ( `delete_time` = 0 AND `status` = 1 AND `class_code` IN ('114-002-001-001','114-002-001-000','114-002-000-000','114-000-000-000') ) ORDER BY `class_code` DESC [ RunTime:0.004024s ]
SELECT `id`,`client_id`,`tag_id`,`sign_date`,`access_notice_id` FROM `pora_comm_tag_access` WHERE ( `delete_time` = 0 AND `client_type_name` = '@mark' AND `client_id` = 'A00005923624079225163140' ) ORDER BY `sign_date` DESC [ RunTime:0.000682s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '216' LIMIT 1 [ RunTime:0.000941s ]
SELECT `id`,`id_hash`,`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` = 'A01236685255074201519255' ) ORDER BY `enum_code` [ RunTime:0.001072s ]
SHOW FULL COLUMNS FROM `pora_mark_mark` [ RunTime:0.002211s ]
SELECT `id`,`sn`,`cname` FROM `pora_mark_mark` WHERE ( `delete_time` = 0 AND `id` = 'A00005923624079225163140' ) [ RunTime:0.000932s ]
SHOW FULL COLUMNS FROM `pora_mark_identify` [ RunTime:0.001584s ]
SELECT * FROM `pora_mark_identify` WHERE ( `delete_time` = 0 AND `unique_token` LIKE '%#0' AND `access_mark_id` = 'A00005923624079225163140' ) ORDER BY `access_mark_id`,`status` DESC,`priority_order`,`check_date`,`identify_date_begin`,`id` [ RunTime:0.000879s ]
SHOW FULL COLUMNS FROM `pora_comm_content` [ RunTime:0.001578s ]
SELECT * FROM `pora_comm_content` WHERE ( `delete_time` = 0 AND `access_client_type` = '@identify' AND `access_client_id` = 'A01244649171943917352971' ) ORDER BY `access_client_id`,`recom_index` DESC,`create_time`,`id` [ RunTime:0.028842s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '230' LIMIT 1 [ RunTime:0.003090s ]
SELECT `id`,`id_hash`,`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` = 'A01249400042469270890542' ) ORDER BY `enum_code` [ RunTime:0.001829s ]
SELECT `id`,`cname`,`contact_person`,`contact_phone`,`type_code`,`cover_path` FROM `pora_comm_entity` WHERE ( `delete_time` = 0 AND `id` IN ('A01236763464830246625564','A01210002478493401417778') ) [ RunTime:0.002593s ]
SHOW FULL COLUMNS FROM `comu_comm_topic` [ RunTime:0.010496s ]
SELECT `id`,`sn`,`cname`,`document_no` FROM `comu_comm_topic` WHERE ( `delete_time` = 0 AND `status` = 1 AND `id` = '' ) [ RunTime:0.000761s ]
SHOW FULL COLUMNS FROM `pora_mark_license` [ RunTime:0.002055s ]
SELECT access_mark_id, identify_type_code, count(id) as counter FROM `pora_mark_license` WHERE ( `delete_time` = 0 AND `unique_token` LIKE '%#0' AND `access_mark_id` = 'A00005923624079225163140' ) GROUP BY `access_mark_id`,`identify_type_code` ORDER BY `access_mark_id`,`identify_type_code` [ RunTime:0.001251s ]
SELECT `class_code`,`cname`,`icon_text` FROM `pora_mark_class` WHERE ( `delete_time` = 0 AND `class_code` = '114-002-001-001' ) [ RunTime:0.002818s ]
SHOW FULL COLUMNS FROM `pora_comm_honor` [ RunTime:0.002142s ]
SELECT * FROM `pora_comm_honor` WHERE ( `delete_time` = 0 AND `client_type_name` = '@farm' AND `client_id` = 'A01225726801674076481201' ) ORDER BY `honor_date` DESC LIMIT 8 [ RunTime:0.001028s ]
SHOW FULL COLUMNS FROM `mall_ware_goods` [ RunTime:0.001984s ]
SELECT COUNT(*) AS think_count FROM `mall_ware_goods` WHERE ( `delete_time` = 0 AND `farm_id` = 'A01225726801674076481201' ) [ RunTime:0.000759s ]
SELECT * FROM `mall_ware_goods` WHERE ( `delete_time` = 0 AND `farm_id` = 'A01225726801674076481201' ) ORDER BY `create_time` DESC,`id` LIMIT 0,3 [ RunTime:0.001536s ]
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` = '@farm' AND `access`.`main_client_id` = 'A01225726801674076481201' AND `access`.`vice_client_type_name` = '@topic' AND `access`.`access_type_code` = '220220' AND `topic`.`delete_time` = '0' AND `topic`.`status` = '1' ) ORDER BY `topic`.`create_time` DESC,`topic`.`exp_index` DESC,`topic`.`create_time` DESC,`topic`.`id` LIMIT 0,5 [ RunTime:0.001145s ]
SELECT * FROM `pora_farm_farm` WHERE ( `delete_time` = 0 AND `status` = 1 ) ORDER BY `visit_count` DESC,`recom_index` DESC LIMIT 0,7 [ RunTime:0.099293s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '206' LIMIT 1 [ RunTime:0.003506s ]
SELECT `id`,`id_hash`,`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` = 'A00008564277234479432672' ) ORDER BY `enum_code` [ RunTime:0.003032s ]
SELECT `code`,`cname`,`full_cname`,`flag_cover` FROM `zata_comm_country` WHERE ( `delete_time` = 0 AND `code` = 'CHN' ) [ RunTime:0.000695s ]
SELECT `sn_code`,`cname`,`short_cname`,`full_cname`,`ename`,`level`,`pinyin`,`cate_code`,`map_cover`,`content_feature`,`longitude`,`latitude`,`type`,`signature`,`altitude` FROM `zata_comm_china_region` WHERE ( `delete_time` = 0 AND `sn_code` IN ('610000000000','610300000000','610326000000','430000000000','430900000000','430923000000','230000000000','230500000000','230524000000','350000000000','350700000000','350703000000','220000000000','222400000000','222404000000','330000000000','330600000000','330624000000','410000000000','411000000000','411082000000') ) ORDER BY `sn_code` DESC [ RunTime:0.001059s ]
SELECT * FROM `pora_comm_pavilion` WHERE ( `delete_time` = 0 AND `status` = 1 AND `type_code` = '202101' AND `com_region_code` IN ('CHN610326000000','CHN610300000000','CHN610000000000','CHN000000000000','CHN430923000000','CHN430900000000','CHN430000000000','CHN230524000000','CHN230500000000','CHN230000000000','CHN350703000000','CHN350700000000','CHN350000000000','CHN222404000000','CHN222400000000','CHN220000000000','CHN330624000000','CHN330600000000','CHN330000000000','CHN411082000000','CHN411000000000','CHN410000000000') ) ORDER BY `com_region_code` DESC [ RunTime:0.003907s ]
SELECT `id`,`cname`,`contact_person`,`contact_phone`,`type_code`,`cover_path` FROM `pora_comm_entity` WHERE ( `delete_time` = 0 AND `id` IN ('A01228549285637798647985','A01231230362471593308462','A01227862725157075355925','A01210235130869616301030','A01230628878531127522978','A01223581432896858394932','A01227862725156116207925') ) [ RunTime:0.000946s ]
SELECT `mid`,`farm_id`,`team_role_code` FROM `pora_farm_farmer` WHERE ( `delete_time` = 0 AND `status` = 1 AND `farm_id` IN ('A00001100000001000186834','A00001100000002000004055','A01227951355759019890155','A00001100000002000009835','A01231317355812639217955','A01179141736877870309236','A01179141736880138396636') AND `mid` <> '' ) ORDER BY `farm_id`,`team_role_code`,`create_time` [ RunTime:0.000942s ]
SHOW FULL COLUMNS FROM `site_mber_member` [ RunTime:0.001929s ]
SELECT `id`,`sn`,`name`,`nickname`,`avatar`,`gender` FROM `site_mber_member` WHERE ( `delete_time` = 0 AND `id` = 'A00006398187623602944476' ) [ RunTime:0.006572s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '223' LIMIT 1 [ RunTime:0.001215s ]
SELECT `id`,`id_hash`,`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` = 'A01248018920311542267320' ) ORDER BY `enum_code` [ RunTime:0.001116s ]
SELECT `id`,`client_id`,`tag_id`,`sign_date`,`access_notice_id` FROM `pora_comm_tag_access` WHERE ( `delete_time` = 0 AND `client_type_name` = '@farm' AND `client_id` IN ('A00001100000001000186834','A00001100000002000004055','A01227951355759019890155','A00001100000002000009835','A01231317355812639217955','A01179141736877870309236','A01179141736880138396636') ) ORDER BY `sign_date` DESC [ RunTime:0.000788s ]
SELECT COUNT(*) AS think_count FROM `pora_farm_farm` WHERE ( `delete_time` = 0 AND `status` = 1 ) [ RunTime:0.034738s ]