Sniper 3D Assassin

Action
Rating
Version 4.39.0
Size 205.42 MB
Go Download
Advertisement
Advertisement

Editor's Review

Ready for a free action-packed multiplayer FPS game? Sniper 3D is a fun free online multiplayer FPS game – fight in a multiplayer war and become the best sniper assassin in this fun free multiplayer shooting game. With free online and offline game modes, you can have fun and play anywhere, anytime.

Fast-paced multiplayer assassin game.

Supports free online and offline play.

Unlock fun upgrades and build the best guns.

KEY FEATURES:

- Ultra-realistic 3D graphics

- Intuitive game controls

- Build the best weapons; unlock guns and fun upgrades for ammo and grip

- Play with sniper assassins around the world

- Get tactical with fun free missions in offline mode or go online for all-out multiplayer war!

- Save hostages and become the army’s top sniper assassin

Play this game for fun-to-master controls and countless exciting free missions. Sniper 3D is a fun action-packed multiplayer FPS game that offers players versatile play modes for endless hours of free multiplayer fun. Download the Sniper 3D FPS assassin game for free to engage in online FPS multiplayer warfare. Enjoy the ultimate fun experience now with this free online multiplayer FPS assassin game.

Information

Platform: Android /IOS
Version: 4.39.0
Category: Action
Price: Free
Size: 205.42 MB
Developer:Fun Games For Free

Download

Ratings

4.8
Total 1,509
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 16:33:03 HTTP/1.1 GET : https://game.appurse.com/com.fungames.sniper3d.html
  2. 运行时间 : 0.573712s [ 吞吐率:1.74req/s ] 内存消耗:4,424.44kb 文件加载: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.000394s ] mysql:host=localhost;port=3306;dbname=appr_game;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `app_list` [ RunTime:0.001192s ]
  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.058348s ]
  4. SHOW FULL COLUMNS FROM `app_category` [ RunTime:0.001066s ]
  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.000420s ]
  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.051060s ]
  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.fungames.sniper3d' AND `d`.`lang_id` = '1' AND `d`.`is_dmca` = '0' LIMIT 1 [ RunTime:0.001779s ]
  8. SHOW FULL COLUMNS FROM `app_versions` [ RunTime:0.001009s ]
  9. SELECT `name`,`version`,`filesize` FROM `app_versions` WHERE `app_id` = 198 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001020s ]
  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.000360s ]
  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.051961s ]
  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.059135s ]
  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` <> '198' 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.045825s ]
  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.057721s ]
  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.060179s ]
  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.056950s ]
  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.042537s ]
  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.000613s ]
  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.051969s ]
0.574806s