Mr Bullet

Puzzle
Rating
Version 3.2
Size 27.97 MB
Go Download
Advertisement
Advertisement

Editor's Review

Are you ready to become a hero, spy, and legend? Solve puzzling challenges, show off your deadly accuracy and take aim at the enemies. Come experience the shooting phenomenon.

Use your brain in this unique puzzle game. You will need precise aim and laser focus to take down enemies, ninjas, and many other bad guys you will encounter in the world! Travel to new lands, save hostages, and use unique weapons like grenade launchers to combat your foes. Start your adventure now! The one thing you have to ask yourself is: can you do it in one shot?

Game Features:

1. Destroy them all and save the world!

Mister Bullet is on a secret mission. Use your deadly accuracy and precision to keep the bad guys! Whether it is a spy, agent, zombie, lumberjack, alien they are all here to take over the world and only a MASTER can take them down and save the world.

2. Unlock Epic Missions

So many enemies and levels for you to take down, each with their own unique twist! How smart are you? Can you solve all the puzzles? Shoot bullets that ricochet, bounce, or simply go in a straight line! Use your bullets to make objects fall and explode. Create chain reactions and do whatever it takes to get your target!

3. New Challenges Await

Rescue hostages, throw grenades at people and go on secret missions. No matter the situation, just remember to make every shot count!

4. Engaging Physics Puzzler

Only the smartest and quickest can solve all the puzzles! You will need more than just accuracy to make it through. Speed, timing and patience are all things you will need to become the zennest shooting master. Can you get three stars on every level?

5. Spy vs Spy

Are you the best and most accurate? Battle against other spies in crazy PVP multiplayer scenarios.

6. New Features Weekly

Mr Bullet is constantly updating with new unique levels, weapons and other skins. You will NOT want to miss out on the action.

Whether you're a shooter or a puzzler, Mr. Bullet is a challenge ready for you. This is the best physics shooter game there is. Never miss a dull moment with this easy to learn and easy to play game that is almost IMPOSSIBLE to master. Battle notorious villains. Become a legend agent. Start your mission and never stop shooting! Bullseye!

Visit https://lionstudios.cc/contact-us/ if have any feedback, need help on beating a level or have any awesome ideas you would like to see in the game!

From the Studio that brought you Happy Glass, Flip Trickster, and Love Balls!

Follow us to get news and updates on Mr Bullet and our other Award Winning titles;

https://lionstudios.cc/

https://reddit.com/r/mrbullet

Facebook.com/MrBulletGame

Instagram.com/LionStudioscc

Twitter.com/LionStudiosCC

Youtube.com/c/LionStudiosCC

Information

Platform: Android /IOS
Version: 3.2
Category: Puzzle
Price: Free
Size: 27.97 MB
Developer:Lion Studios

Download

Ratings

4.8
Total 1,929
5
4
3
2
1
Click Stars To Rate :

Similar Games

Popular Games

You may also like

net.peakgames.match

Match Factory!

4.6
Puzzle
Details
com.fc.goods.sort.matching.puzzle.triplemaster

Goods Puzzle

4.6
Puzzle
Details
com.dreamgames.royalkingdom

Royal Kingdom

4.6
Puzzle
Details
com.color.busfrenzy

Bus Frenzy

4.6
Puzzle
Details
com.abi.perfect.tidy

Perfect Tidy

4.6
Puzzle
Details
com.GybeGames.ColorBlockJam
Details
com.crescivegames.twistedtangle

Twisted Tangle

4.6
Puzzle
Details
com.spaceapegames.carsuperstar
Details
com.bluebraingames.thehouseofdavinci
Details
jigsaw.puzzle.game.banana

Jigsawscapes

4.6
Puzzle
Details
com.atreus.ballsnropes

Balls'n Ropes

4.6
Puzzle
Details
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-06-08 17:51:24 HTTP/1.1 GET : https://game.appurse.com/com.lionstudios.mrbullet.html
  2. 运行时间 : 0.901812s [ 吞吐率:1.11req/s ] 内存消耗:4,429.94kb 文件加载: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.000283s ] mysql:host=localhost;port=3306;dbname=appr_game;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `app_list` [ RunTime:0.000926s ]
  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.426894s ]
  4. SHOW FULL COLUMNS FROM `app_category` [ RunTime:0.000882s ]
  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.000431s ]
  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.048284s ]
  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.lionstudios.mrbullet' AND `d`.`lang_id` = '1' AND `d`.`is_dmca` = '0' LIMIT 1 [ RunTime:0.002153s ]
  8. SHOW FULL COLUMNS FROM `app_versions` [ RunTime:0.000947s ]
  9. SELECT `name`,`version`,`filesize` FROM `app_versions` WHERE `app_id` = 4369 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001510s ]
  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.000349s ]
  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.047430s ]
  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.054036s ]
  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` <> '4369' AND `c`.`id` = '7' 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.041105s ]
  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.053542s ]
  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.052791s ]
  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.052771s ]
  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 = 7 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.039031s ]
  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.000495s ]
  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.049882s ]
0.902744s