SHOW FULL COLUMNS FROM `pora_mark_mark` [ RunTime:0.002049s ]
SELECT * FROM `pora_mark_mark` WHERE ( `delete_time` = 0 AND `sn` = 200542972 ) LIMIT 1 [ RunTime:0.000869s ]
SHOW FULL COLUMNS FROM `zata_comm_country` [ RunTime:0.001523s ]
SELECT `code`,`cname`,`full_cname`,`flag_cover` FROM `zata_comm_country` WHERE ( `delete_time` = 0 AND `code` = 'CHN' ) [ RunTime:0.000793s ]
SHOW FULL COLUMNS FROM `zata_comm_china_region` [ RunTime:0.001654s ]
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 ('460000000000','469000000000','469002000000') ) ORDER BY `sn_code` DESC [ RunTime:0.000828s ]
SHOW FULL COLUMNS FROM `pora_comm_pavilion` [ RunTime:0.001429s ]
SELECT * FROM `pora_comm_pavilion` WHERE ( `delete_time` = 0 AND `status` = 1 AND `com_region_code` IN ('CHN469002000000','CHN469000000000','CHN460000000000','CHN000000000000') ) ORDER BY `com_region_code` DESC [ RunTime:0.003421s ]
SELECT * FROM `pora_comm_pavilion` WHERE ( `delete_time` = 0 AND `status` = 1 AND `class_code` IN ('111-011-028-000','111-011-000-000','111-000-000-000') ) ORDER BY `class_code` DESC [ RunTime:0.003257s ]
SHOW FULL COLUMNS FROM `pora_comm_tag_access` [ RunTime:0.001390s ]
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` = 'A01229627623373865927623' ) ORDER BY `sign_date` DESC [ RunTime:0.000703s ]
SHOW FULL COLUMNS FROM `supo_conf_enum` [ RunTime:0.001454s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '216' LIMIT 1 [ RunTime:0.001007s ]
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.001048s ]
SELECT `id`,`sn`,`cname` FROM `pora_mark_mark` WHERE ( `delete_time` = 0 AND `id` = 'A01229627623373865927623' ) [ RunTime:0.000605s ]
SHOW FULL COLUMNS FROM `pora_mark_identify` [ RunTime:0.001535s ]
SELECT * FROM `pora_mark_identify` WHERE ( `delete_time` = 0 AND `unique_token` LIKE '%#0' AND `access_mark_id` = 'A01229627623373865927623' ) ORDER BY `access_mark_id`,`status` DESC,`priority_order`,`check_date`,`identify_date_begin`,`id` [ RunTime:0.000819s ]
SHOW FULL COLUMNS FROM `pora_comm_content` [ RunTime:0.001360s ]
SELECT * FROM `pora_comm_content` WHERE ( `delete_time` = 0 AND `access_client_type` = '@identify' AND `access_client_id` = 'A01244650591398773141391' ) ORDER BY `access_client_id`,`recom_index` DESC,`create_time`,`id` [ RunTime:0.015797s ]
SHOW FULL COLUMNS FROM `pora_comm_entity` [ RunTime:0.001625s ]
SELECT `id`,`cname`,`contact_person`,`contact_phone`,`type_code`,`cover_path` FROM `pora_comm_entity` WHERE ( `delete_time` = 0 AND `id` IN ('A01236252375492768684675','A01236339496004678950996') ) [ RunTime:0.000757s ]
SHOW FULL COLUMNS FROM `comu_comm_topic` [ RunTime:0.001469s ]
SELECT `id`,`sn`,`cname`,`document_no` FROM `comu_comm_topic` WHERE ( `delete_time` = 0 AND `status` = 1 AND `id` = 'A01229871599703064657199' ) [ RunTime:0.000626s ]
SHOW FULL COLUMNS FROM `pora_mark_license` [ RunTime:0.001471s ]
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` = 'A01229627623373865927623' ) GROUP BY `access_mark_id`,`identify_type_code` ORDER BY `access_mark_id`,`identify_type_code` [ RunTime:0.000844s ]
SHOW FULL COLUMNS FROM `pora_mark_class` [ RunTime:0.001287s ]
SELECT `class_code`,`cname`,`icon_text` FROM `pora_mark_class` WHERE ( `delete_time` = 0 AND `class_code` = '111-011-028-000' ) [ RunTime:0.000917s ]
SELECT `code`,`cname`,`full_cname`,`flag_cover` FROM `zata_comm_country` WHERE ( `delete_time` = 0 AND `code` = 'CHN' ) [ RunTime:0.000660s ]
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 ('460000000000','469000000000','469002000000') ) ORDER BY `sn_code` DESC [ RunTime:0.000795s ]
SELECT COUNT(*) AS think_count FROM `pora_mark_license` WHERE ( `delete_time` = 0 AND `status` = 1 AND `unique_token` LIKE '%#0' AND `access_mark_id` = 'A01229627623373865927623' ) [ RunTime:0.000749s ]
SELECT * FROM `pora_mark_license` WHERE ( `delete_time` = 0 AND `status` = 1 AND `unique_token` LIKE '%#0' AND `access_mark_id` = 'A01229627623373865927623' ) ORDER BY `check_date` DESC,`create_time` DESC,`id` LIMIT 0,12 [ RunTime:0.000726s ]
SELECT * FROM `supo_conf_enum` WHERE `delete_time` = 0 AND `enum_code` = '216' LIMIT 1 [ RunTime:0.000995s ]
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.001079s ]
SELECT `id`,`cname`,`short_cname`,`uscc`,`com_region_code`,`contact_person`,`contact_phone`,`cover_path`,`business_scope` FROM `pora_comm_entity` WHERE ( `delete_time` = 0 AND `id` IN ('A01229676979647063272579','A01236252375492768684675','A01229676979647065605079') ) [ RunTime:0.000716s ]
SHOW FULL COLUMNS FROM `pora_farm_farm` [ RunTime:0.001468s ]
SELECT `id`,`sn`,`cname`,`cover_path`,`entity_id`,`com_region_code`,`signature` FROM `pora_farm_farm` WHERE ( `delete_time` = 0 AND `status` = 1 AND `entity_id` IN ('A01229676979647063272579','A01236252375492768684675','A01229676979647065605079') ) [ RunTime:0.052118s ]
SELECT `id`,`sn`,`cname`,`cover_path`,`com_region_code` FROM `pora_mark_mark` WHERE ( `delete_time` = 0 AND `status` = 1 AND `id` = 'A01229627623373865927623' ) [ RunTime:0.000611s ]
SELECT `code`,`cname`,`full_cname`,`flag_cover` FROM `zata_comm_country` WHERE ( `delete_time` = 0 AND `code` = 'CHN' ) [ RunTime:0.000642s ]
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 ('460000000000','469000000000','469002000000','110000000000','110100000000','110105000000') ) ORDER BY `sn_code` DESC [ RunTime:0.000856s ]
SELECT `id`,`sn`,`cname`,`document_no` FROM `comu_comm_topic` WHERE ( `delete_time` = 0 AND `status` = 1 AND `id` = 'A01229871599703064657199' ) [ RunTime:0.000597s ]