[ DB ] CONNECT:[ UseTime:0.001081s ] mysql:host=localhost;dbname=www_556i_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `sq_gameclass` [ RunTime:0.001520s ]
[ SQL ] SELECT `id`,`category_name`,`category_icon`,`category_desc`,`create_time` FROM `sq_gameclass` ORDER BY `create_time` DESC [ RunTime:0.000559s ]
[ SQL ] SHOW COLUMNS FROM `sq_games` [ RunTime:0.001317s ]
[ SQL ] SELECT * FROM `sq_games` WHERE `audit` = 'true' ORDER BY `download_count` DESC LIMIT 10 [ RunTime:0.001220s ]
[ SQL ] SELECT * FROM `sq_gameclass` WHERE `id` = 1 [ RunTime:0.000435s ]
[ SQL ] SHOW COLUMNS FROM `sq_user` [ RunTime:0.001092s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 [ RunTime:0.000643s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `banned` = 'true' AND `ip` = '216.73.216.116' LIMIT 1 [ RunTime:0.003410s ]
[ SQL ] SHOW COLUMNS FROM `sq_app` [ RunTime:0.001715s ]
[ SQL ] SELECT * FROM `sq_app` WHERE `key` = 'app_site_status' LIMIT 1 [ RunTime:0.000749s ]
[ SQL ] SHOW COLUMNS FROM `sq_lunbo` [ RunTime:0.000794s ]
[ SQL ] SELECT * FROM `sq_lunbo` WHERE `ads_show` = 5 ORDER BY `id` DESC [ RunTime:0.000703s ]
[ SQL ] SELECT `g`.*,`gc`.`category_name`,gc.id as category_id FROM `sq_games` `g` LEFT JOIN `sq_gameclass` `gc` ON `g`.`class_id`=`gc`.`id` WHERE `g`.`id` = '803' LIMIT 1 [ RunTime:0.001137s ]
[ SQL ] SHOW COLUMNS FROM `sq_useronline` [ RunTime:0.001150s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_useronline` WHERE `update_time` > '2025-09-07 21:27:29' [ RunTime:0.000462s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_user` WHERE `creattime` >= '2025-09-07 00:00:00' [ RunTime:0.001313s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_user` WHERE `last_login_time` >= '2025-09-07 00:00:00' [ RunTime:0.000918s ]
[ SQL ] SELECT `u`.`id`,`u`.`username`,`u`.`nickname`,`u`.`usertx`,`u`.`last_login_time`,`u`.`admin`,`u`.`viptime`,uo.update_time as online_time FROM `sq_user` `u` LEFT JOIN `sq_useronline` `uo` ON `u`.`id`=`uo`.`uid` WHERE `u`.`banned` = 'false' AND `u`.`last_login_time` > '1970-01-01 00:00:00' AND `uo`.`update_time` > '2025-09-07 21:27:29' ORDER BY `uo`.`update_time` DESC LIMIT 5 [ RunTime:0.000848s ]
[ SQL ] SELECT `u`.`id`,`u`.`username`,`u`.`nickname`,`u`.`usertx`,`u`.`last_login_time`,`u`.`admin`,`u`.`viptime`,uo.update_time as online_time FROM `sq_user` `u` LEFT JOIN `sq_useronline` `uo` ON `u`.`id`=`uo`.`uid` WHERE `u`.`banned` = 'false' AND `u`.`last_login_time` > '1970-01-01 00:00:00' AND `u`.`id` <> 1 AND ( `uo`.`update_time` IS NULL OR `uo`.`update_time` <= '2025-09-07 21:27:29' ) ORDER BY `u`.`last_login_time` DESC LIMIT 4 [ RunTime:0.002042s ]
[ SQL ] SELECT `g`.*,`gc`.`category_name`,`gc`.`category_desc`,`u`.`username`,`u`.`nickname`,`u`.`usertx`,`u`.`signature`,`u`.`qq`,`u`.`useremail`,`u`.`titleid`,`u`.`creattime` FROM `sq_games` `g` LEFT JOIN `sq_gameclass` `gc` ON `g`.`class_id`=`gc`.`id` LEFT JOIN `sq_user` `u` ON `g`.`uid`=`u`.`id` WHERE `g`.`id` = '803' AND `g`.`audit` = 'true' LIMIT 1 [ RunTime:0.001354s ]
[ SQL ] UPDATE `sq_games` SET `view_count` = `view_count` + 1 WHERE `id` = 803 [ RunTime:0.004013s ]
[ SQL ] SHOW COLUMNS FROM `sq_title` [ RunTime:0.000997s ]
[ SQL ] SELECT `id`,`title`,`icon` FROM `sq_title` WHERE `id` IN (2,4,5,6,9,10,11) [ RunTime:0.000499s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_games` WHERE `uid` = 1 AND `audit` = 'true' [ RunTime:0.023202s ]
[ SQL ] SELECT `g`.`id`,`g`.`game_name`,`g`.`game_icon`,`g`.`game_cover`,`g`.`screenshot1`,`g`.`download_count`,`g`.`game_version`,`g`.`publication_date`,`g`.`class_id`,`gc`.`category_name`,`gc`.`category_desc` FROM `sq_games` `g` LEFT JOIN `sq_gameclass` `gc` ON `g`.`class_id`=`gc`.`id` WHERE `g`.`uid` = 1 AND `g`.`audit` = 'true' AND `g`.`id` <> '803' ORDER BY `g`.`publication_date` DESC LIMIT 3 [ RunTime:0.307263s ]
[ SQL ] SELECT `g`.`id`,`g`.`game_name`,`g`.`game_icon`,`g`.`game_cover`,`g`.`screenshot1`,`g`.`download_count`,`gc`.`category_name` FROM `sq_games` `g` LEFT JOIN `sq_gameclass` `gc` ON `g`.`class_id`=`gc`.`id` WHERE `g`.`class_id` = 1 AND `g`.`id` <> '803' AND `g`.`audit` = 'true' ORDER BY `g`.`download_count` DESC LIMIT 4 [ RunTime:0.001837s ]