Mighty DOOM

Action
Rating
Version 1.13.1
Size 586.73 MB
Go Download
Advertisement
Advertisement

Editor's Review

Shoot through mini demon hordes in Mighty DOOM. This single-touch, top-down shooter set in the animated DOOM universe puts you at the center of the fight as you rip and tear through demon hordes from the fiery depths of Hell.

Descend into mini versions of iconic DOOM worlds in this arcade action, top down shooter. Blast your way through hundreds of exciting levels and become mighty. Battle challenging bosses as you level up, gain powerful skills, loot new gear, and upgrade legendary guns.

RUN AND GUN

  • Shoot your weapon at all times, whether moving or standing still.
  • Dive into a shooter with simple touch controls and dodge ranged enemies, keep melee demons at bay and go in for the Glory Kill.
  • Put your demon slaying skills to the test with challenging gameplay that’s easy to learn but takes great demon-slaying skill to master.

THE ULTIMATE GUN GAME

  • Become the ultimate demon slayer as you equip three unique weapons and swap them on the fly to unleash your might..
  • Choose from 13 legendary weapons like the Rocket Launcher to blast groups of demons with a single shot.
  • Shoot weapons like the Unmakyr or BFG to inflict maximum carnage.

FAST ARCADE ACTION IN EVERY LEVEL

  • Shoot ‘em up through mini versions of iconic DOOM locations.
  • Fight through as many waves of pocket-sized demons and challenge your slaying skills in an epic boss fight.
  • If you should fall, rise to fight again and push further through the enemy horde.

BECOME MIGHTY

  • Level up your Mini Slayer and prepare for the next demon battle.
  • Use equipment to upgrade and craft legendary gear.
  • Gain buffs tied to your weapon choices and enhance your demon slaying skills
  • Unlock devastating abilities and insane combos as you conquer Hell’s armies.
  • Upgrade and arm your Mini Slayer with iconic weapons like the Plasma Rifle, Chain Gun, and Super Shotgun.

GET READY FOR THE NEXT EPIC BOSS FIGHT

  • Demon slaying action kicks into overdrive with each boss fight.
  • Battle bosses with their own unique attacks and strategies.
  • Challenge mini versions of legendary DOOM bosses like the Baron of Hell, Hell Priest, Baron of Hell, and more.

Rip and tear anywhere when you become the Mini Slayer and conquer hundreds of challenging levels in Mighty DOOM.

Information

Platform: Android /IOS
Version: 1.13.1
Category: Action
Price: Free
Size: 586.73 MB
Developer:Bethesda Softworks LLC

Download

Ratings

4.4
Total 1,862
5
4
3
2
1
Click Stars To Rate :

Similar Games

Popular Games

You may also like

com.xq.archeroii

Archero 2

4.6
Action
Details
com.devsisters.cba

CookieRun

4.6
Action
Details
com.netmarble.sololv

Solo Leveling

4.6
Action
Details
com.supercell.squad

Squad Busters

4.6
Action
Details
com.miraclegames.farlight84

Farlight 84

4.6
Action
Details
lol.onevone

1v1.LOL

4.6
Action
Details
com.bethsoft.ubu

Mighty DOOM

4.6
Action
Details
com.kayac.DrawFight

Draw Action

4.6
Action
Details
com.scream.imposter.monster.survival

Space Survivor

