[ DB ] CONNECT:[ UseTime:0.010474s ] mysql:host=127.0.0.1;port=3306;dbname=game;charset=utf8
[ SQL ] SHOW COLUMNS FROM `hisi_system_module` [ RunTime:0.033373s ]
[ SQL ] SELECT `name` FROM `hisi_system_module` WHERE `default` = 1 AND `status` = 2 LIMIT 1 [ RunTime:0.000720s ]
[ SQL ] SELECT * FROM `hisi_system_module` WHERE `name` = 'game' AND `status` = 2 LIMIT 1 [ RunTime:0.001442s ]
[ SQL ] SHOW COLUMNS FROM `hisi_cate` [ RunTime:0.017900s ]
[ SQL ] SELECT * FROM `hisi_cate` WHERE `grade` = 0 [ RunTime:0.000729s ]
[ SQL ] SHOW COLUMNS FROM `hisi_game` [ RunTime:0.015158s ]
[ SQL ] SELECT `id`,`title` FROM `hisi_game` WHERE `push` = 1 LIMIT 30,4 [ RunTime:0.000908s ]
[ SQL ] SHOW COLUMNS FROM `hisi_danji_game_cate` [ RunTime:0.018606s ]
[ SQL ] SELECT `name` FROM `hisi_danji_game_cate` WHERE `pinyin` = 'sheji' LIMIT 1 [ RunTime:0.003302s ]
[ SQL ] SELECT `oid`,`name` FROM `hisi_danji_game_cate` WHERE `pinyin` = 'sheji' LIMIT 1 [ RunTime:0.000993s ]
[ SQL ] SHOW COLUMNS FROM `hisi_danji_games` [ RunTime:0.215635s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' AND `title` LIKE '%%' [ RunTime:0.245979s ]
[ SQL ] SELECT * FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' AND `title` LIKE '%%' ORDER BY `game_pubdate` LIMIT 504,36 [ RunTime:0.057854s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' [ RunTime:0.030351s ]
[ SQL ] SELECT * FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' ORDER BY `game_score` DESC LIMIT 140,10 [ RunTime:0.037223s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' [ RunTime:0.000793s ]
[ SQL ] SELECT * FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' ORDER BY `game_pubdate` DESC LIMIT 140,10 [ RunTime:0.038669s ]
[ SQL ] SELECT * FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' ORDER BY `game_pubdate` DESC LIMIT 150,10 [ RunTime:0.032874s ]
[ SQL ] SELECT * FROM `hisi_danji_game_cate` [ RunTime:0.001768s ]
