[ DB ] CONNECT:[ UseTime:0.000410s ] mysql:host=127.0.0.1;port=3306;dbname=db_sdk;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `h_option` [ RunTime:0.001697s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `h_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000238s ]
[ SQL ] SHOW COLUMNS FROM `h_posts` [ RunTime:0.000953s ]
[ SQL ] SELECT `id` AS `news_id`,`post_title` AS `title`,`post_excerpt` AS `excerpt`,`app_id` AS `game_id`,`published_time` AS `pub_time`,`more` AS `more`,`post_type` AS `type`,`post_type` AS `post_type`,`start_time` AS `start_time`,`end_time` AS `end_time`,`url` AS `url`,`cost_integral` AS `cost_integral`,`post_content` AS `content`,`post_status` AS `status` FROM `h_posts` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000582s ]
[ SQL ] SELECT `id`,post_title as title FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND ( `published_time` BETWEEN 1 AND 1714391344 AND `published_time` > 1600182827 ) AND `post_type` IN (3) ORDER BY `published_time` ASC LIMIT 1 [ RunTime:0.000493s ]
[ SQL ] SELECT `id`,post_title as title FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND ( `published_time` BETWEEN 1 AND 1714391344 AND `published_time` < 1600182827 ) AND `post_type` IN (3) ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000372s ]
[ SQL ] SHOW COLUMNS FROM `h_game` [ RunTime:0.000955s ]
[ SQL ] SELECT * FROM `h_game` WHERE `id` = 6023 LIMIT 1 [ RunTime:0.000288s ]
[ SQL ] SHOW COLUMNS FROM `h_game_ext` [ RunTime:0.000774s ]
[ SQL ] SELECT * FROM `h_game_ext` WHERE `app_id` = 6023 LIMIT 1 [ RunTime:0.000298s ]
[ SQL ] SHOW COLUMNS FROM `h_game_version` [ RunTime:0.000666s ]
[ SQL ] SELECT * FROM `h_game_version` WHERE `is_delete` = 2 AND `delete_time` = 0 AND ( `is_default` = 2 AND `is_default` = 2 ) AND `app_id` = 6023 LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SHOW COLUMNS FROM `h_game_qq` [ RunTime:0.000650s ]
[ SQL ] SELECT SUM(mem_cnt) AS tp_sum FROM `h_game_qq` WHERE `delete_time` = 0 AND `is_delete` = 2 AND `app_id` = 6023 LIMIT 1 [ RunTime:0.000172s ]
[ SQL ] SHOW COLUMNS FROM `h_gift` [ RunTime:0.000744s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `h_gift` WHERE `is_delete` = 2 AND `app_id` = 6023 AND `remain_cnt` > 0 AND `end_time` > 1714391344 LIMIT 1 [ RunTime:0.000307s ]
[ SQL ] SELECT `id` AS `gift_id`,`app_id` AS `game_id`,`title` AS `title`,`total_cnt` AS `total_cnt`,`remain_cnt` AS `remain_cnt`,`content` AS `content`,`start_time` AS `start_time`,`end_time` AS `end_time`,`dead_time` AS `dead_time`,`scope` AS `scope`,`func` AS `func`,`condition` AS `condition`,`need_vip` AS `need_vip`,`is_hot` AS `is_hot`,`is_luxury` AS `is_luxury`,`is_rmd` AS `is_rmd`,`hits_cnt` AS `hits_cnt`,`qq_id` AS `qq_id` FROM `h_gift` WHERE `is_delete` = 2 AND `app_id` = 6023 AND `remain_cnt` > 0 AND `end_time` > 1714391344 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.000329s ]
[ SQL ] SELECT * FROM `h_game` WHERE `id` = 6023 LIMIT 1 [ RunTime:0.000236s ]
[ SQL ] SELECT * FROM `h_game_ext` WHERE `app_id` = 6023 LIMIT 1 [ RunTime:0.000210s ]
[ SQL ] SELECT * FROM `h_game_version` WHERE `is_delete` = 2 AND `delete_time` = 0 AND ( `is_default` = 2 AND `is_default` = 2 ) AND `app_id` = 6023 LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SHOW COLUMNS FROM `h_game_rate` [ RunTime:0.000670s ]
[ SQL ] SELECT * FROM `h_game_rate` WHERE `app_id` = 6023 LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] SELECT * FROM `h_game` WHERE `id` = 6023 LIMIT 1 [ RunTime:0.000232s ]
[ SQL ] SELECT * FROM `h_game_ext` WHERE `app_id` = 6023 LIMIT 1 [ RunTime:0.000185s ]
[ SQL ] SELECT * FROM `h_game_version` WHERE `is_delete` = 2 AND `delete_time` = 0 AND ( `is_default` = 2 AND `is_default` = 2 ) AND `app_id` = 6023 LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT * FROM `h_game` WHERE `id` = 6023 LIMIT 1 [ RunTime:0.000215s ]
[ SQL ] SELECT * FROM `h_game_ext` WHERE `app_id` = 6023 LIMIT 1 [ RunTime:0.000179s ]
[ SQL ] SELECT * FROM `h_game_version` WHERE `is_delete` = 2 AND `delete_time` = 0 AND ( `is_default` = 2 AND `is_default` = 2 ) AND `app_id` = 6023 LIMIT 1 [ RunTime:0.000177s ]
[ SQL ] SELECT `id` AS `news_id`,`post_title` AS `title`,`post_type` AS `type` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1714391344 AND `post_type` IN (1,3,2,4) ORDER BY `published_time` DESC LIMIT 5 [ RunTime:0.001282s ]
[ SQL ] SHOW COLUMNS FROM `h_game_category` [ RunTime:0.000673s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game_category` `gamecategory_model` INNER JOIN `h_game` `joingame` ON `gamecategory_model`.`app_id`=`joingame`.`id` WHERE `cate_id` = 45 AND `joingame`.`status` = 2 LIMIT 1 [ RunTime:0.000203s ]
[ SQL ] SELECT `gamecategory_model`.`id`,`gamecategory_model`.`cate_id`,`gamecategory_model`.`app_id`,`gamecategory_model`.`list_order`,`gamecategory_model`.`find_time`,joingame.id AS joingame__id,joingame.name AS joingame__name,joingame.en_name AS joingame__en_name,joingame.en_abbr AS joingame__en_abbr,joingame.app_key AS joingame__app_key,joingame.tags AS joingame__tags,joingame.category AS joingame__category,joingame.classify AS joingame__classify,joingame.icon AS joingame__icon,joingame.cp_payback_url AS joingame__cp_payback_url,joingame.cp_id AS joingame__cp_id,joingame.parent_id AS joingame__parent_id,joingame.package_name AS joingame__package_name,joingame.pay_switch AS joingame__pay_switch,joingame.logo_is_show AS joingame__logo_is_show,joingame.float_is_show AS joingame__float_is_show,joingame.status AS joingame__status,joingame.is_delete AS joingame__is_delete,joingame.delete_time AS joingame__delete_time,joingame.is_online AS joingame__is_online,joingame.is_sdk AS joingame__is_sdk,joingame.is_bt AS joingame__is_bt,joingame.is_auth AS joingame__is_auth,joingame.list_order AS joingame__list_order,joingame.rise_order AS joingame__rise_order,joingame.hot_order AS joingame__hot_order,joingame.like_order AS joingame__like_order,joingame.fine_order AS joingame__fine_order,joingame.publicity AS joingame__publicity,joingame.language AS joingame__language,joingame.description AS joingame__description,joingame.image AS joingame__image,joingame.run_time AS joingame__run_time,joingame.create_time AS joingame__create_time,joingame.update_time AS joingame__update_time,joingame.promote_switch AS joingame__promote_switch,joingame.apple_id AS joingame__apple_id,joingame.add_cp_time AS joingame__add_cp_time,joingame.single_tag AS joingame__single_tag,joingame.ext_info AS joingame__ext_info,joingame.default_lang_code AS joingame__default_lang_code,joingame.mg_parent_id AS joingame__mg_parent_id,joingame.recycle_rate AS joingame__recycle_rate FROM `h_game_category` `gamecategory_model` INNER JOIN `h_game` `joingame` ON `gamecategory_model`.`app_id`=`joingame`.`id` WHERE `cate_id` = 45 AND `joingame`.`status` = 2 ORDER BY `list_order` DESC LIMIT 0,3 [ RunTime:0.000341s ]
[ SQL ] SELECT * FROM `h_game` WHERE `id` = 6131 LIMIT 1 [ RunTime:0.000241s ]
[ SQL ] SELECT * FROM `h_game_version` WHERE `is_delete` = 2 AND `delete_time` = 0 AND ( `is_default` = 2 AND `is_default` = 2 ) AND `app_id` = 6131 LIMIT 1 [ RunTime:0.000223s ]
[ SQL ] SELECT * FROM `h_game` WHERE `id` = 6028 LIMIT 1 [ RunTime:0.000205s ]
[ SQL ] SELECT * FROM `h_game_version` WHERE `is_delete` = 2 AND `delete_time` = 0 AND ( `is_default` = 2 AND `is_default` = 2 ) AND `app_id` = 6028 LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] UPDATE `h_posts` SET `post_hits`=`post_hits`+1 WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1714391344 AND `id` = 24 [ RunTime:0.000417s ]
[ SQL ] SHOW COLUMNS FROM `h_theme_file` [ RunTime:0.000675s ]
[ SQL ] SELECT `more` FROM `h_theme_file` WHERE `theme` = 'web2' AND ( `is_public` = 1 OR `file` = 'pc/news/detail' ) [ RunTime:0.000175s ]