4.6
Action
Details
com.htt.alpha.shooter.fps
Details
com.ea.gp.apexlegendsmobilefps
Details
com.scottgames.fnaf4
Details
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-06-08 23:47:13 HTTP/1.1 GET : https://game.appurse.com/com.bethsoft.ubu.html
  2. 运行时间 : 0.683191s [ 吞吐率:1.46req/s ] 内存消耗:4,425.45kb 文件加载:126
  3. 缓存信息 : 0 reads,0 writes
  1. /home/appr/public_html_game/index.php ( 0.48 KB )
  2. /home/appr/public_html_game/vendor/autoload.php ( 0.75 KB )
  3. /home/appr/public_html_game/vendor/composer/autoload_real.php ( 1.63 KB )
  4. /home/appr/public_html_game/vendor/composer/platform_check.php ( 0.90 KB )
  5. /home/appr/public_html_game/vendor/composer/ClassLoader.php ( 15.99 KB )
  6. /home/appr/public_html_game/vendor/composer/autoload_static.php ( 3.81 KB )
  7. /home/appr/public_html_game/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
  8. /home/appr/public_html_game/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
  9. /home/appr/public_html_game/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
  10. /home/appr/public_html_game/vendor/topthink/think-container/src/Facade.php ( 2.71 KB )
  11. /home/appr/public_html_game/vendor/topthink/think-validate/src/helper.php ( 2.19 KB )
  12. /home/appr/public_html_game/vendor/topthink/framework/src/think/App.php ( 15.30 KB )
  13. /home/appr/public_html_game/vendor/topthink/think-container/src/Container.php ( 15.76 KB )
  14. /home/appr/public_html_game/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
  15. /home/appr/public_html_game/app/provider.php ( 0.08 KB )
  16. /home/appr/public_html_game/vendor/topthink/framework/src/think/Http.php ( 6.22 KB )
  17. /home/appr/public_html_game/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
  18. /home/appr/public_html_game/vendor/topthink/framework/src/think/Env.php ( 4.68 KB )
  19. /home/appr/public_html_game/app/common.php ( 2.00 KB )
  20. /home/appr/public_html_game/vendor/topthink/framework/src/helper.php ( 18.77 KB )
  21. /home/appr/public_html_game/vendor/topthink/framework/src/think/Config.php ( 5.93 KB )
  22. /home/appr/public_html_game/config/app.php ( 0.38 KB )
  23. /home/appr/public_html_game/config/cache.php ( 0.30 KB )
  24. /home/appr/public_html_game/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  25. /home/appr/public_html_game/config/cookie.php ( 0.18 KB )
  26. /home/appr/public_html_game/config/database.php ( 0.82 KB )
  27. /home/appr/public_html_game/config/log.php ( 0.57 KB )
  28. /home/appr/public_html_game/config/middleware.php ( 0.04 KB )
  29. /home/appr/public_html_game/config/route.php ( 0.38 KB )
  30. /home/appr/public_html_game/config/session.php ( 0.25 KB )
  31. /home/appr/public_html_game/config/trace.php ( 0.34 KB )
  32. /home/appr/public_html_game/config/view.php ( 0.49 KB )
  33. /home/appr/public_html_game/app/event.php ( 0.24 KB )
  34. /home/appr/public_html_game/vendor/topthink/framework/src/think/Event.php ( 7.77 KB )
  35. /home/appr/public_html_game/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
  36. /home/appr/public_html_game/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
  37. /home/appr/public_html_game/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
  38. /home/appr/public_html_game/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  39. /home/appr/public_html_game/vendor/services.php ( 0.14 KB )
  40. /home/appr/public_html_game/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  41. /home/appr/public_html_game/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
  42. /home/appr/public_html_game/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  43. /home/appr/public_html_game/vendor/topthink/framework/src/think/service/ModelService.php ( 2.04 KB )
  44. /home/appr/public_html_game/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  45. /home/appr/public_html_game/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
  46. /home/appr/public_html_game/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  47. /home/appr/public_html_game/vendor/topthink/think-orm/src/Paginator.php ( 11.71 KB )
  48. /home/appr/public_html_game/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
  49. /home/appr/public_html_game/vendor/topthink/think-orm/src/Model.php ( 26.86 KB )
  50. /home/appr/public_html_game/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 19.19 KB )
  51. /home/appr/public_html_game/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 26.44 KB )
  52. /home/appr/public_html_game/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.58 KB )
  53. /home/appr/public_html_game/vendor/topthink/think-orm/src/model/concern/TimeStamp.php ( 5.69 KB )
  54. /home/appr/public_html_game/vendor/topthink/think-orm/src/model/concern/AutoWriteId.php ( 1.44 KB )
  55. /home/appr/public_html_game/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 10.85 KB )
  56. /home/appr/public_html_game/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  57. /home/appr/public_html_game/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  58. /home/appr/public_html_game/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
  59. /home/appr/public_html_game/vendor/topthink/think-orm/src/DbManager.php ( 8.33 KB )
  60. /home/appr/public_html_game/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
  61. /home/appr/public_html_game/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
  62. /home/appr/public_html_game/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
  63. /home/appr/public_html_game/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
  64. /home/appr/public_html_game/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
  65. /home/appr/public_html_game/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
  66. /home/appr/public_html_game/vendor/topthink/think-helper/src/helper/Arr.php ( 17.45 KB )
  67. /home/appr/public_html_game/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.84 KB )
  68. /home/appr/public_html_game/vendor/topthink/framework/src/think/cache/Driver.php ( 9.02 KB )
  69. /home/appr/public_html_game/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
  70. /home/appr/public_html_game/vendor/topthink/framework/src/think/Request.php ( 54.64 KB )
  71. /home/appr/public_html_game/vendor/topthink/framework/src/think/traits/UrlHandler.php ( 6.05 KB )
  72. /home/appr/public_html_game/vendor/topthink/framework/src/think/traits/DomainHandler.php ( 5.49 KB )
  73. /home/appr/public_html_game/vendor/topthink/framework/src/think/traits/HttpMethodHandler.php ( 4.74 KB )
  74. /home/appr/public_html_game/app/middleware.php ( 0.04 KB )
  75. /home/appr/public_html_game/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  76. /home/appr/public_html_game/vendor/topthink/think-trace/src/TraceDebug.php ( 3.40 KB )
  77. /home/appr/public_html_game/vendor/topthink/framework/src/think/Route.php ( 23.73 KB )
  78. /home/appr/public_html_game/vendor/topthink/framework/src/think/route/RuleName.php ( 5.74 KB )
  79. /home/appr/public_html_game/vendor/topthink/framework/src/think/route/Domain.php ( 2.53 KB )
  80. /home/appr/public_html_game/vendor/topthink/framework/src/think/route/RuleGroup.php ( 22.41 KB )
  81. /home/appr/public_html_game/vendor/topthink/framework/src/think/route/Rule.php ( 27.49 KB )
  82. /home/appr/public_html_game/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
  83. /home/appr/public_html_game/route/app.php ( 0.41 KB )
  84. /home/appr/public_html_game/vendor/topthink/framework/src/think/facade/Route.php ( 4.70 KB )
  85. /home/appr/public_html_game/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 4.74 KB )
  86. /home/appr/public_html_game/vendor/topthink/framework/src/think/route/Dispatch.php ( 11.32 KB )
  87. /home/appr/public_html_game/app/controller/Index.php ( 8.05 KB )
  88. /home/appr/public_html_game/app/BaseController.php ( 1.32 KB )
  89. /home/appr/public_html_game/app/model/Game.php ( 8.23 KB )
  90. /home/appr/public_html_game/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
  91. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 4.33 KB )
  92. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/PDOConnection.php ( 51.60 KB )
  93. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/Connection.php ( 8.81 KB )
  94. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.86 KB )
  95. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.56 KB )
  96. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/Builder.php ( 22.26 KB )
  97. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.29 KB )
  98. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/Query.php ( 15.21 KB )
  99. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/BaseQuery.php ( 41.60 KB )
  100. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
  101. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  102. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 19.29 KB )
  103. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
  104. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 6.98 KB )
  105. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
  106. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 18.79 KB )
  107. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 6.96 KB )
  108. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.46 KB )
  109. /home/appr/public_html_game/vendor/topthink/think-orm/src/db/Raw.php ( 1.22 KB )
  110. /home/appr/public_html_game/vendor/topthink/framework/src/think/log/driver/File.php ( 6.10 KB )
  111. /home/appr/public_html_game/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  112. /home/appr/public_html_game/vendor/topthink/framework/src/think/log/Channel.php ( 3.89 KB )
  113. /home/appr/public_html_game/vendor/topthink/framework/src/think/event/LogRecord.php ( 1.02 KB )
  114. /home/appr/public_html_game/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  115. /home/appr/public_html_game/vendor/topthink/framework/src/think/facade/View.php ( 1.70 KB )
  116. /home/appr/public_html_game/vendor/topthink/framework/src/think/View.php ( 4.39 KB )
  117. /home/appr/public_html_game/vendor/topthink/think-view/src/Think.php ( 8.38 KB )
  118. /home/appr/public_html_game/vendor/topthink/framework/src/think/contract/TemplateHandlerInterface.php ( 1.60 KB )
  119. /home/appr/public_html_game/vendor/topthink/think-template/src/Template.php ( 46.61 KB )
  120. /home/appr/public_html_game/vendor/topthink/think-template/src/template/driver/File.php ( 2.41 KB )
  121. /home/appr/public_html_game/vendor/topthink/think-template/src/template/contract/DriverInterface.php ( 0.86 KB )
  122. /home/appr/public_html_game/runtime/temp/abc22d3f9326c851f7db62362c326cb7.php ( 35.77 KB )
  123. /home/appr/public_html_game/vendor/topthink/framework/src/think/Response.php ( 9.07 KB )
  124. /home/appr/public_html_game/vendor/topthink/framework/src/think/response/Html.php ( 0.97 KB )
  125. /home/appr/public_html_game/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
  126. /home/appr/public_html_game/vendor/topthink/think-trace/src/Html.php ( 4.42 KB )
  1. CONNECT:[ UseTime:0.000538s ] mysql:host=localhost;port=3306;dbname=appr_game;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `app_list` [ RunTime:0.000980s ]
  3. SELECT IFNULL(aw.weight, 9999) as weight, a.slug, d.native_name as name, a.id, cl.cate_name, c.appsslug as cate_slug, v.rating FROM `app_list` `a` INNER JOIN `app_detail` `d` ON `a`.`id`=`d`.`app_id` INNER JOIN `app_category` `c` ON `a`.`cate_id`=`c`.`id` INNER JOIN `app_cate_lang` `cl` ON `c`.`id`=`cl`.`cate_id` LEFT JOIN `app_votes` `v` ON `v`.`app_id`=`a`.`id` LEFT JOIN `app_weight` `aw` ON `aw`.`app_id`=a.id and aw.lang_id = 1 WHERE ( 1 = 1 and c.pid = 1 and d.review_id != 0 and a.site = 2 and cl.lang_id = 1 and d.lang_id = 1 and d.is_dmca = 0 and d.is_show = 1 ) ORDER BY `weight` ASC LIMIT 0,5 [ RunTime:0.074537s ]
  4. SHOW FULL COLUMNS FROM `app_category` [ RunTime:0.001122s ]
  5. SELECT c.id as cate_id,`cl`.`cate_name`,c.appsslug as cate_slug FROM `app_category` `c` INNER JOIN `app_cate_lang` `cl` ON `c`.`id`=`cl`.`cate_id` WHERE `c`.`pid` = '1' AND `cl`.`lang_id` = '1' ORDER BY `c`.`appsid` ASC [ RunTime:0.000671s ]
  6. SELECT a.cate_id, a.slug, IFNULL(aw.weight, 9999) as weight FROM `app_list` `a` INNER JOIN `app_detail` `d` ON `a`.`id`=`d`.`app_id` INNER JOIN `app_category` `c` ON `a`.`cate_id`=`c`.`id` INNER JOIN `app_cate_lang` `cl` ON `c`.`id`=`cl`.`cate_id` LEFT JOIN `app_weight` `aw` ON `aw`.`app_id`=a.id and aw.lang_id = 1 WHERE `a`.`cate_id` IN ('5','12','3','40','17','1','7','39','26','9','6','32','38','20','8','34','29') AND `c`.`pid` = '1' AND `d`.`review_id` <> '0' AND `a`.`site` = '2' AND `cl`.`lang_id` = '1' AND `d`.`lang_id` = '1' AND `d`.`is_dmca` = '0' AND `d`.`is_show` = '1' ORDER BY `weight` ASC [ RunTime:0.066421s ]
  7. SELECT `c`.`pid`,`c`.`similar`,`a`.`tag_id`,`a`.`price`,`d`.`video`,`a`.`ios_id`,`dv`.`dev_name`,`a`.`package_name`,`a`.`slug`,`a`.`cate_id`,`a`.`id`,`r`.`intro`,d.native_name as name,`v`.`rating`,v.votes as v,`v`.`percent`,`v`.`percent_1`,`v`.`percent_2`,`v`.`percent_3`,`v`.`percent_4`,`v`.`percent_5`,`cl`.`cate_name`,c.appsslug as cate_slug FROM `app_list` `a` INNER JOIN `app_detail` `d` ON `a`.`id`=`d`.`app_id` LEFT JOIN `app_review` `r` ON `d`.`review_id`=`r`.`id` LEFT JOIN `app_votes` `v` ON `v`.`app_id`=`a`.`id` INNER JOIN `app_category` `c` ON `c`.`id`=`a`.`cate_id` INNER JOIN `app_cate_lang` `cl` ON `cl`.`cate_id`=`c`.`id` LEFT JOIN `app_developer` `dv` ON `dv`.`id`=`a`.`dev_id` WHERE `c`.`pid` = '1' AND `d`.`review_id` <> '0' AND `cl`.`lang_id` = '1' AND `a`.`site` = '2' AND `a`.`slug` = 'com.bethsoft.ubu' AND `d`.`lang_id` = '1' AND `d`.`is_dmca` = '0' LIMIT 1 [ RunTime:0.002700s ]
  8. SHOW FULL COLUMNS FROM `app_versions` [ RunTime:0.001072s ]
  9. SELECT `name`,`version`,`filesize` FROM `app_versions` WHERE `app_id` = 17948 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001116s ]
  10. SELECT c.id as cate_id,`cl`.`cate_name`,c.appsslug as cate_slug FROM `app_category` `c` INNER JOIN `app_cate_lang` `cl` ON `c`.`id`=`cl`.`cate_id` WHERE `c`.`pid` = '1' AND `cl`.`lang_id` = '1' ORDER BY `c`.`appsid` ASC [ RunTime:0.000369s ]
  11. SELECT a.cate_id, a.slug, IFNULL(aw.weight, 9999) as weight FROM `app_list` `a` INNER JOIN `app_detail` `d` ON `a`.`id`=`d`.`app_id` INNER JOIN `app_category` `c` ON `a`.`cate_id`=`c`.`id` INNER JOIN `app_cate_lang` `cl` ON `c`.`id`=`cl`.`cate_id` LEFT JOIN `app_weight` `aw` ON `aw`.`app_id`=a.id and aw.lang_id = 1 WHERE `a`.`cate_id` IN ('5','12','3','40','17','1','7','39','26','9','6','32','38','20','8','34','29') AND `c`.`pid` = '1' AND `d`.`review_id` <> '0' AND `a`.`site` = '2' AND `cl`.`lang_id` = '1' AND `d`.`lang_id` = '1' AND `d`.`is_dmca` = '0' AND `d`.`is_show` = '1' ORDER BY `weight` ASC [ RunTime:0.061347s ]
  12. SELECT IFNULL(aw.weight, 9999) as weight, a.slug, d.native_name as name, a.id, cl.cate_name, c.appsslug as cate_slug, v.rating FROM `app_list` `a` INNER JOIN `app_detail` `d` ON `a`.`id`=`d`.`app_id` INNER JOIN `app_category` `c` ON `a`.`cate_id`=`c`.`id` INNER JOIN `app_cate_lang` `cl` ON `c`.`id`=`cl`.`cate_id` LEFT JOIN `app_votes` `v` ON `v`.`app_id`=`a`.`id` LEFT JOIN `app_weight` `aw` ON `aw`.`app_id`=a.id and aw.lang_id = 1 WHERE ( 1 = 1 and c.pid = 1 and d.review_id != 0 and a.site = 2 and cl.lang_id = 1 and d.lang_id = 1 and d.is_dmca = 0 and d.is_show = 1 ) ORDER BY `weight` ASC LIMIT 0,6 [ RunTime:0.070215s ]
  13. SELECT IFNULL(aw.weight, 9999) as weight, a.slug, d.native_name as name, a.id, v.rating FROM `app_list` `a` INNER JOIN `app_category` `c` ON `a`.`cate_id`=`c`.`id` INNER JOIN `app_cate_lang` `cl` ON `c`.`id`=`cl`.`cate_id` INNER JOIN `app_detail` `d` ON `a`.`id`=`d`.`app_id` LEFT JOIN `app_weight` `aw` ON `aw`.`app_id`=a.id and aw.lang_id = 1 LEFT JOIN `app_votes` `v` ON `v`.`app_id`=`a`.`id` WHERE `a`.`id` <> '17948' AND `c`.`id` = '5' AND `d`.`review_id` <> '0' AND `a`.`site` = '2' AND `cl`.`lang_id` = '1' AND `d`.`lang_id` = '1' AND `d`.`is_dmca` = '0' AND `d`.`is_show` = '1' ORDER BY `weight` ASC LIMIT 6 [ RunTime:0.045820s ]
  14. SELECT IFNULL(aw.weight, 9999) as weight, a.slug, d.native_name as name, a.id, cl.cate_name, c.appsslug as cate_slug, v.rating FROM `app_list` `a` INNER JOIN `app_detail` `d` ON `a`.`id`=`d`.`app_id` INNER JOIN `app_category` `c` ON `a`.`cate_id`=`c`.`id` INNER JOIN `app_cate_lang` `cl` ON `c`.`id`=`cl`.`cate_id` LEFT JOIN `app_votes` `v` ON `v`.`app_id`=`a`.`id` LEFT JOIN `app_weight` `aw` ON `aw`.`app_id`=a.id and aw.lang_id = 1 WHERE ( 1 = 1 and c.pid = 1 and d.review_id != 0 and a.site = 2 and cl.lang_id = 1 and d.lang_id = 1 and d.is_dmca = 0 and d.is_show = 1 ) ORDER BY `weight` ASC LIMIT 25,8 [ RunTime:0.058102s ]
  15. SELECT IFNULL(aw.weight, 9999) as weight, a.slug, d.native_name as name, a.id, cl.cate_name, c.appsslug as cate_slug, v.rating FROM `app_list` `a` INNER JOIN `app_detail` `d` ON `a`.`id`=`d`.`app_id` INNER JOIN `app_category` `c` ON `a`.`cate_id`=`c`.`id` INNER JOIN `app_cate_lang` `cl` ON `c`.`id`=`cl`.`cate_id` LEFT JOIN `app_votes` `v` ON `v`.`app_id`=`a`.`id` LEFT JOIN `app_weight` `aw` ON `aw`.`app_id`=a.id and aw.lang_id = 1 WHERE ( 1 = 1 and c.pid = 1 and d.review_id != 0 and a.site = 2 and cl.lang_id = 1 and d.lang_id = 1 and d.is_dmca = 0 and d.is_show = 1 ) ORDER BY `weight` ASC LIMIT 0,24 [ RunTime:0.058636s ]
  16. SELECT IFNULL(aw.weight, 9999) as weight, a.slug, d.native_name as name, a.id, cl.cate_name, v.rating FROM `app_list` `a` INNER JOIN `app_category` `c` ON `a`.`cate_id`=`c`.`id` INNER JOIN `app_cate_lang` `cl` ON `c`.`id`=`cl`.`cate_id` INNER JOIN `app_votes` `v` ON `a`.`id`=`v`.`app_id` INNER JOIN `app_detail` `d` ON `a`.`id`=`d`.`app_id` LEFT JOIN `app_weight` `aw` ON `aw`.`app_id`=a.id and aw.lang_id = 1 WHERE ( 1 = 1 and c.pid = 1 and d.review_id != 0 and a.site = 2 and cl.lang_id = 1 and d.lang_id = 1 and d.is_dmca = 0 and d.is_show = 1 ) ORDER BY a.id desc LIMIT 0,6 [ RunTime:0.087252s ]
  17. SELECT IFNULL(aw.weight, 9999) as weight, a.slug, d.native_name as name, a.id, cl.cate_name, v.rating FROM `app_list` `a` INNER JOIN `app_category` `c` ON `a`.`cate_id`=`c`.`id` INNER JOIN `app_cate_lang` `cl` ON `c`.`id`=`cl`.`cate_id` INNER JOIN `app_votes` `v` ON `a`.`id`=`v`.`app_id` INNER JOIN `app_detail` `d` ON `a`.`id`=`d`.`app_id` LEFT JOIN `app_weight` `aw` ON `aw`.`app_id`=a.id and aw.lang_id = 1 WHERE ( a.cate_id = 5 and c.pid = 1 and d.review_id != 0 and a.site = 2 and cl.lang_id = 1 and d.lang_id = 1 and d.is_dmca = 0 and d.is_show = 1 ) ORDER BY a.id desc LIMIT 0,12 [ RunTime:0.062266s ]
  18. SELECT c.id as cate_id,`cl`.`cate_name`,c.appsslug as cate_slug FROM `app_category` `c` INNER JOIN `app_cate_lang` `cl` ON `c`.`id`=`cl`.`cate_id` WHERE `c`.`pid` = '1' AND `cl`.`lang_id` = '1' ORDER BY `c`.`appsid` ASC [ RunTime:0.000532s ]
  19. SELECT a.cate_id, a.slug, IFNULL(aw.weight, 9999) as weight FROM `app_list` `a` INNER JOIN `app_detail` `d` ON `a`.`id`=`d`.`app_id` INNER JOIN `app_category` `c` ON `a`.`cate_id`=`c`.`id` INNER JOIN `app_cate_lang` `cl` ON `c`.`id`=`cl`.`cate_id` LEFT JOIN `app_weight` `aw` ON `aw`.`app_id`=a.id and aw.lang_id = 1 WHERE `a`.`cate_id` IN ('5','12','3','40','17','1','7','39','26','9','6','32','38','20','8','34','29') AND `c`.`pid` = '1' AND `d`.`review_id` <> '0' AND `a`.`site` = '2' AND `cl`.`lang_id` = '1' AND `d`.`lang_id` = '1' AND `d`.`is_dmca` = '0' AND `d`.`is_show` = '1' ORDER BY `weight` ASC [ RunTime:0.050894s ]
0.684323s