Gem Deep Digger-Free online casual games

Gem Deep Digger

Gem Deep Digger is a delightful Arcade game—your perfect choice for casual entertainment during downtime!

Browser Game Free to Play No Download IOS,Android,Windows Arcade

Gem Deep Digger

Quick browser gameplay with no installation required.

12+

Rate

5.0

Top Charts

No. 874

Comments

Total Comments: 0

基本文件流程错误 SQL 调试

/data/test/box_game_api/public/index.php ( 0.97 KB )
/data/test/box_game_api/config/constant.php ( 0.39 KB )
/data/test/box_game_api/vendor/autoload.php ( 0.17 KB )
/data/test/box_game_api/vendor/composer/autoload_real.php ( 2.57 KB )
/data/test/box_game_api/vendor/composer/platform_check.php ( 0.90 KB )
/data/test/box_game_api/vendor/composer/ClassLoader.php ( 15.69 KB )
/data/test/box_game_api/vendor/composer/autoload_static.php ( 14.89 KB )
/data/test/box_game_api/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
/data/test/box_game_api/vendor/symfony/deprecation-contracts/function.php ( 0.98 KB )
/data/test/box_game_api/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
/data/test/box_game_api/vendor/guzzlehttp/guzzle/src/functions.php ( 5.54 KB )
/data/test/box_game_api/vendor/symfony/polyfill-php80/bootstrap.php ( 1.50 KB )
/data/test/box_game_api/vendor/symfony/polyfill-mbstring/bootstrap.php ( 8.26 KB )
/data/test/box_game_api/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
/data/test/box_game_api/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Facade.php ( 2.71 KB )
/data/test/box_game_api/vendor/adbario/php-dot-notation/src/helpers.php ( 0.57 KB )
/data/test/box_game_api/vendor/mtdowling/jmespath.php/src/JmesPath.php ( 0.36 KB )
/data/test/box_game_api/vendor/symfony/translation/Resources/functions.php ( 0.55 KB )
/data/test/box_game_api/vendor/alibabacloud/client/src/Functions.php ( 5.33 KB )
/data/test/box_game_api/vendor/google/apiclient-services/autoload.php ( 1.28 KB )
/data/test/box_game_api/vendor/phpseclib/phpseclib/phpseclib/bootstrap.php ( 0.72 KB )
/data/test/box_game_api/vendor/google/apiclient/src/aliases.php ( 3.05 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Client.php ( 43.87 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Service.php ( 1.91 KB )
/data/test/box_game_api/vendor/google/apiclient/src/AccessToken/Revoke.php ( 2.29 KB )
/data/test/box_game_api/vendor/google/apiclient/src/AccessToken/Verify.php ( 7.94 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Model.php ( 10.00 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Utils/UriTemplate.php ( 10.74 KB )
/data/test/box_game_api/vendor/google/apiclient/src/AuthHandler/Guzzle6AuthHandler.php ( 3.12 KB )
/data/test/box_game_api/vendor/google/apiclient/src/AuthHandler/Guzzle7AuthHandler.php ( 0.71 KB )
/data/test/box_game_api/vendor/google/apiclient/src/AuthHandler/AuthHandlerFactory.php ( 1.58 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Http/Batch.php ( 7.97 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Http/MediaFileUpload.php ( 9.87 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Http/REST.php ( 6.28 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Task/Retryable.php ( 0.73 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Task/Exception.php ( 0.70 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Exception.php ( 0.68 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Task/Runner.php ( 8.03 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Collection.php ( 3.04 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Service/Exception.php ( 1.99 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Service/Resource.php ( 11.17 KB )
/data/test/box_game_api/vendor/google/apiclient/src/Task/Composer.php ( 3.69 KB )
/data/test/box_game_api/vendor/overtrue/pinyin/src/const.php ( 0.49 KB )
/data/test/box_game_api/vendor/qcloud/cos-sdk-v5/src/Common.php ( 2.40 KB )
/data/test/box_game_api/vendor/symfony/var-dumper/Resources/functions/dump.php ( 0.79 KB )
/data/test/box_game_api/vendor/topthink/think-queue/src/common.php ( 1.01 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/App.php ( 14.26 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Container.php ( 15.38 KB )
/data/test/box_game_api/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
/data/test/box_game_api/app/provider.php ( 0.19 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Http.php ( 6.12 KB )
/data/test/box_game_api/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Env.php ( 4.64 KB )
/data/test/box_game_api/app/common.php ( 18.03 KB )
/data/test/box_game_api/vendor/topthink/framework/src/helper.php ( 18.44 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Config.php ( 5.03 KB )
/data/test/box_game_api/config/aliSms.php ( 0.52 KB )
/data/test/box_game_api/config/alibabaConfig.php ( 0.40 KB )
/data/test/box_game_api/config/apiConfig.php ( 0.27 KB )
/data/test/box_game_api/config/app.php ( 1.05 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
/data/test/box_game_api/config/cache.php ( 3.00 KB )
/data/test/box_game_api/config/clickhouse.php ( 0.61 KB )
/data/test/box_game_api/config/console.php ( 0.60 KB )
/data/test/box_game_api/config/cookie.php ( 0.56 KB )
/data/test/box_game_api/config/database.php ( 8.96 KB )
/data/test/box_game_api/config/filesystem.php ( 1.37 KB )
/data/test/box_game_api/config/jrttApiConfig.php ( 25.11 KB )
/data/test/box_game_api/config/lang.php ( 0.81 KB )
/data/test/box_game_api/config/log.php ( 4.49 KB )
/data/test/box_game_api/config/middleware.php ( 0.19 KB )
/data/test/box_game_api/config/payConfig.php ( 8.51 KB )
/data/test/box_game_api/config/queue.php ( 1.42 KB )
/data/test/box_game_api/config/route.php ( 1.54 KB )
/data/test/box_game_api/config/session.php ( 0.57 KB )
/data/test/box_game_api/config/sms.php ( 1.41 KB )
/data/test/box_game_api/config/smsWhiteList.php ( 0.10 KB )
/data/test/box_game_api/config/sourceUrlConfig.php ( 0.09 KB )
/data/test/box_game_api/config/trace.php ( 0.34 KB )
/data/test/box_game_api/config/view.php ( 0.82 KB )
/data/test/box_game_api/config/wechatConfig.php ( 4.49 KB )
/data/test/box_game_api/config/xsolla.php ( 1.14 KB )
/data/test/box_game_api/app/event.php ( 0.25 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Event.php ( 6.96 KB )
/data/test/box_game_api/app/service.php ( 0.13 KB )
/data/test/box_game_api/app/AppService.php ( 0.26 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Service.php ( 1.67 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Lang.php ( 7.60 KB )
/data/test/box_game_api/app/lang/en-us.php ( 4.21 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/initializer/Error.php ( 3.19 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
/data/test/box_game_api/vendor/services.php ( 0.17 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/service/ModelService.php ( 1.76 KB )
/data/test/box_game_api/vendor/topthink/think-queue/src/queue/Service.php ( 1.24 KB )
/data/test/box_game_api/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Middleware.php ( 6.78 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/Paginator.php ( 11.80 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Validate.php ( 46.10 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/Model.php ( 25.67 KB )
/data/test/box_game_api/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
/data/test/box_game_api/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 17.61 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 26.12 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.27 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/model/concern/TimeStamp.php ( 5.70 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 10.41 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Db.php ( 2.87 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/DbManager.php ( 8.28 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Log.php ( 8.50 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Manager.php ( 3.98 KB )
/data/test/box_game_api/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.04 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Cache.php ( 4.79 KB )
/data/test/box_game_api/vendor/psr/simple-cache/src/CacheInterface.php ( 4.50 KB )
/data/test/box_game_api/vendor/topthink/think-helper/src/helper/Arr.php ( 16.63 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.42 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/cache/Driver.php ( 8.06 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 2.25 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Console.php ( 22.65 KB )
/data/test/box_game_api/app/Request.php ( 0.09 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Request.php ( 54.04 KB )
/data/test/box_game_api/app/middleware.php ( 0.25 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
/data/test/box_game_api/vendor/topthink/think-trace/src/TraceDebug.php ( 2.94 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/middleware/SessionInit.php ( 2.06 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Session.php ( 1.80 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/session/driver/File.php ( 6.28 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/contract/SessionHandlerInterface.php ( 0.87 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/session/Store.php ( 7.26 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Route.php ( 23.74 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/route/RuleName.php ( 5.30 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/route/Domain.php ( 5.41 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/route/RuleGroup.php ( 13.91 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/route/Rule.php ( 22.98 KB )
/data/test/box_game_api/route/android.php ( 3.38 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/facade/Route.php ( 4.84 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.23 KB )
/data/test/box_game_api/route/apis.php ( 7.50 KB )
/data/test/box_game_api/route/app.php ( 1.56 KB )
/data/test/box_game_api/route/pay.php ( 1.45 KB )
/data/test/box_game_api/route/sdkApi.php ( 2.71 KB )
/data/test/box_game_api/route/view.php ( 3.01 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 6.61 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/route/Dispatch.php ( 6.93 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/middleware/AllowCrossDomain.php ( 2.08 KB )
/data/test/box_game_api/app/controller/view/Game.php ( 13.95 KB )
/data/test/box_game_api/app/controller/view/ViewBaseController.php ( 9.34 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/facade/Log.php ( 2.94 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/log/driver/File.php ( 6.17 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/log/Channel.php ( 6.54 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/event/LogRecord.php ( 0.86 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/event/LogWrite.php ( 0.88 KB )
/data/test/box_game_api/app/service/CacheService.php ( 8.39 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/facade/Cache.php ( 2.02 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/cache/driver/Redis.php ( 6.72 KB )
/data/test/box_game_api/app/model/user/UserModel.php ( 0.47 KB )
/data/test/box_game_api/app/model/BaseModel.php ( 3.90 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 4.39 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/PDOConnection.php ( 52.45 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/Connection.php ( 7.67 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.56 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 15.93 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/Builder.php ( 41.58 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/Query.php ( 10.64 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/BaseQuery.php ( 36.47 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.50 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 16.06 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 6.29 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.85 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 16.22 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 6.86 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.36 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.51 KB )
/data/test/box_game_api/app/model/common/GameModel.php ( 5.13 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/facade/Config.php ( 1.37 KB )
/data/test/box_game_api/app/model/common/GameCategoryModel.php ( 2.67 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/model/Collection.php ( 6.78 KB )
/data/test/box_game_api/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
/data/test/box_game_api/app/model/user/UserCollectGameModel.php ( 2.65 KB )
/data/test/box_game_api/app/model/common/GameRateRecordModel.php ( 0.85 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/facade/Db.php ( 0.94 KB )
/data/test/box_game_api/app/model/user/UserRecentlyPlayModel.php ( 2.39 KB )
/data/test/box_game_api/app/model/game/GameTopChartsModel.php ( 1.83 KB )
/data/test/box_game_api/app/model/common/GameDetailModel.php ( 4.90 KB )
/data/test/box_game_api/app/model/common/GameCategoryMapModel.php ( 3.00 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/Raw.php ( 1.39 KB )
/data/test/box_game_api/vendor/topthink/think-orm/src/db/Fetch.php ( 12.82 KB )
/data/test/box_game_api/app/model/common/CommentModel.php ( 1.75 KB )
/data/test/box_game_api/vendor/topthink/think-template/src/Template.php ( 47.01 KB )
/data/test/box_game_api/vendor/topthink/think-template/src/template/driver/File.php ( 2.33 KB )
/data/test/box_game_api/vendor/topthink/think-template/src/template/taglib/Cx.php ( 24.23 KB )
/data/test/box_game_api/vendor/topthink/think-template/src/template/TagLib.php ( 12.25 KB )
/data/test/box_game_api/public/cache/13ad905de834cee487fc547bbbcf59f4.php ( 144.39 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Response.php ( 8.60 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/response/Html.php ( 0.98 KB )
/data/test/box_game_api/vendor/topthink/framework/src/think/Cookie.php ( 6.28 KB )
/data/test/box_game_api/vendor/topthink/think-trace/src/Html.php ( 4.49 KB )

CONNECT:[ UseTime:0.001412s ] mysql:host=192.168.0.4;port=3306;dbname=box_game;charset=utf8mb4
SHOW FULL COLUMNS FROM `common_user` [ RunTime:0.001634s ]
SELECT * FROM `common_user` WHERE `uid` = 1365435 LIMIT 1 [ RunTime:0.000894s ]
SHOW FULL COLUMNS FROM `common_game` [ RunTime:0.001550s ]
SELECT * FROM `common_game` WHERE `url_name` = 'gem-deep-digger' AND `game_status` = 1 LIMIT 1 [ RunTime:0.000932s ]
SHOW FULL COLUMNS FROM `common_game_category` [ RunTime:0.001270s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` = 3 [ RunTime:0.000815s ]
SHOW FULL COLUMNS FROM `user_collect_game` [ RunTime:0.001200s ]
SELECT * FROM `user_collect_game` WHERE `game_id` = 1369 AND `uid` = 1365435 AND `channel_id` = 10001 AND `app_id` = 3052 LIMIT 1 [ RunTime:0.000850s ]
SHOW FULL COLUMNS FROM `common_game_rate_record` [ RunTime:0.001199s ]
SELECT * FROM `common_game_rate_record` WHERE `uid` = 1365435 AND `game_id` = 1369 LIMIT 1 [ RunTime:0.001011s ]
SELECT * FROM `common_game_rate_record` WHERE `game_id` = 1369 AND `rate_status` = 1 [ RunTime:0.001140s ]
SELECT * FROM `common_game_rate_record` WHERE `game_id` = 1369 AND `rate_status` = 2 [ RunTime:0.001210s ]
UPDATE `common_game` SET `game_play_num` = `game_play_num` + 1 WHERE `game_id` = 1369 [ RunTime:0.002275s ]
SHOW FULL COLUMNS FROM `user_recently_play` [ RunTime:0.001406s ]
SELECT * FROM `user_recently_play` WHERE `game_id` = 1369 AND `uid` = 1365435 AND `channel_id` = 10001 AND `app_id` = 3052 LIMIT 1 [ RunTime:0.000855s ]
SELECT * FROM `common_game` WHERE `game_id` = 1369 AND `game_status` = 1 LIMIT 1 [ RunTime:0.001086s ]
INSERT INTO `user_recently_play` SET `uid` = 1365435 , `game_id` = 1369 , `game_name` = 'Gem Deep Digger' , `game_icon` = '/public/20250903/452ddf294fa16eb811b289738e0c2a8e.jpg' , `game_main_img` = '/public/20250903/4ab1cb6cbf8ba92085ca2f4efd6543bd.jpg' , `game_title` = 'Gem Deep Digger' , `play_time` = '2026-04-21 22:01:44' , `channel_id` = 10001 , `app_id` = 3052 [ RunTime:0.001328s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` = 3 [ RunTime:0.000916s ]
SHOW FULL COLUMNS FROM `game_top_charts` [ RunTime:0.001403s ]
SELECT * FROM `game_top_charts` WHERE `game_id` = 1369 ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.000898s ]
SHOW FULL COLUMNS FROM `common_game_detail` [ RunTime:0.001312s ]
SELECT COUNT(*) AS think_count FROM `common_game_detail` WHERE `game_id` = 1369 AND `status` = 1 LIMIT 1 [ RunTime:0.000861s ]
SELECT `detail_id`,`game_id`,`content_type`,`detail_type`,`detail_main_img`,`detail_main_h_img`,`detail_title`,`detail_label`,`detail_url_name`,`content` FROM `common_game_detail` WHERE `game_id` = 1369 AND `status` = 1 ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.000882s ]
SHOW FULL COLUMNS FROM `common_game_category_map` [ RunTime:0.001259s ]
SELECT COUNT(*) AS think_count FROM ( SELECT `cm`.*,count(*) AS think_count FROM `common_game_category_map` `gcm` LEFT JOIN `common_game` `cm` ON `gcm`.`game_id`=`cm`.`game_id` WHERE `cm`.`game_status` = '1' AND `gcm`.`category_id` = '3' GROUP BY `cm`.`game_id` ) `_group_count_` LIMIT 1 [ RunTime:0.004103s ]
SELECT `cm`.*,count(*) AS think_count FROM `common_game_category_map` `gcm` LEFT JOIN `common_game` `cm` ON `gcm`.`game_id`=`cm`.`game_id` WHERE `cm`.`game_status` = '1' AND `gcm`.`category_id` = '3' GROUP BY `cm`.`game_id` ORDER BY `cm`.`game_play_num` DESC LIMIT 0,9 [ RunTime:0.003344s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` IN (2,1,3) [ RunTime:0.000867s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` = 3 [ RunTime:0.000834s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` IN (2,3) [ RunTime:0.000824s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` = 3 [ RunTime:0.000886s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` IN (13,1,3) [ RunTime:0.000835s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` = 3 [ RunTime:0.000823s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` = 3 [ RunTime:0.000816s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` IN (12,3) [ RunTime:0.000901s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` IN (1,2,3) [ RunTime:0.000864s ]
SHOW FULL COLUMNS FROM `common_comment` [ RunTime:0.001629s ]
SELECT COUNT(*) AS think_count FROM `common_comment` WHERE ( `game_id` = 1369 AND `root_id` = 0 AND `status` = 1 ) OR ( `game_id` = 1369 AND `root_id` = 0 AND `status` = 0 AND `user_id` = 1365435 ) LIMIT 1 [ RunTime:0.000919s ]
SELECT * FROM `common_comment` WHERE ( `game_id` = 1369 AND `root_id` = 0 AND `status` = 1 ) OR ( `game_id` = 1369 AND `root_id` = 0 AND `status` = 0 AND `user_id` = 1365435 ) ORDER BY `comment_id` ASC LIMIT 0,10 [ RunTime:0.000888s ]