[ DB ] CONNECT:[ UseTime:0.011188s ] mysql:host=127.0.0.1;port=3306;dbname=game;charset=utf8
[ SQL ] SHOW COLUMNS FROM `hisi_system_module` [ RunTime:0.623476s ]
[ SQL ] SELECT `name` FROM `hisi_system_module` WHERE `default` = 1 AND `status` = 2 LIMIT 1 [ RunTime:0.000891s ]
[ SQL ] SELECT * FROM `hisi_system_module` WHERE `name` = 'game' AND `status` = 2 LIMIT 1 [ RunTime:0.001636s ]
[ SQL ] SHOW COLUMNS FROM `hisi_cate` [ RunTime:0.036465s ]
[ SQL ] SELECT * FROM `hisi_cate` WHERE `grade` = 0 [ RunTime:0.001858s ]
[ SQL ] SHOW COLUMNS FROM `hisi_game` [ RunTime:0.131777s ]
[ SQL ] SELECT `id`,`title` FROM `hisi_game` WHERE `push` = 1 LIMIT 30,4 [ RunTime:0.001795s ]
[ SQL ] SHOW COLUMNS FROM `hisi_danji_game_cate` [ RunTime:0.118884s ]
[ SQL ] SELECT `name` FROM `hisi_danji_game_cate` WHERE `pinyin` = 'sheji' LIMIT 1 [ RunTime:0.001166s ]
[ SQL ] SELECT `oid`,`name` FROM `hisi_danji_game_cate` WHERE `pinyin` = 'sheji' LIMIT 1 [ RunTime:0.000944s ]
[ SQL ] SHOW COLUMNS FROM `hisi_danji_games` [ RunTime:0.024712s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' AND `title` LIKE '%%' [ RunTime:0.000859s ]
[ SQL ] SELECT * FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' AND `title` LIKE '%%' ORDER BY `game_pubdate` LIMIT 504,36 [ RunTime:1.947267s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' [ RunTime:0.001171s ]
[ SQL ] SELECT * FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' ORDER BY `game_score` DESC LIMIT 140,10 [ RunTime:0.034439s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' [ RunTime:0.000855s ]
[ SQL ] SELECT * FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' ORDER BY `game_pubdate` DESC LIMIT 140,10 [ RunTime:0.043545s ]
[ SQL ] SELECT * FROM `hisi_danji_games` WHERE `game_type_id` LIKE '%106%' ORDER BY `game_pubdate` DESC LIMIT 150,10 [ RunTime:0.002730s ]
[ SQL ] SELECT * FROM `hisi_danji_game_cate` [ RunTime:0.000863s ]
