SHOW FULL COLUMNS FROM `tab_promote_union` [ RunTime:0.000356s ]
SELECT * FROM `tab_promote_union` WHERE `domain_url` IN ('agent.teamshark.net','http://agent.teamshark.net','https://agent.teamshark.net') LIMIT 1 [ RunTime:0.000136s ]
SHOW FULL COLUMNS FROM `tab_user_config` [ RunTime:0.000161s ]
SELECT `name`,`status` FROM `tab_user_config` WHERE `name` IN ('qq_login','weixin_login') [ RunTime:0.000110s ]
SHOW FULL COLUMNS FROM `tab_seo` [ RunTime:0.000140s ]
SELECT `seo_title`,`seo_keyword`,`seo_description`,`name` FROM `tab_seo` WHERE `name` LIKE 'media_%' [ RunTime:0.000113s ]
SHOW FULL COLUMNS FROM `sys_portal_post` [ RunTime:0.000179s ]
SELECT * FROM `sys_portal_post` WHERE `id` IN ('16','27') ORDER BY `id` DESC [ RunTime:0.000146s ]
SHOW FULL COLUMNS FROM `tab_links` [ RunTime:0.000155s ]
SELECT `title`,`link_url` FROM `tab_links` WHERE `status` = 1 [ RunTime:0.000083s ]
SHOW FULL COLUMNS FROM `tab_adv` [ RunTime:0.000158s ]
SHOW FULL COLUMNS FROM `tab_adv_pos` [ RunTime:0.000142s ]
SELECT * FROM `tab_adv_pos` WHERE `name` = 'slider_media' LIMIT 1 [ RunTime:0.000112s ]
SELECT `title`,`data`,`url`,`target`,`icon`,`type`,`game_id` FROM `tab_adv` WHERE `pos_id` = 1 AND ( `start_time` = < OR `start_time` = 0 ) AND ( `end_time` = > OR `end_time` = 0 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000134s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sys_portal_post` `a` INNER JOIN `sys_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= '0' AND ( `a`.`start_time` < '1772281001' OR `a`.`start_time` = '0' ) AND ( `a`.`end_time` > '1772281001' OR `a`.`end_time` = '0' ) AND `a`.`delete_time` = '0' AND ( `b`.`category_id` = '4' AND `a`.`website` IN ('1','3','5','7','9') AND `a`.`post_status` = '1' AND `a`.`post_type` = '1' ) GROUP BY `a`.`id` ) `_group_count_` [ RunTime:0.000186s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sys_portal_post` `a` INNER JOIN `sys_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= '0' AND ( `a`.`start_time` < '1772281001' OR `a`.`start_time` = '0' ) AND ( `a`.`end_time` > '1772281001' OR `a`.`end_time` = '0' ) AND `a`.`delete_time` = '0' AND ( `b`.`category_id` = '3' AND `a`.`website` IN ('1','3','5','7','9') AND `a`.`post_status` = '1' AND `a`.`post_type` = '1' ) GROUP BY `a`.`id` ) `_group_count_` [ RunTime:0.000155s ]
SHOW FULL COLUMNS FROM `tab_game` [ RunTime:0.000264s ]
SELECT count(id) as sdk_count,relation_game_id as id,relation_game_id,relation_game_name as game_name,cover,hot_cover,features,icon,game_type_name,game_score,sdk_version,game_size,game_address_size,down_port,dow_num FROM `tab_game` WHERE `recommend_status` LIKE '%1%' AND `sdk_version` IN (1,2) AND `game_status` = 1 GROUP BY `relation_game_id` ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.000170s ]
SELECT count(id) as sdk_count,relation_game_id as id,relation_game_id,relation_game_name as game_name,cover,hot_cover,features,icon,game_type_name,game_score,sdk_version,game_size,game_address_size,down_port,dow_num FROM `tab_game` WHERE `recommend_status` LIKE '%1%' AND `sdk_version` = 3 AND `game_status` = 1 GROUP BY `relation_game_id` ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.000144s ]
SELECT count(id) as sdk_count,relation_game_id as id,relation_game_id,relation_game_name as game_name,cover,hot_cover,features,icon,game_type_name,game_score,sdk_version,game_size,game_address_size,down_port,dow_num FROM `tab_game` WHERE `recommend_status` LIKE '%1%' AND `sdk_version` = 4 AND `game_status` = 1 GROUP BY `relation_game_id` ORDER BY `sort` DESC,`id` DESC LIMIT 4 [ RunTime:0.000138s ]
SELECT count(id) as sdk_count,relation_game_id as id,relation_game_id,relation_game_name as game_name,cover,hot_cover,features,icon,game_type_name,game_score,sdk_version,game_size,game_address_size,down_port,dow_num FROM `tab_game` WHERE `recommend_status` LIKE '%2%' AND `sdk_version` IN (1,2) AND `game_status` = 1 GROUP BY `relation_game_id` ORDER BY `sort` DESC,`id` DESC LIMIT 11 [ RunTime:0.000141s ]
SELECT count(id) as sdk_count,relation_game_id as id,relation_game_id,relation_game_name as game_name,cover,hot_cover,features,icon,game_type_name,game_score,sdk_version,game_size,game_address_size,down_port,dow_num FROM `tab_game` WHERE `recommend_status` LIKE '%2%' AND `sdk_version` = 3 AND `game_status` = 1 GROUP BY `relation_game_id` ORDER BY `sort` DESC,`id` DESC LIMIT 11 [ RunTime:0.000128s ]
SELECT count(id) as sdk_count,relation_game_id as id,relation_game_id,relation_game_name as game_name,cover,hot_cover,features,icon,game_type_name,game_score,sdk_version,game_size,game_address_size,down_port,dow_num FROM `tab_game` WHERE `recommend_status` LIKE '%2%' AND `sdk_version` = 4 AND `game_status` = 1 GROUP BY `relation_game_id` ORDER BY `sort` DESC,`id` DESC LIMIT 11 [ RunTime:0.000125s ]
SHOW FULL COLUMNS FROM `tab_game_server` [ RunTime:0.000154s ]
SELECT `id` FROM `tab_game` WHERE `game_status` = 1 AND `dow_status` = 1 [ RunTime:0.000094s ]
SELECT `game_id`,`game_name`,`server_name`,`start_time`,`relation_game_id` FROM `tab_game_server` `s` INNER JOIN `tab_game` `g` ON `g`.`id`=`s`.`game_id` WHERE `status` = 1 AND `g`.`game_status` = '1' AND `start_time` BETWEEN 1772208000 AND 1772294400 AND `game_id` IN (1,2) AND `g`.`sdk_version` IN ('1','2') ORDER BY `start_time` ASC LIMIT 80 [ RunTime:0.000145s ]
SELECT `game_id`,`game_name`,`server_name`,`start_time`,`relation_game_id` FROM `tab_game_server` `s` INNER JOIN `tab_game` `g` ON `g`.`id`=`s`.`game_id` WHERE `status` = 1 AND `g`.`game_status` = '1' AND `start_time` BETWEEN 1772294400 AND 1772899199 AND `game_id` IN (1,2) AND `g`.`sdk_version` IN ('1','2') ORDER BY `start_time` ASC LIMIT 80 [ RunTime:0.000133s ]
SELECT `game_id`,`game_name`,`server_name`,`start_time`,`relation_game_id` FROM `tab_game_server` `s` INNER JOIN `tab_game` `g` ON `g`.`id`=`s`.`game_id` WHERE `status` = 1 AND `g`.`game_status` = '1' AND `start_time` BETWEEN 1771603200 AND 1772207999 AND `game_id` IN (1,2) AND `g`.`sdk_version` IN ('1','2') ORDER BY `start_time` DESC LIMIT 80 [ RunTime:0.000129s ]
SELECT `game_id`,`game_name`,`server_name`,`start_time`,`relation_game_id` FROM `tab_game_server` `s` INNER JOIN `tab_game` `g` ON `g`.`id`=`s`.`game_id` WHERE `status` = 1 AND `g`.`game_status` = '1' AND `start_time` BETWEEN 1772208000 AND 1772294400 AND `game_id` IN (1,2) AND `g`.`sdk_version` = '3' ORDER BY `start_time` ASC LIMIT 80 [ RunTime:0.000127s ]
SELECT `game_id`,`game_name`,`server_name`,`start_time`,`relation_game_id` FROM `tab_game_server` `s` INNER JOIN `tab_game` `g` ON `g`.`id`=`s`.`game_id` WHERE `status` = 1 AND `g`.`game_status` = '1' AND `start_time` BETWEEN 1772294400 AND 1772899199 AND `game_id` IN (1,2) AND `g`.`sdk_version` = '3' ORDER BY `start_time` ASC LIMIT 80 [ RunTime:0.000125s ]
SELECT `game_id`,`game_name`,`server_name`,`start_time`,`relation_game_id` FROM `tab_game_server` `s` INNER JOIN `tab_game` `g` ON `g`.`id`=`s`.`game_id` WHERE `status` = 1 AND `g`.`game_status` = '1' AND `start_time` BETWEEN 1771603200 AND 1772207999 AND `game_id` IN (1,2) AND `g`.`sdk_version` = '3' ORDER BY `start_time` DESC LIMIT 80 [ RunTime:0.000128s ]
SELECT `game_id`,`game_name`,`server_name`,`start_time`,`relation_game_id` FROM `tab_game_server` `s` INNER JOIN `tab_game` `g` ON `g`.`id`=`s`.`game_id` WHERE `status` = 1 AND `g`.`game_status` = '1' AND `start_time` BETWEEN 1772208000 AND 1772294400 AND `game_id` IN (1,2) AND `g`.`sdk_version` = '4' ORDER BY `start_time` ASC LIMIT 80 [ RunTime:0.000126s ]
SELECT `game_id`,`game_name`,`server_name`,`start_time`,`relation_game_id` FROM `tab_game_server` `s` INNER JOIN `tab_game` `g` ON `g`.`id`=`s`.`game_id` WHERE `status` = 1 AND `g`.`game_status` = '1' AND `start_time` BETWEEN 1772294400 AND 1772899199 AND `game_id` IN (1,2) AND `g`.`sdk_version` = '4' ORDER BY `start_time` ASC LIMIT 80 [ RunTime:0.000122s ]
SELECT `game_id`,`game_name`,`server_name`,`start_time`,`relation_game_id` FROM `tab_game_server` `s` INNER JOIN `tab_game` `g` ON `g`.`id`=`s`.`game_id` WHERE `status` = 1 AND `g`.`game_status` = '1' AND `start_time` BETWEEN 1771603200 AND 1772207999 AND `game_id` IN (1,2) AND `g`.`sdk_version` = '4' ORDER BY `start_time` DESC LIMIT 80 [ RunTime:0.000121s ]
SHOW FULL COLUMNS FROM `tab_game_giftbag` [ RunTime:0.000177s ]
SELECT `gb`.`game_id`,g.relation_game_name as game_name,gb.id as gift_id,`gb`.`start_time`,`gb`.`end_time`,`gb`.`giftbag_version`,`gb`.`giftbag_name`,`g`.`icon`,`gb`.`novice_num`,`gb`.`remain_num`,`gb`.`digest`,`g`.`relation_game_name`,`gb`.`desribe`,`vip` FROM `tab_game_giftbag` `gb` LEFT JOIN `tab_game` `g` ON `g`.`id`=`gb`.`game_id` WHERE `gb`.`remain_num` > '0' AND `gb`.`status` = '1' AND ( `gb`.`start_time` < '1772281001' OR `gb`.`start_time` = '0' ) AND ( `gb`.`end_time` > '1772281001' OR `gb`.`end_time` = '0' ) ORDER BY `gb`.`create_time` DESC,`gb`.`id` DESC LIMIT 16 [ RunTime:0.000170s ]
SHOW FULL COLUMNS FROM `tab_game_gift_record` [ RunTime:0.000163s ]
SELECT `and_dow_address`,`ios_dow_plist`,`add_game_address`,`ios_game_address`,`down_port` FROM `tab_game` WHERE `game_status` = 1 AND `dow_status` = 1 AND `relation_game_id` = 1 AND `sdk_version` = 1 LIMIT 1 [ RunTime:0.000121s ]
SELECT `and_dow_address`,`ios_dow_plist`,`add_game_address`,`ios_game_address`,`down_port` FROM `tab_game` WHERE `game_status` = 1 AND `dow_status` = 1 AND `relation_game_id` = 1 AND `sdk_version` = 2 LIMIT 1 [ RunTime:0.000102s ]
SELECT * FROM `tab_user_config` WHERE `name` = 'age' LIMIT 1 [ RunTime:0.000093s ]
SELECT * FROM `tab_user_config` WHERE `name` = 'age' LIMIT 1 [ RunTime:0.000083s ]
SELECT * FROM `tab_user_config` WHERE `name` = 'age' LIMIT 1 [ RunTime:0.000084s ]
SHOW FULL COLUMNS FROM `sys_option` [ RunTime:0.000141s ]
SELECT `option_value` FROM `sys_option` WHERE `option_name` = 'kefu_set' LIMIT 1 [ RunTime:0.000084s ]
SELECT * FROM `tab_user_config` WHERE `name` = 'age' LIMIT 1 [ RunTime:0.000083s ]