[ DB ] CONNECT:[ UseTime:0.001146s ] mysql:host=localhost;dbname=www_556i_com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `sq_gameclass` [ RunTime:0.001284s ]
[ SQL ] SELECT `id`,`category_name`,`category_icon`,`category_desc`,`create_time` FROM `sq_gameclass` ORDER BY `create_time` DESC [ RunTime:0.000502s ]
[ SQL ] SHOW COLUMNS FROM `sq_games` [ RunTime:0.002036s ]
[ SQL ] SELECT * FROM `sq_games` WHERE `audit` = 'true' ORDER BY `download_count` DESC LIMIT 10 [ RunTime:0.001717s ]
[ SQL ] SELECT * FROM `sq_gameclass` WHERE `id` = 1 [ RunTime:0.001021s ]
[ SQL ] SHOW COLUMNS FROM `sq_user` [ RunTime:0.001830s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 [ RunTime:0.001010s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `banned` = 'true' AND `ip` = '216.73.216.116' LIMIT 1 [ RunTime:0.004177s ]
[ SQL ] SHOW COLUMNS FROM `sq_app` [ RunTime:0.001354s ]
[ SQL ] SELECT * FROM `sq_app` [ RunTime:0.001353s ]
[ SQL ] SELECT * FROM `sq_app` WHERE `key` = 'app_site_status' LIMIT 1 [ RunTime:0.000643s ]
[ SQL ] SELECT * FROM `sq_app` WHERE `key` = 'app_notice_title' LIMIT 1 [ RunTime:0.000478s ]
[ SQL ] SELECT * FROM `sq_app` WHERE `key` = 'app_notice_content' LIMIT 1 [ RunTime:0.000522s ]
[ SQL ] SHOW COLUMNS FROM `sq_apkclass` [ RunTime:0.000830s ]
[ SQL ] SELECT c.id, c.classname, c.classicon, c.classdetail, (SELECT COUNT(*) FROM sq_apkdown WHERE classid = c.id AND audit = "true") as app_count FROM `sq_apkclass` `c` ORDER BY `c`.`id` ASC [ RunTime:0.051016s ]
[ SQL ] SHOW COLUMNS FROM `sq_apkdown` [ RunTime:0.001462s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_apkdown` WHERE `classid` = 1 AND `audit` = 'true' [ RunTime:0.001928s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_apkdown` WHERE `classid` = 1 AND `audit` = 'true' [ RunTime:0.002329s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_apkdown` WHERE `classid` = 2 AND `audit` = 'true' [ RunTime:0.001377s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_apkdown` WHERE `classid` = 2 AND `audit` = 'true' [ RunTime:0.001035s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_apkdown` WHERE `classid` = 4 AND `audit` = 'true' [ RunTime:0.000952s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_apkdown` WHERE `classid` = 4 AND `audit` = 'true' [ RunTime:0.000593s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_apkdown` WHERE `classid` = 5 AND `audit` = 'true' [ RunTime:0.003672s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_apkdown` WHERE `classid` = 5 AND `audit` = 'true' [ RunTime:0.003592s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_apkdown` WHERE `classid` = 7 AND `audit` = 'true' [ RunTime:0.001008s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_apkdown` WHERE `classid` = 7 AND `audit` = 'true' [ RunTime:0.000875s ]
[ SQL ] SELECT gc.id, gc.category_name, gc.category_icon, gc.category_desc, gc.create_time, (SELECT COUNT(*) FROM sq_games WHERE class_id = gc.id AND audit = "true") as game_count FROM `sq_gameclass` `gc` ORDER BY `gc`.`create_time` DESC [ RunTime:0.051136s ]
[ SQL ] SHOW COLUMNS FROM `sq_lunbo` [ RunTime:0.001465s ]
[ SQL ] SELECT * FROM `sq_lunbo` WHERE `ads_show` = 5 ORDER BY `id` DESC [ RunTime:0.000944s ]
[ SQL ] SHOW COLUMNS FROM `sq_plate` [ RunTime:0.001366s ]
[ SQL ] SELECT p.id,p.platename,p.plateicon,p.plateontent,(SELECT COUNT(*) FROM sq_post WHERE plateid = p.id AND is_audit = "true") as post_count FROM `sq_plate` `p` ORDER BY `p`.`id` ASC [ RunTime:0.004928s ]
[ SQL ] SHOW COLUMNS FROM `sq_toolclass` [ RunTime:0.001487s ]
[ SQL ] SELECT tc.id, tc.toolclassname, tc.toolclassicon, tc.toolclassdetail, (SELECT COUNT(*) FROM sq_tool WHERE toolclassid = tc.id AND toolkg = "true") as tool_count FROM `sq_toolclass` `tc` ORDER BY `tc`.`id` ASC [ RunTime:0.001654s ]
[ SQL ] SHOW COLUMNS FROM `sq_post` [ RunTime:0.001517s ]
[ SQL ] SELECT p.id,p.postname,p.view,p.creat_time,p.plateid,u.nickname,u.usertx,(select count(*) from sq_comment where postid = p.id) as commentnum FROM `sq_post` `p` INNER JOIN `sq_user` `u` ON `u`.`id`=`p`.`uid` WHERE `p`.`is_audit` = 'true' ORDER BY `p`.`view` DESC LIMIT 5 [ RunTime:0.001310s ]
[ SQL ] SELECT `platename` FROM `sq_plate` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000582s ]
[ SQL ] SELECT `platename` FROM `sq_plate` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000481s ]
[ SQL ] SELECT `platename` FROM `sq_plate` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000465s ]
[ SQL ] SELECT `platename` FROM `sq_plate` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000532s ]
[ SQL ] SELECT `platename` FROM `sq_plate` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000490s ]
[ SQL ] SELECT p.id,p.postname,p.view,p.creat_time,p.plateid,u.nickname,u.usertx,(select count(*) from sq_comment where postid = p.id) as commentnum FROM `sq_post` `p` INNER JOIN `sq_user` `u` ON `u`.`id`=`p`.`uid` WHERE `p`.`is_audit` = 'true' ORDER BY `p`.`creat_time` DESC LIMIT 5 [ RunTime:0.001590s ]
[ SQL ] SELECT `platename` FROM `sq_plate` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000768s ]
[ SQL ] SELECT `platename` FROM `sq_plate` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000682s ]
[ SQL ] SELECT `platename` FROM `sq_plate` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000553s ]
[ SQL ] SELECT `platename` FROM `sq_plate` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000833s ]
[ SQL ] SELECT `platename` FROM `sq_plate` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000699s ]
[ SQL ] SELECT p.id,p.postname,p.view,p.creat_time,p.plateid,u.nickname,u.usertx,(select count(*) from sq_comment where postid = p.id) as commentnum FROM `sq_post` `p` INNER JOIN `sq_user` `u` ON `u`.`id`=`p`.`uid` WHERE `p`.`is_audit` = 'true' AND `p`.`is_recommend` = 'true' ORDER BY `p`.`creat_time` DESC LIMIT 5 [ RunTime:0.002208s ]
[ SQL ] SELECT `platename` FROM `sq_plate` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000501s ]
[ SQL ] SELECT `a`.*,`c`.`classname` FROM `sq_apkdown` `a` LEFT JOIN `sq_apkclass` `c` ON `a`.`classid`=`c`.`id` WHERE `audit` = 'true' ORDER BY `downnum` DESC LIMIT 8 [ RunTime:0.074745s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001216s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000937s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000803s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001166s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001013s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000901s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000838s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000978s ]
[ SQL ] SELECT `a`.*,`c`.`classname` FROM `sq_apkdown` `a` LEFT JOIN `sq_apkclass` `c` ON `a`.`classid`=`c`.`id` WHERE `audit` = 'true' ORDER BY `publication_date` DESC LIMIT 8 [ RunTime:0.099075s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001114s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001187s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000931s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000738s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000856s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000983s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001067s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000789s ]
[ SQL ] SELECT `g`.*,`gc`.`category_name` FROM `sq_games` `g` LEFT JOIN `sq_gameclass` `gc` ON `g`.`class_id`=`gc`.`id` WHERE `g`.`audit` = 'true' ORDER BY `g`.`download_count` DESC LIMIT 8 [ RunTime:0.002127s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001125s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001023s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001104s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001029s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000733s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000928s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000906s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000922s ]
[ SQL ] SELECT `g`.*,`gc`.`category_name` FROM `sq_games` `g` LEFT JOIN `sq_gameclass` `gc` ON `g`.`class_id`=`gc`.`id` WHERE `g`.`audit` = 'true' ORDER BY `g`.`publication_date` DESC LIMIT 8 [ RunTime:0.001384s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000596s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001131s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001036s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000862s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000603s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000672s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000808s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000885s ]
[ SQL ] SELECT `g`.*,`gc`.`category_name` FROM `sq_games` `g` LEFT JOIN `sq_gameclass` `gc` ON `g`.`class_id`=`gc`.`id` WHERE `g`.`audit` = 'true' AND `g`.`is_recommend` = 'true' ORDER BY `g`.`publication_date` DESC LIMIT 8 [ RunTime:0.037664s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000926s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000658s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000605s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000548s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000554s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000581s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001527s ]
[ SQL ] SELECT * FROM `sq_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000740s ]
[ SQL ] SHOW COLUMNS FROM `sq_upload` [ RunTime:0.002091s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_upload` [ RunTime:0.132299s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_user` [ RunTime:0.001084s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_apkclass` [ RunTime:0.000887s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_apkdown` WHERE `audit` = 'true' [ RunTime:0.003777s ]
[ SQL ] SELECT SUM(`downnum`) AS tp_sum FROM `sq_apkdown` WHERE `audit` = 'true' [ RunTime:0.006693s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_gameclass` [ RunTime:0.000663s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_games` WHERE `audit` = 'true' [ RunTime:0.013725s ]
[ SQL ] SELECT SUM(`download_count`) AS tp_sum FROM `sq_games` WHERE `audit` = 'true' [ RunTime:0.014165s ]
[ SQL ] SELECT SUM(`view_count`) AS tp_sum FROM `sq_games` WHERE `audit` = 'true' [ RunTime:0.067443s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_games` WHERE `publication_date` >= '2025-09-08 00:00:00' [ RunTime:0.011699s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_plate` [ RunTime:0.000720s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_post` WHERE `is_audit` = 'true' [ RunTime:0.000785s ]
[ SQL ] SELECT SUM(`view`) AS tp_sum FROM `sq_post` WHERE `is_audit` = 'true' [ RunTime:0.000602s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_post` WHERE `creat_time` >= '2025-09-08 00:00:00' [ RunTime:0.000496s ]
[ SQL ] SHOW COLUMNS FROM `sq_comment` [ RunTime:0.000828s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_comment` [ RunTime:0.000390s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_toolclass` [ RunTime:0.000347s ]
[ SQL ] SHOW COLUMNS FROM `sq_tool` [ RunTime:0.001302s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_tool` WHERE `toolkg` = 'true' [ RunTime:0.000602s ]
[ SQL ] SELECT SUM(`toolheat`) AS tp_sum FROM `sq_tool` WHERE `toolkg` = 'true' [ RunTime:0.000431s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_tool` WHERE `toolkg` = 'true' [ RunTime:0.000466s ]
[ SQL ] SHOW COLUMNS FROM `sq_visit_log` [ RunTime:0.001106s ]
[ SQL ] SELECT SUM(`visit_count`) AS tp_sum FROM `sq_visit_log` [ RunTime:0.001243s ]
[ SQL ] SELECT `t`.`id`,`t`.`tool`,`t`.`toolimg`,`t`.`toolheat`,`t`.`toolclassid`,`tc`.`toolclassname` FROM `sq_tool` `t` LEFT JOIN `sq_toolclass` `tc` ON `t`.`toolclassid`=`tc`.`id` WHERE `t`.`toolkg` = 'true' ORDER BY `t`.`toolheat` DESC LIMIT 8 [ RunTime:0.000612s ]
[ SQL ] SELECT `t`.`id`,`t`.`tool`,`t`.`toolimg`,`t`.`toolheat`,`t`.`toolclassid`,`tc`.`toolclassname` FROM `sq_tool` `t` LEFT JOIN `sq_toolclass` `tc` ON `t`.`toolclassid`=`tc`.`id` WHERE `t`.`toolkg` = 'true' ORDER BY `t`.`id` DESC LIMIT 8 [ RunTime:0.027073s ]
[ 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` = '3100' LIMIT 1 [ RunTime:0.001448s ]
[ SQL ] SHOW COLUMNS FROM `sq_useronline` [ RunTime:0.001357s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_useronline` WHERE `update_time` > '2025-09-08 00:10:24' [ RunTime:0.000831s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_user` WHERE `creattime` >= '2025-09-08 00:00:00' [ RunTime:0.001085s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_user` WHERE `last_login_time` >= '2025-09-08 00:00:00' [ RunTime:0.001186s ]
[ 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-08 00:10:24' ORDER BY `uo`.`update_time` DESC LIMIT 5 [ RunTime:0.000924s ]
[ 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` <> 32 AND ( `uo`.`update_time` IS NULL OR `uo`.`update_time` <= '2025-09-08 00:10:24' ) ORDER BY `u`.`last_login_time` DESC LIMIT 4 [ RunTime:0.002343s ]
[ 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` = '3100' AND `g`.`audit` = 'true' LIMIT 1 [ RunTime:0.001630s ]
[ SQL ] SHOW COLUMNS FROM `sq_title` [ RunTime:0.001403s ]
[ SQL ] SELECT `id`,`title`,`icon` FROM `sq_title` WHERE `id` IN (2,4,5,6,9,10,11) [ RunTime:0.000852s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sq_games` WHERE `uid` = 1 AND `audit` = 'true' [ RunTime:0.036724s ]
[ 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` <> '3100' ORDER BY `g`.`publication_date` DESC LIMIT 3 [ RunTime:0.307730s ]
[ 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` <> '3100' AND `g`.`audit` = 'true' ORDER BY `g`.`download_count` DESC LIMIT 4 [ RunTime:0.001955s ]
[ SQL ] UPDATE `sq_games` SET `view_count` = `view_count` + 1 WHERE `id` = 3100 [ RunTime:0.022584s ]