[ DB ] CONNECT:[ UseTime:0.002082s ] mysql:host=127.0.0.1;port=3306;dbname=game;charset=utf8
[ SQL ] SHOW COLUMNS FROM `hisi_system_module` [ RunTime:0.021790s ]
[ SQL ] SELECT `name` FROM `hisi_system_module` WHERE `default` = 1 AND `status` = 2 LIMIT 1 [ RunTime:0.001047s ]
[ SQL ] SELECT * FROM `hisi_system_module` WHERE `name` = 'game' AND `status` = 2 LIMIT 1 [ RunTime:0.001770s ]
[ SQL ] SHOW COLUMNS FROM `hisi_cate` [ RunTime:0.024752s ]
[ SQL ] SELECT * FROM `hisi_cate` WHERE `grade` = 0 [ RunTime:0.001142s ]
[ SQL ] SHOW COLUMNS FROM `hisi_game` [ RunTime:0.022462s ]
[ SQL ] SELECT `id`,`title` FROM `hisi_game` WHERE `push` = 1 LIMIT 30,4 [ RunTime:0.000909s ]
[ SQL ] SHOW COLUMNS FROM `hisi_danji_game_cate` [ RunTime:0.025458s ]
[ SQL ] SELECT `name` FROM `hisi_danji_game_cate` WHERE `pinyin` = 'sheji' LIMIT 1 [ RunTime:0.001038s ]
[ SQL ] SELECT `oid`,`name` FROM `hisi_danji_game_cate` WHERE `pinyin` = 'sheji' LIMIT 1 [ RunTime:0.000839s ]
[ SQL ] SHOW COLUMNS FROM `hisi_danji_games` [ RunTime:0.035844s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' AND `title` LIKE '%%' [ RunTime:0.198175s ]
[ SQL ] SELECT * FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' AND `title` LIKE '%%' ORDER BY `game_pubdate` LIMIT 504,36 [ RunTime:0.033283s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' [ RunTime:0.031991s ]
[ SQL ] SELECT * FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' ORDER BY `game_score` DESC LIMIT 140,10 [ RunTime:0.027908s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' [ RunTime:0.001036s ]
[ SQL ] SELECT * FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' ORDER BY `game_pubdate` DESC LIMIT 140,10 [ RunTime:0.030753s ]
[ SQL ] SELECT * FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' ORDER BY `game_pubdate` DESC LIMIT 150,10 [ RunTime:0.024088s ]
[ SQL ] SELECT * FROM `hisi_danji_game_cate` [ RunTime:0.001141s ]