1v1.LOL

Action
Rating
Version 4.680
Size 365.12 MB
Go Download
Advertisement
Advertisement

Editor's Review

Be the last man standing in this epic multiplayer building and shooting game!

Fight to survive in this epic multiplayer building and shooting game where only the last player standing wins and achieves the great and coveted victory.

Free 3D Battle Royale, with more than 10M downloads and 750k daily active users waiting for you to fight 1v1.

What can you find in this multiplayer free online shooting game?

Quick pairing:

Find a 1v1 or 2v2 or a 16 player Battle Royale match against random players in 3 seconds, with real players 24 hours a day!

Custom HUD:

Advanced control editors where you can organize your screen buttons however you like, with layouts and Setups Builder Pro, Old School and LOL Style easy controls with shooting assistant and self-trigger.

Multiplayer Gun Game Modes:

  • 1v1: Unique multiplayer mode, where you get to play against other opponent fighting with the same weapons (Assault Rifle, shotgun, axe or sniper rifle)
  • 2v2: Multiplayer 4 player shooter game mode, where you play in pairs versus other opponents
  • Battle Royale: Join a squad and play with your friends to defeat other assassin guilds and become the last survivor
  • Battle Royale Duos: Play with a friend against other teams and try to be the last pair left standing.
  • Custom Gun Games with friends: Recruit friends and play with them online in a multiplayer mode (1v1 arena, mini box, vikings death match, gulag and more)

Practice modes:

  • Free Build: Train your building skills with endless materials
  • Zombies: Intense action shooting game mode where you have to run, hide, shoot and kill the zombies
  • 3D AIM Trainer: Improve your gun shooting skills and become the best sniper shooter

Shooting Weapons:

  • Assault Rifle: Get ready for a gun game and take down killers with your assault rifle
  • Shotgun: Grab your pixel gun, start shooting and kill the enemies
  • Axe: Use fighting strategies and kill your opponent with an axe
  • Sniper rifle: Choose your sniper rifle and shoot!

Free Gun Game:

This app is designed for all audiences and is completely free, it does not require payments or a battle pass to play without limits unlike other Battle Royale Gun Games.

1. No need to register, just download the app and start playing your pvp shooter simulator!

2. Create the character´s name that will bring your virtual avatar to life in this Battle Royale, and start your first online gun game in practice mode. It's time to rehearse your shooting and building skills!

3. You are now ready to play a battle royale to death in a multiplayer gun game with real players.

1v1 has versions intended for different ages. You will be directed to the version intended for your age, depending on the jurisdiction in which you are located. 1v1 does not require payment to download and play, but it also allows you to purchase virtual items with real money inside the game. You can disable in-app purchases in your device’s settings. 1v1 may also contain advertising. You may require an internet connection to play 1v1 and access its social features. You can also find more information about the functionality, compatibility and interoperability of 1v1 in the above description and additional app store information.

By downloading this game, you agree to future game updates as released on your app store or social network. You may choose to update this game, but if you do not update, your game experience and functionalities may be reduced.

Information

Platform: Android
Version: 4.680
Category: Action
Price: Free
Size: 365.12 MB
Developer:JustPlay.LOL

Download

Ratings

4.9
Total 1,635
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-07 03:06:39 HTTP/1.1 GET : https://game.appurse.com/lol.onevone.html
  2. 运行时间 : 1.380803s [ 吞吐率:0.72req/s ] 内存消耗:4,426.34kb 文件加载: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.000801s ] mysql:host=localhost;port=3306;dbname=appr_game;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `app_list` [ RunTime:0.000889s ]
  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.485745s ]
  4. SHOW FULL COLUMNS FROM `app_category` [ RunTime:0.001296s ]
  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.054477s ]
  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` = 'lol.onevone' AND `d`.`lang_id` = '1' AND `d`.`is_dmca` = '0' LIMIT 1 [ RunTime:0.002565s ]
  8. SHOW FULL COLUMNS FROM `app_versions` [ RunTime:0.000704s ]
  9. SELECT `name`,`version`,`filesize` FROM `app_versions` WHERE `app_id` = 19365 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001379s ]
  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.000350s ]
  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.049119s ]
  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.058290s ]
  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` <> '19365' 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.064516s ]
  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.419139s ]
  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.061018s ]
  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.056711s ]
  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.042212s ]
  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.000665s ]
  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.049525s ]
1.381714s